Dear All, I have problem that API node on cluster always auto restart mysql (every 30, 20, 15 or just 5 minutes). I see many error messages at message log file:
Jun 20 15:27:18 PrivateData1 sshd(pam_unix)[30280]: session opened for user root by root(uid=0) Jun 20 15:51:24 PrivateData1 kernel: mysqld-max[24953]: segfault at 00000000416c7fe8 rip 0000003d45d68900 rsp 00000000416c8018 error 6 Jun 20 16:03:34 PrivateData1 kernel: mysqld-max[3171]: segfault at 0000000041541fe8 rip 0000003d45d68900 rsp 0000000041542018 error 6 Jun 20 16:08:50 PrivateData1 kernel: mysqld-max[22925]: segfault at 0000000040de4fe8 rip 0000003d45d68900 rsp 0000000040de5018 error 6 Jun 20 17:40:56 PrivateData1 kernel: mysqld-max[25183]: segfault at 0000000041d61fe8 rip 0000003d45d68900 rsp 0000000041d62018 error 6 Jun 20 17:43:59 PrivateData1 kernel: mysqld-max[2592]: segfault at 0000000040e66fe8 rip 0000003d45d68900 rsp 0000000040e67018 error 6 Jun 20 17:44:14 PrivateData1 kernel: mysqld-max[3047]: segfault at 0000000040b9bfe8 rip 0000003d45d68900 rsp 0000000040b9c018 error 6 Jun 20 18:53:28 PrivateData1 kernel: mysqld-max[28016]: segfault at 0000000041992fe8 rip 0000003d45d68900 rsp 0000000041993018 error 6 Jun 20 19:00:55 PrivateData1 kernel: mysqld-max[16842]: segfault at 00000000412b7fe8 rip 0000003d45d68900 rsp 00000000412b8018 error 6 Jun 20 19:01:40 PrivateData1 kernel: mysqld-max[19158]: segfault at 0000000040fecfe8 rip 0000003d45d68900 rsp 0000000040fed018 error 6 Jun 21 08:25:35 PrivateData1 kernel: mysqld-max[17855]: segfault at 0000000041febfe8 rip 0000003d45d68900 rsp 0000000041fec018 error 6 Jun 21 08:30:20 PrivateData1 kernel: mysqld-max[28280]: segfault at 0000000040b5afe8 rip 0000003d45d68900 rsp 0000000040b5b018 error 6 Jun 21 08:31:33 PrivateData1 kernel: mysqld-max[30318]: segfault at 0000000041276fe8 rip 0000003d45d68900 rsp 0000000041277018 error 6 ............................ but there is no error on the database log file, only restarted messages. My cluser have: 1 MGM node, 1 API node and 2 data nodes. Version: 5.0.37-max | version_bdb | Sleepycat Software: Berkeley DB 4.1.24: (March 2, 2007) | | version_comment | MySQL Community Edition - Experimental (GPL) | | version_compile_machine: CentOS 4.4 x86_64, kernel: 2.6.9-34.EL Please help me Thanks so much. Toan Dang
