[Bug 35734] New: Message queue table lock will crash Koha
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35734 Bug ID: 35734 Summary: Message queue table lock will crash Koha Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Circulation Assignee: koha-bugs@lists.koha-community.org Reporter: johanna.raisa@koha-suomi.fi QA Contact: testopia@bugs.koha-community.org CC: gmcharlt@gmail.com, kyle.m.hall@gmail.com Locking the message_queue table on circulation and reserves will crash Koha, if there are many circulation or/and reservation operations on running and the process_message_queue cron is processing messages. Locking a table is not a very good way to handle digest messages and active queue, this should be handled with a new message status instead. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35734 --- Comment #1 from Johanna Räisä <johanna.raisa@koha-suomi.fi> --- I investigated this problem further, seems that the issue appears when there are lot of rows in the message_queue table. One of our biggest Koha had last year 1892573 message rows and it takes a while finding messages with pending status. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
participants (1)
-
bugzilla-daemon@bugs.koha-community.org