Hi Jonathan,
I don't use any special connection parameters. All are defaults.
I I execute
>> engine.execute('set autocommit=1;')
>> foo = engine.execute('select * from Foo;')
...then on other console CREATE TABLE IF NOT EXISTS Foo(i int) don't block.
So it seems it's an application bug. Autocommit should be True for
ScopedSession when running in worker's context.
On Thursday, August 29, 2013 7:17:51 PM UTC+2, Jonathan Vanasco wrote:
>
> MyISAM doesn't support transactions, but it does support locking.
> According to the docs, it actually relies on table locking for certain
> operations.
>
> What are your sqlalchemy connection strings for the engine ?
> Have you tried explicitly setting autocommit mode within the query ?
> Have you tried verbose logging of SqlAlchemy and/pr MySql to see what
> commands are being sent to the server in which order to cause this ?
>
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/groups/opt_out.
