Continuent Developer Community
Welcome, Guest
Please Login or Register.    Lost Password?
Event extraction failed: bad date format (1 viewing) (1) Guest
Go to bottom Post Reply Favoured: 0
TOPIC: Event extraction failed: bad date format
#707
Jonathan Sharley (User)
Fresh Boarder
Posts: 4
graphgraph
User Offline Click here to see the profile of this user
Event extraction failed: bad date format 3 Months ago Karma: 1  
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
 
Report to moderator   Logged Logged  
 
Last Edit: 2010/06/03 17:34 By iggi@bconnected.com.
  The administrator has disabled public write access.
      Topics Author Date
    thread link
Event extraction failed: bad date format
Jonathan Sharley 2010/06/03 14:13
    thread link
thread linkthread link Re:Event extraction failed: bad date format
Stephane Giron 2010/06/05 17:00
    thread link
thread linkthread linkthread link Re:Event extraction failed: bad date format
Stephane Giron 2010/06/05 17:22
    thread link
thread linkthread linkthread linkthread link Re:Event extraction failed: bad date format
Cody Payne 2010/06/07 12:27
Go to top Post Reply
Powered by FireBoardget the latest posts directly to your desktop