From: Ross Crawford (ross.crawfordgmail.com)
Date: Sat Jan 12 2008 - 16:12:53 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hi,

My mysql server crashed last night, and when it rebooted, was unable to
restart. Here is the error log:

Jan 13 00:12:54 localhost mysqld_safe[1324]: started
Jan 13 00:12:55 localhost mysqld[1327]: 080113 0:12:55 InnoDB:
Database was not shut down normally!
Jan 13 00:12:55 localhost mysqld[1327]: InnoDB: Starting crash recovery.
Jan 13 00:12:55 localhost mysqld[1327]: InnoDB: Reading tablespace
information from the .ibd files...
Jan 13 00:12:55 localhost mysqld[1327]: InnoDB: Restoring possible
half-written data pages from the doublewrite
Jan 13 00:12:55 localhost mysqld[1327]: InnoDB: buffer...
Jan 13 00:12:56 localhost mysqld[1327]: 080113 0:12:56 InnoDB:
Starting log scan based on checkpoint at
Jan 13 00:12:56 localhost mysqld[1327]: InnoDB: log sequence number 0
111349.
Jan 13 00:12:56 localhost mysqld[1327]: InnoDB: Doing recovery: scanned
up to log sequence number 0 111349
Jan 13 00:12:56 localhost mysqld[1327]: InnoDB: Last MySQL binlog file
position 0 3587, file name /var/log/mysql/mysql-bin.000489
Jan 13 00:12:56 localhost mysqld[1327]: 080113 0:12:56 InnoDB:
Started; log sequence number 0 111349
Jan 13 00:12:56 localhost mysqld[1327]: 080113 0:12:56 [Note]
Recovering after a crash using /var/log/mysql/mysql-bin
Jan 13 00:12:56 localhost mysqld[1327]: 080113 0:12:56 [Note] Starting
crash recovery...
Jan 13 00:12:56 localhost mysqld[1327]: 080113 0:12:56 [Note] Crash
recovery finished.
Jan 13 00:12:57 localhost mysqld[1327]: 080113 0:12:57 [ERROR] Can't
start server: Bind on TCP/IP port: Cannot assign requested address
Jan 13 00:12:57 localhost mysqld[1327]: 080113 0:12:57 [ERROR] Do you
already have another mysqld server running on port: 3306 ?
Jan 13 00:12:57 localhost mysqld[1327]: 080113 0:12:57 [ERROR] Aborting
Jan 13 00:12:57 localhost mysqld[1327]:
Jan 13 00:12:57 localhost mysqld[1327]: 080113 0:12:57 InnoDB:
Starting shutdown...
Jan 13 00:12:59 localhost mysqld[1327]: 080113 0:12:59 InnoDB:
Shutdown completed; log sequence number 0 111349
Jan 13 00:12:59 localhost mysqld[1327]: 080113 0:12:59 [Note]
/usr/sbin/mysqld: Shutdown complete
Jan 13 00:12:59 localhost mysqld[1327]:
Jan 13 00:12:59 localhost mysqld_safe[1374]: ended

And since then I am unable to start it. mysqld_safe aborts with:

Starting mysqld daemon with databases from /var/lib/mysql
mysqld_safe[3150]: started
STOPPING server from pid file /var/run/mysqld/mysqld.pid
mysqld_safe[3164]: ended

And error file:

Jan 13 06:03:06 localhost mysqld_safe[1318]: started
Jan 13 06:03:08 localhost mysqld[1321]: 080113 6:03:08 InnoDB:
Started; log sequence number 0 111349
Jan 13 06:03:08 localhost mysqld[1321]: 080113 6:03:08 [ERROR] Can't
start server: Bind on TCP/IP port: Cannot assign requested address
Jan 13 06:03:08 localhost mysqld[1321]: 080113 6:03:08 [ERROR] Do you
already have another mysqld server running on port: 3306 ?
Jan 13 06:03:08 localhost mysqld[1321]: 080113 6:03:08 [ERROR] Aborting
Jan 13 06:03:08 localhost mysqld[1321]:
Jan 13 06:03:08 localhost mysqld[1321]: 080113 6:03:08 InnoDB:
Starting shutdown...
Jan 13 06:03:11 localhost mysqld[1321]: 080113 6:03:11 InnoDB:
Shutdown completed; log sequence number 0 111349
Jan 13 06:03:11 localhost mysqld[1321]: 080113 6:03:11 [Note]
/usr/sbin/mysqld: Shutdown complete
Jan 13 06:03:11 localhost mysqld[1321]:
Jan 13 06:03:11 localhost mysqld_safe[1368]: ended

Nothing is running on port 3306, telnet gets connection refused. No
mysql processes are running.

Does anyone have any ideas what might be wrong?

Thanks

ROSCO

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]