Re: [sqlite] strange issue with broken links/hung processes in transaction

2006-10-31 Thread ara . t . howard
On Tue, 31 Oct 2006 [EMAIL PROTECTED] wrote: I suspect that the /var/tmp file is unrelated to your mmap/munmap problem. When SQLite needs a temporary file on Unix, it creates the file, opens it, then calls unlink(). Unix removes the inode for the file from its directory immediately so that

Re: [sqlite] strange issue with broken links/hung processes in transaction

2006-10-31 Thread drh
[EMAIL PROTECTED] wrote: > i have some code which uses sqlite heavily. every so often a command using > with hang indefinitely, running an strace on the code shows it to be stuck in > a loop doing > > >munmap addr1 >mmap #=> addr1 >munmap addr2 >mmap #=> addr1 >

[sqlite] strange issue with broken links/hung processes in transaction

2006-10-31 Thread ara . t . howard
i have some code which uses sqlite heavily. every so often a command using with hang indefinitely, running an strace on the code shows it to be stuck in a loop doing munmap addr1 mmap #=> addr1 munmap addr2 mmap #=> addr1 munmap addr1 ... ... repeat forever...