Package: libmariadbclient18
Version: 10.1.38-0+deb9u1
Severity: normal
Dear Maintainer,
we started receive errors on "LOAD DATA LOCAL INFILE" queries from
DBD::mysql when we upgraded libmariadbclient18 from 10.1.37 to 10.1.38
$ ./test.pl
DBD::mysql::db do failed: Malformed packet at ./test.pl line 27.
here is the script to reproduce the bug
$ cat test.pl
-----------------------------
#!/usr/bin/env perl
# vim: ts=8 sw=4 sts=4 et
#
use strict;
use DBI;
my $dbh = DBI->connect(
"dbi:mysql:test:db-host",
"user", "password",
{ RaiseError => 1, PrintError => 0 }
);
my $file = '/tmp/file.test';
open my $out, '>', $file;
print $out "1|2\n";
close $out;
$dbh->do('DROP TABLE IF EXISTS table_name');
$dbh->do(<<SQL);
CREATE TABLE `table_name` (
`a` int(2),
`b` int(2)
) ENGINE=InnoDB CHARSET=latin1
SQL
$dbh->do(<<SQL);
LOAD DATA LOCAL INFILE '$file'
INTO TABLE test.table_name
FIELDS TERMINATED BY '|' (a, b)
SQL
-----------------------------
if we downgrade back to 10.1.37 it works as expected.
$ sudo apt install libmariadbclient18:amd64=10.1.37-0+deb9u1
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following packages will be DOWNGRADED:
libmariadbclient18
0 upgraded, 0 newly installed, 1 downgraded, 0 to remove and 0 not upgraded.
Need to get 783 kB of archives.
After this operation, 7,168 B disk space will be freed.
Do you want to continue? [Y/n]
Get:1 http://security.debian.org stretch/updates/main amd64
libmariadbclient18 amd64 10.1.37-0+deb9u1 [783 kB]
Fetched 783 kB in 0s (1,110 kB/s)
dpkg: warning: downgrading libmariadbclient18:amd64 from 10.1.38-0+deb9u1
to 10.1.37-0+deb9u1
(Reading database ... 68269 files and directories currently installed.)
Preparing to unpack .../libmariadbclient18_10.1.37-0+deb9u1_amd64.deb ...
Unpacking libmariadbclient18:amd64 (10.1.37-0+deb9u1) over
(10.1.38-0+deb9u1) ...
Setting up libmariadbclient18:amd64 (10.1.37-0+deb9u1) ...
Processing triggers for libc-bin (2.24-11+deb9u4) ...
$ ./test.pl
$
-- System Information:
Debian Release: 9.9
APT prefers stable-updates
APT policy: (500, 'stable-updates'), (500, 'stable')
Architecture: amd64 (x86_64)
Kernel: Linux 4.9.0-8-amd64 (SMP w/8 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8),
LANGUAGE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)
Versions of packages libmariadbclient18 depends on:
ii libc6 2.24-11+deb9u4
ii libstdc++6 6.3.0-18+deb9u1
ii mysql-common 5.8+1.0.2
ii zlib1g 1:1.2.8.dfsg-5
libmariadbclient18 recommends no packages.
libmariadbclient18 suggests no packages.
-- no debconf information
