search

jakemctigue / tungsten-replicator

Automatically exported from code.google.com/p/tungsten-replicator
0 stars 0 forks source link

Tungsten Replicator fails to extract from MySQL 5.5 binlog if clients use utf8mb4 character set #37

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
Binlog extraction fails on MySQL 5.5.11 due to presences of utf8mb4 character 
set, which was added in version 5.5.3.  The problem is that Tungsten does not 
list this name as a synonym for UTF-8 in the MySQL extractor.  

To duplicate: 

1.) Set up a Tungsten manager against MySQL version 5.5.11 (earlier versions 
after 5.5.3 should work).  

2.) Enter the following client data in mysql: 

set names utf8mb4;
set session binlog_format=statement;
create database foo;

3.) The replicator will go offline with the following error in the log: 

INFO   | jvm 1    | 2011/04/25 18:00:38 | 2011-04-25 18:00:38,182 ERROR 
replicator.management.OpenReplicatorManager Received error notification, 
shutting down services: Event extraction failed: Unexpected failure while 
extracting event mysql-bin.000006 (534)
INFO   | jvm 1    | 2011/04/25 18:00:38 | 
com.continuent.tungsten.replicator.extractor.ExtractorException: Unexpected 
failure while extracting event mysql-bin.000006 (534)INFO   | jvm 1    | 
2011/04/25 18:00:38 |   at 
com.continuent.tungsten.replicator.extractor.mysql.MySQLExtractor.extractEvent(M
ySQLExtractor.java:1138)INFO   | jvm 1    | 2011/04/25 18:00:38 |   at 
com.continuent.tungsten.replicator.extractor.mysql.MySQLExtractor.extract(MySQLE
xtractor.java:1158)INFO   | jvm 1    | 2011/04/25 18:00:38 |   at 
com.continuent.tungsten.replicator.extractor.ExtractorWrapper.extract(ExtractorW
rapper.java:95)INFO   | jvm 1    | 2011/04/25 18:00:38 |   at 
com.continuent.tungsten.replicator.extractor.ExtractorWrapper.extract(ExtractorW
rapper.java:1)INFO   | jvm 1    | 2011/04/25 18:00:38 |   at 
com.continuent.tungsten.replicator.pipeline.SingleThreadStageTask.runTask(Single
ThreadStageTask.java:217)INFO   | jvm 1    | 2011/04/25 18:00:38 |   at 
com.continuent.tungsten.replicator.pipeline.SingleThreadStageTask.run(SingleThre
adStageTask.java:148)INFO   | jvm 1    | 2011/04/25 18:00:38 |   at 
java.lang.Thread.run(Thread.java:636)
INFO   | jvm 1    | 2011/04/25 18:00:38 | Caused by: 
java.io.UnsupportedEncodingException:INFO   | jvm 1    | 2011/04/25 18:00:38 |  
 at java.lang.StringCoding.decode(StringCoding.java:188)INFO   | jvm 1    | 
2011/04/25 18:00:38 |   at java.lang.String.<init>(String.java:451)

Original issue reported on code.google.com by berkeley...@gmail.com on 26 Apr 2011 at 1:19