[Pkg-postgresql-public] Bug#795729: libpqtypes: FTBFS under some timezones (eg. GMT+12)

Chris Lamb lamby at debian.org
Sun Aug 16 13:17:58 UTC 2015


Source: libpqtypes
Version: 1.5.1-2
Severity: serious
Justification: fails to build from source

Dear Maintainer,

libpqtypes fails to build from source on unstable/amd64 under
some timezones (eg. TZ="/usr/share/zoneinfo/Etc/GMT+12"):

  [..]
     debian/rules override_dh_auto_test
  make[1]: Entering directory '/tmp/buildd/libpqtypes-1.5.1'
  /usr/bin/make test LDFLAGS+=-L.libs
  make[2]: Entering directory '/tmp/buildd/libpqtypes-1.5.1'
  gcc -g -O2 -fstack-protector-strong -Wformat -Werror=format-security
  -O3 -Wall -Wpointer-arith -D_GNU_SOURCE -D_REENTRANT -fsigned-char
  -std=gnu99 -Wclobbered -Wempty-body -Wignored-qualifiers
  -Wmissing-parameter-type -Wold-style-declaration -Woverride-init
  -Wsign-compare -Wtype-limits -Wuninitialized -fomit-frame-pointer
  -fno-strict-aliasing -funroll-all-loops -funit-at-a-time -Wdate-time
  -D_FORTIFY_SOURCE=2 -I/usr/include/postgresql -Isrc -DHAVE_CONFIG_H \
  	-o test src/regression-test.c -Wl,-z,relro -L.libs -lm  -lpq
  	-lpqtypes
  src/regression-test.c: In function 'main':
  src/regression-test.c:235:11: warning: variable 'ba' set but not used
  [-Wunused-but-set-variable]
     PGbytea ba;
             ^
  make[2]: Leaving directory '/tmp/buildd/libpqtypes-1.5.1'
  LD_LIBRARY_PATH=:.libs pg_virtualenv ./test ""
  install: cannot change owner and permissions of
  '/tmp/pg_virtualenv.2sBpjO/postgresql/9.4': Operation not permitted
  Creating new cluster 9.4/regress ...
    config /tmp/pg_virtualenv.2sBpjO/postgresql/9.4/regress
    data   /tmp/pg_virtualenv.2sBpjO/data/9.4/regress
    locale C
  Warning: The socket directory for owners other than 'postgres'
  defaults to /tmp. You might want to change the unix_socket_directories
  parameter
  in postgresql.conf to a more secure directory.
    port   5432
  Warning: The parent /var/run/postgresql of the selected
  stats_temp_directory is not writable for the cluster owner. Not adding
  this
  setting in postgresql.conf.
  server type lookup failed: could not find 'mytype_t'
    %epoch - passed
    %epoch - passed
    %timestamptz - FAILED
  
  Composites & Arrays: (always binary)
    Testing empty array handling - passed
    composite[] with nested composite and arrays passed
  
  PQputvf
    SELECT $1 + ($2 % $3) AS answer
    PQputvf - passed
  
  PQspecPrepare
    PQspecPrepare - passed
  
  Native C types: (text)
    %char - passed
    %char - passed
    %int2 - passed
    %int2 - passed
    %int4 - passed
    %int4 - passed
    %int8 - passed
    %int8 - passed
    %float4 - passed
    %float4 - passed
    %float8 - passed
    %float8 - passed
    %money - passed
    %money - passed
    %oid - passed
    %oid - passed
    %bool - passed
    %bool - passed
  
  Native C types: (binary)
    %char - passed
    %char - passed
    %int2 - passed
    %int2 - passed
    %int4 - passed
    %int4 - passed
    %int8 - passed
    %int8 - passed
    %float4 - passed
    %float4 - passed
    %float8 - passed
    %float8 - passed
    %money - passed
    %money - passed
    %oid - passed
    %oid - passed
    %bool - passed
    %bool - passed
  
  Variable-length types: (text)
    %bpchar - passed
    %varchar - passed
    %text - passed
    %bytea* - passed
    %uuid - passed
    %numeric - passed
  
  Variable-length types: (binary)
    %bpchar - passed
    %varchar - passed
    %text - passed
    %bytea* - passed
    %uuid - passed
    %numeric - passed
  
  Geometric types: (text)
    %point - passed
    %lseg - passed
    %box - passed
    %circle - passed
    %path - passed
    %polygon - passed
  
  Geometric types: (binary)
    %point - passed
    %lseg - passed
    %box - passed
    %circle - passed
    %path - passed
    %polygon - passed
  
  Network types: (text)
    %inet - IPv4 passed
    %inet - IPv6 passed
    %macaddr - passed
  
  Network types: (binary)
    %inet - IPv4 passed
    %inet - IPv6 passed
    %macaddr - passed
  
  Sub-class: (text)
    epoch_put('0')
    epoch_put('946702800')
    epoch_get(text)
    epoch_get(text)
  
  Sub-class: (binary)
    epoch_put('0')
    epoch_put('946702800')
    epoch_get(binary)
    epoch_get(binary)
  
  Date & Time types: (text 'ISO, MDY')
    %date - #1 passed
    %date - #2 passed
    %date - #3 passed
    %time - #1 passed
    %time - #2 passed
    %time - #3 passed
    %timetz - #1 passed
    %timetz - #2 passed
    %timetz - #3 passed
    %timestamp - #1 passed
    %timestamp - #2 passed
    %timestamp - #3 passed
    %interval - passed
    %timestamptz - passed
  
  Date & Time types: (binary 'ISO, MDY')
    %date - #1 passed
    %date - #2 passed
    %date - #3 passed
    %time - #1 passed
    %time - #2 passed
    %time - #3 passed
    %timetz - #1 passed
    %timetz - #2 passed
    %timetz - #3 passed
    %timestamp - #1 passed
    %timestamp - #2 passed
    %timestamp - #3 passed
    %interval - passed
    %timestamptz - passed
  
  Date & Time types: (text 'Postgres, MDY')
    %date - #1 passed
    %date - #2 passed
    %date - #3 passed
    %time - #1 passed
    %time - #2 passed
    %time - #3 passed
    %timetz - #1 passed
    %timetz - #2 passed
    %timetz - #3 passed
    %timestamp - #1 passed
    %timestamp - #2 passed
    %timestamp - #3 passed
    **NOTE: non-ISO DateStyle interval text has a 2 digit limit on the
    microsecond value ... adjusting
      => sent=29333, received=29333
    %interval - passed
  SENT:
  epoch=315532800,isbc=0,yr=1979,mon=11,mday=31,jday=0,yday=0,wday=0,hr=12,min=0,sec=0,usec=0,withtz=1,isdst=0,tzabbr=GMT+12,gmtoff=-43200
  RECV:
  epoch=315489600,isbc=0,yr=1979,mon=11,mday=31,jday=2444239,yday=364,wday=1,hr=12,min=0,sec=0,usec=0,withtz=1,isdst=-1,tzabbr=USR/SHARE,gmtoff=0
  
  Date & Time types: (binary 'Postgres, MDY')
    %date - #1 passed
    %date - #2 passed
    %date - #3 passed
    %time - #1 passed
    %time - #2 passed
    %time - #3 passed
    %timetz - #1 passed
    %timetz - #2 passed
    %timetz - #3 passed
    %timestamp - #1 passed
    %timestamp - #2 passed
    %timestamp - #3 passed
    %interval - passed
    %timestamptz - passed
  
  Ran 125 tests - 1 failed
  /tmp/pg_virtualenv.2sBpjO/log/postgresql-9.4-regress.log:
  2015-07-16 05:05:19 /USR/SHARE/ZONEINFO/ETC/GMT [55005-1] LOG: 
  database system was shut down at 2015-07-16 05:05:19
  /USR/SHARE/ZONEINFO/ETC/GMT
  2015-07-16 05:05:19 /USR/SHARE/ZONEINFO/ETC/GMT [55005-2] LOG: 
  MultiXact member wraparound protections are now enabled
  2015-07-16 05:05:19 /USR/SHARE/ZONEINFO/ETC/GMT [55001-1] LOG: 
  database system is ready to accept connections
  2015-07-16 05:05:19 /USR/SHARE/ZONEINFO/ETC/GMT [55010-1] LOG: 
  autovacuum launcher started
  2015-07-16 05:05:20 /USR/SHARE/ZONEINFO/ETC/GMT [55112-1]
  [unknown]@[unknown] LOG:  incomplete startup packet
  2015-07-16 05:05:22 /USR/SHARE/ZONEINFO/ETC/GMT [55714-1]
  pbuilder1 at postgres ERROR:  table "libpq_array" does not exist
  2015-07-16 05:05:22 /USR/SHARE/ZONEINFO/ETC/GMT [55714-2]
  pbuilder1 at postgres STATEMENT:  DROP TABLE libpq_array
  2015-07-16 05:05:22 /USR/SHARE/ZONEINFO/ETC/GMT [55714-3]
  pbuilder1 at postgres ERROR:  type "public.complex" does not exist
  2015-07-16 05:05:22 /USR/SHARE/ZONEINFO/ETC/GMT [55714-4]
  pbuilder1 at postgres STATEMENT:  DROP TYPE public.complex
  2015-07-16 05:05:22 /USR/SHARE/ZONEINFO/ETC/GMT [55714-5]
  pbuilder1 at postgres ERROR:  type "public.simple" does not exist
  2015-07-16 05:05:22 /USR/SHARE/ZONEINFO/ETC/GMT [55714-6]
  pbuilder1 at postgres STATEMENT:  DROP TYPE public.simple
  Stopping cluster 9.4/regress...
  debian/rules:6: recipe for target 'override_dh_auto_test' failed
  make[1]: *** [override_dh_auto_test] Error 1
  make[1]: Leaving directory '/tmp/buildd/libpqtypes-1.5.1'
  debian/rules:17: recipe for target 'build' failed
  make: *** [build] Error 2
  dpkg-buildpackage: error: debian/rules build gave error exit status 2

  [..]

The full build log is attached or can be viewed here:

  https://reproducible.debian.net/logs/unstable/amd64/libpqtypes_1.5.1-2.build1.log.gz


Regards,

-- 
      ,''`.
     : :'  :     Chris Lamb
     `. `'`      lamby at debian.org / chris-lamb.co.uk
       `-
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: libpqtypes.1.5.1-2.unstable.amd64.log.txt
URL: <http://lists.alioth.debian.org/pipermail/pkg-postgresql-public/attachments/20150816/bae4d921/attachment-0001.txt>


More information about the Pkg-postgresql-public mailing list