btree02-110 test failing

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

btree02-110 test failing

aiannotti
I am seeing the make test fail on btree02-110, are there configuration
directives I should use to use to fix this? (Currently only using the tcl
directory configure flag.)

I am getting this with 3.27.0 and the latest pull from
https://www.sqlite.org/src/info/trunk - SQLite-6821c61f

Running on CentOS 7.5, compiling with gcc (GCC) 7.1.0

.....
Time: btree01.test 18510 ms
! btree02-110 expected: [27]
! btree02-110 got:      [20]
Time: btree02.test 562 ms
.....





--
Sent from: http://sqlite.1065341.n5.nabble.com/
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: btree02-110 test failing

Richard Hipp-3
Please patch the btree02.test file as follows:

--- test/btree02.test
+++ test/btree02.test
@@ -27,10 +27,11 @@
   CREATE TABLE t3(cnt);
   WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4)
     INSERT INTO t3(cnt) SELECT i FROM c;
   SELECT count(*) FROM t1;
 } {10}
+file copy test.db backup.db
 do_test btree02-110 {
   db eval BEGIN
   set i 0
   db eval {SELECT a, ax, b, cnt FROM t1 CROSS JOIN t3 WHERE b IS NOT NULL} {
     if {$a==""} {set a 0}

Then run the test:

    ./testfixture test/btree02.test

Then email me the file testdir/backup.db

Thanks.

On 12/26/18, aiannotti <[hidden email]> wrote:

> I am seeing the make test fail on btree02-110, are there configuration
> directives I should use to use to fix this? (Currently only using the tcl
> directory configure flag.)
>
> I am getting this with 3.27.0 and the latest pull from
> https://www.sqlite.org/src/info/trunk - SQLite-6821c61f
>
> Running on CentOS 7.5, compiling with gcc (GCC) 7.1.0
>
> .....
> Time: btree01.test 18510 ms
> ! btree02-110 expected: [27]
> ! btree02-110 got:      [20]
> Time: btree02.test 562 ms
> .....
>
>
>
>
>
> --
> Sent from: http://sqlite.1065341.n5.nabble.com/
> _______________________________________________
> sqlite-users mailing list
> [hidden email]
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>


--
D. Richard Hipp
[hidden email]
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: btree02-110 test failing

Shlomi Fish
Hi Richard,

On Thu, 27 Dec 2018 03:16:24 -0500
Richard Hipp <[hidden email]> wrote:

> Please patch the btree02.test file as follows:
>
> --- test/btree02.test
> +++ test/btree02.test
> @@ -27,10 +27,11 @@
>    CREATE TABLE t3(cnt);
>    WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<4)
>      INSERT INTO t3(cnt) SELECT i FROM c;
>    SELECT count(*) FROM t1;
>  } {10}
> +file copy test.db backup.db
>  do_test btree02-110 {
>    db eval BEGIN
>    set i 0
>    db eval {SELECT a, ax, b, cnt FROM t1 CROSS JOIN t3 WHERE b IS NOT NULL} {
>      if {$a==""} {set a 0}
>
> Then run the test:
>
>     ./testfixture test/btree02.test
>
> Then email me the file testdir/backup.db
>

I attached it. Thanks!

> Thanks.
>
> On 12/26/18, aiannotti <[hidden email]> wrote:
> > I am seeing the make test fail on btree02-110, are there configuration
> > directives I should use to use to fix this? (Currently only using the tcl
> > directory configure flag.)
> >
> > I am getting this with 3.27.0 and the latest pull from
> > https://www.sqlite.org/src/info/trunk - SQLite-6821c61f
> >
> > Running on CentOS 7.5, compiling with gcc (GCC) 7.1.0
> >
> > .....
> > Time: btree01.test 18510 ms
> > ! btree02-110 expected: [27]
> > ! btree02-110 got:      [20]
> > Time: btree02.test 562 ms
> > .....
> >
> >
> >
> >
> >
> > --
> > Sent from: http://sqlite.1065341.n5.nabble.com/
> > _______________________________________________
> > sqlite-users mailing list
> > [hidden email]
> > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> >  
>
>



--
-----------------------------------------------------------------
Shlomi Fish       http://www.shlomifish.org/
http://is.gd/htwEXQ - Integrating GNU Guile into GNU coreutils

Bill Gates, CEO of Microsoft decides to use Richard Stallman’s Emacs as the
basis of his company’s state‐of‐the‐art product Microsoft Editing Macros™
Enterprise Edition XP .NET Professional.

Please reply to list if it's a mailing list post - http://shlom.in/reply .
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: btree02-110 test failing

aiannotti
In reply to this post by Richard Hipp-3
Thanks, emailed separately with the atachment.

Output from the test run was:

[aiannotti@dog SQLite-6821c61f]$  ./testfixture test/btree02.test      
btree02-100... Ok
btree02-110...
! btree02-110 expected: [27]
! btree02-110 got:      [20]
SQLite 2018-12-26 18:34:56
6821c61f1d71be2be7f867e59fd94582a1eaf45a4d1fb88be995807a77cc22ea
1 errors out of 3 tests on ip-172-101-5-31.ec2.internal Linux 64-bit
little-endian
!Failures on these tests: btree02-110
All memory allocations freed - no leaks
Memory used:          now          0  max     207744  max-size     120000
Allocation count:     now          0  max        236
Page-cache used:      now          0  max          0  max-size       1024
Page-cache overflow:  now          0  max       4128
Maximum memory usage: 207744 bytes
Current memory usage: 0 bytes
Number of malloc()  : -1 calls





--
Sent from: http://sqlite.1065341.n5.nabble.com/
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: btree02-110 test failing

aiannotti
Just to close the loop, with the commit at:

https://www.sqlite.org/src/info/d9e4f9574659c628

All tests now pass cleanly in my environment.

Thank you very much!




--
Sent from: http://sqlite.1065341.n5.nabble.com/
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users