Tungsten 3.0.0. build 524 compatibility issue MySQL 5.7.0

[Tony Liu]

Hi,

Is there a compatibility issue between Tungsten 3.0.0. build 524\ and  MySQL 5.7?

INFO   | jvm 1    | 2019/08/02 04:26:27 | 2019-08-02 04:26:27,895 [master - binlog-to-q-0] INFO  pipeline.SingleThreadStageTask Last successfully processed event prior to termination: seqno=0 eventid=mysql-bin.003381:0000000000000270;1851297
INFO   | jvm 1    | 2019/08/02 04:26:27 | 2019-08-02 04:26:27,895 [master - binlog-to-q-0] INFO  pipeline.SingleThreadStageTask Task event count: 1
INFO   | jvm 1    | 2019/08/02 04:26:27 | 2019-08-02 04:26:27,896 [master - pool-2-thread-1] ERROR management.OpenReplicatorManager Received error notification, shutting down services :
INFO   | jvm 1    | 2019/08/02 04:26:27 | Event extraction failed
INFO   | jvm 1    | 2019/08/02 04:26:27 | com.continuent.tungsten.replicator.extractor.ExtractorException: Unexpected failure while extracting event mysql-bin.003381 (468)
INFO   | jvm 1    | 2019/08/02 04:26:27 |       at com.continuent.tungsten.replicator.extractor.mysql.MySQLExtractor.extractEvent(MySQLExtractor.java:1162)
INFO   | jvm 1    | 2019/08/02 04:26:27 |       at com.continuent.tungsten.replicator.extractor.mysql.MySQLExtractor.extract(MySQLExtractor.java:1267)
INFO   | jvm 1    | 2019/08/02 04:26:27 |       at com.continuent.tungsten.replicator.extractor.ExtractorWrapper.extract(ExtractorWrapper.java:99)
INFO   | jvm 1    | 2019/08/02 04:26:27 |       at com.continuent.tungsten.replicator.extractor.ExtractorWrapper.extract(ExtractorWrapper.java:58)
INFO   | jvm 1    | 2019/08/02 04:26:27 |       at com.continuent.tungsten.replicator.pipeline.SingleThreadStageTask.runTask(SingleThreadStageTask.java:252)
INFO   | jvm 1    | 2019/08/02 04:26:27 |       at com.continuent.tungsten.replicator.pipeline.SingleThreadStageTask.run(SingleThreadStageTask.java:179)
INFO   | jvm 1    | 2019/08/02 04:26:27 |       at java.lang.Thread.run(Thread.java:748)
INFO   | jvm 1    | 2019/08/02 04:26:27 | Caused by: java.lang.ArrayIndexOutOfBoundsException: 112
INFO   | jvm 1    | 2019/08/02 04:26:27 |       at com.continuent.tungsten.replicator.extractor.mysql.conversion.LittleEndianConversion.convertSignedNBytesToLong(LittleEndianConversion.java:95)
INFO   | jvm 1    | 2019/08/02 04:26:27 |       at com.continuent.tungsten.replicator.extractor.mysql.RowsLogEvent.extractValue(RowsLogEvent.java:432)
INFO   | jvm 1    | 2019/08/02 04:26:27 |       at com.continuent.tungsten.replicator.extractor.mysql.RowsLogEvent.processExtractedEventRow(RowsLogEvent.java:1254)
INFO   | jvm 1    | 2019/08/02 04:26:27 |       at com.continuent.tungsten.replicator.extractor.mysql.UpdateRowsLogEvent.processExtractedEvent(UpdateRowsLogEvent.java:113)
INFO   | jvm 1    | 2019/08/02 04:26:27 |       at com.continuent.tungsten.replicator.extractor.mysql.MySQLExtractor.extractEvent(MySQLExtractor.java:924)
INFO   | jvm 1    | 2019/08/02 04:26:27 |       ... 6 more
INFO   | jvm 1    | 2019/08/02 04:26:27 | 2019-08-02 04:26:27,897 [master - pool-2-thread-1] INFO  management.OpenReplicatorManager No auto-recovery as max retry attempts have been exceeded
INFO   | jvm 1    | 2019/08/02 04:26:27 | 2019-08-02 04:26:27,897 [master - pool-2-thread-1] WARN  management.OpenReplicatorManager Performing emergency service shutdown
INFO   | jvm 1    | 2019/08/02 04:26:27 | 2019-08-02 04:26:27,897 [master - pool-2-thread-1] INFO  pipeline.Pipeline Shutting down pipeline: master

[Tony Liu]

That error ever happened when we were trying to upgrade MySQL from 5.5 to 5.7, so I am asking any known compatibility issue between Tungsten 3.0.0. and MySQL 5.7, thhanks.

[Chris Parker]

Hi Tony,

v3 of the Replicator is extremely old and is officially EOL (End of Life)

Full support for MySQL5.7 was included in v5.3

Full support for MySQL 8 was added into v5.4 and v6.1 that was recently release

Thanks

Chris

[Tony Liu]

Hi Chris,

Thanks for your reply, before upgrade tungsten, I have concerns:

