Re: [sqlalchemy] Deadlocks when reflecting SQL Server metadata

2018-02-26 Thread Sean Harrington
Server Management Studio... On Mon, Feb 26, 2018 at 9:30 PM Mike Bayer wrote: > so do you have another thread or process that is running database > migrations, like create table or alter table, while that happens? > > On Mon, Feb 26, 2018 at 6:16 PM, Sean Harrington > wrote: > &

[sqlalchemy] Deadlocks when reflecting SQL Server metadata

2018-02-26 Thread Sean Harrington
We're getting the following deadlock error on SQL Server: [FreeTDS][SQL Server]Transaction (Process ID 65) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. (1205) (SQLExecDirectW)') [SQL: 'SELECT [ INFORMATION_SCHEMA].[TABL

[sqlalchemy] Percona Server

2015-10-28 Thread Sean Harrington
Has anybody tried to use SQLAlchemy on Percona Server? Percona Server is a "drop-in replacement" for MySQL with InnoDB optimizations -- however it contains additional INFORMATION_SCHEMA tables, and performance tables...Want to make sure that SQLAlchemy will still sit atop Percona the same way t