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

get_lock() crashes on Windows, main.sp_notembedded and main.trigger_notembedded fail in buildbot

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.0
    • Fix Version/s: 10.0.16
    • Component/s: Tests
    • Labels:

      Description

      http://buildbot.askmonty.org/buildbot/builders/win32-debug2/builds/6560/steps/test/logs/stdio

      main.sp_notembedded                      [ fail ]
              Test ended at 2014-11-21 17:53:25
      
      CURRENT_TEST: main.sp_notembedded
      mysqltest: At line 331: query 'SELECT GET_LOCK('Bug44521', 0)' failed: 2013: Lost connection to MySQL server during query
      
      The result from queries just before the failure was:
      < snip >
      Delete_priv, Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv, File_priv,
      Grant_priv, References_priv, Index_priv, Alter_priv, Show_db_priv, Super_priv,
      Create_tmp_table_priv, Lock_tables_priv, Execute_priv, Repl_slave_priv, Repl_client_priv,
      Create_view_priv, Show_view_priv, Create_routine_priv, Alter_routine_priv,
      Create_user_priv, ssl_type, ssl_cipher, x509_issuer, x509_subject, max_questions,
      max_updates, max_connections, max_user_connections) 
      VALUES('%', 'mysqltest_1', password(''), 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N',
      'N', 'N', 'N', 'Y', 'Y', 'N', 'N', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'Y', 'Y', 'N', '',
      '', '', '', '0', '0', '0', '0');
      Warnings:
      Warning	1364	Field 'authentication_string' doesn't have a default value
      FLUSH PRIVILEGES;
      CREATE PROCEDURE p1(i INT) BEGIN END;
      DROP PROCEDURE p1;
      DELETE FROM mysql.user WHERE User='mysqltest_1';
      FLUSH PRIVILEGES;
      #
      # Bug#44521 Prepared Statement: CALL p() - crashes: `! thd->main_da.is_sent' failed et.al.
      #
      SELECT GET_LOCK('Bug44521', 0);
      
      More results from queries before failure can be found in C:\bzr\bb-win32\win32-debug2\build\mysql-test\var\log\sp_notembedded.log
      
      
      Server [mysqld.1 - pid: 281136, winpid: 281136, exit: 768] failed during test run
      Server log from this test:
      ----------SERVER LOG START-----------
      ----------SERVER LOG END-------------
      
      main.trigger_notembedded                 [ fail ]
              Test ended at 2014-11-21 17:57:03
      
      CURRENT_TEST: main.trigger_notembedded
      mysqltest: At line 897: query 'SELECT GET_LOCK('B26162',120)' failed: 2013: Lost connection to MySQL server during query
      
      The result from queries just before the failure was:
      < snip >
      ERROR 42000: SELECT command denied to user 'mysqltest_dfn'@'localhost' for column 'i1' in table 't1'
      DROP PROCEDURE p1;
      CREATE PROCEDURE p1(INOUT i INT) DETERMINISTIC NO SQL SET i = i + 51;
      INSERT INTO t1 VALUES (53);
      ERROR 42000: SELECT command denied to user 'mysqltest_dfn'@'localhost' for column 'i1' in table 't1'
      DROP PROCEDURE p1;
      REVOKE UPDATE ON mysqltest_db1.* FROM mysqltest_dfn@localhost;
      DROP TRIGGER t1_bi;
      DROP USER mysqltest_inv@localhost;
      DROP USER mysqltest_dfn@localhost;
      DROP TABLE t2;
      DROP TABLE t1;
      DROP DATABASE mysqltest_db1;
      USE test;
      CREATE TABLE t1 (id INTEGER);
      CREATE TABLE t2 (id INTEGER);
      INSERT INTO t2 VALUES (1),(2);
      CREATE TRIGGER t1_test AFTER INSERT ON t1 FOR EACH ROW 
      INSERT INTO t2 VALUES (new.id);
      SELECT GET_LOCK('B26162',120);
      
      More results from queries before failure can be found in C:\bzr\bb-win32\win32-debug2\build\mysql-test\var\log\trigger_notembedded.log
      
      
      Server [mysqld.1 - pid: 278220, winpid: 278220, exit: 768] failed during test run
      Server log from this test:
      ----------SERVER LOG START-----------
      ----------SERVER LOG END-------------
      

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

              Hide
              elenst Elena Stepanova added a comment - - edited
              select get_lock('Bug44521',0)
              
              mysqld.exe!my_sigabrt_handler()[my_thr_init.c:475]
              mysqld.exe!raise()[winsig.c:593]
              mysqld.exe!abort()[abort.c:82]
              mysqld.exe!_wassert()[assert.c:155]
              mysqld.exe!MDL_key::mdl_key_init()[mdl.h:354]
              mysqld.exe!MDL_request::init()[mdl.cc:1244]
              mysqld.exe!Item_func_get_lock::val_int()[item_func.cc:4280]
              mysqld.exe!Item::send()[item.cc:6489]
              mysqld.exe!Protocol::send_result_set_row()[protocol.cc:904]
              mysqld.exe!select_send::send_data()[sql_class.cc:2542]
              mysqld.exe!JOIN::exec_inner()[sql_select.cc:2456]
              mysqld.exe!JOIN::exec()[sql_select.cc:2372]
              mysqld.exe!mysql_select()[sql_select.cc:3310]
              mysqld.exe!handle_select()[sql_select.cc:373]
              mysqld.exe!execute_sqlcom_select()[sql_parse.cc:5261]
              mysqld.exe!mysql_execute_command()[sql_parse.cc:2545]
              mysqld.exe!mysql_parse()[sql_parse.cc:6407]
              mysqld.exe!dispatch_command()[sql_parse.cc:1302]
              mysqld.exe!do_command()[sql_parse.cc:996]
              mysqld.exe!threadpool_process_request()[threadpool_common.cc:233]
              mysqld.exe!io_completion_callback()[threadpool_win.cc:568]
              kernel32.dll!BaseFormatTimeOut()
              ntdll.dll!RtlEqualDomainName()
              ntdll.dll!RtlValidateHeap()
              kernel32.dll!BaseThreadInitThunk()
              ntdll.dll!RtlUserThreadStart()
              

              Only aborts on debug build, release seems to be okay.

              Show
              elenst Elena Stepanova added a comment - - edited select get_lock('Bug44521',0) mysqld.exe!my_sigabrt_handler()[my_thr_init.c:475] mysqld.exe!raise()[winsig.c:593] mysqld.exe!abort()[abort.c:82] mysqld.exe!_wassert()[assert.c:155] mysqld.exe!MDL_key::mdl_key_init()[mdl.h:354] mysqld.exe!MDL_request::init()[mdl.cc:1244] mysqld.exe!Item_func_get_lock::val_int()[item_func.cc:4280] mysqld.exe!Item::send()[item.cc:6489] mysqld.exe!Protocol::send_result_set_row()[protocol.cc:904] mysqld.exe!select_send::send_data()[sql_class.cc:2542] mysqld.exe!JOIN::exec_inner()[sql_select.cc:2456] mysqld.exe!JOIN::exec()[sql_select.cc:2372] mysqld.exe!mysql_select()[sql_select.cc:3310] mysqld.exe!handle_select()[sql_select.cc:373] mysqld.exe!execute_sqlcom_select()[sql_parse.cc:5261] mysqld.exe!mysql_execute_command()[sql_parse.cc:2545] mysqld.exe!mysql_parse()[sql_parse.cc:6407] mysqld.exe!dispatch_command()[sql_parse.cc:1302] mysqld.exe!do_command()[sql_parse.cc:996] mysqld.exe!threadpool_process_request()[threadpool_common.cc:233] mysqld.exe!io_completion_callback()[threadpool_win.cc:568] kernel32.dll!BaseFormatTimeOut() ntdll.dll!RtlEqualDomainName() ntdll.dll!RtlValidateHeap() kernel32.dll!BaseThreadInitThunk() ntdll.dll!RtlUserThreadStart() Only aborts on debug build, release seems to be okay.

                People

                • Assignee:
                  serg Sergei Golubchik
                  Reporter:
                  elenst Elena Stepanova
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Time Tracking

                    Estimated:
                    Original Estimate - Not Specified
                    Not Specified
                    Remaining:
                    Remaining Estimate - 0 minutes
                    0m
                    Logged:
                    Time Spent - 20 minutes
                    20m