<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<tt>For the people interested in an follow up, the discussion around
the topic moved to the github tracker:<br>
<a class="moz-txt-link-freetext" href="https://github.com/OpenSIPS/opensips/issues/1579">https://github.com/OpenSIPS/opensips/issues/1579</a><br>
<br>
Regards,<br>
</tt>
<pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="moz-txt-link-freetext" href="https://www.opensips-solutions.com">https://www.opensips-solutions.com</a>
OpenSIPS Summit 2019
<a class="moz-txt-link-freetext" href="https://www.opensips.org/events/Summit-2019Amsterdam/">https://www.opensips.org/events/Summit-2019Amsterdam/</a>
</pre>
<div class="moz-cite-prefix">On 01/03/2019 02:22 PM, Bogdan-Andrei
Iancu wrote:<br>
</div>
<blockquote type="cite"
cite="mid:21b15458-4c96-9f0f-436f-cb24773e2cde@opensips.org">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<tt>Hi Slava,<br>
<br>
I guess this report is related to you previous post "presence
cluster" - and this kind of errors in postgres are responsible
for delaying the timer tasks.<br>
<br>
The latest master implements a timeout on the postgres queries :<br>
<a class="moz-txt-link-freetext"
href="http://www.opensips.org/html/docs/modules/3.0.x/db_postgres.html#param_timeout"
moz-do-not-send="true">http://www.opensips.org/html/docs/modules/3.0.x/db_postgres.html#param_timeout</a><br>
but the default value is 5 seconds. Is your psql server taking
more than 5 secs to run the 'delete' query ??<br>
<br>
Regards,<br>
</tt>
<pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="moz-txt-link-freetext" href="https://www.opensips-solutions.com" moz-do-not-send="true">https://www.opensips-solutions.com</a>
OpenSIPS Summit 2019
<a class="moz-txt-link-freetext" href="https://www.opensips.org/events/Summit-2019Amsterdam/" moz-do-not-send="true">https://www.opensips.org/events/Summit-2019Amsterdam/</a>
</pre>
<div class="moz-cite-prefix">On 12/27/2018 10:54 PM, Slava
Bendersky wrote:<br>
</div>
<blockquote type="cite"
cite="mid:1034273120.76016.1545944069287.JavaMail.zimbra@skillsearch.ca">
<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>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org" moz-do-not-send="true">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" moz-do-not-send="true">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</body>
</html>