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.
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: archive. ubuntu. com/ubuntu/ trusty-proposed restricted main multiverse universe' >> /etc/apt/ sources. list
# echo 'deb http://
# 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.