Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-9137

MariaDB Crash on Query Using Aria Engine

Details

    • Bug
    • Status: Stalled (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.1.8, 5.5(EOL), 10.0(EOL), 10.1(EOL)
    • 10.4(EOL)
    • Storage Engine - Aria
    • Arch Linux 64bit

    Description

      Certain imports appear to be crashing MariaDB but only when this table is set to Aria as the engine, it doesn't happen when the table is set to InnoDB or MyISAM. Here's one example. Each time MariaDB was restarted, it kept crashing on this same insert.

      Thread pointer: 0x0x7fe6e0e54548
      Attempting backtrace. You can use the following information to find out
      where mysqld died. If you see no messages after this, something went
      terribly wrong...
      stack_bottom = 0x7fea9ccb5d78 thread_stack 0x48000
      /usr/bin/mysqld(my_print_stacktrace+0x2e)[0x55b637b50a0e]
      /usr/bin/mysqld(handle_fatal_signal+0x34d)[0x55b63769fdcd]
      /usr/lib/libpthread.so.0(+0x10d60)[0x7fea9ad4fd60]
      /usr/bin/mysqld(+0x98299d)[0x55b637a9c99d]
      /usr/bin/mysqld(+0x982c3b)[0x55b637a9cc3b]
      /usr/bin/mysqld(+0x982a08)[0x55b637a9ca08]
      /usr/bin/mysqld(+0x982a08)[0x55b637a9ca08]
      /usr/bin/mysqld(+0x982e0b)[0x55b637a9ce0b]
      /usr/bin/mysqld(+0x983230)[0x55b637a9d230]
      /usr/bin/mysqld(+0x99cd43)[0x55b637ab6d43]
      /usr/bin/mysqld(+0x97fd10)[0x55b637a99d10]
      /usr/bin/mysqld(_ZN7handler12ha_write_rowEPh+0x42f)[0x55b6376a9cbf]
      /usr/bin/mysqld(_Z12write_recordP3THDP5TABLEP12st_copy_info+0x6f)[0x55b6374fb2cf]
      /usr/bin/mysqld(_Z12mysql_insertP3THDP10TABLE_LISTR4ListI4ItemERS3_IS5_ES6_S6_15enum_duplicatesb+0xf8e)[0x55b6374ff05e]
      /usr/bin/mysqld(_Z21mysql_execute_commandP3THD+0x325a)[0x55b637518eca]
      /usr/bin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x20e)[0x55b63751ecce]
      /usr/bin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x24a7)[0x55b637522087]
      /usr/bin/mysqld(_Z10do_commandP3THD+0x176)[0x55b6375227f6]
      /usr/bin/mysqld(_Z26threadpool_process_requestP3THD+0x127)[0x55b637629667]
      /usr/bin/mysqld(+0x55dc45)[0x55b637677c45]
      /usr/lib/libpthread.so.0(+0x74a4)[0x7fea9ad464a4]
      /usr/lib/libc.so.6(clone+0x6d)[0x7fea9a40413d]
       
      Trying to get some variables.
      Some pointers may be invalid and cause the dump to abort.
      Query (0x7fe4d89648a0): INSERT INTO bookinfo          (title, author, asin, isbn, ean, url, salesrank, publisher, publishdate, pages,          overview, genre, cover, createddate, updateddate)         VALUES ('Standoff', 'Sandra Brown', '0743532627', '0743532627', '9780743532624', 'http://www.amazon.com/Standoff-Sandra-Brown/dp/0743532627%3FSubscriptionId%3DAKIAJ6YEOWNXMRGD5AFQ%26tag%3Dxnode0f-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3D0743532627', 1230300, 'Simon & Schuster Audio', '2003-05-01', 6, ' TV reporter Tiel McCoy is driving down Interstate 20 on her way to New Mexico for a well-earned vacation. But her itinerary is rewritten when she hears on the radio that the teenage daughter of a well-known Fort Worth multi-millionaire has been kidnapped, at least that\'s the official report. In truth, she is pregnant and has run away with her boyfriend. After calling her editor, Tiel abandons her holiday plans in favor of pursuing the story.  During an innocuous visit to a convenience store in Rojo Flats, Tiel gets up close and personal with the barrel of a gun, two desperate young lovers -- and the scoop of a lifetime.  In the electrifying standoff that follows, she learns why the two young runaways fear the wealthy father of one of them even more than the FBI...and why she must defend them against a world bent on their destruction.  Poignant and riveting, Standoff is suspense at its best, as only Sandra Brown can create it.', 'Suspense', 1, now(), now())
      Connection ID (thread ID): 3259
      Status: NOT_KILLED
       
      Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on
       
      The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
      information that should help you find out what is causing the crash.
      Mon Nov 16 13:18:23 2015 TokuFT recovery starting in env /var/lib/mysql/
      Mon Nov 16 13:18:23 2015 TokuFT recovery scanning backward from 5805517708
      Mon Nov 16 13:18:23 2015 TokuFT recovery bw_end_checkpoint at 5805517708 timestamp 1447679863009133 xid 5805505638 (bw_newer)
      Mon Nov 16 13:18:23 2015 TokuFT recovery bw_begin_checkpoint at 5805505638 timestamp 1447679844844486 (bw_between)
      Mon Nov 16 13:18:23 2015 TokuFT recovery turning around at begin checkpoint 5805505638 time 18164647
      Mon Nov 16 13:18:23 2015 TokuFT recovery starts scanning forward to 5805517708 from 5805505638 left 12070 (fw_between)
      Mon Nov 16 13:18:40 2015 TokuFT recovery scanning forward to 5805517708 at 5805507638 left 10070 (fw_between)
      Mon Nov 16 13:18:55 2015 TokuFT recovery scanning forward to 5805517708 at 5805515638 left 2070 (fw_between)
      Mon Nov 16 13:18:55 2015 TokuFT recovery closing 9765 dictionaries
      Mon Nov 16 13:19:01 2015 TokuFT recovery making a checkpoint
      Mon Nov 16 13:19:01 2015 TokuFT recovery done
      2015-11-16 13:19:01 139810053760896 [Note] InnoDB: Using mutexes to ref count buffer pool pages
      2015-11-16 13:19:01 139810053760896 [Note] InnoDB: The InnoDB memory heap is disabled
      2015-11-16 13:19:01 139810053760896 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
      2015-11-16 13:19:01 139810053760896 [Note] InnoDB: Memory barrier is not used
      2015-11-16 13:19:01 139810053760896 [Note] InnoDB: Compressed tables use zlib 1.2.8
      2015-11-16 13:19:01 139810053760896 [Note] InnoDB: Using Linux native AIO
      2015-11-16 13:19:01 139810053760896 [Note] InnoDB: Using CPU crc32 instructions
      2015-11-16 13:19:01 139810053760896 [Note] InnoDB: Initializing buffer pool, size = 128.0M
      2015-11-16 13:19:01 139810053760896 [Note] InnoDB: Completed initialization of buffer pool
      2015-11-16 13:19:01 139810053760896 [Note] InnoDB: Highest supported file format is Barracuda.
      2015-11-16 13:19:01 139810053760896 [Note] InnoDB: The log sequence numbers 706566915771 and 706566915771 in ibdata files do not match the log sequence number 706566915811 in the ib_logfiles!
      2015-11-16 13:19:01 139810053760896 [Note] InnoDB: Database was not shutdown normally!
      2015-11-16 13:19:01 139810053760896 [Note] InnoDB: Starting crash recovery.
      2015-11-16 13:19:01 139810053760896 [Note] InnoDB: Reading tablespace information from the .ibd files...
      2015-11-16 13:19:02 139810053760896 [Note] InnoDB: Restoring possible half-written data pages
      2015-11-16 13:19:02 139810053760896 [Note] InnoDB: from the doublewrite buffer...
      2015-11-16 13:19:02 139810053760896 [Note] InnoDB: 128 rollback segment(s) are active.
      2015-11-16 13:19:02 139810053760896 [Note] InnoDB: Waiting for purge to start
      2015-11-16 13:19:02 139810053760896 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 706566915811
      2015-11-16 13:19:03 139808592598784 [Note] InnoDB: Dumping buffer pool(s) not yet started
      2015-11-16 13:19:03 139810053760896 [Note] Plugin 'FEEDBACK' is disabled.
      2015-11-16 13:19:03 139810053760896 [Note] Recovering after a crash using tc.log
      2015-11-16 13:19:03 139810053760896 [Note] Starting crash recovery...
      2015-11-16 13:19:03 139810053760896 [Note] Crash recovery finished.
      2015-11-16 13:19:03 139810053760896 [Note] Event Scheduler: Loaded 0 events
      2015-11-16 13:19:03 139810053760896 [Note] /usr/bin/mysqld: ready for connections.
      Version: '10.1.8-MariaDB'  socket: '/var/run/mysqld/mysqld.sock'  port: 0  MariaDB Server

      This is the table in question:

      CREATE TABLE `bookinfo` (
       `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
       `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
       `author` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
       `asin` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
       `isbn` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
       `ean` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
       `url` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,
       `salesrank` int(10) unsigned DEFAULT NULL,
       `publisher` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
       `publishdate` datetime DEFAULT NULL,
       `pages` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
       `overview` varchar(10000) COLLATE utf8_unicode_ci DEFAULT NULL,
       `genre` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
       `cover` tinyint(1) unsigned NOT NULL DEFAULT '0',
       `createddate` datetime NOT NULL,
       `updateddate` datetime NOT NULL,
       PRIMARY KEY (`id`) KEY_BLOCK_SIZE=2048,
       UNIQUE KEY `ix_bookinfo_asin` (`asin`) KEY_BLOCK_SIZE=2048,
       FULLTEXT KEY `ix_bookinfo_author_title_ft` (`author`,`title`) KEY_BLOCK_SIZE=2048
      ) ENGINE=Aria AUTO_INCREMENT=212983 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci PACK_KEYS=1 PAGE_CHECKSUM=0 ROW_FORMAT=DYNAMIC TRANSACTIONAL=0 /* `PAGE_COMPRESSED`=1 */

      (the table has been several different engines in the past which is why it appears to have retained many different and now invalid options).

      Attachments

        Issue Links

          Activity

            Enverex,
            This crash on SELECT looks like a separate problem.
            It's usual that after a crash an Aria/MyISAM table which was open during the crash is considered to be corrupt; it's unusual however that it's corrupted that much, but we'll see what's going on after we can reproduce it. If you don't mind, to avoid confusion, please file a separate bug report about this second crash (and importantly, please attach your cnf file(s) to it), while this issue will stay about crashing on an already corrupted table, and about ordinary REPAIR failing to fix it.

            elenst Elena Stepanova added a comment - Enverex , This crash on SELECT looks like a separate problem. It's usual that after a crash an Aria/MyISAM table which was open during the crash is considered to be corrupt; it's unusual however that it's corrupted that much , but we'll see what's going on after we can reproduce it. If you don't mind, to avoid confusion, please file a separate bug report about this second crash (and importantly, please attach your cnf file(s) to it), while this issue will stay about crashing on an already corrupted table, and about ordinary REPAIR failing to fix it.

            Here is another dataset for the reported problem, produced during concurrent tests, there is no sensitive data: ftp://ftp.askmonty.org/public/mdev9137.tar.gz
            Effect is the same:

            10.1 c69357d8d459

            MariaDB [test]> check table table1_key_pk_parts_2_int_autoinc;
            +----------------------------------------+-------+----------+--------------------------------------------------+
            | Table                                  | Op    | Msg_type | Msg_text                                         |
            +----------------------------------------+-------+----------+--------------------------------------------------+
            | test.table1_key_pk_parts_2_int_autoinc | check | error    | Page at 24576 is not marked for index 2863311518 |
            | test.table1_key_pk_parts_2_int_autoinc | check | error    | Page at 8192 is not marked for index 2863311518  |
            | test.table1_key_pk_parts_2_int_autoinc | check | error    | Page at 16384 is not marked for index 2863311518 |
            | test.table1_key_pk_parts_2_int_autoinc | check | error    | Key in wrong position at page 114688             |
            | test.table1_key_pk_parts_2_int_autoinc | check | error    | Corrupt                                          |
            +----------------------------------------+-------+----------+--------------------------------------------------+
            5 rows in set (0.00 sec)
             
            MariaDB [test]> INSERT INTO `table1_key_pk_parts_2_int_autoinc` SELECT * FROM `table1_key_pk_parts_2_int_autoinc`;
            ERROR 2013 (HY000): Lost connection to MySQL server during query
            

            #3  <signal handler called>
            #4  0x00007f7b1e9a79c6 in w_search (info=0x7f7aeea3e070, comp_flag=4, key=0x7f7b1f142a00, page_pos=24576, father_page=0x0, father_keypos=0x0, insert_last=1 '\001') at /data/src/10.1/storage/maria/ma_write.c:630
            #5  0x00007f7b1e9a7501 in _ma_ck_real_write_btree (info=0x7f7aeea3e070, key=0x7f7b1f142a00, root=0x7f7b1f141d98, comp_flag=4) at /data/src/10.1/storage/maria/ma_write.c:527
            #6  0x00007f7b1e9a7d55 in w_search (info=0x7f7aeea3e070, comp_flag=4, key=0x7f7b1f142a00, page_pos=114688, father_page=0x0, father_keypos=0x0, insert_last=1 '\001') at /data/src/10.1/storage/maria/ma_write.c:677
            #7  0x00007f7b1e9a7501 in _ma_ck_real_write_btree (info=0x7f7aeea3e070, key=0x7f7b1f1429e0, root=0x7f7b1f1423f0, comp_flag=131137) at /data/src/10.1/storage/maria/ma_write.c:527
            #8  0x00007f7b1e9a737b in _ma_ck_write_btree_with_log (info=0x7f7aeea3e070, key=0x7f7b1f1429e0, root=0x7f7aeea082b0, comp_flag=131137) at /data/src/10.1/storage/maria/ma_write.c:494
            #9  0x00007f7b1e9a71cc in _ma_ck_write_btree (info=0x7f7aeea3e070, key=0x7f7b1f1429e0) at /data/src/10.1/storage/maria/ma_write.c:452
            #10 0x00007f7b1e9aafac in keys_free (key=0x7f7aeeafb118 "\t136052736?}", <incomplete sequence \350>, mode=free_free, param=0x7f7aee89b3c0) at /data/src/10.1/storage/maria/ma_write.c:1708
            #11 0x00007f7b1eaa943e in delete_tree_element (tree=0x7f7aee89ae70, element=0x7f7aeeafb0f8) at /data/src/10.1/mysys/tree.c:186
            #12 0x00007f7b1eaa93e3 in delete_tree_element (tree=0x7f7aee89ae70, element=0x7f7aeeafb210) at /data/src/10.1/mysys/tree.c:184
            #13 0x00007f7b1eaa93e3 in delete_tree_element (tree=0x7f7aee89ae70, element=0x7f7aeeafb440) at /data/src/10.1/mysys/tree.c:184
            #14 0x00007f7b1eaa93e3 in delete_tree_element (tree=0x7f7aee89ae70, element=0x7f7aeeafb8a0) at /data/src/10.1/mysys/tree.c:184
            #15 0x00007f7b1eaa93e3 in delete_tree_element (tree=0x7f7aee89ae70, element=0x7f7aeeafc160) at /data/src/10.1/mysys/tree.c:184
            #16 0x00007f7b1eaa93e3 in delete_tree_element (tree=0x7f7aee89ae70, element=0x7f7aeeafd2e0) at /data/src/10.1/mysys/tree.c:184
            #17 0x00007f7b1eaa93e3 in delete_tree_element (tree=0x7f7aee89ae70, element=0x7f7aeeaff5e0) at /data/src/10.1/mysys/tree.c:184
            #18 0x00007f7b1eaa93e3 in delete_tree_element (tree=0x7f7aee89ae70, element=0x7f7aeeb03be0) at /data/src/10.1/mysys/tree.c:184
            #19 0x00007f7b1eaa93e3 in delete_tree_element (tree=0x7f7aee89ae70, element=0x7f7aeeb0c7e0) at /data/src/10.1/mysys/tree.c:184
            #20 0x00007f7b1eaa93e3 in delete_tree_element (tree=0x7f7aee89ae70, element=0x7f7aeeafb168) at /data/src/10.1/mysys/tree.c:184
            #21 0x00007f7b1eaa93e3 in delete_tree_element (tree=0x7f7aee89ae70, element=0x7f7aeeafb088) at /data/src/10.1/mysys/tree.c:184
            #22 0x00007f7b1eaa92df in free_tree (tree=0x7f7aee89ae70, free_flags=2) at /data/src/10.1/mysys/tree.c:154
            #23 0x00007f7b1eaa93a9 in reset_tree (tree=0x7f7aee89ae70) at /data/src/10.1/mysys/tree.c:176
            #24 0x00007f7b1eaa95f4 in tree_insert (tree=0x7f7aee89ae70, key=0x7f7aeea42a06, key_size=20, custom_arg=0x7f7aee89b3c0) at /data/src/10.1/mysys/tree.c:236
            #25 0x00007f7b1e9aad54 in _ma_ck_write_tree (info=0x7f7aeea3e070, key=0x7f7b1f1431f0) at /data/src/10.1/storage/maria/ma_write.c:1656
            #26 0x00007f7b1e9a7111 in _ma_ck_write (info=0x7f7aeea3e070, key=0x7f7b1f1431f0) at /data/src/10.1/storage/maria/ma_write.c:435
            #27 0x00007f7b1e9cd90f in _ma_ft_store (info=0x7f7aeea3e070, keynr=0, keybuf=0x7f7aeea42a06 "\t136052736?}", <incomplete sequence \350>, wlist=0x7f7aee9e9088, filepos=493540) at /data/src/10.1/storage/maria/ma_ft_update.c:143
            #28 0x00007f7b1e9cdf74 in _ma_ft_add (info=0x7f7aeea3e070, keynr=0, keybuf=0x7f7aeea42a06 "\t136052736?}", <incomplete sequence \350>, record=0x7f7aee85a788 <incomplete sequence \375>, pos=493540) at /data/src/10.1/storage/maria/ma_ft_update.c:260
            #29 0x00007f7b1e9a651a in maria_write (info=0x7f7aeea3e070, record=0x7f7aee85a788 <incomplete sequence \375>) at /data/src/10.1/storage/maria/ma_write.c:178
            #30 0x00007f7b1e92ff3d in ha_maria::write_row (this=0x7f7aee8b5888, buf=0x7f7aee85a788 <incomplete sequence \375>) at /data/src/10.1/storage/maria/ha_maria.cc:1279
            #31 0x00007f7b1e44c991 in handler::ha_write_row (this=0x7f7aee8b5888, buf=0x7f7aee85a788 <incomplete sequence \375>) at /data/src/10.1/sql/handler.cc:5941
            #32 0x00007f7b1e1e1e09 in write_record (thd=0x7f7af82e7070, table=0x7f7aee8d5270, info=0x7f7aee826820) at /data/src/10.1/sql/sql_insert.cc:1915
            #33 0x00007f7b1e1e6a69 in select_insert::send_data (this=0x7f7aee8267e0, values=...) at /data/src/10.1/sql/sql_insert.cc:3711
            #34 0x00007f7b1e26e029 in end_send (join=0x7f7aee826880, join_tab=0x7f7aee8298a0, end_of_records=false) at /data/src/10.1/sql/sql_select.cc:19584
            #35 0x00007f7b1e26bda2 in evaluate_join_record (join=0x7f7aee826880, join_tab=0x7f7aee829558, error=0) at /data/src/10.1/sql/sql_select.cc:18673
            #36 0x00007f7b1e26b848 in sub_select (join=0x7f7aee826880, join_tab=0x7f7aee829558, end_of_records=false) at /data/src/10.1/sql/sql_select.cc:18489
            #37 0x00007f7b1e26af17 in do_select (join=0x7f7aee826880, fields=0x7f7aee826c50, table=0x0, procedure=0x0) at /data/src/10.1/sql/sql_select.cc:18105
            #38 0x00007f7b1e245896 in JOIN::exec_inner (this=0x7f7aee826880) at /data/src/10.1/sql/sql_select.cc:3261
            #39 0x00007f7b1e242b27 in JOIN::exec (this=0x7f7aee826880) at /data/src/10.1/sql/sql_select.cc:2548
            #40 0x00007f7b1e2460bd in mysql_select (thd=0x7f7af82e7070, rref_pointer_array=0x7f7af82eb550, tables=0x7f7aee8259b0, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=3489925888, result=0x7f7aee8267e0, unit=0x7f7af82eaba8, select_lex=0x7f7af82eb2a8) at /data/src/10.1/sql/sql_select.cc:3485
            #41 0x00007f7b1e23b93a in handle_select (thd=0x7f7af82e7070, lex=0x7f7af82eaae0, result=0x7f7aee8267e0, setup_tables_done_option=1073741824) at /data/src/10.1/sql/sql_select.cc:388
            #42 0x00007f7b1e204849 in mysql_execute_command (thd=0x7f7af82e7070) at /data/src/10.1/sql/sql_parse.cc:4036
            #43 0x00007f7b1e20ee4b in mysql_parse (thd=0x7f7af82e7070, rawbuf=0x7f7aee825088 "INSERT INTO `table1_key_pk_parts_2_int_autoinc` SELECT * FROM `table1_key_pk_parts_2_int_autoinc`", length=97, parser_state=0x7f7b1f144630) at /data/src/10.1/sql/sql_parse.cc:7449
            #44 0x00007f7b1e1fd885 in dispatch_command (command=COM_QUERY, thd=0x7f7af82e7070, packet=0x7f7b1b7f9071 "INSERT INTO `table1_key_pk_parts_2_int_autoinc` SELECT * FROM `table1_key_pk_parts_2_int_autoinc`", packet_length=97) at /data/src/10.1/sql/sql_parse.cc:1492
            #45 0x00007f7b1e1fc60a in do_command (thd=0x7f7af82e7070) at /data/src/10.1/sql/sql_parse.cc:1121
            #46 0x00007f7b1e336557 in do_handle_one_connection (thd_arg=0x7f7af82e7070) at /data/src/10.1/sql/sql_connect.cc:1330
            #47 0x00007f7b1e3362bb in handle_one_connection (arg=0x7f7af82e7070) at /data/src/10.1/sql/sql_connect.cc:1242
            #48 0x00007f7b1d8f5064 in start_thread (arg=0x7f7b1f145b00) at pthread_create.c:309
            #49 0x00007f7b1bd1b62d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
            

            elenst Elena Stepanova added a comment - Here is another dataset for the reported problem, produced during concurrent tests, there is no sensitive data: ftp://ftp.askmonty.org/public/mdev9137.tar.gz Effect is the same: 10.1 c69357d8d459 MariaDB [test]> check table table1_key_pk_parts_2_int_autoinc; +----------------------------------------+-------+----------+--------------------------------------------------+ | Table | Op | Msg_type | Msg_text | +----------------------------------------+-------+----------+--------------------------------------------------+ | test.table1_key_pk_parts_2_int_autoinc | check | error | Page at 24576 is not marked for index 2863311518 | | test.table1_key_pk_parts_2_int_autoinc | check | error | Page at 8192 is not marked for index 2863311518 | | test.table1_key_pk_parts_2_int_autoinc | check | error | Page at 16384 is not marked for index 2863311518 | | test.table1_key_pk_parts_2_int_autoinc | check | error | Key in wrong position at page 114688 | | test.table1_key_pk_parts_2_int_autoinc | check | error | Corrupt | +----------------------------------------+-------+----------+--------------------------------------------------+ 5 rows in set (0.00 sec)   MariaDB [test]> INSERT INTO `table1_key_pk_parts_2_int_autoinc` SELECT * FROM `table1_key_pk_parts_2_int_autoinc`; ERROR 2013 (HY000): Lost connection to MySQL server during query #3 <signal handler called> #4 0x00007f7b1e9a79c6 in w_search (info=0x7f7aeea3e070, comp_flag=4, key=0x7f7b1f142a00, page_pos=24576, father_page=0x0, father_keypos=0x0, insert_last=1 '\001') at /data/src/10.1/storage/maria/ma_write.c:630 #5 0x00007f7b1e9a7501 in _ma_ck_real_write_btree (info=0x7f7aeea3e070, key=0x7f7b1f142a00, root=0x7f7b1f141d98, comp_flag=4) at /data/src/10.1/storage/maria/ma_write.c:527 #6 0x00007f7b1e9a7d55 in w_search (info=0x7f7aeea3e070, comp_flag=4, key=0x7f7b1f142a00, page_pos=114688, father_page=0x0, father_keypos=0x0, insert_last=1 '\001') at /data/src/10.1/storage/maria/ma_write.c:677 #7 0x00007f7b1e9a7501 in _ma_ck_real_write_btree (info=0x7f7aeea3e070, key=0x7f7b1f1429e0, root=0x7f7b1f1423f0, comp_flag=131137) at /data/src/10.1/storage/maria/ma_write.c:527 #8 0x00007f7b1e9a737b in _ma_ck_write_btree_with_log (info=0x7f7aeea3e070, key=0x7f7b1f1429e0, root=0x7f7aeea082b0, comp_flag=131137) at /data/src/10.1/storage/maria/ma_write.c:494 #9 0x00007f7b1e9a71cc in _ma_ck_write_btree (info=0x7f7aeea3e070, key=0x7f7b1f1429e0) at /data/src/10.1/storage/maria/ma_write.c:452 #10 0x00007f7b1e9aafac in keys_free (key=0x7f7aeeafb118 "\t136052736?}", <incomplete sequence \350>, mode=free_free, param=0x7f7aee89b3c0) at /data/src/10.1/storage/maria/ma_write.c:1708 #11 0x00007f7b1eaa943e in delete_tree_element (tree=0x7f7aee89ae70, element=0x7f7aeeafb0f8) at /data/src/10.1/mysys/tree.c:186 #12 0x00007f7b1eaa93e3 in delete_tree_element (tree=0x7f7aee89ae70, element=0x7f7aeeafb210) at /data/src/10.1/mysys/tree.c:184 #13 0x00007f7b1eaa93e3 in delete_tree_element (tree=0x7f7aee89ae70, element=0x7f7aeeafb440) at /data/src/10.1/mysys/tree.c:184 #14 0x00007f7b1eaa93e3 in delete_tree_element (tree=0x7f7aee89ae70, element=0x7f7aeeafb8a0) at /data/src/10.1/mysys/tree.c:184 #15 0x00007f7b1eaa93e3 in delete_tree_element (tree=0x7f7aee89ae70, element=0x7f7aeeafc160) at /data/src/10.1/mysys/tree.c:184 #16 0x00007f7b1eaa93e3 in delete_tree_element (tree=0x7f7aee89ae70, element=0x7f7aeeafd2e0) at /data/src/10.1/mysys/tree.c:184 #17 0x00007f7b1eaa93e3 in delete_tree_element (tree=0x7f7aee89ae70, element=0x7f7aeeaff5e0) at /data/src/10.1/mysys/tree.c:184 #18 0x00007f7b1eaa93e3 in delete_tree_element (tree=0x7f7aee89ae70, element=0x7f7aeeb03be0) at /data/src/10.1/mysys/tree.c:184 #19 0x00007f7b1eaa93e3 in delete_tree_element (tree=0x7f7aee89ae70, element=0x7f7aeeb0c7e0) at /data/src/10.1/mysys/tree.c:184 #20 0x00007f7b1eaa93e3 in delete_tree_element (tree=0x7f7aee89ae70, element=0x7f7aeeafb168) at /data/src/10.1/mysys/tree.c:184 #21 0x00007f7b1eaa93e3 in delete_tree_element (tree=0x7f7aee89ae70, element=0x7f7aeeafb088) at /data/src/10.1/mysys/tree.c:184 #22 0x00007f7b1eaa92df in free_tree (tree=0x7f7aee89ae70, free_flags=2) at /data/src/10.1/mysys/tree.c:154 #23 0x00007f7b1eaa93a9 in reset_tree (tree=0x7f7aee89ae70) at /data/src/10.1/mysys/tree.c:176 #24 0x00007f7b1eaa95f4 in tree_insert (tree=0x7f7aee89ae70, key=0x7f7aeea42a06, key_size=20, custom_arg=0x7f7aee89b3c0) at /data/src/10.1/mysys/tree.c:236 #25 0x00007f7b1e9aad54 in _ma_ck_write_tree (info=0x7f7aeea3e070, key=0x7f7b1f1431f0) at /data/src/10.1/storage/maria/ma_write.c:1656 #26 0x00007f7b1e9a7111 in _ma_ck_write (info=0x7f7aeea3e070, key=0x7f7b1f1431f0) at /data/src/10.1/storage/maria/ma_write.c:435 #27 0x00007f7b1e9cd90f in _ma_ft_store (info=0x7f7aeea3e070, keynr=0, keybuf=0x7f7aeea42a06 "\t136052736?}", <incomplete sequence \350>, wlist=0x7f7aee9e9088, filepos=493540) at /data/src/10.1/storage/maria/ma_ft_update.c:143 #28 0x00007f7b1e9cdf74 in _ma_ft_add (info=0x7f7aeea3e070, keynr=0, keybuf=0x7f7aeea42a06 "\t136052736?}", <incomplete sequence \350>, record=0x7f7aee85a788 <incomplete sequence \375>, pos=493540) at /data/src/10.1/storage/maria/ma_ft_update.c:260 #29 0x00007f7b1e9a651a in maria_write (info=0x7f7aeea3e070, record=0x7f7aee85a788 <incomplete sequence \375>) at /data/src/10.1/storage/maria/ma_write.c:178 #30 0x00007f7b1e92ff3d in ha_maria::write_row (this=0x7f7aee8b5888, buf=0x7f7aee85a788 <incomplete sequence \375>) at /data/src/10.1/storage/maria/ha_maria.cc:1279 #31 0x00007f7b1e44c991 in handler::ha_write_row (this=0x7f7aee8b5888, buf=0x7f7aee85a788 <incomplete sequence \375>) at /data/src/10.1/sql/handler.cc:5941 #32 0x00007f7b1e1e1e09 in write_record (thd=0x7f7af82e7070, table=0x7f7aee8d5270, info=0x7f7aee826820) at /data/src/10.1/sql/sql_insert.cc:1915 #33 0x00007f7b1e1e6a69 in select_insert::send_data (this=0x7f7aee8267e0, values=...) at /data/src/10.1/sql/sql_insert.cc:3711 #34 0x00007f7b1e26e029 in end_send (join=0x7f7aee826880, join_tab=0x7f7aee8298a0, end_of_records=false) at /data/src/10.1/sql/sql_select.cc:19584 #35 0x00007f7b1e26bda2 in evaluate_join_record (join=0x7f7aee826880, join_tab=0x7f7aee829558, error=0) at /data/src/10.1/sql/sql_select.cc:18673 #36 0x00007f7b1e26b848 in sub_select (join=0x7f7aee826880, join_tab=0x7f7aee829558, end_of_records=false) at /data/src/10.1/sql/sql_select.cc:18489 #37 0x00007f7b1e26af17 in do_select (join=0x7f7aee826880, fields=0x7f7aee826c50, table=0x0, procedure=0x0) at /data/src/10.1/sql/sql_select.cc:18105 #38 0x00007f7b1e245896 in JOIN::exec_inner (this=0x7f7aee826880) at /data/src/10.1/sql/sql_select.cc:3261 #39 0x00007f7b1e242b27 in JOIN::exec (this=0x7f7aee826880) at /data/src/10.1/sql/sql_select.cc:2548 #40 0x00007f7b1e2460bd in mysql_select (thd=0x7f7af82e7070, rref_pointer_array=0x7f7af82eb550, tables=0x7f7aee8259b0, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=3489925888, result=0x7f7aee8267e0, unit=0x7f7af82eaba8, select_lex=0x7f7af82eb2a8) at /data/src/10.1/sql/sql_select.cc:3485 #41 0x00007f7b1e23b93a in handle_select (thd=0x7f7af82e7070, lex=0x7f7af82eaae0, result=0x7f7aee8267e0, setup_tables_done_option=1073741824) at /data/src/10.1/sql/sql_select.cc:388 #42 0x00007f7b1e204849 in mysql_execute_command (thd=0x7f7af82e7070) at /data/src/10.1/sql/sql_parse.cc:4036 #43 0x00007f7b1e20ee4b in mysql_parse (thd=0x7f7af82e7070, rawbuf=0x7f7aee825088 "INSERT INTO `table1_key_pk_parts_2_int_autoinc` SELECT * FROM `table1_key_pk_parts_2_int_autoinc`", length=97, parser_state=0x7f7b1f144630) at /data/src/10.1/sql/sql_parse.cc:7449 #44 0x00007f7b1e1fd885 in dispatch_command (command=COM_QUERY, thd=0x7f7af82e7070, packet=0x7f7b1b7f9071 "INSERT INTO `table1_key_pk_parts_2_int_autoinc` SELECT * FROM `table1_key_pk_parts_2_int_autoinc`", packet_length=97) at /data/src/10.1/sql/sql_parse.cc:1492 #45 0x00007f7b1e1fc60a in do_command (thd=0x7f7af82e7070) at /data/src/10.1/sql/sql_parse.cc:1121 #46 0x00007f7b1e336557 in do_handle_one_connection (thd_arg=0x7f7af82e7070) at /data/src/10.1/sql/sql_connect.cc:1330 #47 0x00007f7b1e3362bb in handle_one_connection (arg=0x7f7af82e7070) at /data/src/10.1/sql/sql_connect.cc:1242 #48 0x00007f7b1d8f5064 in start_thread (arg=0x7f7b1f145b00) at pthread_create.c:309 #49 0x00007f7b1bd1b62d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111

            Unfortunately for this I need a little more information to be able to repeat (especially as stack trace doesn't tell me on which line things crashed)

            I assume the import is done to an empty table ?
            Can you give me access to what you tried to import

            monty Michael Widenius added a comment - Unfortunately for this I need a little more information to be able to repeat (especially as stack trace doesn't tell me on which line things crashed) I assume the import is done to an empty table ? Can you give me access to what you tried to import

            Sorry Michael, I gave up on Toku long ago and the project this was part of has since been abandoned.

            Enverex Benjamin Hodgetts added a comment - Sorry Michael, I gave up on Toku long ago and the project this was part of has since been abandoned.

            monty,
            The way to reproduce is actually in my previous comment, but they're not very well defined, so, to summarize:

            The datadir contains a corrupt table table1_key_pk_parts_2_int_autoinc. The problem to look at in the scope of this report is two-fold:
            1) REPAIR TABLE pretends everything is fine, but doesn't repair anything:

            MariaDB [test]> check table table1_key_pk_parts_2_int_autoinc;
            +----------------------------------------+-------+----------+--------------------------------------------------+
            | Table                                  | Op    | Msg_type | Msg_text                                         |
            +----------------------------------------+-------+----------+--------------------------------------------------+
            | test.table1_key_pk_parts_2_int_autoinc | check | error    | Page at 24576 is not marked for index 2863311518 |
            | test.table1_key_pk_parts_2_int_autoinc | check | error    | Page at 8192 is not marked for index 2863311518  |
            | test.table1_key_pk_parts_2_int_autoinc | check | error    | Page at 16384 is not marked for index 2863311518 |
            | test.table1_key_pk_parts_2_int_autoinc | check | error    | Key in wrong position at page 122880             |
            | test.table1_key_pk_parts_2_int_autoinc | check | error    | Corrupt                                          |
            +----------------------------------------+-------+----------+--------------------------------------------------+
            5 rows in set (0.01 sec)
             
            MariaDB [test]> repair table table1_key_pk_parts_2_int_autoinc;
            +----------------------------------------+--------+----------+----------+
            | Table                                  | Op     | Msg_type | Msg_text |
            +----------------------------------------+--------+----------+----------+
            | test.table1_key_pk_parts_2_int_autoinc | repair | status   | OK       |
            +----------------------------------------+--------+----------+----------+
            1 row in set (0.34 sec)
             
            MariaDB [test]> check table table1_key_pk_parts_2_int_autoinc;
            +----------------------------------------+-------+----------+--------------------------------------------------+
            | Table                                  | Op    | Msg_type | Msg_text                                         |
            +----------------------------------------+-------+----------+--------------------------------------------------+
            | test.table1_key_pk_parts_2_int_autoinc | check | error    | Page at 24576 is not marked for index 2863311518 |
            | test.table1_key_pk_parts_2_int_autoinc | check | error    | Page at 8192 is not marked for index 2863311518  |
            | test.table1_key_pk_parts_2_int_autoinc | check | error    | Page at 16384 is not marked for index 2863311518 |
            | test.table1_key_pk_parts_2_int_autoinc | check | error    | Key in wrong position at page 122880             |
            | test.table1_key_pk_parts_2_int_autoinc | check | error    | Corrupt                                          |
            +----------------------------------------+-------+----------+--------------------------------------------------+
            5 rows in set (0.01 sec)
            

            2) INSERT .. SELECT crashes:

            MariaDB [test]> INSERT INTO `table1_key_pk_parts_2_int_autoinc` SELECT * FROM `table1_key_pk_parts_2_int_autoinc`;
            ERROR 2013 (HY000): Lost connection to MySQL server during query
            

            10.1 6c588c92a9b

            #3  <signal handler called>
            #4  0x0000561d48c53e1c in w_search (info=0x7f82d7a1d070, comp_flag=4, key=0x7f8306f47a00, page_pos=40960, father_page=0x0, father_keypos=0x0, insert_last=1 '\001') at /data/src/10.1/storage/maria/ma
            _write.c:630
            #5  0x0000561d48c53957 in _ma_ck_real_write_btree (info=0x7f82d7a1d070, key=0x7f8306f47a00, root=0x7f8306f46d98, comp_flag=4) at /data/src/10.1/storage/maria/ma_write.c:527
            #6  0x0000561d48c541ab in w_search (info=0x7f82d7a1d070, comp_flag=4, key=0x7f8306f47a00, page_pos=196608, father_page=0x0, father_keypos=0x0, insert_last=1 '\001') at /data/src/10.1/storage/maria/m
            a_write.c:677
            #7  0x0000561d48c53957 in _ma_ck_real_write_btree (info=0x7f82d7a1d070, key=0x7f8306f479e0, root=0x7f8306f473f0, comp_flag=131137) at /data/src/10.1/storage/maria/ma_write.c:527
            #8  0x0000561d48c537d1 in _ma_ck_write_btree_with_log (info=0x7f82d7a1d070, key=0x7f8306f479e0, root=0x7f82d7a08320, comp_flag=131137) at /data/src/10.1/storage/maria/ma_write.c:494
            #9  0x0000561d48c53622 in _ma_ck_write_btree (info=0x7f82d7a1d070, key=0x7f8306f479e0) at /data/src/10.1/storage/maria/ma_write.c:452
            #10 0x0000561d48c57402 in keys_free (key=0x7f82d7b9a118 "\t136052736?}", <incomplete sequence \350>, mode=free_free, param=0x7f82d789b3c0) at /data/src/10.1/storage/maria/ma_write.c:1708
            #11 0x0000561d490802a5 in delete_tree_element (tree=0x7f82d789ae70, element=0x7f82d7b9a0f8) at /data/src/10.1/mysys/tree.c:186
            #12 0x0000561d4908024a in delete_tree_element (tree=0x7f82d789ae70, element=0x7f82d7b9a210) at /data/src/10.1/mysys/tree.c:184
            #13 0x0000561d4908024a in delete_tree_element (tree=0x7f82d789ae70, element=0x7f82d7b9a440) at /data/src/10.1/mysys/tree.c:184
            #14 0x0000561d4908024a in delete_tree_element (tree=0x7f82d789ae70, element=0x7f82d7b9a8a0) at /data/src/10.1/mysys/tree.c:184
            #15 0x0000561d4908024a in delete_tree_element (tree=0x7f82d789ae70, element=0x7f82d7b9b160) at /data/src/10.1/mysys/tree.c:184
            #16 0x0000561d4908024a in delete_tree_element (tree=0x7f82d789ae70, element=0x7f82d7b9c2e0) at /data/src/10.1/mysys/tree.c:184
            #17 0x0000561d4908024a in delete_tree_element (tree=0x7f82d789ae70, element=0x7f82d7b9e5e0) at /data/src/10.1/mysys/tree.c:184
            #18 0x0000561d4908024a in delete_tree_element (tree=0x7f82d789ae70, element=0x7f82d7ba2be0) at /data/src/10.1/mysys/tree.c:184
            #19 0x0000561d4908024a in delete_tree_element (tree=0x7f82d789ae70, element=0x7f82d7bab7e0) at /data/src/10.1/mysys/tree.c:184
            #20 0x0000561d4908024a in delete_tree_element (tree=0x7f82d789ae70, element=0x7f82d7b9a168) at /data/src/10.1/mysys/tree.c:184
            #21 0x0000561d4908024a in delete_tree_element (tree=0x7f82d789ae70, element=0x7f82d7b9a088) at /data/src/10.1/mysys/tree.c:184
            #22 0x0000561d49080146 in free_tree (tree=0x7f82d789ae70, free_flags=2) at /data/src/10.1/mysys/tree.c:154
            #23 0x0000561d49080210 in reset_tree (tree=0x7f82d789ae70) at /data/src/10.1/mysys/tree.c:176
            #24 0x0000561d4908045b in tree_insert (tree=0x7f82d789ae70, key=0x7f82d7a21a06, key_size=20, custom_arg=0x7f82d789b3c0) at /data/src/10.1/mysys/tree.c:236
            #25 0x0000561d48c571aa in _ma_ck_write_tree (info=0x7f82d7a1d070, key=0x7f8306f481f0) at /data/src/10.1/storage/maria/ma_write.c:1656
            #26 0x0000561d48c53567 in _ma_ck_write (info=0x7f82d7a1d070, key=0x7f8306f481f0) at /data/src/10.1/storage/maria/ma_write.c:435
            #27 0x0000561d48c79d65 in _ma_ft_store (info=0x7f82d7a1d070, keynr=0, keybuf=0x7f82d7a21a06 "\t136052736?}", <incomplete sequence \350>, wlist=0x7f82d79e9088, filepos=878560) at /data/src/10.1/storage/maria/ma_ft_update.c:143
            #28 0x0000561d48c7a3ca in _ma_ft_add (info=0x7f82d7a1d070, keynr=0, keybuf=0x7f82d7a21a06 "\t136052736?}", <incomplete sequence \350>, record=0x7f82d785ac88 <incomplete sequence \375>, pos=878560) at /data/src/10.1/storage/maria/ma_ft_update.c:260
            #29 0x0000561d48c52970 in maria_write (info=0x7f82d7a1d070, record=0x7f82d785ac88 <incomplete sequence \375>) at /data/src/10.1/storage/maria/ma_write.c:178
            #30 0x0000561d48bdb1db in ha_maria::write_row (this=0x7f82d78b6088, buf=0x7f82d785ac88 <incomplete sequence \375>) at /data/src/10.1/storage/maria/ha_maria.cc:1279
            #31 0x0000561d48a223cd in handler::ha_write_row (this=0x7f82d78b6088, buf=0x7f82d785ac88 <incomplete sequence \375>) at /data/src/10.1/sql/handler.cc:5963
            #32 0x0000561d487b624b in write_record (thd=0x7f82e1351070, table=0x7f82d78d5270, info=0x7f82d7826080) at /data/src/10.1/sql/sql_insert.cc:1915
            #33 0x0000561d487baeab in select_insert::send_data (this=0x7f82d7826040, values=...) at /data/src/10.1/sql/sql_insert.cc:3711
            #34 0x0000561d48842757 in end_send (join=0x7f82d78260e0, join_tab=0x7f82d7829100, end_of_records=false) at /data/src/10.1/sql/sql_select.cc:19605
            #35 0x0000561d488404d0 in evaluate_join_record (join=0x7f82d78260e0, join_tab=0x7f82d7828db8, error=0) at /data/src/10.1/sql/sql_select.cc:18694
            #36 0x0000561d4883ff76 in sub_select (join=0x7f82d78260e0, join_tab=0x7f82d7828db8, end_of_records=false) at /data/src/10.1/sql/sql_select.cc:18510
            #37 0x0000561d4883f645 in do_select (join=0x7f82d78260e0, fields=0x7f82d78264b0, table=0x0, procedure=0x0) at /data/src/10.1/sql/sql_select.cc:18126
            #38 0x0000561d48819ea8 in JOIN::exec_inner (this=0x7f82d78260e0) at /data/src/10.1/sql/sql_select.cc:3275
            #39 0x0000561d48817139 in JOIN::exec (this=0x7f82d78260e0) at /data/src/10.1/sql/sql_select.cc:2562
            #40 0x0000561d4881a6cf in mysql_select (thd=0x7f82e1351070, rref_pointer_array=0x7f82e1355560, tables=0x7f82d78259b0, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=3489925888, result=0x7f82d7826040, unit=0x7f82e1354bb8, select_lex=0x7f82e13552b8) at /data/src/10.1/sql/sql_select.cc:3499
            #41 0x0000561d4880fd88 in handle_select (thd=0x7f82e1351070, lex=0x7f82e1354af0, result=0x7f82d7826040, setup_tables_done_option=1073741824) at /data/src/10.1/sql/sql_select.cc:388
            #42 0x0000561d487d8cc1 in mysql_execute_command (thd=0x7f82e1351070) at /data/src/10.1/sql/sql_parse.cc:4039
            #43 0x0000561d487e3368 in mysql_parse (thd=0x7f82e1351070, rawbuf=0x7f82d7825088 "INSERT INTO `table1_key_pk_parts_2_int_autoinc` SELECT * FROM `table1_key_pk_parts_2_int_autoinc`", length=97, parser_state=0x7f8306f49630) at /data/src/10.1/sql/sql_parse.cc:7463
            #44 0x0000561d487d1cfd in dispatch_command (command=COM_QUERY, thd=0x7f82e1351070, packet=0x7f82e12b6071 "INSERT INTO `table1_key_pk_parts_2_int_autoinc` SELECT * FROM `table1_key_pk_parts_2_int_autoinc`", packet_length=97) at /data/src/10.1/sql/sql_parse.cc:1495
            #45 0x0000561d487d0a82 in do_command (thd=0x7f82e1351070) at /data/src/10.1/sql/sql_parse.cc:1124
            #46 0x0000561d4890aecd in do_handle_one_connection (thd_arg=0x7f82e1351070) at /data/src/10.1/sql/sql_connect.cc:1330
            

            elenst Elena Stepanova added a comment - monty , The way to reproduce is actually in my previous comment, but they're not very well defined, so, to summarize: download ftp://ftp.askmonty.org/public/mdev9137.tar.gz unpack it, there will be vardir/data (among other things) start the server, e.g. current 10.1 debug build, on this datadir. All default options will do The datadir contains a corrupt table table1_key_pk_parts_2_int_autoinc . The problem to look at in the scope of this report is two-fold: 1) REPAIR TABLE pretends everything is fine, but doesn't repair anything: MariaDB [test]> check table table1_key_pk_parts_2_int_autoinc; + ----------------------------------------+-------+----------+--------------------------------------------------+ | Table | Op | Msg_type | Msg_text | + ----------------------------------------+-------+----------+--------------------------------------------------+ | test.table1_key_pk_parts_2_int_autoinc | check | error | Page at 24576 is not marked for index 2863311518 | | test.table1_key_pk_parts_2_int_autoinc | check | error | Page at 8192 is not marked for index 2863311518 | | test.table1_key_pk_parts_2_int_autoinc | check | error | Page at 16384 is not marked for index 2863311518 | | test.table1_key_pk_parts_2_int_autoinc | check | error | Key in wrong position at page 122880 | | test.table1_key_pk_parts_2_int_autoinc | check | error | Corrupt | + ----------------------------------------+-------+----------+--------------------------------------------------+ 5 rows in set (0.01 sec)   MariaDB [test]> repair table table1_key_pk_parts_2_int_autoinc; + ----------------------------------------+--------+----------+----------+ | Table | Op | Msg_type | Msg_text | + ----------------------------------------+--------+----------+----------+ | test.table1_key_pk_parts_2_int_autoinc | repair | status | OK | + ----------------------------------------+--------+----------+----------+ 1 row in set (0.34 sec)   MariaDB [test]> check table table1_key_pk_parts_2_int_autoinc; + ----------------------------------------+-------+----------+--------------------------------------------------+ | Table | Op | Msg_type | Msg_text | + ----------------------------------------+-------+----------+--------------------------------------------------+ | test.table1_key_pk_parts_2_int_autoinc | check | error | Page at 24576 is not marked for index 2863311518 | | test.table1_key_pk_parts_2_int_autoinc | check | error | Page at 8192 is not marked for index 2863311518 | | test.table1_key_pk_parts_2_int_autoinc | check | error | Page at 16384 is not marked for index 2863311518 | | test.table1_key_pk_parts_2_int_autoinc | check | error | Key in wrong position at page 122880 | | test.table1_key_pk_parts_2_int_autoinc | check | error | Corrupt | + ----------------------------------------+-------+----------+--------------------------------------------------+ 5 rows in set (0.01 sec) 2) INSERT .. SELECT crashes: MariaDB [test]> INSERT INTO `table1_key_pk_parts_2_int_autoinc` SELECT * FROM `table1_key_pk_parts_2_int_autoinc`; ERROR 2013 (HY000): Lost connection to MySQL server during query 10.1 6c588c92a9b #3 <signal handler called> #4 0x0000561d48c53e1c in w_search (info=0x7f82d7a1d070, comp_flag=4, key=0x7f8306f47a00, page_pos=40960, father_page=0x0, father_keypos=0x0, insert_last=1 '\001') at /data/src/10.1/storage/maria/ma _write.c:630 #5 0x0000561d48c53957 in _ma_ck_real_write_btree (info=0x7f82d7a1d070, key=0x7f8306f47a00, root=0x7f8306f46d98, comp_flag=4) at /data/src/10.1/storage/maria/ma_write.c:527 #6 0x0000561d48c541ab in w_search (info=0x7f82d7a1d070, comp_flag=4, key=0x7f8306f47a00, page_pos=196608, father_page=0x0, father_keypos=0x0, insert_last=1 '\001') at /data/src/10.1/storage/maria/m a_write.c:677 #7 0x0000561d48c53957 in _ma_ck_real_write_btree (info=0x7f82d7a1d070, key=0x7f8306f479e0, root=0x7f8306f473f0, comp_flag=131137) at /data/src/10.1/storage/maria/ma_write.c:527 #8 0x0000561d48c537d1 in _ma_ck_write_btree_with_log (info=0x7f82d7a1d070, key=0x7f8306f479e0, root=0x7f82d7a08320, comp_flag=131137) at /data/src/10.1/storage/maria/ma_write.c:494 #9 0x0000561d48c53622 in _ma_ck_write_btree (info=0x7f82d7a1d070, key=0x7f8306f479e0) at /data/src/10.1/storage/maria/ma_write.c:452 #10 0x0000561d48c57402 in keys_free (key=0x7f82d7b9a118 "\t136052736?}", <incomplete sequence \350>, mode=free_free, param=0x7f82d789b3c0) at /data/src/10.1/storage/maria/ma_write.c:1708 #11 0x0000561d490802a5 in delete_tree_element (tree=0x7f82d789ae70, element=0x7f82d7b9a0f8) at /data/src/10.1/mysys/tree.c:186 #12 0x0000561d4908024a in delete_tree_element (tree=0x7f82d789ae70, element=0x7f82d7b9a210) at /data/src/10.1/mysys/tree.c:184 #13 0x0000561d4908024a in delete_tree_element (tree=0x7f82d789ae70, element=0x7f82d7b9a440) at /data/src/10.1/mysys/tree.c:184 #14 0x0000561d4908024a in delete_tree_element (tree=0x7f82d789ae70, element=0x7f82d7b9a8a0) at /data/src/10.1/mysys/tree.c:184 #15 0x0000561d4908024a in delete_tree_element (tree=0x7f82d789ae70, element=0x7f82d7b9b160) at /data/src/10.1/mysys/tree.c:184 #16 0x0000561d4908024a in delete_tree_element (tree=0x7f82d789ae70, element=0x7f82d7b9c2e0) at /data/src/10.1/mysys/tree.c:184 #17 0x0000561d4908024a in delete_tree_element (tree=0x7f82d789ae70, element=0x7f82d7b9e5e0) at /data/src/10.1/mysys/tree.c:184 #18 0x0000561d4908024a in delete_tree_element (tree=0x7f82d789ae70, element=0x7f82d7ba2be0) at /data/src/10.1/mysys/tree.c:184 #19 0x0000561d4908024a in delete_tree_element (tree=0x7f82d789ae70, element=0x7f82d7bab7e0) at /data/src/10.1/mysys/tree.c:184 #20 0x0000561d4908024a in delete_tree_element (tree=0x7f82d789ae70, element=0x7f82d7b9a168) at /data/src/10.1/mysys/tree.c:184 #21 0x0000561d4908024a in delete_tree_element (tree=0x7f82d789ae70, element=0x7f82d7b9a088) at /data/src/10.1/mysys/tree.c:184 #22 0x0000561d49080146 in free_tree (tree=0x7f82d789ae70, free_flags=2) at /data/src/10.1/mysys/tree.c:154 #23 0x0000561d49080210 in reset_tree (tree=0x7f82d789ae70) at /data/src/10.1/mysys/tree.c:176 #24 0x0000561d4908045b in tree_insert (tree=0x7f82d789ae70, key=0x7f82d7a21a06, key_size=20, custom_arg=0x7f82d789b3c0) at /data/src/10.1/mysys/tree.c:236 #25 0x0000561d48c571aa in _ma_ck_write_tree (info=0x7f82d7a1d070, key=0x7f8306f481f0) at /data/src/10.1/storage/maria/ma_write.c:1656 #26 0x0000561d48c53567 in _ma_ck_write (info=0x7f82d7a1d070, key=0x7f8306f481f0) at /data/src/10.1/storage/maria/ma_write.c:435 #27 0x0000561d48c79d65 in _ma_ft_store (info=0x7f82d7a1d070, keynr=0, keybuf=0x7f82d7a21a06 "\t136052736?}", <incomplete sequence \350>, wlist=0x7f82d79e9088, filepos=878560) at /data/src/10.1/storage/maria/ma_ft_update.c:143 #28 0x0000561d48c7a3ca in _ma_ft_add (info=0x7f82d7a1d070, keynr=0, keybuf=0x7f82d7a21a06 "\t136052736?}", <incomplete sequence \350>, record=0x7f82d785ac88 <incomplete sequence \375>, pos=878560) at /data/src/10.1/storage/maria/ma_ft_update.c:260 #29 0x0000561d48c52970 in maria_write (info=0x7f82d7a1d070, record=0x7f82d785ac88 <incomplete sequence \375>) at /data/src/10.1/storage/maria/ma_write.c:178 #30 0x0000561d48bdb1db in ha_maria::write_row (this=0x7f82d78b6088, buf=0x7f82d785ac88 <incomplete sequence \375>) at /data/src/10.1/storage/maria/ha_maria.cc:1279 #31 0x0000561d48a223cd in handler::ha_write_row (this=0x7f82d78b6088, buf=0x7f82d785ac88 <incomplete sequence \375>) at /data/src/10.1/sql/handler.cc:5963 #32 0x0000561d487b624b in write_record (thd=0x7f82e1351070, table=0x7f82d78d5270, info=0x7f82d7826080) at /data/src/10.1/sql/sql_insert.cc:1915 #33 0x0000561d487baeab in select_insert::send_data (this=0x7f82d7826040, values=...) at /data/src/10.1/sql/sql_insert.cc:3711 #34 0x0000561d48842757 in end_send (join=0x7f82d78260e0, join_tab=0x7f82d7829100, end_of_records=false) at /data/src/10.1/sql/sql_select.cc:19605 #35 0x0000561d488404d0 in evaluate_join_record (join=0x7f82d78260e0, join_tab=0x7f82d7828db8, error=0) at /data/src/10.1/sql/sql_select.cc:18694 #36 0x0000561d4883ff76 in sub_select (join=0x7f82d78260e0, join_tab=0x7f82d7828db8, end_of_records=false) at /data/src/10.1/sql/sql_select.cc:18510 #37 0x0000561d4883f645 in do_select (join=0x7f82d78260e0, fields=0x7f82d78264b0, table=0x0, procedure=0x0) at /data/src/10.1/sql/sql_select.cc:18126 #38 0x0000561d48819ea8 in JOIN::exec_inner (this=0x7f82d78260e0) at /data/src/10.1/sql/sql_select.cc:3275 #39 0x0000561d48817139 in JOIN::exec (this=0x7f82d78260e0) at /data/src/10.1/sql/sql_select.cc:2562 #40 0x0000561d4881a6cf in mysql_select (thd=0x7f82e1351070, rref_pointer_array=0x7f82e1355560, tables=0x7f82d78259b0, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=3489925888, result=0x7f82d7826040, unit=0x7f82e1354bb8, select_lex=0x7f82e13552b8) at /data/src/10.1/sql/sql_select.cc:3499 #41 0x0000561d4880fd88 in handle_select (thd=0x7f82e1351070, lex=0x7f82e1354af0, result=0x7f82d7826040, setup_tables_done_option=1073741824) at /data/src/10.1/sql/sql_select.cc:388 #42 0x0000561d487d8cc1 in mysql_execute_command (thd=0x7f82e1351070) at /data/src/10.1/sql/sql_parse.cc:4039 #43 0x0000561d487e3368 in mysql_parse (thd=0x7f82e1351070, rawbuf=0x7f82d7825088 "INSERT INTO `table1_key_pk_parts_2_int_autoinc` SELECT * FROM `table1_key_pk_parts_2_int_autoinc`", length=97, parser_state=0x7f8306f49630) at /data/src/10.1/sql/sql_parse.cc:7463 #44 0x0000561d487d1cfd in dispatch_command (command=COM_QUERY, thd=0x7f82e1351070, packet=0x7f82e12b6071 "INSERT INTO `table1_key_pk_parts_2_int_autoinc` SELECT * FROM `table1_key_pk_parts_2_int_autoinc`", packet_length=97) at /data/src/10.1/sql/sql_parse.cc:1495 #45 0x0000561d487d0a82 in do_command (thd=0x7f82e1351070) at /data/src/10.1/sql/sql_parse.cc:1124 #46 0x0000561d4890aecd in do_handle_one_connection (thd_arg=0x7f82e1351070) at /data/src/10.1/sql/sql_connect.cc:1330

            People

              monty Michael Widenius
              Enverex Benjamin Hodgetts
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.