Linode Forum
Linode Community Forums
 FAQFAQ    SearchSearch    MembersMembers      Register Register 
 LoginLogin [ Anonymous ] 
Post new topic  Reply to topic
Author Message
PostPosted: Mon Jun 13, 2005 11:36 am 
Offline
Senior Member

Joined: Sun Jul 20, 2003 8:29 am
Posts: 100
Website: http://www.ipo-australia.com
Location: Tropical Queensland, Australia
All of a sudden, I cant get mysql to start. Its looping with signal 11, filling up the logs with the output below. I'm running Redhat 9 & haven't changed the config in months.

Even worse I that I've found files like C:\windows\system32\shell64.dll under /var with modification dates in the last month.
Is this a mysql problem or have I been hacked?

----------
Number of processes running now: 0
050614 01:25:27 mysqld restarted
050614 1:25:28 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
050614 1:25:28 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 43634.
InnoDB: Doing recovery: scanned up to log sequence number 0 43634
050614 1:25:28 InnoDB: Flushing modified pages from the buffer pool...
050614 1:25:28 InnoDB: Started; log sequence number 0 43634
050614 1:25:28 Found an entry in the 'db' table with empty database name; Skipped
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=5242880
read_buffer_size=131072
max_used_connections=0
max_connections=100
threads_connected=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 427519 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.


Top
   
PostPosted: Tue Jun 14, 2005 6:02 am 
Offline
Newbie

Joined: Mon May 31, 2004 6:30 am
Posts: 3
gmt wrote:
All of a sudden, I cant get mysql to start. Its looping with signal 11, filling up the logs with the output below. I'm running Redhat 9 & haven't changed the config in months.


Same deal here. I rebooted the Debian Woody install, then can't get back in as the boot process (as seen from Lish) hangs at

Code:
Starting MySQL database server: mysqld


Also haven't touched MySQL in a long time (or done an apt-get upgrade for that matter). Really need this fixed fast, am opening a ticket and hoping for the best. I did the last reboot only about 20 minutes earlier, no problem then. Any ideas?


Top
   
PostPosted: Tue Jun 14, 2005 6:08 am 
Offline
Newbie

Joined: Mon May 31, 2004 6:30 am
Posts: 3
kris wrote:
Really need this fixed fast, am opening a ticket and hoping for the best. I did the last reboot only about 20 minutes earlier, no problem then. Any ideas?


Sorry, am sleep deprived and mushy brained. Obviously I can just boot in single user mode via Lish and get in to fix this myself.


Top
   
PostPosted: Tue Jun 14, 2005 6:54 am 
Offline
Newbie

Joined: Mon May 31, 2004 6:30 am
Posts: 3
Turns out the cause was 127M of MySQL logs that filled up the /var partition where is of course also were the MySQL databases reside. Minor data corruption, but could be restored. Moral of story: next time I'll partition even more aggressively. /var/log needs to be a separate partition.

Sorry for wasting your valuable time folks with this monologue. :oops:


Top
   
 Post subject:
PostPosted: Fri Jun 17, 2005 5:47 am 
Offline
Senior Member

Joined: Sun Jul 20, 2003 8:29 am
Posts: 100
Website: http://www.ipo-australia.com
Location: Tropical Queensland, Australia
I upgraded from Mysql 4.1beta to 4.1 production & all is fixed.


Top
   
Display posts from previous:  Sort by  
Post new topic  Reply to topic


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
RSS

Powered by phpBB® Forum Software © phpBB Group