[Freeswitch-users] Error database is locked

[Anthony Minessale]

It's a harmless warning generated by sqlite due to it's design.  It just
means something was reading from the db while something else was writing.

On Sun, Oct 19, 2008 at 2:24 PM, Jon Bruel <jbr at consiglia.dk> wrote:

> I have made an application using the fifo application which behaves as
> the Asterisk queue: It rings to the members. I use javascript DB to
> access the core database in various scripts, f.in the following script:
> //This script is used to disconnect agents being rung from a queue when
> abandoned by the customer before answered.
> use("CoreDB");
> var db = new CoreDB("core");
> var sql="select uuid from channels where cid_num='"+argv+"' and
> state='CS_EXECUTE';";
> db.prepare(sql);
> while(db.next()) {
>        rec = db.fetch();
>        apiExecute("uuid_kill", rec["uuid"]);
> }
> db.close();
>
> My problem is that I get a message from the CLI: mod_spidermonkey.c:3300
> js_api_use() Loading CoreDB, [ERR] mod_spidermonkey_core_db.c:250
> db_prepare() Error database is locked.
> The error does not occur every time.
> I have closed the database in every script using it.
> Is the anything I should be aware of to prevent this from happening?
>
>
> _______________________________________________
> 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
>
>


-- 
Anthony Minessale II

FreeSWITCH http://www.freeswitch.org/
ClueCon http://www.cluecon.com/

AIM: anthm
MSN:anthony_minessale at hotmail.com <MSN%3Aanthony_minessale at hotmail.com>
GTALK/JABBER/PAYPAL:anthony.minessale at gmail.com<PAYPAL%3Aanthony.minessale at gmail.com>
IRC: irc.freenode.net #freeswitch

FreeSWITCH Developer Conference
sip:888 at conference.freeswitch.org <sip%3A888 at conference.freeswitch.org>
iax:guest at conference.freeswitch.org/888
googletalk:conf+888 at conference.freeswitch.org<googletalk%3Aconf%2B888 at conference.freeswitch.org>
pstn:213-799-1400
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20081020/fe10d033/attachment-0002.html