Hi.
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.
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
