GNU bug report logs - #38663
postgis is not reproducible

Previous Next

Package: guix;

Reported by: Björn Höfling <bjoern.hoefling <at> bjoernhoefling.de>

Date: Wed, 18 Dec 2019 21:14:02 UTC

Severity: normal

Done: Björn Höfling <bjoern.hoefling <at> bjoernhoefling.de>

Bug is archived. No further changes may be made.

To add a comment to this bug, you must first unarchive it, by sending
a message to control AT debbugs.gnu.org, with unarchive 38663 in the body.
You can then email your comments to 38663 AT debbugs.gnu.org in the normal way.

Toggle the display of automated, internal messages from the tracker.

View this report as an mbox folder, status mbox, maintainer mbox


Report forwarded to bug-guix <at> gnu.org:
bug#38663; Package guix. (Wed, 18 Dec 2019 21:14:02 GMT) Full text and rfc822 format available.

Acknowledgement sent to Björn Höfling <bjoern.hoefling <at> bjoernhoefling.de>:
New bug report received and forwarded. Copy sent to bug-guix <at> gnu.org. (Wed, 18 Dec 2019 21:14:02 GMT) Full text and rfc822 format available.

Message #5 received at submit <at> debbugs.gnu.org (full text, mbox):

From: Björn Höfling <bjoern.hoefling <at> bjoernhoefling.de>
To: <bug-guix <at> gnu.org>
Subject: postgis is not reproducible
Date: Wed, 18 Dec 2019 22:13:34 +0100
[Message part 1 (text/plain, inline)]
Package postgis contains many timestamps, making it not reproducible.

Some examples below.

Björn


--- /gnu/store/121c447hzz55milkdp7ak15vxmsi1xpr-postgis-2.4.8
+++ /gnu/store/121c447hzz55milkdp7ak15vxmsi1xpr-postgis-2.4.8-check
├── lib
│ ├── postgis-2.4.so
│ │ ├── /gnu/store/mx2bgrpxkbdjsmhlxp9a30hbzcilk4cn-binutils-2.32/bin/readelf --wide --decompress --hex-dump=.rodata {}
│ │ │ @@ -253,15 +253,15 @@
│ │ │    0x00083fa0 6e617465 00000000 47656f6d 65747279 nate....Geometry
│ │ │    0x00083fb0 20646f65 73206e6f 74206861 76652061  does not have a
│ │ │    0x00083fc0 205a206f 7264696e 61746500 00000000  Z ordinate.....
│ │ │    0x00083fd0 5363616c 65206661 63746f72 2067656f Scale factor geo
│ │ │    0x00083fe0 6d657472 79207061 72616d65 74657220 metry parameter 
│ │ │    0x00083ff0 6d757374 20626520 6120706f 696e7400 must be a point.
│ │ │    0x00084000 322e342e 38003230 31392d31 322d3138 2.4.8.2019-12-18
│ │ │ -  0x00084010 2031323a 33393a35 36002573 20722564  12:39:56.%s r%d
│ │ │ +  0x00084010 2031323a 33363a35 32002573 20722564  12:36:52.%s r%d
│ │ │    0x00084020 00322e39 2e390031 2e32006c 7767656f .2.9.9.1.2.lwgeo
│ │ │    0x00084030 6d5f6675 6e637469 6f6e735f 62617369 m_functions_basi
│ │ │    0x00084040 632e6300 5368656c 6c206973 206e6f74 c.c.Shell is not
│ │ │    0x00084050 2061206c 696e6500 486f6c65 20256420  a line.Hole %d 
│ │ │    0x00084060 6973206e 6f742061 206c696e 6500496e is not a line.In
│ │ │    0x00084070 76616c69 64206f66 66736574 00506f69 valid offset.Poi
│ │ │    0x00084080 6e742069 6e736572 74206661 696c6564 nt insert failed
│ ├── rtpostgis-2.4.so
│ │ ├── objdump --line-numbers --disassemble --demangle --reloc --section=.text {}
│ │ │ @@ -17520,15 +17520,15 @@
│ │ │     1d009:        e8 52 d4 fe ff          callq  a460 <palloc <at> plt>
│ │ │     1d00e:        66 0f 6f 05 0a 4c 05    movdqa 0x54c0a(%rip),%xmm0        
│ │ │     1d015:        00 
│ │ │     1d016:        ba 3a 35 00 00          mov    $0x353a,%edx
│ │ │     1d01b:        c7 00 5c 00 00 00       movl   $0x5c,(%rax)
│ │ │     1d021:        66 89 50 14             mov    %dx,0x14(%rax)
│ │ │     1d025:        0f 11 40 04             movups %xmm0,0x4(%rax)
│ │ │ -   1d029:        c6 40 16 36             movb   $0x36,0x16(%rax)
│ │ │ +   1d029:        c6 40 16 32             movb   $0x32,0x16(%rax)
│ │ │     1d02d:        48 83 c4 08             add    $0x8,%rsp


