OperationalError: database is locked

[Simon Chatain]

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]

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]

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]

(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]

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]

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]

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]

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]

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]

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]

where did you check (and what is the OS) ?

kind regards, Henk-Jan Ebbers

To view this discussion on the web visit https://groups.google.com/d/msgid/botsmail/6632b249-992b-432c-8ec2-65c66e5d50c9n%40googlegroups.com.

[Len Finley]

Thanks for responding on a Sunday.  Running Microsoft Windows Server 2012 R2.

To view this discussion on the web visit https://groups.google.com/d/msgid/botsmail/CAK7Br2-VFupZ04hRPW4GhMo17QwaK2rja%3DXcbeNxsPaH7y5e-Q%40mail.gmail.com.

[Eppye Bots]

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

To view this discussion on the web visit https://groups.google.com/d/msgid/botsmail/CAP4-Fk3ZB%2BW-5vEOtMpyWtn960ZYpLURAj_VvaQNtS2%3DhYdvCA%40mail.gmail.com.