Which version of mysql are you using? In mysql 4, you could get away with some differences between the definition of the merge table and the underlying tables.
As you've discovered, the structure and index definitions must now be exactly the same, otherwise you will get errors. Regards, Gavin Towey -----Original Message----- From: stutiredboy [mailto:stutired...@gmail.com] Sent: Tuesday, August 25, 2009 12:23 AM To: mysql@lists.mysql.com Subject: Got error 124 from storage engine hi, all: i have met an question as below: table A1,A2 A1 has been *packed by myisampack, and rebuild the index by myisamchk* A2 is a noraml table, and the struct of A1 and A2 is exactlly same talbe A is the merge table of A1 and A2 while i use: * mysql> select max(id) from A; ** ERROR 1030 (HY000): Got error 124 from storage engine +---------------+-----------------------+------+-----+-------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+-----------------------+------+-----+-------------------+----------------+ | id | bigint(20) unsigned | NO | MUL | NULL | auto_increment | *but when i try another table, the situation is as before, such as table B1,B2,B * mysql> select max(id) from loot; +---------+ | max(id) | +---------+ | 110415 | +---------+ 1 row in set (0.00 sec) * the only difference is (*table A the id Field is auto_increment and table B the id is not*): *+-------+-----------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+-----------------------+------+-----+---------+-------+ | id | bigint(20) unsigned | NO | MUL | NULL | | *and if i do not use myisampack/myisamchk, all are work fine, *our system is freebsd 7.2, the mysql version is 5.0.84 Server version: 5.0.84 Source distribution * thanks for your reply tiredboy ** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=gto...@ffn.com The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
