Last Updated: 2013-07-17
Condition or Error
Replication fails due to an incorrect SQL mode,
INVALID_DATES being
applied for a specific transaction.
Causes
Due to a problem with the code, the
SQL_MODE variable in
MySQL when set to include
ALLOW_INVALID_DATES
would be identified incorrectly as
INVALID_DATES from the
information in the binary log.
Rectifications
In affected versions, these statements can be bypassed by
explicitly ignoring that value in the event by editing
tungsten-replicator/conf/replicator.properties
to include the following property line:
replicator.applier.dbms.ignoreSessionVars=autocommit|INVALID_DATES