├── share
│ ├── contrib
│ │ ├── postgis-2.4
│ │ │ ├── postgis.sql
│ │ │ │ @@ -2776,15 +2776,15 @@
│ │ │ │         LANGUAGE 'c' IMMUTABLE;
│ │ │ │  
│ │ │ │  CREATE OR REPLACE FUNCTION postgis_libxml_version() RETURNS text
│ │ │ │         AS '$libdir/postgis-2.4'
│ │ │ │         LANGUAGE 'c' IMMUTABLE;
│ │ │ │  
│ │ │ │  CREATE OR REPLACE FUNCTION postgis_scripts_build_date() RETURNS text
│ │ │ │ -       AS 'SELECT ''2019-12-18 12:39:56''::text AS version'
│ │ │ │ +       AS 'SELECT ''2019-12-18 12:36:52''::text AS version'
│ │ │ │         LANGUAGE 'sql' IMMUTABLE;
│ 


│ │ │ ├── uninstall_topology.sql
│ │ │ │ @@ -4,15 +4,15 @@
│ │ │ │  -- http://postgis.net 
│ │ │ │  -- 
│ │ │ │  -- This is free software; you can redistribute and/or modify it under 
│ │ │ │  -- the terms of the GNU General Public Licence. See the COPYING file. 
│ │ │ │  -- 
│ │ │ │  -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
│ │ │ │  -- 
│ │ │ │ --- Generated on: Wed 18 Dec 2019 12:42:14 PM UTC
│ │ │ │ +-- Generated on: Wed 18 Dec 2019 12:39:11 PM UTC



[Message part 2 (application/pgp-signature, inline)]

Information forwarded to bug-guix <at> gnu.org:
bug#38663; Package guix. (Thu, 19 Dec 2019 17:00:02 GMT) Full text and rfc822 format available.

Message #8 received at 38663 <at> debbugs.gnu.org (full text, mbox):

From: Ludovic Courtès <ludo <at> gnu.org>
To: Björn Höfling <bjoern.hoefling <at> bjoernhoefling.de>
Cc: 38663 <at> debbugs.gnu.org
Subject: Re: bug#38663: postgis is not reproducible
Date: Thu, 19 Dec 2019 17:59:00 +0100
Hi!

Björn Höfling <bjoern.hoefling <at> bjoernhoefling.de> skribis:

> │ │ │    0x00084000 322e342e 38003230 31392d31 322d3138 2.4.8.2019-12-18
> │ │ │ -  0x00084010 2031323a 33393a35 36002573 20722564  12:39:56.%s r%d
> │ │ │ +  0x00084010 2031323a 33363a35 32002573 20722564  12:36:52.%s r%d

I see a timestamps here!  :-)

Ludo’.




Information forwarded to bug-guix <at> gnu.org:
bug#38663; Package guix. (Thu, 19 Dec 2019 20:08:02 GMT) Full text and rfc822 format available.

Message #11 received at 38663 <at> debbugs.gnu.org (full text, mbox):

From: Gábor Boskovits <boskovits <at> gmail.com>
To: Björn Höfling <bjoern.hoefling <at> bjoernhoefling.de>
Cc: 38663 <at> debbugs.gnu.org
Subject: Re: bug#38663: postgis is not reproducible
Date: Thu, 19 Dec 2019 21:07:17 +0100
Hello,

