Guys,
I keep seeing:
sqlalchemy.exc.InternalError: (InternalError) (1205, u'Lock wait timeout
exceeded
in code where there should not be any contention for the records or
indexes......I'm pretty experienced on the MySQL side and this even should
be incredibly rare but it's happening with some frequency.... this system
has very low concurrency and these are not exceptionally long
transactions......less than 20 seconds
It sometimes occurs when the script is called manually via the command
line, and sometimes occurs when the script is called by the Celery/RabbitMQ
Beat scheduler.
I feel certain I must be using SA in some way that's causing this but I'm
not sure how.....
All tips appreciated.....Partial stack trace below
Thx
Dewey
File "/opt/paysys/python/lib/python2.7/site-packages/pymysql/err.py", line
116, in raise_mysql_exception
_check_mysql_exception(errinfo)
File "/opt/paysys/python/lib/python2.7/site-packages/pymysql/err.py",
line 112, in _check_mysql_exception
raise InternalError(errno, errorvalue)
sqlalchemy.exc.InternalError: (InternalError) (1205, u'Lock wait timeout
exceeded; try restarting transaction')
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
