Struggling to get replication up...
Hi Great People,
I am working on a project that is using a replicated database.... I am having a real hard time with replication... I have about 8 replication errors that caused the replication to halt.... I am running 4.1.7-max-log with my.cnf (copy of myhuge.cnf) of huge database. Twice the replication was halted because of binaro log being corrupted.
Error history:
Error1:
50324 14:20:00 [ERROR] Got fatal error 1236: 'log event entry exceeded
max_allowed_packet; Increase max_allowed_packet on master' from master
when reading data from binary log
050324 14:20:00 [ERROR] Slave I/O thread exiting, read up to log
'.000037', position 96219300
Error2:
050324 16:49:47 [ERROR] Slave: Error 'You have an error in your SQL
syntax; check the manual that corresponds to your MySQL server version
for the right syntax to use near '' at line 1' on query. Default
database: 'cms'. Query: 'insert into productdescription (createdate,
createdbyid, onelinedescid, productid, languageId,marketid,description,
isactive, updatedate, dbuäDAB', Error_code: 1064
Error 3:
050324 14:20:00 [ERROR] Error reading packet from server: log event
entry exceeded max_allowed_packet; Increase max_allowed_packet on master
(server_errno=1236)
Error 4:
Error 'Cannot add or update a child row: a foreign key constraint fails' on query. Default database: 'cms'. Query: 'insert into PRODUCTSTATUSHISTORY (isactive,productid,languageid,updatedbyid,productstatusid,oldproductstatusid,timestamp,productstatushistoryid) values (1,10514464,9,1446,3,3,'2005-04-04 16:46:41',0)'
Error:5
050405 17:05:48 [ERROR] Error reading packet from server: log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master (server_errno=1236)
050405 17:05:48 [ERROR] Got fatal error 1236: 'log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master' from master when reading data from binary log
050405 17:05:48 [ERROR] Slave I/O thread exiting, read up to log '.000001', position 619068
050405 17:05:52 [ERROR] Slave: Error 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ms' at line 1' on query. Default database: ''. Query: 'ms', Error_code: 1064
050405 17:05:52 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log '.000001' position 552954
Thanks in advance.
Yasir Sufyan.