Re: [sqlalchemy] MX Linux Python3 sqlalchemy hangs on ROLLBACK

2021-05-12 Thread Rob Marshall
> On Tue, May 11, 2021, at 12:41 PM, Rob Marshall wrote: > > Hi Mike, > > Apparently it was the driver. I changed the create_engine to: > > engine = create_engine('mysql://user:pass...@127.0.0.1/options > <http://user:password@127.0.0.1/options>') >

Re: [sqlalchemy] MX Linux Python3 sqlalchemy hangs on ROLLBACK

2021-05-11 Thread Rob Marshall
8.0/en/information-schema-processlist-table.html > > > > On Tue, May 11, 2021, at 10:29 AM, Rob Marshall wrote: > > Hi, > > I'm updating a MySQL (MariaDB) database using Pandas and sqlalchemy. I am > seeing it hang on a ROLLBACK but I'm not sure how to determine w

[sqlalchemy] MX Linux Python3 sqlalchemy hangs on ROLLBACK

2021-05-11 Thread Rob Marshall
Hi, I'm updating a MySQL (MariaDB) database using Pandas and sqlalchemy. I am seeing it hang on a ROLLBACK but I'm not sure how to determine what is causing the ROLLBACK. Below is a session with DEBUG enabled. Any help would be appreciated. The engine is created with: engine = create_engine