sqlite 3.22.0 walro2 test failures on ppc64

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

sqlite 3.22.0 walro2 test failures on ppc64

Petr Kubat
Hi all,

hitting some failures when building 3.22.0 on ppc64 boxes (both
big-endian and little-endian) running Fedora Rawhide (full logs in [1][2]):

Time: walro.test 135 ms
! walro2-1.3.2.2 expected: [0 32768]
! walro2-1.3.2.2 got:      [0 65536]
! walro2-1.3.3.0 expected: [4224 32768]
! walro2-1.3.3.0 got:      [4224 65536]
! walro2-1.3.3.2 expected: [4224 32768]
! walro2-1.3.3.2 got:      [4224 65536]
! walro2-2.3.2.2 expected: [0 32768]
! walro2-2.3.2.2 got:      [0 65536]
! walro2-2.3.3.0 expected: [4224 32768]
! walro2-2.3.3.0 got:      [4224 65536]
! walro2-2.3.3.2 expected: [4224 32768]
! walro2-2.3.3.2 got:      [4224 65536]
Time: walro2.test 513 ms

 From what I can see the expected sizes of the database files seem to be
half of what is the actual size.

Petr

[1]: https://kojipkgs.fedoraproject.org//work/tasks/9900/24679900/build.log
[2]: https://kojipkgs.fedoraproject.org//work/tasks/9898/24679898/build.log

_______________________________________________
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: sqlite 3.22.0 walro2 test failures on ppc64

Petr Kubat
On 02/05/2018 08:41 AM, Petr Kubat wrote:

> Hi all,
>
> hitting some failures when building 3.22.0 on ppc64 boxes (both
> big-endian and little-endian) running Fedora Rawhide (full logs in
> [1][2]):
>
> Time: walro.test 135 ms
> ! walro2-1.3.2.2 expected: [0 32768]
> ! walro2-1.3.2.2 got:      [0 65536]
> ! walro2-1.3.3.0 expected: [4224 32768]
> ! walro2-1.3.3.0 got:      [4224 65536]
> ! walro2-1.3.3.2 expected: [4224 32768]
> ! walro2-1.3.3.2 got:      [4224 65536]
> ! walro2-2.3.2.2 expected: [0 32768]
> ! walro2-2.3.2.2 got:      [0 65536]
> ! walro2-2.3.3.0 expected: [4224 32768]
> ! walro2-2.3.3.0 got:      [4224 65536]
> ! walro2-2.3.3.2 expected: [4224 32768]
> ! walro2-2.3.3.2 got:      [4224 65536]
> Time: walro2.test 513 ms
>
> From what I can see the expected sizes of the database files seem to
> be half of what is the actual size.

To correct myself here - its the "-wal" file that gets twice as big as
expected. btw the starting size of the "-wal" file on ppc64 is the same
(65536 bytes) even in older versions of sqlite (looking at 3.20.1 right
now).

_______________________________________________
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: sqlite 3.22.0 walro2 test failures on ppc64

Dan Kennedy-4
On 02/05/2018 04:22 PM, Petr Kubat wrote:

> On 02/05/2018 08:41 AM, Petr Kubat wrote:
>
>> Hi all,
>>
>> hitting some failures when building 3.22.0 on ppc64 boxes (both
>> big-endian and little-endian) running Fedora Rawhide (full logs in
>> [1][2]):
>>
>> Time: walro.test 135 ms
>> ! walro2-1.3.2.2 expected: [0 32768]
>> ! walro2-1.3.2.2 got:      [0 65536]
>> ! walro2-1.3.3.0 expected: [4224 32768]
>> ! walro2-1.3.3.0 got:      [4224 65536]
>> ! walro2-1.3.3.2 expected: [4224 32768]
>> ! walro2-1.3.3.2 got:      [4224 65536]
>> ! walro2-2.3.2.2 expected: [0 32768]
>> ! walro2-2.3.2.2 got:      [0 65536]
>> ! walro2-2.3.3.0 expected: [4224 32768]
>> ! walro2-2.3.3.0 got:      [4224 65536]
>> ! walro2-2.3.3.2 expected: [4224 32768]
>> ! walro2-2.3.3.2 got:      [4224 65536]
>> Time: walro2.test 513 ms
>>
>> From what I can see the expected sizes of the database files seem to
>> be half of what is the actual size.
>
> To correct myself here - its the "-wal" file that gets twice as big as
> expected. btw the starting size of the "-wal" file on ppc64 is the
> same (65536 bytes) even in older versions of sqlite (looking at 3.20.1
> right now).


