Re: [sqlite] database is locked

On 20 Oct 2018, at 1:19pm, p...@geniais.com wrote: > I'm using exec() to simply get true/false result (just reading) and I'm > receiving this error, even in WAL mode: > SQLite3::exec(): database is locked in ... on line 47 > > Any help will be apreciated I'm assuming that you are aware that

[sqlite] database is locked

Hello, I'm using exec() to simply get true/false result (just reading) and I'm receiving this error, even in WAL mode: SQLite3::exec(): database is locked in ... on line 47 Any help will be apreciated Thank you Ismael ___ sqlite-users mailing

Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked

> For the record, "delete the journal file" is terrible advice Agreed. In normal production environment, I wouldn't suggest that. The user was testing a database, and in my own developemtn cycle, its common when developing for a database to be in all manners of chaos states. It was purely a

Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked

On 2018/10/15 5:05 AM, Rowan Worth wrote: On Sat, 13 Oct 2018 at 02:20, Lars Frederiksen wrote: Any ideas? Not sure if this got resolved off-list, but based on the code you've posted I wonder if there is an "fdqGloser" as well as an "fdqGloser2", and if so what state it is in. Update:

Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked

On Sat, 13 Oct 2018 at 02:20, Lars Frederiksen wrote: > I type info into some labeledits and by pressing "Append to DB" button > this code is executed (fdqGoser2 is a FDQuery) > > fdqGloser2.Open; > fdqGloser2.Append; > fdqGloser2.FieldByName('Graesk').AsString:= ledGræsk.Text; > ... >

Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked

On Sat, 13 Oct 2018 at 00:21, Chris Locke wrote: > > Database is locked > > Close your application. Is there a xxx-journal file in the same directory > as the database? (where xxx is the name of the database) > Try deleting this file. > For the record, "delete the journal file" is terrible

Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked

On 2018/10/12 8:19 PM, Lars Frederiksen wrote: I type info into some labeledits and by pressing "Append to DB" button this code is executed (fdqGoser2 is a FDQuery) fdqGloser2.Open; fdqGloser2.Append; fdqGloser2.FieldByName('Graesk').AsString:= ledGræsk.Text;

Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked

of SQLite Database Emne: Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked FSCK is File System ChecK, so the equivalent in Windows Scandisk. Trace through the code to find out when exactly the SQLite is reporting the lock. Is it at a query, on opening, is it multi-thread or multi-a

Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked

-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of Lars Frederiksen >Sent: Friday, 12 October, 2018 06:26 >To: 'SQLite mailing list' >Subject: Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database >is locked > >That is: I have disable

Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked

FSCK is File System ChecK, so the equivalent in Windows Scandisk. Trace through the code to find out when exactly the SQLite is reporting the lock. Is it at a query, on opening, is it multi-thread or multi-application access? Is the query taking too long? If you're debugging and everything is

Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked

[mailto:sqlite-users-boun...@mailinglists.sqlite.org] På vegne af Chris Locke Sendt: 12. oktober 2018 18:22 Til: SQLite mailing list Emne: Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked > Database is locked Close your application. Is there a xxx-journal file in the s

Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked

o filesystem corruption? Have you tried an >> fsck? >> >> >> - Original Message - >> From: R Smith >> To: sqlite-users@mailinglists.sqlite.org < >> sqlite-users@mailinglists.sqlite.org> >> Sent: Friday, October 12, 2018, 17:35:28 &g

Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked

Could the problem arise due to filesystem corruption? Have you tried an fsck? - Original Message - From: R Smith To: sqlite-users@mailinglists.sqlite.org Sent: Friday, October 12, 2018, 17:35:28 Subject: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked On 2018/10/12

Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked

On 2018/10/12 2:44 PM, Lars Frederiksen wrote: I have tried that too! - I must admit that right now I am turning to a KISS solution: String-based database with functions and procedures in a class that handles the different jobs you do on a table. After all these old-fashioned DB's are not so

Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked

? /Lars -Oprindelig meddelelse- Fra: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] På vegne af Radovan Antloga Sendt: 12. oktober 2018 10:10 Til: sqlite-users@mailinglists.sqlite.org Emne: Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked Try

Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked

: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] På vegne af Stephen Chrzanowski Sendt: 12. oktober 2018 14:37 Til: General Discussion of SQLite Database Emne: Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked How about moving the databases elsewhere

Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked

