Agents not able to login - [ERR] attempt to concatenate global 'agent_uuid'

Status
Not open for further replies.

DownUnder

New Member
Jan 29, 2018
24
0
1
43
Yesterday I had an issue where I was seeing "database disk image is malformed" in the fs_cli

The recommended solution was to stop FreeSWITCH, remove the DB files from /var/lib/freeswitch/db and start FreeSWITCH again to regenerate the files.

This seemed to work ok, phones registered and were able to make calls. Later in the morning we had reports of Call Centers not working, the logs show the following error:

2019-03-13 07:47:53.067556 [NOTICE] switch_cpp.cpp:1365 [user status] SQL: SELECT * FROM v_call_center_agents WHERE domain_uuid = :domain_uuid AND agent_id = :agent_id ; params:{"domain_uuid":"e1d638ac-0c93-49f5-a301-d013dc633969","agent_id":"950"}
2019-03-13 07:47:53.087560 [NOTICE] switch_cpp.cpp:1365 [user status][login] agent id: 950 authorized: true

2019-03-13 07:47:53.087560 [ERR] mod_lua.cpp:203 /usr/share/freeswitch/scripts/app/agent_status/index.lua:112: attempt to concatenate global 'agent_uuid' (a nil value)
stack traceback:
/usr/share/freeswitch/scripts/app/agent_status/index.lua:112: in main chunk
/usr/share/freeswitch/scripts/app.lua:48: in main chunk

2019-03-13 07:47:53.087560 [DEBUG] freeswitch_lua.cpp:382 DBH handle 0x7f2b4c00b750 released.
2019-03-13 07:47:53.087560 [DEBUG] switch_cpp.cpp:1112 sofia/internal/950@######.com:5060 destroy/unlink session from object

2019-03-13 07:47:53.087560 [NOTICE] switch_core_state_machine.c:385 sofia/internal/950@######.com:5060 has executed the last dialplan instruction, hanging up.
2019-03-13 07:47:53.087560 [NOTICE] switch_core_state_machine.c:387 Hangup sofia/internal/950@######.com:5060 [CS_EXECUTE] [NORMAL_CLEARING]


I can see that callcenter.db has been recreated.

Does anyone have any suggestions for a fix?

Version 4.4.0
Git Information Branch: 4.4
Commit: 45e98b85cd51163a384c690597fb702c7db46849
Origin: https://github.com/fusionpbx/fusionpbx
Status: Your branch is up-to-date with 'origin/4.4'. +292 days ago
Project Path /var/www/fusionpbx
Switch Version 1.6.20 (64bit)
Operating System Information
Operating System Debian
Version 8.11
Kernel Linux sip 3.16.0-4-amd64 #1 SMP Debian 3.16.51-3 (2017-12-13) x86_64 GNU/Linux
 

DownUnder

New Member
Jan 29, 2018
24
0
1
43
Hi Adrian,

It looks ok, each entry seems to have a valid UUID.

From the FusionPBX DB:

"1fa2d48d-ecd2-495a-8fd3-8965dd67e7fe";"e1d638ac-0c93-49f5-a301-d013dc633969";"A814";"callback";60;"814";"";"user/814@###.com";"Available";"";0;1;90;90;"30";""
"2c46478b-52ac-4756-9750-52ffc1f4ed88";"e1d638ac-0c93-49f5-a301-d013dc633969";"A823";"callback";60;"823";"";"user/823@###.com";"Available";"";0;1;90;90;"30";""
"43f9d440-e5b0-453b-9295-293eb4979dd8";"e1d638ac-0c93-49f5-a301-d013dc633969";"A836";"callback";60;"836";"836";"user/836@###.com";"Available";"";0;1;90;90;"30";""
"4b0042b1-59ee-43a8-889b-22012e069477";"e1d638ac-0c93-49f5-a301-d013dc633969";"A888";"callback";60;"888";"";"user/888@###.com";"Available";"";0;1;90;90;"30";""
"6649b209-bb93-4b6f-a306-bbf601011eb3";"e1d638ac-0c93-49f5-a301-d013dc633969";"A800";"callback";60;"800";"";"user/800@###.com";"Available";"";0;1;90;90;"30";""
"81234841-36cf-495d-8fe3-bd9399e63cda";"e1d638ac-0c93-49f5-a301-d013dc633969";"A802";"callback";60;"802";"";"user/802@###.com";"Available";"";0;1;90;90;"30";""
"82486710-017a-4c22-88b3-0f0d14362190";"e1d638ac-0c93-49f5-a301-d013dc633969";"A822";"callback";60;"822";"";"user/822@###.com";"Available";"";0;1;90;90;"30";""
"aed56b0b-3133-44e1-b83b-18a200baa161";"e1d638ac-0c93-49f5-a301-d013dc633969";"A815";"callback";60;"815";"";"user/815@###.com";"Available";"";0;1;90;90;"30";""
"cf7aec08-92c7-49ed-8ad3-83fd93a6dc68";"e1d638ac-0c93-49f5-a301-d013dc633969";"A824";"callback";60;"824";"";"user/824@###.com";"Available";"";0;1;90;90;"30";""

From the FreeSWITCH DB

aed56b0b-3133-44e1-b83b-18a200baa161|single_box||callback|{call_timeout=60}user/815@###.com|Available|Waiting|0|1|90|90|30|1552287236|1552287257|1552287234|1552255281|0|40|3386|1552012424
cf7aec08-92c7-49ed-8ad3-83fd93a6dc68|single_box||callback|{call_timeout=60}user/824@###.com|Available|Waiting|0|1|90|90|30|1540525111|1540525121|1552287187|1543779851|0|0|0|1552287277
1fa2d48d-ecd2-495a-8fd3-8965dd67e7fe|single_box||callback|{call_timeout=60}user/814@###.com|Available|Waiting|0|1|90|90|30|1552285868|1552285930|1552287116|1552336249|0|0|0|1552287218
4b0042b1-59ee-43a8-889b-22012e069477|single_box||callback|{call_timeout=60}user/888@###.com|Available|Waiting|0|1|90|90|30|1552026137|1552026218|1552271177|1552336249|0|0|0|1551928387
43f9d440-e5b0-453b-9295-293eb4979dd8|single_box||callback|{call_timeout=60}user/836@###.com|Available|Waiting|0|1|90|90|30|1551327350|1551327382|1551327572|1552336249|0|0|0|1551326260
2c46478b-52ac-4756-9750-52ffc1f4ed88|single_box||callback|{call_timeout=60}user/823@###.com|Available|Waiting|0|1|90|90|30|1542950393|1542950456|1542951789|1543289453|0|0|0|1542951879
82486710-017a-4c22-88b3-0f0d14362190|single_box||callback|{call_timeout=60}user/822@###.com|Available|Waiting|0|1|90|90|30|0|0|1551229363|1552336249|0|0|0|1549923732
81234841-36cf-495d-8fe3-bd9399e63cda|single_box||callback|{call_timeout=60}user/802@###.com|Available|Waiting|0|1|90|90|30|1552284105|1552284131|1552285668|1552336249|0|0|0|1552025236
6649b209-bb93-4b6f-a306-bbf601011eb3|single_box||callback|{call_timeout=60}user/800@###.com|Available|Waiting|0|1|90|90|30|1551227570|1551227802|1551227563|1552336249|0|0|0|1546497125
 
Status
Not open for further replies.