Hi, I'm using two Mysql 3.23.36 with Innobase tables on two machines running Redhat 7.0. I'm trying to use replication in a simple master/slave configuration, but while it works when I use MyIsam tables, if one of the two machines tries to use Innobase tables the replication doesn't work, both when they are configured to do it manually and when I manually start the slave and launch load table news from master; in this last case after some seconds the slave complains of a network error (although the master is alive and configured properly). Follows an excerpt from the log of the master, ?func: general: Host: www2.MIOSITO.it ip: 193.207.81.207 vio_keepalive: enter: sd=9, set_keep_alive=1 vio_is_blocking: exit: 0 >>>> vio_write: enter: sd=9, buf=0x82afad0, size=54 *** HERE IT WRITES SUCCESSFULLY 54 BYTES ON SOCKET 9 >>>>vio_write: exit: 54 >>>>vio_is_blocking: exit: 0 >>>>vio_read: enter: sd=9, buf=0x82afad0, size=4 *****HERE IT CAN'T READ 4 BYTES FROM THE SAME SOCKET >>>>vio_read: error: Got error 11 during read -1, 4294967295 >>>>vio_read: exit: -1 ?func: info: vio_read returned -1, errno: 11 thr_alarm: enter: thread: T@2051 sec: 5 thr_alarm: info: reschedule vio_is_blocking: exit: 0 So it seems the socket has been closed (maybe by the slave?). Does anyone have any suggestion? I'd also like to know if someone has Innobase replicating correctly, and if so what versions of c++ and libstdc++ he/she is using, I don't know if gcc is preferrable to egcs-g++. Thanks very much Nico
--------------------------------------------------------------------- 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
