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

analyze_stmt test fails in --embedded 10.1

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • None
    • 10.1.1
    • Optimizer
    • None

    Description

      main.analyze_stmt                        [ fail ]
              Test ended at 2014-09-05 08:09:36
       
      CURRENT_TEST: main.analyze_stmt
      mysqltest got signal 11
      read_command_buf (0x7f0d4876f7a0): analyze select * from t1
      conn->name (0x7f0d49cf2380): 
      conn->cur_query (0x7f0d49d18f90): analyze select * from t1
      Attempting backtrace...
      stack_bottom = 0x0 thread_stack 0x48000
      /usr/home/serg/Abk/maria/libmysqld/examples/mysqltest_embedded(my_print_stacktrace+0x38)[0x7f0d475c02e2]
      /usr/home/serg/Abk/maria/libmysqld/examples/mysqltest_embedded(+0x3ebb01)[0x7f0d4758eb01]
      /usr/home/serg/Abk/maria/libmysqld/examples/mysqltest_embedded(+0x3ebb34)[0x7f0d4758eb34]
      /lib64/libpthread.so.0(+0x11260)[0x7f0d46d73260]
      /usr/home/serg/Abk/maria/libmysqld/examples/mysqltest_embedded(_ZN13Protocol_text18prepare_for_resendEv+0x6c)[0x7f0d475ceddc]
      /usr/home/serg/Abk/maria/libmysqld/examples/mysqltest_embedded(_ZN11select_send9send_dataER4ListI4ItemE+0xf2)[0x7f0d47731b9e]
      /usr/home/serg/Abk/maria/libmysqld/examples/mysqltest_embedded(+0x612cf5)[0x7f0d477b5cf5]
      /usr/home/serg/Abk/maria/libmysqld/examples/mysqltest_embedded(+0x610b37)[0x7f0d477b3b37]
      /usr/home/serg/Abk/maria/libmysqld/examples/mysqltest_embedded(_Z10sub_selectP4JOINP13st_join_tableb+0x300)[0x7f0d477b3402]
      /usr/home/serg/Abk/maria/libmysqld/examples/mysqltest_embedded(+0x60fc5e)[0x7f0d477b2c5e]
      /usr/home/serg/Abk/maria/libmysqld/examples/mysqltest_embedded(_ZN4JOIN10exec_innerEv+0x2d3e)[0x7f0d4778e848]
      /usr/home/serg/Abk/maria/libmysqld/examples/mysqltest_embedded(_ZN4JOIN4execEv+0x80)[0x7f0d4778baa0]
      /usr/home/serg/Abk/maria/libmysqld/examples/mysqltest_embedded(_Z12mysql_selectP3THDPPP4ItemP10TABLE_LISTjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x393)[0x7f0d4778f0f9]
      /usr/home/serg/Abk/maria/libmysqld/examples/mysqltest_embedded(_Z13handle_selectP3THDP3LEXP13select_resultm+0x199)[0x7f0d47785073]
      /usr/home/serg/Abk/maria/libmysqld/examples/mysqltest_embedded(+0x5c2827)[0x7f0d47765827]
      /usr/home/serg/Abk/maria/libmysqld/examples/mysqltest_embedded(_Z21mysql_execute_commandP3THD+0x852)[0x7f0d4775f7b9]
      /usr/home/serg/Abk/maria/libmysqld/examples/mysqltest_embedded(_Z11mysql_parseP3THDPcjP12Parser_state+0x1c8)[0x7f0d47766c34]
      /usr/home/serg/Abk/maria/libmysqld/examples/mysqltest_embedded(_Z16dispatch_command19enum_server_commandP3THDPcj+0x93d)[0x7f0d4775d076]
      /usr/home/serg/Abk/maria/libmysqld/examples/mysqltest_embedded(+0x4295e8)[0x7f0d475cc5e8]
      /usr/home/serg/Abk/maria/libmysqld/examples/mysqltest_embedded(mysql_send_query+0x86)[0x7f0d475e20c3]
      /usr/home/serg/Abk/maria/libmysqld/examples/mysqltest_embedded(connection_thread+0xcd)[0x7f0d4757d5f2]
      /lib64/libpthread.so.0(+0x91da)[0x7f0d46d6b1da]
      /lib64/libc.so.6(clone+0x6d)[0x7f0d4493d95d]
      Writing a core file...
       
       - saving '/usr/home/serg/Abk/maria/mysql-test/var/log/main.analyze_stmt/' to '/usr/home/serg/Abk/maria/mysql-test/var/log/main.analyze_stmt/'
      --------------------------------------------------------------------------
      The servers were restarted 0 times
      Spent 0.000 of 4 seconds executing testcases
       
      Failure: Failed 1/1 tests, 0.00% were successful.
       
      Failing test(s): main.analyze_stmt

      Attachments

        Activity

          Stack trace

            0x00007f229f8f83b6 in Protocol_text::prepare_for_resend (this=0x7f22a2565080) at /home/psergey/dev-git/10.1/libmysqld/lib_sql.cc:1254
          (gdb) wher
            #0  0x00007f229f8f83b6 in Protocol_text::prepare_for_resend (this=0x7f22a2565080) at /home/psergey/dev-git/10.1/libmysqld/lib_sql.cc:1254
            #1  0x00007f229fbd3e4e in select_send::send_data (this=0x7f22a24f19b0, items=...) at /home/psergey/dev-git/10.1/sql/sql_class.cc:2666
            #2  0x00007f229fabb0f1 in end_send (join=0x7f22a24f19d0, join_tab=0x7f22a24f2d78, end_of_records=false) at /home/psergey/dev-git/10.1/sql/sql_select.cc:18755
            #3  0x00007f229fab8f71 in evaluate_join_record (join=0x7f22a24f19d0, join_tab=0x7f22a24f2a38, error=0) at /home/psergey/dev-git/10.1/sql/sql_select.cc:17863
            #4  0x00007f229fab8865 in sub_select (join=0x7f22a24f19d0, join_tab=0x7f22a24f2a38, end_of_records=false) at /home/psergey/dev-git/10.1/sql/sql_select.cc:17638
            #5  0x00007f229fab80d0 in do_select (join=0x7f22a24f19d0, fields=0x7f22a1771a50, table=0x0, procedure=0x0) at /home/psergey/dev-git/10.1/sql/sql_select.cc:17298
            #6  0x00007f229fa93bb9 in JOIN::exec_inner (this=0x7f22a24f19d0) at /home/psergey/dev-git/10.1/sql/sql_select.cc:3093
            #7  0x00007f229fa90e18 in JOIN::exec (this=0x7f22a24f19d0) at /home/psergey/dev-git/10.1/sql/sql_select.cc:2388
            #8  0x00007f229fa94469 in mysql_select (thd=0x7f22a176da50, rref_pointer_array=0x7f22a1771bb0, tables=0x7f22a24f1328, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f22a24f19b0, unit=0x7f22a1771250, select_lex=0x7f22a1771938) at /home/psergey/dev-git/10.1/sql/sql_select.cc:3320
            #9  0x00007f229fa8a312 in handle_select (thd=0x7f22a176da50, lex=0x7f22a1771188, result=0x7f22a24f19b0, setup_tables_done_option=0) at /home/psergey/dev-git/10.1/sql/sql_select.cc:372

          we crash in Protocol_text::prepare_for_resend here:

            data->rows++;

          and the reason is that data==NULL.

          psergei Sergei Petrunia added a comment - Stack trace 0x00007f229f8f83b6 in Protocol_text::prepare_for_resend (this=0x7f22a2565080) at /home/psergey/dev-git/10.1/libmysqld/lib_sql.cc:1254 (gdb) wher #0 0x00007f229f8f83b6 in Protocol_text::prepare_for_resend (this=0x7f22a2565080) at /home/psergey/dev-git/10.1/libmysqld/lib_sql.cc:1254 #1 0x00007f229fbd3e4e in select_send::send_data (this=0x7f22a24f19b0, items=...) at /home/psergey/dev-git/10.1/sql/sql_class.cc:2666 #2 0x00007f229fabb0f1 in end_send (join=0x7f22a24f19d0, join_tab=0x7f22a24f2d78, end_of_records=false) at /home/psergey/dev-git/10.1/sql/sql_select.cc:18755 #3 0x00007f229fab8f71 in evaluate_join_record (join=0x7f22a24f19d0, join_tab=0x7f22a24f2a38, error=0) at /home/psergey/dev-git/10.1/sql/sql_select.cc:17863 #4 0x00007f229fab8865 in sub_select (join=0x7f22a24f19d0, join_tab=0x7f22a24f2a38, end_of_records=false) at /home/psergey/dev-git/10.1/sql/sql_select.cc:17638 #5 0x00007f229fab80d0 in do_select (join=0x7f22a24f19d0, fields=0x7f22a1771a50, table=0x0, procedure=0x0) at /home/psergey/dev-git/10.1/sql/sql_select.cc:17298 #6 0x00007f229fa93bb9 in JOIN::exec_inner (this=0x7f22a24f19d0) at /home/psergey/dev-git/10.1/sql/sql_select.cc:3093 #7 0x00007f229fa90e18 in JOIN::exec (this=0x7f22a24f19d0) at /home/psergey/dev-git/10.1/sql/sql_select.cc:2388 #8 0x00007f229fa94469 in mysql_select (thd=0x7f22a176da50, rref_pointer_array=0x7f22a1771bb0, tables=0x7f22a24f1328, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f22a24f19b0, unit=0x7f22a1771250, select_lex=0x7f22a1771938) at /home/psergey/dev-git/10.1/sql/sql_select.cc:3320 #9 0x00007f229fa8a312 in handle_select (thd=0x7f22a176da50, lex=0x7f22a1771188, result=0x7f22a24f19b0, setup_tables_done_option=0) at /home/psergey/dev-git/10.1/sql/sql_select.cc:372 we crash in Protocol_text::prepare_for_resend here: data->rows++; and the reason is that data==NULL.

          People

            psergei Sergei Petrunia
            serg Sergei Golubchik
            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.