article Replicate - MySQL source defect and fix (2022.5 & 2022.11) in Official Support Articles

Replicate - MySQL source defect and fix (2022.5 & 2022.11)

john_wang — Sat, 13 Apr 2024 08:03:40 GMT

Replicate reported errors during resume task if source MySQL running on Windows (while MySQL running on Linux then no problem)

[SOURCE_CAPTURE ]I: Stream positioning at context '$.000034:3506:-1:3506:0'
[SOURCE_CAPTURE ]T: Read next binary log event failed; mariadb_rpl_fetch error 1236 (Could not find first log file name in binary log index file)

Replicate reported errors at MySQL source endpoints sometimes (does not matter what's the MySQL source platforms):

[SOURCE_CAPTURE ]W: The given Source Change Position points inside a transaction. Replicate will ignore this transaction and will capture events from the next BEGIN or DDL events.

Environment:

Replicate 2022.5 PR4 (2022.5.0.815)
Replicate 2022.11 PR1 (2022.11.0.289)
MySQL source database , any version

Fix Version & Resolution:

Upgrade to Replicate 2022.11 PR2 (2022.11.0.394, released already) or higher, or Replicate 2022.5 PR5 (coming soon)

Workaround:

If you are running 2022.5 PR3 (or lower), then keep run it, or upgrade to PR5 (or higher) .

No workaround for 2022.11 (GA, or PR01) .

Cause & Internal Investigation ID(s):

Jira: RECOB-6526 , Description: It would not be possible to resume a task if MySQL Server was on Windows

Jira: RECOB-6499 , Description: Resuming a task from a CTI event, would sometimes result in missing events or/and a redundant warning message

Re: Replicate - MySQL source defect and fix (2022.5 & 2022.11)

brunnovb_in — Thu, 02 Feb 2023 17:41:46 GMT

Hello,

Where/when will 2022.11 PR2 be available?

I couldn't see this version under Product Downloads in the Qlik portal.

Tks,

Brunno.

Re: Replicate - MySQL source defect and fix (2022.5 & 2022.11)

SwathiPulagam — Thu, 02 Feb 2023 17:44:09 GMT

Hi @brunnovb_in ,

Below is the file cloud link for 2022.11 SP02 installation files:

https://files.qlik.com/url/2emizytniwidttvd

Thanks,

Swathi

Re: Replicate - MySQL source defect and fix (2022.5 & 2022.11)

narendersarva — Thu, 02 Feb 2023 17:58:24 GMT

Hello @brunnovb_in,

You can also check download links under this link

https://community.qlik.com/t5/Product-Downloads/tkb-p/Downloads?_ga=2.246948996.1424938220.1646659183-355499787.1646318726

Thanks,
Naren

Re: Replicate - MySQL source defect and fix (2022.5 & 2022.11)

AlexOmetis — Thu, 02 Feb 2023 18:07:08 GMT

@narendersarva except for some reason not all releases of the QDI products are added there, they seem to be made available ad-hoc to customers on request via the files link. I've found this weird for years - not sure why it's done so differently from Qlik Sense etc and causes confusion over what the latest release is.

Re: Replicate - MySQL source defect and fix (2022.5 & 2022.11)

narendersarva — Thu, 02 Feb 2023 18:15:07 GMT

Hi @AlexOmetis,

I am able to download the latest version from the link I shared below.

Please make sure to filter the products correctly.

Thanks
Naren

Re: Replicate - MySQL source defect and fix (2022.5 & 2022.11)

brunnovb_in — Thu, 02 Feb 2023 18:18:45 GMT

Hello @narendersarva,

This one we can see, but I'd like to get this one: 2022.11.0.394. It was possible through Swathi Pulagam post (link).

Thanks,

Brunno.

Re: Replicate - MySQL source defect and fix (2022.5 & 2022.11)

AlexOmetis — Thu, 02 Feb 2023 18:23:55 GMT

@narendersarva - as @brunnovb_in showed, it only shows the Initial Release, to get PR02 you have to go to the individual files link that @SwathiPulagam sent... and if you needed PR01 for some reason, you'd have to ask for a different link...

Re: Replicate - MySQL source defect and fix (2022.5 & 2022.11)

narendersarva — Thu, 02 Feb 2023 18:30:27 GMT

Hi @AlexOmetis, @brunnovb_in

Looks like in the Release Assets section for some reason Latest Release and Patch is not updating to the latest available patch. I will reach out to our internal teams and see if they can fix it.

Thanks
Naren

Re: Replicate - MySQL source defect and fix (2022.5 & 2022.11)

AlexOmetis — Fri, 03 Feb 2023 09:21:31 GMT

@narendersarva I imagine it's because it's not been uploaded to the central Qlik download site on GitHub - I assume the downloads app automatically generates its content from there: Releases · qlik-download/replicate · GitHub.

Re: Replicate - MySQL source defect and fix (2022.5 & 2022.11)

Dana_Baldwin — Fri, 03 Feb 2023 15:50:38 GMT

The public downloads page only includes GA (initial release) and service release versions. Service packs, which occur between service releases, are only available by opening a support case and requesting a download link.

article Replicate - MySQL source defect and fix (2022.5 & 2022.11) in Official Support Articles

Replicate - MySQL source defect and fix (2022.5 & 2022.11)

Environment:

Fix Version & Resolution:

Workaround:

Cause & Internal Investigation ID(s):

Related Content:

Re: Replicate - MySQL source defect and fix (2022.5 & 2022.11)

Re: Replicate - MySQL source defect and fix (2022.5 & 2022.11)

Re: Replicate - MySQL source defect and fix (2022.5 & 2022.11)

Re: Replicate - MySQL source defect and fix (2022.5 & 2022.11)

Re: Replicate - MySQL source defect and fix (2022.5 & 2022.11)

Re: Replicate - MySQL source defect and fix (2022.5 & 2022.11)

Re: Replicate - MySQL source defect and fix (2022.5 & 2022.11)

Re: Replicate - MySQL source defect and fix (2022.5 & 2022.11)

Re: Replicate - MySQL source defect and fix (2022.5 & 2022.11)

Re: Replicate - MySQL source defect and fix (2022.5 & 2022.11)