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
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
