Comment 24 for bug 1366997

Hello, Łukasz!

I have verified that package which is in trusty-proposed fixes the issue.

I merely repeated the test case explained here: https://bugs.launchpad.net/ubuntu/+source/percona-xtradb-cluster-5.5/+bug/1366997/comments/12, but instead of using my personal PPA i used trusty-proposed pocket:

1. I used juju to install a 3 node PXC (Percona Xtradb Cluster): juju deploy cs:trusty/percona-cluster -n3

2. I created the test database and the test table in it:
mysql> CREATE DATABASE pktest;
mysql> CREATE TABLE pktest.t1 (id INTEGER PRIMARY KEY AUTO_INCREMENT, datafield VARCHAR(20));

3. I created a 'ubuntu' user which is able to connect to all the databases from any of the hosts:
mysql> GRANT ALL PRIVILEGES ON *.* TO ubuntu@'%';

4. From the separate node I run this:
$> for i in {1..20}; do (yes "INSERT INTO t1 (datafield) VALUES ('mario');" | mysql -u ubuntu -h 10.0.0.10 pktest) & done

While the INSERTs where running I restarted one of the nodes - the primary key violation occurred instantly.

5. I upgraded my PXC cluster, running this on every node:
# echo 'deb http://archive.ubuntu.com/ubuntu/ trusty-proposed restricted main multiverse universe' >> /etc/apt/sources.list
# apt-get update
# apt-get dist-upgrade

6. After the cluster was completely upgraded and I confirmed it is running fine I repeated step (4):
$> for i in {1..20}; do (yes "INSERT INTO t1 (datafield) VALUES ('mario');" | mysql -u ubuntu -h 10.0.0.10 pktest) & done

While INSERTs were running I restarted one of the nodes. This time no error occurred and INSERTs kept on going.

From that I concluded that the package in trusty-proposed fixes the issue.