wrote: > > > Hello, > > > > I have made (in Delphi) a program that writes to a sqlite database. This > is > > a simple stand-alone solution. Now something is blocking for the programs > > attempt to writing to the databse. There is a an error message: > > [

Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked

Database Emne: Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked Change the timeout value on the connection to 5 seconds or so. The DB will retry. The AV has its grip on it, doing a scan, and won't let anything else touch it until its done. On Fri, Oct 12, 2018 at 3:11 AM Lars

Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked

@mailinglists.sqlite.org Emne: Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked Try to change database name (extension). For example: mydb.sqlite mydb.sdb mydb.db3 I would use .sqlite extension and exclude that files from antivirus check. Regards Lars Frederiksen je 12.10.2018 ob

Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked

at writes to a sqlite database. This is > a simple stand-alone solution. Now something is blocking for the programs > attempt to writing to the databse. There is a an error message: > [FireDAC][Phys][SQLite] Database is locked. > > A friend of mine has analysed the scenario and t

Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked

at writes to a sqlite database. This is > a simple stand-alone solution. Now something is blocking for the programs > attempt to writing to the databse. There is a an error message: > [FireDAC][Phys][SQLite] Database is locked. > > A friend of mine has analysed the scenario and t

Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked

. This is a simple stand-alone solution. Now something is blocking for the programs attempt to writing to the databse. There is a an error message: [FireDAC][Phys][SQLite] Database is locked. A friend of mine has analysed the scenario and tells me that BitDefender is the Problem. In BitDefender

[sqlite] error message: [FireDAC][Phys][SQLite] Database is locked

Hello, I have made (in Delphi) a program that writes to a sqlite database. This is a simple stand-alone solution. Now something is blocking for the programs attempt to writing to the databse. There is a an error message: [FireDAC][Phys][SQLite] Database is locked. A friend of mine has analysed

Re: [sqlite] Database is locked

On 2/28/18 3:18 PM, Frank Millman wrote: > > On 2/28/18 2:53 PM, Richard Damon wrote: > > > > > On 2/28/18 6:59 AM, Frank Millman wrote: > > > Hi all > > > > > > I am using Python 3.6.0 and sqlite3 3.20.1. I am getting the message > > > ‘database is locked’ which, from reading the docs, I

Re: [sqlite] Database is locked

On 2/28/18 2:53 PM, Richard Damon wrote: > > On 2/28/18 6:59 AM, Frank Millman wrote: > > Hi all > > > > I am using Python 3.6.0 and sqlite3 3.20.1. I am getting the message > > ‘database is locked’ which, from reading the docs, I think is coming from > > an SQL_BUSY error. > > > > It does not

Re: [sqlite] Database is locked

On 2/28/18 6:59 AM, Frank Millman wrote: Hi all I am using Python 3.6.0 and sqlite3 3.20.1. I am getting the message ‘database is locked’ which, from reading the docs, I think is coming from an SQL_BUSY error. It does not behave in the way I expect. I tested using two concurrent connections

[sqlite] Database is locked

Hi all I am using Python 3.6.0 and sqlite3 3.20.1. I am getting the message ‘database is locked’ which, from reading the docs, I think is coming from an SQL_BUSY error. It does not behave in the way I expect. I tested using two concurrent connections – call them conn_1 and conn_2. 1. conn_1

[sqlite] "Database is locked" in diagnostic tools C#

Hi everyone, I have managed to successfully replace SQLCE with System.Data.SQLite in a mid-size application. Everything works fine but now that I started optimizing the old code and replaced own connection pooling with SQLite connection pooling I am getting an occasional Program Output

Re: [sqlite] Database is locked

h, 01. März 2017 21:45 An: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> Betreff: Re: [sqlite] Database is locked On Wed, 1 Mar 2017, Stephen Chrzanowski wrote: > Where is the database being stored? What OS is the software running > under? If Windows, I'd suggest looking up Sys

Re: [sqlite] Database is locked

On 1 Mar 2017, at 9:17pm, Bob Friesenhahn wrote: > I am not sure of all of the conditions which might result in "Database is > locked". For example, if the results of a query are being iterated through > and the reader stops iterating part way through the result

Re: [sqlite] Database is locked

On Wed, 1 Mar 2017, Simon Slavin wrote: On 1 Mar 2017, at 7:27pm, Bob Friesenhahn wrote: What is the recommended approach to diagnosing "Database is locked" errors and determining the guilty party? Are you checking the result codes returned by all SQLite

Re: [sqlite] Database is locked

Where is the database being stored? What OS is the software running under? If Windows, I'd suggest looking up SysInternals and downloading the package to see what has its grubby hands on the database. If Linux, as root, run an LSOF (Lower case) and grep for the database or process accessing the

Re: [sqlite] Database is locked

You may not DETACH while a query is running. This is to prevent the DETACH from closing a database connection out from under the running query. On 11/9/16, Jean-Baptiste Gardette wrote: > On Window 7 with tcl/tk 8.6.6 and SQLite 3.13.0 > > The following tcl script craches

[sqlite] Database is locked

On Window 7 with tcl/tk 8.6.6 and SQLite 3.13.0 The following tcl script craches : package require sqlite3 sqlite3 db1 dbfile1 db1 eval "SELECT A FROM TableA" { db1 eval "ATTACH DATABASE dbfile2 AS 'dbfile2'" db1 eval

Re: [sqlite] Database is locked

Dan, On Sun, Jul 10, 2016 at 11:57 AM, Dan Kennedy wrote: > On 07/10/2016 06:21 AM, Igor Korot wrote: >> >> Simon, >> >> On Sat, Jul 9, 2016 at 7:09 PM, Simon Slavin wrote: >>> >>> On 10 Jul 2016, at 12:06am, Igor Korot wrote:

Re: [sqlite] Database is locked

On 07/10/2016 06:21 AM, Igor Korot wrote: Simon, On Sat, Jul 9, 2016 at 7:09 PM, Simon Slavin wrote: On 10 Jul 2016, at 12:06am, Igor Korot wrote: I'm trying to write some software in C{++}. Everything works fine except when I exit the program exit

Re: [sqlite] Database is locked

Simon, On Sat, Jul 9, 2016 at 7:09 PM, Simon Slavin wrote: > > On 10 Jul 2016, at 12:06am, Igor Korot wrote: > >> I'm trying to write some software in C{++}. Everything works fine except >> when I exit the program exit I get the error "Database is

Re: [sqlite] Database is locked

On 10 Jul 2016, at 12:06am, Igor Korot wrote: > I'm trying to write some software in C{++}. Everything works fine except > when I exit the program exit I get the error "Database is locked". > I am only trying to retrieve the information about the database (queries on >

[sqlite] Database is locked

Hi, Here is my situation. I'm trying to write some software in C{++}. Everything works fine except when I exit the program exit I get the error "Database is locked". I am only trying to retrieve the information about the database (queries on sqlite_master). So here are my questions: 1. When the

Re: [sqlite] sqlite database is locked when query SQLITE_MASTER table

Are you programming in a programming language ? If so, which language are you using and which library are you using to execute SQLite commands ? If you are scripting instead please tell us which scripting language you're using. If you are using multi-threading or multi-processing, please tell

[sqlite] sqlite database is locked when query SQLITE_MASTER table

I have the huge size of the database file (approx 5.5GB). I have two processes. 1.The first process: It executes master table query. (Ex. "SELECT "type", "tbl_name" FROM "SQLite_MASTER"). It creates the new table using the dump of the existing table and database file size has been increased

[sqlite] database is locked when using SQLite3 and MPI to generate different databases

On 8 May 2016 at 10:14, just_rookie <925345468 at qq.com> wrote: > Obviously, I did not do incompatible things with a database at the same > time. > You are attempting to drop a table in databases 300_500.db and 600_900.db. Obviously another process must create that table, since your test code

[sqlite] ?????? database is locked when using SQLite3 and MPI togenerate different databases

;; ??: Re: [sqlite] database is locked when using SQLite3 and MPI togenerate different databases On 8 May 2016, at 3:14am, just_rookie <925345468 at qq.com> wrote: > But when I ran the program in Linux, I got an error message from > sqlite3_exec() that ?database is locked?. You h

[sqlite] database is locked when using SQLite3 and MPI to generate different databases

Hi all, I would like to use SQLite3 and MPI to generate many databases, and different processes produce and process different databases. But when I ran the program in Linux, I got an error message from sqlite3_exec() that ?database is locked?. I know this message means I tried to do

[sqlite] database is locked when using SQLite3 and MPI to generate different databases

On 8 May 2016, at 3:14am, just_rookie <925345468 at qq.com> wrote: > But when I ran the program in Linux, I got an error message from > sqlite3_exec() that ?database is locked?. You have not set a timeout, so SQLite is quitting as soon as it is told that another thread/process has the

[sqlite] Database is locked (wal) - purely from read-only connections/queries

Jim, I am running simple select statements against views; I am not inserting into them or anything unusual like that. Also, my earlier comment re attach database was a red herring. I hit the "statement aborts" without that. Lastly, to be clear, the "SQLite error (17): statement aborts..." is

[sqlite] Database is locked (wal) - purely from read-only connections/queries

Jim, I am running simple select statements against views; I am not inserting into them or anything unusual like that. Also, my earlier comment re attach database was a red herring. I hit the "statement aborts" without that. Lastly, to be clear, the "SQLite error (17): statement aborts..." is

[sqlite] Database is locked (wal) - purely from read-only connections/queries

On 2/29/16, Vince Scafaria wrote: > Richard, I can confirm that having a writable connection open first, prior > to trying any reads, does avoid the "database is locked" error. However, I > still do get "SQLite error (17): statement aborts" errors. What are the > rules I must follow to avoid

[sqlite] Database is locked (wal) - purely from read-only connections/queries

One possibility: Does ATTACH DATABASE count as a schema change? From: Vince Scafaria Sent: Monday, February 29, 2016 10:31 PM To: 'sqlite-users at mailinglists.sqlite.org' Subject: Database is locked (wal) - purely from read-only connections/queries Richard, I can confirm that having a

[sqlite] Database is locked (wal) - purely from read-only connections/queries

Richard, I can confirm that having a writable connection open first, prior to trying any reads, does avoid the "database is locked" error. However, I still do get "SQLite error (17): statement aborts" errors. What are the rules I must follow to avoid getting these SQLITE_SCHEMA errors? I am

[sqlite] Database is locked (wal) - purely from read-only connections/queries

Are you using any SQL VIEWs? "You cannot DELETE, INSERT, or UPDATE a view. Views are read-only in SQLite." http://sqlite.org/lang_createview.html Jim On Mon, Feb 29, 2016 at 10:31 PM, Vince Scafaria wrote: > Richard, I can confirm that having a writable connection open first, prior > to trying

[sqlite] Database is locked (wal) - purely from read-only connections/queries

On 2/26/16, Vince Scafaria wrote: > I am using System.Data.SQLite in .NET and encountering "database is locked" > with wal using multiple threads from the same process running simple select > statements with (separate) read-only connections. The first database connection (in any process) that

[sqlite] Database is locked (wal) - purely from read-only connections/queries

I am using System.Data.SQLite in .NET and encountering "database is locked" with wal using multiple threads from the same process running simple select statements with (separate) read-only connections. Please see the link below and note the Visual Studio output window when it runs.

[sqlite] Database is locked

Hello Richard, I am not a SQLITE expert. As I understand WAL it is especially made for transactions? But our application do not have transactions, just normal SQL queries like Select, Insert and Updates. So does WAL makes sense for that? 2016-01-14 14:20 GMT+01:00 Richard Hipp : > On 1/14/16,

[sqlite] Database is locked

On 15 Jan 2016, at 7:51am, Werner Kleiner wrote: > Takes your suggestion with PDO setAttribute(PDO:: ATTR_TIMEOUT, the same > effect as Richards with PRAGMA busy_timeout? > For example I do a: > > $dbConnection =$db->query('PRAGMA busy_timeout=6') ; > > instead of > >

[sqlite] Database is locked

Thanks a lot Simon. Now I understand a little bit better. Last question: (hopefully :-) ) Takes your suggestion with PDO setAttribute(PDO:: ATTR_TIMEOUT, the same effect as Richards with PRAGMA busy_timeout? For example I do a: $dbConnection =$db->query('PRAGMA busy_timeout=6') ; instead

[sqlite] Database is locked

On 1/15/16, Werner Kleiner wrote: > Hello Richard, > I am not a SQLITE expert. > As I understand WAL it is especially made for transactions? > But our application do not have transactions, just normal SQL queries like > Select, Insert and Updates. Every "normal SQL query" is a transaction unto

[sqlite] Database is locked

On 14 Jan 2016, at 1:42pm, Werner Kleiner wrote: > The windows application is written in C# and uses the sqlite.systemData.dll. I'm sure someone here can tell you how to set a timeout in that. > What does the timeout mean in detail for sqlite ? > Is this time (in your example 5 minutes) for

[sqlite] Database is locked

Hello Simon, thank you for help. The windows application is written in C# and uses the sqlite.systemData.dll. What does the timeout mean in detail for sqlite ? Is this time (in your example 5 minutes) for each SQL query which is executed? 2016-01-14 14:25 GMT+01:00 Simon Slavin : > > On 14 Jan

[sqlite] Database is locked

On 14 Jan 2016, at 10:57am, Werner Kleiner wrote: > I have written a small Wep application with PHP (PDO Apache,). This web app > uses a sqlite db3 database. Also there is a Windows application which uses > the same database file. > Now we heard one time that there war a problem and in a log

[sqlite] Database is locked

As with the other suggestions, have a read of https://www.sqlite.org/howtocorrupt.html If you've got to distinct machines/OS's trying to touch the same file, you might be looking at other issues. Also, if you are indeed working over a network, your timeout might be set so low that SQLite just

[sqlite] Database is locked

Hello I have written a small Wep application with PHP (PDO Apache,). This web app uses a sqlite db3 database. Also there is a Windows application which uses the same database file. Now we heard one time that there war a problem and in a log file we saw the error code "Database is locked" My

[sqlite] Database is locked

On 1/14/16, Werner Kleiner wrote: > Hello > I have written a small Wep application with PHP (PDO Apache,). This web app > uses a sqlite db3 database. Also there is a Windows application which uses > the same database file. > Now we heard one time that there war a problem and in a log file we saw

Re: [sqlite] database is locked

: [sqlite] database is locked Use the following code snippet (add error checking, set v_file to the full path name of your SQLite db file) to check. It attempts to take the same locks as SQLite would, but prints the pid of the blocking process. It also prints the journal mode. #include

Re: [sqlite] database is locked

l_pid)); if (v_ret == -1) printf("%s File:%s, \n",g_mode[v_mode] ,v_file); -Ursprüngliche Nachricht- Von: Roman Fleysher [mailto:roman.fleys...@einstein.yu.edu] Gesendet: Mittwoch, 14. Jänner 2015 18:54 An: General Discussio

Re: [sqlite] database is locked

.@sqlite.org] on > behalf of Richard Hipp [d...@sqlite.org] > Sent: Wednesday, January 14, 2015 1:26 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] database is locked > > On 1/14/15, Roman Fleysher <roman.fleys...@einstein.yu.edu> wrote: >> SQLite s

