Re: [sqlite] integrity_check "out of memory"

2013-01-23 Thread 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"

2013-01-22 Thread 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"

2013-01-22 Thread 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"

2013-01-21 Thread 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"

2013-01-21 Thread 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