When using CMR db username is too long

Bug #1771729 reported by Christopher Lee
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
OpenStack Percona Cluster Charm
Triaged
Medium
Unassigned

Bug Description

With Juju Cross Model Relations using percona-cluster to relate to it's db results in an error in the https://pastebin.ubuntu.com/p/YXw97nhJxj/ hook.

The error is that the username is too long, this is caused by trying to use the remote_unit() string which will be much longer than the 16 chars allowed by the db helper library.

Example remote-unit name with CMR: remote-ec8dda69cfdb48d18e0dcbc65385a1f1
To reproduce:
 - juju add-model src
 - juju add-model sink
 - juju deploy -m src cs:percona-cluster
 - juju deploy -m sink cs:mediawiki
 - watch -n5 juju status -m src # Wait for unit ready
 - juju offer src.percona-cluster:db
 - juju relate -m sink mediawiki:db admin/src.percona-cluster

The error can be seen using: juju debug-log -m controller

Observe the following error (full traceback can be seen here[1]:
  _mysql_exceptions.OperationalError: (1470, "String 'remote-ec8dda69cfdb48d18e0dcbc65385a1f1' is too long for user name (should be no longer than 16)")

[1] https://pastebin.ubuntu.com/p/YXw97nhJxj/

Revision history for this message
Christopher Lee (veebers) wrote :
Frode Nordahl (fnordahl)
Changed in charm-percona-cluster:
status: New → Triaged
importance: Undecided → Medium
milestone: none → 18.08
James Page (james-page)
Changed in charm-percona-cluster:
milestone: 18.08 → 18.11
James Page (james-page)
Changed in charm-percona-cluster:
milestone: 18.11 → 19.04
David Ames (thedac)
Changed in charm-percona-cluster:
milestone: 19.04 → 19.07
David Ames (thedac)
Changed in charm-percona-cluster:
milestone: 19.07 → 19.10
David Ames (thedac)
Changed in charm-percona-cluster:
milestone: 19.10 → 20.01
James Page (james-page)
Changed in charm-percona-cluster:
milestone: 20.01 → 20.05
David Ames (thedac)
Changed in charm-percona-cluster:
milestone: 20.05 → 20.08
James Page (james-page)
Changed in charm-percona-cluster:
milestone: 20.08 → none
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.