Yep, it looks like that was indeed the problem, it was trying to acquire a
lock but it wasn't granted,
presumably because of the other idle transactions listed. Closing the
session in tearDown and
creating a new one in setUp fixed the problem. Thank you!
--
You received this message because
On 06/13/2016 01:15 PM, Drachenfels wrote:
Hi guys,
I found very strange behaviour of my script, after a lot of debugging it
appears that SQLAlchemy complains about joins that I cannot see exactly
why it has any issue with.
Full running example is below in both as inline main.py script and
Hi guys,
I found very strange behaviour of my script, after a lot of debugging it
appears that SQLAlchemy complains about joins that I cannot see exactly why
it has any issue with.
Full running example is below in both as inline main.py script and link.
In the nutshell, hierarchy of objects
When this hangs, open up a terminal window for postgres and list all the
queries/connections. Hangs like this often happen because of locking.
It's not technically a deadlock, so it doesn't get reported as one -- but
dropping a table that another connection used/is-using will just stall