Db_execute_sql: Error executing SQL (COMMIT): database is locked

1

Hi,

I got this error:

[2017-10-13 08:22:01] WARNING[1334]: db.c:288 db_execute_sql: Error executing SQL (COMMIT): database is locked
[2017-10-13 08:22:02] WARNING[1334]: db.c:288 db_execute_sql: Error executing SQL (COMMIT): database is locked

Now i cant see any activity in cli to all calls or any transactions except the error message above.
By the way, I move the database to another host. Everything work well in admin page including the cdr. Only the CLI seems not giving me any report from any activity.

Asterisk 13.17.2
Freepbx 13.0.192.18

2

try to repair your table

3

I don’t believe we are talking mysql/mariasql here., the problem is with the asterisk sqlite3 database , you can either restart asterisk and if that doesn’t work then copyin off /var/lib/asterisk/astdb.sqlite3 restarting asterisk restoring the file , another restart, will generally fix things up, you will loose the “state” of your machine though, (DND/hints etc)

1 Like
4

Hi,

Thanks dicko, it did work, i did not see the error and logs from my activities appeared now in CLI. This is great!!