[postgis-tickets] [PostGIS] #5448: Test failures on i386

PostGIS trac at osgeo.org
Fri Jul 28 05:18:44 PDT 2023 

#5448: Test failures on i386
------------------------------------+---------------------------
  Reporter:  Bas Couwenberg         |      Owner:  strk
      Type:  defect                 |     Status:  new
  Priority:  medium                 |  Milestone:  PostGIS 3.4.0
 Component:  build/upgrade/install  |    Version:  master
Resolution:                         |   Keywords:
------------------------------------+---------------------------
Comment (by Bas Couwenberg):

 Just for the record, we're seeing similar test failures for 3.3.4 on i386:
 {{{
  ./topology/test/regress/getnodeedges .. failed (diff expected obtained:
 /tmp/pgis_reg/test_184_diff)
 -----------------------------------------------------------------------------
 --- ./topology/test/regress/getnodeedges_expected       2023-07-28
 08:40:49.000000000 +0000
 +++ /tmp/pgis_reg/test_184_out  2023-07-28 12:10:06.199532720 +0000
 @@ -1,37 +1,37 @@
  N1|1|1
  N1|2|-1
 -N2|1|3
 -N2|2|2
 -N2|3|-2
 +N2|1|2
 +N2|2|-2
 +N2|3|3
  N3|1|-3
  N5|1|4
 -N6|1|-5
 -N6|2|-4
 +N6|1|-4
 +N6|2|-5
  N7|1|5
 -N8|1|22
 -N8|2|12
 -N9|1|20
 -N9|2|13
 -N9|3|-12
 -N10|1|18
 -N10|2|14
 -N10|3|-13
 -N11|1|16
 -N11|2|-14
 -N12|1|15
 -N12|2|-16
 -N12|3|-11
 -N13|1|17
 -N13|2|11
 -N13|3|-18
 -N13|4|10
 -N14|1|19
 -N14|2|-10
 -N14|3|-20
 -N14|4|-9
 -N15|1|21
 -N15|2|9
 -N15|3|-22
 +N8|1|12
 +N8|2|22
 +N9|1|13
 +N9|2|-12
 +N9|3|20
 +N10|1|14
 +N10|2|-13
 +N10|3|18
 +N11|1|-14
 +N11|2|16
 +N12|1|-16
 +N12|2|-11
 +N12|3|15
 +N13|1|11
 +N13|2|-18
 +N13|3|10
 +N13|4|17
 +N14|1|-10
 +N14|2|-20
 +N14|3|-9
 +N14|4|19
 +N15|1|9
 +N15|2|-22
 +N15|3|21
  N16|1|6
  N16|2|-21
  N17|1|7
 @@ -42,8 +42,8 @@
  N18|3|-7
  N19|1|-15
  N19|2|-8
 -N20|1|-26
 -N20|2|26
 +N20|1|26
 +N20|2|-26
  N21|1|25
  N22|1|-25
  Topology 'city_data' dropped
 -----------------------------------------------------------------------------
 [...]
  ./topology/test/regress/legacy_invalid .. failed (diff expected obtained:
 /tmp/pgis_reg/test_189_diff)
 -----------------------------------------------------------------------------
 --- ./topology/test/regress/legacy_invalid_expected     2023-07-28
 08:40:49.000000000 +0000
 +++ /tmp/pgis_reg/test_189_out  2023-07-28 12:10:08.171532602 +0000
 @@ -20,7 +20,7 @@
  invalid next_left_edge|6|29
  invalid next_left_edge|18|-27
  invalid next_left_edge|27|10
 -invalid next_left_edge|29|-33
 +invalid next_left_edge|29|31
  invalid next_left_edge|30|-3
  invalid next_left_edge|31|-28
  invalid next_left_edge|33|33
 @@ -28,7 +28,8 @@
  invalid next_right_edge|27|-22
  invalid next_right_edge|28|-30
  invalid next_right_edge|29|7
 -invalid next_right_edge|33|31
 +invalid next_right_edge|31|-33
 +invalid next_right_edge|33|-31
  #4936|missing_count|1
  #4936|missing|face without edges|10|
  Topology 'invalid_topology' dropped
 -----------------------------------------------------------------------------
 [...]
 Run tests: 324
 Failed: 2
 make[2]: *** [regress/runtest.mk:24: check-regress] Error 2
 make[2]: Leaving directory '/build/postgis-3.3.4+dfsg'
 *** /tmp/pg_virtualenv.ctfHfk/log/postgresql-15-regress.log (last 100
 lines) ***
 2023-07-28 12:10:49.171 UTC [1423800] pbuilder at postgis_reg-3.3 ERROR:
 Band at index '2' not found for raster '2'
 2023-07-28 12:10:49.171 UTC [1423800] pbuilder at postgis_reg-3.3 CONTEXT:
 PL/pgSQL function st_grayscale(rastbandarg[],text) line 41 at RAISE
         PL/pgSQL function
 st_grayscale(raster,integer,integer,integer,text) line 5 at RETURN
 2023-07-28 12:10:49.171 UTC [1423800] pbuilder at postgis_reg-3.3 STATEMENT:
 SELECT
                 ST_Grayscale(rast)
         FROM raster_grayscale_in
         ORDER BY rid
         LIMIT 1;
 2023-07-28 12:10:49.171 UTC [1423800] pbuilder at postgis_reg-3.3 ERROR:
 Band at index '2' not found for raster '2'
 2023-07-28 12:10:49.171 UTC [1423800] pbuilder at postgis_reg-3.3 CONTEXT:
 PL/pgSQL function st_grayscale(rastbandarg[],text) line 41 at RAISE
 2023-07-28 12:10:49.171 UTC [1423800] pbuilder at postgis_reg-3.3 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;
 2023-07-28 12:10:50.603 UTC [1423889] pbuilder at postgis_reg-3.3 ERROR:
 Tolerance cannot be less than zero

 2023-07-28 12:10:50.603 UTC [1423889] pbuilder at postgis_reg-3.3 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;
 2023-07-28 12:10:50.607 UTC [1423889] pbuilder at postgis_reg-3.3 ERROR:
 Tolerance cannot be less than zero

 2023-07-28 12:10:50.607 UTC [1423889] pbuilder at postgis_reg-3.3 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;
 ERROR 4: `/vsimem/in.dat' not recognized as a supported file format.
 2023-07-28 12:10:52.054 UTC [1423965] pbuilder at postgis_reg-3.3 ERROR:
 RASTER_fromGDALRaster: Could not open bytea with GDAL. Check that the
 bytea is of a GDAL supported format
 2023-07-28 12:10:52.054 UTC [1423965] pbuilder at postgis_reg-3.3 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
 2023-07-28 12:10:52.056 UTC [1423965] pbuilder at postgis_reg-3.3 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>
 2023-07-28 12:10:52.056 UTC [1423965] pbuilder at postgis_reg-3.3 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
 2023-07-28 12:10:52.057 UTC [1423965] pbuilder at postgis_reg-3.3 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>
 2023-07-28 12:10:52.057 UTC [1423965] pbuilder at postgis_reg-3.3 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
 2023-07-28 12:10:52.063 UTC [1423965] pbuilder at postgis_reg-3.3 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>
 2023-07-28 12:10:52.063 UTC [1423965] pbuilder at postgis_reg-3.3 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
 2023-07-28 12:10:52.064 UTC [1423965] pbuilder at postgis_reg-3.3 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>
 2023-07-28 12:10:52.064 UTC [1423965] pbuilder at postgis_reg-3.3 STATEMENT:
 SELECT count(convert_from(ST_AsGDALRaster(r, 'EHDR')::bytea, 'LATIN1')) as
 passwd from raster_test where lbl = 'passwd';
 2023-07-28 12:10:52.305 UTC [1423977] pbuilder at postgis_reg-3.3 WARNING:
 Unable to add constraint: 'scale_x'.  Skipping
 2023-07-28 12:10:52.305 UTC [1423977] pbuilder at postgis_reg-3.3 CONTEXT:
 PL/pgSQL function addrasterconstraints(name,name,name,text[]) line 113 at
 RAISE
 2023-07-28 12:10:52.309 UTC [1423977] pbuilder at postgis_reg-3.3 ERROR:  new
 row for relation "test_raster_scale_regular" violates check constraint
 "enforce_scaley_rast"
 2023-07-28 12:10:52.309 UTC [1423977] pbuilder at postgis_reg-3.3 DETAIL:
 Failing row contains (3,
 01000001006ABC74931804F03FCB1A50CAFFFFEF3F0000000000000000000000...).
 2023-07-28 12:10:52.309 UTC [1423977] pbuilder at postgis_reg-3.3 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
 2023-07-28 12:10:52.309 UTC [1423977] pbuilder at postgis_reg-3.3 STATEMENT:
 SELECT make_test_raster('regular', 3, 1.001, 0.9999999);
 2023-07-28 12:10:52.313 UTC [1423977] pbuilder at postgis_reg-3.3 ERROR:  new
 row for relation "test_raster_scale_big" violates check constraint
 "enforce_scalex_rast"
 2023-07-28 12:10:52.313 UTC [1423977] pbuilder at postgis_reg-3.3 DETAIL:
 Failing row contains (1,
 0100000100E1639D31956AE5C3000000000000F03F0000000000000000000000...).
 2023-07-28 12:10:52.313 UTC [1423977] pbuilder at postgis_reg-3.3 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
 2023-07-28 12:10:52.313 UTC [1423977] pbuilder at postgis_reg-3.3 STATEMENT:
 SELECT make_test_raster('big', 1, -12345678901234567890.0);
 2023-07-28 12:10:52.314 UTC [1423977] pbuilder at postgis_reg-3.3 WARNING:
 Unable to add constraint: 'scale_x'.  Skipping
 2023-07-28 12:10:52.314 UTC [1423977] pbuilder at postgis_reg-3.3 CONTEXT:
 PL/pgSQL function addrasterconstraints(name,name,name,text[]) line 113 at
 RAISE
 2023-07-28 12:10:52.317 UTC [1423977] pbuilder at postgis_reg-3.3 ERROR:  new
 row for relation "test_raster_scale_small" violates check constraint
 "enforce_scaley_rast"
 2023-07-28 12:10:52.317 UTC [1423977] pbuilder at postgis_reg-3.3 DETAIL:
 Failing row contains (3,
 0100000100F168E388B5F8E43E72C45A7C0A00F03F0000000000000000000000...).
 2023-07-28 12:10:52.317 UTC [1423977] pbuilder at postgis_reg-3.3 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
 2023-07-28 12:10:52.317 UTC [1423977] pbuilder at postgis_reg-3.3 STATEMENT:
 SELECT make_test_raster('small', 3, 0.00001, 1.00001);
 2023-07-28 12:10:52.338 UTC [1423977] pbuilder at postgis_reg-3.3 WARNING:
 Unable to add constraint: 'blocksize_x'.  Skipping
 2023-07-28 12:10:52.338 UTC [1423977] pbuilder at postgis_reg-3.3 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
 2023-07-28 12:10:52.338 UTC [1423977] pbuilder at postgis_reg-3.3 WARNING:
 Unable to add constraint: 'blocksize_y'.  Skipping
 2023-07-28 12:10:52.338 UTC [1423977] pbuilder at postgis_reg-3.3 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
 2023-07-28 12:10:52.338 UTC [1423977] pbuilder at postgis_reg-3.3 WARNING:
 Unable to add constraint: 'pixel_types'.  Skipping
 2023-07-28 12:10:52.338 UTC [1423977] pbuilder at postgis_reg-3.3 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
 2023-07-28 12:10:52.339 UTC [1423977] pbuilder at postgis_reg-3.3 WARNING:
 Unable to add constraint: 'nodata_values'.  Skipping
 2023-07-28 12:10:52.339 UTC [1423977] pbuilder at postgis_reg-3.3 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
 2023-07-28 12:10:52.339 UTC [1423977] pbuilder at postgis_reg-3.3 WARNING:
 Unable to add constraint: 'out_db'.  Skipping
 2023-07-28 12:10:52.339 UTC [1423977] pbuilder at postgis_reg-3.3 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
 2023-07-28 12:10:52.339 UTC [1423977] pbuilder at postgis_reg-3.3 WARNING:
 Unable to add constraint: 'extent'.  Skipping
 2023-07-28 12:10:52.339 UTC [1423977] pbuilder at postgis_reg-3.3 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
 2023-07-28 12:10:58.278 UTC [1417321] LOG:  checkpoint starting: immediate
 force wait
 2023-07-28 12:10:58.279 UTC [1417321] LOG:  checkpoint complete: wrote 56
 buffers (0.3%); 0 WAL file(s) added, 0 removed, 11 recycled; write=0.001
 s, sync=0.001 s, total=0.002 s; sync files=0, longest=0.000 s,
 average=0.000 s; distance=177151 kB, estimate=177151 kB
 Dropping cluster 15/regress ...
 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5448#comment:8>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.

More information about the postgis-tickets mailing list