bug#38663: postgis is not reproducible

unofficial mirror of bug-guix@gnu.org 
 help / color / mirror / code / Atom feed

* bug#38663: postgis is not reproducible
@ 2019-12-18 21:13 Björn Höfling
  2019-12-19 16:59 ` Ludovic Courtès
  2019-12-19 20:07 ` Gábor Boskovits
  0 siblings, 2 replies; 5+ messages in thread
From: Björn Höfling @ 2019-12-18 21:13 UTC (permalink / raw)
  To: 38663

[-- Attachment #1: Type: text/plain, Size: 3957 bytes --]

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




[-- Attachment #2: OpenPGP digital signature --]
[-- Type: application/pgp-signature, Size: 195 bytes --]

^ permalink raw reply	[flat|nested] 5+ messages in thread

* bug#38663: postgis is not reproducible
  2019-12-18 21:13 bug#38663: postgis is not reproducible Björn Höfling
@ 2019-12-19 16:59 ` Ludovic Courtès
  2019-12-19 20:07 ` Gábor Boskovits
  1 sibling, 0 replies; 5+ messages in thread
From: Ludovic Courtès @ 2019-12-19 16:59 UTC (permalink / raw)
  To: Björn Höfling; +Cc: 38663

Hi!

Björn Höfling <bjoern.hoefling@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’.

^ permalink raw reply	[flat|nested] 5+ messages in thread

* bug#38663: postgis is not reproducible
  2019-12-18 21:13 bug#38663: postgis is not reproducible Björn Höfling
  2019-12-19 16:59 ` Ludovic Courtès
@ 2019-12-19 20:07 ` Gábor Boskovits
  2019-12-21  5:00   ` Arun Isaac
  1 sibling, 1 reply; 5+ messages in thread
From: Gábor Boskovits @ 2019-12-19 20:07 UTC (permalink / raw)
  To: Björn Höfling; +Cc: 38663

Hello,

Björn Höfling <bjoern.hoefling@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@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

^ permalink raw reply	[flat|nested] 5+ messages in thread

* bug#38663: postgis is not reproducible
  2019-12-19 20:07 ` Gábor Boskovits
@ 2019-12-21  5:00   ` Arun Isaac
  2020-01-02  9:34     ` Björn Höfling
  0 siblings, 1 reply; 5+ messages in thread
From: Arun Isaac @ 2019-12-21  5:00 UTC (permalink / raw)
  To: Gábor Boskovits, Björn Höfling; +Cc: 38663

[-- Attachment #1: Type: text/plain, Size: 271 bytes --]


> 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

[-- Attachment #2: signature.asc --]
[-- Type: application/pgp-signature, Size: 487 bytes --]

^ permalink raw reply	[flat|nested] 5+ messages in thread

* bug#38663: postgis is not reproducible
  2019-12-21  5:00   ` Arun Isaac
@ 2020-01-02  9:34     ` Björn Höfling
  0 siblings, 0 replies; 5+ messages in thread
From: Björn Höfling @ 2020-01-02  9:34 UTC (permalink / raw)
  To: Arun Isaac; +Cc: 38663-done

[-- Attachment #1: Type: text/plain, Size: 498 bytes --]

On Sat, 21 Dec 2019 10:30:11 +0530
Arun Isaac <arunisaac@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

[-- Attachment #2: OpenPGP digital signature --]
[-- Type: application/pgp-signature, Size: 195 bytes --]

^ permalink raw reply	[flat|nested] 5+ messages in thread

end of thread, other threads:[~2020-01-02  9:35 UTC | newest]

Thread overview: 5+ messages (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2019-12-18 21:13 bug#38663: postgis is not reproducible Björn Höfling
2019-12-19 16:59 ` Ludovic Courtès
2019-12-19 20:07 ` Gábor Boskovits
2019-12-21  5:00   ` Arun Isaac
2020-01-02  9:34     ` Björn Höfling

Code repositories for project(s) associated with this public inbox

	https://git.savannah.gnu.org/cgit/guix.git

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).