I'm trying to resolve a frustrating replication problem with my databases. The master contains a number of schema, only using Innodb tables. Updates happen regularly, usually using bulk inserts of the form INSERT ... ON DUPLICATE UPDATE. Data is mostly numbers. The missing queries contain no non-deterministic functions, no BLOB/TEXT fields, no triggers or procedures, and no variables. The queries are generated by various C programs, connecting through Connector/ODBC.
typical table (explain results): 'nodeID', 'int(10) unsigned', 'NO', 'PRI', '', '' 'calculationID', 'int(10) unsigned', 'NO', 'PRI', '', '' 'columnID', 'tinyint(3) unsigned', 'NO', 'PRI', '1', '' 'value', 'double', 'NO', '', '', '' 'lastUpdate', 'timestamp', 'NO', '', 'CURRENT_TIMESTAMP', 'on update CURRENT_TIMESTAMP typical bulk insert: INSERT INTO risk.risk_node_tree (nodeID, calculationID, columnID, value, lastUpdate) VALUES (1,2,1,1000,null),... ON DUPLICATE KEY UPDATE value=VALUES(value) Replication is active, and I am able to test it by doing single point modifications through the query browser. However, the bulk inserts seem to vanish: The Master updates, but the slave does not. There are no errors in the log file. SHOW SLAVE STATUS states no problems. I have attempted changing binlog_format, and have received the same results on all three settings. The Master has no settings to ignore any particular schema. Using the query browser, and running the same exact query with the same user, results in the query properly replicating. Both instances are 5.1.34. This is causing me to have to resynchronize the databases every night, which is getting to be something of a chore. Does anyone have any idea what might be happening, or could suggest an avenue of investigation? Any help would be greatly appreciated. Martin -- --- This is a signature. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
