Bugs in replication ?

------=_NextPart_000_0012_01C30FEA.38645810
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,

I dont want to "stress" this listing, but as far as I have tested I =
cannot find any other solution then this could be a bug too in =
replication.

Configuration is Win2000 Server (fully patched), MySQL 4.0.12 on both =
master and slave.

The replication are working, binary files are "copyed" from master to =
slave, and updates takes place.

When adding some of the master-commands from 4.10.5, like "binlog-do-db" =
on the master, the master stops collecting binary-files.

When adding some of the slave-commands from 4.10.5, like =
"replicate-rewrite-db" the slave stops updating, but binary-files are =
"copyed" to the slave.

For my last testing, the FLUSH LOGS have been used between each step for =
checking, and both SHOW MASTER STATUS and SHOW SLAVE STATUS shows that =
master and slave are syncronized on positions in the binary files - =
step-by-step.

Taking off the special master/slave commands, replication are back =
again.

Best regards
Peter
Copenhagen
Denmark


------=_NextPart_000_0012_01C30FEA.38645810--

Re: Bugs in replication ?

On Thu, 2003-05-01 at 16:01, PeterWR wrote:
> Hi,
>
> I dont want to "stress" this listing, but as far as I have tested I cannot find any other solution then this could be a bug too in replication.
>
> Configuration is Win2000 Server (fully patched), MySQL 4.0.12 on both master and slave.
>
> The replication are working, binary files are "copyed" from master to slave, and updates takes place.
>
> When adding some of the master-commands from 4.10.5, like "binlog-do-db" on the master, the master stops collecting binary-files.
>
> When adding some of the slave-commands from 4.10.5, like "replicate-rewrite-db" the slave stops updating, but binary-files are "copyed" to the slave.


Peter,

To investigate if this is a bug or expected behavior we would need fully
repeatable bug report, which includes my.cnf for both master and slaves,
tables data as well as commands which resulted in the wrong behavior.

Thank you for cooperation.


--
MySQL 2003 Users Conf. -> http://www.mysql.com/events/uc2003/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Peter Zaitsev
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Moscow, Russia
<___/ www.mysql.com


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org