[postgis-tickets] [PostGIS] #4995: regress/loader/MultiPoint test is racy
PostGIS
trac at osgeo.org
Thu Sep 16 22:53:52 PDT 2021
#4995: regress/loader/MultiPoint test is racy
----------------------------+---------------------------
Reporter: Bas Couwenberg | Owner: robe
Type: defect | Status: new
Priority: medium | Milestone: PostGIS 3.1.5
Component: loader/dumper | Version: 3.1.x
Keywords: |
----------------------------+---------------------------
Some loader tests are racy, they sometimes fail with:
{{{
ERROR: relation "loadedshp" already exists
}}}
armhf example (package build on buildd):
{{{
./regress/loader/MultiPoint ............ failed (wkb testdiff expected
obtained: /tmp/pgis_reg/test_116_diff)
-----------------------------------------------------------------------------
--- ./regress/loader/MultiPoint.select.expected 2021-09-04
05:03:43.000000000 +0000
+++ /tmp/pgis_reg/test_116_out 2021-09-17 03:06:56.245881317 +0000
@@ -1 +0,0 @@
-MULTIPOINT(0 1,9 -1,9 -1)
-----------------------------------------------------------------------------
./regress/loader/MultiPointM ... failed ( wkt test: running shp2pgsql
output: /tmp/pgis_reg/loader.err)
-----------------------------------------------------------------------------
SET
SET
BEGIN
psql:/tmp/pgis_reg/loader.out:4: ERROR: relation "loadedshp" already
exists
-----------------------------------------------------------------------------
./regress/loader/MultiPointZ ... failed ( wkt test: running shp2pgsql
output: /tmp/pgis_reg/loader.err)
-----------------------------------------------------------------------------
SET
SET
BEGIN
psql:/tmp/pgis_reg/loader.out:4: ERROR: relation "loadedshp" already
exists
-----------------------------------------------------------------------------
./regress/loader/Arc ... failed ( wkt test: running shp2pgsql output:
/tmp/pgis_reg/loader.err)
-----------------------------------------------------------------------------
SET
SET
BEGIN
psql:/tmp/pgis_reg/loader.out:5: ERROR: relation "loadedshp" already
exists
-----------------------------------------------------------------------------
./regress/loader/ArcM ... failed ( wkt test: running shp2pgsql output:
/tmp/pgis_reg/loader.err)
-----------------------------------------------------------------------------
SET
SET
BEGIN
psql:/tmp/pgis_reg/loader.out:4: ERROR: relation "loadedshp" already
exists
-----------------------------------------------------------------------------
./regress/loader/ArcZ ... failed ( wkt test: running shp2pgsql output:
/tmp/pgis_reg/loader.err)
-----------------------------------------------------------------------------
SET
SET
BEGIN
psql:/tmp/pgis_reg/loader.out:4: ERROR: relation "loadedshp" already
exists
-----------------------------------------------------------------------------
./regress/loader/Polygon ... failed ( wkt test: running shp2pgsql output:
/tmp/pgis_reg/loader.err)
-----------------------------------------------------------------------------
SET
SET
BEGIN
psql:/tmp/pgis_reg/loader.out:4: ERROR: relation "loadedshp" already
exists
-----------------------------------------------------------------------------
./regress/loader/PolygonM ... failed ( wkt test: running shp2pgsql
output: /tmp/pgis_reg/loader.err)
-----------------------------------------------------------------------------
SET
SET
BEGIN
psql:/tmp/pgis_reg/loader.out:4: ERROR: relation "loadedshp" already
exists
-----------------------------------------------------------------------------
./regress/loader/PolygonZ ... failed ( wkt test: running shp2pgsql
output: /tmp/pgis_reg/loader.err)
-----------------------------------------------------------------------------
SET
SET
BEGIN
psql:/tmp/pgis_reg/loader.out:4: ERROR: relation "loadedshp" already
exists
-----------------------------------------------------------------------------
./regress/loader/TSTPolygon ... failed ( wkt test: running shp2pgsql
output: /tmp/pgis_reg/loader.err)
-----------------------------------------------------------------------------
SET
SET
BEGIN
psql:/tmp/pgis_reg/loader.out:4: ERROR: relation "loadedshp" already
exists
-----------------------------------------------------------------------------
./regress/loader/TSIPolygon ... failed ( wkt test: running shp2pgsql
output: /tmp/pgis_reg/loader.err)
-----------------------------------------------------------------------------
SET
SET
BEGIN
psql:/tmp/pgis_reg/loader.out:4: ERROR: relation "loadedshp" already
exists
-----------------------------------------------------------------------------
./regress/loader/TSTIPolygon ... failed ( wkt test: running shp2pgsql
output: /tmp/pgis_reg/loader.err)
-----------------------------------------------------------------------------
SET
SET
BEGIN
psql:/tmp/pgis_reg/loader.out:4: ERROR: relation "loadedshp" already
exists
-----------------------------------------------------------------------------
}}}
[https://buildd.debian.org/status/fetch.php?pkg=postgis&arch=armel&ver=3.1.4%2Bdfsg-1%2Bb2&stamp=1631848521&raw=0
Full buildlog]
i386 example (!GitLab CI Pipeline):
{{{
./regress/loader/PolygonM ............ failed (wkb testdiff expected
obtained: /tmp/pgis_reg/test_123_diff)
-----------------------------------------------------------------------------
--- ./regress/loader/PolygonM.select.expected 2021-09-08
15:38:20.000000000 +0000
+++ /tmp/pgis_reg/test_123_out 2021-09-08 15:50:21.797366851 +0000
@@ -1 +0,0 @@
-MULTIPOLYGONM(((0 0 1,0 10 7,10 10 5,10 0 3,0 0 1),(5 5 9,8 5 15,8 8 13,5
8 11,5 5 9)),((-1 -1 -1,-1 -10 -7,-10 -10 -5,-10 -1 -3,-1 -1 -1),(-5 -5
-9,-8 -5 -15,-8 -8 -13,-5 -8 -11,-5 -5 -9)))
-----------------------------------------------------------------------------
./regress/loader/PolygonZ ... failed ( wkt test: running shp2pgsql
output: /tmp/pgis_reg/loader.err)
-----------------------------------------------------------------------------
SET
SET
BEGIN
psql:/tmp/pgis_reg/loader.out:4: ERROR: relation "loadedshp" already
exists
-----------------------------------------------------------------------------
./regress/loader/TSTPolygon ... failed ( wkt test: running shp2pgsql
output: /tmp/pgis_reg/loader.err)
-----------------------------------------------------------------------------
SET
SET
BEGIN
psql:/tmp/pgis_reg/loader.out:4: ERROR: relation "loadedshp" already
exists
-----------------------------------------------------------------------------
./regress/loader/TSIPolygon ... failed ( wkt test: running shp2pgsql
output: /tmp/pgis_reg/loader.err)
-----------------------------------------------------------------------------
SET
SET
BEGIN
psql:/tmp/pgis_reg/loader.out:4: ERROR: relation "loadedshp" already
exists
-----------------------------------------------------------------------------
./regress/loader/TSTIPolygon ... failed ( wkt test: running shp2pgsql
output: /tmp/pgis_reg/loader.err)
-----------------------------------------------------------------------------
SET
SET
BEGIN
psql:/tmp/pgis_reg/loader.out:4: ERROR: relation "loadedshp" already
exists
-----------------------------------------------------------------------------
}}}
[https://salsa.debian.org/debian-gis-team/postgis/-/jobs/1925038/raw Full
buildlog]
Retrying the build generally fixes the issue point to a race condition
with the parallel builds.
--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4995>
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