Community Discussions and Support
Popfile SQLite Temporary Files Locked

We have run Mercury 4.01b on Windows 98SE and Windows XP Pro and now run 4.52 on XP Pro. We have used POPFileD v1.22.4 with POPFile v0.22.4 on both Mercury 4.01b and 4.52 with both Windows 98SE and Windows XP. In every case POPFile's use of SQLite results in lots of 0k locked files that do not go away until POPFile is shutdown. These files are in "C:\Windows\Temp" for Windows 98SE and are in "C:\Documents and Settings\MercuryAccount\Local Settings\Temp" for Windows XP. It appears like a file is created and locked for every email that passes through POPFile. Each file is named something like "sqlite_nwkhQ5SvfzHf0Wa" and has a size of 0k. The file cannot be opened by Notepad or even merely copied to some other location because it is locked. Several hundred or even several thousand of these files may accumulate over a period of several days and then no more accumulate and the ones that are there just stay there indefinitely until POPFile is shut down. For example, I last started POPFile (and Mercury) on Sept 8. There are over 800 of these locked files with dates from Sept 8-13 and then no more. If POPFile were shutdown all these locked files immediately go away.

Has anyone else noticed this phenomenon? Is it a POPFile, POPFileD, or SQLite bug? Or is it something else? And does anyone have a solution to suggest? I get the impression that the system seems slower when there are many of these files sitting there.

<P>We have run Mercury 4.01b on Windows 98SE and Windows XP Pro and now run 4.52 on XP Pro. We have used POPFileD v1.22.4 with POPFile v0.22.4 on both Mercury 4.01b and 4.52 with both Windows 98SE and Windows XP. In every case POPFile's use of SQLite results in lots of 0k locked files that do not go away until POPFile is shutdown. These files are in "C:\Windows\Temp" for Windows 98SE and are in "C:\Documents and Settings\MercuryAccount\Local Settings\Temp" for Windows XP. It appears like a file is created and locked for every email that passes through POPFile. Each file is named something like "sqlite_nwkhQ5SvfzHf0Wa" and has a size of 0k. The file cannot be opened by Notepad or even merely copied to some other location because it is locked. Several hundred or even several thousand of these files may accumulate over a period of several days and then no more accumulate and the ones that are there just stay there indefinitely until POPFile is shut down. For example, I last started POPFile (and Mercury) on Sept 8. There are over 800 of these locked files with dates from Sept 8-13 and then no more. If POPFile were shutdown all these locked files immediately go away.</P> <P>Has anyone else noticed this phenomenon? Is it a POPFile, POPFileD, or SQLite bug? Or is it something else? And does anyone have a solution to suggest? I get the impression that the system seems slower when there are many of these files sitting there.</P>
live preview
enter atleast 10 characters
WARNING: You mentioned %MENTIONS%, but they cannot see this message and will not be notified
Saving...
Saved
With selected deselect posts show selected posts
All posts under this topic will be deleted ?
Pending draft ... Click to resume editing
Discard draft