The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

mysql databases missing!

Discussion in 'General Discussion' started by Secret Agent, Jun 17, 2005.

  1. Secret Agent

    Secret Agent Guest

    Mysql had an error starting this morning and I had to run /scripts/mysqlup --force

    Now the databaes were there AFTER, a few minutes later they disappear????

    What the hell is wrong with mysql on cpanel?? I know many others on the forum have the same on going issues

    What do I do?
     
  2. Secret Agent

    Secret Agent Guest

    logs show this:

    050617 8:31:04 [Note] /usr/sbin/mysqld: Shutdown complete

    050617 08:31:04 mysqld ended

    050617 08:32:11 mysqld started
    050617 8:32:11 [Warning] Asked for 196608 thread stack, but got 126976
    /usr/sbin/mysqld: ready for connections.
    Version: '4.1.11-standard' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition - Standard (GPL)
    050617 8:39:56 [Note] /usr/sbin/mysqld: Normal shutdown

    050617 8:39:57 [ERROR] /usr/sbin/mysqld: Forcing close of thread 113 user: 'southern_bvlt1'


    050617 8:39:57 [ERROR] /usr/sbin/mysqld: Forcing close of thread 33 user: 'root'


    Number of processes running now: 12
    050617 08:40:34 mysqld restarted
    050617 8:40:34 [Warning] Asked for 196608 thread stack, but got 126976
    /usr/sbin/mysqld: ready for connections.
    Version: '4.1.11-standard' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition - Standard (GPL)
    A mysqld process already exists at Fri Jun 17 08:40:34 EDT 2005
    050617 8:40:47 [Note] /usr/sbin/mysqld: Normal shutdown

    050617 8:40:47 [Note] /usr/sbin/mysqld: Shutdown complete

    050617 08:42:54 mysqld started
    050617 8:42:55 [Warning] Asked for 196608 thread stack, but got 126976
    /usr/sbin/mysqld: ready for connections.
    Version: '4.1.11-standard' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition - Standard (GPL)
     
  3. ecoutez

    ecoutez Well-Known Member

    Joined:
    May 23, 2002
    Messages:
    152
    Likes Received:
    0
    Trophy Points:
    0
    Same thing here...

    /var/lib/mysql no longer has databases in it! Did cPanel attempt to do something to 'upgrade' or something? We run very large databases by normal cPanel standards (say around 900mb) but never had a problem in the past.

    /var/lib/mysql/servername.err shows some interesting stuff last night:
    050617 1:03:14 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
    050617 1:03:15 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
    mysqld got signal 11;
    This could be because you hit a bug. It is also possible that this binary
    or one of the libraries it was linked against is corrupt, improperly built,
    or misconfigured. This error can also be caused by malfunctioning hardware.
    We will try our best to scrape up some info that will hopefully help diagnose
    the problem, but since we have already crashed, something is definitely wrong
    and this may fail.

    key_buffer_size=8388600
    read_buffer_size=131072
    max_used_connections=55
    max_connections=500
    threads_connected=1
    It is possible that mysqld could use up to
    key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 1096188 K
    bytes of memory
    Hope that's ok; if not, decrease some variables in the equation.

    thd=0x42200440
    Attempting backtrace. You can use the following information to find out
    where mysqld died. If you see no messages after this, something went
    terribly wrong...
    Cannot determine thread, fp=0xbfe7f378, backtrace may not be correct.
    Stack range sanity check OK, backtrace follows:
    0x8072da4
    0x826d468
    0x82963b9
    0x8296253
    0x8252006
    0x82525cc
    0x80b74fa
    0x80b76e3
    0x8082e42
    0x807d78c
    0x807cbfe
    0x807c428
    0x826ac1c
    0x82a0aca
    New value of fp=(nil) failed sanity check, terminating stack trace!
    Please read http://dev.mysql.com/doc/mysql/en/Using_stack_trace.html and follow instructions on how to resolve the stack trac
    e. Resolved
    stack trace is much more helpful in diagnosing the problem, so please do
    resolve it
    Trying to get some variables.
    Some pointers may be invalid and cause the dump to abort...
    thd->query at (nil) is invalid pointer
    thd->thread_id=124864
    The manual page at http://www.mysql.com/doc/en/Crashing.html contains
    information that should help you find out what is causing the crash.

    Number of processes running now: 0
    050617 01:03:15 mysqld restarted
    050617 1:03:15 Warning: Asked for 196608 thread stack, but got 126976
    050617 1:03:16 InnoDB: Database was not shut down normally.
    InnoDB: Starting recovery from log files...
    InnoDB: Starting log scan based on checkpoint at
    InnoDB: log sequence number 0 43932
    InnoDB: Doing recovery: scanned up to log sequence number 0 43932
    050617 1:03:17 InnoDB: Flushing modified pages from the buffer pool...
    050617 1:03:17 InnoDB: Started
    050617 1:03:17 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
    050617 1:03:17 Aborting

    050617 1:03:17 InnoDB: Starting shutdown...
    050617 1:03:19 InnoDB: Shutdown completed
    050617 1:03:19 /usr/sbin/mysqld: Shutdown Complete

    050617 01:03:19 mysqld ended

    050617 01:07:56 mysqld started
    050617 1:07:56 Warning: Asked for 196608 thread stack, but got 126976
    050617 1:07:57 InnoDB: Started
    050617 1:07:57 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
    050617 1:07:57 Aborting
     
  4. ecoutez

    ecoutez Well-Known Member

    Joined:
    May 23, 2002
    Messages:
    152
    Likes Received:
    0
    Trophy Points:
    0
    FYI:
    cPane Version 10.2.0-R82
    RH 7.3

    I opened a ticket with our data center and asked them to open one with cPanel (since it seems datacenter licensed user can no longer open support tickets with cpanel directly.) :(

    - Was anything done by cPanel that would cause this? Two people reporting such a strange thing at the same time seems... well, strange. Perhaps not a coincidence.

    - And if so, is there somewhere I should be looking for a dump or other backup that cpanel might have created before doing its job? We're recovering manually from a not-that-recent backup now and will see how bad things look...
     
  5. Secret Agent

    Secret Agent Guest

    No response from any tech?
     
  6. chirpy

    chirpy Well-Known Member

    Joined:
    Jun 15, 2002
    Messages:
    13,475
    Likes Received:
    20
    Trophy Points:
    38
    Location:
    Go on, have a guess
    Tech from where? cPanel? This is not a place to get support from cPanel - as I've said many times. If you want a cPanel tech to respond to an issue that you have you need to log a support ticket with cPanel or through your license provider. Then feel free to post their recommendations here if you want.
     
Loading...

Share This Page