Re: [sqlite] Database locked problem

On 30 Sep 2018, at 3:14pm, Lars Frederiksen wrote: > In fact I had the same error some time ago where the solution was to put my > database in a C-drive root folder. But that is where the db is right now!! It is very unusual under Windows to have enough privileges to change files in C:\ . Any

[sqlite] Database locked problem

Hello, Delphi 10.2 - FireDAC - SQLite FDConnection1 - FDQuery - DataSource - DBGrid My DBGrid is is Showing words ("gloser") from my database with SQL = 'SELECT * FROM Gloser'. BUT When I fill out som editfields and want to append the data I get the error message: Database Locked

Re: [sqlite] Database locked problem on Windows 7

On Tue, 31 Jul 2018 18:00:31 +0200, Richard Hipp wrote: On 7/31/18, Yngve N. Pettersen wrote: I sent the email quoted below to the list, but unfortunately, as far as I can tell, I have so far received no response. I think that means that nobody has an answer. I don't have any idea why you

Re: [sqlite] Database locked problem on Windows 7

On 7/31/18, Yngve N. Pettersen wrote: > I sent the email quoted below to the list, but > unfortunately, as far as I can tell, I have so far received no response. > I think that means that nobody has an answer. I don't have any idea why your system would work well on Win10 but not on Win7. SQLit

Re: [sqlite] Database locked problem on Windows 7

Hello all, About four weeks ago, I sent the email quoted below to the list, but unfortunately, as far as I can tell, I have so far received no response. TL;DR: Concurrent attempts to exclusively lock the database tend to fail on Windows 7 Pro, there is no similar problem on Windows 10. Th

[sqlite] Database locked problem on Windows 7

Hello all, I am working on a project involving the Python SQLite3 API for SQLite (a compile cache system), and I have started running into "database locked" problems on the Windows 7 Pro machines some of the instances will run on; the Windows 10 instances works without any problems. The database

Re: [sqlite] database locked on select

I have to query an external resource for each row. Unfortunately nothing I can do in a single update query. Would mean keeping a lot of data manually in memory. On Mon, May 28, 2018 at 2:33 AM Abroży Nieprzełoży < abrozynieprzelozy314...@gmail.com> wrote: > BTW why not to update all rows by singl

Re: [sqlite] database locked on select

Message- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of Deon Brewis >Sent: Sunday, 27 May, 2018 16:50 >To: SQLite mailing list >Subject: Re: [sqlite] database locked on select > >By one connection doing SELECT and UPDATE, do you mean m

Re: [sqlite] database locked on select

BTW why not to update all rows by single update query? 2018-05-27 20:30 GMT+02:00, Torsten Curdt : > I am doing a select, then iterate through the resultset and on each row > call update on that row. > I am using the golang driver and ran into the issue that on the update the > database is still l

Re: [sqlite] database locked on select

There is no multi threading. Just a single thread and only one connection/handle. While iterating through the resultset I am also trying to execute an update for every row. Along the lines of: resultset = db.exec(`select`) foreach row in resultset { db.exec(`update`) } I don't want to r

Re: [sqlite] database locked on select

On 27 May 2018, at 11:49pm, Deon Brewis wrote: > By one connection doing SELECT and UPDATE, do you mean multi-threaded mode > and using the connection from 2 threads? A connection cannot lock the database against itself. If you are doing two operations with one connection, there can be no SQL

Re: [sqlite] database locked on select

By one connection doing SELECT and UPDATE, do you mean multi-threaded mode and using the connection from 2 threads? - Deon -Original Message- From: sqlite-users On Behalf Of Simon Slavin Sent: Sunday, May 27, 2018 3:39 PM To: SQLite mailing list Subject: Re: [sqlite] database locked

Re: [sqlite] database locked on select

On 27 May 2018, at 7:30pm, Torsten Curdt wrote: > I am doing a select, then iterate through the resultset and on each row > call update on that row. > I am using the golang driver and ran into the issue that on the update the > database is still locked from the select. Are you usihg one connecti

