Re: [sqlite] database permanently locked

2006-12-05 Thread Matt Sergeant
On 3-Dec-06, at 7:24 AM, [EMAIL PROTECTED] wrote: Max Barry <[EMAIL PROTECTED]> wrote: 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:

Re: [sqlite] database permanently locked

2006-12-03 Thread John Stanton
Have you tried using lsof to report what is holding your file open? Can you copy the file? Max Barry wrote: Christian Smith wrote: Max Barry uttered: My database is permanently locked, and I've spent two fruitless days trying to unlock it. You haven't said what sort of box this is. I

Re: [sqlite] database permanently locked

2006-12-03 Thread Max Barry
Christian Smith wrote: > Max Barry uttered: > > My database is permanently locked, and I've spent two fruitless days > trying to unlock it. > > You haven't said what sort of box this is. I guess a generic Unix. If Linux, > you'll probably have fuser installed. Run fuser against the

Re: [sqlite] database permanently locked

2006-12-03 Thread drh
Max Barry <[EMAIL PROTECTED]> wrote: > 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 > Is the database on

Re: [sqlite] database permanently locked

2006-12-02 Thread Christian Smith
Max Barry uttered: My database is permanently locked, and I've spent two fruitless days trying to unlock it. You haven't said what sort of box this is. I guess a generic Unix. If Linux, you'll probably have fuser installed. Run fuser against the database file, and it'll tell you the PID

[sqlite] database permanently locked

2006-12-02 Thread Max Barry
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