Björn Höfling <bjoern.hoefling <at> bjoernhoefling.de> ezt írta (időpont:
2019. dec. 18., Sze, 22:16):
>
> Package postgis contains many timestamps, making it not reproducible.
>
> Some examples below.
>
> Björn
>
>
> --- /gnu/store/121c447hzz55milkdp7ak15vxmsi1xpr-postgis-2.4.8
> +++ /gnu/store/121c447hzz55milkdp7ak15vxmsi1xpr-postgis-2.4.8-check
> ├── lib
> │ ├── postgis-2.4.so
> │ │ ├── /gnu/store/mx2bgrpxkbdjsmhlxp9a30hbzcilk4cn-binutils-2.32/bin/readelf --wide --decompress --hex-dump=.rodata {}
> │ │ │ @@ -253,15 +253,15 @@
> │ │ │    0x00083fa0 6e617465 00000000 47656f6d 65747279 nate....Geometry
> │ │ │    0x00083fb0 20646f65 73206e6f 74206861 76652061  does not have a
> │ │ │    0x00083fc0 205a206f 7264696e 61746500 00000000  Z ordinate.....
> │ │ │    0x00083fd0 5363616c 65206661 63746f72 2067656f Scale factor geo
> │ │ │    0x00083fe0 6d657472 79207061 72616d65 74657220 metry parameter
> │ │ │    0x00083ff0 6d757374 20626520 6120706f 696e7400 must be a point.
> │ │ │    0x00084000 322e342e 38003230 31392d31 322d3138 2.4.8.2019-12-18
> │ │ │ -  0x00084010 2031323a 33393a35 36002573 20722564  12:39:56.%s r%d
> │ │ │ +  0x00084010 2031323a 33363a35 32002573 20722564  12:36:52.%s r%d
> │ │ │    0x00084020 00322e39 2e390031 2e32006c 7767656f .2.9.9.1.2.lwgeo
> │ │ │    0x00084030 6d5f6675 6e637469 6f6e735f 62617369 m_functions_basi
> │ │ │    0x00084040 632e6300 5368656c 6c206973 206e6f74 c.c.Shell is not
> │ │ │    0x00084050 2061206c 696e6500 486f6c65 20256420  a line.Hole %d
> │ │ │    0x00084060 6973206e 6f742061 206c696e 6500496e is not a line.In
> │ │ │    0x00084070 76616c69 64206f66 66736574 00506f69 valid offset.Poi
> │ │ │    0x00084080 6e742069 6e736572 74206661 696c6564 nt insert failed
> │ ├── rtpostgis-2.4.so
> │ │ ├── objdump --line-numbers --disassemble --demangle --reloc --section=.text {}
> │ │ │ @@ -17520,15 +17520,15 @@
> │ │ │     1d009:        e8 52 d4 fe ff          callq  a460 <palloc <at> plt>
> │ │ │     1d00e:        66 0f 6f 05 0a 4c 05    movdqa 0x54c0a(%rip),%xmm0
> │ │ │     1d015:        00
> │ │ │     1d016:        ba 3a 35 00 00          mov    $0x353a,%edx
> │ │ │     1d01b:        c7 00 5c 00 00 00       movl   $0x5c,(%rax)
> │ │ │     1d021:        66 89 50 14             mov    %dx,0x14(%rax)
> │ │ │     1d025:        0f 11 40 04             movups %xmm0,0x4(%rax)
> │ │ │ -   1d029:        c6 40 16 36             movb   $0x36,0x16(%rax)
> │ │ │ +   1d029:        c6 40 16 32             movb   $0x32,0x16(%rax)
> │ │ │     1d02d:        48 83 c4 08             add    $0x8,%rsp
>
>
> ├── share
> │ ├── contrib
> │ │ ├── postgis-2.4
> │ │ │ ├── postgis.sql
> │ │ │ │ @@ -2776,15 +2776,15 @@
> │ │ │ │         LANGUAGE 'c' IMMUTABLE;
> │ │ │ │
> │ │ │ │  CREATE OR REPLACE FUNCTION postgis_libxml_version() RETURNS text
> │ │ │ │         AS '$libdir/postgis-2.4'
> │ │ │ │         LANGUAGE 'c' IMMUTABLE;
> │ │ │ │
> │ │ │ │  CREATE OR REPLACE FUNCTION postgis_scripts_build_date() RETURNS text
> │ │ │ │ -       AS 'SELECT ''2019-12-18 12:39:56''::text AS version'
> │ │ │ │ +       AS 'SELECT ''2019-12-18 12:36:52''::text AS version'
> │ │ │ │         LANGUAGE 'sql' IMMUTABLE;
> │
>
>
> │ │ │ ├── uninstall_topology.sql
> │ │ │ │ @@ -4,15 +4,15 @@
> │ │ │ │  -- http://postgis.net
> │ │ │ │  --
> │ │ │ │  -- This is free software; you can redistribute and/or modify it under
> │ │ │ │  -- the terms of the GNU General Public Licence. See the COPYING file.
> │ │ │ │  --
> │ │ │ │  -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
> │ │ │ │  --
> │ │ │ │ --- Generated on: Wed 18 Dec 2019 12:42:14 PM UTC
> │ │ │ │ +-- Generated on: Wed 18 Dec 2019 12:39:11 PM UTC
>
>
>
It seems that version 3.0.0 is out for two months. I will try to
update this first, then have a look at reproducibility. Wdyt?

