MySQL crashed with: double free or corruption (!prev): 0x00007fec0b86ade0
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
New
|
Undecided
|
Unassigned |
Bug Description
3 days ago (Jun, 6, 2017) I updated MySQL from version Percona Server 5.6.23-72.1 to version 5.7.18-15.1 (I also also ran system tables upgrade). OS Oracle Linux 7.2/x86_64.
The server is a master in master-slave pair. We use native 5.7 partitioning (it was the main goal of upgrade), and we use row_format=
Today server crashed with the following message (more details in attached file):
2017-06-
*** Error in `/usr/sbin/mysqld': double free or corruption (!prev): 0x00007fec0b86ade0 ***
======= Backtrace: =========
/lib64/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/lib64/
/lib64/
here is my.cnf:
[mysqld]
pid-file=
socket = /var/lib/
max_connections = 500
character-
skip-name-resolve
skip-slave-start
datadir = /opt/mysql
log-error = /var/log/mysqld.log
slow-query-log = 1
slow-query-log-file = /var/log/
max_slowlog_files = 5
max_slowlog_size = 10000000
long-query-time = 2
innodb_
innodb_
innodb_
innodb_
innodb_file_format = Barracuda
userstat = 1
server-id=1
log-bin = /opt/binlogs/
expire_logs_days = 2
log-slave-updates
relay-log = mysqld-relay-bin
sync_binlog = 0
skip-slave-start
performance_schema = 0
innodb_
event_scheduler = on
Today 24.06.2017, we hit it again. MySQL crashed with the same bug:
2017-06- 23T11:31: 26.156921Z 2541990 [Note] Aborted connection 2541990 to db: 'xxxxx' user: 'xxxx' host: '192.168.xx.xx' (Got timeout reading communication packets)
*** Error in `/usr/sbin/mysqld': double free or corruption (!prev): 0x00007fb1a0007880 *** libc.so. 6(+0x7d053) [0x7fb3a34eb053 ] mysqld( _Z15row_ search_ mvccPh15page_ cur_mode_ tP14row_ prebuilt_ tmm+0xaa4) [0x11098c4] mysqld( _ZN11ha_ innobase10index _readEPhPKhj16h a_rkey_ function+ 0x316)[ 0xff4326] mysqld( _ZN7handler17ha _index_ read_mapEPhPKhm 16ha_rkey_ function+ 0x248)[ 0x80bc58] mysqld( _ZN7handler16re ad_range_ firstEPK12st_ key_rangeS2_ bb+0x5c) [0x80c40c] mysqld( _ZN7handler21mu lti_range_ read_nextEPPc+ 0x99)[0x7ff059] mysqld( _ZN18QUICK_ RANGE_SELECT8ge t_nextEv+ 0x5a)[0xe0605a] mysqld[ 0xc3747a] mysqld( _Z10sub_ selectP4JOINP7Q EP_TABb+ 0x11b)[ 0xca8d8b] mysqld( _ZN4JOIN4execEv +0x267) [0xca1967] mysqld( _Z12handle_ queryP3THDP3LEX P12Query_ resultyy+ 0x17d)[ 0xd13f5d] mysqld[ 0x75f7c1] mysqld( _Z21mysql_ execute_ commandP3THDb+ 0x482e) [0xcd518e] mysqld( _Z11mysql_ parseP3THDP12Pa rser_state+ 0x60d)[ 0xcd84dd] mysqld( _Z16dispatch_ commandP3THDPK8 COM_DATA19enum_ server_ command+ 0xaba)[ 0xcd902a] mysqld( _Z10do_ commandP3THD+ 0x1df)[ 0xcdaabf] mysqld( handle_ connection+ 0x2b8)[ 0xda2f28] mysqld( pfs_spawn_ thread+ 0x1b4)[ 0xf22a94] libpthread. so.0(+0x7dc5) [0x7fb3a5311dc5 ] libc.so. 6(clone+ 0x6d)[0x7fb3a35 64c4d]
======= Backtrace: =========
/lib64/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/lib64/
/lib64/
======= Memory map: ========