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

jeffty wantwatering at gmail.com
Wed May 6 05:14:39 UTC 2015


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.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-dev/attachments/20150506/03787a57/attachment.html>


More information about the OpenStack-dev mailing list