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
-------------------------------------------------------------------------
E S C R I B A I N F O R M A T I C A
-------------------------------------------------------------------------
The only stupid question is the unasked one (somewhere in Linux's HowTo)
Linux registred user : #230601
-- ICQ : 221602060
$ look into "my eyes" Phone : +55 041 296-2311 r.112
look: cannot open my eyes Fax : +55 041 296-6640
-------------------------------------------------------------------------
Reply: [EMAIL PROTECTED]
---------------------------------------------------------------------
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
