[MDEV-11863] main.mysql_client_test_nonblock fails with non-default build options Created: 2017-01-21  Updated: 2023-11-29  Resolved: 2023-11-29

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.1
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Vicențiu Ciorbaru
Resolution: Won't Fix Votes: 1
Labels: None

Attachments: PNG File ci.debian.net.png    

 Description   

cmake . -DBUILD_CONFIG=mysql_release \
 -DFEATURE_SET="community" \
 -DWITH_XTRADB=1 \
 -DWITH_PARTITION=1 \
 -DWITHOUT_ARCHIVE=1 \
 -DWITHOUT_BLACKHOLE=1 \
 -DWITHOUT_CASSANDRA=1 \
 -DWITHOUT_MROONGA=1 \
 -DWITHOUT_OQGRAPH=1 \
 -DWITHOUT_PERFSCHEMA=1 \
 -DWITHOUT_SPHINX=1 \
 -DWITHOUT_SPIDER=1 \
 -DENABLED_PROFILING=OFF \
 -DENABLE_DTRACE=OFF \
 -DENABLE_DEBUG_SYNC=OFF \
 -DWITHOUT_TOKUDB=ON \
 -DWITH_VALGRIND=OFF \
 -DWITH_SAFEMALLOC=OFF \
 -DWITH_EMBEDDED_SERVER=OFF \
 -DWITH_FEEDBACK=OFF \
 -DWITH_INNODB_DISALLOW_WRITES=OFF \
 -DWITH_LIBWRAP=OFF \
 -DWITH_READLINE=OFF \
 -DWITH_WSREP=OFF \
 -DUSE_NEW_READLINE_INTERFACE=ON \
 -DENABLED_LOCAL_INFILE=ON \
 -DNOT_FOR_DISTRIBUTION=ON \
 -DWITH_ATOMIC_OPS=smp \
 -DWITHOUT_DYNAMIC_PLUGINS=ON \
 -DWITH_PIC=ON \
 -DWITH_JEMALLOC=system \
 -DWITH_SSL=system \
 -DWITH_ZLIB=system

perl ./mtr main.mysql_client_test_nonblock
 
main.mysql_client_test_nonblock          [ fail ]
        Test ended at 2017-01-21 17:08:39
 
CURRENT_TEST: main.mysql_client_test_nonblock
mysqltest: At line 18: exec of '/data/src/10.1-bug/tests/mysql_client_test --defaults-file=/data/src/10.1-bug/mysql-test/var/my.cnf --testcase --vardir=/data/src/10.1-bug/mysql-test/var --non-blocking-api --getopt-ll-test=25600M >> /data/src/10.1-bug/mysql-test/var/log/mysql_client_test.out.log 2>&1' failed, error: 256, status: 1, errno: 2
Output from before failure:
call mtr.add_suppression(" Error reading file './client_test_db/test_frm_bug.frm'");



 Comments   
Comment by Alice Sherepa [ 2017-10-11 ]

on 10.2, p8-rhel7-bintar, http://buildbot.askmonty.org/buildbot/builders/p8-rhel7-bintar/builds/2739/steps/test/logs/stdio

main.mysql_client_test_nonblock          w2 [ fail ]
        Test ended at 2017-10-11 06:21:05
 
CURRENT_TEST: main.mysql_client_test_nonblock
sh: line 1:  5580 Aborted                 /home/buildbot/maria-slave/power8-vlp03-bintar/build/tests/mysql_client_test --defaults-file=/home/buildbot/maria-slave/power8-vlp03-bintar/build/mysql-test/var/2/my.cnf --testcase --vardir=/home/buildbot/maria-slave/power8-vlp03-bintar/build/mysql-test/var/2 --non-blocking-api --getopt-ll-test=25600M >> /home/buildbot/maria-slave/power8-vlp03-bintar/build/mysql-test/var/2/log/mysql_client_test.out.log 2>&1
mysqltest: At line 18: exec of '/home/buildbot/maria-slave/power8-vlp03-bintar/build/tests/mysql_client_test --defaults-file=/home/buildbot/maria-slave/power8-vlp03-bintar/build/mysql-test/var/2/my.cnf --testcase --vardir=/home/buildbot/maria-slave/power8-vlp03-bintar/build/mysql-test/var/2 --non-blocking-api --getopt-ll-test=25600M >> /home/buildbot/maria-slave/power8-vlp03-bintar/build/mysql-test/var/2/log/mysql_client_test.out.log 2>&1' failed, error: 34304, status: 134, errno: 11
Output from before failure:
call mtr.add_suppression(" Error reading file './client_test_db/test_frm_bug.frm'");
 
