[Impact]
With Percona Cluster in pxc-strict-mode=ENFORCING, When the charm tried
to execute a database migration with the command:
$ sudo octavia-db-manage upgrade head
It failed with the following error:
2019-04-29 11:49:20.096 22569 ERROR octavia-db-manage
sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1105,
'Percona-XtraDB-Cluster prohibits use of DML command on a table
(octavia.spares_pool) without an explicit primary key with
pxc_strict_mode = ENFORCING or MASTER') [SQL: 'INSERT INTO spares_pool
(updated_at) VALUES (%(updated_at)s)'] [parameters: {'updated_at':
datetime.datetime(2019, 4, 29, 11, 49, 20, 94405)}] (Background on this
error at: http://sqlalche.me/e/2j85)
[Test Case]
* After to have installed the new package, execute a db migration
upgrade.
[Fix]
* The fix accepted upstream and cherry-picked set a primary key to the
table 'spares_pool'.
[Regression Potential]
* n/a
[Other Info]
* n/a
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1826875
Title:
[stein] 'Percona-XtraDB-Cluster prohibits use of DML command on a
table (octavia.spares_pool) without an explicit primary key with
pxc_strict_mode = ENFORCING or MASTER')
To manage notifications about this bug go to:
https://bugs.launchpad.net/cloud-archive/+bug/1826875/+subscriptions
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
