[prev in list] [next in list] [prev in thread] [next in thread]
List: mysql
Subject: Mysql server [ERROR] Can't create interrupt-thread (error 22, errno: 22)
From: cdurepo () durepo ! homedns ! org
Date: 2009-02-24 15:13:38
Message-ID: 20090224151338.224CC1BF219 () cypher ! durepo ! net
[Download RAW message or body]
> Description:
I am running unstable and I did an upgrade on Monday the 23. When I did this it \
upgraded mysql-server-5.0. Once the upgrade was done mysql would not start. I then \
did a dist-upgrade and mysql-server will still not start. This is the version it is \
trying to install: mysql-server-5.0_5.0.77-1_i386.deb
Here is what I get as output during install:
<standard out>
Reading package lists... Done
Building dependency tree
Reading state information... Done
mysql-server-5.0 is already the newest version.
mysql-server-5.0 set to manually installed.
0 upgraded, 0 newly installed, 0 to remove and 3 not upgraded.
1 not fully installed or removed.
After this operation, 0B of additional disk space will be used.
Setting up mysql-server-5.0 (5.0.77-1) ...
Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing mysql-server-5.0 (--configure):
subprocess post-installation script returned error exit status 1
Errors were encountered while processing:
mysql-server-5.0
E: Sub-process /usr/bin/dpkg returned an error code (1)
</standard out>
Here is what I get from syslog:
<syslog>
Feb 24 09:48:44 cypher mysqld_safe[14779]: 090224 9:48:44 [ERROR] Can't create \
interrupt-thread (error 22, errno: 22)
Feb 24 09:48:44 cypher mysqld_safe[14779]: Installation of system tables failed!
Feb 24 09:48:44 cypher mysqld_safe[14779]:
Feb 24 09:48:44 cypher mysqld_safe[14779]: Examine the logs in /var/lib/mysql for \
more information.
Feb 24 09:48:44 cypher mysqld_safe[14779]: You can try to start the mysqld daemon \
with:
Feb 24 09:48:44 cypher mysqld_safe[14779]: /usr/sbin/mysqld --skip-grant &
Feb 24 09:48:44 cypher mysqld_safe[14779]: and use the command line tool
Feb 24 09:48:44 cypher mysqld_safe[14779]: /usr/bin/mysql to connect to the mysql
Feb 24 09:48:44 cypher mysqld_safe[14779]: database and look at the grant tables:
Feb 24 09:48:44 cypher mysqld_safe[14779]:
Feb 24 09:48:44 cypher mysqld_safe[14779]: shell> /usr/bin/mysql -u root mysql
Feb 24 09:48:44 cypher mysqld_safe[14779]: mysql> show tables
Feb 24 09:48:44 cypher mysqld_safe[14779]:
Feb 24 09:48:44 cypher mysqld_safe[14779]: Try 'mysqld --help' if you have problems \
with paths. Using --log
Feb 24 09:48:44 cypher mysqld_safe[14779]: gives you a log in /var/lib/mysql that may \
be helpful.
Feb 24 09:48:44 cypher mysqld_safe[14779]:
Feb 24 09:48:44 cypher mysqld_safe[14779]: The latest information about MySQL is \
available on the web at
Feb 24 09:48:44 cypher mysqld_safe[14779]: http://www.mysql.com
Feb 24 09:48:44 cypher mysqld_safe[14779]: Please consult the MySQL manual section: \
'Problems running mysql_install_db',
Feb 24 09:48:44 cypher mysqld_safe[14779]: and the manual section that describes \
problems on your OS.
Feb 24 09:48:44 cypher mysqld_safe[14779]: Another information source is the MySQL \
email archive.
Feb 24 09:48:44 cypher mysqld_safe[14779]: Please check all of the above before \
mailing us!
Feb 24 09:48:44 cypher mysqld_safe[14779]: And if you do mail us, you MUST use the \
/usr/bin/mysqlbug script!
Feb 24 09:48:45 cypher mysqld_safe[14812]: 090224 9:48:45 [ERROR] Can't create \
interrupt-thread (error 22, errno: 22)
Feb 24 09:48:45 cypher mysqld_safe[14821]: 090224 9:48:45 [ERROR] Can't create \
interrupt-thread (error 22, errno: 22)
Feb 24 09:48:45 cypher mysqld_safe[14825]: 090224 9:48:45 [ERROR] Can't create \
interrupt-thread (error 22, errno: 22)
Feb 24 09:48:45 cypher mysqld_safe[14829]: 090224 9:48:45 [ERROR] Can't create \
interrupt-thread (error 22, errno: 22)
Feb 24 09:48:45 cypher mysqld_safe[14908]: started
Feb 24 09:48:45 cypher mysqld[14911]: InnoDB: Error: pthread_create returned 22
Feb 24 09:48:45 cypher mysqld_safe[14913]: ended
Feb 24 09:48:59 cypher /etc/init.d/mysql[15048]: 0 processes alive and \
'/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' \
resulted in
Feb 24 09:48:59 cypher /etc/init.d/mysql[15048]: ^G/usr/bin/mysqladmin: connect to \
server at 'localhost' failed
Feb 24 09:48:59 cypher /etc/init.d/mysql[15048]: error: 'Can't connect to local MySQL \
server through socket '/var/run/mysqld/mysqld.sock' (2)'
Feb 24 09:48:59 cypher /etc/init.d/mysql[15048]: Check that mysqld is running and \
that the socket: '/var/run/mysqld/mysqld.sock' exists!
Feb 24 09:48:59 cypher /etc/init.d/mysql[15048]:
</syslog>
when I try to run: InnoDB: Error: pthread_create returned 22
from the cmd line I get:
InnoDB: Error: pthread_create returned 22
I have skip-innodb set in my.cnf
I have tried to run: mysql_install_db
I get the same errors.
I am not sure what the problem is.
I am not sure if this is related but when I do a host I get errors too:
cypher:/# host google.com
host: isc_taskmgr_create: no available threads
> How-To-Repeat:
I have not done that yet. I would assume a debian unstable upgrade would do it.
> Fix:
Cannot find one.
> Submitter-Id: noname101
> Originator:
> Organization:
>
> MySQL support: none
> Synopsis: mysql server does not start with error [ERROR] Can't create \
> interrupt-thread (error 22, errno: 22)
> Severity: critical
> Priority: medium
> Category: mysql
> Class: sw-bug
> Release: mysql-5.0.77-1 ((Debian))
> C compiler: gcc (Debian 4.3.3-4) 4.3.3
> C++ compiler: g++ (Debian 4.3.3-4) 4.3.3
> Environment:
Debian unstable running on dual PIII's
System: Linux cypher 2.6.19.2-grsec #5 SMP Fri Aug 17 10:07:30 EDT 2007 i686 \
GNU/Linux
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc
GCC: Using built-in specs.
Target: i486-linux-gnu
Configured with: ../src/configure -v --with-pkgversion='Debian 4.3.3-4' \
--with-bugurl=file:///usr/share/doc/gcc-4.3/README.Bugs \
--enable-languages=c,c++,fortran,objc,obj-c++ --prefix=/usr --enable-shared \
--with-system-zlib --libexecdir=/usr/lib --without-included-gettext \
--enable-threads=posix --enable-nls --with-gxx-include-dir=/usr/include/c++/4.3 \
--program-suffix=-4.3 --enable-clocale=gnu --enable-libstdcxx-debug --enable-objc-gc \
--enable-mpfr --enable-targets=all --with-tune=generic --enable-checking=release \
--build=i486-linux-gnu --host=i486-linux-gnu --target=i486-linux-gnu Thread model: \
posix gcc version 4.3.3 (Debian 4.3.3-4)
Compilation info (call): CC='gcc' CFLAGS='-DBIG_JOINS=1 -O2 -fPIC' CXX='g++' \
CXXFLAGS='-DBIG_JOINS=1 -felide-constructors -fno-rtti -O2' LDFLAGS='' ASFLAGS='' \
Compilation info (used): CC='gcc' CFLAGS=' -DDBUG_OFF -DBIG_JOINS=1 -O2 -fPIC ' \
CXX='g++' CXXFLAGS=' -DDBUG_OFF -DBIG_JOINS=1 -felide-constructors -fno-rtti -O2 \
-fno-implicit-templates -fno-exceptions -fno-rtti ' LDFLAGS=' -rdynamic ' \
ASFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 11 2009-02-23 11:22 /lib/libc.so.6 -> libc-2.9.so
-rwxr-xr-x 1 root root 1311428 2009-02-22 16:17 /lib/libc-2.9.so
-rw-r--r-- 1 root root 2946402 2009-02-22 16:17 /usr/lib/libc.a
-rw-r--r-- 1 root root 238 2009-02-22 16:05 /usr/lib/libc.so
Configure command: ./configure '--build=i486-linux-gnu' '--host=i486-linux-gnu' \
'--prefix=/usr' '--exec-prefix=/usr' '--libexecdir=/usr/sbin' '--datadir=/usr/share' \
'--localstatedir=/var/lib/mysql' '--includedir=/usr/include' \
'--infodir=/usr/share/info' '--mandir=/usr/share/man' '--with-server-suffix=-1' \
'--with-comment=(Debian)' '--with-system-type=debian-linux-gnu' '--enable-shared' \
'--enable-static' '--enable-thread-safe-client' '--enable-assembler' \
'--enable-local-infile' '--with-big-tables' \
'--with-unix-socket-path=/var/run/mysqld/mysqld.sock' '--with-mysqld-user=mysql' \
'--with-libwrap' '--without-openssl' '--with-yassl' '--without-docs' '--with-bench' \
'--without-readline' '--with-extra-charsets=all' '--with-innodb' \
'--with-archive-storage-engine' '--with-csv-storage-engine' \
'--with-federated-storage-engine' '--with-blackhole-storage-engine' \
'--with-sphinx-storage-engine' '--without-embedded-server' '--with-ndbcluster' \
'--with-ndb-ccflags=-fPIC' '--with-ndb-shm' '--with out-ndb-sci' \
'--without-ndb-test' '--with-embedded-server' '--with-embedded-privilege-control' \
'--without-ndb-docs' 'build_alias=i486-linux-gnu' 'host_alias=i486-linux-gnu' \
'CC=gcc' 'CFLAGS=-DBIG_JOINS=1 -O2 -fPIC' 'LDFLAGS=' 'CPPFLAGS=' 'CXX=g++' \
'CXXFLAGS=-DBIG_JOINS=1 -felide-constructors -fno-rtti -O2' 'FFLAGS=-g -O2'
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=mysql-marcsub@progressive-comp.com
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic