[debian-mysql] Bug#1030630: Acknowledgement (mariadb: FTBFS on sparc64: /bin/sh: Bad address)

[Otto Kekäläinen]

For the record, latest upload 10.11.1-4 in
https://buildd.debian.org/status/fetch.php?pkg=mariadb&arch=sparc64&ver=1%3A10.11.1-4&stamp=1676000962&raw=0
no longer had the bad address issue, but instead if failed on two
tests:

main.flush-innodb 'innodb'               w1 [ fail ]  timeout after 7200 seconds
        Test ended at 2023-02-10 01:43:49
Test case timeout after 7200 seconds
== /<<PKGBUILDDIR>>/builddir/mysql-test/var/1/log/flush-innodb.log ==
DROP PROCEDURE p1;
# new "EXPORT" keyword is a valid local variable name:
CREATE PROCEDURE p1()
BEGIN
DECLARE export INT;
END|
DROP PROCEDURE p1;
# new "EXPORT" keyword is a valid SP name:
CREATE PROCEDURE export() BEGIN END;
DROP PROCEDURE export;
# new FLUSH TABLES ... FOR EXPORT syntax:
FLUSH TABLES FOR EXPORT;
ERROR 42000: No tables used near 'FOR EXPORT' at line 1
FLUSH TABLES WITH EXPORT;
ERROR 42000: You have an error in your SQL syntax; check the manual
that corresponds to your MariaDB server version for the right syntax
to use near 'EXPORT' at line 1
CREATE TABLE t1 (i INT) engine=InnoDB;
CREATE TABLE t2 LIKE t1;
FLUSH TABLES t1,t2 WITH EXPORT;
ERROR 42000: You have an error in your SQL syntax; check the manual
that corresponds to your MariaDB server version for the right syntax
to use near 'EXPORT' at line 1
FLUSH TABLES t1, t2 FOR EXPORT;
 == /<<PKGBUILDDIR>>/builddir/mysql-test/var/1/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' (61)
 - found 'core' (2/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).
--------------------------
warning: Can't open file anon_inode:[io_uring] which was expanded to
anon_inode:[io_uring] during file-backed mapping note processing
warning: Can't open file anon_inode:[io_uring] which was expanded to
anon_inode:[io_uring] during file-backed mapping note processing
[New LWP 1240150]
[New LWP 1239933]
[New LWP 1239969]
[New LWP 1239972]
[New LWP 1239977]
[New LWP 1239978]
[New LWP 1240026]
[New LWP 1240637]
[New LWP 1240035]
[New LWP 1241030]
[New LWP 1273616]
[Thread debugging using libthread_db enabled]
Using host libthread_db library "/lib/sparc64-linux-gnu/libthread_db.so.1".
Core was generated by `/<<PKGBUILDDIR>>/builddir/sql/mariadbd
--defaults-group-su'.
Program terminated with signal SIGABRT, Aborted.
#0  0xffff800102693cfc in ?? () from /lib/sparc64-linux-gnu/libc.so.6
[Current thread is 1 (Thread 0xffff80010254e8c0 (LWP 1240150))]
#0  0xffff800102693cfc in ?? () from /lib/sparc64-linux-gnu/libc.so.6
#1  0xffff8001026463a0 in raise () from /lib/sparc64-linux-gnu/libc.so.6
#2  0xffff80010262ed28 in abort () from /lib/sparc64-linux-gnu/libc.so.6
#3  0xffff800102686998 in ?? () from /lib/sparc64-linux-gnu/libc.so.6
Backtrace stopped: previous frame identical to this frame (corrupt stack?)
Compressed file
/<<PKGBUILDDIR>>/builddir/mysql-test/var/1/log/main.flush-innodb-innodb/mysqld.1/data/core
 - saving '/<<PKGBUILDDIR>>/builddir/mysql-test/var/1/log/main.flush-innodb-innodb/'
to '/<<PKGBUILDDIR>>/builddir/mysql-test/var/log/main.flush-innodb-innodb/'
Retrying test main.flush-innodb, attempt(2/3)...


I have not seen this before, but the anon_inode:[io_uring] issue
resembles the one seen for HPPA in https://bugs.debian.org/1006529


main.func_json_notembedded               w13 [ fail ]  timeout after
7200 seconds
        Test ended at 2023-02-10 01:45:04
Test case timeout after 7200 seconds
== /<<PKGBUILDDIR>>/builddir/mysql-test/var/13/log/func_json_notembedded.log ==
    1234567,
    1234567,
    1234567,
    1234567,
    1234567,
    1234567,
    1234567,
    1234567,
    1234567,
    1234567,
    1234567,
    2345678
...

This latter is identical to https://bugs.debian.org/1029374