On 1/7/16, Andrew Stewart <AStewart at arguscontrols.com> wrote:
> 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
Knowing the content of page 78032902 (and any other page for which
btreeInitPage() failed) as a hex dump might give a clue. On a
workstation, with the SQLite sources checked out and configured:
make showdb
./showdb FILENAME 78032902b
Enabling the error log might also give a clue.
Probably the errors did not appear suddenly. The errors have been
accumulating and then SQLite suddenly tripped over one of them.
> 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-bounces at 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-bounces at 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
> _______________________________________________
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
--
D. Richard Hipp
drh at sqlite.org
