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

Reply via email to