Re: [sqlite] database is locked

ite.org] on > behalf of Richard Hipp [d...@sqlite.org] > Sent: Wednesday, January 14, 2015 1:26 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] database is locked > > On 1/14/15, Roman Fleysher <roman.fleys...@einstein.yu.edu> wrote: >> SQLite s

Re: [sqlite] database is locked

From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Richard Hipp [d...@sqlite.org] Sent: Wednesday, January 14, 2015 1:26 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] database is locked On 1/14/15, Roman Fleysher <roman.fl

Re: [sqlite] database is locked

pect to locking. > > > > > From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on > behalf of Richard Hipp [d...@sqlite.org] > Sent: Wednesday, January 14, 2015 12:50 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] databas

Re: [sqlite] database is locked

On 14 Jan 2015, at 5:30pm, Roman Fleysher wrote: > Is there a way to figure out what is happening? Clear the lock? We would need specifics of your system to answer this absolutely correctly. But you can try these things in turn until one of them works:

Re: [sqlite] database is locked

Subject: Re: [sqlite] database is locked On 1/14/15, Roman Fleysher <roman.fleys...@einstein.yu.edu> wrote: > Dear SQLiters, > > There has been a lot of discussion, I remember, on this subject by others. > Please forgive me for asking this for a millionth time. > > I somehow got

