[Openstack] debugging a db migration script

Adam Young ayoung at redhat.com
Tue Jul 17 17:47:47 UTC 2012


On 07/17/2012 11:42 AM, Jim Fehlig wrote:
> Hengqing Hu wrote:
>> There is a test in nova:
>>
>> You can run run_tests.sh in your nova root like this:
>> ./run_tests.sh -v test_migrations
> Thanks for the tip!

To set a breakpoint, you can either run

python -m pdb run_tests.py  ....

or modify your code and put in :
import pdb; pdb.set_trace()

>
>> If there is something wrong in the migration script,
>> it will show up in the console.
> Indeed.  And easy to fix problems once you know the errors :).
>
> Regards,
> Jim
>
>> On 07/17/2012 11:59 AM, Jim Fehlig wrote:
>>> I'm working on a patch that adds a column to the compute_nodes table in
>>> the nova db, but it seems my db migration script fails when calling 'db
>>> sync' in stack.sh.  I tried running the command manually, same failure:
>>>
>>> stack at virt71:~> /opt/stack/nova/bin/nova-manage --debug -v db
>>> sync2012-07-16 21:42:52 DEBUG nova.utils [-] backend <module
>>> 'nova.db.sqlalchemy.migration' from
>>> '/opt/stack/nova/nova/db/sqlalchemy/migration.pyc'> from (pid=19230)
>>> __get_backend /opt/stack/nova/nova/utils.py:484
>>> /usr/lib64/python2.6/site-packages/sqlalchemy/pool.py:681:
>>> SADeprecationWarning: The 'listeners' argument to Pool (and
>>> create_engine()) is deprecated.  Use event.listen().
>>>     Pool.__init__(self, creator, **kw)
>>> /usr/lib64/python2.6/site-packages/sqlalchemy/pool.py:159:
>>> SADeprecationWarning: Pool.add_listener is deprecated.  Use
>>> event.listen()
>>>     self.add_listener(l)
>>> Command failed, please check log for more info
>>>
>>> I can't find anything useful in any log (/var/log/*, /opt/stack/log/*).
>>> I ran the above in strace and saw my migration script was opened and
>>> then shortly thereafter writing of "Command failed, please check log for
>>> more info" and exit(1) :).
>>>
>>> The patch also adds a 'hypervisor_type' column to the instances table,
>>> and that migration script succeeds!
>>>
>>> Any hints for debugging a db migration script?
>>>
>>> Thanks,
>>> Jim
>>>
>>>
>>> _______________________________________________
>>> Mailing list: https://launchpad.net/~openstack
>>> Post to     : openstack at lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~openstack
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>>
> _______________________________________________
> Mailing list: https://launchpad.net/~openstack
> Post to     : openstack at lists.launchpad.net
> Unsubscribe : https://launchpad.net/~openstack
> More help   : https://help.launchpad.net/ListHelp






More information about the Openstack mailing list