<html><body><div style="font-family: lucida console,sans-serif; font-size: 12pt; color: #000000"><div>Hello Everyone,</div><div>Presence and postgresql having some problem to query database on latest master pull </div><div>Any help thank you.</div><div><br data-mce-bogus="1"></div><div><div>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</div><div>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</div><div>Dec 27 14:38:24 aitossbc01 /usr/sbin/opensips[8868]: ERROR:core:db_do_delete: error while submitting query</div><div>Dec 27 14:38:24 aitossbc01 /usr/sbin/opensips[8864]: ERROR:core:db_do_delete: error while submitting query</div><div>Dec 27 14:38:24 aitossbc01 /usr/sbin/opensips[8868]: ERROR:db_postgres:db_postgres_store_result: 0x7f772a428f98 - invalid query, execution aborted</div><div>Dec 27 14:38:24 aitossbc01 /usr/sbin/opensips[8868]: ERROR:db_postgres:db_postgres_store_result: 0x7f772a428f98: PGRES_FATAL_ERROR</div><div>Dec 27 14:38:24 aitossbc01 /usr/sbin/opensips[8868]: ERROR:db_postgres:db_postgres_store_result: 0x7f772a428f98:</div><div>Dec 27 14:38:24 aitossbc01 /usr/sbin/opensips[8868]: WARNING:db_postgres:db_postgres_delete: unexpected result returned</div><div>Dec 27 14:38:24 aitossbc01 /usr/sbin/opensips[8868]: ERROR:presence:update_db_subs: deleting expired information from database</div><div>Dec 27 14:38:24 aitossbc01 /usr/sbin/opensips[8864]: ERROR:db_postgres:db_postgres_store_result: 0x7f772a429088 - invalid query, execution aborted</div><div>Dec 27 14:38:24 aitossbc01 /usr/sbin/opensips[8864]: ERROR:db_postgres:db_postgres_store_result: 0x7f772a429088: PGRES_FATAL_ERROR</div><div>Dec 27 14:38:24 aitossbc01 /usr/sbin/opensips[8864]: ERROR:db_postgres:db_postgres_store_result: 0x7f772a429088:</div><div>Dec 27 14:38:24 aitossbc01 /usr/sbin/opensips[8864]: WARNING:db_postgres:db_postgres_delete: unexpected result returned</div></div><div><br></div><div><br data-mce-bogus="1"></div><div>and domain module</div><div><br data-mce-bogus="1"></div><div><div>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']</div><div>Dec 27 14:38:34 aitossbc01 /usr/sbin/opensips[8867]: ERROR:domain:is_domain_local_pvar: Error while querying database</div></div><div><br></div><div><br data-mce-bogus="1"></div><div>volga629</div></div></body></html>