Hi, I'm trying to replicate a db. I'm running MySQL 3.23.49a-log on a linux box as master and MySQL 3.23.49-log on Solaris as slave. I copied the data on the solaris box and I modified the cnf files.
The slave error message is the following: 020627 16:04:35 Slave: Failed reading log event, reconnecting to retry, log 'FIRST' position 31 020627 16:04:35 Slave: reconnected to master 'repl@keynes:3306',replication resumed in log 'FIRST' at position 31 020627 16:04:35 Slave: received 0 length packet from server, apparent master shutdown: (0) On master: mysql> SHOW MASTER STATUS; +----------------+----------+--------------+------------------+ | File | Position | Binlog_do_db | Binlog_ignore_db | +----------------+----------+--------------+------------------+ | keynes-bin.023 | 399 | | | +----------------+----------+--------------+------------------+ On slave: mysql> SHOW SLAVE STATUS; +-------------+-------------+-------------+---------------+----------+-----+---------------+-----------------+---------------------+------------+------------+--------------+ | Master_Host | Master_User | Master_Port | Connect_retry | Log_File | Pos | Slave_Running | Replicate_do_db | Replicate_ignore_db | Last_errno | Last_error | Skip_counter | +-------------+-------------+-------------+---------------+----------+-----+---------------+-----------------+---------------------+------------+------------+--------------+ | keynes | repl | 3306 | 60 | | 31 | Yes | | | 0 | | 0 | +-------------+-------------+-------------+---------------+----------+-----+---------------+-----------------+---------------------+------------+------------+--------------+ mysql> SHOW PROCESSLIST; +----+-------------+-----------+------+---------+------+------------------------------------------+------------------+ | Id | User | Host | db | Command | Time | State | | Info | +----+-------------+-----------+------+---------+------+------------------------------------------+------------------+ | 1 | system user | none | NULL | Connect | 3185 | Waiting to reconnect after a failed read | NULL | | 6 | paolo | localhost | NULL | Query | 0 | NULL | | SHOW PROCESSLIST | +----+-------------+-----------+------+---------+------+------------------------------------------+------------------+ Any suggestion? -- ======================================================== Paolo Patelli PGP Key ID:17EFF1F5 ======================================================== Actual Position: Graduate fellow at Santa Fe Institute 1399 Hyde Park Rd, Santa Fe, New Mexico 87501 USA ph.: 505 984 8800 ext. 293 email: [EMAIL PROTECTED] ======================================================== PhD student, S. Anna School for Advanced Studies via Carducci 40, 56100 Pisa, Italy email: [EMAIL PROTECTED] ======================================================== CEEL member, Dept. of Economics, University of Trento via Imene 1, 38100 Trento, Italy email: [EMAIL PROTECTED] ======================================================== --------------------------------------------------------------------- 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
