Public bug reported:

Example logs:
 - 
https://autopkgtest.ubuntu.com/results/autopkgtest-oracular/oracular/s390x/m/mysql-8.0/20240814_155651_ec73a@/log.gz
 - 
https://autopkgtest.ubuntu.com/results/autopkgtest-oracular/oracular/s390x/m/mysql-8.0/20240820_150759_2d701@/log.gz

(I've only spot checked these two logs; there are a lot of failures and
I'm assuming they're all the same thing but didn't check.)

1666s [ 33%] main.archive                             w2  [ fail ]
1666s         Test ended at 2024-08-14 15:33:59
1666s 
1666s CURRENT_TEST: main.archive
1666s --- /usr/lib/mysql-test/r/archive.result  2024-07-12 22:15:25.000000000 
+0300
1666s +++ /tmp/tmp.CeBnbj4483/var/2/log/archive.reject  2024-08-14 
18:33:59.640275927 +0300
1666s @@ -12732,7 +12732,7 @@
1666s  SELECT DATA_LENGTH, AVG_ROW_LENGTH FROM
1666s  INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME='t1' AND TABLE_SCHEMA='test';
1666s  DATA_LENGTH      AVG_ROW_LENGTH
1666s -122      61
1666s +121      60
1666s  DROP TABLE t1;
1666s  SET @save_join_buffer_size= @@join_buffer_size;
1666s  SET @@join_buffer_size= 8192;
1666s 
1666s mysqltest: Result content mismatch
1666s 
1666s 
1666s The result from queries just before the failure was:
1666s 3 3
1666s SELECT * FROM innodb_table ORDER BY id;
1666s id        x
1666s 1 3
1666s 3 5
1666s 5 6
1666s # Delete is allowed if the archive table is only read from.
1666s DELETE t2 FROM archive_table AS t1, innodb_table AS t2 WHERE t1.id = 
t2.id;
1666s SELECT * FROM archive_table ORDER BY id;
1666s id        x
1666s 1 1
1666s 2 2
1666s 3 3
1666s SELECT * FROM innodb_table ORDER BY id;
1666s id        x
1666s 5 6
1666s DROP VIEW v;
1666s DROP TABLE archive_table, innodb_table;
1666s Warnings:
1666s Warning   1287    '@@binlog_format' is deprecated and will be removed in 
a future release.
1666s safe_process[15231]: Child process: 15232, exit: 1
1666s 
1666s  - the logfile can be found in 
'/tmp/tmp.CeBnbj4483/var/log/main.archive/archive.log'
1666s 
1666s Retrying test main.archive, attempt(2/3).
1666s 
1668s [ 33%] main.myisam                              w1  [ pass ]   1826
1671s [ 33%] main.archive                             w2  [ retry-fail ]
1671s         Test ended at 2024-08-14 15:34:04
1671s 
1671s CURRENT_TEST: main.archive
1671s --- /usr/lib/mysql-test/r/archive.result  2024-07-12 22:15:25.000000000 
+0300
1671s +++ /tmp/tmp.CeBnbj4483/var/2/log/archive.reject  2024-08-14 
18:34:04.350305816 +0300
1671s @@ -12732,7 +12732,7 @@
1671s  SELECT DATA_LENGTH, AVG_ROW_LENGTH FROM
1671s  INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME='t1' AND TABLE_SCHEMA='test';
1671s  DATA_LENGTH      AVG_ROW_LENGTH
1671s -122      61
1671s +121      60
1671s  DROP TABLE t1;
1671s  SET @save_join_buffer_size= @@join_buffer_size;
1671s  SET @@join_buffer_size= 8192;
1671s 
1671s mysqltest: Result content mismatch
1671s 
1671s 
1671s The result from queries just before the failure was:
1671s 3 3
1671s SELECT * FROM innodb_table ORDER BY id;
1671s id        x
1671s 1 3
1671s 3 5
1671s 5 6
1671s # Delete is allowed if the archive table is only read from.
1671s DELETE t2 FROM archive_table AS t1, innodb_table AS t2 WHERE t1.id = 
t2.id;
1671s SELECT * FROM archive_table ORDER BY id;
1671s id        x
1671s 1 1
1671s 2 2
1671s 3 3
1671s SELECT * FROM innodb_table ORDER BY id;
1671s id        x
1671s 5 6
1671s DROP VIEW v;
1671s DROP TABLE archive_table, innodb_table;
1671s Warnings:
1671s Warning   1287    '@@binlog_format' is deprecated and will be removed in 
a future release.
1671s safe_process[15597]: Child process: 15598, exit: 1
1671s 
1671s  - the logfile can be found in 
'/tmp/tmp.CeBnbj4483/var/log/main.archive/archive.log'
1671s 
1671s Test main.archive has failed 2 times, no more retries.
1671s 


-----------------------------------


3755s [ 50%] main.func_compress                       w1  [ fail ]
3755s         Test ended at 2024-08-20 14:53:40
3755s 
3755s CURRENT_TEST: main.func_compress
3755s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a 
future version.
3755s --- /usr/lib/mysql-test/r/func_compress.result    2024-07-12 
22:15:25.000000000 +0300
3755s +++ /tmp/tmp.XPF6G0PbyJ/var/1/log/func_compress.reject    2024-08-20 
17:53:40.281009461 +0300
3755s @@ -58,7 +58,7 @@
3755s  length(a)
3755s  NULL
3755s  12
3755s -76
3755s +455
3755s  50000
3755s  select length(uncompress(a)) from t1;
3755s  length(uncompress(a))
3755s 
3755s mysqltest: Result content mismatch
3755s 
3755s 
3755s The result from queries just before the failure was:
3755s Warning   1259    ZLIB: Input data corrupted
3755s drop table t1;
3755s CREATE TABLE t1 (c1 INT);
3755s INSERT INTO t1 VALUES (1), (1111), (11111);
3755s SELECT UNCOMPRESS(c1), UNCOMPRESSED_LENGTH(c1) FROM t1;
3755s UNCOMPRESS(c1)    UNCOMPRESSED_LENGTH(c1)
3755s NULL      0
3755s NULL      0
3755s NULL      825307441
3755s EXPLAIN SELECT * FROM (SELECT UNCOMPRESSED_LENGTH(c1) FROM t1) AS s;
3755s DROP TABLE t1;
3755s End of 5.0 tests
3755s #
3755s # Bug#18693654 VALGRIND WARNINGS IN INFLATE ON UNCOMPRESS
3755s #
3755s SELECT UNCOMPRESS( CAST( 0 AS BINARY(5) ) );
3755s UNCOMPRESS( CAST( 0 AS BINARY(5) ) )
3755s NULL
3755s Warnings:
3755s Warning   1259    ZLIB: Input data corrupted
3755s safe_process[26823]: Child process: 26824, exit: 1
3755s 
3755s  - the logfile can be found in 
'/tmp/tmp.XPF6G0PbyJ/var/log/main.func_compress/func_compress.log'
3755s 
3755s Retrying test main.func_compress, attempt(2/3).
3755s 
3756s [ 50%] main.func_compress                       w1  [ retry-fail ]
3756s         Test ended at 2024-08-20 14:53:41
3756s 
3756s CURRENT_TEST: main.func_compress
3756s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a 
future version.
3756s --- /usr/lib/mysql-test/r/func_compress.result    2024-07-12 
22:15:25.000000000 +0300
3756s +++ /tmp/tmp.XPF6G0PbyJ/var/1/log/func_compress.reject    2024-08-20 
17:53:41.451019446 +0300
3756s @@ -58,7 +58,7 @@
3756s  length(a)
3756s  NULL
3756s  12
3756s -76
3756s +455
3756s  50000
3756s  select length(uncompress(a)) from t1;
3756s  length(uncompress(a))
3756s 
3756s mysqltest: Result content mismatch
3756s 
3756s 
3756s The result from queries just before the failure was:
3756s Warning   1259    ZLIB: Input data corrupted
3756s drop table t1;
3756s CREATE TABLE t1 (c1 INT);
3756s INSERT INTO t1 VALUES (1), (1111), (11111);
3756s SELECT UNCOMPRESS(c1), UNCOMPRESSED_LENGTH(c1) FROM t1;
3756s UNCOMPRESS(c1)    UNCOMPRESSED_LENGTH(c1)
3756s NULL      0
3756s NULL      0
3756s NULL      825307441
3756s EXPLAIN SELECT * FROM (SELECT UNCOMPRESSED_LENGTH(c1) FROM t1) AS s;
3756s DROP TABLE t1;
3756s End of 5.0 tests
3756s #
3756s # Bug#18693654 VALGRIND WARNINGS IN INFLATE ON UNCOMPRESS
3756s #
3756s SELECT UNCOMPRESS( CAST( 0 AS BINARY(5) ) );
3756s UNCOMPRESS( CAST( 0 AS BINARY(5) ) )
3756s NULL
3756s Warnings:
3756s Warning   1259    ZLIB: Input data corrupted
3756s safe_process[26876]: Child process: 26877, exit: 1
3756s 
3756s  - the logfile can be found in 
'/tmp/tmp.XPF6G0PbyJ/var/log/main.func_compress/func_compress.log'
3756s 
3756s Test main.func_compress has failed 2 times, no more retries.
3756s 
3757s [ 50%] main.func_concat                         w1  [ pass ]     78

** Affects: mysql-8.0 (Ubuntu)
     Importance: High
         Status: New


** Tags: update-excuse

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/2077483

Title:
  DEP8 failure on s390x due to subtest 'main.archive' and
  'main.func_compress'

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mysql-8.0/+bug/2077483/+subscriptions


-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

Reply via email to