[MDEV-11700] funcs_2.innodb_charset fails in buldbot on valgrind builder with timeout Created: 2017-01-01  Updated: 2017-01-09  Resolved: 2017-01-05

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.0, 10.1, 10.2
Fix Version/s: 5.5.55, 10.0.29, 10.1.21, 10.2.4

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Elena Stepanova
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-7069 Fix buildbot failures in main server ... Stalled

 Description   

http://askmonty.org/buildbot/builders/xenial-amd64-valgrind/builds/247

funcs_2.innodb_charset 'xtradb'          w10 [ fail ]  timeout after 9000 seconds
        Test ended at 2017-01-01 13:06:09
 
Test case timeout after 9000 seconds
 
== /dev/shm/var/10/log/innodb_charset.log == 
DFB7	1
DFB8	1
DFB9	1
DFBA	1
DFBB	1
DFBC	1
DFBD	1
DFBE	1
DFBF	1
DROP TABLE IF EXISTS test.t1;
DROP TABLE IF EXISTS test.t1;
DROP DATABASE test;
CREATE DATABASE test CHARACTER SET utf8;
USE test;
CREATE TABLE test.t1 (a CHAR(4) CHARACTER SET utf8 COLLATE utf8_slovak_ci) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_slovak_ci;
SHOW TABLE STATUS LIKE 't1';
Name	Engine	Version	Row_format	Rows	Avg_row_length	Data_length	Max_data_length	Index_length	Data_free	Auto_increment	Create_time	Update_time	Check_time	Collation	Checksum	Create_options	Comment
t1	InnoDB	#	#	#	#	#	#	#	#	#	#	#	#	utf8_slovak_ci	#	#	#
LOAD DATA INFILE 
'MYSQL_TEST_DIR/suite/funcs_2/data/charset_utf8.txt' INTO TABLE test.t1;

The test reaches different places before the timeout, it doesn't look like it gets stuck, it's just really slow with valgrind. Even without parallel execution, it takes ~45 min for each combination (as opposed to ~25 seconds without valgrind). And with high levels of parallel execution it exceeds 9000 seconds timeout as shown above



 Comments   
Comment by Elena Stepanova [ 2017-01-01 ]

https://github.com/MariaDB/server/commit/761ba0e525be754b01c15a542bd78f84d8a4a19e

Comment by Elena Stepanova [ 2017-01-01 ]

bar,

I'm going to disable the test for valgrind runs in buildbot. Would you want to have a similar but much shorter test (for a tiny subset of character sets) which would run with valgrind, or do you think it's other tests are sufficient?

Comment by Elena Stepanova [ 2017-01-05 ]

https://github.com/MariaDB/server/commit/5302ef2c955d98bf3b1fb1f94c036d904c8af922

Comment by Alexander Barkov [ 2017-01-09 ]

It's a good idea to split this test into parts, one test per charset.

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