|
I'm getting community 1.3 rc2 setup on a new server. The master replicator process started collecting data but stopped with this error. In order to get the replicator to launch we had to force it to run through the 64 bit wrapper on this host, so I figure that could be related. Also, we're seeing some Integer WARN messages detailed in a separate ticket of mine. Have any suggestions for a fix?
System:
Red Hat Enterprise Linux Server release 5.4 (Tikanga)
Linux 2.6.18-164.2.1.el5 #1 SMP Mon Sep 21 04:37:42 EDT 2009 x86_64 x86_64 x86_64 GNU/Linux
java version "1.6.0_20"
Java(TM) SE Runtime Environment (build 1.6.0_20-b02)
Java HotSpot(TM) Server VM (build 16.3-b01, mixed mode)
Replicator log detail:
----------------------------------
INFO | jvm 1 | 2010/06/03 13:50:53 | com.continuent.tungsten.replicator.extractor.mysql.MySQLExtractException: bad date format for date value: 1029315 String: 2010-6-3
INFO | jvm 1 | 2010/06/03 13:50:53 | at com.continuent.tungsten.replicator.extractor.mysql.RowsLogEvent.extractValue(Row
sLogEvent.java:657)
INFO | jvm 1 | 2010/06/03 13:50:53 | at com.continuent.tungsten.replicator.extractor.mysql.RowsLogEvent.processExtracted
EventRow(RowsLogEvent.java:891)
INFO | jvm 1 | 2010/06/03 13:50:53 | at com.continuent.tungsten.replicator.extractor.mysql.WriteRowsLogEvent.processExtr
actedEvent(WriteRowsLogEvent.java:73)
INFO | jvm 1 | 2010/06/03 13:50:53 | at com.continuent.tungsten.replicator.extractor.mysql.MySQLExtractor.extractEvent(M
ySQLExtractor.java:762)
INFO | jvm 1 | 2010/06/03 13:50:53 | at com.continuent.tungsten.replicator.extractor.mysql.MySQLExtractor.extract(MySQLE
xtractor.java:966)
INFO | jvm 1 | 2010/06/03 13:50:53 | at com.continuent.tungsten.replicator.extractor.ExtractorWrapper.extract(ExtractorW
rapper.java:91)
INFO | jvm 1 | 2010/06/03 13:50:53 | at com.continuent.tungsten.replicator.pipeline.SingleThreadStageTask.runTask(Single
ThreadStageTask.java:177)
INFO | jvm 1 | 2010/06/03 13:50:53 | at com.continuent.tungsten.replicator.pipeline.SingleThreadStageTask.run(SingleThre
adStageTask.java:122)
INFO | jvm 1 | 2010/06/03 13:50:53 | at java.lang.Thread.run(Thread.java:619)
INFO | jvm 1 | 2010/06/03 13:50:53 | Caused by: java.lang.IllegalArgumentException
INFO | jvm 1 | 2010/06/03 13:50:53 | at java.sql.Date.valueOf(Date.java:138)
INFO | jvm 1 | 2010/06/03 13:50:53 | at com.continuent.tungsten.replicator.extractor.mysql.RowsLogEvent.extractValue(Row
sLogEvent.java:650)
INFO | jvm 1 | 2010/06/03 13:50:53 | ... 8 more
INFO | jvm 1 | 2010/06/03 13:50:53 | 2010-06-03 13:50:53,004 ERROR extractor.mysql.MySQLExtractor Failed to extract from binlog.000420 (145327)
INFO | jvm 1 | 2010/06/03 13:50:53 | com.continuent.tungsten.replicator.extractor.mysql.MySQLExtractException: bad date format for date value: 1029315 String: 2010-6-3
INFO | jvm 1 | 2010/06/03 13:50:53 | at com.continuent.tungsten.replicator.extractor.mysql.RowsLogEvent.extractValue(Row
sLogEvent.java:657)
INFO | jvm 1 | 2010/06/03 13:50:53 | at com.continuent.tungsten.replicator.extractor.mysql.RowsLogEvent.processExtracted
EventRow(RowsLogEvent.java:891)
INFO | jvm 1 | 2010/06/03 13:50:53 | at com.continuent.tungsten.replicator.extractor.mysql.WriteRowsLogEvent.processExtr
actedEvent(WriteRowsLogEvent.java:73)
INFO | jvm 1 | 2010/06/03 13:50:53 | at com.continuent.tungsten.replicator.extractor.mysql.MySQLExtractor.extractEvent(M
ySQLExtractor.java:762)
INFO | jvm 1 | 2010/06/03 13:50:53 | at com.continuent.tungsten.replicator.extractor.mysql.MySQLExtractor.extract(MySQLE
xtractor.java:966)
INFO | jvm 1 | 2010/06/03 13:50:53 | at com.continuent.tungsten.replicator.extractor.ExtractorWrapper.extract(ExtractorW
rapper.java:91)
INFO | jvm 1 | 2010/06/03 13:50:53 | at com.continuent.tungsten.replicator.pipeline.SingleThreadStageTask.runTask(Single
ThreadStageTask.java:177)
INFO | jvm 1 | 2010/06/03 13:50:53 | at com.continuent.tungsten.replicator.pipeline.SingleThreadStageTask.run(SingleThre
adStageTask.java:122)
INFO | jvm 1 | 2010/06/03 13:50:53 | at java.lang.Thread.run(Thread.java:619)
INFO | jvm 1 | 2010/06/03 13:50:53 | Caused by: java.lang.IllegalArgumentException
INFO | jvm 1 | 2010/06/03 13:50:53 | at java.sql.Date.valueOf(Date.java:138)
INFO | jvm 1 | 2010/06/03 13:50:53 | at com.continuent.tungsten.replicator.extractor.mysql.RowsLogEvent.extractValue(Row
sLogEvent.java:650)
INFO | jvm 1 | 2010/06/03 13:50:53 | ... 8 more
INFO | jvm 1 | 2010/06/03 13:50:53 | 2010-06-03 13:50:53,004 INFO replicator.pipeline.SingleThreadStageTask [binlog-to-thl] Terminating processing for stage
INFO | jvm 1 | 2010/06/03 13:50:53 | 2010-06-03 13:50:53,004 INFO replicator.pipeline.SingleThreadStageTask [binlog-to-thl] Last successfully processed event prior to termination: seqno=995 eventid=000420:0000000000145085;0
INFO | jvm 1 | 2010/06/03 13:50:53 | 2010-06-03 13:50:53,004 INFO replicator.pipeline.SingleThreadStageTask [binlog-to-thl] Stage event count: 230
INFO | jvm 1 | 2010/06/03 13:50:53 | 2010-06-03 13:50:53,004 ERROR replicator.management.OpenReplicatorManager Received error notification, shutting down services: Event extraction failed: bad date format for date value: 1029315 String: 2010-6-3O | jvm 1 | 2010/06/03 13:50:53 | ... 8 more
INFO | jvm 1 | 2010/06/03 13:50:53 | com.continuent.tungsten.replicator.extractor.mysql.MySQLExtractException: bad date format for date value: 1029315 String: 2010-6-3
INFO | jvm 1 | 2010/06/03 13:50:53 | at com.continuent.tungsten.replicator.extractor.mysql.RowsLogEvent.extractValue(Row
sLogEvent.java:657)
INFO | jvm 1 | 2010/06/03 13:50:53 | at com.continuent.tungsten.replicator.extractor.mysql.RowsLogEvent.processExtracted
EventRow(RowsLogEvent.java:891)
INFO | jvm 1 | 2010/06/03 13:50:53 | at com.continuent.tungsten.replicator.extractor.mysql.WriteRowsLogEvent.processExtr
actedEvent(WriteRowsLogEvent.java:73)
INFO | jvm 1 | 2010/06/03 13:50:53 | at com.continuent.tungsten.replicator.extractor.mysql.MySQLExtractor.extractEvent(M
ySQLExtractor.java:762)
INFO | jvm 1 | 2010/06/03 13:50:53 | at com.continuent.tungsten.replicator.extractor.mysql.MySQLExtractor.extract(MySQLE
xtractor.java:966)
INFO | jvm 1 | 2010/06/03 13:50:53 | at com.continuent.tungsten.replicator.extractor.ExtractorWrapper.extract(ExtractorW
rapper.java:91)
INFO | jvm 1 | 2010/06/03 13:50:53 | at com.continuent.tungsten.replicator.pipeline.SingleThreadStageTask.runTask(Single
ThreadStageTask.java:177)
INFO | jvm 1 | 2010/06/03 13:50:53 | at com.continuent.tungsten.replicator.pipeline.SingleThreadStageTask.run(SingleThre
adStageTask.java:122)
INFO | jvm 1 | 2010/06/03 13:50:53 | at java.lang.Thread.run(Thread.java:619)
INFO | jvm 1 | 2010/06/03 13:50:53 | Caused by: java.lang.IllegalArgumentException
INFO | jvm 1 | 2010/06/03 13:50:53 | at java.sql.Date.valueOf(Date.java:138)
INFO | jvm 1 | 2010/06/03 13:50:53 | at com.continuent.tungsten.replicator.extractor.mysql.RowsLogEvent.extractValue(Row
sLogEvent.java:650)
INFO | jvm 1 | 2010/06/03 13:50:53 | ... 8 more
|