[Freeswitch-users] [ERR] switch_core_sqldb.c:587 NATIVE SQL ERR [cannot commit - no transaction is active]

Chris Mandra mandra at gmail.com
Thu Oct 8 21:31:53 MSD 2015


I've seen that before - if you install as sudo, but are runnning as
freeswitch this happens

On Thu, Oct 8, 2015 at 12:47 PM, Ken Rice <krice at freeswitch.org> wrote:

> 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 at lists.freeswitch.org [mailto:
> freeswitch-users-bounces at lists.freeswitch.org] *On Behalf Of *Kiran Patil
> *Sent:* Thursday, October 8, 2015 7:55 AM
> *To:* freeswitch-users at 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 at freeswitch freeswitch]# freeswitch -version
> FreeSWITCH version: 1.6.2~64bit ( 64bit)
>
> [root at 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 at 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 at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>



-- 
mandra
c:410.258.5281
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20151008/69b6ff36/attachment.html 


Join us at ClueCon 2016 Aug 8-12, 2016
More information about the FreeSWITCH-users mailing list