Re: [sqlite] database is locked

On 1/14/15, Roman Fleysher wrote: > Dear SQLiters, > > There has been a lot of discussion, I remember, on this subject by others. > Please forgive me for asking this for a millionth time. > > I somehow got my database in a locked state. I updated a table yesterday

[sqlite] database is locked

Dear SQLiters, There has been a lot of discussion, I remember, on this subject by others. Please forgive me for asking this for a millionth time. I somehow got my database in a locked state. I updated a table yesterday and I am rather sure that no one on our multi-user system is updating it

Re: [sqlite] "database is locked" for SQLITE_BUSY

On 4 Dec 2014, at 5:36pm, Jonathan Moules wrote: > Depending on the application, an end user likely won't see the error code, > but instead just the error message SQlite is not a program. It's an API, intended for use by a programmer. Those error codes should

Re: [sqlite] "database is locked" for SQLITE_BUSY

, but instead just the error message (at least the application where I encountered this issue). They then google for "sqlite database locked" but get back information about SQLITE_LOCKED which isn't the same thing as SQLITE_BUSY. It doesn't particularly matter too much what the mes

Re: [sqlite] "database is locked" for SQLITE_BUSY

On 3 Dec 2014, at 3:20pm, Richard Hipp wrote: > https://www.sqlite.org/rescode.html#busy Thanks, Richard. I have somehow never seen that. I had no idea that the difference between _BUSY and _LOCKED was purely about whether the conflicting access was from the same

