I am running the system with the Quick_Check pragma - takes a while - and error logging turned on. I will let you know the results from this when I have some. Compression Attribute is a feature of the file system. Just mentioned as it might be an issue. SQLite database is on the same drive as the application (different folder).
Thanks, Andrew -----Original Message----- From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Stephen Chrzanowski Sent: Tuesday, January 05, 2016 7:42 AM To: SQLite mailing list <sqlite-users at mailinglists.sqlite.org> Subject: Re: [sqlite] The database disk image is malformed All of what Richard asked and said, plus, my question of where the file stored in relation to the application? (Network attached storage?) On Tue, Jan 5, 2016 at 10:22 AM, Richard Hipp <drh at sqlite.org> wrote: > On 1/5/16, Andrew Stewart <AStewart at arguscontrols.com> wrote: > > Hi, > > I am getting the following error on a database. The > > database is 78GB large when this started. I am adding data to it > > via > insert > > statements. I believe that this is the second time that I have seen > this. > > It has been running for about 2 weeks adding data to it constantly. > > The database structure is simple. Following is the code for the > > create > table: > > CREATE TABLE dataStreamRecord ( > > fwParameterID INTEGER NOT NULL, > > dateTime INTEGER NOT NULL, > > data INTEGER NOT NULL, > > UNIQUE ( > > fwParameterID, > > dateTime > > ) > > ); > > FWIW, a more efficient schema might be: > > CREATE TABLE dataStreamRecord ( > fwParameterId INT, > dateTime INT, > data INT NOT NULL, > PRIMARY KEY(fwParameterId,dateTime) > ) WITHOUT ROWID; > > > > > I am wondering what could cause this. The database > > does have the compression attribute turned on. The database > > time/date is > still > > getting adjusted. > > "compression attribute"? SQLite doesn't have any such thing. Is this > a feature of your filesystem? > > Have you run "PRAGMA quick_check" on the faulty database to gather > more information about the problem? > > Have you enabled error logging as described at > (https://www.sqlite.org/errlog.html)? > > -- > D. Richard Hipp > drh at sqlite.org > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users at mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users Notice: This electronic transmission contains confidential information, intended only for the person(s) named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or any other use of this email is strictly prohibited. If you have received this transmission by error, please notify us immediately by return email and destroy the original transmission immediately and all copies thereof.