The result from queries just before the failure was:
SET @old_general_log= @@global.general_log;
SET @old_slow_query_log= @@global.slow_query_log;
call mtr.add_suppression(" Error reading file './client_test_db/test_frm_bug.frm'");

Comment by Otto Kekäläinen [ 2018-08-29 ]

The Debian Continuous Integration is currently (MariaDB 1:10.1.35-1) failing on this same test with the identical error message.

}}
main.mysql_client_test_nonblock          w1 [ fail ]
        Test ended at 2018-08-28 02:37:39
 
CURRENT_TEST: main.mysql_client_test_nonblock
mysqltest: At line 18: exec of '/usr/bin/mysql_client_test --defaults-file=/tmp/tmp.qUj37LebVe/var/1/my.cnf --testcase --vardir=/tmp/tmp.qUj37LebVe/var/1 --non-blocking-api --getopt-ll-test=25600M >> /tmp/tmp.qUj37LebVe/var/1/log/mysql_client_test.out.log 2>&1' failed, error: 256, status: 1, errno: 2
Output from before failure:
call mtr.add_suppression(" Error reading file './client_test_db/test_frm_bug.frm'");
 
The result from queries just before the failure was:
SET @old_general_log= @@global.general_log;
SET @old_slow_query_log= @@global.slow_query_log;
call mtr.add_suppression(" Error reading file './client_test_db/test_frm_bug.frm'");
{{

Is there any suggested fix or work-around at the moment? cvicentiu ?

Comment by Otto Kekäläinen [ 2018-09-05 ]

I also encountered this on Debian Gitlab CI: https://salsa.debian.org/mariadb-team/mariadb-10.1/-/jobs/43186/raw

Probably related to something how the test is run in containers.

Comment by Otto Kekäläinen [ 2018-11-05 ]

Hello!

I would like to remind that this still affects Debian: every single Debian CI build of MariaDB since about a month have been failing due this single failure:

See https://ci.debian.net/data/autopkgtest/testing/amd64/m/mariadb-10.1/1270687/log.gz for latest 1:10.1.37-1 test log.

Ping ratzpo cvicentiu faust

Comment by Elena Stepanova [ 2018-11-05 ]

otto, a side question (not meaning that it doesn't need to be fixed) – I see that the command line points at some /tmp/skip-test.lst, is it not based on mysql-test/unstable-tests list? If it were, the test would have been skipped. I'm asking because if distributions are not using the list that we provide, we'll be happy to stop maintaining it.

Comment by Otto Kekäläinen [ 2018-11-05 ]

That /tmp/skip-test.lst is just a very small skip-list necessary due to restrictions in the Debian CI environment (authored by Christian Ehrhardt ): https://salsa.debian.org/mariadb-team/mariadb-10.1/blob/master/debian/tests/upstream#L23-28

The rules file uses the unstable-tests you provide is still used as part of the actual build + test run: https://salsa.debian.org/mariadb-team/mariadb-10.1/blob/master/debian/rules#L105

Comment by Otto Kekäläinen [ 2018-12-09 ]

OK, I see now that the way Christian implemented the additional skiplist ignores the original skiplist. The correct behaviour would be to skip everything deemed unstable.

Fixed in https://salsa.debian.org/mariadb-team/mariadb-10.1/commit/33d85312840a625c1d607601b77c45f138405cfe and https://salsa.debian.org/mariadb-team/mariadb-10.1/commit/18480afc86838a28cd9ba89e942330c2038011e2

Now Debian-CI passes: https://ci.debian.net/packages/m/mariadb-10.1/

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