[sqlite] database locked on select

I am doing a select, then iterate through the resultset and on each row call update on that row. I am using the golang driver and ran into the issue that on the update the database is still locked from the select. https://github.com/mattn/go-sqlite3/issues/569 I have read http://www.sqlite.org/

[sqlite] Database locked error with only one process?

I read around, and it seems that the consensus is it should only be locked during a multi-thread/multi-process update. However I encountered the error in a python script (single proc/single thread) that was the only reader/writer to the database. It seems that I forgot to con.commit() in a loop

[sqlite] Database locked error with only one process?

On 30 Dec 2015, at 5:12pm, Jason H wrote: > I read around, and it seems that the consensus is it should only be locked > during a multi-thread/multi-process update. Nope. The database is locked any time a transaction is under way [1]. Your program cannot know if another process is going to

Re: [sqlite] database locked in PHP

Maybe you can use the (linux, c) code I posted recently to determine which process/thread is locking the database file. -Ursprüngliche Nachricht- Von: Lev [mailto:leventel...@gmail.com] Gesendet: Sonntag, 25. Jänner 2015 01:36 An: sqlite-users@sqlite.org Betreff: Re: [sqlite] database

Re: [sqlite] database locked in PHP

On 01/25/2015 07:35 AM, Lev wrote: On Sat, 24 Jan 2015 20:59:22 + Simon Slavin wrote: and set it to 6 (60 seconds) or so. Okay, I try that, but I still don't understand how can a single threaded application get a locked error. Was the error message "database is locked" or "database

Re: [sqlite] database locked in PHP

On Sat, 24 Jan 2015 20:59:22 + Simon Slavin wrote: > and set it to 6 (60 seconds) or so. Okay, I try that, but I still don't understand how can a single threaded application get a locked error. Levente ___ sqlite-users mailing list sqlite-use

Re: [sqlite] database locked in PHP

On 24 Jan 2015, at 8:13pm, Lev wrote: > I sometimes get a database locked error when I access the database by > calling the execute() call. This is on PHP. Have you set a timeout ? Immediately after opening the connection use and set it to 6

[sqlite] database locked in PHP

Hi list, I'm currently working on a www frontend that uses SQLite. I sometimes get a database locked error when I access the database by calling the execute() call. This is on PHP. Reading the document http://www.sqlite.org/rescode.html#locked I learned that locked error occurs only on the sa

[sqlite] Database Locked Error

Dear All, Can you please help me in solving below error.When I am compiling sqlite 3.6.12 on UCLINUX. Error : database locked or Can you please assist me in executing sqlite 3.6.12 on UCLINUX. -- Thanks & Regards, Mohammed Aijas +91-9642933393 ___ sql

Re: [sqlite] Database locked after read

> I have found that when using SQLite under Windows if you execute an update > statement and then a select statement, the database is locked until the > select statement is finished. How can I stop this from happening? Note that you don't have to execute UPDATE before the SELECT to reproduce that

[sqlite] Database locked after read

I have found that when using SQLite under Windows if you execute an update statement and then a select statement, the database is locked until the select statement is finished. How can I stop this from happening? Here is a simple test program that simulates this situation. If you run the pro

Re: [sqlite] Database locked in multi process scenario

On 2/10/2012 2:57 PM, Marc L. Allen wrote: MSSQL in its default serialization mode does not guarantee repeatable reads within a transaction. But, it provides locking hints to help enforce it when required. I'm guessing that sqlite does guarantee repeatable reads? SQLite implements only one tr

Re: [sqlite] Database locked in multi process scenario

> -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Igor Tandetnik > Sent: Friday, February 10, 2012 2:36 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Database locked in multi process scenario

Re: [sqlite] Database locked in multi process scenario

