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

Babak Yakhchali babak.freeswitch at gmail.com
Sat Mar 28 10:20:38 UTC 2020


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


More information about the FreeSWITCH-users mailing list