Public bug reported:

FTBFS on ppc64 as synced over from Debian
=> https://launchpad.net/ubuntu/+source/postgis/3.1.4+dfsg-3build1

Failing log:
https://launchpadlibrarian.net/569861170/buildlog_ubuntu-jammy-ppc64el.postgis_3.1.4+dfsg-3build1_BUILDING.txt.gz

The same built fine in Debian
=> 
https://buildd.debian.org/status/fetch.php?pkg=postgis&arch=ppc64el&ver=3.1.4%2Bdfsg-3%2Bb1&stamp=1634938635&raw=0


Error:

./regress/core/mvt .. failed (diff expected obtained: 
/tmp/pgis_reg/test_110_diff)
-----------------------------------------------------------------------------
--- ./regress/core/mvt_expected 2021-09-04 05:03:43.000000000 +0000
+++ /tmp/pgis_reg/test_110_out  2021-11-20 06:56:10.856917815 +0000
@@ -138,7 +138,7 @@
 #4348Clip|t
 #4348Invalid|t
 #4348Dropped|t
-#4348ReversedSmall|t
+#4348ReversedSmall|
 #4348Reversed2|t
 #4348Point|t
 #4348Crash|t
-----------------------------------------------------------------------------


Later there is a test log detail:


Failed: 1
make[2]: *** [regress/runtest.mk:10: check-regress] Error 1
make[2]: Leaving directory '/<<BUILDDIR>>/postgis-3.1.4+dfsg'
*** /tmp/pg_virtualenv.DM9fVH/log/postgresql-14-regress.log (last 100 lines) ***
                ST_Grayscale(rast)
        FROM raster_grayscale_in
        ORDER BY rid
        LIMIT 1;
2021-11-20 06:57:01.875 UTC [28528] buildd@postgis_reg ERROR:  Band at index 
'2' not found for raster '2'
2021-11-20 06:57:01.875 UTC [28528] buildd@postgis_reg CONTEXT:  PL/pgSQL 
function st_grayscale(rastbandarg[],text) line 41 at RAISE
2021-11-20 06:57:01.875 UTC [28528] buildd@postgis_reg STATEMENT:  SELECT
                ST_Grayscale(
                        ARRAY[
                                ROW(rast, 1)::rastbandarg,
                                ROW(rast, 2)::rastbandarg,
                                ROW(rast, 1)::rastbandarg
                        ]::rastbandarg[]
                )
        FROM raster_grayscale_in
        ORDER BY rid
        LIMIT 1;
ORC error: No callback manager available for powerpc64le-unknown-linux-gnu
ORC error: No callback manager available for powerpc64le-unknown-linux-gnu
ORC error: No callback manager available for powerpc64le-unknown-linux-gnu
ORC error: No callback manager available for powerpc64le-unknown-linux-gnu
2021-11-20 06:57:03.210 UTC [28576] buildd@postgis_reg ERROR:  Tolerance cannot 
be less than zero
        
2021-11-20 06:57:03.210 UTC [28576] buildd@postgis_reg STATEMENT:  SELECT
                '2.2',
                r1.rid,
                r2.rid,
                -1 AS distance,
                ST_DWithin(r1.rast, NULL, r2.rast, NULL, -1)
        FROM raster_geos_rast r1
        CROSS JOIN raster_geos_rast r2
        WHERE r1.rid = 0;
2021-11-20 06:57:03.216 UTC [28576] buildd@postgis_reg ERROR:  Tolerance cannot 
be less than zero
        
2021-11-20 06:57:03.216 UTC [28576] buildd@postgis_reg STATEMENT:  SELECT
                '2.4',
                r1.rid,
                r2.rid,
                -1 AS distance,
                ST_DFullyWithin(r1.rast, NULL, r2.rast, NULL, -1)
        FROM raster_geos_rast r1
        CROSS JOIN raster_geos_rast r2
        WHERE r1.rid = 0;
