Dyego, did you compile MySQL yourself and are using a debug version of mysqld?
The assertion is a DBUG_ASSERT which is only present in the debug version. It fails because an earlier version of MySQL internally assigned a UNIQUE key as the primary key of the table, but InnoDB was not aware of it. I have now removed that DBUG_ASSERT from 4.0.12. You should use a non-debug version of mysqld to convert your table, like it advises below. Regards, Heikki Innobase Oy sql query ................... Subject: The Error in INNODb with MySQL 4.0.11 From: Dyego Souza do Carmo Date: Wed, 26 Feb 2003 14:36:01 -0300 I'm using MySQL-PRO 4.0.11 and I have a error on SELEC/DROP/ALTER/INSERT one specific table: Version: '4.0.11-gamma-debug-log' socket: '/tmp/mysql.sock' port: 3306 InnoDB: Error: table ./webescriba/webtest has no primary key in InnoDB InnoDB: data dictionary, but has one in MySQL! InnoDB: If you created the table with a MySQL InnoDB: version < 3.23.54 and did not define a primary InnoDB: key, but defined a unique key with all non-NULL InnoDB: columns, then MySQL internally treats that key InnoDB: as the primary key. You can fix this error by InnoDB: dump + DROP + CREATE + reimport of the table. mysqld: ha_innodb.cc:1266: int ha_innobase::open(const char *, int, unsigned int): Assertion `key_used_on_scan == 32' failed. Number of processes running now: 1 mysqld process hanging, pid 1776 - killed 030226 14:29:36 mysqld restarted 030226 14:29:38 InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 10 3177927546 InnoDB: Doing recovery: scanned up to log sequence number 10 3177927556 030226 14:29:38 InnoDB: Flushing modified pages from the buffer pool... 030226 14:29:38 InnoDB: Started /usr/local/mysql4/libexec/mysqld: ready for connections. Version: '4.0.11-gamma-debug-log' socket: '/tmp/mysql.sock' port: 3306 Nothing command work with this table... de DROP causes the die of MySQL server... This bug is very strange ! Heiiki , is a InnoDB bug ? sql,query ------------------------------------------------------------------------- ++ Dyego Souza do Carmo ++ Dep. Desenvolvimento --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
