[Bug 1657256] Re: Percona crashes when doing a a 'larger' update

[Ryan Beisner]

Seeing the following with pxc 5.6 xenial ppc64el:

http://paste.ubuntu.com/24287991/

root at juju-c5895e-11:/var/log# dpkg -l | egrep 'mysql|percona'
ii  libdbd-mysql-perl                 4.033-1ubuntu0.1                           ppc64el      Perl5 database interface to the MySQL database
ii  libmysqlclient20:ppc64el          5.7.17-0ubuntu0.16.04.1                    ppc64el      MySQL database client library
ii  mysql-client                      5.7.17-0ubuntu0.16.04.1                    all          MySQL database client (metapackage depending on the latest version)
ii  mysql-client-5.7                  5.7.17-0ubuntu0.16.04.1                    ppc64el      MySQL database client binaries
ii  mysql-client-core-5.7             5.7.17-0ubuntu0.16.04.1                    ppc64el      MySQL database core client binaries
ii  mysql-common                      5.7.17-0ubuntu0.16.04.1                    all          MySQL database common files, e.g. /etc/mysql/my.cnf
ii  percona-galera-3                  3.19-0ubuntu0.16.04.1                      ppc64el      Galera replication framework for Percona XtraDB Cluster
ii  percona-xtrabackup                2.3.7-0ubuntu0.16.04.1                     ppc64el      Open source backup tool for InnoDB and XtraDB
ii  percona-xtradb-cluster-server-5.6 5.6.34-26.19-0ubuntu0.16.04.1              ppc64el      Percona XtraDB Cluster database server binaries
ii  python-mysqldb                    1.3.7-1build2                              ppc64el      Python interface to MySQL

-- 
You received this bug notification because you are a member of Ubuntu
Sponsors Team, which is subscribed to the bug report.
https://bugs.launchpad.net/bugs/1657256

Title:
  Percona crashes when doing a a 'larger' update

Status in percona-xtradb-cluster-5.5 package in Ubuntu:
  In Progress
Status in percona-xtradb-cluster-5.6 package in Ubuntu:
  In Progress
Status in percona-xtradb-cluster-5.5 source package in Trusty:
  In Progress
Status in percona-xtradb-cluster-5.6 source package in Xenial:
  Confirmed
Status in percona-xtradb-cluster-5.6 source package in Yakkety:
  Confirmed
Status in percona-xtradb-cluster-5.6 source package in Zesty:
  In Progress

Bug description:
  I'm trying to set up percona-xtradb-cluster-5.5 on PPC machine. While
  the package installs fine, as soon as I run sysbench oltp becnhmark
  against it, Percona dies (even when I start the benchmark with just
  one connection).

  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->page.buf_fix_count > 0

  This is a single-node percona-xtradb-cluster server, without
  wsrep_provied configured, run inside 14.04 lxc container on 16.04
  host.

  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-25.10+dfsg-
  0ubuntu0.14.04.2.

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/percona-xtradb-cluster-5.5/+bug/1657256/+subscriptions