Cliff, I do not think this is a threading issue. This looks now more like a wrong .frm file problem. Please use innodb_table_monitor as I suggested earlier, and compare the table definition inside InnoDB to what SHOW CREATE TABLE says.
Best regards, Heikki Innobase Oy InnoDB - transactions, row level locking, and foreign keys for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb.com/order.php Register now for the 2004 MySQL Users Conference! http://www.mysql.com/events/uc2004/index.html .............. List: MySQL General Discussion« Previous MessageNext Message » From: Cliff Date: March 5 2004 8:12am Subject: Re: Major problem converting MyISAM to InnoDB I think I may have gotten closer to the root of the problem. It seems that the field named 'comments' is the one that crashes the server when it is selected. Here is the output of the logs when I do 'select comments from allusa': 040304 23:14:52 mysqld restarted 040304 23:14:53 InnoDB: Started /mnt/disk2/mysql/bin/mysqld: ready for connections. Version: '4.0.18-standard-log' socket: '/tmp/mysql.sock' port: 3306 Fatal error '_waitq_remove: Not in queue' at line ? in file /usr/src/lib/libc_r/uthread/uthread_priority_queue.c (errno = ?) Number of processes running now: 0 I searched google and it seems that error has been seen in many programs since it is a threading issue. Any ideas on what would cause this? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
