MySQL Forums
Forum List  »  Replication

Struggling to get replication up...
Posted by: Yasir Sufyan
Date: April 05, 2005 03:19PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Struggling to get replication up...
10655
April 05, 2005 03:19PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.