Subject: bug#38663: closed (Re: bug#38663: postgis is not reproducible)

From: [email-masked] (GNU bug Tracking System)
Date: Thu, 02 Jan 2020 09:35:02 +0000

Your bug report

#38663: postgis is not reproducible

which was filed against the guix package, has been closed.

The explanation is attached below, along with your original report.
If you require more details, please reply to [email-masked].

-- 
38663: http://debbugs.gnu.org/cgi/bugreport.cgi?bug=38663
GNU Bug Tracking System
Contact [email-masked] with problems

Subject: Re: bug#38663: postgis is not reproducible
From: Björn Höfling <[email-masked]>
To: Arun Isaac <[email-masked]>
Cc: [email-masked],Gábor Boskovits <[email-masked]>
Date: Thu, 2 Jan 2020 10:34:02 +0100
List-Id: <debbugs-submit.debbugs.gnu.org>

On Sat, 21 Dec 2019 10:30:11 +0530
Arun Isaac <[email-masked]> 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

Subject: postgis is not reproducible
From: Björn Höfling <[email-masked]>
To: <[email-masked]>
Date: Wed, 18 Dec 2019 22:13:34 +0100
List-Id: <debbugs-submit.debbugs.gnu.org>

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@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