On 2/10/2012 12:29 PM, Sreekumar TP wrote: Can this situation be handled in sqlite - by upgrading the lock to a writer lock ? Since both applications use the same WAL file for read and writes, it shouldnt be a problem , because all changes will be in linear sequence ? Consider again: [1] BEG

Re: [sqlite] Database locked in multi process scenario

On 10 Feb 2012, at 5:55pm, Kit wrote: > 2012/2/10 Simon Slavin : >> On 10 Feb 2012, at 5:32pm, Kit wrote: >>> A situation in which I read from the database first and then changes >>> the data tells me that they are wrong questions. It is such a problem >>> to insert SELECT into UPDATE or INSERT?

Re: [sqlite] Database locked in multi process scenario

2012/2/10 Simon Slavin : > On 10 Feb 2012, at 5:32pm, Kit wrote: >> A situation in which I read from the database first and then changes >> the data tells me that they are wrong questions. It is such a problem >> to insert SELECT into UPDATE or INSERT? > > Why do you need to do a SELECT at all ?  C

Re: [sqlite] Database locked in multi process scenario

On 10 Feb 2012, at 5:32pm, Kit wrote: > 2012/2/10 Sreekumar TP : >> Though the example of $ is very intuitive, I am not suggesting that we >> drop one of the transaction and block the database forever (as it is >> happening now). Instead, it could be serialized such that two $100 >> transactions

Re: [sqlite] Database locked in multi process scenario

On Fri, Feb 10, 2012 at 11:45 AM, Sreekumar TP wrote: > There is no recovery from this situation- > The recovery from your situation is to reset or finalize the initial query that is holding the transaction option. > > If you try to rollback, you get the following error -"cannot rollback > save

Re: [sqlite] Database locked in multi process scenario

On 10 Feb 2012, at 5:29pm, Sreekumar TP wrote: > Can this situation be handled in sqlite - by upgrading the lock to a > writer lock ? Since both applications use the same WAL file for read and > writes, it shouldnt be a problem , because all changes will be in linear > sequence ? SQLite handle

Re: [sqlite] Database locked in multi process scenario

2012/2/10 Sreekumar TP : >  Though the example of $ is very intuitive, I am not suggesting that we > drop one of the transaction and block the database forever (as it is > happening now). Instead, it could be serialized such that two $100 > transactions are committed to the db. A situation in whic

Re: [sqlite] Database locked in multi process scenario

Can this situation be handled in sqlite - by upgrading the lock to a writer lock ? Since both applications use the same WAL file for read and writes, it shouldnt be a problem , because all changes will be in linear sequence ? Sreekumar On Fri, Feb 10, 2012 at 10:49 PM, Sreekumar TP wrote: >

Re: [sqlite] Database locked in multi process scenario

> On 2/10/2012 9:57 AM, Sreekumar TP wrote: > >> The last transaction should always be the final one. In a a >> multiprocess/threaded application how can one make assumptions on the >> order >> of updates? SQL does not have any concept of 'last transaction' or 'final transaction' or 'order of tr

Re: [sqlite] Database locked in multi process scenario

Though the example of $ is very intuitive, I am not suggesting that we drop one of the transaction and block the database forever (as it is happening now). Instead, it could be serialized such that two $100 transactions are committed to the db. On Fri, Feb 10, 2012 at 10:33 PM, Igor Tandetnik wr

Re: [sqlite] Database locked in multi process scenario

On 2/10/2012 11:45 AM, Sreekumar TP wrote: There is no recovery from this situation- If you try to rollback, you get the following error -"cannot rollback savepoint, SQL statments in progress" or if you dont use SAVEPOINT - "cannot rollback, no transaction is active" If you start the transactio

Re: [sqlite] Database locked in multi process scenario

On 2/10/2012 9:57 AM, Sreekumar TP wrote: The last transaction should always be the final one. In a a multiprocess/threaded application how can one make assumptions on the order of updates? There are two updates in my example: update t set count = count + 1; update t set count = count + 10; D

