OperationalError: database is locked

76 views
Skip to first unread message

Simon Chatain

unread,
Apr 16, 2018, 4:32:46 AM4/16/18
to Bots Open Source EDI Translator
Hello,

We have a lots of flows in Bots (with SQLite) and we have more and more error of OperationalError: database is locked.

In Bots itself and with our script (only SELECT).

Do you know how we can solve this kind of issue ?

Thanks

Eppye Bots

unread,
Apr 16, 2018, 6:09:39 AM4/16/18
to 'Chuck Turco' via Bots Open Source EDI Translator
there is a script for that.

look where the startup scripts are (bots-engine.py, bots-webserver.py). There is also a script called 'unlockdb.py'.
That works most of the time.
Which version are you using?


kind regards, Henk-Jan Ebbers

--
You received this message because you are subscribed to the Google Groups "Bots Open Source EDI Translator" group.
To unsubscribe from this group and stop receiving emails from it, send an email to botsmail+unsubscribe@googlegroups.com.
Visit this group at https://groups.google.com/group/botsmail.
For more options, visit https://groups.google.com/d/optout.

Simon Chatain

unread,
Apr 17, 2018, 4:21:50 AM4/17/18
to Bots Open Source EDI Translator
Hello,

I'm using v3.2.0
I will take a look at the unlockdb.py.

Thanks


Le lundi 16 avril 2018 12:09:39 UTC+2, eppye a écrit :
there is a script for that.

look where the startup scripts are (bots-engine.py, bots-webserver.py). There is also a script called 'unlockdb.py'.
That works most of the time.
Which version are you using?


kind regards, Henk-Jan Ebbers

On Mon, Apr 16, 2018 at 10:32 AM, Simon Chatain <chata...@gmail.com> wrote:
Hello,

We have a lots of flows in Bots (with SQLite) and we have more and more error of OperationalError: database is locked.

In Bots itself and with our script (only SELECT).

Do you know how we can solve this kind of issue ?

Thanks

--
You received this message because you are subscribed to the Google Groups "Bots Open Source EDI Translator" group.
To unsubscribe from this group and stop receiving emails from it, send an email to botsmail+u...@googlegroups.com.

Eppye Bots

unread,
Apr 17, 2018, 5:46:46 AM4/17/18
to 'Chuck Turco' via Bots Open Source EDI Translator
(read your post too fast, so checking other things. Older versions of bots have a database-lock problem, but not 3.2.0, as far as I know)

when/what happens?
it that in the engine, webserver or where?
where is the database?



kind regards, Henk-Jan Ebbers

On Tue, Apr 17, 2018 at 10:21 AM, Simon Chatain <chata...@gmail.com> wrote:
Hello,

I'm using v3.2.0
I will take a look at the unlockdb.py.

Thanks

Le lundi 16 avril 2018 12:09:39 UTC+2, eppye a écrit :
there is a script for that.

look where the startup scripts are (bots-engine.py, bots-webserver.py). There is also a script called 'unlockdb.py'.
That works most of the time.
Which version are you using?


kind regards, Henk-Jan Ebbers

On Mon, Apr 16, 2018 at 10:32 AM, Simon Chatain <chata...@gmail.com> wrote:
Hello,

We have a lots of flows in Bots (with SQLite) and we have more and more error of OperationalError: database is locked.

In Bots itself and with our script (only SELECT).

Do you know how we can solve this kind of issue ?

Thanks

--
You received this message because you are subscribed to the Google Groups "Bots Open Source EDI Translator" group.
To unsubscribe from this group and stop receiving emails from it, send an email to botsmail+u...@googlegroups.com.
Visit this group at https://groups.google.com/group/botsmail.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Bots Open Source EDI Translator" group.
To unsubscribe from this group and stop receiving emails from it, send an email to botsmail+unsubscribe@googlegroups.com.

Eppye Bots

