LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Software (https://www.linuxquestions.org/questions/linux-software-2/)
-   -   Mysql replication (https://www.linuxquestions.org/questions/linux-software-2/mysql-replication-86525/)

pk21 08-28-2003 05:00 AM

Mysql replication
 
My replications doesnt work anymore.
Here is a 'show processlist' from the slave while its trying to do replication:

+------+-------------+-----------+----------+---------+------+------------------------------------------+------------------+
| Id | User | Host | db | Command | Time | State
| Info |
+------+-------------+-----------+----------+---------+------+------------------------------------------+------------------+
| 2203 | ictu02dbu | localhost | db02 | Sleep | 40 |
| NULL |
| 2231 | ictu02dbu | localhost | db02 | Sleep | 7 |
| NULL |
| 2252 | ictu02dbu | localhost | db02 | Sleep | 855 |
| NULL |
| 2253 | root | localhost | db02 | Query | 0 | NULL
| show processlist |
| 2255 | system user | none | NULL | Connect | 144 | Waiting to reconnect after a failed read | NULL |
+------+-------------+-----------+----------+---------+------+------------------------------------------+------------------+
5 rows in set (0.00 sec)

Does anyone know how i can handle this problem?


All times are GMT -5. The time now is 10:05 AM.