How to work with peewee from multiple threads?

Question

MySQL

Good day.
There is a multi-threaded application using peewee from several threads. Some time after launch, the following exception is thrown:

peewee.OperationalError: (2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")

In reality, this of course falls off PyMySQL, which uses the peewee core. Based on experience, threading.Lock helped to work with PyMySQL:

from threading import Lock
database_locker = Lock()

database_locker.acquire(blocking=True)
pass #работа с БД
database_locker.release()

That's just in the case of peewee for some reason it does not work.
What do you think? Should threading.Lock help, and are there other approaches to solving the problem?
Python 3.4
PyMySQL 0.7.4
peewee 2.8.2

Answer 1

If anyone is interested, you can pass an argument to database.__init__ threadlocals=True, which seems to fix everything. As I said, the error does not appear immediately, so you have to wait a bit before you say for sure :)