Hy, Was something wrong with this post or is it really such a weird problem that there is neither a solution nor anything i could do to solve it, nor anything i could do to find out more about it?
that was the message: I get some Errors when doing Replication on MySQL 3.23.47. And can't get it going on(I did not upgrade because in Changelog there is no replication or binlog related Bugfix mentioned between .47 and .48 and i only upgraded to .47 some days before) 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 problematic 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
