packstack Magnum: Error during MagnumServicePeriodicTasks.update_magnum_service: MultipleResultsFound: Multiple rows were found for one()
Installed Magnum with Packstack. Magnum-conductor service has the following error. Cluster creation failed.
2017-10-14 17:52:35.478 28101 WARNING oslo_messaging.server [-] Possible hang: stop is waiting for start to complete 2017-10-14 17:52:37.840 28114 ERROR oslo_service.periodic_task [req-068caab6-0c6e-47dc-ad50-caf29cd21c3f - - - - -] Error during MagnumServicePeriodicTasks.update_magnum_service: MultipleResultsFound: Multiple rows were found for one() 2017-10-14 17:52:37.840 28114 ERROR oslo_service.periodic_task Traceback (most recent call last): 2017-10-14 17:52:37.840 28114 ERROR oslo_service.periodic_task File "/usr/lib/python2.7/site-packages/oslo_service/periodic_task.py", line 220, in run_periodic_tasks 2017-10-14 17:52:37.840 28114 ERROR oslo_service.periodic_task task(self, context) 2017-10-14 17:52:37.840 28114 ERROR oslo_service.periodic_task File "/usr/lib/python2.7/site-packages/magnum/service/periodic.py", line 43, in handler 2017-10-14 17:52:37.840 28114 ERROR oslo_service.periodic_task func(self, ctx) 2017-10-14 17:52:37.840 28114 ERROR oslo_service.periodic_task File "/usr/lib/python2.7/site-packages/magnum/servicegroup/magnum_service_periodic.py", line 46, in update_magnum_service 2017-10-14 17:52:37.840 28114 ERROR oslo_service.periodic_task ctx, self.host, self.binary) 2017-10-14 17:52:37.840 28114 ERROR oslo_service.periodic_task File "/usr/lib/python2.7/site-packages/oslo_versionedobjects/base.py", line 184, in wrapper 2017-10-14 17:52:37.840 28114 ERROR oslo_service.periodic_task result = fn(cls, context, args, *kwargs) 2017-10-14 17:52:37.840 28114 ERROR oslo_service.periodic_task File "/usr/lib/python2.7/site-packages/magnum/objects/magnum_service.py", line 62, in get_by_host_and_binary 2017-10-14 17:52:37.840 28114 ERROR oslo_service.periodic_task host, binary) 2017-10-14 17:52:37.840 28114 ERROR oslo_service.periodic_task File "/usr/lib/python2.7/site-packages/magnum/db/sqlalchemy/api.py", line 528, in get_magnum_service_by_host_and_binary 2017-10-14 17:52:37.840 28114 ERROR oslo_service.periodic_task return query.one() 2017-10-14 17:52:37.840 28114 ERROR oslo_service.periodic_task File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2817, in one 2017-10-14 17:52:37.840 28114 ERROR oslo_service.periodic_task "Multiple rows were found for one()")
Guessing:
get_magnum_service_by_host_and_binary
finds that more than one conductor service per host is found in the DB. How this can happen, I don't know, but perhaps you can check if there is more than one conductor process and kill the wrong one, then correct the DB.I added the RDO tag to your question to get the attention of the Packstack team.
There are two instances of the conductors started indeed, and both in "down" state. Why two instances? Stop/restart service, the same case.