Thanks for reporting this. I think it's just a problem with the test
script. Now fixed here:

   http://www.sqlite.org/src/info/d9e59cfb8476e1ec

Dan.



>
>>
>> Petr
>>
>> [1]:
>> https://kojipkgs.fedoraproject.org//work/tasks/9900/24679900/build.log
>> [2]:
>> https://kojipkgs.fedoraproject.org//work/tasks/9898/24679898/build.log
>>
>> _______________________________________________
>> sqlite-users mailing list
>> [hidden email]
>> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
> _______________________________________________
> sqlite-users mailing list
> [hidden email]
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


_______________________________________________
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: sqlite 3.22.0 walro2 test failures on ppc64

Petr Kubat
Tests are passing now, thanks!

Had to make one small modification to the patch to get it working though:

@@ -17,7 +17,7 @@ Index: test/walro2.test
  +do_execsql_test 0.0 {
  +  PRAGMA journal_mode = wal;
  +  CREATE TABLE t1(x);
-+}
++} {wal}
  +set MINSHMSZ [file size test.db-shm]
  +
   foreach bZeroShm {0 1} {

Petr

On 02/05/2018 02:29 PM, Dan Kennedy wrote:

> On 02/05/2018 04:22 PM, Petr Kubat wrote:
>> On 02/05/2018 08:41 AM, Petr Kubat wrote:
>>
>>> Hi all,
>>>
>>> hitting some failures when building 3.22.0 on ppc64 boxes (both
>>> big-endian and little-endian) running Fedora Rawhide (full logs in
>>> [1][2]):
>>>
>>> Time: walro.test 135 ms
>>> ! walro2-1.3.2.2 expected: [0 32768]
>>> ! walro2-1.3.2.2 got:      [0 65536]
>>> ! walro2-1.3.3.0 expected: [4224 32768]
>>> ! walro2-1.3.3.0 got:      [4224 65536]
>>> ! walro2-1.3.3.2 expected: [4224 32768]
>>> ! walro2-1.3.3.2 got:      [4224 65536]
>>> ! walro2-2.3.2.2 expected: [0 32768]
>>> ! walro2-2.3.2.2 got:      [0 65536]
>>> ! walro2-2.3.3.0 expected: [4224 32768]
>>> ! walro2-2.3.3.0 got:      [4224 65536]
>>> ! walro2-2.3.3.2 expected: [4224 32768]
>>> ! walro2-2.3.3.2 got:      [4224 65536]
>>> Time: walro2.test 513 ms
>>>
>>> From what I can see the expected sizes of the database files seem to
>>> be half of what is the actual size.
>>
>> To correct myself here - its the "-wal" file that gets twice as big
>> as expected. btw the starting size of the "-wal" file on ppc64 is the
>> same (65536 bytes) even in older versions of sqlite (looking at
>> 3.20.1 right now).
>
>
> Thanks for reporting this. I think it's just a problem with the test
> script. Now fixed here:
>
>   http://www.sqlite.org/src/info/d9e59cfb8476e1ec
>
> Dan.
>
>
>
>>
>>>
>>> Petr
>>>
>>> [1]:
>>> https://kojipkgs.fedoraproject.org//work/tasks/9900/24679900/build.log
>>> [2]:
>>> https://kojipkgs.fedoraproject.org//work/tasks/9898/24679898/build.log
>>>
>>> _______________________________________________
>>> sqlite-users mailing list
>>> [hidden email]
>>> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>>
>> _______________________________________________
>> sqlite-users mailing list
>> [hidden email]
>> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
>
> _______________________________________________
> sqlite-users mailing list
> [hidden email]
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users