We have latency logging enabled but there were no abnormally long delays reported. The
last lines before the crash are like this:
```
Apr 5 10:19:39 sipwise1 proxy[11071]: NOTICE: <core> [db_query.c:60]:
db_do_submit_query(): alert - query execution too long [375 ms] for [select
`received`,`contact`,`socket`
,`cflags`,`pat]
Apr 5 10:19:39 sipwise1 proxy[11072]: NOTICE: <core> [db_query.c:60]:
db_do_submit_query(): alert - query execution too long [312 ms] for [select
`received`,`contact`,`socket`
,`cflags`,`pat]
Apr 5 10:19:39 sipwise1 proxy[11073]: NOTICE: <core> [db_query.c:60]:
db_do_submit_query(): alert - query execution too long [375 ms] for [select
`received`,`contact`,`socket`,`cflags`,`pat]
Apr 5 10:19:39 sipwise1 proxy[11069]: NOTICE: <core> [db_query.c:60]:
db_do_submit_query(): alert - query execution too long [313 ms] for [select
`received`,`contact`,`socket`,`cflags`,`pat]
Apr 5 10:19:39 sipwise1 proxy[11070]: NOTICE: <core> [db_query.c:60]:
db_do_submit_query(): alert - query execution too long [312 ms] for [select
`received`,`contact`,`socket`,`cflags`,`pat]
Apr 5 10:19:40 sipwise1 proxy[11075]: NOTICE: <core> [db_query.c:60]:
db_do_submit_query(): alert - query execution too long [375 ms] for [select
`received`,`contact`,`socket`,`cflags`,`pat]
Apr 5 10:19:40 sipwise1 proxy[11074]: NOTICE: <core> [db_query.c:60]:
db_do_submit_query(): alert - query execution too long [438 ms] for [select
`received`,`contact`,`socket`,`cflags`,`pat]
Apr 5 10:19:40 sipwise1 proxy[11071]: NOTICE: <core> [db_query.c:60]:
db_do_submit_query(): alert - query execution too long [375 ms] for [select
`received`,`contact`,`socket`,`cflags`,`pat]
Apr 5 10:19:40 sipwise1 proxy[11072]: NOTICE: <core> [db_query.c:60]:
db_do_submit_query(): alert - query execution too long [313 ms] for [select
`received`,`contact`,`socket`,`cflags`,`pat]
Apr 5 10:19:40 sipwise1 proxy[11073]: NOTICE: <core> [db_query.c:60]:
db_do_submit_query(): alert - query execution too long [375 ms] for [select
`received`,`contact`,`socket`,`cflags`,`pat]
Apr 5 10:19:41 sipwise1 proxy[11069]: NOTICE: <core> [db_query.c:60]:
db_do_submit_query(): alert - query execution too long [312 ms] for [select
`received`,`contact`,`socket`,`cflags`,`pat]
Apr 5 10:19:41 sipwise1 proxy[11070]: NOTICE: <core> [db_query.c:60]:
db_do_submit_query(): alert - query execution too long [313 ms] for [select
`received`,`contact`,`socket`,`cflags`,`pat]
Apr 5 10:19:41 sipwise1 proxy[11075]: NOTICE: <core> [db_query.c:60]:
db_do_submit_query(): alert - query execution too long [375 ms] for [select
`received`,`contact`,`socket`,`cflags`,`pat]
Apr 5 10:19:42 sipwise1 proxy[11072]: NOTICE: <core> [db_query.c:60]:
db_do_submit_query(): alert - query execution too long [312 ms] for [select
`received`,`contact`,`socket`,`cflags`,`pat]
Apr 5 10:19:42 sipwise1 proxy[11071]: NOTICE: <core> [db_query.c:60]:
db_do_submit_query(): alert - query execution too long [312 ms] for [select
`received`,`contact`,`socket`,`cflags`,`pat]
Apr 5 10:19:42 sipwise1 proxy[11074]: NOTICE: <core> [db_query.c:60]:
db_do_submit_query(): alert - query execution too long [438 ms] for [select
`received`,`contact`,`socket`,`cflags`,`pat]
Apr 5 10:19:42 sipwise1 proxy[11073]: NOTICE: <core> [db_query.c:60]:
db_do_submit_query(): alert - query execution too long [375 ms] for [select
`received`,`contact`,`socket`,`cflags`,`pat]
Apr 5 10:19:42 sipwise1 proxy[11069]: NOTICE: <core> [db_query.c:60]:
db_do_submit_query(): alert - query execution too long [313 ms] for [select
`received`,`contact`,`socket`,`cflags`,`pat]
Apr 5 10:19:42 sipwise1 proxy[11070]: NOTICE: <core> [db_query.c:60]:
db_do_submit_query(): alert - query execution too long [312 ms] for [select
`received`,`contact`,`socket`,`cflags`,`pat]
Apr 5 10:19:43 sipwise1 proxy[11075]: NOTICE: <core> [db_query.c:60]:
db_do_submit_query(): alert - query execution too long [375 ms] for [select
`received`,`contact`,`socket`,`cflags`,`pat]
Apr 5 10:19:43 sipwise1 proxy[11072]: NOTICE: <core> [db_query.c:60]:
db_do_submit_query(): alert - query execution too long [313 ms] for [select
`received`,`contact`,`socket`,`cflags`,`pat]
Apr 5 10:19:43 sipwise1 proxy[11071]: NOTICE: <core> [db_query.c:60]:
db_do_submit_query(): alert - query execution too long [312 ms] for [select
`received`,`contact`,`socket`,`cflags`,`pat]
Apr 5 10:19:43 sipwise1 proxy[11073]: NOTICE: <core> [db_query.c:60]:
db_do_submit_query(): alert - query execution too long [375 ms] for [select
`received`,`contact`,`socket`,`cflags`,`pat]
Apr 5 10:19:43 sipwise1 proxy[11074]: NOTICE: <core> [db_query.c:60]:
db_do_submit_query(): alert - query execution too long [438 ms] for [select
`received`,`contact`,`socket`,`cflags`,`pat]
Apr 5 10:19:44 sipwise1 proxy[11069]: NOTICE: <core> [db_query.c:60]:
db_do_submit_query(): alert - query execution too long [375 ms] for [select
`received`,`contact`,`socket`,`cflags`,`pat]
Apr 5 10:19:44 sipwise1 proxy[11070]: NOTICE: <core> [db_query.c:60]:
db_do_submit_query(): alert - query execution too long [313 ms] for [select
`received`,`contact`,`socket`,`cflags`,`pat]
Apr 5 10:19:44 sipwise1 proxy[11075]: NOTICE: <core> [db_query.c:60]:
db_do_submit_query(): alert - query execution too long [375 ms] for [select
`received`,`contact`,`socket`,`cflags`,`pat]
Apr 5 10:19:44 sipwise1 proxy[11056]: ALERT: <core> [main.c:740]: handle_sigs():
child process 11061 exited by a signal 11
Apr 5 10:19:44 sipwise1 proxy[11056]: ALERT: <core> [main.c:743]: handle_sigs():
core was generated
```
--
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/kamailio/kamailio/issues/1059#issuecomment-292192130