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 created issue -
            elenst Elena Stepanova made changes -
            Field Original Value New Value
            elenst Elena Stepanova made changes -
            Summary main.sp_notembedded fails in buildbot on Windows main.sp_notembedded and main.trigger_notembedded fail in buildbot on Windows
            elenst Elena Stepanova made changes -
            Description http://buildbot.askmonty.org/buildbot/builders/win32-debug2/builds/6560/steps/test/logs/stdio

            {noformat}
            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-------------
            {noformat}
            http://buildbot.askmonty.org/buildbot/builders/win32-debug2/builds/6560/steps/test/logs/stdio

            {noformat}
            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-------------
            {noformat}
            {noformat}
            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-------------
            {noformat}
            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.
            elenst Elena Stepanova made changes -
            Summary main.sp_notembedded and main.trigger_notembedded fail in buildbot on Windows get_lock() crashes on Windows, main.sp_notembedded and main.trigger_notembedded fail in buildbot
            elenst Elena Stepanova made changes -
            Assignee Elena Stepanova [ elenst ] Sergei Golubchik [ serg ]
            elenst Elena Stepanova made changes -
            Component/s OTHER [ 10125 ]
            elenst Elena Stepanova made changes -
            serg Sergei Golubchik made changes -
            Summary get_lock() crashes on Windows, main.sp_notembedded and main.trigger_notembedded fail in buildbot get_lock() crashes on Windows 32bit, main.sp_notembedded and main.trigger_notembedded fail in buildbot
            serg Sergei Golubchik made changes -
            Summary get_lock() crashes on Windows 32bit, main.sp_notembedded and main.trigger_notembedded fail in buildbot get_lock() crashes on Windows, main.sp_notembedded and main.trigger_notembedded fail in buildbot
            serg Sergei Golubchik made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.0.16 [ 17900 ]
            Fix Version/s 10.0 [ 16000 ]
            serg Sergei Golubchik made changes -
            Component/s OTHER [ 10125 ]
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Workflow MariaDB v2 [ 58704 ] MariaDB v3 [ 65102 ]
            svoj Sergey Vojtovich made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 65102 ] MariaDB v4 [ 148533 ]

            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.