[OpenSIPS-Users] postgresql

[Bogdan-Andrei Iancu]

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
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20190103/9e2ebed3/attachment.html>