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'