I am also on version 3 of the SQLite...not sure if that makes a difference or if OpenVAS uses version 2.
Installed Packages Name : sqlite Arch : x86_64 Version : 3.7.17 Release : 8.el7 Size : 795 k Repo : installed From repo : anaconda Summary : Library that implements an embeddable SQL database engine URL : http://www.sqlite.org/ License : Public Domain Description : SQLite is a C library that implements an SQL database engine. A large : subset of SQL92 is supported. A complete database is stored in a : single disk file. The API is designed for convenience and ease of use. : Applications that link against SQLite can enjoy the power and : flexibility of an SQL database without the administrative hassles of : supporting a separate database server. Version 2 and version 3 binaries : are named to permit each to be installed on a single host -----Original Message----- From: Openvas-discuss [mailto:openvas-discuss-boun...@wald.intevation.org] On Behalf Of Turner,Jonas Sent: Monday, June 12, 2017 10:13 AM To: Reindl Harald; openvas-discuss@wald.intevation.org Subject: Re: [Openvas-discuss] sql errors Luckily, this server doesn’t do anything else besides OpenVAS and most of my files are already backed up so really I am up for trying anything at this point. -----Original Message----- From: Openvas-discuss [mailto:openvas-discuss-boun...@wald.intevation.org] On Behalf Of Reindl Harald Sent: Monday, June 12, 2017 10:09 AM To: openvas-discuss@wald.intevation.org Subject: Re: [Openvas-discuss] sql errors Am 12.06.2017 um 15:38 schrieb Brandon Perry: > >> On Jun 12, 2017, at 8:33 AM, Thijs Stuurman >> <thijs.stuur...@internedservices.nl >> <mailto:thijs.stuur...@internedservices.nl>> wrote: >> >> No, never. These are also the kind of errors I never ever wish to see! >> If your data is still there, scan tasks .. history etc’ I strongly >> urge you to make a backup and repeat making backups just in case. >> Many things can cause these errors, I cannot give you any specific >> place to start looking for a problem or solution. >> Perhaps it helps to get more log/verbose/debug information out of >> sqlite if possible. >> Check versions, is everything up to date? (sqlite, openvas) > > Perhaps consider PostgreSQL instead, simply for potential visibility > and easier diagnostics. maybe easier diagnostics *for you* - for everybody who is not usging postgresql in his daily workflow it leads sooner or later to more problems than it solves "disk I/O error" sounds RDBMS agnostic and the only real answer to that is find the hardware issue and grab your backups _______________________________________________ Openvas-discuss mailing list Openvas-discuss@wald.intevation.org https://lists.wald.intevation.org/cgi-bin/mailman/listinfo/openvas-discuss _______________________________________________ Openvas-discuss mailing list Openvas-discuss@wald.intevation.org https://lists.wald.intevation.org/cgi-bin/mailman/listinfo/openvas-discuss _______________________________________________ Openvas-discuss mailing list Openvas-discuss@wald.intevation.org https://lists.wald.intevation.org/cgi-bin/mailman/listinfo/openvas-discuss
