Re: [sqlalchemy] database operation fails after succsefull multi-processing.

2022-08-23 Thread Geert Jan Talens
lib64/libc.so.6 (0x7f37c43ed000) > libz.so.1 => /lib64/libz.so.1 (0x7f37c43d3000) > libssl.so.1.1 => /lib64/libssl.so.1.1 (0x7f37c4336000) > libcrypto.so.1.1 => /lib64/libcrypto.so.1.1 (0x7f37c4048000) > /lib64/ld-linux-x86-64.so.2 (0x7f37c467f

Re: [sqlalchemy] database operation fails after succsefull multi-processing.

2022-08-23 Thread Geert Jan Talens
in a container.What server version ? > > On Tue, Aug 23, 2022, at 11:22 AM, Geert Jan Talens wrote: > > Hello Mike, > > Thank you for your reply. The traceback of the issue is below. I'm using > sqlalchemy 1.4.40 and MySQLdb 2.1.1, the problem does not occur when u

Re: [sqlalchemy] database operation fails after succsefull multi-processing.

2022-08-23 Thread Geert Jan Talens
NFO sqlalchemy.engine.Engine ROLLBACK > 2022-08-22 19:16:02,382 INFO sqlalchemy.engine.Engine BEGIN (implicit) > 2022-08-22 19:16:02,382 INFO sqlalchemy.engine.Engine INSERT INTO mytable > (id) VALUES (%s) > 2022-08-22 19:16:02,382 INFO sqlalchemy.engine.Engine [cached since > 0.

[sqlalchemy] database operation fails after succsefull multi-processing.

2022-08-22 Thread Geert Jan Talens
Hi, I am trying to perform some database actions after multiprocessing some database manipulations but in most cases I get: sqlalchemy.exc.OperationalError: (MySQLdb._exceptions.OperationalError) (2006, 'MySQL server has gone away') The code below is a working example of the problem I'm having