Hello,
while using pymssql, sometimes it happens a connection starts behaving
strangely:
every time I try to commit or rollback, a "can't commit" or "can't rollback"
error
is raised and I'm not able to have the correct behaviour again. The
connections operating
from other processes are not affected.
Unfortunately in my case it happens randomly while there is a lot of
cuncurrency and activity
on the DB and it's quite difficult for me to reproduce it.
Do you have any idea about what can I do in order to reset the connection
state and restart
the transaction?
Thanks for your time,
Enrico
|