Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Cannot Reproduce
-
10.2(EOL)
-
None
-
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
- blocks
-
MDEV-7069 Fix buildbot failures in main server trees
- Stalled