C.3.9.  The session variable SQL_MODE when set to include ALLOW_INVALID_DATES does not apply statements correctly on the Replica.

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