Re: [openstack-dev] [watcher] some database migration file skipped

2017-07-07 Thread Hidekazu Nakamura 
Hi Yumeng Bao,

By simply executing watcher-db-manage after creating database,
All migration scripts are executed.

Now I can try cron type audit interval.

Thanks,
Hidekazu Nakamura


> -Original Message-
> From: yumeng bao [mailto:yumeng_...@yahoo.com]
> Sent: Friday, July 07, 2017 11:39 AM
> To: openstack-dev@lists.openstack.org
> Subject: Re: [openstack-dev] [watcher] some database migration file skipped
> 
> Hi Hidekazu,
> 
> 
> 
> The revision id 0f6042416884 has been recorded in your database, so when
> you sync the database base on your old database, it will only execute the
> scripts after this id.
> If you want to execute all the scripts, you can create a new database for
> the test.
> please reference:
> http://alembic.zzzcomputing.com/en/latest/tutorial.html#running-our-se
> cond-migration
> 
> Regards,
> Yumeng Bao
> 
> 

__
OpenStack Development Mailing List (not for usage questions)
Unsubscribe: openstack-dev-requ...@lists.openstack.org?subject:unsubscribe
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev

Re: [openstack-dev] [watcher] some database migration file skipped

2017-07-06 Thread yumeng bao 
Hi Hidekazu,


The revision id 0f6042416884 has been recorded in your database, so when you 
sync the database base on your old database, it will only execute the scripts 
after this id.If you want to execute all the scripts, you can create a new 
database for the test.please reference: 
http://alembic.zzzcomputing.com/en/latest/tutorial.html#running-our-second-migration
Regards,Yumeng Bao


   __
OpenStack Development Mailing List (not for usage questions)
Unsubscribe: openstack-dev-requ...@lists.openstack.org?subject:unsubscribe
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev

[openstack-dev] [watcher] some database migration file skipped

2017-07-06 Thread Hidekazu Nakamura 
Hi Watcher folks,

I am creating database schema for testing, but facing problem.
Source code is checked out from
https://review.openstack.org/#/c/471379/

After creating Watcher database and grant access right, 
I executed the following:

$ watcher-db-manage --config-file /etc/watcher/watcher.conf create_schema

I expected this to execute the following sequentially.
001_ocata.py
0f6042416884_add_apscheduler_jobs.py
d098df6021e2_cron_support_for_audit.py

But 0f6042416884_add_apscheduler_jobs.py was skipped. Could you help?

Regards,
Hidekazu Nakamura


__
OpenStack Development Mailing List (not for usage questions)
Unsubscribe: openstack-dev-requ...@lists.openstack.org?subject:unsubscribe
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev