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

Reply via email to