Hi. On Thu 2002-09-05 at 10:13:12 -0400, [EMAIL PROTECTED] wrote: > > On Thu 2002-09-05 at 09:29:41 -0400, [EMAIL PROTECTED] wrote: [...] > > > Last_error: error 'unexpected success or fatal > > error' on query 'bslive' > > [...] > > 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?
That is one of the possibilities. Others are, e.g. different charsets on master and slave or different MySQL versions (one containing a bugfix) and so on. I think most of them are listed here: http://www.mysql.com/doc/en/Replication_Features.html > 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?? My answer was based on that message, but I only referred to the part "unexpected success" - I overlooked that the next line belonged to error message. I still think that my earlier explanation is correct, but additionally, it could have some other cause. Bye, Benjamin. -- [EMAIL PROTECTED] --------------------------------------------------------------------- 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