• Is it really related to tungsten compatibility issue with MySQL 57? 
• If it's it's compatibility issue, do we have ticket get it fixed in newer version?

I appreciate if you can provide more context on my concerns.

Thanks.

--
You received this message because you are subscribed to a topic in the Google Groups "Tungsten Replicator Discuss" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/tungsten-replicator-discuss/rOGGUuro9hU/unsubscribe.
To unsubscribe from this group and all its topics, send an email to tungsten-replicator...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/tungsten-replicator-discuss/d0090b94-0a41-4db4-8426-1d65f60499f5%40googlegroups.com.

[Chris Parker]

Hi Tony,

Given the age of v3 I’m unable to verify - We just don’t support that release anymore.  MySQL 5.7 was only certified and tested from v5.3

As for upgrading etc you will need to have an active subscription and license to use the product and to access the supported release.

The only thing I can suggest atm is to contact sa...@continuent.com to resolve this

Thanks

Chris

Chris Parker
Director, Professional Services EMEA & APAC
Continuent Ltd., a Delaware Corporation
https://www.continuent.com

chris....@continuent.com

You received this message because you are subscribed to the Google Groups "Tungsten Replicator Discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to tungsten-replicator...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/tungsten-replicator-discuss/CACCKuyQC_PkkHUm7AqR%3D-gAcTWJXzqiJNOWX-sqLkyHo4e8ASQ%40mail.gmail.com.

[Tony Liu]

https://pubs.vmware.com/continuent/tungsten-replicator-3.0/prerequisite-mysql.html said Tungsten v3  is compatible with MySQL 5.7. 

so I don't ensure it is a compatibility issue. 

On Tuesday, August 6, 2019 at 11:04:17 AM UTC-7, Chris Parker wrote:

Hi Tony,

Given the age of v3 I’m unable to verify - We just don’t support that release anymore.  MySQL 5.7 was only certified and tested from v5.3

As for upgrading etc you will need to have an active subscription and license to use the product and to access the supported release.

The only thing I can suggest atm is to contact sa...@continuent.com to resolve this

Thanks

Chris

Chris Parker
Director, Professional Services EMEA & APAC
Continuent Ltd., a Delaware Corporation
https://www.continuent.com

chris...@continuent.com

On 6 Aug 2019, 18:59 +0100, 'Tony Liu' via Tungsten Replicator Discuss <tungsten-repl...@googlegroups.com>, wrote:

Hi Chris,

Thanks for your reply, before upgrade tungsten, I have concerns:

• Is it really related to tungsten compatibility issue with MySQL 57? 
• If it's it's compatibility issue, do we have ticket get it fixed in newer version?

I appreciate if you can provide more context on my concerns.

Thanks.

To unsubscribe from this group and all its topics, send an email to tungsten-replicator-discuss+unsub...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/tungsten-replicator-discuss/d0090b94-0a41-4db4-8426-1d65f60499f5%40googlegroups.com.

--
You received this message because you are subscribed to the Google Groups "Tungsten Replicator Discuss" group.

To unsubscribe from this group and stop receiving emails from it, send an email to tungsten-replicator-discuss+unsub...@googlegroups.com.

[金炯杰]

我不需要了，谢谢

--------------原始邮件--------------
发件人："'Tony Liu' via Tungsten Replicator Discuss "<tungsten-repl...@googlegroups.com>;
发送时间：2019年8月7日(星期三) 中午12:42
收件人："Tungsten Replicator Discuss" <tungsten-repl...@googlegroups.com>;
主题：Re: [tungsten-replicator-discuss] Re: Tungsten 3.0.0. build 524 compatibility issue MySQL 5.7.0
-----------------------------------

To unsubscribe from this group and stop receiving emails from it, send an email to tungsten-replicator...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/tungsten-replicator-discuss/b855a5b9-e820-47e7-9196-4d682b47e230%40googlegroups.com.

[Chris Parker]

Tony

I can assure you, v3 is NOT compatible with 5.7. Development on v3 stopped long before MySQL 5.7 even existed

Those docs are old and inaccurate. Continuent are no longer associated with VMware

All up to date and maintained docs for the product are at docs.continuent.com

Chris Parker
Director, Professional Services EMEA & APAC
Continuent Ltd., a Delaware Corporation
https://www.continuent.com

chris....@continuent.com
+44 7790 685 269

To unsubscribe from this group and stop receiving emails from it, send an email to tungsten-replicator...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/tungsten-replicator-discuss/b855a5b9-e820-47e7-9196-4d682b47e230%40googlegroups.com.

[Chris Parker]

See table 1.1 on this page

http://docs.continuent.com/tungsten-replicator-6.1/introduction.html#table_extractor-matrix

Chris Parker
Director, Professional Services EMEA & APAC
Continuent Ltd., a Delaware Corporation
https://www.continuent.com

chris....@continuent.com
+44 7790 685 269

To unsubscribe from this group and stop receiving emails from it, send an email to tungsten-replicator...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/tungsten-replicator-discuss/b855a5b9-e820-47e7-9196-4d682b47e230%40googlegroups.com.