[Spce-user] rate-o-mat FATAL error lock wait timeout exceede
rkrenn at sipwise.com
Sat Jul 20 18:55:51 EDT 2019
Contract locking apraoch was not changed actually.
Basically this can happen only if the contracts of a cdr are retrieved via
panel/api while rate-o-mat tries to rate the cdr, and the panel/api request
take longer time.
Do you have scripts that poll subscriber or contract collections? What times
of day did the errors occur?
Eg. the credit warning job script also uses api to retrive data and was
fixed to iterate the full collection, so it has longer processing times and
could be causing this.
Rate-o-mat retries up to 3 times (by default). So an option for now is to
increase the retry count, decrease the rate-o-mat cdr batch size or increase
the mysql lock timeout.
We are currently working on refactoring the fraud and credit warning jobs.
Von: Spce-user [mailto:spce-user-bounces at lists.sipwise.com] Im Auftrag von
Gesendet: Freitag, 19. Juli 2019 23:51
An: spce-user at lists.sipwise.com
Betreff: [Spce-user] rate-o-mat FATAL error lock wait timeout exceede
since update to 6.5.5 few months ago I regonized that rate-o-mat fails every
This is the log entry:
root at spce:~# grep FATAL /var/log/ngcp/rate-o-mat.log
Jul 19 23:12:50 spce (info) rate-o-mat: FATAL: FATAL: Error executing
contract row lock statement: Lock wait timeout exceeded; try restarting
After a rate-o-mat restart everything works fine for few days but then same
Is there a fix for this "new" error?
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Spce-user