main.lock_sync                           w8 [ fail ]  timeout after 900 seconds

        Test ended at 2025-04-22 06:31:34

Test case timeout after 900 seconds

== /home/buildbot/s390x-ubuntu-2004-debug/build/mysql-test/var/8/log/lock_sync.log == 

disconnect con1;

disconnect con2;

DROP TABLES t1, t2;

#

# MDEV-28567 Assertion `0' in open_tables upon function-related operation

#

CREATE TABLE t1 (a INT);

CREATE TABLE t2 (b INT);

CREATE TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW UPDATE t2 SET b = 0;

CREATE TRIGGER tr2 BEFORE INSERT ON t2 FOR EACH ROW UPDATE t1 SET a = 6;

CREATE VIEW v1 AS SELECT * FROM t1;

SET AUTOCOMMIT=OFF;

SELECT * FROM t1;

a

DROP TRIGGER tr1;

INSERT INTO t2 SELECT * FROM t2;

SELECT f() FROM t2;

ERROR 42000: FUNCTION test.f does not exist

set debug_sync= 'after_open_table_mdl_shared signal s1';

ALTER VIEW v1 AS SELECT f() FROM t1;

 == /home/buildbot/s390x-ubuntu-2004-debug/build/mysql-test/var/8/tmp/analyze-timeout-mysqld.1.err ==

mysqltest: Could not open connection 'default' after 500 attempts: 2002 Can't connect to local server through socket '/home/buildbot/s390x-ubuntu-2004-debug/build/mysql-test/var/tmp/' (111)