View Single Post
  #1   (View Single Post)  
Old 24th May 2008
zeltus zeltus is offline
New User
 
Join Date: May 2008
Posts: 3
Default MySQL 5.1 install - daemon crashes

This is a new thread based on my earlier one - I have tried deinstalling/reinstalling package MySQL but the mysqld daemon still crashes as fast as I can start it. mysqld_safe continually loops, which makes for fun and games trying to kill it off, but

#/usr/local/libexec/mysqld can be called direct... this throws out

zeltus# ./mysqld --user=mysql &
[2] 68492
[1] Exit 1 mysqld --user=mysql
jail0087# 080524 8:52:38 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...
080524 8:52:38 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 46409.
InnoDB: Doing recovery: scanned up to log sequence number 0 46409
080524 8:52:38 InnoDB: Started; log sequence number 0 46409
080524 8:52:38 [Note] Recovering after a crash using mysql-bin
080524 8:52:38 [Note] Starting crash recovery...
080524 8:52:38 [Note] Crash recovery finished.
080524 8:52:38 [Note] Event Scheduler: Loaded 0 events
080524 8:52:38 [Note] ./mysqld: ready for connections.
Version: '5.1.20-beta-log' socket: '/tmp/mysql.sock' port: 3306 FreeBSD port: mysql-server-5.1.20
[2] Done ./mysqld --user=mysql

Unfortunately, this is all I have achieved so far re diagnostics.. and other than telling me that mysqld died suddenly, I haven't got much else.

Can anyone else suggest what I might do now to get this up and running? I have no idea what I have to do to get mysqld to tell me why it is crashing... and it's all getting a bit frustrating. Sigh.

Cheers

Bill
Reply With Quote