On Fri, 17 Nov 21:38:32 GMT, rafael@stripped wrote:
>
> Hello
>
> I have a system with a master database and a slave.
> Everything seems to work ok for a while but .....
>
> Sometimes we create a temporary table in the master database witch is destroyed when
> we do not need it anymore. It looks like the slave replicate this
> temporary table but it do not destroy it, so the next time the tmp table
> is created in the master, the slave stops with this error:
> ----------------------------------------------
> ERROR: 1050 Table \'tmp\' already exists
> 001117 15:28:37 Slave: error running query \'create temporary table tmp
> (id_site SMALLINT UNSIGNED NOT NULL, id_article SMALLINT UNSIGNED NOT
> NULL)\'
> 001117 15:28:37 Error running query, slave aborted. Fix the problem, and
> re-start the slave thread with mysqladmin start-slave
> ----------------------------------------------
>
> The master databases does not have a problem at all with this and works
> without problems.
>
> Info:
> version: mysql 3.23.27-beta (master and slave)
>
> Entries in slave (about replication):
> master-host=xxx.xxx.xxx.xxx
> master-user=copy
> master-password=********
> replicate-do-db=test
> server-id=44
>
> Entries in master (about replication):
> log-bin=/usr/local/mysql/var/replication.log
> server-id=33
> ---------------------------------
>
> Sugestions? please ..... Is this a bug in mysql or am I doing anything
> wrong?
>
> Thanks for your time
> Rafael Martinez
>
>
>
>
> --
> ---------------------------------------------------------------------
> Please check \"http://www.mysql.com/documentation/manual.php\" before
> posting. To request this thread, e-mail mysql-thread56648@stripped
>
> To unsubscribe, send a message to:
> <mysql-unsubscribe@stripped>
>
> If you have a broken mail client that cannot send a message to
> the above address (Microsoft Outlook), you can use:
> http://lists.mysql.com/php/unsubscribe.php
>
>
>
I just tried that on my testbed. I have the same problem.
I would love to know if it is a bug or what.
--
Todd
