Your message dated Fri, 11 Apr 2025 18:45:16 +0300
with message-id
<caou6tacpvqvn8n5ukpoemuxtg6ccjxw1zslm8i5n4ngqojj...@mail.gmail.com>
and subject line Re: [debian-mysql] Bug#1084786: mariadb-client: mariadb-dump
fails on mysql 5.7 db with syntax error
has caused the Debian Bug report #1084786,
regarding mariadb-client: mariadb-dump fails on mysql 5.7 db with syntax error
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)
--
1084786: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=1084786
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: mariadb-client
Version: 1:11.4.3-1
Severity: normal
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
-- System Information:
Debian Release: trixie/sid
APT prefers testing
APT policy: (500, 'testing')
Architecture: amd64 (x86_64)
Foreign Architectures: i386
Kernel: Linux 6.10.11-amd64 (SMP w/6 CPU threads; PREEMPT)
Locale: LANG=de_DE.UTF-8, LC_CTYPE=de_DE.UTF-8 (charmap=UTF-8), LANGUAGE not set
Shell: /bin/sh linked to /usr/bin/dash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled
Versions of packages mariadb-client depends on:
ii debianutils 5.20
ii libc6 2.40-2
ii libconfig-inifiles-perl 3.000003-3
ii libssl3t64 3.3.2-1
ii libstdc++6 14.2.0-3
ii mariadb-client-core 1:11.4.3-1
ii perl 5.38.2-5
ii zlib1g 1:1.3.dfsg+really1.3.1-1
Versions of packages mariadb-client recommends:
ii libdbd-mariadb-perl 1.22-1+b3
ii libdbi-perl 1.645-1
ii libterm-readkey-perl 2.38-2+b3
mariadb-client suggests no packages.
-- no debconf information
--- End Message ---
--- Begin Message ---
Version: 1:10.11.9-0+deb12u1
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.
--- End Message ---
