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:[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 , 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 <[email protected]
<mailto:[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
<http://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 ,
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