ORC error: No callback manager available for powerpc64le-unknown-linux-gnu
ORC error: No callback manager available for powerpc64le-unknown-linux-gnu
ERROR 4: `/vsimem/in.dat' not recognized as a supported file format.
2021-11-20 06:57:04.606 UTC [28612] buildd@postgis_reg ERROR:  
RASTER_fromGDALRaster: Could not open bytea with GDAL. Check that the bytea is 
of a GDAL supported format
2021-11-20 06:57:04.606 UTC [28612] buildd@postgis_reg STATEMENT:  SELECT 
convert_from(ST_AsGDALRaster(ST_FromGDALRaster('<VRTDataset rasterXSize="1000"
        rasterYSize="1"><VRTRasterBand band="1"
        
subClass="VRTRawRasterBand"><SourceFilename>/etc/passwd</SourceFilename></VRTRasterBand></VRTDataset>'::bytea),
        'EHDR')::bytea, 'LATIN1');
ERROR 4: <VRTDataset rasterXSize="1000" rasterYSize="1"><VRTRasterBand band="1" 
subClass="VRTRawRasterBand"><SourceFilename>/etc/passwd</SourceFilename></VRTRasterBand></VRTDataset>:
 No such file or directory
2021-11-20 06:57:04.609 UTC [28612] buildd@postgis_reg ERROR:  
rt_band_load_offline_data: Cannot open offline raster: <VRTDataset 
rasterXSize="1000" rasterYSize="1"><VRTRasterBand band="1" 
subClass="VRTRawRasterBand"><SourceFilename>/etc/passwd</SourceFilename></VRTRasterBand></VRTDataset>
2021-11-20 06:57:04.609 UTC [28612] buildd@postgis_reg STATEMENT:  SELECT 
count(convert_from(ST_AsGDALRaster(r, 'EHDR')::bytea, 'LATIN1')) as passwd from 
raster_test where lbl = 'passwd';
ERROR 4: <VRTDataset rasterXSize="1000" rasterYSize="1"><VRTRasterBand band="1" 
subClass="VRTRawRasterBand"><SourceFilename>/etc/passwd</SourceFilename></VRTRasterBand></VRTDataset>:
 No such file or directory
2021-11-20 06:57:04.610 UTC [28612] buildd@postgis_reg ERROR:  
rt_band_load_offline_data: Cannot open offline raster: <VRTDataset 
rasterXSize="1000" rasterYSize="1"><VRTRasterBand band="1" 
subClass="VRTRawRasterBand"><SourceFilename>/etc/passwd</SourceFilename></VRTRasterBand></VRTDataset>
2021-11-20 06:57:04.610 UTC [28612] buildd@postgis_reg STATEMENT:  SELECT 
count(convert_from(ST_AsGDALRaster(r, 'EHDR')::bytea, 'LATIN1')) as passwd from 
raster_test where lbl = 'passwd';
ERROR 4: <VRTDataset rasterXSize="1000" rasterYSize="1"><VRTRasterBand band="1" 
subClass="VRTRawRasterBand"><SourceFilename>/etc/passwd</SourceFilename></VRTRasterBand></VRTDataset>:
 No such file or directory
2021-11-20 06:57:04.616 UTC [28612] buildd@postgis_reg ERROR:  
rt_band_load_offline_data: Cannot open offline raster: <VRTDataset 
rasterXSize="1000" rasterYSize="1"><VRTRasterBand band="1" 
subClass="VRTRawRasterBand"><SourceFilename>/etc/passwd</SourceFilename></VRTRasterBand></VRTDataset>
2021-11-20 06:57:04.616 UTC [28612] buildd@postgis_reg STATEMENT:  SELECT 
count(convert_from(ST_AsGDALRaster(r, 'EHDR')::bytea, 'LATIN1')) as passwd from 
raster_test where lbl = 'passwd';
ERROR 4: <VRTDataset rasterXSize="1000" rasterYSize="1"><VRTRasterBand band="1" 
subClass="VRTRawRasterBand"><SourceFilename>/etc/passwd</SourceFilename></VRTRasterBand></VRTDataset>:
 No such file or directory
2021-11-20 06:57:04.616 UTC [28612] buildd@postgis_reg ERROR:  
rt_band_load_offline_data: Cannot open offline raster: <VRTDataset 
rasterXSize="1000" rasterYSize="1"><VRTRasterBand band="1" 
subClass="VRTRawRasterBand"><SourceFilename>/etc/passwd</SourceFilename></VRTRasterBand></VRTDataset>
2021-11-20 06:57:04.616 UTC [28612] buildd@postgis_reg STATEMENT:  SELECT 
count(convert_from(ST_AsGDALRaster(r, 'EHDR')::bytea, 'LATIN1')) as passwd from 
raster_test where lbl = 'passwd';
2021-11-20 06:57:04.804 UTC [28624] buildd@postgis_reg WARNING:  Unable to add 
constraint: 'scale_x'.  Skipping
2021-11-20 06:57:04.804 UTC [28624] buildd@postgis_reg CONTEXT:  PL/pgSQL 
function addrasterconstraints(name,name,name,text[]) line 113 at RAISE
2021-11-20 06:57:04.807 UTC [28624] buildd@postgis_reg ERROR:  new row for 
relation "test_raster_scale_regular" violates check constraint 
"enforce_scaley_rast"
2021-11-20 06:57:04.807 UTC [28624] buildd@postgis_reg DETAIL:  Failing row 
contains (3, 
01000001006ABC74931804F03FCB1A50CAFFFFEF3F0000000000000000000000...).
2021-11-20 06:57:04.807 UTC [28624] buildd@postgis_reg CONTEXT:  SQL statement 
"INSERT INTO test_raster_scale_regular VALUES ('3', 
'01000001006ABC74931804F03FCB1A50CAFFFFEF3F00000000000000000000000000000000000000000000000000000000000000000000000002000200440001010101')"
        PL/pgSQL function make_test_raster(text,integer,double precision,double 
precision) line 16 at EXECUTE
2021-11-20 06:57:04.807 UTC [28624] buildd@postgis_reg STATEMENT:  SELECT 
make_test_raster('regular', 3, 1.001, 0.9999999);
2021-11-20 06:57:04.811 UTC [28624] buildd@postgis_reg ERROR:  new row for 
relation "test_raster_scale_big" violates check constraint "enforce_scalex_rast"
2021-11-20 06:57:04.811 UTC [28624] buildd@postgis_reg DETAIL:  Failing row 
contains (1, 
0100000100E1639D31956AE5C3000000000000F03F0000000000000000000000...).
2021-11-20 06:57:04.811 UTC [28624] buildd@postgis_reg CONTEXT:  SQL statement 
"INSERT INTO test_raster_scale_big VALUES ('1', 
'0100000100E1639D31956AE5C3000000000000F03F00000000000000000000000000000000000000000000000000000000000000000000000002000200440001010101')"
        PL/pgSQL function make_test_raster(text,integer,double precision,double 
precision) line 16 at EXECUTE
2021-11-20 06:57:04.811 UTC [28624] buildd@postgis_reg STATEMENT:  SELECT 
make_test_raster('big', 1, -12345678901234567890.0);
2021-11-20 06:57:04.813 UTC [28624] buildd@postgis_reg WARNING:  Unable to add 
constraint: 'scale_x'.  Skipping
2021-11-20 06:57:04.813 UTC [28624] buildd@postgis_reg CONTEXT:  PL/pgSQL 
function addrasterconstraints(name,name,name,text[]) line 113 at RAISE
2021-11-20 06:57:04.816 UTC [28624] buildd@postgis_reg ERROR:  new row for 
relation "test_raster_scale_small" violates check constraint 
"enforce_scaley_rast"
2021-11-20 06:57:04.816 UTC [28624] buildd@postgis_reg DETAIL:  Failing row 
contains (3, 
0100000100F168E388B5F8E43E72C45A7C0A00F03F0000000000000000000000...).
2021-11-20 06:57:04.816 UTC [28624] buildd@postgis_reg CONTEXT:  SQL statement 
"INSERT INTO test_raster_scale_small VALUES ('3', 
'0100000100F168E388B5F8E43E72C45A7C0A00F03F00000000000000000000000000000000000000000000000000000000000000000000000002000200440001010101')"
        PL/pgSQL function make_test_raster(text,integer,double precision,double 
precision) line 16 at EXECUTE
2021-11-20 06:57:04.816 UTC [28624] buildd@postgis_reg STATEMENT:  SELECT 
make_test_raster('small', 3, 0.00001, 1.00001);
2021-11-20 06:57:04.841 UTC [28624] buildd@postgis_reg WARNING:  Unable to add 
constraint: 'blocksize_x'.  Skipping
2021-11-20 06:57:04.841 UTC [28624] buildd@postgis_reg CONTEXT:  PL/pgSQL 
function addrasterconstraints(name,name,name,text[]) line 113 at RAISE
        PL/pgSQL function 
addrasterconstraints(name,name,name,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean)
 line 53 at RETURN
2021-11-20 06:57:04.841 UTC [28624] buildd@postgis_reg WARNING:  Unable to add 
constraint: 'blocksize_y'.  Skipping
2021-11-20 06:57:04.841 UTC [28624] buildd@postgis_reg CONTEXT:  PL/pgSQL 
function addrasterconstraints(name,name,name,text[]) line 113 at RAISE
        PL/pgSQL function 
addrasterconstraints(name,name,name,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean)
 line 53 at RETURN
2021-11-20 06:57:04.841 UTC [28624] buildd@postgis_reg WARNING:  Unable to add 
constraint: 'pixel_types'.  Skipping
2021-11-20 06:57:04.841 UTC [28624] buildd@postgis_reg CONTEXT:  PL/pgSQL 
function addrasterconstraints(name,name,name,text[]) line 113 at RAISE
        PL/pgSQL function 
addrasterconstraints(name,name,name,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean)
 line 53 at RETURN
2021-11-20 06:57:04.841 UTC [28624] buildd@postgis_reg WARNING:  Unable to add 
constraint: 'nodata_values'.  Skipping
2021-11-20 06:57:04.841 UTC [28624] buildd@postgis_reg CONTEXT:  PL/pgSQL 
function addrasterconstraints(name,name,name,text[]) line 113 at RAISE
        PL/pgSQL function 
addrasterconstraints(name,name,name,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean)
 line 53 at RETURN
2021-11-20 06:57:04.841 UTC [28624] buildd@postgis_reg WARNING:  Unable to add 
constraint: 'out_db'.  Skipping
2021-11-20 06:57:04.841 UTC [28624] buildd@postgis_reg CONTEXT:  PL/pgSQL 
function addrasterconstraints(name,name,name,text[]) line 113 at RAISE
        PL/pgSQL function 
addrasterconstraints(name,name,name,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean)
 line 53 at RETURN
2021-11-20 06:57:04.842 UTC [28624] buildd@postgis_reg WARNING:  Unable to add 
constraint: 'extent'.  Skipping
2021-11-20 06:57:04.842 UTC [28624] buildd@postgis_reg CONTEXT:  PL/pgSQL 
function addrasterconstraints(name,name,name,text[]) line 113 at RAISE
        PL/pgSQL function 
addrasterconstraints(name,name,name,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean)
 line 53 at RETURN
Dropping cluster 14/regress ...


The test log lists important components:

The run in Debian had
PostgreSQL 14.0 (Debian 14.0-1) on powerpc64le-unknown-linux-gnu, compiled by 
gcc (Debian 10.3.0-11) 10.3.0, 64-bit
  Postgis 3.1.4 - (ded6c34) - 2021-10-22 21:28:51
  scripts 3.1.4 ded6c34
  raster scripts 3.1.4 ded6c34
  GEOS: 3.10.0-CAPI-1.16.0
  PROJ: 8.1.1
  SFCGAL: 1.4.0
  GDAL: GDAL 3.3.2, released 2021/09/01

Ubuntu had
PostgreSQL 14.1 (Ubuntu 14.1-1) on powerpc64le-unknown-linux-gnu, compiled by 
gcc (Ubuntu 11.2.0-10ubuntu1) 11.2.0, 64-bit
  Postgis 3.1.4 - (ded6c34) - 2021-10-28 06:20:59
  scripts 3.1.4 ded6c34
  raster scripts 3.1.4 ded6c34
  GEOS: 3.10.1-CAPI-1.16.0
  PROJ: 8.2.0
  SFCGAL: 1.4.0
  GDAL: GDAL 3.3.3, released 2021/10/25

Note: Another Ubuntu build failed before 14.1 with 14.0, only GDAL (or
anything not listed here) is new.

Note:
There is 3.2.0~beta1+dfsg-1~exp1 in debian/experimental but it didn't have an
obvious change/fix in git for this, might still be worth to PPA build 3.2 in
an Ubuntu Jammy PPA.

Repro:
1. build last good one 3.1.1+dfsg-1 in Impish and Jammy on ppc64
2. build bad one 3.1.4+dfsg-3build1 in Impish and Jammy on ppc64

=> Unfortunately None of the above reproduces the issue on ppc64 in LXD
containers :-/ Not even the 4.1.4@Jammy which is continuously failing on
launchpad build retries (4/4 failing)

More logs (for patterns in them):
https://launchpadlibrarian.net/571347323/buildlog_ubuntu-jammy-ppc64el.postgis_3.1.4+dfsg-3build1_BUILDING.txt.gz
https://launchpadlibrarian.net/570874201/buildlog_ubuntu-jammy-ppc64el.postgis_3.1.4+dfsg-3build1_BUILDING.txt.gz
https://launchpadlibrarian.net/569861170/buildlog_ubuntu-jammy-ppc64el.postgis_3.1.4+dfsg-3build1_BUILDING.txt.gz

** Affects: postgis (Ubuntu)
     Importance: Undecided
         Status: New


** Tags: update-excuse

** Tags added: update-excuse

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1952604

Title:
  FTBFS in Jammy - 4348ReversedSmall

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/postgis/+bug/1952604/+subscriptions


-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

Reply via email to