Re: [sqlite] Database locked in multi process scenario

On 10 Feb 2012, at 4:45pm, Sreekumar TP wrote: > There is no recovery from this situation- > > If you try to rollback, you get the following error -"cannot rollback > savepoint, SQL statments in progress" or if you dont use SAVEPOINT - > "cannot rollback, no transaction is active " > If you sta

Re: [sqlite] Database locked in multi process scenario

There is no recovery from this situation- If you try to rollback, you get the following error -"cannot rollback savepoint, SQL statments in progress" or if you dont use SAVEPOINT - "cannot rollback, no transaction is active " If you start the transaction with BEGIN IMMEDIATE in App1, the writer i

Re: [sqlite] Database locked in multi process scenario

On 10 Feb 2012, at 3:01pm, Marc L. Allen wrote: > From my background, I'm used to SQL statements blocking until appropriate > locks are acquired. From what I've seen, it looks like sqlite doesn't block, > but returns BUSY, is that correct? You can set a timeout. SQLite tries and retries unti

Re: [sqlite] Database locked in multi process scenario

und them.) > > Thanks > > > -Original Message- > > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > > boun...@sqlite.org] On Behalf Of Marc L. Allen > > Sent: Friday, February 10, 2012 9:45 AM > > To: General Discussion of SQLite Database &g

Re: [sqlite] Database locked in multi process scenario

haven't found them.) Thanks > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Marc L. Allen > Sent: Friday, February 10, 2012 9:45 AM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] D

Re: [sqlite] Database locked in multi process scenario

The last transaction should always be the final one. In a a multiprocess/threaded application how can one make assumptions on the order of updates? Sreekumar On Fri, Feb 10, 2012 at 8:16 PM, Igor Tandetnik wrote: > Sreekumar TP wrote: > > How is this different from two threads each with a db

Re: [sqlite] Database locked in multi process scenario

Sreekumar TP wrote: > How is this different from two threads each with a db connection in a > single process? If each thread uses its own separate connection, it should be no different - you would observe the same issue. > Moreover the journal mode is WAL. Hence the writer should be able to app

Re: [sqlite] Database locked in multi process scenario

February 10, 2012 9:43 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Database locked in multi process scenario > > Marc L. Allen wrote: > > I see. So, the implied commit doesn't occur until you finalize? > > Or reset. > > > As a result, the su

Re: [sqlite] Database locked in multi process scenario

on't hit a BUSY. > > > -Original Message- > > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > > boun...@sqlite.org] On Behalf Of Richard Hipp > > Sent: Friday, February 10, 2012 9:28 AM > > To: General Discussion of SQLite Database > > Subjec

Re: [sqlite] Database locked in multi process scenario

Marc L. Allen wrote: > I see. So, the implied commit doesn't occur until you finalize? Or reset. > As a result, the subsequent update in step 5 was added to his > non-finalized select? The update was attempted within the same transaction. > Still.. what is the correct way to handle the expli

Re: [sqlite] Database locked in multi process scenario

ruary 10, 2012 9:28 AM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Database locked in multi process scenario > > On Fri, Feb 10, 2012 at 9:19 AM, Marc L. Allen > wrote: > > > > > So, you're assuming the OP actually started a transaction? B

Re: [sqlite] Database locked in multi process scenario

you're saying that this causes a problem if App2 gets in > between App1's SELECT and UPDATE? > > > -Original Message- > > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > > boun...@sqlite.org] On Behalf Of Richard Hipp > > Sent: Friday, Februar

Re: [sqlite] Database locked in multi process scenario

d Hipp > Sent: Friday, February 10, 2012 9:13 AM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Database locked in multi process scenario > > On Fri, Feb 10, 2012 at 9:05 AM, Rob Richardson con.com>wrote: > > > Isn't it almost a requirement of a

Re: [sqlite] Database locked in multi process scenario

