My Slave stopped replicating.
SHOW SLAVE STATUS
*************************** 1. row ***************************
Master_Host: 209.217.92.34
Master_User: repslave2
Master_Port: 3306
Connect_retry: 60
Log_File: QBSLXDB1-bin.049
Pos: 56605370
Slave_Running: No
Replicate_do_db: qbslive
Replicate_ignore_db:
Last_errno: 1054
Last_error: error 'Unknown column 'PrinintLe' in 'field list'' on query
'UPDATE PRINTJOBDATA SET ID_PRINTJOB = '55986', ID_PRINTERCODE = '1', PrinintLe = '
26/06 324406 15:27 Doris 37 5330 Canotek 1794 Woodward
ECO 4.95 ', Sequence = '35' WHERE
PRINTJOBDATA.ID = 5328541'
Skip_counter: 0
------------------------------
When replication receives stuff like 'Unknown column' errors, can't it just go back
and try it again? It probably just lost some data on the transfer. MySQL doesn't log
erroneous queries ( does it? ) so it should know that there was some kind of transfer
error.
'PrinintLe' should be 'PrintLine'. It seems to have moved 'in' back a few characters.
I restarted the slave and off it went, doing its merry little chore :)
I don't know what I am hoping for here, just griping about it :)
Luc Foisy
Technical Magic - www.technical-magic.com
1 Stafford Road, Suite 325, Nepean, Ontario, K2H 1B9
Phone: (613) 721-8850 Fax: (613) 596-5096
E-Mail: [EMAIL PROTECTED]
<<<<< Fulfilling the Promise of Technology >>>>>
---------------------------------------------------------------------
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
