"failure obtaining db row lock :lock wait timeout exceeded try restarting transaction" problem

quartz-scheduler / quartz

Code for Quartz Scheduler

http://www.quartz-scheduler.org

Apache License 2.0

6.27k stars 1.93k forks source link

"failure obtaining db row lock :lock wait timeout exceeded try restarting transaction" problem #188

Closed darouwan closed 5 years ago

darouwan commented 7 years ago

I meet " failure obtaining db row lock :lock wait timeout exceeded try restarting transaction problem " error message when some jobs will be triggered. It seems a thread doesn't release the row lock and block the following job triggers.

How to avoid this problem ? and when it occurs, how to solve it?

google group ref:https://groups.google.com/forum/#!category-topic/quartz-scheduler/triggers--scheduling-questions/9A32WVWymq0　

zemian commented 5 years ago

Closing outdated, unresolved issues. Please, reopen if still relevant.

zemian commented 5 years ago

See related #268