012 8:52 AM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Database locked in multi process scenario > > In the real code, there is no sleep/wait or pause. It so happens that the > write of the app2 is scheduled in between. > > What you are suggesting

Re: [sqlite] Database locked in multi process scenario

t; > To: General Discussion of SQLite Database > > Subject: Re: [sqlite] Database locked in multi process scenario > > > > > > On 10 Feb 2012, at 1:52pm, Sreekumar TP wrote: > > > > > In the real code, there is no sleep/wait or pause. It so happens that >

Re: [sqlite] Database locked in multi process scenario

Sent: Friday, February 10, 2012 8:52 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Database locked in multi process scenario In the real code, there is no sleep/wait or pause. It so happens that the write of the app2 is scheduled in between. What you are suggesting is that a

Re: [sqlite] Database locked in multi process scenario

ze. > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Simon Slavin > Sent: Friday, February 10, 2012 8:55 AM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Database locked in multi proce

Re: [sqlite] Database locked in multi process scenario

On 10 Feb 2012, at 1:52pm, Sreekumar TP wrote: > In the real code, there is no sleep/wait or pause. It so happens that the > write of the app2 is scheduled in between. > > What you are suggesting is that at any point of time only one process can > have a transaction open in a database? I unders

Re: [sqlite] Database locked in multi process scenario

In the real code, there is no sleep/wait or pause. It so happens that the write of the app2 is scheduled in between. What you are suggesting is that at any point of time only one process can have a transaction open in a database? Sreekumar On Feb 10, 2012 7:12 PM, "Simon Slavin" wrote: > > On

Re: [sqlite] Database locked in multi process scenario

On 10 Feb 2012, at 1:32pm, Sreekumar TP wrote: > well, the 'wait' is a simulation of what happens in the real code. > > The error is fatal to the application as it never ever recovers from it > even though the writer has finalized and terminated. In a multi-process environment I recommend that

Re: [sqlite] Database locked in multi process scenario

Hi Simon, well, the 'wait' is a simulation of what happens in the real code. The error is fatal to the application as it never ever recovers from it even though the writer has finalized and terminated. Sreekumar On Feb 10, 2012 6:57 PM, "Simon Slavin" wrote: > > On 10 Feb 2012, at 11:47am, Sre

Re: [sqlite] Database locked in multi process scenario

On 10 Feb 2012, at 11:47am, Sreekumar TP wrote: > I have a 'database is locked' issued which can be reproduced as follows. > > I have two applications opening the database in WAL mode. The threading > mode is SERIALIZED. Environment is PC/Linux. > > > > Step1: Launch App1 followed by App 2

Re: [sqlite] Database locked in multi process scenario

How is this different from two threads each with a db connection in a single process? Moreover the journal mode is WAL. Hence the writer should be able to append changes to the WAL file as there are no other write transaction. Sreekumar On Feb 10, 2012 6:22 PM, "Richard Hipp" wrote: > On Fri, F

Re: [sqlite] Database locked in multi process scenario

On Fri, Feb 10, 2012 at 6:47 AM, Sreekumar TP wrote: > I have a 'database is locked' issued which can be reproduced as follows. > > I have two applications opening the database in WAL mode. The threading > mode is SERIALIZED. Environment is PC/Linux. > > > > Step1: Launch App1 followed by App 2

[sqlite] Database locked in multi process scenario

I have a 'database is locked' issued which can be reproduced as follows. I have two applications opening the database in WAL mode. The threading mode is SERIALIZED. Environment is PC/Linux. Step1: Launch App1 followed by App 2 ( same executables) Step 2: App1 Prepares a SELECT statement and e

[sqlite] Database Locked

I'm using sqlite v3 as database backend for an very small web app (some of 20 concurrent users -really serial access users-).. in Ms. Win xp (my test/develop env.) it work perfectly...my web app can handle that load(and even more by My JMeter Tests)... But on my production environment (L

