LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 05-14-2008, 05:39 AM   #1
alee
LQ Newbie
 
Registered: May 2008
Posts: 28

Rep: Reputation: 15
unable to start mysql


hi,

I was having issue with ibdata1 file which had grown to 5GB on the server machine. so after reading couple of blogs, i got the way how to remove it. i backedup my DB's, stopped the mysql and deleted that ibdata1 file.

now after that, i am unable to run mysql in ANYWAY!. I have searched accross the boards, across the blogs and i am still unable to figure out the problem.

every time i start it gives me following error
Code:
[root@server init.d]# /etc/init.d/mysqld start
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL:                                            [FAILED]
and here is my my.cnf file
Code:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
max_connections=50
table_cache=1000
thread_cache_size=40
thread_stack=100K
wait_timeout=10
join_buffer=2M
myisam_sort_buffer_size=6M
query_cache_size=6M
read_rnd_buffer_size=2M
#i wrote this line to recover, but failed. innodb_force_recovery=4

[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
 
Old 05-14-2008, 05:44 AM   #2
grumbl
LQ Newbie
 
Registered: Jan 2008
Location: The Netherlands
Distribution: Red Hat/Fedora, Suse, Studio64, etc...
Posts: 9

Rep: Reputation: 0
Maybe i am asking the obvious, but what does err-log say, and what other troubleshooting have you already carried out ?
 
Old 05-14-2008, 05:55 AM   #3
alee
LQ Newbie
 
Registered: May 2008
Posts: 28

Original Poster
Rep: Reputation: 15
well, tried to start the server with force recovery and what else? i was not able to figure out any other troubleshooting.

here i am gonna post the mysql-log file.

(log file is too large, posting in 2 posts)

Code:
080514 03:00:35  mysqld started
080514  3:00:35  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...
080514  3:00:35  InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 1 1319257103.
InnoDB: Doing recovery: scanned up to log sequence number 1 1319257103
InnoDB: Page directory corruption: supremum not pointed to
080514  3:00:35  InnoDB: Page dump in ascii and hex (16384 bytes):
 len 16384; hex
 
Old 05-14-2008, 05:56 AM   #4
alee
LQ Newbie
 
Registered: May 2008
Posts: 28

Original Poster
Rep: Reputation: 15
Code:
<removed hex 0 manually>; 

asc                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 ;InnoDB: End of page dump
080514  3:00:35  InnoDB: Page checksum 1575996416, prior-to-4.0.14-form checksum 1371122432
InnoDB: stored checksum 0, prior-to-4.0.14-form stored checksum 0
InnoDB: Page lsn 0 0, low 4 bytes of lsn at page end 0
InnoDB: Page number (if stored to page already) 0,
InnoDB: space id (if created with >= MySQL-4.1.1 and stored already) 0
InnoDB: Page directory corruption: supremum not pointed to
080514  3:00:35  InnoDB: Page dump in ascii and hex (16384 bytes):
 len 16384; hex 

<removed hex 0 manually>;

 asc     
;InnoDB: End of page dump
080514  3:00:35  InnoDB: Page checksum 1575996416, prior-to-4.0.14-form checksum 1371122432
InnoDB: stored checksum 0, prior-to-4.0.14-form stored checksum 0
InnoDB: Page lsn 0 0, low 4 bytes of lsn at page end 0
InnoDB: Page number (if stored to page already) 0,
InnoDB: space id (if created with >= MySQL-4.1.1 and stored already) 0
080514  3:00:35InnoDB: Error: trying to access a stray pointer 0x35c57ff8
InnoDB: buf pool start is at 0xb5c48000, end at 0xb6448000
InnoDB: Probable reason is database corruption or memory
InnoDB: corruption. 
080514  3:00:35InnoDB: Assertion failure in thread 3081860800 in file ./../include/buf0buf.ic line 262
key_buffer_size=0
read_buffer_size=131072
max_used_connections=0
max_connections=50
threads_connected=0
It is possible that mysqld could use up to 
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 108799 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

thd=(nil)
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=0xbfff9d7c, backtrace may not be correct.
Stack range sanity check OK, backtrace follows:
0x8130bff
0xb7e653e8
(nil)
0x82fcb74
0x829b52f
0x829c044
0x8282f66
0x82811dc
0x81b6a81
0x81a9537
0x812f485
0x8132cdb
0xb7bf5d5f
0x80d0161
New value of fp=(nil) failed sanity check, terminating stack trace!
080514 03:00:35  mysqld ended
 
  


Reply

Tags
mysql, mysqldb


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
unable to connect to mysql djib Linux - Software 7 03-08-2007 09:03 PM
Starting MySQL OLD Error : imeout error occurred trying to start MySQL Daemon Fr33B5D Linux - Software 9 10-28-2006 06:23 AM
MySQL - Timeout error occurred trying to start MySQL Daemon. stuartornum Linux - Software 3 02-26-2006 12:54 PM
MySQL - Warning: mysql_result(): Unable to jump to row 0 on MySQL result index 9 jasontn Linux - Software 0 02-09-2005 12:17 PM
MySql error 2002, Cannot start mysql djchris Linux - Software 5 04-13-2004 06:12 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 04:40 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration