Your message dated Sat, 31 Aug 2019 01:02:20 +0000
with message-id <[email protected]>
and subject line Bug#931801: fixed in mariadb-10.3 1:10.3.17-0+deb10u1
has caused the Debian Bug report #931801,
regarding mariadb-server-core-10.3: mysqld segfaults when database
`information_schema` is accessed
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.)
--
931801: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=931801
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: mariadb-server-core-10.3
Version: 1:10.3.15-1
Severity: critical
Justification: causes serious data loss
-- System Information:
Debian Release: 10.0
APT prefers stable
APT policy: (500, 'stable')
Architecture: amd64 (x86_64)
Kernel: Linux 4.19.0-5-amd64 (SMP w/2 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8),
LANGUAGE=en_US:en (charmap=UTF-8)
Shell: /bin/sh linked to /usr/bin/dash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled
Versions of packages mariadb-server-core-10.3 depends on:
ii libaio1 0.3.112-3
ii libc6 2.28-10
ii libgnutls30 3.6.7-4
ii liblz4-1 1.8.3-1
ii libpcre3 2:8.39-12
ii libsnappy1v5 1.1.7-1
ii libstdc++6 8.3.0-6
ii libsystemd0 241-5
ii mariadb-common 1:10.3.15-1
ii zlib1g 1:1.2.11.dfsg-1
mariadb-server-core-10.3 recommends no packages.
mariadb-server-core-10.3 suggests no packages.
-- no debconf information
How to trigger the issue:
* install mariadb-server
* start 'mysql' in a terminal
* enter 'user information_schema'
The process mysqld will segfault, thus terminating all existing processes
within the server.
It writes the following to the error log (e.g. /var/lib/mysql/error.log:
---------------
190710 16:45:48 [ERROR] mysqld got signal 11 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
To report this bug, see https://mariadb.com/kb/en/reporting-bugs
We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.
Server version: 10.3.15-MariaDB-1
key_buffer_size=134217728
read_buffer_size=131072
max_used_connections=1
max_threads=153
thread_count=7
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467420 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
Thread pointer: 0x55b4ef5ef738
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0x7f2beceeadd8 thread_stack 0x49000
/usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x55b4eda6ea5e]
/usr/sbin/mysqld(handle_fatal_signal+0x54d)[0x55b4ed5d8fcd]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x12730)[0x7f2bf1f27730]
/usr/sbin/mysqld(+0xc6b67a)[0x55b4edad167a]
/usr/sbin/mysqld(_Z17find_schema_tableP3THDPK25st_mysql_const_lex_stringPb+0x55)[0x55b4ed475eb5]
/usr/sbin/mysqld(_Z11open_tablesP3THDRK14DDL_options_stPP10TABLE_LISTPjPP19Sroutine_hash_entryjP19Prelocking_strategy+0x8cf)[0x55b4ed3b59af]
/usr/sbin/mysqld(_Z30open_normal_and_derived_tablesP3THDP10TABLE_LISTjj+0x64)[0x55b4ed3b6684]
/usr/sbin/mysqld(_Z18mysqld_list_fieldsP3THDP10TABLE_LISTPKc+0x35)[0x55b4ed466655]
/usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x24c8)[0x55b4ed413b68]
/usr/sbin/mysqld(_Z10do_commandP3THD+0x170)[0x55b4ed4140b0]
/usr/sbin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x20a)[0x55b4ed4e25da]
/usr/sbin/mysqld(handle_one_connection+0x3d)[0x55b4ed4e277d]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x7fa3)[0x7f2bf1f1cfa3]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7f2bf15a64cf]
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0x55b4ef5fd1f0):
Connection ID (thread ID): 36
Status: NOT_KILLED
Optimizer switch:
index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
Writing a core file...
Working directory at /var/lib/mysql
Resource Limits:
Limit Soft Limit Hard Limit Units
Max cpu time unlimited unlimited seconds
Max file size unlimited unlimited bytes
Max data size unlimited unlimited bytes
Max stack size 8388608 unlimited bytes
Max core file size 0 unlimited bytes
Max resident set unlimited unlimited bytes
Max processes 15580 15580 processes
Max open files 16364 16364 files
Max locked memory 65536 65536 bytes
Max address space unlimited unlimited bytes
Max file locks unlimited unlimited locks
Max pending signals 15580 15580 signals
Max msgqueue size 819200 819200 bytes
Max nice priority 0 0
Max realtime priority 0 0
Max realtime timeout unlimited unlimited us
Core pattern: core
----------------
Systemd then automatically restarts mysqld so that operation continues, but at
this
point data loss might have occurred already.
--- End Message ---
--- Begin Message ---
Source: mariadb-10.3
Source-Version: 1:10.3.17-0+deb10u1
We believe that the bug you reported is fixed in the latest version of
mariadb-10.3, which is due to be installed in the Debian FTP archive.
A summary of the changes between this version and the previous one is
attached.
Thank you for reporting the bug, which will now be closed. If you
have further comments please address them to [email protected],
and the maintainer will reopen the bug report if appropriate.
Debian distribution maintenance software
pp.
Otto Kekäläinen <[email protected]> (supplier of updated mariadb-10.3 package)
(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing [email protected])
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512
Format: 1.8
Date: Tue, 27 Aug 2019 23:42:59 +0200
Source: mariadb-10.3
Binary: libmariadb-dev libmariadbclient-dev libmariadb-dev-compat libmariadb3
libmariadbd19 libmariadbd-dev mariadb-common mariadb-client-core-10.3
mariadb-client-10.3 mariadb-server-core-10.3 mariadb-server-10.3 mariadb-server
mariadb-client mariadb-backup mariadb-plugin-connect mariadb-plugin-rocksdb
mariadb-plugin-oqgraph mariadb-plugin-tokudb mariadb-plugin-mroonga
mariadb-plugin-spider mariadb-plugin-gssapi-server mariadb-plugin-gssapi-client
mariadb-plugin-cracklib-password-check mariadb-test mariadb-test-data
Architecture: source
Version: 1:10.3.17-0+deb10u1
Distribution: buster
Urgency: high
Maintainer: Debian MySQL Maintainers <[email protected]>
Changed-By: Otto Kekäläinen <[email protected]>
Description:
libmariadb-dev - MariaDB database development files
libmariadb-dev-compat - MariaDB Connector/C, compatibility symlinks
libmariadb3 - MariaDB database client library
libmariadbclient-dev - MariaDB database development files (transitional
package)
libmariadbd-dev - MariaDB embedded database, development files
libmariadbd19 - MariaDB embedded database, shared library
mariadb-backup - Backup tool for MariaDB server
mariadb-client - MariaDB database client (metapackage depending on the latest
vers
mariadb-client-10.3 - MariaDB database client binaries
mariadb-client-core-10.3 - MariaDB database core client binaries
mariadb-common - MariaDB common metapackage
mariadb-plugin-connect - Connect storage engine for MariaDB
mariadb-plugin-cracklib-password-check - CrackLib Password Validation Plugin
for MariaDB
mariadb-plugin-gssapi-client - GSSAPI authentication plugin for MariaDB client
mariadb-plugin-gssapi-server - GSSAPI authentication plugin for MariaDB server
mariadb-plugin-mroonga - Mroonga storage engine for MariaDB
mariadb-plugin-oqgraph - OQGraph storage engine for MariaDB
mariadb-plugin-rocksdb - RocksDB storage engine for MariaDB
mariadb-plugin-spider - Spider storage engine for MariaDB
mariadb-plugin-tokudb - TokuDB storage engine for MariaDB
mariadb-server - MariaDB database server (metapackage depending on the latest
vers
mariadb-server-10.3 - MariaDB database server binaries
mariadb-server-core-10.3 - MariaDB database core server files
mariadb-test - MariaDB database regression test suite
mariadb-test-data - MariaDB database regression test suite - data files
Closes: 930314 931801
Changes:
mariadb-10.3 (1:10.3.17-0+deb10u1) buster; urgency=high
.
* SECURITY UPDATE: New upstream version 10.3.17. Includes fixes for the
following security vulnerabilities:
- CVE-2019-2737
- CVE-2019-2739
- CVE-2019-2740
- CVE-2019-2758
- CVE-2019-2805
* Upstream release 10.3.16 fixed segfaults when database 'information_schema'
is accessed (Closes: #931801)
* Multiple Gitlab-CI/Salsa-CI improvements
* Update libmariadb3 symbols to match MariaDB Connector C 3.1 API
* Add Lintian override for new test binary wsrep_check_version
* Make libzstd dependency versioned as RocksDB need at least 1.3.3
* Rename 'mariadbcheck' to 'mariadb-check' as upstream is doing in 10.4
* Improve cross building (Closes: #930314)
- Perform a native build of import_executables first.
- cross.patch: Fix missing include in cmake/systemd.cmake.
- Build-Depends: libreadline-gplv2-dev:native for the native pass.
- Forward IMPORT_EXECUTABLES to the cross build pass.
Checksums-Sha1:
4b23cc5ebdf4074483cdd0358ed2ff6c0b5c3679 4812
mariadb-10.3_10.3.17-0+deb10u1.dsc
16edbd4762c8804118dda10de713cbddc675df5a 71894997
mariadb-10.3_10.3.17.orig.tar.gz
5aa36a844eb7fe8979c333786aa82365c2eaaddf 181
mariadb-10.3_10.3.17.orig.tar.gz.asc
52fb733a35e89f83c2743fe5ec953fdc52fc7519 222724
mariadb-10.3_10.3.17-0+deb10u1.debian.tar.xz
7ba6f21ff0d73485e94200aa55d81f8082c285ce 9283
mariadb-10.3_10.3.17-0+deb10u1_source.buildinfo
Checksums-Sha256:
6405c4d6984d166484a18a63047ff888c55664a029810e936b3b851963f22e8f 4812
mariadb-10.3_10.3.17-0+deb10u1.dsc
20a1ea4fc59aae89dcc82aff0d4907b036daf9bfbd252f08162399f055097097 71894997
mariadb-10.3_10.3.17.orig.tar.gz
989f24ffd89310a8c79bee4a3164f5495b1dba0e7d6b9966db3d88957c9ea698 181
mariadb-10.3_10.3.17.orig.tar.gz.asc
7e07e38beeb6dcbff9f969e7f291595e923e0452265f1e7a09d334dee8501a8d 222724
mariadb-10.3_10.3.17-0+deb10u1.debian.tar.xz
9d6573d493078ba6422f722b1219e843fbd3ba3908d00a0f91f25b716d47c737 9283
mariadb-10.3_10.3.17-0+deb10u1_source.buildinfo
Files:
1d85d20606f4727026061d33bc1e5097 4812 database optional
mariadb-10.3_10.3.17-0+deb10u1.dsc
6bcee042bcc393cfcffeccbddbf6fe0e 71894997 database optional
mariadb-10.3_10.3.17.orig.tar.gz
6ca67cdcf3f2442888f24d967e1ee538 181 database optional
mariadb-10.3_10.3.17.orig.tar.gz.asc
f587753b91949bbe4cef68a4f8442bc8 222724 database optional
mariadb-10.3_10.3.17-0+deb10u1.debian.tar.xz
d1cbdbade5703f40fd67a908f4498bcf 9283 database optional
mariadb-10.3_10.3.17-0+deb10u1_source.buildinfo
-----BEGIN PGP SIGNATURE-----
iQIzBAEBCgAdFiEEmbRSsR88dMO0U+RvvthEn87o2ogFAl1m7x0ACgkQvthEn87o
2ojOnxAAqPvKRuvWBst/sA4JvWjt2wNNzv3jc+6OOMKkaE/1SVZ4L5jUXV51BTeO
ZDB/xS+ovPqpmey7DOF1Py+7Vcio29iwgJk2lC5KC9WDOJg+tMYDNaAxANmKtCms
tfsnEb0xPLMm91L7KzVtz/ss9h5B5sCnsoOPD5QUsK6PDjjgyX/NhkZ8Lfw/AcLX
Xi49N2QzMBLYocwY0ENamDvhxpxoFRlJMCAiMgnE65UK/EYjyEPfiuOjvrHnxALS
b8NSzaiDSXGFxy1i+SvhEOiGYmLHTFayfkflB3PIsGjM83XV9m4dYpSa9YZLHwuw
nF9pkUpCmUWjy4fiyPbJk7nNfjYkA4rXZ0V41k9ucWAqynEO4G4RS60TVjOC0PVc
T/eTrdbSD3ifDDUkVtmJw5sY45SM6ptgsXqgW9IutJ2S+TjVhQUIGMsl8tXdXSOh
m/oXIStDQuxIqWN1lgTpO8voN6oaJJHfp9pkN3Ij1svPNXhCU4n89USuJ7P9IT6T
NqhLjZRG0hiwRLvEnBYPIChMJ82KtXAfYVbkqoJJ+Jw+HNIkw/UPUlVG4NYyW7bm
C65T8RYbIXyLS4Tya3yLxRE+VhFEyoNoONHfwIfVg6sPdj6FJnNl3N/7D2Q4YkgP
eQgw0ndjlJ9tz7MZZol9FHDrs3vJrjQTcTOSB6oUHA5s6FrRvIs=
=+VG2
-----END PGP SIGNATURE-----
--- End Message ---