[sqlite] Database Locked

I'm using sqlite v3 as database backend for an very small web app (some of 20 concurrent users -really serial access users-).. in Ms. Win xp (my test/develop env.) it work perfectly...my web app can handle that load(and even more by My JMeter Tests)... But on my production environment (L

Re: [sqlite] Issue "sqlite database locked"

On Mar 26, 2010, at 12:40 AM, wrote: > Hi, > > > I have downloaded the sqlite from the link > http://www.sqlite.org/download.html > version sqlite-3.6.23.so.gz sqlite-3.6.23.so.gz> (220.62 KiB). I am using fedora -9-i386. Have > mounted a > Shared drive on my pc

[sqlite] Issue "sqlite database locked"

Hi, I have downloaded the sqlite from the link http://www.sqlite.org/download.html version sqlite-3.6.23.so.gz (220.62 KiB). I am using fedora -9-i386. Have mounted a Shared drive on my pc to the fedora image.I copied the extracted sqlite db and saved

[sqlite] 'database locked' error

Hello, I would like to pass cookies back and forth between a search script I have written that runs on the local system, and javascript pages displaying the forms and results in Firefox. I'll forego all the gory details here, it is working pretty well, but being able to pass cookies back and for

[sqlite] Database Locked

I am writing a php script to back up mysql to sqlite(3) via PDO My process is : -- Create SQLite database connection Loop several tables Describe mysql table Drop sqlite table if exists, Create matching sqlite table query mysql table for recordset. insert r

Re: [sqlite] Database locked error, while deleting

he shared cache mode or not. Thanks, JP - Original Message From: D. Richard Hipp <[EMAIL PROTECTED]> To: General Discussion of SQLite Database Sent: Tuesday, June 10, 2008 7:30:09 AM Subject: Re: [sqlite] Database locked error, while deleting On Jun 10, 2008, at 10:18 AM,

Re: [sqlite] Database locked error, while deleting

On Jun 10, 2008, at 10:18 AM, Shailesh Birari wrote: > Richard, > Just to go one step ahead, If there are independent connections, do > you > mean that there can exist multiple transactions at the same time? I > think not since the first transaction (write) will exclusively lock > the > datab

Re: [sqlite] Database locked error, while deleting

abase > Subject: Re: [sqlite] Database locked error, while deleting > > > On Jun 10, 2008, at 7:36 AM, Sabyasachi Ruj wrote: > > > Hi, > > > > I have a very big table with around 40,00, 000 rows. 4 columns. 220 > > MB. > > > > Now, I have tw

Re: [sqlite] Database locked error, while deleting

Our PRAGMA cache_size = 4000. Is there any recommended way to calculate the cache size needed? On Tue, Jun 10, 2008 at 5:29 PM, Igor Tandetnik <[EMAIL PROTECTED]> wrote: > "Sabyasachi Ruj" <[EMAIL PROTECTED]> > wrote in message > news:[EMAIL PROTECTED]<[EMAIL PROTECTED]> > > Now, I have two thre

Re: [sqlite] Database locked error, while deleting

We are using two different connections to sqlite for these two different threads. So, we are not sharing the connection in SELECT and the DELETE thread. On Tue, Jun 10, 2008 at 5:28 PM, D. Richard Hipp <[EMAIL PROTECTED]> wrote: > > On Jun 10, 2008, at 7:36 AM, Sabyasachi Ruj wrote: > > > Hi, > >

Re: [sqlite] Database locked error, while deleting

"Sabyasachi Ruj" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Now, I have two threads:- > Thread1: Is deleting 7,00, 000 rows from the table. > Thread2: Is doing SELECT on the same table. > > Now the problem is sometimes the sqlite3_prepare for the SELECT query > is failing with SQ

Re: [sqlite] Database locked error, while deleting

