[core-updates] MariaDB fails tests on armhf-linux

DoneSubmitted by Marius Bakke.
Details
2 participants
  • Ludovic Courtès
  • Marius Bakke
Owner
unassigned
Severity
normal
M
M
Marius Bakke wrote on 3 Oct 2019 17:44
(address . bug-guix@gnu.org)
8736g996l2.fsf@devup.no
"mariadb" consistently fails a single test on the core-updates branch on
armhf-linux:


The test output:

CURRENT_TEST: binlog_encryption.rpl_skip_replication
safe_process[21120]: parent_pid: 16023
safe_process[21120]: Started child 21121, terminated: 0
--- /tmp/guix-build-mariadb-10.1.41.drv-0/mariadb-10.1.41/mysql-test/suite/binlog_encryption/rpl_skip_replication.result 1970-01-01 00:00:00.000000000 +0000
+++ /tmp/guix-build-mariadb-10.1.41.drv-0/mariadb-10.1.41/mysql-test/suite/binlog_encryption/rpl_skip_replication.reject 2019-09-05 23:24:20.300000000 +0000
@@ -46,12 +46,15 @@
Tables_in_test
t1
t2
+t3
SELECT * FROM t1;
a b
1 NULL
+2 NULL
SELECT * FROM t2;
a b
1 NULL
+2 NULL
DROP TABLE t3;
FLUSH NO_WRITE_TO_BINLOG LOGS;
STOP SLAVE;
@@ -66,12 +69,17 @@
Tables_in_test
t1
t2
+t3
SELECT * FROM t1;
a b
1 NULL
+2 NULL
+3 NULL
SELECT * FROM t2;
a b
1 NULL
+2 NULL
+3 NULL
DROP TABLE t3;
FLUSH NO_WRITE_TO_BINLOG LOGS;
STOP SLAVE;
@@ -109,6 +117,7 @@
SELECT * FROM t1 ORDER by a;
a b
1 0
+2 0
3 0
TRUNCATE t1;
STOP SLAVE;
@@ -127,6 +136,7 @@
SET binlog_format= @old_binlog_format;
SELECT * FROM t1;
a b
+3 5
4 5
include/stop_slave.inc
SET @old_slave_binlog_format= @@global.binlog_format;
@@ -151,6 +161,7 @@
2 8
SELECT * FROM t1 ORDER by a;
a b
+1 8
2 8
include/stop_slave.inc
SET GLOBAL binlog_format= @old_slave_binlog_format;
@@ -225,6 +236,7 @@
START SLAVE;
SELECT * FROM t1;
a b
+1 NULL
2 NULL
SET skip_replication= 0;
TRUNCATE t1;

mysqltest: Result length mismatch

safe_process[21120]: Got signal 17, child_pid: 21121
safe_process[21120]: Killing child: 21121
safe_process[21120]: Child exit: 1

binlog_encryption.rpl_skip_replication 'mix,xtradb' w2 [ fail ]
Test ended at 2019-09-05 23:24:22

This does not happen on current 'master', so the problem was introduced
somewhere in between ccbc1c5eb..cbc8c658d.
-----BEGIN PGP SIGNATURE-----

iQEzBAEBCgAdFiEEu7At3yzq9qgNHeZDoqBt8qM6VPoFAl2WF2kACgkQoqBt8qM6
VPr1Ugf+PO/dP2d6fbBczjKGCLx+iigXt9cIs/ipja9cTWDjfjSlbprd62LiRioc
qaiUjiD8iEsnaW2PUFppheXKqW4fJCkqw+i7yBE5nTMzklrVst+IJGu+vgl4kno/
ThOXSpjhJrQIEQvHsevT3YUK0YXo1jbfGLRHeS+27THfnR6nGyjjk1Oi8R9WsIQ4
kDeVwVZawj8lYsXPDqLJ1Y+WdX7gYn2+mHMZfsDzxCmWUSaG7D0uiYxXP5OAE0ci
bKOyXqQCPWccLBMBgGVLPmTgy39JxmbTZf3l7D4uSH9CPwHb/bbyzwr4VwCF7aF9
Pz8MLjW3yQstEr6HW73cN11rSGQAGQ==
=BLZF
-----END PGP SIGNATURE-----

M
M
Marius Bakke wrote on 5 Oct 2019 14:53
(address . 37605@debbugs.gnu.org)
87r23r73q5.fsf@devup.no
Marius Bakke <mbakke@fastmail.com> writes:

Toggle quote (10 lines)
> "mariadb" consistently fails a single test on the core-updates branch on
> armhf-linux:
>
> https://ci.guix.gnu.org/build/1689172/details
>
> [...]
>
> This does not happen on current 'master', so the problem was introduced
> somewhere in between ccbc1c5eb..cbc8c658d.

Upstream bug report here:


I'm not sure what to do about it. We could skip it, but then users who
rely on encrypted binary logs could potentially get in trouble. I
haven't found a compile-time flag to disable just this one feature.

Thoughts?
-----BEGIN PGP SIGNATURE-----

