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

[draft] Assertion `inited==NONE || (inited==RND && scan)' failed

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 10.3(EOL)
    • N/A
    • N/A
    • None

    Description

      10.3 186a998b5b932851d64666c92e3062

      mysqld: /home/alice/git/10.3/sql/handler.h:3060: int handler::ha_rnd_init(bool): Assertion `inited==NONE || (inited==RND && scan)' failed.
      180704  9:16:56 [ERROR] mysqld got signal 6 ;
      Server version: 10.3.9-MariaDB-debug-log
       
      Thread pointer: 0x62a00007e270
       
      stack_bottom = 0x7fd3982ffe40 thread_stack 0x49000
      /usr/lib/x86_64-linux-gnu/libasan.so.2(+0x4a077)[0x7fd3c78b9077]
      /home/alice/git/10.3/sql/mysqld(my_print_stacktrace+0xb3)[0x55f499c4ba64]
      mysys/stacktrace.c:269(my_print_stacktrace)[0x55f498b8fa8d]
      /lib/x86_64-linux-gnu/libpthread.so.0(+0x11390)[0x7fd3c6725390]
      linux/raise.c:54(__GI_raise)[0x7fd3c5ade428]
      stdlib/abort.c:91(__GI_abort)[0x7fd3c5ae002a]
      assert/assert.c:92(__assert_fail_base)[0x7fd3c5ad6bd7]
      /lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7fd3c5ad6c82]
      sql/handler.h:3061(handler::ha_rnd_init(bool))[0x55f49843d714]
      sql/handler.cc:2980(handler::ha_rnd_init_with_error(bool))[0x55f498ba6bc3]
      sql/opt_range.cc:1623(QUICK_ROR_INTERSECT_SELECT::init_ror_merged_scan(bool, st_mem_root*))[0x55f498ed361d]
      sql/opt_range.cc:1644(QUICK_ROR_INTERSECT_SELECT::reset())[0x55f498ed3891]
      sql/sql_select.cc:20188(join_init_read_record(st_join_table*))[0x55f4985ebb37]
      sql/sql_select.cc:20136(join_init_quick_read_record(st_join_table*))[0x55f4985eb2e5]
      sql/sql_select.cc:19268(sub_select(JOIN*, st_join_table*, bool))[0x55f4985e585d]
      sql/sql_select.cc:19491(evaluate_join_record(JOIN*, st_join_table*, int))[0x55f4985e6e12]
      sql/sql_select.cc:19310(sub_select(JOIN*, st_join_table*, bool))[0x55f4985e6094]
      sql/sql_select.cc:18811(do_select(JOIN*, Procedure*))[0x55f4985e3eb5]
      sql/sql_select.cc:4021(JOIN::exec_inner())[0x55f4985837dd]
      sql/sql_select.cc:3816(JOIN::exec())[0x55f498581522]
      sql/sql_select.cc:4222(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x55f4985848f4]
      sql/sql_select.cc:382(handle_select(THD*, LEX*, select_result*, unsigned long))[0x55f498560139]
      sql/sql_parse.cc:6542(execute_sqlcom_select(THD*, TABLE_LIST*))[0x55f4984e5c8a]
      sql/sql_parse.cc:3765(mysql_execute_command(THD*))[0x55f4984d449d]
      sql/sql_parse.cc:8073(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55f4984ee598]
      sql/sql_parse.cc:1849(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55f4984c927f]
      sql/sql_parse.cc:1392(do_command(THD*))[0x55f4984c6417]
      sql/sql_connect.cc:1402(do_handle_one_connection(CONNECT*))[0x55f498815872]
      sql/sql_connect.cc:1309(handle_one_connection)[0x55f49881524f]
      /lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7fd3c671b6ba]
      /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7fd3c5bb041d]
       
      Trying to get some variables.
      Some pointers may be invalid and cause the dump to abort.
      Query (0x62b000007288): SELECT DISTINCT STRAIGHT_JOIN alias1.`col_int_key` AS field1, alias2.`pk` AS field2, alias2.`col_int_key` AS field3, alias2.`col_int_key` AS field4, alias1.`pk` AS field5 FROM E AS alias1 LEFT OUTER JOIN E AS alias2 ON alias1.`col_int_key` = alias2.`col_int_key` WHERE alias2.`pk` > alias1.`pk` GROUP BY field1, field2, field3, field4, field5 HAVING field1 > 5 ORDER BY field1  /* QNO 20285 CON_ID 16 */
      Connection ID (thread ID): 16
      Status: NOT_KILLED
      

      Attachments

        Issue Links

          Activity

            People

              alice Alice Sherepa
              alice Alice Sherepa
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.