I’d you issue those sql from the proxy, do you get data back? On Thu, 27 Dec 2018 at 21:57, Slava Bendersky <[email protected]> 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 > [email protected] > http://lists.opensips.org/cgi-bin/mailman/listinfo/users >
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