Re: [sqlite] "database is locked" for SQLITE_BUSY

scussion of SQLite Database >Subject: Re: [sqlite] "database is locked" for SQLITE_BUSY > >To me, a BUSY state would mean that everything up to actually reading or >writing the data out is valid, but, the response time coming back was >just >too long, so a timeout

Re: [sqlite] "database is locked" for SQLITE_BUSY

On Wed, Dec 3, 2014 at 10:18 AM, Simon Slavin wrote: > > On 3 Dec 2014, at 3:10pm, Hick Gunter wrote: > > > SQLITE_BUSY means that some connection is BUSY with a write transaction > and has locked the database file; presumably, it will be possible to

Re: [sqlite] "database is locked" for SQLITE_BUSY

On 3 Dec 2014, at 3:10pm, Hick Gunter wrote: > SQLITE_BUSY means that some connection is BUSY with a write transaction and > has locked the database file; presumably, it will be possible to write to the > database when the current writer has finished, just not now or within

Re: [sqlite] "database is locked" for SQLITE_BUSY

] Gesendet: Mittwoch, 03. Dezember 2014 12:01 An: 'General Discussion of SQLite Database' Betreff: [sqlite] "database is locked" for SQLITE_BUSY Hi, Just a quick request/suggestion. Currently SQLITE_BUSY events return an error of "Database is locked". Is it possible to change

