mysql databases missing!

S

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?
 
S

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)
 

ecoutez

Well-Known Member
May 23, 2002
152
0
316
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
 

ecoutez

Well-Known Member
May 23, 2002
152
0
316
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...
 

chirpy

Well-Known Member
Verifed Vendor
Jun 15, 2002
13,437
31
473
Go on, have a guess
No response from any tech?
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.