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

[Draft] Server crashes in myrocks::Rdb_trx_info_aggregator::process_tran

    XMLWordPrintable

Details

    Description

      https://travis-ci.org/elenst/travis-tests/jobs/403111694

      bb-10.2-mdev16428 af1568668f6a910b5739fe1d7181c59f94a95196

      180712 23:42:08 [ERROR] mysqld got signal 11 ;
       
      #3  <signal handler called>
      #4  0x00007f2e194ee694 in myrocks::Rdb_trx_info_aggregator::process_tran (this=0x7f2dfcfafcb0, tx=0x7f2dcc65b8d0) at /home/travis/src/storage/rocksdb/ha_rocksdb.cc:3947
      #5  0x00007f2e194e84d0 in myrocks::Rdb_transaction::walk_tx_list (walker=0x7f2dfcfafcb0) at /home/travis/src/storage/rocksdb/ha_rocksdb.cc:2035
      #6  0x00007f2e194ba6bc in myrocks::rdb_get_all_trx_info () at /home/travis/src/storage/rocksdb/ha_rocksdb.cc:3959
      #7  0x00007f2e195275c3 in myrocks::rdb_i_s_trx_info_fill_table (thd=0x7f2df8001d50, tables=0x7f2df8012598, cond=0x0) at /home/travis/src/storage/rocksdb/rdb_i_s.cc:1447
      #8  0x000056282f35b210 in get_schema_tables_result (join=0x7f2df8013df0, executed_place=PROCESSED_BY_JOIN_EXEC) at /home/travis/src/sql/sql_show.cc:8350
      #9  0x000056282f2f8fb7 in JOIN::exec_inner (this=0x7f2df8013df0) at /home/travis/src/sql/sql_select.cc:3549
      #10 0x000056282f2f8672 in JOIN::exec (this=0x7f2df8013df0) at /home/travis/src/sql/sql_select.cc:3380
      #11 0x000056282f2f9870 in mysql_select (thd=0x7f2df8001d50, tables=0x7f2df8012598, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2684619520, result=0x7f2df8013dd0, unit=0x7f2df80058f0, select_lex=0x7f2df8006028) at /home/travis/src/sql/sql_select.cc:3780
      #12 0x000056282f2edd7c in handle_select (thd=0x7f2df8001d50, lex=0x7f2df8005828, result=0x7f2df8013dd0, setup_tables_done_option=0) at /home/travis/src/sql/sql_select.cc:376
      #13 0x000056282f2b9603 in execute_sqlcom_select (thd=0x7f2df8001d50, all_tables=0x7f2df8012598) at /home/travis/src/sql/sql_parse.cc:6476
      #14 0x000056282f2af629 in mysql_execute_command (thd=0x7f2df8001d50) at /home/travis/src/sql/sql_parse.cc:3483
      #15 0x000056282f2bd1ff in mysql_parse (thd=0x7f2df8001d50, rawbuf=0x7f2df8012268 "SELECT COUNT(*) FROM INFORMATION_SCHEMA.ROCKSDB_TRX", length=51, parser_state=0x7f2dfcfb1210, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:7941
      #16 0x000056282f2aaed2 in dispatch_command (command=COM_QUERY, thd=0x7f2df8001d50, packet=0x7f2df80099f1 "SELECT COUNT(*) FROM INFORMATION_SCHEMA.ROCKSDB_TRX", packet_length=51, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:1820
      #17 0x000056282f2a9835 in do_command (thd=0x7f2df8001d50) at /home/travis/src/sql/sql_parse.cc:1374
      #18 0x000056282f3f99d4 in do_handle_one_connection (connect=0x562832510980) at /home/travis/src/sql/sql_connect.cc:1335
      #19 0x000056282f3f9761 in handle_one_connection (arg=0x562832510980) at /home/travis/src/sql/sql_connect.cc:1241
      #20 0x00007f2e1c9d6184 in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
      #21 0x00007f2e1bee2ffd in clone () from /lib/x86_64-linux-gnu/libc.so.6
       
      Query (0x7f2df8012268): SELECT COUNT(*) FROM INFORMATION_SCHEMA.ROCKSDB_TRX
      Connection ID (thread ID): 19
      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=on,condition_pushdown_for_derived=on
      

      merge aa7bc7508b939e11fc7e444384290d5950a06f4f

      perl /home/travis/rqg/runall-new.pl --basedir=/home/travis/server --vardir=/home/travis/logs/vardir --engine=RocksDB --duration=350 --threads=6 --seed=1531438916 --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --views --redefine=conf/mariadb/alter_table.yy --redefine=conf/mariadb/bulk_insert.yy --mysqld=--log_output=FILE --mysqld=--lock-wait-timeout=10 --mysqld=--loose-innodb-lock-wait-timeout=5 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --mysqld=--default-storage-engine=RocksDB --mysqld=--plugin-load-add=ha_rocksdb --grammar=conf/mariadb/functions.yy --skip-gendata --gendata-advanced --vcols --transformers=ExecuteAsCTE,ExecuteAsDeleteReturning,ExecuteAsExecuteImmediate,ExecuteAsInsertSelect,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView,ExecuteAsPreparedTwice,ExecuteAsSPTwice
      

      Coredump is not available this time.


      https://travis-ci.org/elenst/travis-tests/jobs/403550663#L537

      bb-10.2-mdev16428 b528b069a169d6e3d9ef4f9c7de68ead3e29186f

      pure virtual method called
      terminate called without an active exception
      180713 14:50:37 [ERROR] mysqld got signal 6 ;
       
      #5  0x00007f9892674028 in abort () from /lib/x86_64-linux-gnu/libc.so.6
      #6  0x00007f9892f7f535 in __gnu_cxx::__verbose_terminate_handler() () from /usr/lib/x86_64-linux-gnu/libstdc++.so.6
      #7  0x00007f9892f7d6d6 in ?? () from /usr/lib/x86_64-linux-gnu/libstdc++.so.6
      #8  0x00007f9892f7d703 in std::terminate() () from /usr/lib/x86_64-linux-gnu/libstdc++.so.6
      #9  0x00007f9892f7e1bf in __cxa_pure_virtual () from /usr/lib/x86_64-linux-gnu/libstdc++.so.6
      #10 0x00007f9884dbd27e in myrocks::Rdb_trx_info_aggregator::process_tran (this=0x7f9881960860, tx=0x7f98416c15c0) at /home/travis/src/storage/rocksdb/ha_rocksdb.cc:3906
      #11 0x00007f9884db74d0 in myrocks::Rdb_transaction::walk_tx_list (walker=0x7f9881960860) at /home/travis/src/storage/rocksdb/ha_rocksdb.cc:2033
      #12 0x00007f9884d896bc in myrocks::rdb_get_all_trx_info () at /home/travis/src/storage/rocksdb/ha_rocksdb.cc:3959
      #13 0x00007f9884df657b in myrocks::rdb_i_s_trx_info_fill_table (thd=0x7f987800c700, tables=0x7f987801cb08, cond=0x7f9878871400) at /home/travis/src/storage/rocksdb/rdb_i_s.cc:1447
      #14 0x00005586b72ff210 in get_schema_tables_result (join=0x7f9878020358, executed_place=PROCESSED_BY_JOIN_EXEC) at /home/travis/src/sql/sql_show.cc:8350
      #15 0x00005586b729cfb7 in JOIN::exec_inner (this=0x7f9878020358) at /home/travis/src/sql/sql_select.cc:3549
      #16 0x00005586b729c672 in JOIN::exec (this=0x7f9878020358) at /home/travis/src/sql/sql_select.cc:3380
      #17 0x00005586b729d870 in mysql_select (thd=0x7f987800c700, tables=0x7f987801cb08, wild_num=0, fields=..., conds=0x7f987801d8b8, og_num=0, order=0x0, group=0x0, having=0x7f987801e018, proc_param=0x0, select_options=2953054976, result=0x7f9878020288, unit=0x7f987801c238, select_lex=0x7f987801be48) at /home/travis/src/sql/sql_select.cc:3780
      #18 0x00005586b7224cab in mysql_derived_fill (thd=0x7f987800c700, lex=0x7f98780101d8, derived=0x7f987801e4d0) at /home/travis/src/sql/sql_derived.cc:1124
      #19 0x00005586b7222baf in mysql_handle_single_derived (lex=0x7f98780101d8, derived=0x7f987801e4d0, phases=96) at /home/travis/src/sql/sql_derived.cc:197
      #20 0x00005586b72b3083 in st_join_table::preread_init (this=0x7f98788726c8) at /home/travis/src/sql/sql_select.cc:11962
      #21 0x00005586b72c329d in sub_select (join=0x7f987801fd30, join_tab=0x7f98788726c8, end_of_records=false) at /home/travis/src/sql/sql_select.cc:18678
      #22 0x00005586b72c29d7 in do_select (join=0x7f987801fd30, procedure=0x0) at /home/travis/src/sql/sql_select.cc:18254
      #23 0x00005586b729d1bd in JOIN::exec_inner (this=0x7f987801fd30) at /home/travis/src/sql/sql_select.cc:3585
      #24 0x00005586b729c672 in JOIN::exec (this=0x7f987801fd30) at /home/travis/src/sql/sql_select.cc:3380
      #25 0x00005586b729d870 in mysql_select (thd=0x7f987800c700, tables=0x7f987801e4d0, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=551903562496, result=0x7f987801fd10, unit=0x7f98780102a0, select_lex=0x7f98780109d8) at /home/travis/src/sql/sql_select.cc:3780
      #26 0x00005586b7291d7c in handle_select (thd=0x7f987800c700, lex=0x7f98780101d8, result=0x7f987801fd10, setup_tables_done_option=0) at /home/travis/src/sql/sql_select.cc:376
      #27 0x00005586b725d603 in execute_sqlcom_select (thd=0x7f987800c700, all_tables=0x7f987801e4d0) at /home/travis/src/sql/sql_parse.cc:6476
      #28 0x00005586b7253629 in mysql_execute_command (thd=0x7f987800c700) at /home/travis/src/sql/sql_parse.cc:3483
      #29 0x00005586b72611ff in mysql_parse (thd=0x7f987800c700, rawbuf=0x7f987801b9f8 "/* GenTest::Transform::ExecuteAsCTE */  WITH cte1 AS ( SELECT * FROM INFORMATION_SCHEMA.`ROCKSDB_TRX` AS table1 WHERE( table1.`WAITING_KEY` >= '2013-03-15 07:50:12.006703' OR table1.`HAS_DEADLOCK_DETE"..., length=422, parser_state=0x7f9881962210, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:7941
      #30 0x00005586b724eed2 in dispatch_command (command=COM_QUERY, thd=0x7f987800c700, packet=0x7f98780138c1 "", packet_length=423, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:1820
      #31 0x00005586b724d835 in do_command (thd=0x7f987800c700) at /home/travis/src/sql/sql_parse.cc:1374
      #32 0x00005586b739d9d4 in do_handle_one_connection (connect=0x5586bafc3420) at /home/travis/src/sql/sql_connect.cc:1335
      #33 0x00005586b739d761 in handle_one_connection (arg=0x5586bafc3420) at /home/travis/src/sql/sql_connect.cc:1241
      #34 0x00007f989322b184 in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
      #35 0x00007f9892737ffd in clone () from /lib/x86_64-linux-gnu/libc.so.6
       
      Query (0x7f987801b9f8): /* GenTest::Transform::ExecuteAsCTE */  WITH cte1 AS ( SELECT * FROM INFORMATION_SCHEMA.`ROCKSDB_TRX` AS table1 WHERE( table1.`WAITING_KEY` >= '2013-03-15 07:50:12.006703' OR table1.`HAS_DEADLOCK_DETECTION` = table1.`WRITE_COUNT`) HAVING( table1.`WAITING_KEY` <= 'ub' OR table1.`IS_REPLICATION` <> 0) LIMIT 2 /* QNO 12393 CON_ID 20 */ ) SELECT * FROM cte1  /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 12394 CON_ID 20 */
      Connection ID (thread ID): 20
      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=on,condition_pushdown_for_derived=on
      

      perl /home/travis/rqg/runall-new.pl --basedir=/home/travis/server --vardir=/home/travis/logs/vardir --engine=RocksDB --duration=350 --threads=6 --seed=1531493252 --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --views --redefine=conf/mariadb/alter_table.yy --redefine=conf/mariadb/bulk_insert.yy --mysqld=--log_output=FILE --mysqld=--lock-wait-timeout=10 --mysqld=--loose-innodb-lock-wait-timeout=5 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --mysqld=--default-storage-engine=RocksDB --mysqld=--plugin-load-add=ha_rocksdb --grammar=conf/runtime/information_schema.yy --transformers=ExecuteAsCTE,ExecuteAsDeleteReturning,ExecuteAsExecuteImmediate,ExecuteAsInsertSelect,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView,ExecuteAsPreparedTwice,ExecuteAsSPTwice
      

      Stack traces: threads, threads_full
      Coredump, datadir etc. are available on demand.

      Attachments

        1. threads
          67 kB
        2. threads_full
          408 kB

        Activity

          People

            elenst Elena Stepanova
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.