unread,
Apr 17, 2018, 5:48:33 AM4/17/18
to 'Chuck Turco' via Bots Open Source EDI Translator
Check if you have a virusscanner running.
I have seen cases where the virusscanner seemed to be the case.
(you can whitelist the database in most virusscanners)

kind regards, Henk-Jan Ebbers

On Tue, Apr 17, 2018 at 10:21 AM, Simon Chatain <chata...@gmail.com> wrote:
Hello,

I'm using v3.2.0
I will take a look at the unlockdb.py.

Thanks

Le lundi 16 avril 2018 12:09:39 UTC+2, eppye a écrit :
there is a script for that.

look where the startup scripts are (bots-engine.py, bots-webserver.py). There is also a script called 'unlockdb.py'.
That works most of the time.
Which version are you using?


kind regards, Henk-Jan Ebbers

On Mon, Apr 16, 2018 at 10:32 AM, Simon Chatain <chata...@gmail.com> wrote:
Hello,

We have a lots of flows in Bots (with SQLite) and we have more and more error of OperationalError: database is locked.

In Bots itself and with our script (only SELECT).

Do you know how we can solve this kind of issue ?

Thanks

--
You received this message because you are subscribed to the Google Groups "Bots Open Source EDI Translator" group.
To unsubscribe from this group and stop receiving emails from it, send an email to botsmail+u...@googlegroups.com.
Visit this group at https://groups.google.com/group/botsmail.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Bots Open Source EDI Translator" group.
To unsubscribe from this group and stop receiving emails from it, send an email to botsmail+unsubscribe@googlegroups.com.

Simon Chatain

unread,
Apr 17, 2018, 5:50:23 AM4/17/18
to Bots Open Source EDI Translator
Hello,

Thanks.
There is no antivirus on this system.
Whe have the Database lock error when browsing the web interface and when we use script to query DB (only SELECT).
the database is on the filesystem of the machine, no remote access trought NFS or SMB.

Regards,

Eppye Bots

unread,
Apr 17, 2018, 6:24:34 AM4/17/18
to 'Chuck Turco' via Bots Open Source EDI Translator
so the only writer is bots-engine?

how often and how long does it run?


kind regards, Henk-Jan Ebbers

To unsubscribe from this group and stop receiving emails from it, send an email to botsmail+unsubscribe@googlegroups.com.

Simon Chatain

unread,
Apr 17, 2018, 8:51:50 AM4/17/18
to Bots Open Source EDI Translator
Yes, it's only bots-engine.
And it run a lot :
    new    0    0    2018-04-17 14:49:28            /app/local/bots/bin/bots-engine.py
   
new    0    0    2018-04-17 14:49:25            /app/local/bots/bin/bots-engine.py
   
new    0    0    2018-04-17 14:49:21            /app/local/bots/bin/bots-engine.py
   
new    0    0    2018-04-17 14:49:17            /app/local/bots/bin/bots-engine.py
   
new    0    0    2018-04-17 14:49:13            /app/local/bots/bin/bots-engine.py
   
new    0    0    2018-04-17 14:49:11            /app/local/bots/bin/bots-engine.py
   
new    0    0    2018-04-17 14:49:08            /app/local/bots/bin/bots-engine.py
   
new    0    0    2018-04-17 14:49:05            /app/local/bots/bin/bots-engine.py
   
new    0    0    2018-04-17 14:49:03            /app/local/bots/bin/bots-engine.py
   
new    0    0    2018-04-17 14:49:00            /app/local/bots/bin/bots-engine.py
   
new    0    0    2018-04-17 14:48:57            /app/local/bots/bin/bots-engine.py
   
new    0    0    2018-04-17 14:48:54            /app/local/bots/bin/bots-engine.py
   
new    0    0    2018-04-17 14:48:52            /app/local/bots/bin/bots-engine.py
   
new    0    0    2018-04-17 14:48:49            /app/local/bots/bin/bots-engine.py
   
new    0    0    2018-04-17 14:48:46            /app/local/bots/bin/bots-engine.py
   
new    104    104    2018-04-17 14:48:30    611.3 KB        /app/local/bots/bin/bots-engine.py
   
