Ask Your Question
0

packstack Magnum: Error during MagnumServicePeriodicTasks.update_magnum_service: MultipleResultsFound: Multiple rows were found for one()

asked 2017-10-14 12:58:05 -0600

Planck-C gravatar image

updated 2017-10-15 14:56:58 -0600

Bernd Bausch gravatar image

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()")

edit retag flag offensive close merge delete

Comments

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.

Bernd Bausch gravatar imageBernd Bausch ( 2017-10-15 14:54:38 -0600 )edit

I added the RDO tag to your question to get the attention of the Packstack team.

Bernd Bausch gravatar imageBernd Bausch ( 2017-10-15 14:56:07 -0600 )edit

There are two instances of the conductors started indeed, and both in "down" state. Why two instances? Stop/restart service, the same case.

Planck-C gravatar imagePlanck-C ( 2017-10-16 20:08:08 -0600 )edit

1 answer

Sort by ยป oldest newest most voted
0

answered 2017-10-16 23:01:13 -0600

Planck-C gravatar image

Maybe something went wrong in the initial installation. Dropping Magnum and Heat databases, and reinstalling packstack (using same answer file) seem to solve the problem. Now only one "Up" magnum-conductor.

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Get to know Ask OpenStack

Resources for moderators

Question Tools

1 follower

Stats

Asked: 2017-10-14 12:58:05 -0600

Seen: 51 times

Last updated: Oct 16