Bug #59513 | Failing assertion: prebuilt->sql_stat_start || trx->state == TRX_STATE_ACTIVE | ||
---|---|---|---|
Submitted: | 14 Jan 2011 19:08 | Modified: | 11 Feb 2011 7:05 |
Reporter: | Shane Bester (Platinum Quality Contributor) | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | MySQL Server: InnoDB storage engine | Severity: | S1 (Critical) |
Version: | 5.6.2 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[14 Jan 2011 19:08]
Shane Bester
[14 Jan 2011 19:19]
MySQL Verification Team
some infos
Attachment: bug59513_gdb_infos.txt (text/plain), 183.55 KiB.
[12 Sep 2014 1:10]
Roel Van de Paar
Seen here also 2014-09-12 00:59:35 16886 [ERROR] /sda/Percona-Server-5.6.20-rel68.0-657.Linux.x86_64-debug/bin/mysqld: Deadlock found when trying to get lock; try restarting transaction 2014-09-12 00:59:35 16886 [ERROR] /sda/Percona-Server-5.6.20-rel68.0-657.Linux.x86_64-debug/bin/mysqld: Sort aborted: Deadlock found when trying to get lock; try restarting transaction 2014-09-12 00:59:38 7f4309c97700 InnoDB: Assertion failure in thread 139925903734528 in file row0sel.cc line 4021 InnoDB: Failing assertion: prebuilt->sql_stat_start || trx->state == TRX_STATE_ACTIVE
[12 Sep 2014 1:23]
Roel Van de Paar
A developer may be able to find the issue by core analysis even without testcase. I was not able to reproduce easily either. Uploading core, myqsld used, ldd files, vardir, stacks, error log etc. for analysis.
[12 Sep 2014 2:05]
Roel Van de Paar
Uploaded mysql-bug-59513_BUNDLE_160.tar.gz, please analyze
[12 Sep 2014 2:05]
Roel Van de Paar
(to SFTP)