#1084786 mariadb-client: mariadb-dump fails on mysql 5.7 db with syntax error

Package:
mariadb-client
Source:
mariadb-client
Description:
MariaDB database client binaries
Submitter:
Lukas Wedeking
Date:
2025-04-19 21:06:03 UTC
Severity:
normal
#1084786#5
Date:
2024-10-08 08:29:32 UTC
From:
To:
Dear Maintainer,

I tried to dump a mysql database (mysql is running version 5.7.44) with
mariadb-dump, but it fails with this message:

   mysqldump: Couldn't execute '/*!100100 SET WAIT_TIMEOUT=DEFAULT */':
   You have an error in your SQL syntax; check the manual that
   corresponds to your MySQL server version for the right syntax to use
   near '0 SET WAIT_TIMEOUT=DEFAULT */' at line 1 (1064)

I tried adding --compatible with mysql40 and mysql323, but the same
error occured nonetheless. Logging into the database with mariadb works
as expected.

Best regards
Lukas
#1084786#10
Date:
2024-10-10 03:24:34 UTC
From:
To:
Hi,

This is most likely not related to the Debian packaging, so I
recommend filing a bug directly at upstream jira.mariadb.org instead -
and check first if it is already filed there.
#1084786#15
Date:
2024-10-10 06:54:21 UTC
From:
To:
Hi,

Am 10.10.24 um 05:24 schrieb Otto Kekäläinen:

thanks for pointing me to the mariadb issue tracker. There is indeed
already a ticket[1] there for the issue and iiuc it should be fixed in
the next release.

[1]https://jira.mariadb.org/browse/MDEV-34318
#1084786#20
Date:
2024-10-10 07:36:37 UTC
From:
To:
#1084786#25
Date:
2025-04-11 15:45:16 UTC
From:
To:
Seems this was fixed in
https://github.com/MariaDB/server/commit/d60f5c11ea9008fa57444327526e3d2c8633ba06
and included in 10.5.26, 10.6.19, 10.11.9, 11.4.3 and 11.8.0. Thus
this is fixed in all MariaDB versions currently in Debian. Closing
issue.