FW: Replication bug
am 14.01.2003 23:44:56 von RossHow-To-Repeat:
-----Original Message-----
From: bugs@lists.mysql.com [mailto:bugs@lists.mysql.com]
Sent: Tuesday, January 14, 2003 2:39 PM
To: Ross Davis - DataAnywhere.net
Subject: Re: Replication bug
Your message cannot be posted to bugs@lists.mysql.com because it did not
follow the format expected by our spam/off-topic filter. To this list we
accept only repeatable bugs reports, meaning that you can describe a set
of steps we can follow to repeat the bug on our systems.
If you are having problems with MySQL but are unable to provide the
required description, and have not purchased a support contract from
MySQL AB, you should send your message to mysql@lists.mysql.com and
possibly one of our knowledgable users or developers will help you.
However, we do not guarantee that every message on mysql@lists.mysql.com
will be answered. We can afford to provide free code, but unfortunately,
we cannot afford to provide guaranteed free support on top of that. We
do, nevertheless, fix our bugs regardless of who reports them and whose
systems they affect, and will investigate your problem if you can prove
to us with a test case that the error is in our code and not yours.
If you have purchased a support contract from MySQL AB, you should
follow the standard support request procedure to report this problem.
Support contracts are available at https://order.mysql.com/.
If you are able to describe how we can repeat the problem, include the
string "How-To-Repeat:" in the body of your message, followed by the
detailed description of what we need to do to make it happen, and our
filter will accept your message. If you use mysqlbug script, which comes
with the MySQL distribution, to post the message, it will be
automatically accepted.
You have written the following:
---start of your message----
I think I have found a replication bug. We are using Mysql-Max 3.23.53
in a master and multiple slave situation. That is working fine. We are
using InnoDB
We have found a workaround to the problem but I thought you should know
about it.
We have 2 databases on the system call them dba and dbb.
If I have a connection to dba and and then run the following query the
update happens on the master but not on the slaves!!!
replace into dbb.tablename set field='somevalue' ...
The key to the problem is not the replace into, but the fact that we are
connected to one database and working on another.
I posted this message to the newsgroup and there were other comments
around the same type of problems but nothing from a Mysql person so I
thought I should send it in.
---end of your message-------
MySQL Development Team
------------------------------------------------------------ ---------
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 bugs-thread13481@lists.mysql.com
To unsubscribe, e-mail