<html><body><div style="font-family: lucida console,sans-serif; font-size: 12pt; color: #000000"><div>Hello David,</div><div>Yes, query runs ok for both failing queries.</div><div><br data-mce-bogus="1"></div><div><div>[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'"</div><div>Password for user devmaster:</div><div> domain | attrs</div><div>---------------+-------</div><div> dev.ait.local | 0</div><div>(1 row)</div></div><div><br data-mce-bogus="1"></div><div><strong>volga629</strong></div><div><br></div><hr id="zwchr" data-marker="__DIVIDER__"><div data-marker="__HEADERS__"><b>From: </b>"David Villasmil" <david.villasmil.work@gmail.com><br><b>To: </b>"OpenSIPS users mailling list" <users@lists.opensips.org><br><b>Sent: </b>Thursday, December 27, 2018 5:54:15 PM<br><b>Subject: </b>Re: [OpenSIPS-Users] postgresql<br></div><div><br></div><div data-marker="__QUOTED_TEXT__">I’d you issue those sql from the proxy, do you get data back?<br><div class="gmail_quote"><div dir="ltr">On Thu, 27 Dec 2018 at 21:57, Slava Bendersky <<a href="mailto:volga629@networklab.ca" target="_blank">volga629@networklab.ca</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><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><br><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><br><br><div>and domain module</div><br><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><br><br><div>volga629</div></div></div>_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
</blockquote></div>
<br>_______________________________________________<br>Users mailing list<br>Users@lists.opensips.org<br>http://lists.opensips.org/cgi-bin/mailman/listinfo/users<br></div></div></body></html>