> On Thu 2002-09-05 at 09:29:41 -0400, > [EMAIL PROTECTED] wrote: > > > > Can anyone tell me what this means??? > > > > Master_User: repslave2 > > Master_Port: 3306 > > Connect_retry: 60 > > Log_File: QBSLXDB1-bin.058 > > Pos: 52706154 > > Slave_Running: No > > Replicate_do_db: qbslive > > Replicate_ignore_db: > > Last_errno: 4294967295 > > Last_error: error 'unexpected success or fatal > error' on query 'bslive' > > It means that an statement that failed on the master, succeeded on the > slave and therefore the slave cannot be not in sync with the master > for some reason. > > This may happen, if e.g. you run an UPDATE which affects the whole > table, but *after* already updating some rows, it gets an > duplicate-key error. > > The query is then logged and send to the slave and is expected to do > the same on the slave, i.e. update some rows and then bail out. But > for some reason it did not get the same error, but succeeded instead. > And this is considered an error, because it shows an inconsistency, > and therefore manual intervention.
Are you saying the slave was manually altered? Hmm. I started up the slave again by the way and it continued on like nothing happened. I don't think what you are saying is entirely correct. Look at the following two lines. > > Replicate_do_db: qbslive > > Last_error: error 'unexpected success or fatal error' on query 'bslive' Doesn't that look like something is looking in the wrong place?? --------------------------------------------------------------------- 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
