[debian-mysql] Bug#1029374: mariadb: FTBFS on ppc64: main.func_json_notembedded very long output and crash

[Otto Kekäläinen]

Source: mariadb
Version: 1:10.11.1-1
Tags: upstream, confirmed, help, ftbfs
User: debian-powerpc at lists.debian.org
Usertags: ppc64
X-Debbugs-CC: debian-powerpc at lists.debian.org

Builds on ppc64 pass but the testsuite that validates that binary
works failed with:

--------------------------------------------------------------------------------
main.func_json_notembedded               w26 [ fail ]  timeout after
7200 seconds
        Test ended at 2023-01-12 21:54:41
Test case timeout after 7200 seconds
== /<<PKGBUILDDIR>>/builddir/mysql-test/var/26/log/func_json_notembedded.log ==
    1234567,
    1234567,
...
    2345678
]
select json_loose(@arr);
json_loose(@arr)
[1234567, 1234567, 1234567, 1234567, 1234567, 1234567, 1234567,
1234567, 1234567, 1234567, 1234567, 1234567, 1234567, 1234567,
1234567, 1234567, 1234567, 1234567, 1234567, 1234567, 1234567,
1234567, 1234567, 1234567, 1234567, 1234567, 1234567,
...
...
...
  2345678]
select json_merge_patch(@obj, @obj);
 == /<<PKGBUILDDIR>>/builddir/mysql-test/var/26/tmp/analyze-timeout-mysqld.1.err
==
mysqltest: Could not open connection 'default' after 500 attempts:
2002 Can't connect to local server through socket
'/<<PKGBUILDDIR>>/builddir/mysql-test/var/tm' (111)
 - found 'core' (0/5)
Core generated by '/<<PKGBUILDDIR>>/builddir/sql/mariadbd'
Output from gdb follows. The first stack trace is from the failing thread.
The following stack traces are from all threads (so the failing one is
duplicated).
--------------------------
[New LWP 20086]
[New LWP 20119]
[New LWP 20101]
[New LWP 20100]
[New LWP 20099]
[New LWP 20111]
[New LWP 20108]
[Thread debugging using libthread_db enabled]
Using host libthread_db library "/lib/powerpc64-linux-gnu/libthread_db.so.1".
Core was generated by `/<<PKGBUILDDIR>>/builddir/sql/mariadbd
--defaults-group-su'.
Program terminated with signal SIGABRT, Aborted.
#0  0x00007fffa689da5c in ?? () from /lib/powerpc64-linux-gnu/libc.so.6
[Current thread is 1 (Thread 0x7fffa792b2a0 (LWP 20086))]
#0  0x00007fffa689da5c in ?? () from /lib/powerpc64-linux-gnu/libc.so.6
#1  0x0000000108f72718 in my_write_core (sig=<optimized out>) at
./mysys/stacktrace.c:424
#2  0x000000010891d058 in handle_fatal_signal (sig=<optimized out>) at
./sql/signal_handler.cc:355
#3  <signal handler called>
#4  0x00007fffa692daf0 in .__poll () from /lib/powerpc64-linux-gnu/libc.so.6
#5  0x00000001084ef3fc in poll (__timeout=-1, __nfds=140737482556448,
__fds=0x1002e8d9098) at
/usr/include/powerpc64-linux-gnu/bits/poll2.h:39
#6  handle_connections_sockets () at ./sql/mysqld.cc:6292
#7  0x00000001084f0e44 in mysqld_main (argc=<optimized out>,
argv=<optimized out>) at ./sql/mysqld.cc:5997
#8  0x0000000108496618 in main (argc=<optimized out>, argv=<optimized
out>) at ./sql/main.cc:34
--------------------------------------------------------------------------------



This is similar as in MariaDB 10.6 in
https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=1007216 so it is not
a regression in 10.11.

For suggestions to fix, Merge Requests on Salsa are very welcome!
https://salsa.debian.org/mariadb-team/mariadb-server/-/wikis/Contributing-to-MariaDB-packaging-in-Debian