search

edrikL / gears

Automatically exported from code.google.com/p/gears
2 stars 3 forks source link

Understand cause of Michael's antivirus induced SQLITE_CANTOPEN errors #370

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
Observed on...
* Windows xp(sp2)
* AOL Active Virus Shield (powered by kasperksy)

Spurious SQLITE_CANTOPEN(14) errors when accessing both Gears.Database 
files and the internal localserver.db file used by Gears.

No such errors after disabling the anti-virus service.

See /sqlite/os_win.c for the source of this error code. Bumping the retry 
count from 2 to 10 in sqlite3WinOpenExclusive (and in winClose and 
sqlite3WinDelete too) did not remedy the problem.

Argh...

Original issue reported on code.google.com by gears.te...@gmail.com on 1 Feb 2008 at 11:32

GoogleCodeExporter commented 9 years ago

Original comment by gears.te...@gmail.com on 1 Feb 2008 at 11:35

GoogleCodeExporter commented 9 years ago

Original comment by cpri...@google.com on 11 Feb 2008 at 11:41

GoogleCodeExporter commented 9 years ago 
Bumping to 0.3 med, Gears enabled apps will not be usable on systems that 
exhibit 
this problem.

Original comment by gears.te...@gmail.com on 12 Feb 2008 at 10:36

GoogleCodeExporter commented 9 years ago

Original comment by cpri...@google.com on 12 Feb 2008 at 10:40

GoogleCodeExporter commented 9 years ago

Original comment by gears.te...@gmail.com on 23 Feb 2008 at 3:22

GoogleCodeExporter commented 9 years ago

Original comment by gears.te...@gmail.com on 25 Feb 2008 at 11:01

GoogleCodeExporter commented 9 years ago 
If that's any help, I have seen this error occur in NTFS-partitioned file 
systems, when the antivirus subscribes to 
monitor any changes on files. As the anti-virus software accesses the file, it 
locks it exclusively for a brief period 
of time.

My solution had always been to recommend the customer to exclude these files 
from scans. But that was for the 
server environment, where there usually is an IT professional to do this. I 
haven't a clue whether it is possible to 
announce the file as "excluded from scan" for all anti-virus software packages.

Original comment by dimitri....@gmail.com on 25 Feb 2008 at 11:50

GoogleCodeExporter commented 9 years ago

Original comment by gears.te...@gmail.com on 22 Apr 2008 at 12:24

GoogleCodeExporter commented 9 years ago

Original comment by gears.te...@gmail.com on 4 Jun 2008 at 12:46