Hy All, I get some Errors when doing Replication on MySQL 3.23.47. (I did not upgrade because in Changelog there is no Replication-Related Bugfix mentioned)
the Messages in error-log are: 020208 17:43:20 mysqld started /usr/local/mysql/3.23.47/libexec/mysqld: ready for connections 020208 17:43:22 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'FIRST' at position 4 020209 3:49:32 Slave: did not get the expected error running query from master - expected: 'Got timeout reading communication packets' (1159), got 'no error' (0) 020209 3:49:32 Slave: error running query 'drop table tropon_base.TB_Tage,tropon_0000001.TB_Tage' 020209 3:49:32 Error running query, slave aborted. Fix the problem, and re-start the slave thread with "mysqladmin start-slave". We stopped at log 'localhost-bin.001' position 330834 020209 3:49:32 Slave thread exiting, replication stopped in log 'localhost-bin.001' at position 330834 After restarting _wthout_ fixing an error because not knowing what the error is and just looking if it maybe works I get a somehow different message, even if i think it's the same problem: 020211 14:49:06 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'localhost-bin.001' at position 330834 ERROR: 1051 Unknown table 'TB_Tage,TB_Tage' 020211 14:49:06 Slave: did not get the expected error running query from master - expected: 'Got timeout reading communication packets' (1159), got 'Unknown table 'TB_Tage,TB_Tage'' (1051) 020211 14:49:06 Slave: error running query 'drop table tropon_base.TB_Tage,tropon_0000001.TB_Tage' 020211 14:49:06 Error running query, slave aborted. Fix the problem, and re-start the slave thread with "mysqladmin start-slave". We stopped at log 'localhost-bin.001' position 330834 020211 14:49:06 Slave thread exiting, replication stopped in log 'localhost-bin.001' at position 330834 Those tables are temporary heap Tables, but in replication docs I read that those work fine since some Versions. I'd greatly appreciate some Ideas, TIA, Henning --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
