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
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