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 som
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 thin
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
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
esendet: Mittwoch, 01. März 2017 21:45
An: SQLite mailing list
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 SysInternals and
&
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 set, might this
> cause "Data
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 commands you give to
make sure th
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 commands you give to
make sure they are SQLITE_OK ?
I’m not talking about
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 SysInternals and downloading the
package to see what has its grubby hands on the database. If Linux, as
root, run an LSOF (Lower case) a
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
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 :
>
> pack
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:
>>>
I'm trying to write some software in C{++}. Everything work
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 I get the error "Database is locked".
I am
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 locked".
>> I am only trying to retrieve the inf
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_master).
What comm
EXCLUSIVE\n" ,g_mode[v_mode]
,v_file, (v_ret = v_shared .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: M
,v_file, (v_ret = v_shared .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:
ard 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 wrote:
>> SQLite shell version 3.7.2
>> on Linux 2.6.18
>> NTFS
>
> On
ard 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 wrote:
>> SQLite shell version 3.7.2
>> on Linux 2.6.18
>> NTFS
>
> On Linux, S
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 wrote
__
> 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] database is locked
>
> On 1/14/15,
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:
Unmount the volume the database is on,
Subject: 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.
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 and
> I am rather sure that no on
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 not be reported to the end use
cember 03, 2014 3:21 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] "database is locked" for SQLITE_BUSY
>From https://www.sqlite.org/rescode.html#busy
In both cases there are specific extended codes that may further pinpoint the
source just in case you do not know
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 connection.
Simon.
al Discussion 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 timeo
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 write
> to the database when the current writ
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 the
> specified bu
I think the error messages are distinct enough as is.
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 the
specified bus
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
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 different SQLite result code
Although I think there is already an error result, one situation might be
when the DB is in a read only state.
On Wed, Dec 3, 2014 at 6:15 AM, RSmith wrote:
>
> On 2014/12/03 13:00, Jonathan Moules wrote:
>
>> Hi,
>> Just a quick request/suggestion.
>>
>> Currently SQLITE_BUSY events return an e
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 for "SQLite database lo
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 System.Windows.Forms.UnsafeNativeMethods.DispatchMessag
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 to leave the setting li
SQLite Database'
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-
di 27 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:1
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 : "Database is
> l
-
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 wrote:
>
: -vfs
> Use -help for a list 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: G
x1
sqlite3: Error: unknown option: -vfs
Use -help for a list 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
On Tue, Feb 19, 2013 at 4:39 PM, Choi, David wrote:
> Hi Richard,
>
> I think your guess is highly possible because the error comes from
> sqliteErrorFromPosixError(). In that case, how can I fix the issue?
>
Try adding the -vfs unix-none command-line option:
sqlite3 -vfs unix-none ex1
Th
Richard Hipp
Sent: Tuesday, February 19, 2013 9:44 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] database is locked with create
On Tue, Feb 19, 2013 at 12:01 PM, Choi, David wrote:
> Hi all,
>
> I am new to sqlite. I build sqlite with buildroot without any issue.
ehalf Of Simon Slavin
Sent: Tuesday, February 19, 2013 9:14 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] database is locked with create
On 19 Feb 2013, at 5:01pm, "Choi, David" wrote:
> I am new to sqlite. I build sqlite with buildroot without any issue. After
&
On Tue, Feb 19, 2013 at 12:01 PM, Choi, David wrote:
> Hi all,
>
> I am new to sqlite. I build sqlite with buildroot without any issue. After
> loading sqlite on my embedded board, I always get one error
> message:"database is locked".
>
> Here is my operation on my board:
>
> #sqlite3 ex1
> SQL
On 19 Feb 2013, at 5:01pm, "Choi, David" wrote:
> I am new to sqlite. I build sqlite with buildroot without any issue. After
> loading sqlite on my embedded board, I always get one error message:"database
> is locked".
>
> Here is my operation on my board:
>
> #sqlite3 ex1
> SQLite version
On Sun, 29 Jan 2012 17:11:35 +0200, Shahar Weinstein
wrote:
>hi,
>
>thanks for your intention. but it's a shared hosting. I do not have a
>remote desktop access that allows me
>to run any application I desire. and besides that there is no need to
>monitor processes.
Many of the sysinternal tools
On 29 Jan 2012, at 4:14pm, Shahar Weinstein wrote:
> no, its an ordinary website.
> the situation is simple. I'm trying to save into the database some data
> taken from a web form with one simple,
> update query. the database is being opened and then immidietly being closed.
So you do execute sq
no, its an ordinary website.
the situation is simple. I'm trying to save into the database some data
taken from a web form with one simple,
update query. the database is being opened and then immidietly being closed.
as I mentioned before. the problem appears. and than stays for
seconds,minutes or
On 29 Jan 2012, at 3:11pm, Shahar Weinstein wrote:
> the sqlite database I'm using is failing to
> serve one update from one process.
> and this problem comes and goes, and when it comes, it stays for some time.
Is this for a web-facing service ? In other words, someone looks up a page on
a we
> From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org]
> on behalf of Shahar Weinstein [shahar...@gmail.com]
> Sent: Sunday, January 29, 2012 9:03 AM
> To: General Discussion of SQLite Database
> Subject: EXT :Re: [sqlite] Database is Locked
>
> thanks for the
...@sqlite.org [sqlite-users-boun...@sqlite.org] on
behalf of Shahar Weinstein [shahar...@gmail.com]
Sent: Sunday, January 29, 2012 9:03 AM
To: General Discussion of SQLite Database
Subject: EXT :Re: [sqlite] Database is Locked
thanks for the reply.
but, I'm using a shared hosting running Windows. s
e.org]
> on behalf of Shahar Weinstein [shahar...@gmail.com]
> Sent: Sunday, January 29, 2012 8:40 AM
> To: General Discussion of SQLite Database
> Subject: EXT :Re: [sqlite] Database is Locked
>
> thanks for the reply but its not a permission issue, since after few hours
> the
_
From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on
behalf of Shahar Weinstein [shahar...@gmail.com]
Sent: Sunday, January 29, 2012 8:40 AM
To: General Discussion of SQLite Database
Subject: EXT :Re: [sqlite] Database is Locked
thanks for the reply but its not a permis
thanks for the reply but its not a permission issue, since after few hours
the problem dissapears
and there is no problem to save data into the database.
the problem comes, stays for few hours and than disappears.
it's very strange since on my development machine it does not happen.
Shahar.
20
Is the hosting company running linux or windows? You say .net so that
indicates to me windows, but I've been wrong before. (Wife lets me know
frequently. {smirk})
This still "smells" like a permission issue to me. I acknowledge that
you're able to read/write/modify the web files then upload
thanks for your reply.
since my situation IS one process that tries to write to the database, I'm
trying to use the forums help.
if the situation was multiple processes as you described I would move to
mysql or MSaccess database which is quite stable for web applications.
I've programmed few web pr
On Sun, Jan 29, 2012 at 12:57:21 +0200, Shahar Weinstein wrote:
> I don't think that the TMP folder is the right direction but I'll check it
> anyway with the hosting company.
No, *NOT* *HOSTING* *COMPANY*. Your code.
I agree it's probably not the right direction though.
> besides that, I do kno
I don't think that the TMP folder is the right direction but I'll check it
anyway with the hosting company.
besides that, I do know that there is only one process running that tries
to write to the database what makes my situation a sad joke. sqlite
supposed to be a strong database that knows how t
On 28 Jan 2012, at 11:47pm, Jan Hudec wrote:
> On Sun, Jan 29, 2012 at 00:43:07 +0200, Shahar Weinstein wrote:
>> I know there is no permissions problems since after some time when I try
>> the same action, it succeeds. in the website, I manage to read/write/delete
>> in different locations of th
On Sun, Jan 29, 2012 at 00:43:07 +0200, Shahar Weinstein wrote:
> I know there is no permissions problems since after some time when I try
> the same action, it succeeds. in the website, I manage to read/write/delete
> in different locations of the code.
Can it be that the database is really locke
hi,
thanks for your reply.
I know there is no permissions problems since after some time when I try
the same action,
it succeeds. in the website, I manage to read/write/delete in different
locations of the code.
and since the website is on a shared hosting I cannot modify the TMP
definitions, whic
On Sat, Jan 28, 2012 at 23:36:36 +0200, Shahar Weinstein wrote:
> I'm using System.Data.Sqlite the latest version that supports .NET 4
> in an ordinary .NET website.
> when trying to issue a single update to the database I'm receiving the
> error message saying that the database file is locked.
> t
On 01/26/2012 09:05 AM, Erik Fears wrote:
I have a writer, but the thread is not writing during this test.
This is built by me.
This is single process, one connection per thread, 100 threads.
The threads are being created/destroyed often, though, and each time one is
created it creates a new D
I have a writer, but the thread is not writing during this test.
This is built by me.
This is single process, one connection per thread, 100 threads.
The threads are being created/destroyed often, though, and each time one is
created it creates a new DB connection.
I understand this isn't ideal
On Wed, Jan 25, 2012 at 8:01 PM, Erik Fears wrote:
> I've got a WAL database with only readers right now. I'm opening and close
> the database
> at pretty rapid rate, and usually have about 100 connections open at a
> time. I'm
> using prepared statements for SELECTS and I'm pretty sure I'm final
On 12 Jul 2010, at 5:37am, raf wrote:
> Each page hit results in several database writes each of which is currently
> in a separate transaction. Is combining these into a single transaction likely
> to help or make matters worse? Or is this just an inappropriate use of sqlite?
It will probably m
> Does that seem correct?
Yes.
> If so, my options are:
>
> 1) rollback/commit one of the transactions
>
> 2) use begin exclusive
That's correct, but it's better to be 'begin immediate' than 'exclusive'.
> I don't think the second one will work, since I need nested transactions
> and the save
Thanks for the response Pavel. The order that the events were getting
logged wasn't accurate enough so I increased the timing precision for my
logging. I didn't leave anything out, but some commands were logged
slightly out of order.
Thread1 is doing reads and writes for a while, with Thread2
Apparently the following happens:
13875 Thread2 SAVEPOINT Thread2 success
(shared lock acquired)
13875 Thread1 SAVEPOINT Thread1 success
(shared lock acquired)
13880 Thread2 INSERT INTO TableB success
(reserved
Hello, Yesterday, we recognized that we had two concurrent SQL Server
threads reading and writing to the same sqlite database. Furthermore,the reader
thread was not releasing it's lock. So, now we release the lock by commiting
the transaction. As a result, we no longer get the SQLite databa
Jay Kreibich, Thank for your reply about sqlite3_busy_timeout. We
found that the sqlite 'database is locked' error message can be fixed by
updating two different tables in the two SQL Server 2005 client processes.
UPDATE mdMatchUp SET
MatchKey = master.dbo.mdMUIncrementalBuildKey
On Tue, Nov 10, 2009 at 06:04:20PM -0500, Frank Chang scratched on the wall:
>
> We have an application which uses Microsoft SQL Server 2005
> Extended stored procedures in conjunction with Sqlite databases.
> We have a C++ DLL which uses the following code to insert rows
> into a SQLite da
On May 13, 2009, at 4:09 AM, s.breith...@staubli.com wrote:
> We use QNX 6.3 on a ppc with sqlite as database for our application.
> As
> there was a speed problem in older sqlite versions we used the PRAGMA
> SYNCHRONOUS = OFF command before creating an INSERT and the PRAGMA
> SYNCHRONOUS = ON
it wont it was a quick example, that prep is suppose to be sqlite3_step
~Shaun
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
you don't need to prepare when you use exec...
The following is not a step.. Don't see how this even would compile...
while(sqlite3_prep(plineInfo) == SQLITE_ROW)
--- On Fri, 10/10/08, Shaun R. <[EMAIL PROTECTED]> wrote:
> From: Shaun R. <[EMAIL PROTECTED]>
> Subject: [sqlite] database is lock
On Aug 19, 2008, at 11:14 AM, <[EMAIL PROTECTED]> <[EMAIL PROTECTED]>
wrote:
> Are there
> any problems with creating the database with 3.5.7 and then reading
> it with 3.6.1?
There are not suppose to be any difference. Nobody else has reported
differences.
D. Richard Hipp
[EMAIL PROTECT
this, &m_sqliteErrMsg);
These are the two functions that are called. The open comes back successful,
but when
the exec is called it returns with a "database is locked" error.
> ---Original Message---
> From: Robert Simpson <[EMAIL PROTECTED]>
> Subject:
Show and tell time! Lets see some code :)
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Tuesday, August 19, 2008 8:15 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] "Database is Locked"
I haven
I haven't changed anything. I recompiled with 3.5.7 and it worked fine. Are
there
any problems with creating the database with 3.5.7 and then reading it with
3.6.1?
Thanks
> ---Original Message---
> From: D. Richard Hipp <[EMAIL PROTECTED]>
> Subject: Re: [
On Aug 19, 2008, at 10:33 AM, <[EMAIL PROTECTED]> <[EMAIL PROTECTED]>
wrote:
> I currently have a project that runs on a Windows XP machine. The
> project was working with
> SQLite 3.5.7, but I recently upgraded to 3.6.1 . Since the upgrade I
> have been getting
> an "Database is Locked" er
On Mon, Mar 3, 2008 at 12:59 PM, Andreas Kupries
<[EMAIL PROTECTED]> wrote:
> Is the database file by chance in a NFS mounted directory ?
That was it. Thanks!
Sean
--
"Humanity has advanced, when it has advanced, not because it has been
sober, responsible, and cautious, but because it has been
Sean Rhea wrote:
> sqlite> create table foo (node_id, timestamp, tput);
> SQL error: database is locked
>
> What am I doing wrong?
>
Sean,
Ensure that you have write privileges for the database file and the
directory it is in. SQLite needs to create a journal file in the same
directory for yo
>
> I must be missing something:
>
> $ sudo apt-get install sqlite3
> ...
> Selecting previously deselected package sqlite3.
> ...
> Setting up sqlite3 (3.3.8-1.1) ...
> $ ls -l test.db
> ls: test.db: No such file or directory
> $ sqlite3 test.db
> SQLite version 3.3.8
> Enter ".help" for instruc
low. And search the archives for "locked" in the subject.
Tom
From: T&B <[EMAIL PROTECTED]>
Date: 11 May 2007 10:54:02 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] database is locked error
Is there a timetable for including the fix for opening SQLite files
on
Can you do any other write queries (INSERT or UPDATE for example)?
On 8/2/07, Chase <[EMAIL PROTECTED]> wrote:
>
> running sqlite 3.4.1 on mac os x 10.4
>
> i've set up a file share on another mac running 10.4 and placed a small
> db file on the share and chmod'ed it to 777 (full access).
>
> i go
lite.org
Subject: Re: [sqlite] database is locked error
Following up an old thread:
The SQLite sources include an (Apple-supplied) patch to work around
the problem. Recompile
with
-DSQLITE_ENABLE_LOCKING_STYLE=1
We are working toward turning on this patch by default, but we are
not quite the
Following up an old thread:
The SQLite sources include an (Apple-supplied) patch to work around
the problem. Recompile
with
-DSQLITE_ENABLE_LOCKING_STYLE=1
We are working toward turning on this patch by default, but we are
not quite there yet.
I compiled and ran SQLite 3.3.17 and got
I'm experiencing the same problem on QNX compiled for Renesas SH4...
> This is not a bug in SQLite - it is a bug in Apple's implementation
>(or more precisely their lack of implementation) of POSIX advisory
> locks for AppleShare mounted volumes. The SQLite sources include
> an (Apple-supplied) p
Hi Richard and Puneet,
I just wanted to say thanks, and to record your combined advice that
worked. Much of this may be superfluous or painfully obvious, but it
worked:
1. In the sqlite-3.3.13 downloaded source directory, execute:
./configure
2. That creates a new file "MakeFile". Edit th
T&B <[EMAIL PROTECTED]> wrote:
>
> I recently installed SQLite 3.3.13, after having used previous
> versions. I now get an error:
>
> Error: database is locked
>
> when I use the sqlite3 command line tool to access a database on a
> shared volume.
>
> But opening the same file with an earli
I have the following sources which one would you like?
sqlite-2.8.16.tag.gz sqlite-3.3.8.tar.gz
sqlite-3.2.2.tar.gz sqlite-3.3.9.tar.gz
sqlite-3.2.8.tar.gz
sqlite-3.3.10.tar.gz
sqlite-3.3.12.tar.gz
sqlite-3.3.13.tar.gz
sqlite-3.3.5.tar.gz
sqlite-3.3.7.tar.gz
Ken
T&B <[EMAIL
> Where can I get 3.3.9 and earlier source code?
http://www.sqlite.org/sqlite-source-3_3_0.zip
...
http://www.sqlite.org/sqlite-source-3_3_9.zip
But it would be nice to have direct link on the website, or even better to
have tags for all releases in CVS.
---
Hi all,
Following up:
I recently installed SQLite 3.3.13, after having used previous
versions. I now get an error:
Error: database is locked
when I use the sqlite3 command line tool to access a database on a
shared volume.
But opening the same file with an earlier version works fine.
I
Andrew,
I wouldn't worry about it too much, at least your contributing.
There are quite a few threads regarding locking, concurrency and multi
threading.
IMHO, everyone would benefit from your modification. I would especially like
to be able to deal with Locking issues at the be
--- Andrew Teirney <[EMAIL PROTECTED]> wrote:
> If you are interested in the "BEGIN SHARED" transaction i posted a
> simple patch to this mailing list within the last month if i recall
> correctly.
http://www.mail-archive.com/sqlite-users@sqlite.org/msg21260.html
Do you find that using this BE
Andrew,
Nice modification.. Did you buy any chance post this into the sqlite ticketing system?
It would be nice if sqlite would let you acquire a shared lock via the BEGIN statement.
No i didn't actually post this to the ticketing system, to be honest i
am very new to all this open sou
Andrew,
Nice modification.. Did you buy any chance post this into the sqlite ticketing
system?
It would be nice if sqlite would let you acquire a shared lock via the BEGIN
statement.
Andrew Teirney <[EMAIL PROTECTED]> wrote: > I have multiple thread reading the
database and a threa
1 - 100 of 124 matches
Mail list logo
