Open Stack

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:test@192.168.1.10/test
<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
<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 <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',
>
>     '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/20150508/3983742f/attachment.html>