[openstack-dev] [TaskFlow]Create Tables for SQLAlchemy backend issue

Joshua Harlow harlowja at outlook.com
Wed May 6 05:37:06 UTC 2015


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:test@192.168.1.10/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: OpenStack-dev-request at lists.openstack.org?subject:unsubscribe
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev



More information about the OpenStack-dev mailing list