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

innodb.innodb_information_schema and main.commit fail with --embedded

    Details

    • Sprint:
      10.2.3-2

      Description

      Tests started failing after a bunch of commits related to MDEV-8931, I don't know which particular change caused it.

      http://buildbot.askmonty.org/buildbot/builders/kvm-fulltest/builds/6508/steps/test_5/logs/stdio

      innodb.innodb_information_schema 'innodb_plugin' w1 [ fail ]
              Test ended at 2016-09-04 18:11:31
       
      CURRENT_TEST: innodb.innodb_information_schema
      --- /mnt/buildbot/build/mariadb-10.2.2/mysql-test/suite/innodb/r/innodb_information_schema.result	2016-09-04 15:32:48.000000000 +0300
      +++ /mnt/buildbot/build/mariadb-10.2.2/mysql-test/suite/innodb/r/innodb_information_schema.reject	2016-09-04 18:11:29.000000000 +0300
      @@ -51,4 +51,4 @@
       trx_isolation_level	trx_unique_checks	trx_foreign_key_checks
       SERIALIZABLE	0	0
       trx_state	trx_isolation_level	trx_last_foreign_key_error
      -RUNNING	REPEATABLE READ	`test`.`t2`, CONSTRAINT `fk1` FOREIGN KEY (`c02`) REFERENCES `t1` (`c01`)
      +RUNNING	SERIALIZABLE	`test`.`t2`, CONSTRAINT `fk1` FOREIGN KEY (`c02`) REFERENCES `t1` (`c01`)
      

      main.commit 'xtradb'                     w3 [ fail ]
              Test ended at 2016-09-04 18:15:34
       
      CURRENT_TEST: main.commit
      innodb_open_files should not be greater than the open_files_limit.
      mysqltest: At line 486: query 'CREATE FUNCTION f1() RETURNS INT
      BEGIN
      DELETE FROM t1;
      RETURN 1;
      END' failed: 1792: Cannot execute statement in a READ ONLY transaction.
       
      The result from queries just before the failure was:
      < snip >
      HANDLER t1 READ FIRST;
      a
      HANDLER t1 CLOSE;
      HANDLER temp_t2 OPEN;
      HANDLER temp_t2 READ FIRST;
      a
      HANDLER temp_t2 CLOSE;
      # 5: Prepared statements
      PREPARE stmt FROM "DELETE FROM t1";
      ERROR 25006: Cannot execute statement in a READ ONLY transaction.
      PREPARE stmt FROM "DELETE FROM temp_t2";
      EXECUTE stmt;
      DEALLOCATE PREPARE stmt;
      COMMIT;
      # 6: Stored routines
      CREATE FUNCTION f1() RETURNS INT
      BEGIN
      DELETE FROM t1;
      RETURN 1;
      END|
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                sanja Oleksandr Byelkin
                Reporter:
                elenst Elena Stepanova
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: