<div dir="ltr">thanks Andrey<div>I applied the changes from that commit to my clone of 1.10 branch to check if it will solve the problem</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Sat, Mar 28, 2020 at 6:46 PM Andrey Wolk <<a href="mailto:andywolk@gmail.com">andywolk@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">That is fixed in the latest master<div>See <a href="https://github.com/signalwire/freeswitch/commit/3d650f4f694d0f0f51bde285796a7f43059f7119#diff-7c063dd9ef98f3e13d3e601ea0411a95" target="_blank">https://github.com/signalwire/freeswitch/commit/3d650f4f694d0f0f51bde285796a7f43059f7119#diff-7c063dd9ef98f3e13d3e601ea0411a95</a></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">сб, 28 мар. 2020 г. в 14:37, Babak Yakhchali <<a href="mailto:babak.freeswitch@gmail.com" target="_blank">babak.freeswitch@gmail.com</a>>:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Hi<div>I'm using freeswitch version 1.10.2-release+git~20191231T140119Z~f7bdd3845a~64bit on debian 10. after some days logs show errors like this:</div><div><br></div><div>2020-03-28 14:23:35.669184 [DEBUG] mod_pgsql.c:747 Query (SELECT queue,uuid,session_uuid,cid_number,cid_name,joined_epoch,(1585389215-joined_epoch)+base_score+skill_score AS score, state, abandoned_epoch, serving_agent, instance_id FROM members WHERE (state = 'Waiting' OR state = 'Abandoned' OR (serving_agent = 'ring-all' AND state = 'Trying') OR (serving_agent = 'ring-progressively' AND state = 'Trying')) AND instance_id = 'single_box' ORDER BY score DESC) returned PGRES_FATAL_ERROR<br>2020-03-28 14:23:35.669184 [ERR] switch_core_sqldb.c:1347 ERR: [SELECT queue,uuid,session_uuid,cid_number,cid_name,joined_epoch,(1585389215-joined_epoch)+base_score+skill_score AS score, state, abandoned_epoch, serving_agent, instance_id FROM members WHERE (state = 'Waiting' OR state = 'Abandoned' OR (serving_agent = 'ring-all' AND state = 'Trying') OR (serving_agent = 'ring-progressively' AND state = 'Trying')) AND instance_id = 'single_box' ORDER BY score DESC]<br>[ERROR:  current transaction is aborted, commands ignored until end of transaction block<br>]<br>2020-03-28 14:23:35.669184 [ERR] switch_core_sqldb.c:1347 ERR: [SELECT queue,uuid,session_uuid,cid_number,cid_name,joined_epoch,(1585389215-joined_epoch)+base_score+skill_score AS score, state, abandoned_epoch, serving_agent, instance_id FROM members WHERE (state = 'Waiting' OR state = 'Abandoned' OR (serving_agent = 'ring-all' AND state = 'Trying') OR (serving_agent = 'ring-progressively' AND state = 'Trying')) AND instance_id = 'single_box' ORDER BY score DESC]</div><div><br>[ERROR:  current transaction is aborted, commands ignored until end of transaction block<br></div><div><br></div><div>this errors keep showing like a loop and it keeps giving errors  till I restart postgre and freeswitch</div><div>is this related to missconfiguration of core dsn? this is the connection string I'm using:</div><div>pgsql://hostaddr=127.0.0.1 dbname=freeswitch user=freeswitch password='freeswitch' options='-c client_min_messages=NOTICE' application_name='freeswitch'<br></div></div>
_________________________________________________________________________<br>
<br>
The FreeSWITCH project is sponsored by SignalWire <a href="https://signalwire.com" rel="noreferrer" target="_blank">https://signalwire.com</a><br>
Enhance your FreeSWITCH install with disruptive priced SMS and PSTN services.<br>
Build your next product on our scalable cloud platform.<br>
<br>
Join our online community to chat in real time <a href="https://signalwire.community" rel="noreferrer" target="_blank">https://signalwire.community</a><br>
<br>
Professional FreeSWITCH Services<br>
<a href="mailto:sales@freeswitch.com" target="_blank">sales@freeswitch.com</a><br>
<a href="https://freeswitch.com" rel="noreferrer" target="_blank">https://freeswitch.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="https://freeswitch.com/oss" rel="noreferrer" target="_blank">https://freeswitch.com/oss</a><br>
<a href="https://freeswitch.org/confluence" rel="noreferrer" target="_blank">https://freeswitch.org/confluence</a><br>
<a href="https://cluecon.com" rel="noreferrer" target="_blank">https://cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" rel="noreferrer" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" rel="noreferrer" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="https://freeswitch.com" rel="noreferrer" target="_blank">https://freeswitch.com</a></blockquote></div>
_________________________________________________________________________<br>
<br>
The FreeSWITCH project is sponsored by SignalWire <a href="https://signalwire.com" rel="noreferrer" target="_blank">https://signalwire.com</a><br>
Enhance your FreeSWITCH install with disruptive priced SMS and PSTN services.<br>
Build your next product on our scalable cloud platform.<br>
<br>
Join our online community to chat in real time <a href="https://signalwire.community" rel="noreferrer" target="_blank">https://signalwire.community</a><br>
<br>
Professional FreeSWITCH Services<br>
<a href="mailto:sales@freeswitch.com" target="_blank">sales@freeswitch.com</a><br>
<a href="https://freeswitch.com" rel="noreferrer" target="_blank">https://freeswitch.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="https://freeswitch.com/oss" rel="noreferrer" target="_blank">https://freeswitch.com/oss</a><br>
<a href="https://freeswitch.org/confluence" rel="noreferrer" target="_blank">https://freeswitch.org/confluence</a><br>
<a href="https://cluecon.com" rel="noreferrer" target="_blank">https://cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" rel="noreferrer" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" rel="noreferrer" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="https://freeswitch.com" rel="noreferrer" target="_blank">https://freeswitch.com</a></blockquote></div>