Comment 4 for bug 1689211

No difference:

$ pip show psycopg2
Name: psycopg2
Version: 2.7.1
$ gnocchi-upgrade --config-file gnocchi.conf
2017-05-08 20:55:54.632 17729 INFO gnocchi.cli [-] Upgrading indexer <gnocchi.indexer.sqlalchemy.SQLAlchemyIndexer object at 0x7f0a5503d7f0>
2017-05-08 20:55:54.650 17729 INFO alembic.runtime.migration [-] Context impl PostgresqlImpl.
2017-05-08 20:55:54.650 17729 INFO alembic.runtime.migration [-] Will assume transactional DDL.
2017-05-08 20:55:54.661 17729 INFO alembic.runtime.migration [-] Context impl PostgresqlImpl.
2017-05-08 20:55:54.662 17729 INFO alembic.runtime.migration [-] Will assume transactional DDL.
2017-05-08 20:55:54.691 17729 ERROR gnocchi.utils [-] Unable to start coordinator: ProgrammingError: invalid dsn: invalid connection option "username"

—

> On 08 mag 2017, at 20:05, Julien Danjou <email address hidden> wrote:
>
> I think you need to upgrade to psycopg2 >= 2.7. Can you give it a try
> and tell me if it works better?
>
> ** Project changed: gnocchi => python-tooz
>
> --
> You received this bug notification because you are subscribed to the bug
> report.
> https://bugs.launchpad.net/bugs/1689211
>
> Title:
> unable to start coordinator
>
> Status in tooz:
> New
>
> Bug description:
> $ sudo -H gnocchi-upgrade --config-file gnocchi.conf
> sudo: unable to resolve host juju-0bd5ff-default-4
> 2017-05-08 00:10:22.051 26637 INFO gnocchi.cli [-] Upgrading indexer <gnocchi.indexer.sqlalchemy.SQLAlchemyIndexer object at 0x7ff6b9ed1208>
> 2017-05-08 00:10:22.067 26637 INFO alembic.runtime.migration [-] Context impl PostgresqlImpl.
> 2017-05-08 00:10:22.067 26637 INFO alembic.runtime.migration [-] Will assume transactional DDL.
> 2017-05-08 00:10:22.079 26637 INFO alembic.runtime.migration [-] Context impl PostgresqlImpl.
> 2017-05-08 00:10:22.079 26637 INFO alembic.runtime.migration [-] Will assume transactional DDL.
> 2017-05-08 00:10:22.110 26637 ERROR gnocchi.utils [-] Unable to start coordinator: OperationalError: invalid connection option "username"
> 2017-05-08 00:10:23.112 26637 ERROR gnocchi.utils [-] Unable to start coordinator: OperationalError: invalid connection option "username"
>
> This is on Ubuntu 16.04 with this gnocchi.conf:
>
> [DEFAULT]
> [api]
> [archive_policy]
> [cors]
> [cors.subdomain]
> [database]
> [healthcheck]
> [incoming]
> file_basepath = /var/lib/gnocchi
> [indexer]
> url = 'postgresql://juju_gnocchi:h66cr3KG6TxBK58yrFWbxLBszdVKbSVCpKyMy6f@192.168.250.178:5432/gnocchi'
> [metricd]
> [oslo_middleware]
> [oslo_policy]
> [statsd]
> [storage]
> driver = file
> file_basepath = /var/lib/gnocchi
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/python-tooz/+bug/1689211/+subscriptions