Sabyasachi Ruj wrote: Hi, Hello there! I have a very big table with around 40,00, 000 rows. 4 columns. 220 MB. Now, I have two threads:- Thread1: Is deleting 7,00, 000 rows from the table. Thread2: Is doing SELECT on the same table. Now the problem is sometimes the sqlite3_prepare for the

Re: [sqlite] Database locked error, while deleting

On Jun 10, 2008, at 7:36 AM, Sabyasachi Ruj wrote: > Hi, > > I have a very big table with around 40,00, 000 rows. 4 columns. 220 > MB. > > Now, I have two threads:- > Thread1: Is deleting 7,00, 000 rows from the table. > Thread2: Is doing SELECT on the same table. > > Now the problem is sometim

Re: [sqlite] Database locked error, while deleting

On Jun 10, 2008, at 7:50 AM, Alex Katebi wrote: > There can only be one prepare per table at a time. The first prepare > has to > be finalized before another one. Table is locked by the first > prepare until > finalized. > Actually, there is no limit on the number of prepared statements on a

Re: [sqlite] Database locked error, while deleting

There can only be one prepare per table at a time. The first prepare has to be finalized before another one. Table is locked by the first prepare until finalized. On Tue, Jun 10, 2008 at 7:36 AM, Sabyasachi Ruj <[EMAIL PROTECTED]> wrote: > Hi, > > I have a very big table with around 40,00, 000 ro

[sqlite] Database locked error, while deleting

Hi, I have a very big table with around 40,00, 000 rows. 4 columns. 220 MB. Now, I have two threads:- Thread1: Is deleting 7,00, 000 rows from the table. Thread2: Is doing SELECT on the same table. Now the problem is sometimes the sqlite3_prepare for the SELECT query is failing with SQLITE_BUSY

Re: [sqlite] Database locked version 3.3.17

Resolved the issue. My issue on the app side. I think the newer version is much faster. So much so that it changed timing characteristics and reveald a logic bug in my code. Appologies, Ken Ken <[EMAIL PROTECTED]> wrote: Hi all, Think I may have hit some form of a bug in 3.3.

[sqlite] Database locked version 3.3.17

Hi all, Think I may have hit some form of a bug in 3.3.17: At an insert statement I'm getting a rc=[5] msg=[database is locked] When I recompile the sqlite using version 3.3.13 and re-run the appliation. No problems. Sorry this is pretty vague.. I'll try digging in more and finding more

[sqlite] database locked

