That means it cant access the db properly.  Check your perms for the user FreeSWITCH is running as and make sure it has full read/write perms to the db dir, also make sure there is plenty of space on whatever mount point that is on

 

From: freeswitch-users-bounces@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] On Behalf Of Kiran Patil
Sent: Thursday, October 8, 2015 7:55 AM
To: freeswitch-users@lists.freeswitch.org
Subject: [Freeswitch-users] [ERR] switch_core_sqldb.c:587 NATIVE SQL ERR [cannot commit - no transaction is active]

 

Hi,

I installed Freeswitch 1.6.2 on CentOS 7.

[root@freeswitch freeswitch]# freeswitch -version
FreeSWITCH version: 1.6.2~64bit ( 64bit)

[root@freeswitch freeswitch]# systemctl status freeswitch.service
freeswitch.service - FreeSWITCH
   Loaded: loaded (/usr/lib/systemd/system/freeswitch.service; enabled)
   Active: active (running) since Thu 2015-10-08 17:50:38 IST; 29min ago
 Main PID: 12226 (freeswitch)
   CGroup: /system.slice/freeswitch.service
           └─12226 /usr/bin/freeswitch -nc -nf

Oct 08 17:50:38 freeswitch systemd[1]: Starting FreeSWITCH...
Oct 08 17:50:38 freeswitch systemd[1]: Started FreeSWITCH.

Started Freeswitch daemon and typed fs_cli on cmd line and I am seeing only errors as below.

Please help me to resolve this issue.

BEGIN EXCLUSIVE
2015-10-08 18:11:35.190458 [CRIT] switch_core_sqldb.c:1952 ERROR [attempt to write a readonly database]
2015-10-08 18:11:35.190458 [ERR] switch_core_sqldb.c:587 NATIVE SQL ERR [cannot commit - no transaction is active]
COMMIT
2015-10-08 18:11:35.190458 [ERR] switch_core_sqldb.c:587 NATIVE SQL ERR [attempt to write a readonly database]
BEGIN EXCLUSIVE
2015-10-08 18:11:35.190458 [CRIT] switch_core_sqldb.c:1952 ERROR [attempt to write a readonly database]
2015-10-08 18:11:35.190458 [ERR] switch_core_sqldb.c:587 NATIVE SQL ERR [cannot commit - no transaction is active]
COMMIT
2015-10-08 18:11:35.190458 [ERR] switch_core_sqldb.c:587 NATIVE SQL ERR [attempt to write a readonly database]
BEGIN EXCLUSIVE
2015-10-08 18:11:35.190458 [CRIT] switch_core_sqldb.c:1952 ERROR [attempt to write a readonly database]
2015-10-08 18:11:35.190458 [ERR] switch_core_sqldb.c:587 NATIVE SQL ERR [cannot commit - no transaction is active]
COMMIT
2015-10-08 18:11:35.190458 [ERR] switch_core_sqldb.c:587 NATIVE SQL ERR [attempt to write a readonly database]
BEGIN EXCLUSIVE
2015-10-08 18:11:35.190458 [CRIT] switch_core_sqldb.c:1952 ERROR [attempt to write a readonly database]
2015-10-08 18:11:35.190458 [ERR] switch_core_sqldb.c:587 NATIVE SQL ERR [cannot commit - no transaction is active]
COMMIT
2015-10-08 18:11:35.190458 [ERR] switch_core_sqldb.c:587 NATIVE SQL ERR [attempt to write a readonly database]
BEGIN EXCLUSIVE
2015-10-08 18:11:35.190458 [CRIT] switch_core_sqldb.c:1952 ERROR [attempt to write a readonly database]
2015-10-08 18:11:35.190458 [ERR] switch_core_sqldb.c:587 NATIVE SQL ERR [cannot commit - no transaction is active]
COMMIT
2015-10-08 18:11:35.190458 [ERR] switch_core_sqldb.c:587 NATIVE SQL ERR [attempt to write a readonly database]
BEGIN EXCLUSIVE
2015-10-08 18:11:35.190458 [CRIT] switch_core_sqldb.c:1952 ERROR [attempt to write a readonly database]
2015-10-08 18:11:35.190458 [ERR] switch_core_sqldb.c:587 NATIVE SQL ERR [cannot commit - no transaction is active]
COMMIT

Thanks,

Kiran.

 

_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
consulting@freeswitch.org
http://www.freeswitchsolutions.com

Official FreeSWITCH Sites
http://www.freeswitch.org
http://confluence.freeswitch.org
http://www.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
http://www.freeswitch.org