[MDEV-23954] main.column_compression 'innodb' fails on s390x: data length 36 not 40 Created: 2020-10-13  Updated: 2023-10-06

Status: Open
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.5.5
Fix Version/s: 10.5

Type: Bug Priority: Major
Reporter: Otto Kekäläinen Assignee: Michael Widenius
Resolution: Unresolved Votes: 0
Labels: None


 Description   

Came across on Travis-CI this failure:

main.column_compression 'innodb'         w1 [ fail ]
 
        Test ended at 2020-10-13 16:12:52
 
CURRENT_TEST: main.column_compression
 
--- /home/travis/build/ottok/mariadb/mysql-test/main/column_compression.result	2020-10-13 15:56:31.196230080 +0000
 
+++ /home/travis/build/ottok/mariadb/mysql-test/main/column_compression.reject	2020-10-13 16:12:52.186491421 +0000
 
@@ -565,7 +565,7 @@
 
 COLUMN_DECOMPRESSIONS	12
 
 SELECT DATA_LENGTH FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='test' AND TABLE_NAME='t1';
 
 DATA_LENGTH
 
-40
 
+36
 
 TRUNCATE TABLE t1;
 
 SET column_compression_zlib_level= 9;
 
 INSERT INTO t1 VALUES(REPEAT('ab', 1000));
 
@@ -780,7 +780,7 @@
 
 COLUMN_DECOMPRESSIONS	12
 
 SELECT DATA_LENGTH FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='test' AND TABLE_NAME='t1';
 
 DATA_LENGTH
 
-40
 
+36
 
 TRUNCATE TABLE t1;
 
 SET column_compression_zlib_level= 9;
 
 INSERT INTO t1 VALUES(REPEAT('ab', 1000));
 
mysqltest: Result content mismatch

Full log: https://travis-ci.org/github/ottok/mariadb/jobs/735397898

Filing as 'major' since this is on the main test suite and on Travis-CI, so it must either be disabled or fixed for CI to have further progress.

Env:

os: Linux / Ubuntu 20.04
arch: s390x
Compiler: gcc C++
CC_VERSION=8 TYPE=RelWithDebInfo MYSQL_TEST_SUITES=main

 Comments   
Comment by Marko Mäkelä [ 2020-10-14 ]

I would suggest to create a stand-alone test of this, so that zlib can be tested directly.

Comment by Otto Kekäläinen [ 2020-10-19 ]

This failure is visible on every build of 10.5 on Travis-CI. Maybe it should be assigned to somebody since it is so visible?

See

E.g. https://travis-ci.org/github/MariaDB/server/jobs/736259317

Comment by Elena Stepanova [ 2021-01-02 ]

otto, danblack,

The comment in your commit seems to say that it's fixed, should the issue be closed then?

Comment by Ehsan Kiani Far [ 2023-07-25 ]

On the buildbot CI ( https://buildbot.mariadb.org/#/grid?branch=11.1 ) this test is still failing . However, when I build locally, this test and other "compression" tests are passing. I tested on Ubuntu 20.04, RHEL 9.2, and SLES 15sp5 (s390x arch). I followed instructions here: https://mariadb.com/kb/en/Build_Environment_Setup_for_Linux/ to setup my environment. I am wondering if this is because I have a different version of dependencies (zlib) or something else is going on. Is there a way to check the buildbot environment details?

Comment by Daniel Black [ 2023-09-08 ]

Monty - see this is fixed in your latest bb-10.5-monty branch.

Generated at Thu Feb 08 09:26:18 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.