innodb.innodb_sys_semaphore_waits 'innodb' w4 [ fail ]

        Test ended at 2022-08-24 12:29:31

CURRENT_TEST: innodb.innodb_sys_semaphore_waits

mysqltest: At line 94: query 'show status' failed with wrong errno 5014: 'Write error: Broken pipe (32)', instead of 0...

The result from queries just before the failure was:

< snip >

connection con1;

create table t1 (id integer, x integer) engine = InnoDB;

insert into t1 values(0, 0);

SET @saved_dbug = @@SESSION.debug_dbug;

set DEBUG_DBUG='+d,fatal-semaphore-timeout';

set autocommit=0;

# Sending query on con1,

# the session will hold lock table mutex and sleep

SELECT * from t1 where id = 0 FOR UPDATE;

connection con2;

set autocommit=0;

# Sending query on con2,

# the session will be blocked on the lock table mutex and

# thus be put into sync arry

SELECT * from t1 where id = 0 FOR UPDATE;

connection default;

# Waitting for mysqld to crash

-  --error 0,ER_SERVER_SHUTDOWN,ER_CONNECTION_KILLED,2002,2006,2013

+  --error 0,ER_SERVER_SHUTDOWN,ER_CONNECTION_KILLED,2002,2006,2013,5014