MySQL Forums
Forum List  »  Newbie

pthread_create returned 12
Posted by: lyker Zooky
Date: February 18, 2009 05:32AM

The mysql server can not boot after a crash, how to fix it? see the booting logs below,


Feb 18 19:18:22 colinux mysqld_safe[15093]: started
Feb 18 19:18:23 colinux mysqld[15096]: InnoDB: The log sequence number in ibdata
files does not match
Feb 18 19:18:23 colinux mysqld[15096]: InnoDB: the log sequence number in the ib
_logfiles!
Feb 18 19:18:23 colinux mysqld[15096]: 090218 19:18:22 InnoDB: Database was not
shut down normally!
Feb 18 19:18:23 colinux mysqld[15096]: InnoDB: Starting crash recovery.
Feb 18 19:18:23 colinux mysqld[15096]: InnoDB: Reading tablespace information fr
om the .ibd files...
Feb 18 19:18:23 colinux mysqld[15096]: InnoDB: Restoring possible half-written d
ata pages from the doublewrite
Feb 18 19:18:23 colinux mysqld[15096]: InnoDB: buffer...
Feb 18 19:18:24 colinux mysqld[15096]: InnoDB: Error: pthread_create returned 12
Feb 18 19:18:24 colinux mysqld_safe[15111]: ended
Feb 18 19:18:38 colinux /etc/init.d/mysql[15254]: 0 processes alive and '/usr/bi
n/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Feb 18 19:18:38 colinux /etc/init.d/mysql[15254]: ^G/usr/bin/mysqladmin: connect
to server at 'localhost' failed
Feb 18 19:18:38 colinux /etc/init.d/mysql[15254]: error: 'Can't connect to local
MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Feb 18 19:18:38 colinux /etc/init.d/mysql[15254]: Check that mysqld is running a
nd that the socket: '/var/run/mysqld/mysqld.sock' exists!

Options: ReplyQuote


Subject
Written By
Posted
pthread_create returned 12
February 18, 2009 05:32AM
February 19, 2009 08:58PM
February 19, 2009 09:22PM
February 20, 2009 07:41AM
February 20, 2009 11:04PM
February 22, 2009 08:38PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.