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.

Reply via email to