For the people interested in an follow up, the discussion around the
topic moved to the github tracker:
https://github.com/OpenSIPS/opensips/issues/1579
Regards,
Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
https://www.opensips-solutions.com
OpenSIPS Summit 2019
https://www.opensips.org/events/Summit-2019Amsterdam/
On 01/03/2019 02:22 PM, Bogdan-Andrei Iancu wrote:
Hi Slava,
I guess this report is related to you previous post "presence
cluster​" - and this kind of errors in postgres are responsible for
delaying the timer tasks.
The latest master implements a timeout on the postgres queries :
http://www.opensips.org/html/docs/modules/3.0.x/db_postgres.html#param_timeout
but the default value is 5 seconds. Is your psql server taking more
than 5 secs to run the 'delete' query ??
Regards,
Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
https://www.opensips-solutions.com
OpenSIPS Summit 2019
https://www.opensips.org/events/Summit-2019Amsterdam/
On 12/27/2018 10:54 PM, Slava Bendersky wrote:
Hello Everyone,
Presence and postgresql having some problem to query database on
latest master pull
Any help thank you.
Dec 27 14:38:24 aitossbc01 /usr/sbin/opensips[8864]:
ERROR:db_postgres:db_postgres_submit_query: 0x7f772a429088
PQsendQuery Error: could not receive data from server: Connection
timed out#012 Query: delete from pua where expires<1545943081
Dec 27 14:38:24 aitossbc01 /usr/sbin/opensips[8868]:
ERROR:db_postgres:db_postgres_submit_query: 0x7f772a428f98
PQsendQuery Error: could not receive data from server: Connection
timed out#012 Query: delete from active_watchers where expires<1545943091
Dec 27 14:38:24 aitossbc01 /usr/sbin/opensips[8868]:
ERROR:core:db_do_delete: error while submitting query
Dec 27 14:38:24 aitossbc01 /usr/sbin/opensips[8864]:
ERROR:core:db_do_delete: error while submitting query
Dec 27 14:38:24 aitossbc01 /usr/sbin/opensips[8868]:
ERROR:db_postgres:db_postgres_store_result: 0x7f772a428f98 - invalid
query, execution aborted
Dec 27 14:38:24 aitossbc01 /usr/sbin/opensips[8868]:
ERROR:db_postgres:db_postgres_store_result: 0x7f772a428f98:
PGRES_FATAL_ERROR
Dec 27 14:38:24 aitossbc01 /usr/sbin/opensips[8868]:
ERROR:db_postgres:db_postgres_store_result: 0x7f772a428f98:
Dec 27 14:38:24 aitossbc01 /usr/sbin/opensips[8868]:
WARNING:db_postgres:db_postgres_delete: unexpected result returned
Dec 27 14:38:24 aitossbc01 /usr/sbin/opensips[8868]:
ERROR:presence:update_db_subs: deleting expired information from database
Dec 27 14:38:24 aitossbc01 /usr/sbin/opensips[8864]:
ERROR:db_postgres:db_postgres_store_result: 0x7f772a429088 - invalid
query, execution aborted
Dec 27 14:38:24 aitossbc01 /usr/sbin/opensips[8864]:
ERROR:db_postgres:db_postgres_store_result: 0x7f772a429088:
PGRES_FATAL_ERROR
Dec 27 14:38:24 aitossbc01 /usr/sbin/opensips[8864]:
ERROR:db_postgres:db_postgres_store_result: 0x7f772a429088:
Dec 27 14:38:24 aitossbc01 /usr/sbin/opensips[8864]:
WARNING:db_postgres:db_postgres_delete: unexpected result returned
and domain module
Dec 27 14:38:34 aitossbc01 /usr/sbin/opensips[8867]:
ERROR:core:db_do_query: error while submitting query - [select
domain,attrs from domain where domain='dev.ait.local']
Dec 27 14:38:34 aitossbc01 /usr/sbin/opensips[8867]:
ERROR:domain:is_domain_local_pvar: Error while querying database
volga629
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
