Run Replication Manager แล้วเกิดปัญหาแบบนี้ครับ
---------------------------------------------------------------------------------------------------------------------------------------
15/02/2553 22:36:42 192.168.100.17/hos Out of memory
15/02/2553 22:36:48 192.168.100.15/hos Out of memory
15/02/2553 22:36:51 192.168.100.17/hos ReceiveCompHeader: Net packets out of order: received[19], expected[1]
15/02/2553 22:36:53 192.168.100.15/hos ReceiveCompHeader: Net packets out of order: received[163], expected[1]
15/02/2553 22:36:57 192.168.100.17/hos ReceiveCompHeader: Net packets out of order: received[116], expected[1]
15/02/2553 22:36:59 192.168.100.15/hos ReceiveCompHeader: Net packets out of order: received[115], expected[1]
15/02/2553 22:37:02 192.168.100.17/hos ReceiveCompHeader: Net packets out of order: received[164], expected[1]
15/02/2553 22:37:04 192.168.100.15/hos ReceiveCompHeader: Net packets out of order: received[114], expected[1]
15/02/2553 22:37:07 192.168.100.17/hos ReceiveCompHeader: Net packets out of order: received[3], expected[1]
15/02/2553 22:37:10 192.168.100.15/hos ReceiveCompHeader: Net packets out of order: received[161], expected[1]
15/02/2553 22:37:13 192.168.100.17/hos ReceiveCompHeader: Net packets out of order: received[108], expected[1]
15/02/2553 22:37:15 192.168.100.15/hos ReceiveCompHeader: Net packets out of order: received[8], expected[1]
15/02/2553 22:37:18 192.168.100.17/hos ReceiveCompHeader: Net packets out of order: received[150], expected[1]
15/02/2553 22:37:21 192.168.100.15/hos ReceiveCompHeader: Net packets out of order: received[252], expected[1]
15/02/2553 22:37:23 192.168.100.17/hos ReceiveCompHeader: Net packets out of order: received[111], expected[1]
15/02/2553 22:37:26 192.168.100.15/hos ReceiveCompHeader: Net packets out of order: received[31], expected[1]
15/02/2553 22:37:29 192.168.100.17/hos Lost connection to MySQL server during querySocket error on write. WSAGetLastError return 10054($2746)
15/02/2553 22:37:31 192.168.100.15/hos ReceiveCompHeader: Net packets out of order: received[190], expected[1]
15/02/2553 22:37:37 192.168.100.15/hos ReceiveCompHeader: Net packets out of order: received[232], expected[1]
15/02/2553 22:37:42 192.168.100.15/hos ReceiveCompHeader: Net packets out of order: received[141], expected[1]
15/02/2553 22:37:53 192.168.100.15/hos ReceiveCompHeader: Net packets out of order: received[215], expected[1]
---------------------------------------------------------------------------------------------------------------------------------------
ลอง restart slave server แล้วก็ยังไม่ได้อยู่ดี (ไม่ใช่แค่ restart MySQL นะ restart เครื่องเลย)
restart เครื่องที่ทำ replicate แล้ว ก็ยังไม่ได้ ไม่รู้โดนอะไรเข้าไป
เหลืออย่างเดียวยังไมได้ restart server หลักครับ
อยากทราบว่าเกิดจากอะไร แล้วมีแนวทางแก้ไขอย่างไรครับ
หัวข้อ: Replication Manager มีปัญหา (อ่าน 10313 ครั้ง)