I have run the Quick Check. The results are below. This database is written to once a minute. One minute it was working and the next it was not. What would cause it to suddenly have errors? This is what I don't understand.
check_callback argc 1 argv <*** in database main *** On tree page 78032851 cell 0: invalid page number 78032953 On tree page 78032851 cell 80: invalid page number 78032952 On tree page 78032851 cell 79: invalid page number 78032943 Page 78032902: btreeInitPage() returns error code 11 Page 78032899: btreeInitPage() returns error code 11 On tree page 78032851 cell 76: 2nd reference to page 78032896 Page 78032893: btreeInitPage() returns error code 11 On tree page 78032851 cell 74: 2nd reference to page 78032891 On tree page 78032851 cell 73: 2nd reference to page 78032890 On tree page 78032851 cell 72: 2nd reference to page 78032892 Page 78032894: btreeInitPage() returns error code 11 On tree page 78032851 cell 70: 2nd reference to page 78032897 Page 78032898: btreeInitPage() returns error code 11 Page 78032900: btreeInitPage() returns error code 11 Page 78032903: btreeInitPage() returns error code 11 Page 78032905: btreeInitPage() returns error code 11 Page 78032906: btreeInitPage() returns error code 11 Page 78032908: btreeInitPage() returns error code 11 Page 78032909: btreeInitPage() returns error code 11 On tree page 78032785 cell 50: Rowid 1920558098 out of order On tree page 78032620 cell 51: Rowid 1920553873 out of order On tree page 12554114 cell 1: 2nd reference to page 73763093 On tree page 12554114 cell 45: 2nd reference to page 74027333 On tree page 12554114 cell 44: 2nd reference to page 74269821 On tree page 12554114 cell 43: 2nd reference to page 74282113 On tree page 12554114 cell 42: Child page depth differs On tree page 11504958 cell 0: 2nd reference to page 17057664 On tree page 11504958 cell 41: Child page depth differs On tree page 49348817 cell 3: 2nd reference to page 77795949 On tree page 49348817 cell 44: 2nd reference to page 77795603 On tree page 49348817 cell 43: 2nd reference to page 77795269 On tree page 49348817 cell 42: 2nd reference to page 77794959 On tree page 49348817 cell 41: 2nd reference to page 77794647 On tree page 49348817 cell 40: 2nd reference to page 77794339 On tree page 49348817 cell 39: 2nd reference to page 77793992 On tree page 49348817 cell 38: 2nd reference to page 77793667 On tree page 49348817 cell 37: 2nd reference to page 77793387 On tree page 74474051 cell 18: 2nd reference to page 77794984 On tree page 74474051 cell 44: 2nd reference to page 77794646 On tree page 74474051 cell 43: 2nd reference to page 77794312 On tree page 74474051 cell 42: 2nd reference to page 77793944 On tree page 74474051 cell 41: 2nd reference to page 77793595 On tree page 23617480 cell 6: 2nd reference to page 77348882 On tree page 23617480 cell 45: 2nd reference to page 77348544 On tree page 23617480 cell 44: 2nd reference to page 77797542 On tree page 23617480 cell 43: 2nd reference to page 77797224 On tree page 23617480 cell 42: 2nd reference to page 77796839 On tree page 23617480 cell 41: 2nd reference to page 77796444 On tree page 23617480 cell 40: 2nd reference to page 77796068 On tree page 23617480 cell 39: 2nd reference to page 77795675 On tree page 23617480 cell 38: 2nd reference to page 77795283 On tree page 23617480 cell 37: 2nd reference to page 77794931 On tree page 23617480 cell 36: 2nd reference to page 77794576 On tree page 23617480 cell 35: 2nd reference to page 77794219 On tree page 44645394 cell 13: 2nd reference to page 77794197 On tree page 44645394 cell 45: 2nd reference to page 77793853 On tree page 44645394 cell 44: 2nd reference to page 77793543 On tree page 44645394 cell 43: 2nd reference to page 77793249 On tree page 44645394 cell 42: 2nd reference to page 77792913 On tree page 44645394 cell 41: 2nd reference to page 77792600 On tree page 44645394 cell 40: 2nd reference to page 77792259 On tree page 44645394 cell 39: 2nd reference to page 77791944 On tree page 44645394 cell 38: 2nd reference to page 77573982 On tree page 44645394 cell 37: 2nd reference to page 77573636 On tree page 44645394 cell 36: 2nd reference to page 77573305 On tree page 44645394 cell 35: 2nd reference to page 77572949 On tree page 44645394 cell 34: 2nd reference to page 77572603 On tree page 9022708 cell 22: 2nd reference to page 77795655 On tree page 9022708 cell 45: 2nd reference to page 77795318 On tree page 9022708 cell 44: 2nd reference to page 77795008 On tree page 9022708 cell 43: 2nd reference to page 77794698 On tree page 9022708 cell 42: 2nd reference to page 77794387 On tree page 9022708 cell 41: 2nd reference to page 77794048 On tree page 9022708 cell 40: 2nd reference to page 77793710 On tree page 9022708 cell 39: 2nd reference to page 77793431 On tree page 9022708 cell 38: 2nd reference to page 77793104 On tree page 9022708 cell 37: 2nd reference to page 77792777 On tree page 9022708 cell 36: 2nd reference to page 77792457 On tree page 9022708 cell 35: 2nd reference to page 77792124 On tree page 9022708 cell 34: 2nd reference to page 77791818 On tree page 9026909 cell 1: 2nd reference to page 77792121 On tree page 9026909 cell 44: 2nd reference to page 77791812 On tree page 6545734 cell 0: 2nd reference to page 6232064 On tree page 6545734 cell 43: 2nd reference to page 6232062 On tree page 23033976 cell 26: 2nd reference to page 75901962 On tree page 23033976 cell 45: 2nd reference to page 75898413 On tree page 23033976 cell 44: Child page depth differs On tree page 71968221 cell 11: 2nd reference to page 77794382 On tree page 71968221 cell 45: 2nd reference to page 77794042 On tree page 71968221 cell 44: 2nd reference to page 77793705 On tree page 69239670 cell 10: 2nd reference to page 45319543 On tree page 67511115 cell 16: 2nd reference to page 77792050 On tree page 67511115 cell 45: 2nd reference to page 77791736 On tree page 67511115 cell 44: 2nd reference to page 77573749 On tree page 67511115 cell 43: 2nd reference to page 77573414 On tree page 67511115 cell 42: 2nd reference to page 77573067 On tree page 67511115 cell 41: 2nd reference to page 77572717 On tree page 67511115 cell 40: 2nd reference to page 77572370 On tree page 67511115 cell 39: 2nd reference to page 77572056 On tree page 67511115 cell 38: 2nd reference to page 77571738> Regards, Andrew Stewart -----Original Message----- From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Andrew Stewart Sent: Tuesday, January 05, 2016 8:12 AM To: 'SQLite mailing list' <sqlite-users at mailinglists.sqlite.org> Subject: Re: [sqlite] The database disk image is malformed 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. _______________________________________________ sqlite-users mailing list sqlite-users at mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
