<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<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">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">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 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">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>