Thanks Josh. I run that and it works. Tables were created successfully. Also if I create table, foreign keys and index that also work. Except for table alembic_version. Seems taskflow works well without this table.
It's wired that my gmail didn't receive ur response and I have to go to the mailing list archive page to find my post and reply. Thanks again for your kindly help. [openstack-dev] [TaskFlow]Create Tables for SQLAlchemy backend issue*Joshua Harlow* harlowja at outlook.com <openstack-dev%40lists.openstack.org?Subject=Re%3A%20%5Bopenstack-dev%5D%20%5BTaskFlow%5DCreate%20Tables%20for%20SQLAlchemy%20backend%0A%20issue&In-Reply-To=%3CBLU436-SMTP277D1317D7BA26D2DD960DD8D00%40phx.gbl%3E> *Wed May 6 05:37:06 UTC 2015* - Previous message: [openstack-dev] [TaskFlow]Create Tables for SQLAlchemy backend issue <http://lists.openstack.org/pipermail/openstack-dev/2015-May/063375.html> - Next message: [openstack-dev] [Fuel] Swagger documentation <http://lists.openstack.org/pipermail/openstack-dev/2015-May/063378.html> - *Messages sorted by:* [ date ] <http://lists.openstack.org/pipermail/openstack-dev/2015-May/date.html#63377> [ thread ] <http://lists.openstack.org/pipermail/openstack-dev/2015-May/thread.html#63377> [ subject ] <http://lists.openstack.org/pipermail/openstack-dev/2015-May/subject.html#63377> [ author ] <http://lists.openstack.org/pipermail/openstack-dev/2015-May/author.html#63377> ------------------------------ Good question! U have to call into the following: http://docs.openstack.org/developer/taskflow/persistence.html#taskflow.persistence.base.Connection.upgrade This is getting renamed (hopefully to a more obvious name) in the following review: https://review.openstack.org/#/c/180351/ (others got confused by this one also). https://blueprints.launchpad.net/taskflow/+spec/storage-initialize-instead-of-upgrade Hope that helps, -Josh jeffty wrote: >* Hi there, *>>* I’m trying to use mysql to store lobbooks and atom etc. *>>* Here is the code: *>>* backend = backends.fetch({ *>>* 'connection': 'mysql://test:[email protected]/test <mysql://test:[email protected]/test>', *>>* 'user': test, *>>* 'password': test, *>>* }) *>>* book, flow_detail = pu.temporary_flow_detail(backend=backend) *>>* And I got below errors: *>>* taskflow.exceptions.StorageFailure: Failed saving logbook *>* 'e34f21c0-72cf-48be-ad96-766befa55ab3' *>>* ProgrammingError: (ProgrammingError) (1146, "Table 'flow.logbooks' *>* doesn't exist") 'SELECT logbooks.created_at, logbooks.updated_at, *>* logbooks.meta, logbooks.name <http://logbooks.name>, logbooks.uuid \nFROM logbooks \nWHERE *>* logbooks.uuid = %s' ('e34f21c0-72cf-48be-ad96-766befa55ab3',) *>>* After checked *>* http://docs.openstack.org/developer/taskflow/persistence.html <http://docs.openstack.org/developer/taskflow/persistence.html> , there *>* are 3 tables to be created. *>>* So we need to create these tables manually right? Or is there any API *>* for the tables initiation? *>>* Thanks. *>>* __________________________________________________________________________ *>* OpenStack Development Mailing List (not for usage questions) *>* Unsubscribe: OpenStack-dev-request at lists.openstack.org <http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev>?subject:unsubscribe *>* http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev <http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev>* 2015-05-06 13:14 GMT+08:00 jeffty <[email protected]>: > Hi there, > > > > I’m trying to use mysql to store lobbooks and atom etc. > > > > Here is the code: > > > > backend = backends.fetch({ > > 'connection': 'mysql://test:[email protected]/test', > > 'user': test, > > 'password': test, > > }) > > > > book, flow_detail = pu.temporary_flow_detail(backend=backend) > > > > And I got below errors: > > > > taskflow.exceptions.StorageFailure: Failed saving logbook > 'e34f21c0-72cf-48be-ad96-766befa55ab3' > > ProgrammingError: (ProgrammingError) (1146, "Table 'flow.logbooks' > doesn't exist") 'SELECT logbooks.created_at, logbooks.updated_at, > logbooks.meta, logbooks.name, logbooks.uuid \nFROM logbooks \nWHERE > logbooks.uuid = %s' ('e34f21c0-72cf-48be-ad96-766befa55ab3',) > > > > After checked > http://docs.openstack.org/developer/taskflow/persistence.html , there are > 3 tables to be created. > > > > So we need to create these tables manually right? Or is there any API for > the tables initiation? > > > > Thanks. >
__________________________________________________________________________ OpenStack Development Mailing List (not for usage questions) Unsubscribe: [email protected]?subject:unsubscribe http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