-- 
OpenPGP Key Fingerprint: 7988:3B9F:7D6A:4DBF:3719:0367:2506:A96C:CF63:0B21




Information forwarded to bug-guix <at> gnu.org:
bug#38663; Package guix. (Sat, 21 Dec 2019 05:01:01 GMT) Full text and rfc822 format available.

Message #14 received at 38663 <at> debbugs.gnu.org (full text, mbox):

From: Arun Isaac <arunisaac <at> systemreboot.net>
To: Gábor Boskovits <boskovits <at> gmail.com>, Björn Höfling <bjoern.hoefling <at> bjoernhoefling.de>
Cc: 38663 <at> debbugs.gnu.org
Subject: Re: bug#38663: postgis is not reproducible
Date: Sat, 21 Dec 2019 10:30:11 +0530
[Message part 1 (text/plain, inline)]
> It seems that version 3.0.0 is out for two months. I will try to
> update this first, then have a look at reproducibility. Wdyt?

I have a patch updating postgis as well as many other packages in
geo.scm. Please see https://debbugs.gnu.org/cgi/bugreport.cgi?bug=38149
[signature.asc (application/pgp-signature, inline)]

Reply sent to Björn Höfling <bjoern.hoefling <at> bjoernhoefling.de>:
You have taken responsibility. (Thu, 02 Jan 2020 09:35:02 GMT) Full text and rfc822 format available.

Notification sent to Björn Höfling <bjoern.hoefling <at> bjoernhoefling.de>:
bug acknowledged by developer. (Thu, 02 Jan 2020 09:35:02 GMT) Full text and rfc822 format available.

Message #19 received at 38663-done <at> debbugs.gnu.org (full text, mbox):

From: Björn Höfling <bjoern.hoefling <at> bjoernhoefling.de>
To: Arun Isaac <arunisaac <at> systemreboot.net>
Cc: 38663-done <at> debbugs.gnu.org,
 Gábor Boskovits <boskovits <at> gmail.com>
Subject: Re: bug#38663: postgis is not reproducible
Date: Thu, 2 Jan 2020 10:34:02 +0100
[Message part 1 (text/plain, inline)]
On Sat, 21 Dec 2019 10:30:11 +0530
Arun Isaac <arunisaac <at> systemreboot.net> wrote:

> > It seems that version 3.0.0 is out for two months. I will try to
> > update this first, then have a look at reproducibility. Wdyt?  
> 
> I have a patch updating postgis as well as many other packages in
> geo.scm. Please see
> https://debbugs.gnu.org/cgi/bugreport.cgi?bug=38149

This is fixed with the new 3.0.0
version commited as

871828b921db55af02a462286c7293e9bcb9108a

Thanks,

Björn
[Message part 2 (application/pgp-signature, inline)]

bug archived. Request was from Debbugs Internal Request <help-debbugs <at> gnu.org> to internal_control <at> debbugs.gnu.org. (Thu, 30 Jan 2020 12:24:07 GMT) Full text and rfc822 format available.

This bug report was last modified 4 years and 59 days ago.

Previous Next


GNU bug tracking system
Copyright (C) 1999 Darren O. Benham, 1997,2003 nCipher Corporation Ltd, 1994-97 Ian Jackson.