Hi,
Background Info -
1. Using Linux kernel v2.4.21 on both machines.
2. Scenario in which this problem occurs - when I rlogin/rsh to another
machine and then run the app
calls to sqlite3_open() work successfully
calls to sqlite3_exec() return 'database is locked' error message
3. This problem does not occur if I run the app on my local machine.
---------------------------------
I've debugged this issue and found that the problem lies with fcntl()
returning a failure (i.e. -1) which causes sqlite3 functions to return
"database is locked" error.
The fcntl() calls which return -1 are of this type -
fcntl64(5, F_SETLK64, {type=F_RDLCK, whence=SEEK_SET, start=1073741824,
len=1}, 0xbfffe4f0)
I think its safe to assume that the use of F_SETLK64 causes the fcntl()
fn to fail.
Is there a solution to this without changing the NFS settings. Maybe if
I modify the fcntl() calls in sqlite source code so that instead of
F_SETLK64 I pass some other command. I've tried passing F_SETLKW64 but
that reproduces the problem again.
I also tried another option in os_unix.c file which sqlite uses for
DJGPP in which the fcntl() is re-defined as -
#define fcntl(A,B,C) 0
but this gives another error message related to OS not able support
large file formats.
Could you please suggest some other alternative(s) except for
reconfiguring NFS server - this is something we just can't do. Thanks
for your help.
Regards,
Ritesh
On Mon, 2006-01-30 at 19:31, [EMAIL PROTECTED] wrote:
> Ritesh Kapoor <[EMAIL PROTECTED]> wrote:
> > Yes.
> > My machine has NFS and the machines I log onto also have NFS. But if
> > this is the problem then why dosen't it appear on my machine when I run
> > the app.
>
> Perhaps you are using a local filesystem when you run on
> your machine. Or perhaps NFS is configured properly on
> your machine but not on the other machines.
>
>
> > Is there a workaround for this? without having to change the file system
> > from NFS.
> >
>
> Yes. Configure your NFS so that file locking works correctly.
>
> --
> D. Richard Hipp <[EMAIL PROTECTED]>
>