new    0    0    2018-04-17 14:48:27            /app/local/bots/bin/bots-engine.py
   
new    0    0    2018-04-17 14:48:24            /app/local/bots/bin/bots-engine.py
   
new    0    0    2018-04-17 14:48:22            /app/local/bots/bin/bots-engine.py
   
new    0    0    2018-04-17 14:48:19            /app/local/bots/bin/bots-engine.py
   
new    0    0    2018-04-17 14:48:16            /app/local/bots/bin/bots-engine.py
   
new    0    0    2018-04-17 14:48:13            /app/local/bots/bin/bots-engine.py
   
new    0    0    2018-04-17 14:48:09            /app/local/bots/bin/bots-engine.py
   
new    0    0    2018-04-17 14:48:05            /app/local/bots/bin/bots-engine.py
   
new    1    1    2018-04-17 14:48:00    50.4 KB        /app/local/bots/bin/bots-engine.py
   
new    0    0    2018-04-17 14:47:56            /app/local/bots/bin/bots-engine.py
   
new    0    0    2018-04-17 14:47:52            /app/local/bots/bin/bots-engine.py
   
new    0    0    2018-04-17 14:47:49            /app/local/bots/bin/bots-engine.py
   
new    0    0    2018-04-17 14:47:47            /app/local/bots/bin/bots-engine.py
   
new    0    0    2018-04-17 14:47:43            /app/local/bots/bin/bots-engine.py

Eppye Bots

unread,
Apr 17, 2018, 8:58:15 AM4/17/18
to 'Chuck Turco' via Bots Open Source EDI Translator
seems to be running every 3 seconds?
I would say that is the main reason?



kind regards, Henk-Jan Ebbers

To unsubscribe from this group and stop receiving emails from it, send an email to botsmail+unsubscribe@googlegroups.com.

Len Finley

unread,
Sep 11, 2022, 9:40:07 AM9/11/22
to Bots Open Source EDI Translator
Hello,

We're having the same issue.  I checked the scripts folder and don't see an unlockdb.py file.  We're running version 3.2.

Regards,
Len

On Monday, April 16, 2018 at 6:09:39 AM UTC-4 eppye wrote:
there is a script for that.

look where the startup scripts are (bots-engine.py, bots-webserver.py). There is also a script called 'unlockdb.py'.
That works most of the time.
Which version are you using?


kind regards, Henk-Jan Ebbers

On Mon, Apr 16, 2018 at 10:32 AM, Simon Chatain <chata...@gmail.com> wrote:
Hello,

We have a lots of flows in Bots (with SQLite) and we have more and more error of OperationalError: database is locked.

In Bots itself and with our script (only SELECT).

Do you know how we can solve this kind of issue ?

Thanks

--
You received this message because you are subscribed to the Google Groups "Bots Open Source EDI Translator" group.
To unsubscribe from this group and stop receiving emails from it, send an email to botsmail+u...@googlegroups.com.

Eppye Bots

unread,
Sep 11, 2022, 10:30:51 AM9/11/22
to 'Chuck Turco' via Bots Open Source EDI Translator
where did you check (and what is the OS) ?
kind regards, Henk-Jan Ebbers


Len Finley

unread,
Sep 11, 2022, 10:40:48 AM9/11/22
to bots...@googlegroups.com
Thanks for responding on a Sunday.  Running Microsoft Windows Server 2012 R2.

image.png

Eppye Bots

unread,
Sep 11, 2022, 10:56:17 AM9/11/22
to 'Chuck Turco' via Bots Open Source EDI Translator
I am mistaken.
there is no such script (that was long time ago)

think this happens in the GUI/browser?
it is not a problem in so far that nothing breaks. it is of course an real annoyance.
it happens when there is to much writing/reading in database (GUI is mostly reading).
so it happens mostly when bot-engine is running.

I do not have a solution for this alas.

kind regards, Henk-Jan Ebbers


Reply all
Reply to author
Forward
0 new messages