Re: [sqlite] "database is locked" for SQLITE_BUSY

To me, a BUSY state would mean that everything up to actually reading or writing the data out is valid, but, the response time coming back was just too long, so a timeout hit which might mean that a retry later might be appropriate. To me, a timeout = busy, but, locked != busy. When something is

Re: [sqlite] "database is locked" for SQLITE_BUSY

On 3 Dec 2014, at 2:20pm, Stephen Chrzanowski wrote: > Although I think there is already an error result, one situation might be > when the DB is in a read only state. I just thought of the database /file/ being marked 'read-only'. But it turns out that there's a

Re: [sqlite] "database is locked" for SQLITE_BUSY

suggestion. >> >> Currently SQLITE_BUSY events return an error of "Database is locked". Is >> it possible to change this to "Database is busy" or something similar? >> I ask because when someone then goes googling for "SQLite database >> locked",

Re: [sqlite] "database is locked" for SQLITE_BUSY

On 2014/12/03 13:00, Jonathan Moules wrote: Hi, Just a quick request/suggestion. Currently SQLITE_BUSY events return an error of "Database is locked". Is it possible to change this to "Database is busy" or something similar? I ask because when someone then goes googling

[sqlite] "database is locked" for SQLITE_BUSY

Hi, Just a quick request/suggestion. Currently SQLITE_BUSY events return an error of "Database is locked". Is it possible to change this to "Database is busy" or something similar? I ask because when someone then goes googling for "SQLite database locked", t

Re: [sqlite] Database is locked exceptions

On 2014-10-29, 12:13 PM, Mike McWhinney wrote: System.Windows.Forms.Control.ControlNativeWindow.OnThreadException(Exception e) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) at

Re: [sqlite] Database is locked exceptions

