[Freeswitch-users] getting sql errors when using postgre with stable 1.10 branch

[Babak Yakhchali]

thanks Andrey
I applied the changes from that commit to my clone of 1.10 branch to check
if it will solve the problem

On Sat, Mar 28, 2020 at 6:46 PM Andrey Wolk <andywolk at gmail.com> wrote:

> That is fixed in the latest master
> See
> https://github.com/signalwire/freeswitch/commit/3d650f4f694d0f0f51bde285796a7f43059f7119#diff-7c063dd9ef98f3e13d3e601ea0411a95
>
> сб, 28 мар. 2020 г. в 14:37, Babak Yakhchali <babak.freeswitch at gmail.com>:
>
>> Hi
>> I'm using freeswitch
>> version 1.10.2-release+git~20191231T140119Z~f7bdd3845a~64bit on debian 10.
>> after some days logs show errors like this:
>>
>> 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
>> 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]
>> [ERROR:  current transaction is aborted, commands ignored until end of
>> transaction block
>> ]
>> 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]
>>
>> [ERROR:  current transaction is aborted, commands ignored until end of
>> transaction block
>>
>> this errors keep showing like a loop and it keeps giving errors  till I
>> restart postgre and freeswitch
>> is this related to missconfiguration of core dsn? this is the connection
>> string I'm using:
>> pgsql://hostaddr=127.0.0.1 dbname=freeswitch user=freeswitch
>> password='freeswitch' options='-c client_min_messages=NOTICE'
>> application_name='freeswitch'
>> _________________________________________________________________________
>>
>> The FreeSWITCH project is sponsored by SignalWire https://signalwire.com
>> Enhance your FreeSWITCH install with disruptive priced SMS and PSTN
>> services.
>> Build your next product on our scalable cloud platform.
>>
>> Join our online community to chat in real time
>> https://signalwire.community
>>
>> Professional FreeSWITCH Services
>> sales at freeswitch.com
>> https://freeswitch.com
>>
>> Official FreeSWITCH Sites
>> https://freeswitch.com/oss
>> https://freeswitch.org/confluence
>> https://cluecon.com
>>
>> FreeSWITCH-users mailing list
>> FreeSWITCH-users at lists.freeswitch.org
>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>> https://freeswitch.com
>
> _________________________________________________________________________
>
> The FreeSWITCH project is sponsored by SignalWire https://signalwire.com
> Enhance your FreeSWITCH install with disruptive priced SMS and PSTN
> services.
> Build your next product on our scalable cloud platform.
>
> Join our online community to chat in real time
> https://signalwire.community
>
> Professional FreeSWITCH Services
> sales at freeswitch.com
> https://freeswitch.com
>
> Official FreeSWITCH Sites
> https://freeswitch.com/oss
> https://freeswitch.org/confluence
> https://cluecon.com
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> https://freeswitch.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20200329/4ad08913/attachment.html>