- 论坛徽章:
- 0
|
mysql主从复制,从机出错,这是怎么回事?
show slave status\G的结果
Slave_IO_State: Waiting for master to send event
Master_Host: 192.168.0.99
Master_User: replication
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000020
Read_Master_Log_Pos: 13469325
Relay_Log_File: mysqld-relay-bin.000002
Relay_Log_Pos: 1433
Relay_Master_Log_File: mysql-bin.000020
Slave_IO_Running: Yes
Slave_SQL_Running: No
Replicate_Do_DB: djgkmp,jjkjrck,mysql,djgkmp,jjkjrck,mysql
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 1146
Last_Error: Error 'Table 'djgkmp.article' doesn't exist' on query. Default database: 'djgkmp'. Query: 'update Article set sortOrder=0, auditTime=1262653364163, audited=1, auditerID=1, author=null, catalog_ID=59, commentable=0, content='<P align=center><IMG onclick="window.open(\'/UploadFile/2010/1/5/8436747275120694.jpg\');" src="/UploadFile/2010/1/5/8436747275120694.jpg" source="/UploadFile/2010/1/5/8436747275120694.jpg"></P>\r\n<P align=center><FONT size=3><STRONG>?..?.奔涓..瑙e.锛..?.?瀵..?..琛娑茬.?../STRONG></FONT></P>\r\n<P align=left><FONT size=3>?? ?ユ.涓..澶у.?.┒浜哄.?硅.?轰?绉...?.奔锛..娓.??.??..?..?..?绉.楸间??..?.箍娉.??ㄤ?瀹..?.┒?./FONT></P>\r\n<P align=left><FONT size=3>???ユ.?卞.绀?2?.8?ユ.?.?涓..澶у.颁父娴╁.?..?╃.3骞存.?达?浣跨.?哄.绐..?虹.?.??.??查.楸间氦?.??缁..?插.?..?.奔?.?绉..楸间??瑙e锛..?.?瀵..?..琛娑茬.?../FONT></P>\r\n<
Skip_Counter: 0
Exec_Master_Log_Pos: 13460307
Relay_Log_Space: 10451
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: NULL |
|