Re: [sqlite] integrity_check "out of memory"

[Max Vlasov]

On Tue, Jan 22, 2013 at 12:33 PM, Dominique Pellé  wrote:

> Max Vlasov wrote:
>
> > Hi,
> >
> > I found with the web search that this error (out of memory  for PRAGMA
> > integrity_check) appeared in the wild and there were some fixes related
> to
> > it.It looks perhaps like the bug that was fixed in this checkin:
>
> http://www.sqlite.org/src/info/120c82d56e
>
> Can you try and confirm?
>
>
The trunk version works ok, no limits noticed.

Max
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] integrity_check "out of memory"

[Max Vlasov]

Thanks, Dominique

I will try asap, but looking at the arithmetics

25 (The length of "Page ? is never used")
*
800 (maximum I could get)

= 20,000 (limit mentioned in the ticket )

looks like this is a winner :)

Max



> Hi Max
>
> It looks perhaps like the bug that was fixed in this checkin:
>
> http://www.sqlite.org/src/info/120c82d56e
>
> Can you try and confirm?
>
> -- Dominique
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] integrity_check "out of memory"

[Dominique Pellé]

Max Vlasov wrote:

> Hi,
>
> I found with the web search that this error (out of memory  for PRAGMA
> integrity_check) appeared in the wild and there were some fixes related to
> it.
>
> Today I decided to do the check for a base that lives with its own
> encrypted vfs and with an sqlite version older than the current. But the
> check was made with the latest version (3.7.15.2). I got the same error
> (out of memory) for max values larger than 800, for example PRAGMA
> integrity_check(801). If I provide the number below or equal to 800, the
> result is only the (truncated) list of "Page .. is never used". What could
> go wrong? Can it be related to inadequate code of my vfs? The reason why I
> would like to see the entries after 800 is that there can be more serious
> errors than "Page is never used".
>
> Thanks,
>
> Max

Hi Max

It looks perhaps like the bug that was fixed in this checkin:

http://www.sqlite.org/src/info/120c82d56e

Can you try and confirm?

-- Dominique
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] integrity_check "out of memory"

[Max Vlasov]

On Mon, Jan 21, 2013 at 9:30 PM, Klaas V  wrote:

> Max wrote he's using an encrypted VFS. Perhaps the problem disappears when
> he decodes the file?
>

I tried to do the same for the decrypted file and on another computer, with
much more memory. The same result. Probably I I can live with that, the
only thing I would like to know whether the report errors always come most
important first so if I see "Page ... not used" as the first entry then I
would be sure there are no more serious errors regardless of the length of
the output.

Max
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] integrity_check "out of memory"

[Klaas V]

Max wrote he's using an encrypted VFS. Perhaps the problem disappears when he 
decodes the file?
I can imagine the software does not find encoded page numbers and a maximum 
number of errors before quitting a check is pretty normal. Eight hundred is yet 
high. If I would write an integrity check procedure I would say about 250 tops 
and stop.
 
Cordiali saluti/Vriendelijke groeten/Kind regards, Klaas V

http://innocentisart.net
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] integrity_check "out of memory"

[Max Vlasov]

Hi,

I found with the web search that this error (out of memory  for PRAGMA
integrity_check) appeared in the wild and there were some fixes related to
it.

Today I decided to do the check for a base that lives with its own
encrypted vfs and with an sqlite version older than the current. But the
check was made with the latest version (3.7.15.2). I got the same error
(out of memory) for max values larger than 800, for example PRAGMA
integrity_check(801). If I provide the number below or equal to 800, the
result is only the (truncated) list of "Page .. is never used". What could
go wrong? Can it be related to inadequate code of my vfs? The reason why I
would like to see the entries after 800 is that there can be more serious
errors than "Page is never used".

Thanks,

Max
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users