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

[Draft] Server crashes in in heap_check_heap

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 10.1(EOL), 10.4(EOL)
    • N/A
    • Server
    • None

    Description

      10.1 f1bcfbb4373e40dda2c18c137f76fc6ff32e1a45

      Version: '10.1.37-MariaDB-debug'  socket: '/home/travis/logs/vardir/mysql.sock'  port: 19300  Source distribution
      2018-09-08 22:38:47 7f3c7c2cdb00  InnoDB: Operating system error number 2 in a file operation.
      InnoDB: The error means the system cannot find the path specified.
      2018-09-08 22:38:47 139897758079744 [ERROR] InnoDB: Cannot rename file './testdb_N/t1_base2_N.ibd' to './testdb_S/t1_base2_N.ibd'
      2018-09-08 22:39:07 139897756261120 [ERROR] Event Scheduler: [rqg@localhost][testdb_S.e1_1_S] Table 'testdb_S.t1_part1_N' doesn't exist
      180908 22:39:07 [ERROR] mysqld got signal 11 ;
       
      Query (0x7f3c58004688): FLUSH TABLES /* QNO 2818 CON_ID 12 */
      Connection ID (thread ID): 48
      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,orderby_uses_equalities=off
      

      #3  <signal handler called>
      #4  0x000055874eb9d4c6 in heap_check_heap (info=0x7f3c580417a0, print_status=0 '\000') at /home/travis/src/storage/heap/_check.c:82
      #5  0x000055874eb9c18d in hp_close (info=0x7f3c580417a0) at /home/travis/src/storage/heap/hp_close.c:39
      #6  0x000055874eb9c104 in heap_close (info=0x7f3c580417a0) at /home/travis/src/storage/heap/hp_close.c:28
      #7  0x000055874eb93dc7 in ha_heap::close (this=0x7f3c58040e68) at /home/travis/src/storage/heap/ha_heap.cc:141
      #8  0x000055874e9e6d43 in handler::ha_close (this=0x7f3c58040e68) at /home/travis/src/sql/handler.cc:2599
      #9  0x000055874e88ee89 in closefrm (table=0x7f3c58040220, free_share=true) at /home/travis/src/sql/table.cc:3063
      #10 0x000055874e72dfa1 in intern_close_table (table=0x7f3c58040220) at /home/travis/src/sql/sql_base.cc:354
      #11 0x000055874e9681c6 in tc_purge (mark_flushed=true) at /home/travis/src/sql/table_cache.cc:204
      #12 0x000055874e72e3c4 in close_cached_tables (thd=0x5587525f49b0, tables=0x0, wait_for_refresh=true, timeout=10) at /home/travis/src/sql/sql_base.cc:485
      #13 0x000055874e909d6b in reload_acl_and_cache (thd=0x5587525f49b0, options=4, tables=0x0, write_to_binlog=0x7f3c7c2cbd70) at /home/travis/src/sql/sql_reload.cc:343
      #14 0x000055874e7a1cc0 in mysql_execute_command (thd=0x5587525f49b0) at /home/travis/src/sql/sql_parse.cc:4885
      #15 0x000055874e7a9230 in mysql_parse (thd=0x5587525f49b0, rawbuf=0x7f3c58004688 "FLUSH TABLES /* QNO 2818 CON_ID 12 */", length=37, parser_state=0x7f3c7c2cc630) at /home/travis/src/sql/sql_parse.cc:7465
      #16 0x000055874e797ab1 in dispatch_command (command=COM_QUERY, thd=0x5587525f49b0, packet=0x55875254bda1 "FLUSH TABLES /* QNO 2818 CON_ID 12 */ ", packet_length=38) at /home/travis/src/sql/sql_parse.cc:1495
      #17 0x000055874e796831 in do_command (thd=0x5587525f49b0) at /home/travis/src/sql/sql_parse.cc:1124
      #18 0x000055874e8d1e99 in do_handle_one_connection (thd_arg=0x5587525f49b0) at /home/travis/src/sql/sql_connect.cc:1330
      #19 0x000055874e8d1bfd in handle_one_connection (arg=0x5587525f49b0) at /home/travis/src/sql/sql_connect.cc:1242
      #20 0x00007f3c958f6184 in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
      #21 0x00007f3c95018ffd in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      github.com/elenst/rqg mdev15376 aa7bc7508b939e11fc7e444384290d5950a06f4f

      perl /home/travis/rqg/runall-new.pl --basedir=/home/travis/server --vardir=/home/travis/logs/vardir --duration=350 --seed=1530946075 --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --views --redefine=conf/mariadb/alter_table.yy --redefine=conf/mariadb/bulk_insert.yy --mysqld=--log_output=FILE --mysqld=--max-statement-time=30 --mysqld=--lock-wait-timeout=10 --mysqld=--loose-innodb-lock-wait-timeout=5 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --mysqld=--log_bin_trust_function_creators=1 --mysqld=--default-storage-engine=MyISAM --grammar=conf/runtime/connect_kill_sql.yy --gendata=conf/runtime/connect_kill_data.zz --mysqld=--log-bin --transformers=ExecuteAsDeleteReturning,ExecuteAsInsertSelect,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView,ExecuteAsPreparedTwice,ExecuteAsSPTwice --redefine=conf/mariadb/general-workarounds.yy --threads=6
      

      No information yet on whether it's reproducible

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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