Got Error 124 From Storage Engine
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.
person Affects Status Importance Assigned to Milestone Maria Edit Fix Released High Oleksandr "Sanja" Byelkin Edit Maria 5.3 You need to log in to change this bug's status. Affecting: Maria Filed here by: Philip Stoev When: 2011-11-02 Confirmed: 2011-11-02 Assigned: 2011-11-02 Started work: 2011-11-29 Completed: 2011-11-29 Target Distribution Baltix BOSS Juju Charms Collection Elbuntu Guadalinex Guadalinex Edu Kiwi Linux nUbuntu PLD Linux Tilix https://bugs.mysql.com/bug.php?id=67982 tuXlab Ubuntu Ubuntu Linaro Evaluation Build Ubuntu RTM Package (Find…) Project (Find…) Status Importance Milestone Fix Released High Maria 5.3 Assigned to Me Oleksandr "Sanja" Byelkin (sanja-byelkin) Remote Watch None, the status of the bug is updated manually. None, the status of the bug is updated manually. URL: The information https://bugs.launchpad.net/bugs/885162 about this bug in Launchpad is automatically pulled daily from the remote bug. Comment on this change (optional) Email me about changes to this bug report Also affects project (?) Also affects distribution/package Nominate for series Bug Description When executing the following query: SELECT * FROM t1 WHERE t1.f1 IN ( SELECT 'k' UNION SELECT 'e' ) ; mysqld returned: ERROR 1030 (HY000): Got error 124 from storage engine backtrace: #0 my_error (nr=1030, MyFlags=0) at my_error.c:81 #1 0x083f34ef in handler::print_error (this=0xa7550990, error=124, errflag=0) at handler.cc:2981 #2 0x0833eb0f in report_error (table=0xa754fa18, error=124) at sql_select.cc:15468 #3 0x0833f549 in join_read_key2 (thd=0xaf82a20, tab=0xa7571840, table=0xa754fa18, table_ref=0xa757199c) at sql_select.cc:15731 #4 0x0833f3da in join_read_key (tab=0xa7571840) at sql_select.cc:15692 #5 0x0833e023 in sub_select (join=0xa7576490, join_tab=0xa7571840, end_of_records=false) at sql_select.cc:15129 #6 0x0833d8d0 in do_select (join=0xa7576490, fields=0xa754c028, table=0x0, procedure=0x0) at sql_select.cc:14795 #7 0x08322156 in JOIN::exec (this=0xa7576490) at sql_select.cc:2679 #8 0x08322982 in mysql_select (thd=0xaf82a20, rref_pointer_array=0xa754c414, tables=0xa754bdcc, wild_num=0, fields=..., conds=0x0, og_num=0, order
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 http://grokbase.com/t/mysql/mysql/098s2jq3m3/got-error-124-from-storage-engine the merge table of A1 and A2while i use:*mysql> select max(id) from A;** ERROR 1030 (HY000): Got error 124 from storage engine+---------------+-----------------------+------+-----+-------------------+----------------+Field | Type | Null | Key | Default | http://www.tek-tips.com/viewthread.cfm?qid=1326847 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 got error loot;+---------+max(id) |+---------+110415 |+---------+1 row in set (0.00 sec)*the only difference 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 got error 124 version is 5.0.84Server version: 5.0.84 Source distribution*thanks for your replytiredboy** reply Tweet Search Discussions Search 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 belo
Join INTELLIGENT WORK 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 Posting in the Tek-Tips forums is a member-only feature. Click Here to join Tek-Tips and talk with other members! Resources Join | Indeed Jobs | Adverti