Topic: DB error on create Trunk

[jameswilson]

Software error:

DBD::SQLite::db do failed: database is locked(5) at dbdimp.c line 403 at /opt/sark/perl/modules/sark/SarkSubs.pm line 1026.
For help, please send mail to the webmaster (admin@aelintra.local), giving this error message and the time and date of the error.

I am trying to add a trunk (sipgate) and i get this error message. It claims db is locked. How do i unlock it?

[SARK devs]

is it permanently locked?  If you try to add the record again does it always come back as locked?

can you manually open it? - at the cli do...

Code: [Select]

sqlite3 /opt/sark/db/sark.db
to exit sqlite do

Code: [Select]

.exit
Kind REgards

S





   

[jameswilson]

Ah
Just tried again and it was fine. But that was after i tried the above command. Why would it be locked though?

[compsos]

ALso found doing svc -t /service/httpd-srk/ clears the locked DB issue

[SARK devs]

It can lock when you are doing maintenance on the database but it should clear on a retry.  We can't cure it because there are times when the database really does lock as a result of the running PBX doing an update, the most common being the time-segment update which runs every 5 minutes.  The lock should only live a very short time but if you catch it then you will get bounced.  I'm looking at making it a little more graceful in 4.

 
Best

S