Re: [sqlalchemy] Problem with binary field

2019-01-31 Thread Mike Bayer
Please use mysqlclient or pymysql, don't use mysqlclient connector. Also please define "crash". complete stack trace please ? On Thu, Jan 31, 2019, 4:44 PM Teymur Agayev Hi All, > > After upgrade on my VPS the one of the scripts started periodical crash. > After debugging I found that the

[sqlalchemy] Problem with binary field

2019-01-31 Thread Teymur Agayev
Hi All, After upgrade on my VPS the one of the scripts started periodical crash. After debugging I found that the problem in the filed that stores hashes. for some reason the script started crash on some particular hash values. Below is the test script and attached is the database dump. when ID

[sqlalchemy] Problem with binary field

2019-01-31 Thread Teymur Agayev
Hi All, After upgrade on my VPS the one of the scripts started periodical crash. After debugging I found that the problem in the filed that stores hashes. for some reason the script started crash on some particular hash values. Below is the test script and attached is the database dump. when ID

Re: [sqlalchemy] Re: pandas to MS SQL DataWarehouse (to_sql)

2019-01-31 Thread Mark Pearl
No the error related to this: sqlalchemy ProgrammingError: (pyodbc.ProgrammingError) ('42000', '[42000] [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]111214;An attempt to complete a transaction has failed. No corresponding transaction found. (111214) (SQLEndTran)') (Background on this

Re: [sqlalchemy] Re: pandas to MS SQL DataWarehouse (to_sql)

2019-01-31 Thread Mike Bayer
for "dm_exec_sessions" ? that's an old SQLAlchemy bug that was fixed long ago. see https://github.com/sqlalchemy/sqlalchemy/issues/3994 please upgrade. On Wed, Jan 30, 2019 at 10:52 PM wrote: > > Any solution for this? > > On Monday, September 11, 2017 at 6:34:47 PM UTC-4, dirk.biesinger