Re: HSQLDB Deployment & Virus Checkers
Thomas Kellerer <[email protected]>
| Newsgroups | gmane.comp.java.hsqldb.user |
|---|---|
| Message-ID | <[email protected]> |
Mike Ressler, 25.09.2013 19:42: > I noticed that the DOCS for HSQLDB mention that virus checkers will > interfere with database files: > http://hsqldb.org/doc/guide/management-chapt.html#mtc_deploy_context > > I did just have a customer lose quite a bit of data due to an unruly > virus checker. While we have a cloud backup option, they didn't use > it (womp). > > Is there any way around this virus checker vulnerability? Does > shutting down with SHUTDOWN COMPACT get around this? I suspect the > virus checker sniffs out the SQL statements and panics, deleting the > .script file. This is not unique to HSQLDB. I have seen installations of Postgres and Oracle fail or get corrupted because of anti-virus programs. They hook themselves to deeply into the IO code that the application itself cannot do very much. The usual solution is to exclude the directory where the database is stored from scanning. ------------------------------------------------------------------------------ October Webinars: Code for Performance Free Intel webinars can help you accelerate application performance. Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from the latest Intel processors and coprocessors. See abstracts and register > http://pubads.g.doubleclick.net/gampad/clk?id=60133471&iu=/4140/ostg.clktrk