Comment 3 for bug 1009546

Revision history for this message
Dan Prince (dan-prince) wrote :

My thought is that users should not try to 'db sync' simultaneously. I feel like we could come up with *clever* solutions to this issue but having a bunch of services all trying to update the DB at the same time seems like a really bad idea?

If you want to have a really robust/secure Nova setup you'd actually prevent most of the Nova service nodes from making DDL database requests (CREATE, ALTER, etc.). You'd then run nova-manage db sync with a DB account that has those privs from a separate node. Doing this is arguably better and would avoid the problem described in this ticket altogether.

Perhaps a good *solution* to this issue is that we update the Nova documentation with a recommendation that users (including distro packages) not run 'db sync' simultaneously?