List:General Discussion« Previous MessageNext Message »
From:Heikki Tuuri Date:March 5 2004 6:01pm
Subject:Re: Major problem converting MyISAM to InnoDB
View as plain text  
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?

Thread
Major problem converting MyISAM to InnoDBCliff4 Mar
  • Re: Major problem converting MyISAM to InnoDBSasha Pachev4 Mar
Re: Major problem converting MyISAM to InnoDBHeikki Tuuri4 Mar
Re: Major problem converting MyISAM to InnoDBCliff4 Mar
Re: Major problem converting MyISAM to InnoDBMartijn Tonies4 Mar
Re: Major problem converting MyISAM to InnoDBHeikki Tuuri4 Mar
Re: Major problem converting MyISAM to InnoDBCliff4 Mar
Re: Major problem converting MyISAM to InnoDBCliff5 Mar
  • Re: Major problem converting MyISAM to InnoDBSasha Pachev5 Mar
Re: Major problem converting MyISAM to InnoDBHeikki Tuuri5 Mar
Re: Major problem converting MyISAM to InnoDBCliff7 Mar