My replication became out of sync. (Which in turn seems to rewrite my master.info with some garbage) In this particular instance, the LOG_FILE name had a bunch of spaces appended to it, and the PORT got changed to 0. The slave was running, but not going anywhere of course. Usually I can just reset the LOG_FILE name and the replication would resume. The port was still at 0, and replication resumed!! So I changed the PORT to 3306, and then my replication stopped. It tried to resume from -bin.001, so I switched it to the last known LOG_FILE and LOG_POS and replication will not resume. And of course I tried to start it multiple times. Below is the entries in the err file. What I would like to know, is how can I get this kick started again, and would there have been some corruption occur (it would have been trying to do some inserts and updates)
020527 9:41:43 Error reading packet from server: Could not find first log (read_errno 0,server_errno=65535) 020527 9:42:43 Slave: Failed reading log event, reconnecting to retry, log 'QBSLXDB1-bin.044 ' position 1683820 020527 9:42:44 Slave: reconnected to master '[EMAIL PROTECTED]:0',replication resumed in log 'QBSLXDB1-bin.044 ' at position 1683820 020527 9:42:44 Error reading packet from server: Could not find first log (read_errno 0,server_errno=65535) 020527 9:43:44 Slave: Failed reading log event, reconnecting to retry, log 'QBSLXDB1-bin.044 ' position 1683820 020527 9:43:44 Slave: reconnected to master '[EMAIL PROTECTED]:0',replication resumed in log 'QBSLXDB1-bin.044 ' at position 1683820 020527 9:43:44 Error reading packet from server: Could not find first log (read_errno 0,server_errno=65535) 020527 9:43:49 Slave thread exiting, replication stopped in log 'QBSLXDB1-bin.044 ' at position 1683820 020527 9:43:49 Slave: connected to master '[EMAIL PROTECTED]:0', replication started in log 'QBSLXDB1-bin.044' at position 1683820 020527 9:44:34 Slave thread exiting, replication stopped in log 'QBSLXDB1-bin.044' at position 2753978 020527 9:44:34 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'FIRST' at position 4 ERROR: 1062 Duplicate entry '242' for key 1 020527 9:44:35 Slave: error running query 'INSERT INTO REPORT (CreateStamp) VALUES (NOW())' 020527 9:44:35 Error running query, slave aborted. Fix the problem, and re-start the slave thread with mysqladmin start-slave - log 'QBSLXDB1-bin.001' position 841 020527 9:44:35 Slave thread exiting, replication stopped in log 'QBSLXDB1-bin.001' at position 841 020527 9:46:08 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'QBSLXDB1-bin.044' at position 2337362 ERROR: 1062 Duplicate entry '2234960' for key 1 020527 9:46:08 Slave: error running query 'INSERT INTO DISPATCHLOG (CreateStamp) VALUES (NOW())' 020527 9:46:08 Error running query, slave aborted. Fix the problem, and re-start the slave thread with mysqladmin start-slave - log 'QBSLXDB1-bin.044' position 2338640 020527 9:46:08 Slave thread exiting, replication stopped in log 'QBSLXDB1-bin.044' at position 2338640 020527 9:46:15 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'QBSLXDB1-bin.044' at position 2338640 ERROR: 1062 Duplicate entry '2234961' for key 1 020527 9:46:15 Slave: error running query 'INSERT INTO DISPATCHLOG (CreateStamp) VALUES (NOW())' 020527 9:46:15 Error running query, slave aborted. Fix the problem, and re-start the slave thread with mysqladmin start-slave - log 'QBSLXDB1-bin.044' position 2339258 020527 9:46:15 Slave thread exiting, replication stopped in log 'QBSLXDB1-bin.044' at position 2339258 020527 9:54:42 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'QBSLXDB1-bin.044' at position 2753978 ERROR: 1062 Duplicate entry '2235105' for key 1 020527 9:54:43 Slave: error running query 'INSERT INTO DISPATCHLOG (CreateStamp) VALUES (NOW())' 020527 9:54:43 Error running query, slave aborted. Fix the problem, and re-start the slave thread with mysqladmin start-slave - log 'QBSLXDB1-bin.044' position 2757402 020527 9:54:43 Slave thread exiting, replication stopped in log 'QBSLXDB1-bin.044' at position 2757402 020527 10:09:57 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'QBSLXDB1-bin.044' at position 2753978 ERROR: 1062 Duplicate entry '294169' for key 1 020527 10:09:58 Slave: error running query 'INSERT INTO ORDERHEADER (CreateStamp) VALUES (NOW())' 020527 10:09:58 Error running query, slave aborted. Fix the problem, and re-start the slave thread with mysqladmin start-slave - log 'QBSLXDB1-bin.044' position 2753978 020527 10:09:58 Slave thread exiting, replication stopped in log 'QBSLXDB1-bin.044' at position 2753978 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
