Hi All, I had a system replication on Linux consisting of MASTER and only one SLAVE. I stopped replication, I did a backup on my slave and it recreated in another machine so now I have two SLAVES connected to database MASTER.
But I found problems. I show you the output on my database MASTER and SLAVE who is failed: *************************************************** MASTER mysql> show master status; +---------+----------+--------------+------------------+ | File | Position | Binlog_do_db | Binlog_ignore_db | +---------+----------+--------------+------------------+ | log.101 | 54557 | | | +---------+----------+--------------+------------------+ 1 row in set (0.00 sec) 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 | +--------------------------+-------------+-------------+---------------+---- ------+-----+---------------+-----------------+---------------------+------- -----+------------+--------------+ | spiderman.terravista.srv | replica | 3306 | 60 | | 4 | Yes | | | 0 | | 0 | +--------------------------+-------------+-------------+---------------+---- ------+-----+---------------+-----------------+---------------------+------- -----+------------+--------------+ 1 row in set (0.00 sec) mysql> show processlist; +----+-------------+-----------+------+---------+------+-------------------- ----------------------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-------------+-----------+------+---------+------+-------------------- ----------------------+------------------+ | 1 | system user | none | NULL | Connect | 7729 | Waiting to reconnect after a failed read | NULL | | 2 | root | localhost | NULL | Sleep | 337 | | NULL | | 3 | root | localhost | NULL | Query | 0 | NULL | show processlist | +----+-------------+-----------+------+---------+------+-------------------- ----------------------+------------------+ In errors log: 020712 12:43:40 Error reading packet from server: Could not open log file (server_errno=2) 020712 12:44:40 Slave: Failed reading log event, reconnecting to retry, log 'FIRST' position 4 020712 12:44:40 Slave: reconnected to master 'replica#spiderman.terravista.srv:3306',replication resumed in log 'FIRST' at position 4 020712 12:44:40 Error reading packet from server: Could not open log file (server_errno=2) 020712 12:45:40 Slave: Failed reading log event, reconnecting to retry, log 'FIRST' position 4 020712 12:45:40 Slave: reconnected to master 'replica#spiderman.terravista.srv:3306',replication resumed in log 'FIRST' at position 4 020712 12:45:40 Error reading packet from server: Could not open log file (server_errno=2) my.cnf: # The MySQL server [mysqld] port = 3306 socket = /tmp/mysql.sock skip-locking set-variable = key_buffer=384M set-variable = max_allowed_packet=1M set-variable = table_cache=512 set-variable = sort_buffer=2M set-variable = record_buffer=2M set-variable = thread_cache=8 # Try number of CPU's*2 for thread_concurrency set-variable = thread_concurrency=8 set-variable = myisam_sort_buffer_size=64M #log-bin = /mysql/log/log.nnn server-id = 3 master-host = spiderman.terravista.srv master-user = replica master-password = xxxxx *********************************************** Any suggestion? Thanks in advance. Santiago. --------------------------------------------------------------------- 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