Hello, I encounter the following difficulties with sqlite3: I have 4 different processes working on an sqlite3 database. When the "sql timeout" (set by "sqlite3_busy_timeout") is set to 5 seconds and that all processes are running on a same windows machine, it seems OK (I am not 100% sure o

Re: [sqlite] Database Locked

You have to find what is locking the database and unlock it. Lloyd wrote: I have tracked down the problem and found th following. I have a select statement which stores the result set in a pointer variable. If the result set of select statement is empty, the program executes, otherwise it gives

Re: [sqlite] Database Locked

Thanks Clay Dowling, Yes there is a function for fanalize function. Now the problem is solved. On Tue, 2006-11-14 at 08:02 -0500, Clay Dowling wrote: > Lloyd, > > You need at some point to call the sqlite3_finalize function. I don't use > wxSqlite, but if it's not handled by the destructor of

Re: [sqlite] Database Locked

Lloyd, You need at some point to call the sqlite3_finalize function. I don't use wxSqlite, but if it's not handled by the destructor of the recordset then there should be a method, possibly called finalize or close, that needs to be called. I recommend consulting the documentation for wxSQLite

Re: [sqlite] Database Locked

I have tracked down the problem and found th following. I have a select statement which stores the result set in a pointer variable. If the result set of select statement is empty, the program executes, otherwise it gives a Database Locked error. How can I solve this problem ? Thanks again,

[sqlite] Database Locked

Hi, I have opened a database, created tables and inserted data to it in a single transaction. Then I have closed the data base. Then I reopened the database and tried to update the table entries. But it throws an exception called Database Locked. Where can be the mistake? I am using wxSqlite3 wra

Re: [sqlite] database locked

On 8/21/06, Laura Longo <[EMAIL PROTECTED]> wrote: Hi all, I'm a software developer and I'm using sqlite3 for my application in c++. This is the problem I've found: two processes do queries (about 1 query per second) on one database; the 'select' queries don't have any problem, while 'update' q

[sqlite] database locked

Hi all, I'm a software developer and I'm using sqlite3 for my application in c++. This is the problem I've found: two processes do queries (about 1 query per second) on one database; the 'select' queries don't have any problem, while 'update' queries find problems after 1 or 2 days that the proc

Re: [sqlite] Database locked. Any idea ?

PM Please respond to sqlite-users@sqlite.org To sqlite-users@sqlite.org cc Subject Re: [sqlite] Database locked. Any idea ? [EMAIL PROTECTED] wrote: > > Anyone has an idea of what may be wrong ? Oh yeah, I am running of my own > port using uCos and a memory database. >

Re: [sqlite] Database locked. Any idea ?

Sqlite3BtreeCursor wrFlag = 0; Any idea how my table should be unlocked ? Mario Hebert Legerity [EMAIL PROTECTED] 06/20/2006 03:07 PM Please respond to sqlite-users@sqlite.org To sqlite-users@sqlite.org cc Subject Re: [sqlite] Database locked. Any idea ? [EMAIL

RE: [sqlite] Database locked. Any idea ?

Hi, I don't know if I can help you with your problem, but I'm interested in what you are trying to do, are u using uCos on a Z-World based system? Kind regards, Lodewijk Duymaer van Twist

Re: [sqlite] Database locked. Any idea ?

Yes I am using a :memory: database created from 3 flash database that were previously attached to it. I am not quite sure of the amount of work that would be required for me to port it to linux. I will try later today to build it under cygwin and see if the same behavior occurs. Regards, Mar

Re: [sqlite] Database locked. Any idea ?

[EMAIL PROTECTED] wrote: > > Anyone has an idea of what may be wrong ? Oh yeah, I am running of my own > port using uCos and a memory database. > You say you are using a ":memory:" database and this is happening? Can you provide a test program running under Linux? -- D. Richard Hipp <[EMAIL

[sqlite] Database locked. Any idea ?

I have created a database, this table has multiple tables. The tables are accessed through APIs. I have a particular problem with one of my table. I have written a few APIs for it. One API is used to Set (add or update) a record to it, one is used to retrieve the actual records in the table, o

[sqlite] Database Locked Error... problem still persists

Hi, Background Info - 1. Using Linux kernel v2.4.21 on both machines. 2. Scenario in which this problem occurs - when I rlogin/rsh to another machine and then run the app calls to sqlite3_open() work successfully calls to sqlite3_exec() return 'database is locked' error message 3. This

Re: [sqlite] Database Locked Error

I used the fuser and lsof commands and found out that no other process is accessing the database file. So it seems that the assumption of another process accessing the file was wrong. Though the problem still remains unsolved. Thanks Ritesh On Tue, 2006-01-31 at 18:02, Christian Smith wrote: >

Re: [sqlite] Database Locked Error

I've tried to copy/paste and simplify the code. Please assume that the sql query on line #19 is correct, its actually longer so i truncated it. getDB() returns _db. I checked the value of _db after the sqlite3_open() fn call its a valid handle. I'm trying to understand fuser and lsof commands a

Re: [sqlite] Database Locked Error

On Tue, 31 Jan 2006, Ritesh Kapoor wrote: >Regarding the configuration of NFS - >I have two machines with NFS on them. >- if i run the app on machine 1 it works properly >- now when i run the app on machine 2 it works properly > >But if I login to machine 2 from machine 1 and then run the app I ge

  1   2   >