Re: [sqlite] Partially "hidden" row, very bizarre state

quot; -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Jeff B. Sent: Monday, 13 February, 2017 11:56 To: SQLite mailing list Subject: Re: [sqlite] Partially "hidden" row, very bizarre state Should have read up on integrity_c

Re: [sqlite] Partially "hidden" row, very bizarre state

uot; > > > -Original Message- > > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > > On Behalf Of Jeff B. > > Sent: Monday, 13 February, 2017 11:56 > > To: SQLite mailing list > > Subject: Re: [sqlite] Partially "hidden" row, very bi

Re: [sqlite] Partially "hidden" row, very bizarre state

qlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > On Behalf Of Jeff B. > Sent: Monday, 13 February, 2017 11:56 > To: SQLite mailing list > Subject: Re: [sqlite] Partially "hidden" row, very bizarre state > > Should have read up on integrity_check before

Re: [sqlite] Partially "hidden" row, very bizarre state

Thanks again to everyone for the guidance. I read through that list of corruption candidates and most don't seem to apply. Only one app accesses the db file, it's on a local NTFS partition, there were no power failures or hard reboots, no pragmas or non-default access options were used. So

Re: [sqlite] Partially "hidden" row, very bizarre state

First off, thanks for the help! Here is the output: pragma integrity_check; **Command returned -1** select '<'||id||'>',created from messages_priority order by id limit 5; created <424>2/12/2017 8:07:10 PM <423>2/12/2017 8:07:09 PM <425>2/12/2017 8:07:11 PM <426>2/12/2017

Re: [sqlite] Partially "hidden" row, very bizarre state

On 13 Feb 2017, at 7:12pm, Jeff B. wrote: > The vacuum followed by a reindex seems to have fixed the db (see below). But > are there any other theories as to how we got to this point? Could I have > possibly caused this or do I just need to build in code to detect problems >

Re: [sqlite] Partially "hidden" row, very bizarre state

On 2/13/17, Jeff B. wrote: > But are there any other theories as to how we got to this > point? Please see https://www.sqlite.org/howtocorrupt.html -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list

Re: [sqlite] Partially "hidden" row, very bizarre state

The vacuum followed by a reindex seems to have fixed the db (see below). But are there any other theories as to how we got to this point? Could I have possibly caused this or do I just need to build in code to detect problems like this and rebuild on the fly? I'm new to SQLite so I don't

Re: [sqlite] Partially "hidden" row, very bizarre state

On 2017/02/13 8:55 PM, Jeff B. wrote: Should have read up on integrity_check before posting the results... I re-worked my tool and here is the output: pragma integrity_check; *** in database main *** On tree page 11 cell 0: Rowid 424 out of order wrong # of entries in index

Re: [sqlite] Partially "hidden" row, very bizarre state

nal Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Jeff B. Sent: Monday, February 13, 2017 12:32 PM To: sqlite-users@mailinglists.sqlite.org Subject: [sqlite] Partially "hidden" row, very bizarre state Hi Everyone, Sorry for the strange s

Re: [sqlite] Partially "hidden" row, very bizarre state

On 13 Feb 2017, at 6:55pm, Jeff B. wrote: > Should have read up on integrity_check before posting the results... I > re-worked my tool and here is the output: > > > pragma integrity_check; > > *** in database main *** > On tree page 11 cell 0: Rowid 424 out of order > wrong #

Re: [sqlite] Partially "hidden" row, very bizarre state

Should have read up on integrity_check before posting the results... I re-worked my tool and here is the output: pragma integrity_check; *** in database main *** On tree page 11 cell 0: Rowid 424 out of order wrong # of entries in index sqlite_autoindex_messages_priority_1 **2 rows returned**

Re: [sqlite] Partially "hidden" row, very bizarre state

First off, thanks for the help! Here is the output: pragma integrity_check; **Command returned -1** select '<'||id||'>',created from messages_priority order by id limit 5; created <424>2/12/2017 8:07:10 PM <423>2/12/2017 8:07:09 PM <425>2/12/2017 8:07:11 PM <426>2/12/2017

Re: [sqlite] Partially "hidden" row, very bizarre state

Correction: That's "limit 5;" of course on the second query... On 2017/02/13 7:58 PM, R Smith wrote: Could you run and post the output of your tool to the following two queries please: pragma integrity_check; select '<'||id||'>',created from messages_priority order by id limit ; Thanks,

Re: [sqlite] Partially "hidden" row, very bizarre state

Could you run and post the output of your tool to the following two queries please: pragma integrity_check; select '<'||id||'>',created from messages_priority order by id limit ; Thanks, Ryan On 2017/02/13 7:32 PM, Jeff B. wrote: Hi Everyone, Sorry for the strange subject, but the

Re: [sqlite] Partially "hidden" row, very bizarre state

f Jeff B. Sent: Monday, February 13, 2017 12:32 PM To: sqlite-users@mailinglists.sqlite.org Subject: [sqlite] Partially "hidden" row, very bizarre state Hi Everyone, Sorry for the strange subject, but the situation I'm facing is so odd that I wasn't even sure how to

[sqlite] Partially "hidden" row, very bizarre state

Hi Everyone, Sorry for the strange subject, but the situation I'm facing is so odd that I wasn't even sure how to summarize it. First, a little context: I'm using v1.0.104 of System.Data.SQLite.Core in my C#/.NET 4.5 project. I have a table that is created as follows: