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
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
SQLite version 3.6.23.1
Enter ".help" for instructions
Enter SQL statemen
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
Hi,
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.
there is only one connection open. In the connection string connection
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
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 finalizing
the statements.
After a while I start getting back "data
I expect that this has been asked before but I cant find anything
useful via google.
I am updating about 20 rows in a table and setting a particular value
to a particular value. The first time I do this all is OK, if I try
again a few seconds later I get a database is locked error.
The code is (u
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
Greetings,
I've been using sqlite-3.4.2 for a customer-only website for a few years
now and the number of users has recently grown to the point where I'm now
seeing too many "database is locked(5)" (i.e. busy) errors.
When my code gets a "database is locked(5)" error, it sleeps for a random
perio
> 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
I am running into a "database is locked" error and I don't quite
understand what is going on. If someone could explain what is happening,
I'd appreciate it. (I am using sqlite version 3.6.17 on Windows XP.)
A busy handler callback has been set up with sqlite3_busy_handler(). In
addition to some
QLite database is locked
message. Thank you
Retval = Keys->Execute("BEGIN EXCLUSIVE");
sprintf(Command,"SELECT [Key], [RowId], [DupeGroup] "
"FROM [Keys] WHERE [Cluster]=\"%*.*s\"",BlockSize,BlockSize,_Key);
Keys->Pre
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
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
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 database:
sprintf(Command,"INSERT INTO [Keys] ([Key], [Cluster], "
"[DupeGroup]) V
My problem is get a "database is locked" error using lastest linux kernel
(above 2.6.28) , while the code can run smoothly on linux 2.6.26.2
kernel(vmware pc686 host) and on 2.6.26.3 kernel(arm9 embed system).
The problem code is:
#if 1
if (sqlite3_exec(gJcDb, "PRAGMA cache_size = 4000", NUL
My problem is get a "database is locked" error using lastest linux kernel
(above 2.6.28) , while the code can run smoothly on linux 2.6.26.2
kernel(vmware pc686 host) and on 2.6.26.3 kernel(arm9 embed system).
The problem code is:
#if 1
if (sqlite3_exec(gJcDb, "PRAGMA cache_size = 4000", NU
My problem is get a "database is locked" error using lastest linux kernel
(above 2.6.28) , while the code can run smoothly on linux 2.6.26.2
kernel(vmware pc686 host) and on 2.6.26.3 kernel(arm9 embed system).
The problem code is:
#if 1
if (sqlite3_exec(gJcDb, "PRAGMA cache_size = 4000", N
This is an answer to the post of Dr. Hipp to my question. I tried several
times to send the mail as
"Re: [sqlite] database is locked and is malformed" but it did not work. So
I have to create a new thread.
Hello Dr. Hipp,
thank you for your response. First off all I want to apolog
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 afterwards. We used version 3.4.2 for a long time, 2
month ago we cha
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
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 afterwards. We used version 3.4.2 for a long time, 2
month ago we cha
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]>
> S
I have some code that i'm having problems with. i open the database,
prepare, and the step through. During each step i'm trying to run a
seperate exec which is attempting to update a row. I keep getting a error
that says database is locked. I tried creating a additional open to just
use on
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
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" error message on any type of query that is ran after
the database is
"opened". I am assuming t
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
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 instructions
sqlite> create table
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
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 to the development mac and log into the other mac as the user who
owns that db file.
the path on my dev mac to that
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
Hello,
I'm getting this error sometimes when calling a single SELECT
statement via sqlite3.so library while (I guess) cron daemon is
updating the same table with the sqlite3 command line tool like:
buildsqlcmd | sqlite3 /path/database.db
where buildsqlcmd is a simple utility that outpu
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
On 3/10/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
T&B <[EMAIL PROTECTED]> wrote:
> Can someone please tell me (politely ;-) where to put the -
> DSQLITE_ENABLE_LOCKING_STYLE=1
>
> I tried inserting it arbitrarily in the Makefile.in file but it
> didn't seem to make a difference.
>
Do "con
T&B <[EMAIL PROTECTED]> wrote:
> Can someone please tell me (politely ;-) where to put the -
> DSQLITE_ENABLE_LOCKING_STYLE=1
>
> I tried inserting it arbitrarily in the Makefile.in file but it
> didn't seem to make a difference.
>
Do "configure". Then edit the Makefile that is generated.
--
h 2007 1:46:21 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] database is locked error on Mac OS X
Reply-To: sqlite-users@sqlite.org
I recently installed SQLite 3.3.13, after having used previous
versions. I now get an error:
Error: database is locked
This is not a bug in SQLite - it
I recently installed SQLite 3.3.13, after having used previous
versions. I now get an error:
Error: database is locked
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.
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
Hi all,
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'm not sure wha
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
I have multiple thread reading the database and a thread inserting in or
updating the database.
when i try to simulate this case by executing sqlite3 from shell by
beginning a transaction from a shell and retrieving data from other shell
eveything works fine.
But when it's the cas from my C progra
You cannot avoid it if you have competing processes accessing the same
database. What you have to do is synchronize access in your code.
anis chaaba wrote:
Hello
Please can you tell me how can i avoid having error message "database is
locked'?
thanks
---
anis chaaba <[EMAIL PROTECTED]> was heard to say:
> I have multiple thread reading the database and a thread inserting in or
> updating the database.
> when i try to simulate this case by executing sqlite3 from shell by
> beginning a transaction from a shell and retrieving data from other shell
>
I have multiple thread reading the database and a thread inserting in or
updating the database.
when i try to simulate this case by executing sqlite3 from shell by
beginning a transaction from a shell and retrieving data from other shell
eveything works fine.
But when it's the cas from my C progra
anis chaaba wrote:
Hello
Please can you tell me how can i avoid having error message "database is
locked'?
thanks
You will have to provide more details about exactly what you are doing
and how you are doing it for anybody to be able to assist you.
SQLite does support multiple process accessi
Hello
Please can you tell me how can i avoid having error message "database is
locked'?
thanks
Hello,
I have processes that access to my database, one writing on it and the other
just reading. when this case take place an error message occure saying that
database is locked.
I saw in sqlite3 docs that sqlite3 enable this type of access but i don't
know how can I activate this option.
Is that
This issue has been resolved. I did not call sqlite3_finalize() in the
reader process and kept the READ lock
How to read after the database was written by another process?
Reading function should wait until other process finishes writing and
unlocks the file. But in our case unlocking never happ
Many threads or process can read, but just one can write, and when is writen
the DB is locked, even for read.
How to read after the database was written by another process?
Reading function should wait until other process finishes writing and
unlocks the file. But in our case unlocking never hap
Many threads or process can read, but just one can write, and when is writen
the DB is locked, even for read.
On 16/01/07, Yuriy Martsynovskyy <[EMAIL PROTECTED]> wrote:
I have a problem with SQLite when accessing DB file from two processes.
Process 1 is writing to the database periodically in
I have a problem with SQLite when accessing DB file from two processes.
Process 1 is writing to the database periodically in autocommit mode.
Process 2 only reads from the same database file. After awhile Process
2 starts getting "Database is locked " error and can not read anymore
until you close
No problem when I try each routine seperately.
But simulraneous insertion and retrieval to/from one db by two thread in linux
result in the message "database is locked".
I need how to access recent data although it is being used by inserttion
operation.
Is there any idea to solve this?
I
Gerry Snyder wrote:
Steve Bergman wrote:
Yeah, I know my post was light on details and pretty general.
Basically, at this point I was wondering if anyone had any general
advice. Although I'm pretty sure I have seen this problem when I am
the only one in the application, the application has
Steve Bergman wrote:
Yeah, I know my post was light on details and pretty general.
Basically, at this point I was wondering if anyone had any general
advice. Although I'm pretty sure I have seen this problem when I am
the only one in the application, the application has been in
development,
Jay Sprenkle wrote:
To help debug it we'd need to see the code or get a good description.
Yeah, I know my post was light on details and pretty general.
Basically, at this point I was wondering if anyone had any general
advice. Although I'm pretty sure I have seen this problem when I am th
On 4/22/06, Steve Bergman <[EMAIL PROTECTED]> wrote:
> Hi All,
>
> I was wondering if anyone here had any comments on this thread on the
> Python TurboGears group:
>
> http://tinyurl.com/qhmyw
>
> Essentially, people are getting a Database is locked error from the ORM
> (SQLObject). The recommend
Hi All,
I was wondering if anyone here had any comments on this thread on the
Python TurboGears group:
http://tinyurl.com/qhmyw
Essentially, people are getting a Database is locked error from the ORM
(SQLObject). The recommendation seems to be "Don't use SQLite".
I am seeing this proble
If you want to use a lightweight DB like Sqlite and you are setting up
your own daemon and server situation then you can place the DB
synchronization function in the daemon around the Sqlite so that its
action is single streamed. In a similar situation we have installations
which manage many h
On Monday 20 March 2006 11:47, [EMAIL PROTECTED] wrote:
> BTW: Lots of people have multiple processes writing to the same
> SQLite database without problems - the SQLite website is a good
> example. I do not know what you are doing wrong to get the
> locking problems you are experiencing.
I don't
What i normally do in this scenario is just a simple
httpd service restart.
That normally does the trick because i am building an application also
with PHP/Sqlite.
On Mon, 2006-03-20 at 06:47 -0500, [EMAIL PROTECTED] wrote:
> Mark Robson <[EMAIL PROTECTED]> wrote:
> >
> > If the answer is "noth
Mark Robson <[EMAIL PROTECTED]> wrote:
>
> If the answer is "nothing", I'm going straight over to MySQL :)
>
The advantages of SQLite are that there are no administrative
hassles - there is nothing to set up or configure and the
database is contained in a single disk file that you can copy
to a
Hi all,
I'm using Sqlite3 from PHP via PDO.
My application was working fine as long as there was only one process
accessing the database, then I ran two instances at once. Now one of the
processes is getting
"Error message: SQLSTATE[HY000]: General error: 5 database is locked"
when trying to
101 - 200 of 211 matches
Mail list logo