Xenial with grafana 7.0.3 relations fail due to schema mismatch

[Nick Moffitt]

2020-07-09 13:56:53 DEBUG grafana-source-relation-changed UPDATE DATA_SOURCE SET basic_auth_user = ?, basic_auth_password = ?, basic_auth = 0 ('', '')
2020-07-09 13:56:53 DEBUG grafana-source-relation-changed Traceback (most recent call last):
2020-07-09 13:56:53 DEBUG grafana-source-relation-changed File "/var/lib/juju/agents/unit-grafana-1/charm/hooks/grafana-source-relation-changed", line 22, in <module>
2020-07-09 13:56:53 DEBUG grafana-source-relation-changed main()
2020-07-09 13:56:53 DEBUG grafana-source-relation-changed File "/var/lib/juju/agents/unit-grafana-1/.venv/lib/python3.5/site-packages/charms/reactive/__init__.py", line 74, in main
2020-07-09 13:56:53 DEBUG grafana-source-relation-changed bus.dispatch(restricted=restricted_mode)
2020-07-09 13:56:53 DEBUG grafana-source-relation-changed File "/var/lib/juju/agents/unit-grafana-1/.venv/lib/python3.5/site-packages/charms/reactive/bus.py", line 390, in dispatch
2020-07-09 13:56:53 DEBUG grafana-source-relation-changed _invoke(other_handlers)
2020-07-09 13:56:53 DEBUG grafana-source-relation-changed File "/var/lib/juju/agents/unit-grafana-1/.venv/lib/python3.5/site-packages/charms/reactive/bus.py", line 359, in _invoke
2020-07-09 13:56:53 DEBUG grafana-source-relation-changed handler.invoke()
2020-07-09 13:56:53 DEBUG grafana-source-relation-changed File "/var/lib/juju/agents/unit-grafana-1/.venv/lib/python3.5/site-packages/charms/reactive/bus.py", line 181, in invoke
2020-07-09 13:56:53 DEBUG grafana-source-relation-changed self._action(*args)
2020-07-09 13:56:53 DEBUG grafana-source-relation-changed File "/var/lib/juju/agents/unit-grafana-1/charm/reactive/grafana.py", line 421, in configure_sources
2020-07-09 13:56:53 DEBUG grafana-source-relation-changed check_datasource(ds)
2020-07-09 13:56:53 DEBUG grafana-source-relation-changed File "/var/lib/juju/agents/unit-grafana-1/charm/reactive/grafana.py", line 529, in check_datasource
2020-07-09 13:56:53 DEBUG grafana-source-relation-changed cur.execute(stmt, values)
2020-07-09 13:56:53 DEBUG grafana-source-relation-changed sqlite3.IntegrityError: UNIQUE constraint failed: data_source.org_id, data_source.uid
2020-07-09 13:56:53 ERROR juju.worker.uniter.operation runhook.go:132 hook "grafana-source-relation-changed" failed: exit status 1
2020-07-09 13:56:53 INFO juju.worker.uniter resolver.go:126 awaiting error resolution for "relation-changed" hook

People who encountered this typically reported crossing the v6/v7 boundary, such as https://community.grafana.com/t/not-able-to-add-datasource-error-unique-constraint-failed-data-source-org-id-data-source-uid/32264/2

[Thomas Cuthbert (tcuthbert)]

Proposed fix https://code.launchpad.net/~tcuthbert/charm-grafana/+git/grafana-charm/+merge/387275