ERROR [ERR] switch_core_sqldb help me!!!

[kp123]

Today , my fusionpbx server on AWS is well working. But suddenly error , status Registrations (0) on web is empty.
( freeswitch running coredb on ram via : /etc/fstab : tmpfs /var/lib/freeswitch/db tmpfs defaults,size=6g 0 0)


2019-08-28 02:35:51.164378 [ERR] switch_core_sqldb.c:1197 SQL ERR: [select call_id,sip_user,sip_host,contact,status,rpid,expires,user_agent,server_user,server_host,profile_name,hostname,network_ip,network_port,sip_username,sip_realm,mwi_user,mwi_host,ping_status,ping_time from sip_registrations where profile_name='internal'] file is encrypted or is not a database
2019-08-28 02:35:51.174369 [ERR] switch_core_sqldb.c:1197 SQL ERR: [select call_id,sip_user,sip_host,contact,status,rpid,expires,user_agent,server_user,server_host,profile_name,hostname,network_ip,network_port,sip_username,sip_realm,mwi_user,mwi_host,ping_status,ping_time from sip_registrations where profile_name='internal'] file is encrypted or is not a database
2019-08-28 02:35:51.174369 [ERR] switch_core_sqldb.c:1197 SQL ERR: [select nonce,last_nc from sip_authentication where nonce='d8175c1c-fe73-4876-a6d3-87b43242fgaed20152f' and last_nc < 126899] file is encrypted or is not a database
2019-08-28 02:35:51.174369 [ERR] switch_core_sqldb.c:587 NATIVE SQL ERR [file is encrypted or is not a database]
update sip_authentication set expires='1566959816',last_nc=126899 where nonce='d8175c1c-fe73-48dfgeg4476-a6d3-87baed20152f'
2019-08-28 02:35:51.174369 [ERR] switch_core_sqldb.c:587 NATIVE SQL ERR [file is encrypted or is not a database]

2019-08-28 02:36:25.904372 [CRIT] switch_core_sqldb.c:1957 ERROR [file is encrypted or is not a database]
2019-08-28 02:36:25.904372 [ERR] switch_core_sqldb.c:587 NATIVE SQL ERR [cannot commit - no transaction is active]
COMMIT

I deleted /var/lib/freeswitch/db and restart then it is working.

Whar could be the cause? Is there a way to fix this issue without having to restart the entire FS?

 

[gflow]

Did you end up finding a figuring this one out?

What version of Freeswitch are you using?

 

[jeetz]

Today , my fusionpbx server on AWS is well working. But suddenly error , status Registrations (0) on web is empty.
( freeswitch running coredb on ram via : /etc/fstab : tmpfs /var/lib/freeswitch/db tmpfs defaults,size=6g 0 0)


2019-08-28 02:35:51.164378 [ERR] switch_core_sqldb.c:1197 SQL ERR: [select call_id,sip_user,sip_host,contact,status,rpid,expires,user_agent,server_user,server_host,profile_name,hostname,network_ip,network_port,sip_username,sip_realm,mwi_user,mwi_host,ping_status,ping_time from sip_registrations where profile_name='internal'] file is encrypted or is not a database
2019-08-28 02:35:51.174369 [ERR] switch_core_sqldb.c:1197 SQL ERR: [select call_id,sip_user,sip_host,contact,status,rpid,expires,user_agent,server_user,server_host,profile_name,hostname,network_ip,network_port,sip_username,sip_realm,mwi_user,mwi_host,ping_status,ping_time from sip_registrations where profile_name='internal'] file is encrypted or is not a database
2019-08-28 02:35:51.174369 [ERR] switch_core_sqldb.c:1197 SQL ERR: [select nonce,last_nc from sip_authentication where nonce='d8175c1c-fe73-4876-a6d3-87b43242fgaed20152f' and last_nc < 126899] file is encrypted or is not a database
2019-08-28 02:35:51.174369 [ERR] switch_core_sqldb.c:587 NATIVE SQL ERR [file is encrypted or is not a database]
update sip_authentication set expires='1566959816',last_nc=126899 where nonce='d8175c1c-fe73-48dfgeg4476-a6d3-87baed20152f'
2019-08-28 02:35:51.174369 [ERR] switch_core_sqldb.c:587 NATIVE SQL ERR [file is encrypted or is not a database]

2019-08-28 02:36:25.904372 [CRIT] switch_core_sqldb.c:1957 ERROR [file is encrypted or is not a database]
2019-08-28 02:36:25.904372 [ERR] switch_core_sqldb.c:587 NATIVE SQL ERR [cannot commit - no transaction is active]
COMMIT

I deleted /var/lib/freeswitch/db and restart then it is working.

Whar could be the cause? Is there a way to fix this issue without having to restart the entire FS?

this is the prob i had too.... but i read somewhere to delete and restart it, so my time was quick.