Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
10.4.13
-
Wind River Linux LTS 18.44
Description
innodb.innodb_sys_semaphore_waits test fails when running on my intended appliance operating platform. I ran ./mtr innodb.innodb_sys_semaphore_waits in a clean test tree.
var/log/innodb_sys_semaphore_waits.log contains:
connect con1,localhost,root,,;
|
connect con2,localhost,root,,;
|
drop table if exists t1;
|
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
|
A full test run, with --big-test --force --testcase-timeout=30 --suite-timeout=1000 --shutdown-timeout=20 eventually yielded:
Completed: Failed 9/4997 tests, 99.82% were successful.
|
|
Failing test(s): binlog_encryption.binlog_xa_recover binlog.binlog_xa_recover innodb.innodb_sys_semaphore_waits sys_vars.innodb_fatal_semaphore_wait_threshold main.failed_auth_unixsocket main.ssl_cipher unit.conc_charset unit.pcre_grep_test unit.pcre_test
|
|
The log files in var/log may give you some hint of what went wrong.
|
|
If you want to report this error, please read first the documentation
|
at http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html
|
|
Errors/warnings were found in logfiles during server shutdown after running the
|
following sequence(s) of tests:
|
innodb.innodb_sys_semaphore_waits
|
sys_vars.innodb_fatal_semaphore_wait_threshold
|
367 tests were skipped, 288 by the test itself.
|
Please let me know if any of these are likely non-issues, or if there are other logs I can supply from this test run. I am especially concerned that there are semaphore tests that failed, as well as other "important-seeming" tests like main.ssl_cipher and a couple unit. tests.