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 an NFS filesystem. The locking is busted on some (many?) implementations of NFS, resulting in behavior like shown above. Your work-around is to copy the database to a local filesystem that actually supports posix advisory locks. -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