On 29 Oct 2014, at 4:13pm, Mike McWhinney wrote: > "URI=file:mydb.db; default timeout=10; Pooling=True; Max Pool Size=100;"; Can you please change your timeout to 1 (really, 1ms == 10 seconds) and see if this makes the problems go away ? It may not be necessary

[sqlite] Database is locked exceptions

Hello, I have written a program in C# Visual Studio Winforms. In general the SQLite database is working quite well. However, lately we have been plagued with database locking errors: Here is the exeption: database is locked database is locked at

Re: [sqlite] Database is locked !

tabase' Cc : 'Alex Trucy' Objet : Re: [sqlite] Database is locked ! For information, you will find the "SQLiteJdbc" class used. I verified (normally) after each statement there is a db.close(). Fabrice -Message d'origine- De : sqlite-users-boun...@sqlite.org [mail

Re: [sqlite] Database is locked !

août 2014 15:19 À : General Discussion of SQLite Database Cc : Alex Trucy Objet : Re: [sqlite] Database is locked ! Sounds like you have statements laying around that weren't properly destroyed... you say executed correctly, but then also released correctly? On Wed, Aug 27, 2014 at 6:14 AM, Fabr

Re: [sqlite] Database is locked !

Sounds like you have statements laying around that weren't properly destroyed... you say executed correctly, but then also released correctly? On Wed, Aug 27, 2014 at 6:14 AM, Fabrice MAUPIN wrote: > Hi all, > > > > I try to execute an "INSERT" query and I obtain this message

[sqlite] Database is locked !

Hi all, I try to execute an "INSERT" query and I obtain this message : "Database is locked". I verified all the previous connections which were opened were closed and all the previous statements were correctly executed (UPDATE, INSERT, .). The volume of data to be handled is very low.

Re: [sqlite] Database gets locked for other processes

I know well the qt sqlite to say, maybe you aren't destroing the QSqlQuery class or simple call finish function, and the statement is openned helding the lock! Enviado via iPhone > Em 29/10/2013, às 10:51, Stephan Beal escreveu: > >> On Tue, Oct 29, 2013 at 1:52 PM,

Re: [sqlite] Database gets locked for other processes

"Martin Kropfinger" Am Tue, 29 Oct 2013 12:00:02 -0400 schrieb sqlite-users-requ...@sqlite.org: Date: Tue, 29 Oct 2013 14:51:08 +0100 From: Stephan Beal <sgb...@googlemail.com> To: General Discussion of SQLite Database <sqlite-users@sqlite.org> Subject: Re: [sqlite

Re: [sqlite] Database gets locked for other processes

Am Tue, 29 Oct 2013 12:00:02 -0400 schrieb sqlite-users-requ...@sqlite.org: > Date: Tue, 29 Oct 2013 14:51:08 +0100 > From: Stephan Beal <sgb...@googlemail.com> > To: General Discussion of SQLite Database <sqlite-users@sqlite.org> > Subject: Re: [sqlite] Database gets lo

Re: [sqlite] Database gets locked for other processes

On Tue, Oct 29, 2013 at 1:52 PM, Martin wrote: > The program is running on Windows7. > ... The program runs parallel on multiple machines all sharing the same > SQLite-Database-file. Connecting multiple clients over a network share is a sure-fire way to corrupt your

Re: [sqlite] Database gets locked for other processes

Sounds like something changed in Qt 5.1.1 so that it is holding open a read transaction. The first process acquires the read transaction, which permits other processes to read but prevents anybody else from writing. I have no idea why Qt would do this, though. You can change to WAL mode, which

[sqlite] Database gets locked for other processes

Hi there! I have a program written in Qt and using the SQLite-drivers shipped with Qt. AFAIK those are the original SQLite-drivers. The program is running on Windows7. Originally the program was written using Qt4.8 (which came with SQLite 3.7.14.1). The program runs parallel on multiple machines

Re: [sqlite] database is locked with create

- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Richard Hipp Sent: Tuesday, February 19, 2013 4:04 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] database is locked with create On Tue, Feb 19, 2013 at 6:37 PM, Choi, David <davi

Re: [sqlite] database is locked with create

of options. > > > Regards, > David J. Choi > > > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto: > sqlite-users-boun...@sqlite.org] On Behalf Of Richard Hipp > Sent: Tuesday, February 19, 2013 1:44 PM > To: General Discussion of SQLite

  1   2   3   >