Show you results of ps aux | grep mysql | grep -v grep On Jan 14, 2008 11:41 PM, <[EMAIL PROTECTED]> wrote:
> Or maybe the pid is still existing? > > -----Original Message----- > From: Ross Crawford [mailto:[EMAIL PROTECTED] > Sent: Saturday, January 12, 2008 5:13 PM > To: mysql@lists.mysql.com > Subject: Unable to restart after crash > > 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] > > > > -------------------------------------------------------------------------------------------------------- > This message and any files transmitted with it are confidential and > intended solely for the use of the individual or entity to whom it is > addressed. It may contain sensitive and private proprietary or legally > privileged information. No confidentiality or privilege is waived or > lost by any mistransmission. If you are not the intended recipient, > please immediately delete it and all copies of it from your system, > destroy any hard copies of it and notify the sender. You must not, > directly or indirectly, use, disclose, distribute, print, or copy any > part of this message if you are not the intended recipient. > FXDirectDealer, LLC reserves the right to monitor all e-mail > communications through its networks. Any views expressed in this > message are those of the individual sender, except where the > message states otherwise and the sender is authorized to state them. > > Unless otherwise stated, any pricing information given in this message > is indicative only, is subject to change and does not constitute an > offer to deal at any price quoted. Any reference to the terms of > executed transactions should be treated as preliminary only and subject > to our formal confirmation. FXDirectDealer, LLC is not responsible for any > recommendation, solicitation, offer or agreement or any information > about any transaction, customer account or account activity contained in > this communication. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- I'm a mysql DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn