Results 1 to 3 of 3
Thread: MySQL Daemon Restarting
-
09-23-2009, 11:34 PM #1New Member
- Join Date
- Apr 2009
- Posts
- 3
MySQL Daemon Restarting
Linux OS:
Kernel Version(uname -r):
Code:2.6.18-128.1.1.el5.028stab062.3
Code:It's a VPS with 512mb of RAM and 40gb HD, ~600Mhz. That's all I know.
Code:MySQL 5.0.77
Code:LXAdmin/Kloxo (not sure on the version, I'd imagine whatever the latest one is)
Code:USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND root 1 0.0 0.1 2036 660 ? Ss 21:40 0:00 init [3] root 3572 0.0 0.1 1696 620 ? Ss 21:40 0:00 syslogd -m 0 dbus 3589 0.0 0.0 2708 468 ? Ss 21:40 0:00 dbus-daemon --s root 3600 0.0 0.1 4848 924 ? Ss 21:40 0:00 /usr/sbin/sshd root 24407 0.0 0.4 8068 2336 ? Ss 22:18 0:00 \_ sshd: abare 1014 24441 0.0 0.2 8068 1552 ? S 22:18 0:00 \_ sshd: a 1014 24442 0.0 0.2 2416 1308 pts/0 Ss 22:18 0:00 \_ -ba 1014 26295 0.0 0.1 2140 816 pts/0 R+ 22:19 0:00 \_ root 3610 0.0 0.1 2676 888 ? Ss 21:40 0:00 xinetd -stayali clamav 3618 0.0 0.2 2924 1188 ? Ss 21:40 0:00 /usr/bin/freshc root 3635 0.0 5.7 32468 30016 ? Ss 21:40 0:00 /usr/bin/spamd 1005 3883 0.0 5.4 32468 28632 ? S 21:40 0:00 \_ spamd child 1005 3885 0.0 5.4 32468 28556 ? S 21:40 0:00 \_ spamd child tinydns 3651 0.0 0.0 1620 300 ? S 21:40 0:00 /usr/local/bin/ root 3652 0.0 0.0 1668 372 ? S 21:40 0:00 tcpserver -vDRH root 3672 0.0 0.2 2416 1112 ? S 21:40 0:00 sh ../sbin/klox root 3687 0.0 0.2 4220 1472 ? S 21:40 0:00 \_ ../sbin/klo lxlabs 3715 0.0 0.3 5316 2044 ? S 21:40 0:00 /usr/local/lxla qmails 3898 0.0 0.0 1876 476 ? S 21:40 0:00 qmail-send qmaill 3901 0.0 0.0 1640 472 ? S 21:40 0:00 \_ splogger qm root 3902 0.0 0.0 1652 348 ? S 21:40 0:00 \_ qmail-lspaw qmailr 3904 0.0 0.0 1648 372 ? S 21:40 0:00 \_ qmail-rspaw qmailq 3905 0.0 0.0 1632 352 ? S 21:40 0:00 \_ qmail-clean clamav 3911 0.1 14.1 76520 73936 ? S 21:40 0:03 /usr/sbin/clamd root 3973 0.0 0.2 6248 1300 ? S 21:40 0:00 /usr/libexec/co root 3998 0.0 0.0 6248 460 ? S 21:40 0:00 \_ /usr/libexe root 3975 0.0 0.0 1668 376 ? S 21:40 0:00 /usr/bin/tcpser root 3979 0.0 0.0 1668 368 ? S 21:40 0:00 /usr/bin/tcpser root 3991 0.0 0.0 1668 372 ? S 21:40 0:00 /usr/bin/tcpser root 3994 0.0 0.0 1668 368 ? S 21:40 0:00 /usr/bin/tcpser root 4010 0.0 0.2 3180 1108 ? Ss 21:40 0:00 crond root 7306 0.0 2.4 32608 12964 ? Ss 21:41 0:00 /usr/sbin/httpd apache 7308 0.0 1.8 32880 9628 ? S 21:41 0:00 \_ /usr/sbin/h apache 7309 0.0 1.8 32880 9640 ? S 21:41 0:00 \_ /usr/sbin/h apache 7310 0.0 1.8 32880 9612 ? S 21:41 0:00 \_ /usr/sbin/h apache 7311 0.0 1.8 32880 9604 ? S 21:41 0:00 \_ /usr/sbin/h apache 7312 0.0 1.8 32880 9768 ? S 21:41 0:00 \_ /usr/sbin/h apache 7314 0.0 1.8 32880 9764 ? S 21:41 0:00 \_ /usr/sbin/h apache 7315 0.0 1.8 32896 9764 ? S 21:41 0:00 \_ /usr/sbin/h apache 7316 0.0 1.8 32880 9784 ? S 21:41 0:00 \_ /usr/sbin/h root 19760 0.0 0.2 2412 1128 ? S 22:16 0:00 /bin/sh /usr/bi mysql 19810 0.0 0.8 23944 4688 ? Sl 22:16 0:00 \_ /usr/libexe
Code:procs -----------memory---------- ---swap-- -----io---- --system-- -----cpu------ r b swpd free buff cache si so bi bo in cs us sy id wa st 1 0 0 350540 0 0 0 0 0 1 0 2153 1 0 99 0 0 0 0 0 350532 0 0 0 0 0 0 0 2848 0 0 100 0 0 0 0 0 350532 0 0 0 0 0 0 0 2251 0 0 100 0 0 0 0 0 350532 0 0 0 0 0 1 0 2007 0 0 100 0 0 0 0 0 350532 0 0 0 0 0 0 0 1827 0 0 100 0 0
Log File(s):
my.cnf:
Code:090923 22:01:05 mysqld started 090923 22:01:05 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295 090923 22:01:05 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295 090923 22:01:05 [Warning] option 'thread_stack': unsigned value 65536 adjusted to 131072 090923 22:01:05 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.0.77' socket: '/var/lib/mysql/mysql.sock' port: 2319 Source distribution 090923 22:06:05 [Note] /usr/libexec/mysqld: Normal shutdown 090923 22:06:05 [Note] /usr/libexec/mysqld: Shutdown complete 090923 22:06:05 mysqld ended 090923 22:06:06 mysqld started 090923 22:06:06 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295 090923 22:06:06 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295 090923 22:06:06 [Warning] option 'thread_stack': unsigned value 65536 adjusted to 131072 090923 22:06:06 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.0.77' socket: '/var/lib/mysql/mysql.sock' port: 2319 Source distribution 090923 22:11:05 [Note] /usr/libexec/mysqld: Normal shutdown 090923 22:11:05 [Note] /usr/libexec/mysqld: Shutdown complete 090923 22:11:05 mysqld ended 090923 22:11:06 mysqld started 090923 22:11:06 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295 090923 22:11:06 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295 090923 22:11:06 [Warning] option 'thread_stack': unsigned value 65536 adjusted to 131072 090923 22:11:06 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.0.77' socket: '/var/lib/mysql/mysql.sock' port: 2319 Source distribution 090923 22:16:05 [Note] /usr/libexec/mysqld: Normal shutdown 090923 22:16:05 [Note] /usr/libexec/mysqld: Shutdown complete 090923 22:16:05 mysqld ended 090923 22:16:05 mysqld started 090923 22:16:05 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295 090923 22:16:05 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295 090923 22:16:05 [Warning] option 'thread_stack': unsigned value 65536 adjusted to 131072 090923 22:16:05 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.0.77' socket: '/var/lib/mysql/mysql.sock' port: 2319 Source distribution
My problem is that the mysql daemon restarts 10 minutes on the dot after the VPS is rebooted, then after that every 5 minutes (+/- 1 second). I read on LXAdmin's forums about disabling iptables, which I did, and also something about binding mysql to 0.0.0.0 instead of the public IP address, which I did as well. This problem just started happening about a week or so ago. Nothing has been changed/updated/installed on the VPS for some time (except for mysql, it was on version 5.0.22 when problem started). I updated mysql to 5.0.77 tonight and I still have this issue.
I'm not the most educated person when it comes to Linux, but I know my way around decently, so please keep this in mind when replying. Thanks for any help!
-
09-24-2009, 02:15 AM #2New Member
- Join Date
- Sep 2009
- Posts
- 1
What VPS platform is this ? . OpenVZ or Xen ?.
Please check
cat /proc/user_beancounters
for any problems ;if its a OpenVZ platform
-
09-24-2009, 02:30 AM #3Newbie
- Join Date
- Sep 2009
- Posts
- 13
It appears to be a bug in the mysql 5.x versions. This is caused by the error in type casting.
You can find the detailed story in the following MySQL forum thread.
http://bugs.mysql.com/bug.php?id=33785
A patch is also available in the same thread.Technical support | Server administration
Similar Threads
-
Timeout error occured trying to start MySQL Daemon
By netlink in forum Hosting Security and TechnologyReplies: 6Last Post: 08-01-2010, 04:28 AM -
mysql restarting often
By SmartTux in forum Hosting Security and TechnologyReplies: 10Last Post: 10-07-2005, 10:33 AM -
mysql keeps restarting
By AldWeb in forum Hosting Security and TechnologyReplies: 3Last Post: 09-14-2005, 05:45 PM -
mySQL keeps restarting
By MagiCat in forum Hosting Security and TechnologyReplies: 0Last Post: 08-19-2004, 01:55 AM -
SIM keeps restarting mysql
By athlonkmf in forum Hosting Security and TechnologyReplies: 6Last Post: 06-24-2004, 10:21 PM