Hello David, Yes, query runs ok for both failing queries. [root@aitossbc01 ~]# psql -U devmaster -W -h 10.100.101.11 -p 5235 -d opensips_prod02 -c "select domain,attrs from domain where domain='dev.ait.local'" Password for user devmaster: domain | attrs ---------------+------- dev.ait.local | 0 (1 row)
volga629 From: "David Villasmil" <david.villasmil.w...@gmail.com> To: "OpenSIPS users mailling list" <users@lists.opensips.org> Sent: Thursday, December 27, 2018 5:54:15 PM Subject: Re: [OpenSIPS-Users] postgresql I’d you issue those sql from the proxy, do you get data back? On Thu, 27 Dec 2018 at 21:57, Slava Bendersky < [ mailto:volga...@networklab.ca | volga...@networklab.ca ] > 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 [ mailto:Users@lists.opensips.org | Users@lists.opensips.org ] [ http://lists.opensips.org/cgi-bin/mailman/listinfo/users | http://lists.opensips.org/cgi-bin/mailman/listinfo/users ] _______________________________________________ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users