>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=arch...@jab.org