[MDEV-10996] Tests in perfschema_stress suite either fail or don't clean up Created: 2016-10-09  Updated: 2023-11-29  Resolved: 2023-11-29

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 5.5, 10.0, 10.1, 10.3.12, 10.2
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Elena Stepanova
Resolution: Won't Fix Votes: 1
Labels: beginner-friendly


 Description   

elenst@jessie:/data/bld/10.1/mysql-test$ perl ./mtr --suite=perfschema_stress --force
Logging: ./mtr  --suite=perfschema_stress --force
vardir: /data/bld/10.1/mysql-test/var
Checking leftover processes...
Removing old var directory...
Creating var directory '/data/bld/10.1/mysql-test/var'...
Checking supported features...
MariaDB Version 10.1.19-MariaDB-debug
 - SSL connections supported
 - binaries are debug compiled
Using suites: perfschema_stress
Collecting tests...
Installing system database...
 
==============================================================================
 
TEST                                      RESULT   TIME (ms) or COMMENT
--------------------------------------------------------------------------
 
worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019
perfschema_stress.modify                 [ pass ]   1236
 
MTR's internal check of the test case 'perfschema_stress.modify' failed.
This means that the test case does not preserve the state that existed
before the test case was executed.  Most likely the test case did not
do a proper clean-up. It could also be caused by the previous test run
by this thread, if the server wasn't restarted.
This is the diff of the states of the servers before and after the
test case was executed:
mysqltest: Logging to '/data/bld/10.1/mysql-test/var/tmp/check-mysqld_1.log'.
mysqltest: Results saved in '/data/bld/10.1/mysql-test/var/tmp/check-mysqld_1.result'.
mysqltest: Connecting to server localhost:16000 (socket /data/bld/10.1/mysql-test/var/tmp/mysqld.1.sock) as 'root', connection 'default', attempt 0 ...
mysqltest: ... Connected.
mysqltest: Start processing test commands from './include/check-testcase.test' ...
mysqltest: ... Done processing test commands.
--- /data/bld/10.1/mysql-test/var/tmp/check-mysqld_1.result	2016-10-09 23:04:37.240502389 +0300
+++ /data/bld/10.1/mysql-test/var/tmp/check-mysqld_1.reject	2016-10-09 23:04:38.736502382 +0300
@@ -470,6 +470,7 @@
 def	performance_schema	utf8	utf8_general_ci	NULL
 def	test	latin1	latin1_swedish_ci	NULL
 tables_in_test
+t1
 tables_in_mysql
 mysql.columns_priv
 mysql.column_stats
 
mysqltest: Result length mismatch
 
not ok
 
perfschema_stress.read                   [ fail ]
        Test ended at 2016-10-09 23:04:39
 
CURRENT_TEST: perfschema_stress.read
mysqltest: At line 12: query 'SELECT * FROM performance_schema.processlist p,
performance_schema.events_waits_current e
WHERE p.THREAD_ID = e.THREAD_ID
AND TIMER_START = 0
ORDER BY e.EVENT_ID' failed: 1146: Table 'performance_schema.processlist' doesn't exist
 
The result from queries just before the failure was:
SELECT * FROM performance_schema.setup_instruments
WHERE ENABLED='NO' AND TIMED='NO';
NAME	ENABLED	TIMED
SELECT * FROM performance_schema.events_waits_current
WHERE (TIMER_END - TIMER_START != TIMER_WAIT);
THREAD_ID	EVENT_ID	END_EVENT_ID	EVENT_NAME	SOURCE	TIMER_START	TIMER_END	TIMER_WAIT	SPINS	OBJECT_SCHEMA	OBJECT_NAME	INDEX_NAME	OBJECT_TYPE	OBJECT_INSTANCE_BEGIN	NESTING_EVENT_ID	NESTING_EVENT_TYPE	OPERATION	NUMBER_OF_BYTES	FLAGS
SELECT * FROM performance_schema.events_waits_history
WHERE SPINS != NULL;
THREAD_ID	EVENT_ID	END_EVENT_ID	EVENT_NAME	SOURCE	TIMER_START	TIMER_END	TIMER_WAIT	SPINS	OBJECT_SCHEMA	OBJECT_NAME	INDEX_NAME	OBJECT_TYPE	OBJECT_INSTANCE_BEGIN	NESTING_EVENT_ID	NESTING_EVENT_TYPE	OPERATION	NUMBER_OF_BYTES	FLAGS
SELECT * FROM performance_schema.processlist p,
performance_schema.events_waits_current e
WHERE p.THREAD_ID = e.THREAD_ID
AND TIMER_START = 0
ORDER BY e.EVENT_ID;
 
 - saving '/data/bld/10.1/mysql-test/var/log/perfschema_stress.read/' to '/data/bld/10.1/mysql-test/var/log/perfschema_stress.read/'
perfschema_stress.setup                  [ fail ]
        Test ended at 2016-10-09 23:04:40
 
CURRENT_TEST: perfschema_stress.setup
mysqltest: The test didn't produce any output
 
 - saving '/data/bld/10.1/mysql-test/var/log/perfschema_stress.setup/' to '/data/bld/10.1/mysql-test/var/log/perfschema_stress.setup/'
perfschema_stress.work                   [ pass ]    130
 
