MySQL hang and crash
WHM 9.2.0 cPanel 9.3.0-C4 (CURRENT)
RedHat 9 - WHM X v3.1.0
Problem: I have MySQL running for about 10 mins then it crashes and chksrvd will not restart. This problem seems like it just started. When attempting restart via "service mysql restart" I get ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
In the error log there is nothing before the crash but this is what it reads when I restart manually:
/usr/sbin/mysqld: ready for connections.
Version: '4.0.20-standard' socket: '/tmp/mysql.sock' port: 3306
Number of processes running now: 1
mysqld process hanging, pid 14861 - killed
040524 20:36:05 mysqld restarted
040524 20:36:05 Warning: Asked for 196608 thread stack, but got 126976
040524 20:36:05 Can't start server: Bind on TCP/IP port: Address already in use
040524 20:36:05 Do you already have another mysqld server running on port: 3306 ?
040524 20:36:05 Aborting
040524 20:36:05 /usr/sbin/mysqld: Shutdown Complete
040524 20:36:05 mysqld ended
Things I've tried:
recreating the symbolic link between /tmp/mysql.sock and /var/lib/mysql
changing the mysql config to reflect the exact mysql.sock
upgrading/downgrading chksrvd
upgrading/downgrading MySQL
