[OpenSIPS-Users] postgresql

[Bogdan-Andrei Iancu]

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
>> Users at lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
>
> _______________________________________________
> 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/20190104/3770b441/attachment.html>