On Tue, 3 May 2005, Tom Shaw wrote:
At 6:09 PM -0400 5/3/05, D. Richard Hipp wrote:
On Tue, 2005-05-03 at 17:45 -0400, Tom Shaw wrote:
Hi.
I was using SQLite with PHP 5 (MacOSX) and due to some issues the php
page timedout before completing the DB update. Now I can't read the
DB via php nor via the sqlite command line tool. I keep getting DB
busy/DB locked. How do I repair the DB and remove the "lock"and
either 1) try to recover the data in the DB or 2) verify the data is
OK and begin to reuse.
SQLite is suppose to automatically repair itself. If you
are getting "locks" that stick around, it must mean that PHP
is somehow holding the database open (and locked) after it
times out. Try shutting down and restarting your webserver
and see if that doesn't clear the problem.
Richard,
I restarted Apache - No luck :-) Any other ideas?
The current DB is only 144K if you want to look at it.
is your db nfs mounted?
-a
--
===============================================================================
| email :: ara [dot] t [dot] howard [at] noaa [dot] gov
| phone :: 303.497.6469
| renunciation is not getting rid of the things of this world, but accepting
| that they pass away. --aitken roshi
===============================================================================