My database is permanently locked, and I've spent two fruitless days
trying to unlock it.
The problem:
$ sqlite trac.db
SQLite version 3.3.6
Enter ".help" for instructions
sqlite> .databases
Error: database is locked
I believe this was caused by something bad happening in Trac 0.9.6. More
than
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
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
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
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
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
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
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
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
On 9/29/05, Gaurav Patole <[EMAIL PROTECTED]> wrote:
>
> Hello,
>
> I have a database file placed onto a NTFS LAN based local server.
> Application's on different machines tries to access this database file and
> update it frequently.
from: http://www.sqlite.org/cvstrac/wiki?p=WhenToUseSqlite
Hello,
I have a database file placed onto a NTFS LAN based local server.
Application's on different machines tries to access this database file and
update it frequently.
I am using Christian Werner's ODBC Driver. I am facing "Database is locked"
problem.
* Is concurrency weak in
D. Richard Hipp wrote:
Please run your program in a debugger and tell
me what the subroutine "isNT()" returns in os_win.c.
If it is returning false, that would explain your
occasional inability to get a read lock on a
read-only database.
Perhaps a windows programmer can suggest a better
isNT() returns 1(true)
I've only seen this database lock problem while access the db file on
the (slow) NAS - local file systems seem to work fine. Even accessing
it through one of our Windows shares seems to work fine. I'll keep
you posted if I find any more information related to this
Please run your program in a debugger and tell
me what the subroutine "isNT()" returns in os_win.c.
If it is returning false, that would explain your
occasional inability to get a read lock on a
read-only database.
Perhaps a windows programmer can suggest a better
implementation of the isNT()
ent.
Regards
Massimo
John Duprey <[EMAIL PROTECTED]> on 21/06/2005 22.59.12
Please respond to sqlite-users@sqlite.org
To:sqlite-users@sqlite.org
cc:
Subject:[sqlite] Database is locked on SELECT only calls?
Hi All,
I'm using sqlite 3.2.0 - the native C/C++ interface. I'm seeing
Hi All,
I'm using sqlite 3.2.0 - the native C/C++ interface. I'm seeing
something that I haven't seen before. I have 4 programs accessing the
same db file. The db file is on a slow Windows network share (NAS
device). The 4 programs are the only processes accessing the DB file
and all of them
[EMAIL PROTECTED] wrote:
[DQL statements ("SELECT ...") lock the whole database when using PySQLite.]
Hi,
I've thought about this whole issue and made a few changes to my local
working copy of PySQLite over the weekend, which will go into the next
release (during the next days):
The most
-- Initial Header ---
>From : "Gerhard Häring" [EMAIL PROTECTED]
To : "sqlite-users" [EMAIL PROTECTED]
Cc :
Date : Fri, 21 Nov 2003 16:43:26 +0100
Subject : Re: [sqlite] database is locked
> [EMAIL PROTECTED] wrote:
>
[EMAIL PROTECTED] wrote:
Hi all,
I'm trying SQLite with Zope
You're using PySQLite, right?
and it works fine, but when I use the browser's
[Stop] button to interrupt the request it gives me the message:
"database is locked" [...]
This happens when you have a connection that is within a
Hi all,
I'm trying SQLite with Zope and it works fine, but when I use the browser's
[Stop] button to interrupt the request it gives me the message:
"database is locked"
At this point it is not possible to continue the work unless I restart the Zope
daemon.
What can I do to avoid this
201 - 223 of 223 matches
Mail list logo