Mysql Error 124
Reporter: Elena Stepanova Email Updates: Status: Closed Impact on me: None Category:MySQL Server: Partitions Severity:S3 (Non-critical) Version:5.5.28, 5.6.9 OS:Any Assigned to: Mattias Jonsson Triage: Needs Triage: D2 (Serious) View Add Comment Files Developer Edit Submission View Progress Log Contributions [27 Dec 2012 23:45] Elena Stepanova Description: CREATE TABLE IF NOT EXISTS t1 ( a INT, b INT, KEY(b) ) ENGINE = MYISAM PARTITION BY LIST (a) ( PARTITION p0 VALUES IN (1, NULL), PARTITION p1 VALUES IN (4, 6, 3), PARTITION p2 VALUES IN (8, 2, 5) ); INSERT INTO t1 VALUES (5,0), (6,3), (4,9), (8,4); ALTER TABLE t1 DISABLE KEYS; ALTER TABLE t1 REBUILD PARTITION p1; bug.mdev3978-4 [ fail ] Test ended at 2012-12-28 03:44:31 CURRENT_TEST: bug.mdev3978-4 mysqltest: At line 12: query 'DELETE FROM t1 WHERE a = 8 ORDER BY b, a LIMIT 1' failed: 1030: Got error 124 from storage engine Could not reproduce on MySQL 5.1. How to repeat: --source include/have_partition.inc CREATE TABLE IF NOT EXISTS t1 ( a INT, b INT, KEY(b) ) ENGINE = MYISAM PARTITION BY LIST (a) ( PARTITION p0 VALUES IN (1, NULL), PARTITION p1 VALUES IN (4, 6, 3), PARTITION p2 VALUES IN (8, 2, 5) ); INSERT INTO t1 VALUES (5,0), (6,3), (4,9), (8,4); ALTER TABLE t1 DISABLE KEYS; ALTER TABLE t1 REBUILD PARTITION p1; DELETE FROM t1 WHERE a = 8 ORDER BY b, a LIMIT 1; [28 Dec 2012 0:05] Miguel Solorzano Thank you for the bug report. d:\dbs>d:\dbs\5.5\bin\mysql -uroot --port=3541 --prompt="mysql 5.5 >" Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 Server version: 5.5.30 Source distribution Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql 5.5 >use d1 Database changed mysql 5.5 >CREATE TABLE IF NOT EXISTS t1 ( a INT, b INT, KEY(b) ) -> ENGINE = MYISAM PARTITION BY LIST (a) ( -> PARTITION p0 VALUES IN (1, NULL), -> PARTITION p1 VALUES IN (4, 6, 3), -> PARTITION p2 VALUES IN (8, 2, 5) -> ); Query OK, 0 rows affected (0.10 sec) mysql 5.5 >INSERT INTO t1 VALUES (5,0), (6,3), (4,9), (8,4); Query OK, 4 rows affected (0.02 sec) Records: 4 Duplicates: 0 Warnings: 0 mysql 5.5 >ALTER TABLE t1 DISABLE KEYS; Query OK, 0 rows affected (0.00 sec) mysql 5.5 >ALTER TABLE t1 REBUILD PARTITION p1; Query OK, 2 rows affected (0.06 sec) Records: 2 Duplicates: 0 Warnings: 0 mysql 5.5 >DELETE FROM t1 WHERE a = 8 ORDER BY b, a LIMIT 1; ERROR 1030 (HY000): Got error 124 fro
8:57 Reporter: Roel Van de Paar (OCA) Email Updates: Status: Closed Impact on me: None Category:MySQL Server: Partitions Severity:S1 (Critical) Version:5.1.36 OS:Any Assigned to: Mattias Jonsson Triage: Triaged: D2 (Serious) View Add Comment Files Developer Edit Submission View Progress Log Contributions [10 Aug 2009 22:51] Roel Van de Paar Description: mysql> INSERT INTO met (tmin, mid, nid,cid, aid, val) SELECT 1, 399, 0,1,1,1 FROM met MD, vmm VM WHERE MD.mid = VM.mid; ERROR 1030 (HY000): Got error 124 from storage engine Repeatable testcase below. If the first index is dropped, it works fine: mysql> ALTER TABLE met DROP INDEX `mid`; Query OK, 2 rows affected (0.11 sec) Records: 2 Duplicates: 0 Warnings: 0 mysql> INSERT INTO met https://bugs.mysql.com/bug.php?id=67982 (tmin, mid, nid,cid, aid, val) SELECT 1, 399, 0,1,1,1 FROM met MD, vmm VM WHERE MD.mid = VM.mid; Query OK, 1 row affected (0.10 sec) Records: 1 Duplicates: 0 Warnings: 0 How to repeat: CREATE TABLE vmm (vmid int not null, mid int not null) ENGINE=InnoDB; CREATE TABLE met (tmin integer NOT NULL, mid int NOT NULL, nid int NOT NULL, cid int NOT NULL, aid int NOT NULL, val bigint NOT NULL ,INDEX(mid) ,INDEX(tmin,mid,nid, cid) ,INDEX(tmin, mid, https://bugs.mysql.com/bug.php?id=46639 cid) ) ENGINE=MYISAM, AVG_ROW_LENGTH=60, MAX_ROWS=4000000000 PARTITION BY LIST( ((tmin DIV 60) MOD 24) ) ( PARTITION hour0to3 VALUES IN (0,1,2,3), PARTITION hour4to7 VALUES IN (4,5,6,7), PARTITION hour8to11 VALUES IN (8,9,10,11), PARTITION hour12to15 VALUES IN (12,13,14,15), PARTITION hour16to19 VALUES IN (16,17,18,19), PARTITION hour20to23 VALUES IN (20,21,22,23) ); INSERT INTO vmm VALUES (399, 22); INSERT INTO met values (1, 22, 0, 1, 1,1), (1, 42, 0, 1, 1,1); INSERT INTO met (tmin, mid, nid,cid, aid, val) SELECT 1, 399, 0,1,1,1 FROM met MD, vmm VM WHERE MD.mid = VM.mid; [10 Aug 2009 22:54] Roel Van de Paar Verifying as D2 [10 Aug 2009 22:57] Roel Van de Paar Also see bug #44657 [11 Aug 2009 0:18] Roel Van de Paar Customer reported another workaround: 'If each partition has at least one row, then everything is ok.' [13 Aug 2009 16:15] Sinisa Milivojevic errno 124 is returned as "Wrong medium type", which is wrong in this case. Correct errno text is "Wrong index given to function". One thing to be checked here is whether result set from SELECT is first correctly stored in a temporary table. [17 Aug 2009 3:09] Roel Van de Paar Possible workaround may be to use a temporary table: mysql> create table testtemp(a int, b int, c int, d int, e int, f int); Query OK, 0 rows affected (0.01 sec) mysql> INSERT INTO testtemp (a,b,c,d,e,f) SELECT 1, 399, 0,1,1,1 FROM
been *packed by myisampack, and rebuild the index by myisamchk*A2 is a noraml table, and the struct of A1 and A2 is exactlly sametalbe A is the merge table of A1 http://grokbase.com/t/mysql/mysql/098s2jq3m3/got-error-124-from-storage-engine and A2while i use:*mysql> select max(id) from A;** ERROR 1030 (HY000): Got error http://www.tek-tips.com/viewthread.cfm?qid=1326847 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 tableB1,B2,B*mysql> select max(id) from loot;+---------+max(id) |+---------+110415 |+---------+1 row in set (0.00 sec)*the only difference mysql error is (*table A the id Field is auto_increment andtable 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.84Server version: 5.0.84 Source distribution*thanks for your replytiredboy** reply Tweet Search Discussions Search mysql error 124 All Groups mysql 2 responses Oldest Nested Gavin Towey 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 Sent: Tuesday, August 25, 2009 12:23 AM To: [email protected] Subject: Got error 124 from storage engine hi, all: i have met an question as below: table Gavin Towey at Aug 25, 2009 at 5:53 pm ⇧ 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: stutiredboySent: Tuesday, August 25, 2009 12:23 AMTo: mysql@lists.mysql.comSubject: Got error 124 from storage enginehi, all:i have met an question as below:table A1,A2A1 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 sametalbe A is
FORUMSFOR COMPUTER PROFESSIONALS Log In Come Join Us! Are you aComputer / IT professional?Join Tek-Tips Forums! Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free! Join Us! *Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by Link To This Forum! Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.Just copy and paste the BBCode HTML Markdown MediaWiki reStructuredText code below into your site. MySQL Forum at Tek-Tips HomeForumsProgrammersDBMS PackagesMySQL Forum Error 124 thread436-1326847 Forum Search FAQs Links MVPs Error 124 Error 124 aalnaif (TechnicalUser) (OP) 25 Jan 07 14:21 I'm getting the following error when I try to call a procedure'Got Error 124 from storage engine.'Does anyone know what this means? RE: Error 124 r937 (TechnicalUser) 25 Jan 07 15:10 try REPAIR TABLE tablename r937.com | rudy.ca RE: Error 124 johnwm (Programmer) 25 Jan 07 17:17 Error codes are listed in the manual: http://dev.mysql.com/doc/refman/4.1/en/error-handling.html ___________________________________________________________If you want the best response to a question, please check out FAQ222-2244 first.'If we're supposed to work in Hex, why have we only got A fingers?'Drive a Steam Roller Steam Engine Prints Red Flag This Post Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework. Cancel Red Flag SubmittedThank you for helping keep Tek-Tips Forums free from inappropriate posts.The Tek-Tips staff will check this out and take appropriate action. Close Reply To This Thread Postin