Open Stack

No problem,

Probably more DKIM/SPF... issues (oh well, I give up on resolving that 
stuff anymore...) causing emails to go in weird places (aka your spam 
folder)...

Feel free to jump on IRC to:

irc://chat.freenode.net/openstack-state-management

-Josh

jeffty wrote:
>
>   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
> <mailto: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: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  <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  , 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/
>
>
> 2015-05-06 13:14 GMT+08:00 jeffty <wantwatering at gmail.com
> <mailto:wantwatering at gmail.com>>:
>
>     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
>     <http://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
>     <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 ,
>     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.____
>
>