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

analyze_stmt test fails in --embedded 10.1

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Critical
        • Resolution: Fixed
        • Affects Version/s: None
        • Fix Version/s: 10.1.1
        • Component/s: Optimizer
        • Labels:
          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

            Gliffy Diagrams

              Attachments

                Activity

                Hide
                Permalink
                psergey 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.

                Show
                psergey 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

                  • Assignee:
                    psergey Sergei Petrunia
                    Reporter:
                    serg Sergei Golubchik
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    2 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: