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

              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: