sbester@www:~> gcc bug29431.c -g -o bug29431 -L/home/sbester/server/5.0/mysql-5.0.46-linux-i686/lib -I/home/sbester/server/5.0/mysql-5.0.46-linux-i686/include   -lmysqlclient_r -lz -lpthread
sbester@www:~> ./bug29431 
running initializations..
about to spawn 30 threads
..............................
completed spawning new database worker threads .. running them for 10 seconds...
now about to spawn the killer thread...
query failed 'kill 4' : 1094 (Unknown thread id: 4)
kill failed
query failed 'kill 7' : 1094 (Unknown thread id: 7)
kill failed
query failed 'kill 9' : 1094 (Unknown thread id: 9)
kill failed
query failed 'kill 11' : 1094 (Unknown thread id: 11)
kill failed
query failed 'kill 15' : 1094 (Unknown thread id: 15)
kill failed
query failed 'kill 29' : 1094 (Unknown thread id: 29)
kill failed
query failed 'kill 32' : 1094 (Unknown thread id: 32)
kill failed
query failed 'kill 60' : 1094 (Unknown thread id: 60)
kill failed
query failed 'kill 75' : 1094 (Unknown thread id: 75)
kill failed
query failed 'kill 76' : 1094 (Unknown thread id: 76)
kill failed
query failed 'kill 81' : 1094 (Unknown thread id: 81)
kill failed
query failed 'kill 103' : 1094 (Unknown thread id: 103)
kill failed
query failed 'kill 109' : 1094 (Unknown thread id: 109)
kill failed
query failed 'kill 111' : 1094 (Unknown thread id: 111)
kill failed
query failed 'kill 116' : 1094 (Unknown thread id: 116)
kill failed
query failed 'kill 134' : 1094 (Unknown thread id: 134)
kill failed
query failed 'kill 123' : 1094 (Unknown thread id: 123)
kill failed
query failed 'kill 130' : 1094 (Unknown thread id: 130)
kill failed
query failed 'kill 157' : 2013 (Lost connection to MySQL server during query)
kill failed
can't get processlist. server died. 2006 (MySQL server has gone away)

sbester@www:~> 




sbester@www:~/server/5.0/mysql-5.0.44-linux-i686> ./bin/mysqld_safe --skip-grant-tables --skip-name-resolve --skip-innodb --back_log=1000 &
[1] 12112
sbester@www:~/server/5.0/mysql-5.0.44-linux-i686> Starting mysqld daemon with databases from /home/sbester/server/5.0/mysql-5.0.44-linux-i686/data
./bin/mysqld_safe: line 388: 12139 Killed                  nohup /home/sbester/server/5.0/mysql-5.0.44-linux-i686/bin/mysqld --basedir=/home/sbester/server/5.0/mysql-5.0.44-linux-i686 --datadir=/home/sbester/server/5.0/mysql-5.0.44-linux-i686/data --pid-file=/home/sbester/server/5.0/mysql-5.0.44-linux-i686/data/www.pid --skip-external-locking --skip-grant-tables --skip-name-resolve --skip-innodb --back_log\=1000 >>/home/sbester/server/5.0/mysql-5.0.44-linux-i686/data/www.err 2>&1

Number of processes running now: 8
kill: usage: kill [-s sigspec | -n signum | -sigspec] [pid | job]... or kill -l [sigspec]
070629 00:38:26  mysqld restarted




Number of processes running now: 2
070628 23:13:26  mysqld restarted
070628 23:13:26  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
070628 23:13:26  InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 128200719.
InnoDB: Doing recovery: scanned up to log sequence number 0 128200719
InnoDB: Last MySQL binlog file position 0 251596271, file name /home/sbester/server/5.0/mysql-5.0.46-linux-i686/data/www-bin.000003
070628 23:13:26  InnoDB: Started; log sequence number 0 128200719
070628 23:13:26 [Note] /home/sbester/server/5.0/mysql-5.0.46-linux-i686/bin/mysqld: ready for connections.
Version: '5.0.46-debug'  socket: '/tmp/mysql.sock'  port: 3306  yes

Number of processes running now: 4
070628 23:16:51  mysqld restarted
070628 23:16:51  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
070628 23:16:51  InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 128200719.
InnoDB: Doing recovery: scanned up to log sequence number 0 128200719
InnoDB: Last MySQL binlog file position 0 251596271, file name /home/sbester/server/5.0/mysql-5.0.46-linux-i686/data/www-bin.000003
070628 23:16:52  InnoDB: Started; log sequence number 0 128200719
070628 23:16:52 [Note] /home/sbester/server/5.0/mysql-5.0.46-linux-i686/bin/mysqld: ready for connections.
Version: '5.0.46-debug'  socket: '/tmp/mysql.sock'  port: 3306  yes
070628 23:22:24 [Note] /home/sbester/server/5.0/mysql-5.0.46-linux-i686/bin/mysqld: Normal shutdown

070628 23:22:24  InnoDB: Starting shutdown...
070628 23:22:26  InnoDB: Shutdown completed; log sequence number 0 128200719
070628 23:22:26 [Note] /home/sbester/server/5.0/mysql-5.0.46-linux-i686/bin/mysqld: Shutdown complete

070628 23:22:26  mysqld ended