Re: [sqlalchemy] Seek for help - Python process stuck at _exec_once_mutex during first_connect in sqlalchemy/event/attr.py

2023-01-30 Thread Ping Zhang
Thanks Mike for your kind response. so to look for deadlocks we would need to see tracebacks for all threads. Please see this link , there are 48 threads, lots of them are

Re: [sqlalchemy] Seek for help - Python process stuck at _exec_once_mutex during first_connect in sqlalchemy/event/attr.py

2023-01-28 Thread Mike Bayer
that particular routine runs exactly once when the engine is used the very first time.I only see one traceback here that does not seem to indicate the lock is being called in a re-entrant fashion, so to look for deadlocks we would need to see tracebacks for all threads. if there is some

[sqlalchemy] Seek for help - Python process stuck at _exec_once_mutex during first_connect in sqlalchemy/event/attr.py

2023-01-27 Thread Ping Zhang
Hi all, Our production system is experiencing a very strange behavior. At peak load, we see some of our python processes were stuck due to: * in* *with self._exec_once_mutex in sqlalchemy/event/attr.py*, (here is the full stack trace