BMS-HOSxP Community

HOSxP => แจ้งปัญหา / ขอความช่วยเหลือ => ข้อความที่เริ่มโดย: wiphusit ที่ มิถุนายน 19, 2010, 11:31:15 AM

หัวข้อ: replicate_slave
เริ่มหัวข้อโดย: wiphusit ที่ มิถุนายน 19, 2010, 11:31:15 AM

19/06/2553 00:47:20 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 01:05:57 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 01:25:13 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 01:26:32 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 01:41:30 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 01:50:30 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 01:59:08 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 02:03:19 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 02:08:36 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 02:18:28 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 02:24:11 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 02:32:13 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 02:34:00 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 02:36:01 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 02:46:44 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 02:47:44 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 02:49:46 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 02:54:32 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 03:05:43 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 03:09:26 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 03:16:18 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 03:17:25 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 03:22:30 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 03:24:26 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 03:32:41 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 03:43:58 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 03:46:46 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 03:52:13 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 03:55:21 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 04:03:17 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 04:05:15 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 04:13:07 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 04:47:30 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 04:52:43 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 05:09:27 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 08:20:52 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 08:25:05 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 08:26:04 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 08:29:22 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 08:29:51 192.168.1.96/paknam  Can't connect to MySQL server on '192.168.1.100' (10061)Socket error on connect. WSAGetLastError return 10060($274C)
19/06/2553 11:33:23 192.168.1.96/paknam  Lost connection to MySQL server during query
19/06/2553 11:33:29 192.168.1.96/paknam  Can't connect to MySQL server on '192.168.1.96' (10061)Socket error on connect. WSAGetLastError return 10061($274D)
19/06/2553 11:33:55 192.168.1.96/paknam  Can't connect to MySQL server on '192.168.1.96' (10061)Socket error on connect. WSAGetLastError return 10060($274C)
19/06/2553 11:34:20 192.168.1.96/paknam  Can't connect to MySQL server on '192.168.1.96' (10061)Socket error on connect. WSAGetLastError return 10060($274C)

มันคืออะไร

หัวข้อ: Re: replicate_slave
เริ่มหัวข้อโดย: ismailsa ที่ มิถุนายน 19, 2010, 11:39:15 AM

อ้างจาก: wiphusit ที่ มิถุนายน 19, 2010, 11:31:15 AM

19/06/2553 00:47:20 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 01:05:57 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 01:25:13 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 01:26:32 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 01:41:30 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 01:50:30 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 01:59:08 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 02:03:19 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 02:08:36 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 02:18:28 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 02:24:11 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 02:32:13 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 02:34:00 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 02:36:01 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 02:46:44 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 02:47:44 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 02:49:46 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 02:54:32 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 03:05:43 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 03:09:26 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 03:16:18 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 03:17:25 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 03:22:30 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 03:24:26 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 03:32:41 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 03:43:58 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 03:46:46 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 03:52:13 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 03:55:21 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 04:03:17 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 04:05:15 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 04:13:07 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 04:47:30 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 04:52:43 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 05:09:27 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 08:20:52 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 08:25:05 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 08:26:04 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 08:29:22 192.168.1.96/paknam  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746)
19/06/2553 08:29:51 192.168.1.96/paknam  Can't connect to MySQL server on '192.168.1.100' (10061)Socket error on connect. WSAGetLastError return 10060($274C)
19/06/2553 11:33:23 192.168.1.96/paknam  Lost connection to MySQL server during query
19/06/2553 11:33:29 192.168.1.96/paknam  Can't connect to MySQL server on '192.168.1.96' (10061)Socket error on connect. WSAGetLastError return 10061($274D)
19/06/2553 11:33:55 192.168.1.96/paknam  Can't connect to MySQL server on '192.168.1.96' (10061)Socket error on connect. WSAGetLastError return 10060($274C)
19/06/2553 11:34:20 192.168.1.96/paknam  Can't connect to MySQL server on '192.168.1.96' (10061)Socket error on connect. WSAGetLastError return 10060($274C)

มันคืออะไร

มันหาไม่เจอครับ เข้าใจว่า paknam เป็นชื่อฐานข้อมูลใช่บ่ครับ บนโฮสต์ 192.168.1.96

หัวข้อ: Re: replicate_slave
เริ่มหัวข้อโดย: wiphusit ที่ มิถุนายน 19, 2010, 11:48:36 AM

ใช่ครับ

หัวข้อ: Re: replicate_slave
เริ่มหัวข้อโดย: มนตรี บอยรักยุ้ยคนเดียว ที่ มิถุนายน 19, 2010, 14:17:09 PM

192.168.1.96

service mysql start หรือเปล่า
ping 192.168.1.96 -t ได้หรือเปล่า
ถ้าขึ้น time out ลองเช็ค ไฟล์วอล และ port 3306

หัวข้อ: Re: replicate_slave
เริ่มหัวข้อโดย: Adeno Benzoate ที่ มิถุนายน 20, 2010, 01:01:55 AM

ของละงูก็เป็นครับ ตอนนี้ก็ยังหาคำตอบไม่ได้ ที่คาดการณ์ไว้เบื้องต้นคือ Lost Connection กับเครื่อง Slave แต่ยังสงสัยอยู่ เพราะอยู่เวรพอดีแล้ว Connection ที่ห้องยาก็หลุดด้วย เลยยังไม่กล้าฟันธงครับ

หัวข้อ: Re: replicate_slave
เริ่มหัวข้อโดย: มนตรี บอยรักยุ้ยคนเดียว ที่ มิถุนายน 20, 2010, 17:17:58 PM

ใน ระบบ ลง NOD 4.xx หรือเปล่า ลองถอนออกที่เครื่องลูก  น่าจะหาย
เคยมี รพ.อื่นเป็นอยู่

หัวข้อ: Re: replicate_slave
เริ่มหัวข้อโดย: phatipan2 ที่ มิถุนายน 21, 2010, 15:11:10 PM

ใช้คำสั่ง ping ที่เครื่อง server ให้ได้ก่อน ครับ
แล้วก็ไมทราบว่าไปเปลี่ยน user กับ pass ใหม่เปล่า ครับ กลัวตกม้า ครับ
ถ้า ping ไปไม่ได้ก็น่าจะเป็นที่ ระบบ แลนมากกว่า ครับ

หัวข้อ: Re: replicate_slave
เริ่มหัวข้อโดย: Svl2Nuk3 ที่ มิถุนายน 21, 2010, 15:46:47 PM

เป็นเหมือนกันกับครับ   Server  Main  ทำงานปกติ  Server Slave  ทำงานปกติ
แต่ตอน  Run Agent Replicate ไว้  จะมีข้อความแบบนี้ขึ้นให้เห็นเป็นบางครั้งครับ

ยังไม่แน่ใจว่าเกิดจากอะไร  2-3 วัน จะเป็นทีครับ