getting sql errors when using postgre with stable 1.10 branch
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'
That is fixed in the latest master See https://github.com/signalwire/freeswitch/commit/3d650f4f694d0f0f51bde285796a... сб, 28 мар. 2020 г. в 14:37, Babak Yakhchali <babak.freeswitch@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@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@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users https://freeswitch.com
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@gmail.com> wrote:
That is fixed in the latest master See https://github.com/signalwire/freeswitch/commit/3d650f4f694d0f0f51bde285796a...
сб, 28 мар. 2020 г. в 14:37, Babak Yakhchali <babak.freeswitch@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@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@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@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@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users https://freeswitch.com
participants (2)
-
Andrey Wolk
-
Babak Yakhchali