Percona crashes when doing a a 'larger' update
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OpenStack Charm Test Infra |
Confirmed
|
Low
|
Ryan Beisner | ||
percona-xtradb-cluster-5.5 (Ubuntu) |
Confirmed
|
Medium
|
Jorge Niedbalski | ||
Trusty |
Fix Released
|
High
|
Jorge Niedbalski | ||
percona-xtradb-cluster-5.6 (Ubuntu) |
Fix Released
|
High
|
Jorge Niedbalski | ||
Xenial |
Fix Released
|
High
|
Jorge Niedbalski | ||
Zesty |
Fix Released
|
High
|
Jorge Niedbalski | ||
Artful |
Fix Released
|
High
|
Jorge Niedbalski |
Bug Description
[Impact]
* Percona will segfault when exposed to medium load, almost imediately
* This is because of a bug in upstream, which manifests on ARM and PPC
[Test Case]
* Install and configure percona-
* Run sysbench against configured node (only one node is needed, no need for proper cluster):
# sysbench --test=oltp --oltp-
* mysqld will segfault seconds withing starting the test
[Regression Potential]
* This is a cherry-pick from an upstream fix (https:/
* This is not fixed in upstream Percona becasue Percona does not officially support non-intel archs.
* Because code adds additional memory barriers there was a chance of performance degradation on i386/amd64. However, intensive sysbench syntetic loads proved this is not the case - there are no performance penalties.
* Zesty autopkgtest failures :
Explanation --> https:/
[Other Info]
* percona-
$ rmadison percona-
percona-
percona-
percona-
* See comment #22 for more context about other releases that offers percona-
https:/
* Upstream commit: https:/
[Original Description]
I'm trying to set up percona-
I can also crash mysql manually, by updating the sbtest table (which is created by the sysbench utility):
mysql> update sbtest set pad = 'mario1' limit 1000000;
ERROR 2013 (HY000): Lost connection to MySQL server during query
Sometimes I need to repeat this update (with different values for 'pad' field) few times. This happens regardless of whether I run the UPDATE inside the transaction or not.
This is the assertion found in the log file:
170117 21:10:55 InnoDB: Assertion failure in thread 70366668321152 in file buf0buf.ic line 1277
InnoDB: Failing assertion: block->
This is a single-node percona-
I'm attaching the full log file, mysql configuration file and the core dumped.
The version of the package installed is this 5.5.37-
Related branches
- Christian Ehrhardt : Disapprove
-
Diff: 95 lines (+75/-0)3 files modifieddebian/changelog (+7/-0)
debian/patches/fix_power8_crash_under_load.patch (+67/-0)
debian/patches/series (+1/-0)
- Christian Ehrhardt : Approve
-
Diff: 50 lines (+28/-0)3 files modifieddebian/changelog (+7/-0)
debian/patches/fix_time_collector_lock_type.patch (+20/-0)
debian/patches/series (+1/-0)
description: | updated |
Changed in percona-xtradb-cluster-5.5 (Ubuntu): | |
status: | New → Confirmed |
status: | Confirmed → In Progress |
assignee: | nobody → Rafael David Tinoco (inaddy) |
no longer affects: | percona-xtradb-cluster |
Changed in percona-xtradb-cluster-5.5 (Ubuntu): | |
importance: | Undecided → Medium |
no longer affects: | percona-xtradb-cluster |
Changed in percona-xtradb-cluster-5.6 (Ubuntu): | |
assignee: | nobody → Mario Splivalo (mariosplivalo) |
status: | New → In Progress |
Changed in percona-xtradb-cluster-5.5 (Ubuntu): | |
assignee: | Rafael David Tinoco (inaddy) → Mario Splivalo (mariosplivalo) |
Changed in percona-xtradb-cluster-5.6 (Ubuntu): | |
importance: | Undecided → Medium |
no longer affects: | percona-xtradb-cluster-5.5 (Ubuntu Xenial) |
no longer affects: | percona-xtradb-cluster-5.5 (Ubuntu Yakkety) |
no longer affects: | percona-xtradb-cluster-5.6 (Ubuntu Trusty) |
no longer affects: | percona-xtradb-cluster-5.5 (Ubuntu Zesty) |
Changed in percona-xtradb-cluster-5.5 (Ubuntu Trusty): | |
assignee: | nobody → Mario Splivalo (mariosplivalo) |
Changed in percona-xtradb-cluster-5.6 (Ubuntu Xenial): | |
assignee: | nobody → Mario Splivalo (mariosplivalo) |
Changed in percona-xtradb-cluster-5.6 (Ubuntu Yakkety): | |
assignee: | nobody → Mario Splivalo (mariosplivalo) |
Changed in percona-xtradb-cluster-5.5 (Ubuntu Trusty): | |
status: | New → In Progress |
Changed in percona-xtradb-cluster-5.5 (Ubuntu Trusty): | |
importance: | Undecided → Medium |
Changed in percona-xtradb-cluster-5.6 (Ubuntu Xenial): | |
importance: | Undecided → Medium |
Changed in percona-xtradb-cluster-5.6 (Ubuntu Yakkety): | |
importance: | Undecided → Medium |
description: | updated |
no longer affects: | percona-xtradb-cluster-5.6 (Ubuntu Zesty) |
no longer affects: | percona-xtradb-cluster-5.6 (Ubuntu) |
no longer affects: | percona-xtradb-cluster-5.6 (Ubuntu Xenial) |
no longer affects: | percona-xtradb-cluster-5.6 (Ubuntu Yakkety) |
tags: | added: sts-sru-needed |
description: | updated |
tags: |
added: sts-sru-done removed: sts-sru-needed |
no longer affects: | percona-xtradb-cluster-5.5 (Ubuntu Yakkety) |
no longer affects: | percona-xtradb-cluster-5.5 (Ubuntu Zesty) |
no longer affects: | percona-xtradb-cluster-5.5 (Ubuntu Xenial) |
Changed in percona-xtradb-cluster-5.6 (Ubuntu): | |
importance: | Undecided → Medium |
Changed in percona-xtradb-cluster-5.6 (Ubuntu Xenial): | |
importance: | Undecided → Medium |
Changed in percona-xtradb-cluster-5.6 (Ubuntu Yakkety): | |
importance: | Undecided → Medium |
Changed in percona-xtradb-cluster-5.6 (Ubuntu Zesty): | |
importance: | Undecided → Medium |
Changed in percona-xtradb-cluster-5.6 (Ubuntu): | |
assignee: | nobody → Mario Splivalo (mariosplivalo) |
Changed in percona-xtradb-cluster-5.6 (Ubuntu Xenial): | |
assignee: | nobody → Mario Splivalo (mariosplivalo) |
Changed in percona-xtradb-cluster-5.6 (Ubuntu Yakkety): | |
assignee: | nobody → Mario Splivalo (mariosplivalo) |
Changed in percona-xtradb-cluster-5.6 (Ubuntu Zesty): | |
assignee: | nobody → Mario Splivalo (mariosplivalo) |
Changed in percona-xtradb-cluster-5.6 (Ubuntu Xenial): | |
status: | New → Confirmed |
Changed in percona-xtradb-cluster-5.6 (Ubuntu Yakkety): | |
status: | New → Confirmed |
Changed in percona-xtradb-cluster-5.6 (Ubuntu Zesty): | |
status: | New → Confirmed |
tags: |
added: verification-done-trusty removed: verification-done |
tags: |
added: sts-sru-needed removed: sts-sru-done |
Changed in percona-xtradb-cluster-5.6 (Ubuntu): | |
status: | New → In Progress |
assignee: | Mario Splivalo (mariosplivalo) → Jorge Niedbalski (niedbalski) |
Changed in percona-xtradb-cluster-5.5 (Ubuntu): | |
assignee: | Mario Splivalo (mariosplivalo) → Jorge Niedbalski (niedbalski) |
tags: | added: patch |
no longer affects: | percona-xtradb-cluster-5.5 (Ubuntu Artful) |
no longer affects: | percona-xtradb-cluster-5.6 (Ubuntu Yakkety) |
Changed in percona-xtradb-cluster-5.6 (Ubuntu Artful): | |
importance: | Medium → High |
Changed in charm-test-infra: | |
importance: | High → Low |
Changed in percona-xtradb-cluster-5.6 (Ubuntu Xenial): | |
status: | Confirmed → In Progress |
importance: | Medium → High |
assignee: | Mario Splivalo (mariosplivalo) → Jorge Niedbalski (niedbalski) |
Changed in percona-xtradb-cluster-5.5 (Ubuntu Trusty): | |
assignee: | Mario Splivalo (mariosplivalo) → Jorge Niedbalski (niedbalski) |
Changed in percona-xtradb-cluster-5.6 (Ubuntu Zesty): | |
assignee: | Mario Splivalo (mariosplivalo) → Jorge Niedbalski (niedbalski) |
status: | Confirmed → In Progress |
importance: | Medium → High |
Changed in percona-xtradb-cluster-5.5 (Ubuntu Trusty): | |
importance: | Medium → High |
description: | updated |
tags: |
added: sts-sru-done removed: sts-sru-needed |
I was able to reproduce this with percona- xtradb- cluster- server 5.6 from xenial too, on the same architecture (again inside xenial lxc container).
I'm attaching the error.log for percona-5.6 too here, as the assertion is different.