in reply to database problems

If the second process is jumping in as soon as you clear the lock, it might be enough to call
system '/bin/sync'; # or maybe system `which sync`;
before you unlock.

After Compline
Zaxo

Replies are listed 'Best First'.
Re: Re: database problems
by dl748 (Initiate) on Jun 02, 2001 at 04:51 UTC
    that will not work..... both processes have the same file open at the same time... i do a "write" sync" but the other process caches in memory part of the file. so it never gets changed. If i run the sync command that just flushes all the writes waiting on the system.... it doesn't affect what other programs have read already