iQEzBAEBCgAdFiEEu7At3yzq9qgNHeZDoqBt8qM6VPoFAl2YkmIACgkQoqBt8qM6
VPqNgQf/cgGyaiT/e2RafdW+x2X+itncz1f1+duKW1DDQleKoRFSvAakJvQh8Lda
l3WqoJqpDONxaQdDQhnm7mSH4Z96mOD771NQNZhzmbB9JMS05ojrJfH5UqNNNJci
f0aBWokIDREA+0shjklhN7ga653OhzwYxji1S5odpqmn7GTA5rj+lcp7e2HNFMW6
96wj6OdJdwDlf+cImhs7rbX6CkORV/uSCNI1lHADxcGN0X5UUMPAa9i2JOQ3efYH
Veq86VZsKgml4iEIm5Rn4GTyyxk8kiFEl+jeYUNfTlarI1+QOLiYPfq/AwCHDxfl
9nBijywgIz5QxrOzmJ7iBgkvqPTWEA==
=l9vW
-----END PGP SIGNATURE-----

L
L
Ludovic Courtès wrote on 8 Oct 2019 10:41
Re: bug#37605: [core-updates] MariaDB fails tests on armhf-linux
(name . Marius Bakke)(address . mbakke@fastmail.com)(address . 37605@debbugs.gnu.org)
87r23niq89.fsf@gnu.org
Hi,

Marius Bakke <mbakke@fastmail.com> skribis:

Toggle quote (20 lines)
> Marius Bakke <mbakke@fastmail.com> writes:
>
>> "mariadb" consistently fails a single test on the core-updates branch on
>> armhf-linux:
>>
>> https://ci.guix.gnu.org/build/1689172/details
>>
>> [...]
>>
>> This does not happen on current 'master', so the problem was introduced
>> somewhere in between ccbc1c5eb..cbc8c658d.
>
> Upstream bug report here:
>
> https://jira.mariadb.org/browse/MDEV-20573
>
> I'm not sure what to do about it. We could skip it, but then users who
> rely on encrypted binary logs could potentially get in trouble. I
> haven't found a compile-time flag to disable just this one feature.

No idea, let’s see what upstream thinks.

If they don’t reply in a timely fashion, we should try and find a way to
disable that feature on armhf.

Thanks for investigating!

Ludo’.
M
M
Marius Bakke wrote on 8 Oct 2019 11:00
Re: [core-updates] MariaDB fails tests on armhf-linux
(address . 37605-done@debbugs.gnu.org)
87o8yr628n.fsf@devup.no
Marius Bakke <mbakke@fastmail.com> writes:

Toggle quote (20 lines)
> Marius Bakke <mbakke@fastmail.com> writes:
>
>> "mariadb" consistently fails a single test on the core-updates branch on
>> armhf-linux:
>>
>> https://ci.guix.gnu.org/build/1689172/details
>>
>> [...]
>>
>> This does not happen on current 'master', so the problem was introduced
>> somewhere in between ccbc1c5eb..cbc8c658d.
>
> Upstream bug report here:
>
> https://jira.mariadb.org/browse/MDEV-20573
>
> I'm not sure what to do about it. We could skip it, but then users who
> rely on encrypted binary logs could potentially get in trouble. I
> haven't found a compile-time flag to disable just this one feature.

I was able to work around it by going back to GCC 5:
modified gnu/packages/databases.scm
@@ -72,6 +72,7 @@
#:use-module (gnu packages dbm)
#:use-module (gnu packages emacs)
#:use-module (gnu packages flex)
+ #:use-module (gnu packages gcc)
#:use-module (gnu packages gettext)
#:use-module (gnu packages glib)
#:use-module (gnu packages gnupg)
@@ -779,6 +780,10 @@ Language.")
#t))))))
(native-inputs
`(("bison" ,bison)
+ ;; XXX: On armhf, use GCC 5 to work around https://bugs.gnu.org/37605.
+ ,@(if (string-prefix? "armhf" (%current-system))
+ `(("gcc", gcc-5))
+ '())
("perl" ,perl)))
(inputs
`(("jemalloc" ,jemalloc)
GCC 9 did not make a difference.

Workaround pushed in 2fa55c72476c73211cbb2d6b29c05a1ad58a6cf9. Let's
revisit this after upgrading to MariaDB 10.4.
-----BEGIN PGP SIGNATURE-----

iQEzBAEBCgAdFiEEu7At3yzq9qgNHeZDoqBt8qM6VPoFAl2cUCgACgkQoqBt8qM6
VPqJlggAvMJXG7uET0basigaoRMt2tPShVudi2VQ9nUU9BE0fKgW9eeYJQIiDdTR
QWkplefShCJts764EOuckC8Aw97Yt9QaZrx8QF9vtrEKLRmF9BJnJmN1yGq1I5/P
A44kw0FZjz1ApZj/dyuBKKf4Nfox5Hy4xC58E9aO7uRzkYBDTYD5i1RABZvyxnUQ
IuVXL8dQoZrprsBq6YxeuAt0p99azPxjqbPPhe0dtdk/9LY1ktQE9UZM2TB3723K
i7+S9hibCJrt7sT9EnXagnRPt6xwD1ni+MhNbUbDVMOosn0lSQJz59DWgMZxFWnH
Rja7VhaEBbt02UdF/BXjWknWWOvJEQ==
=7SNb
-----END PGP SIGNATURE-----

Closed
L
L
Ludovic Courtès wrote on 8 Oct 2019 11:20
Re: bug#37605: closed (Re: [core-updates] MariaDB fails tests on armhf-linux)
87muebiof1.fsf@gnu.org
Hi Marius,

Toggle quote (2 lines)
> I was able to work around it by going back to GCC 5:

Weird, but great that it works!

Now we can hit the “merge” button. :-)

Thanks!

Ludo’.
?
Your comment

This issue is archived.

To comment on this conversation send email to 37605@debbugs.gnu.org