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

[Andrey Wolk]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20200328/2486e6db/attachment.html>