[OpenSIPS-Users] postgresql

[Slava Bendersky]

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 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20181227/47f8a234/attachment.html>