Comment 6 for bug 1826875

[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