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

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

      Attachments

        Issue Links

          Activity

            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.

            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

              serg Sergei Golubchik
              elenst Elena Stepanova
              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.