Results 1 to 3 of 3
  1. #1

    MySQL Daemon Restarting

    Linux OS:
    Kernel Version(uname -r):
    Code:
    2.6.18-128.1.1.el5.028stab062.3
    Hardware Information
    Code:
    It's a VPS with 512mb of RAM and 40gb HD, ~600Mhz. That's all I know.
    Software Version(if it is a specific peice of software causing problems):
    Code:
    MySQL 5.0.77
    Control Panel(if any):
    Code:
    LXAdmin/Kloxo (not sure on the version, I'd imagine whatever the latest one is)
    A "ps -auxf" and/or a "top"(if possible):
    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
    vmstat 5 5(if possible):
    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
    Linux Distro and Version: CentOS 5 (Final)
    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
    (this is repeated in the log file so I only pasted a portion of it)

    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!

  2. #2
    What VPS platform is this ? . OpenVZ or Xen ?.

    Please check

    cat /proc/user_beancounters

    for any problems ;if its a OpenVZ platform

  3. #3
    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

  1. Timeout error occured trying to start MySQL Daemon
    By netlink in forum Hosting Security and Technology
    Replies: 6
    Last Post: 08-01-2010, 04:28 AM
  2. mysql restarting often
    By SmartTux in forum Hosting Security and Technology
    Replies: 10
    Last Post: 10-07-2005, 10:33 AM
  3. mysql keeps restarting
    By AldWeb in forum Hosting Security and Technology
    Replies: 3
    Last Post: 09-14-2005, 05:45 PM
  4. mySQL keeps restarting
    By MagiCat in forum Hosting Security and Technology
    Replies: 0
    Last Post: 08-19-2004, 01:55 AM
  5. SIM keeps restarting mysql
    By athlonkmf in forum Hosting Security and Technology
    Replies: 6
    Last Post: 06-24-2004, 10:21 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •