On 26 Feb 2002, Arjen Lentz wrote: > On Tue, 2002-02-26 at 12:21, Peter Jennings wrote: > > We have been trying to solve a replication issue related to TEMPORARY > > tables. > > > > Here's the issue > > > > Every three hours we run a processX (C++ compiled program) on the Master > > mysql that goes something like this: > > > > CREATE TEMPORARY TABLE tempTableA > > INSERT INTO tempTableA > > INSERT INTO normalTableB SELECT * FROM tempTableA > > > > processX terminates. > > > > Here's what we observe on the Slave side: > > ERROR: 1146 Table 'MainDatabase.tempTableA' does not exist > > Slave: error running query 'INSERT normalTableB SELECT * FROM tempTableA > >
Hei We have seen a problem that I am sure has something to do with this too. (Latest test in a 3.23.47 rpm binary from www.mysql.com system) If a program creates and uses a temporary table and something happens with this program (stop, crash) before it sends a 'drop table' to the DB (or finish without sending to the DB a 'drop table' for this temporary table), the slave will stop replication even if the master DB drops all the temporary tables associated to the connection terminated. This error is what you get in the master when this happens : ***************************************** Slave: query 'drop table prod.test01' partially completed on the master and was aborted. There is a chance that your master is inconsistent at this point. If you are sure that your master is ok, run this query manually on the slave and then restart the slave with SET SQL_SLAVE_SKIP_COUNTER=1; SLAVE START; ***************************************** Sincerely Rafael Martinez --------------------------------------------------------------------- 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