MTR's internal check of the test case 'perfschema_stress.work' failed.
This means that the test case does not preserve the state that existed
before the test case was executed.  Most likely the test case did not
do a proper clean-up. It could also be caused by the previous test run
by this thread, if the server wasn't restarted.
This is the diff of the states of the servers before and after the
test case was executed:
mysqltest: Logging to '/data/bld/10.1/mysql-test/var/tmp/check-mysqld_1.log'.
mysqltest: Results saved in '/data/bld/10.1/mysql-test/var/tmp/check-mysqld_1.result'.
mysqltest: Connecting to server localhost:16000 (socket /data/bld/10.1/mysql-test/var/tmp/mysqld.1.sock) as 'root', connection 'default', attempt 0 ...
mysqltest: ... Connected.
mysqltest: Start processing test commands from './include/check-testcase.test' ...
mysqltest: ... Done processing test commands.
--- /data/bld/10.1/mysql-test/var/tmp/check-mysqld_1.result	2016-10-09 23:04:40.508502374 +0300
+++ /data/bld/10.1/mysql-test/var/tmp/check-mysqld_1.reject	2016-10-09 23:04:40.808502372 +0300
@@ -470,6 +470,7 @@
 def	performance_schema	utf8	utf8_general_ci	NULL
 def	test	latin1	latin1_swedish_ci	NULL
 tables_in_test
+t1
 tables_in_mysql
 mysql.columns_priv
 mysql.column_stats
 
mysqltest: Result length mismatch
 
not ok
 
--------------------------------------------------------------------------
The servers were restarted 3 times
Spent 1.366 of 11 seconds executing testcases
 
Check of testcase failed for: perfschema_stress.work perfschema_stress.modify
 
Completed: Failed 2/4 tests, 50.00% were successful.
 
Failing test(s): perfschema_stress.read perfschema_stress.setup
 
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
 
mysql-test-run: *** ERROR: there were failing test cases



 Comments   
Comment by Valerii Kravchuk [ 2018-12-05 ]

Fails in current 10.3.12 from GitHub also:

[openxs@fc23 mysql-test]$ ./mtr perfschema_stress.read --force
Logging: ./mtr  perfschema_stress.read --force
vardir: /home/openxs/git/server/mysql-test/var
Checking leftover processes...
Removing old var directory...
Creating var directory '/home/openxs/git/server/mysql-test/var'...
Checking supported features...
MariaDB Version 10.3.12-MariaDB
 - SSL connections supported
Collecting tests...
Installing system database...
 
==============================================================================
 
TEST                                      RESULT   TIME (ms) or COMMENT
--------------------------------------------------------------------------
 
worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019
perfschema_stress.read                   [ fail ]
        Test ended at 2018-12-05 10:46:08
 
CURRENT_TEST: perfschema_stress.read
mysqltest: At line 13: query 'SELECT * FROM performance_schema.processlist p,
performance_schema.events_waits_current e
WHERE p.THREAD_ID = e.THREAD_ID
AND TIMER_START = 0
ORDER BY e.EVENT_ID' failed: 1146: Table 'performance_schema.processlist' doesn't exist
 
The result from queries just before the failure was:
SELECT * FROM performance_schema.setup_instruments
WHERE ENABLED='NO' AND TIMED='NO';
NAME    ENABLED TIMED
SELECT * FROM performance_schema.events_waits_current
WHERE (TIMER_END - TIMER_START != TIMER_WAIT);
THREAD_ID       EVENT_ID        END_EVENT_ID    EVENT_NAME      SOURCE  TIMER_START     TIMER_END       TIMER_WAIT      SPINS   OBJECT_SCHEMA   OBJECT_NAME    INDEX_NAME       OBJECT_TYPE     OBJECT_INSTANCE_BEGIN   NESTING_EVENT_ID       NESTING_EVENT_TYPE       OPERATION       NUMBER_OF_BYTES FLAGS
SELECT * FROM performance_schema.events_waits_history
WHERE SPINS != NULL;
THREAD_ID       EVENT_ID        END_EVENT_ID    EVENT_NAME      SOURCE  TIMER_START     TIMER_END       TIMER_WAIT      SPINS   OBJECT_SCHEMA   OBJECT_NAME    INDEX_NAME       OBJECT_TYPE     OBJECT_INSTANCE_BEGIN   NESTING_EVENT_ID       NESTING_EVENT_TYPE       OPERATION       NUMBER_OF_BYTES FLAGS
SELECT * FROM performance_schema.processlist p,
performance_schema.events_waits_current e
WHERE p.THREAD_ID = e.THREAD_ID
AND TIMER_START = 0
ORDER BY e.EVENT_ID;
 
 - saving '/home/openxs/git/server/mysql-test/var/log/perfschema_stress.read/' to '/home/openxs/git/server/mysql-test/var/log/perfschema_stress.read/'
--------------------------------------------------------------------------
The servers were restarted 0 times
Spent 0.000 of 5 seconds executing testcases
 
Completed: Failed 1/1 tests, 0.00% were successful.
 
Failing test(s): perfschema_stress.read
 
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
 
mysql-test-run: *** ERROR: there were failing test cases

Generated at Thu Feb 08 07:46:30 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.