Your message dated Tue, 16 Aug 2022 10:41:52 +0200
with message-id <yvtyukcacxjks...@msg.df7cb.de>
and subject line Re: Bug#1016343: pgloader: FTBFS: make[2]: *** [Makefile:125:
regress/out/csv-districts.out] Error 1
has caused the Debian Bug report #1016343,
regarding pgloader: FTBFS: make[2]: *** [Makefile:125:
regress/out/csv-districts.out] Error 1
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact ow...@bugs.debian.org
immediately.)
--
1016343: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=1016343
Debian Bug Tracking System
Contact ow...@bugs.debian.org with problems
--- Begin Message ---
Source: pgloader
Version: 3.6.6-1
Severity: serious
Justification: FTBFS
Tags: bookworm sid ftbfs
User: lu...@debian.org
Usertags: ftbfs-20220728 ftbfs-bookworm
Hi,
During a rebuild of all packages in sid, your package failed to build
on amd64.
Relevant part (hopefully):
> make[2]: Entering directory '/<<PKGBUILDDIR>>/test'
> dropdb -U user42 pgloader
> dropdb: error: database removal failed: ERROR: database "pgloader" does not
> exist
> make[2]: [Makefile:67: prepare] Error 1 (ignored)
> dropdb -U user42 stocks
> dropdb: error: database removal failed: ERROR: database "stocks" does not
> exist
> make[2]: [Makefile:68: prepare] Error 1 (ignored)
> dropdb -U user42 ip4r
> dropdb: error: database removal failed: ERROR: database "ip4r" does not exist
> make[2]: [Makefile:69: prepare] Error 1 (ignored)
> createuser -U user42 --superuser `whoami`
> createdb -U user42 -O `whoami` pgloader
> createdb -U user42 -O `whoami` stocks
> createdb -U user42 -O `whoami` ip4r
> psql -d pgloader -c 'create schema expected'
> CREATE SCHEMA
> psql -U user42 -d pgloader -c 'create extension ip4r'
> CREATE EXTENSION
> psql -U user42 -d ip4r -c 'create extension ip4r'
> CREATE EXTENSION
> psql -d stocks -f bossa.sql
> psql:bossa.sql:7: NOTICE: table "intf_derivatives" does not exist, skipping
> psql:bossa.sql:7: NOTICE: table "intf_stocks" does not exist, skipping
> DROP TABLE
> CREATE TABLE
> CREATE TABLE
> rm -f regress/out/*
> pgloader --regress allcols.load
> 2022-07-29T09:27:36.012000Z LOG pgloader version "3.6.3~devel"
> 2022-07-29T09:27:36.016000Z LOG Parsing commands from file
> #P"/<<PKGBUILDDIR>>/test/allcols.load"
> 2022-07-29T09:27:36.048000Z WARNING pgloader always talk to PostgreSQL in
> utf-8, client_encoding has been forced to 'utf8'.
> 2022-07-29T09:27:36.156000Z WARNING Target table "\"public\".\"allcols\"" has
> 1 indexes defined against it.
> 2022-07-29T09:27:36.156000Z WARNING That could impact loading performance
> badly.
> 2022-07-29T09:27:36.156000Z WARNING Consider the option 'drop indexes'.
> 2022-07-29T09:27:36.212000Z WARNING pgloader always talk to PostgreSQL in
> utf-8, client_encoding has been forced to 'utf8'.
> 2022-07-29T09:27:36.216000Z LOG Comparing loaded data against
> (#P"/<<PKGBUILDDIR>>/test/regress/expected/allcols.out")
> 2022-07-29T09:27:36.220000Z WARNING PostgreSQL warning: table "allcols" does
> not exist, skipping
> 2022-07-29T09:27:36.260000Z LOG report summary reset
> table name errors rows bytes total time
> ----------------------- --------- --------- --------- --------------
> fetch 0 0 0.004s
> before load 0 2 0.008s
> ----------------------- --------- --------- --------- --------------
> "public"."allcols" 0 8 0.2 kB 0.024s
> "expected"."allcols" 0 8 0.2 kB 0.004s
> ----------------------- --------- --------- --------- --------------
> Files Processed 0 2 0.024s
> COPY Threads Completion 0 4 0.028s
> ----------------------- --------- --------- --------- --------------
> Total import time ✓ 16 0.4 kB 0.052s
> 2022-07-29T09:27:36.292000Z LOG Regress pass.
> touch regress/out/allcols.out
> pgloader --regress csv-before-after.load
> 2022-07-29T09:27:37.008000Z LOG pgloader version "3.6.3~devel"
> 2022-07-29T09:27:37.340000Z LOG Comparing loaded data against
> (#P"/<<PKGBUILDDIR>>/test/regress/expected/csv-before-after.out")
> 2022-07-29T09:27:37.340000Z WARNING PostgreSQL warning: table "blocks" does
> not exist, skipping
> 2022-07-29T09:27:37.428000Z LOG report summary reset
> table name errors rows bytes total time
> ----------------------- --------- --------- --------- --------------
> fetch 0 0 0.004s
> before load 0 6 0.008s
> ----------------------- --------- --------- --------- --------------
> "csv"."blocks" 0 460 15.9 kB 0.128s
> "expected"."blocks" 0 460 12.4 kB 0.052s
> ----------------------- --------- --------- --------- --------------
> Files Processed 0 2 0.028s
> COPY Threads Completion 0 4 0.180s
> after load 0 1 0.004s
> ----------------------- --------- --------- --------- --------------
> Total import time ✓ 920 28.2 kB 0.212s
> 2022-07-29T09:27:37.456000Z LOG Regress pass.
> touch regress/out/csv-before-after.out
> pgloader --regress csv-districts.load
> 2022-07-29T09:27:37.012000Z LOG pgloader version "3.6.3~devel"
> KABOOM!
> FATAL error: deleting unreachable code
> An unhandled error condition has been signalled: deleting unreachable code
>
>
>
> ;
> ; compilation unit aborted
> ; caught 1 fatal ERROR condition
>
> What I am doing here?
>
> deleting unreachable code
>
> make[2]: *** [Makefile:125: regress/out/csv-districts.out] Error 1
The full build log is available from:
http://qa-logs.debian.net/2022/07/28/pgloader_3.6.6-1_unstable.log
All bugs filed during this archive rebuild are listed at:
https://bugs.debian.org/cgi-bin/pkgreport.cgi?tag=ftbfs-20220728;users=lu...@debian.org
or:
https://udd.debian.org/bugs/?release=na&merged=ign&fnewerval=7&flastmodval=7&fusertag=only&fusertagtag=ftbfs-20220728&fusertaguser=lu...@debian.org&allbugs=1&cseverity=1&ctags=1&caffected=1#results
A list of current common problems and possible solutions is available at
http://wiki.debian.org/qa.debian.org/FTBFS . You're welcome to contribute!
If you reassign this bug to another package, please marking it as 'affects'-ing
this package. See https://www.debian.org/Bugs/server-control#affects
If you fail to reproduce this, please provide a build log and diff it with mine
so that we can identify if something relevant changed in the meantime.
--- End Message ---
--- Begin Message ---
Version: 3.6.7-1
> > KABOOM!
> > FATAL error: deleting unreachable code
> > An unhandled error condition has been signalled: deleting unreachable code
This was fixed in the last upload.
Christoph
--- End Message ---
