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
