** Also affects: percona-xtradb-cluster-5.5 (Ubuntu Artful) Importance: Medium Assignee: Jorge Niedbalski (niedbalski) Status: Confirmed
** Also affects: percona-xtradb-cluster-5.6 (Ubuntu Artful) Importance: Medium Assignee: Jorge Niedbalski (niedbalski) Status: In Progress -- You received this bug notification because you are a member of नेपाली भाषा समायोजकहरुको समूह, which is subscribed to Xenial. Matching subscriptions: Ubuntu 16.04 Bugs https://bugs.launchpad.net/bugs/1657256 Title: Percona crashes when doing a a 'larger' update Status in OpenStack Charm Test Infra: Confirmed Status in percona-xtradb-cluster-5.5 package in Ubuntu: Confirmed Status in percona-xtradb-cluster-5.6 package in Ubuntu: In Progress Status in percona-xtradb-cluster-5.5 source package in Trusty: Confirmed 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: Confirmed Status in percona-xtradb-cluster-5.5 source package in Artful: Confirmed Status in percona-xtradb-cluster-5.6 source package in Artful: In Progress Bug description: [Impact] * Percona will segfault when exposed to medium load, almost imediately * This is because of a bug in upstream, which manifests only on PPC [Test Case] * Install and configure percona-xtradb-cluster-server * Run sysbench against configured node (only one node is needed, no need for proper cluster): # sysbench --test=oltp --oltp-test-mode=complex --max-time=60 --num-threads=110 run * mysqld will segfault seconds withing starting the test [Regression Potential] * This is a cherry-pick from an upstream fix (https://jira.mariadb.org/browse/MDEV-6450) * 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. [Other Info] * percona-xtradb-cluster-5.5 is only available for Trusty. $ rmadison percona-xtradb-cluster-5.5 percona-xtradb-cluster-5.5 | 5.5.34-25.9+dfsg-0ubuntu4 | trusty/universe | source percona-xtradb-cluster-5.5 | 5.5.37-25.10+dfsg-0ubuntu0.14.04.1 | trusty-security/universe | source percona-xtradb-cluster-5.5 | 5.5.37-25.10+dfsg-0ubuntu0.14.04.2 | trusty-updates/universe | source * See comment #22 for more context about other releases that offers percona-xtradb-cluster-5.6 : https://bugs.launchpad.net/ubuntu/+source/percona-xtradb-cluster-5.5/+bug/1657256/comments/22 * Upstream commit: https://github.com/MariaDB/server/commit/40497577ffd9f85557b15e08ad913f627b2e9530 [Original 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/charm-test-infra/+bug/1657256/+subscriptions _______________________________________________ Mailing list: https://launchpad.net/~group.of.nepali.translators Post to : group.of.nepali.translators@lists.launchpad.net Unsubscribe : https://launchpad.net/~group.of.nepali.translators More help : https://help.launchpad.net/ListHelp