NFS.  The same test works fine in /tmp, which is apparently local.  I'll
report the problem to the host.  Thanks for the help.

On 9/15/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:

"Jay Johnston" <[EMAIL PROTECTED]> wrote:
> Yes, the directory is writable.  No, there is no journal file -- this
> happens even when creating a new database.
>
> ============
> [barranca]$ whoami
> jpj
> [barranca]$ ls -dl ./
> drwxr-x--x  38 jpj pg547368 4096 2006-09-15 09:25 ./
> [barranca]$ echo "create table foo(x varchar(12));" | ~/src/sqlite3-
> 3.3.7.bin test.db
> SQL error: database is locked
> ============
>

I've seen this happen on NFS filesystems with busted posix
locking support.  Is it a local disk or an NFS mount?
--
D. Richard Hipp   <[EMAIL PROTECTED]>



-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]

-----------------------------------------------------------------------------


Reply via email to