Description:
[ 51%] main.information_schema_cs w15 [ fail ]
Test ended at 2018-10-02 22:03:13
CURRENT_TEST: main.information_schema_cs
--- /export/home/pb2/test/sb_2-30831804-1538508532.53/usr/share/mysql-test/r/information_schema_cs.result 2018-10-02 22:30:09.894631199 +0300
+++ /dev/shm/mtr-8840/var-all-default/15/log/information_schema_cs.reject 2018-10-02 23:03:13.198155442 +0300
@@ -225,13 +225,13 @@
select * from information_schema.CHARACTER_SETS
where CHARACTER_SET_NAME like 'latin1%' order by character_set_name;
CHARACTER_SET_NAME DEFAULT_COLLATE_NAME DESCRIPTION MAXLEN
-latin1 latin1_swedish_ci cp1252 West European 1
+latin1 latin1_swedish_ci 1
SHOW CHARACTER SET LIKE 'latin1%';
Charset Description Default collation Maxlen
-latin1 cp1252 West European latin1_swedish_ci 1
+latin1 latin1_swedish_ci 1
SHOW CHARACTER SET WHERE charset like 'latin1%';
Charset Description Default collation Maxlen
-latin1 cp1252 West European latin1_swedish_ci 1
+latin1 latin1_swedish_ci 1
select * from information_schema.COLLATIONS
where COLLATION_NAME like 'latin1%' order by collation_name;
COLLATION_NAME CHARACTER_SET_NAME ID IS_DEFAULT IS_COMPILED SORTLEN PAD_ATTRIBUTE
How to repeat:
./mtr --mem main.ctype_uca main.information_schema_cs --parallel=2 --repeat=10
Suggested fix:
The problem is caused by main.ctype_uca which removes and restores share/charsets/Index.xml in the source directory.
If main.information_schema_cs is run in parallel, it can fail, since it needs the information from Index.xml.
In any case, having a test fiddle with the source directory is bad practice. Rewrite the test so that it starts mysqld with an explicit charset directory instead.
Description: [ 51%] main.information_schema_cs w15 [ fail ] Test ended at 2018-10-02 22:03:13 CURRENT_TEST: main.information_schema_cs --- /export/home/pb2/test/sb_2-30831804-1538508532.53/usr/share/mysql-test/r/information_schema_cs.result 2018-10-02 22:30:09.894631199 +0300 +++ /dev/shm/mtr-8840/var-all-default/15/log/information_schema_cs.reject 2018-10-02 23:03:13.198155442 +0300 @@ -225,13 +225,13 @@ select * from information_schema.CHARACTER_SETS where CHARACTER_SET_NAME like 'latin1%' order by character_set_name; CHARACTER_SET_NAME DEFAULT_COLLATE_NAME DESCRIPTION MAXLEN -latin1 latin1_swedish_ci cp1252 West European 1 +latin1 latin1_swedish_ci 1 SHOW CHARACTER SET LIKE 'latin1%'; Charset Description Default collation Maxlen -latin1 cp1252 West European latin1_swedish_ci 1 +latin1 latin1_swedish_ci 1 SHOW CHARACTER SET WHERE charset like 'latin1%'; Charset Description Default collation Maxlen -latin1 cp1252 West European latin1_swedish_ci 1 +latin1 latin1_swedish_ci 1 select * from information_schema.COLLATIONS where COLLATION_NAME like 'latin1%' order by collation_name; COLLATION_NAME CHARACTER_SET_NAME ID IS_DEFAULT IS_COMPILED SORTLEN PAD_ATTRIBUTE How to repeat: ./mtr --mem main.ctype_uca main.information_schema_cs --parallel=2 --repeat=10 Suggested fix: The problem is caused by main.ctype_uca which removes and restores share/charsets/Index.xml in the source directory. If main.information_schema_cs is run in parallel, it can fail, since it needs the information from Index.xml. In any case, having a test fiddle with the source directory is bad practice. Rewrite the test so that it starts mysqld with an explicit charset directory instead.