[postgis-devel] 3.1.0alpha2 test report

Greg Troxel gdt at lexort.com
Tue Jul 28 15:08:27 PDT 2020 

Compared to 3.0.1, other than the usual bunch of upgrade scripts from/to
new versions, the set of installed files changed little, with two
withdrawals:

  -share/postgresql/contrib/postgis-${MAJOR}/postgis_proc_set_search_path.sql
  -share/postgresql/contrib/postgis-${MAJOR}/rtpostgis_proc_set_search_path.sql

but I'm guessing that's an internal implementation detail rather than
part of the API, so that's ok.

It built fine.  Tests crashed on me, testing the not-yet-installed
package, and then I installed it and they still crashed the same way.

I must have run tests on 3.0.1 when I updated, or I would not have
committed it.  But rebuilding 3.0.1 and running tests now, it crashes.
I will look into this; it looks like a proj problem.




PostgreSQL 10.13 on x86_64--netbsd, compiled by gcc (nb2 20180327) 5.5.0, 64-bit
  Postgis 3.1.0alpha2 - (b6f415d) - 2020-07-28 21:33:14
  scripts 3.1.0alpha2 b6f415d
  GEOS: 3.8.1-CAPI-1.13.3
  PROJ: 6.3.2

and things were ok for a while and then:

 ../loader/ReprojectPtsD ..... ok in 187 ms
 ../loader/ReprojectPtsGeog .... failed ( wkt test: running shp2pgsql output: /tmp/pgis_reg/loader.err)
 failed (Unable to run sql script ../loader/ReprojectPtsGeog-post.sql: /tmp/pgis_reg/test_22_tmp)
 ... but cleanup sql failed!psql: FATAL:  the database system is in recovery mode
 failed (PostGIS object count pre-test () != post-test (8500))
 ../loader/ReprojectPtsGeogD .... failed ( wkt test: running shp2pgsql output: /tmp/pgis_reg/loader.err)
 failed (Unable to run sql script ../loader/ReprojectPtsGeogD-post.sql: /tmp/pgis_reg/test_23_tmp)
 ... but cleanup sql failed!psql: FATAL:  the database system is in recovery mode
 failed (PostGIS object count pre-test () != post-test (8500))
 ../loader/Latin1 .psql: FATAL:  the database system is in recovery mode
Could not run: psql -tXAq -d postgis_reg -c "DROP TABLE IF EXISTS loadedshp" >> /tmp/pgis_reg/regress_log 2>&1
gmake[3]: *** [Makefile:237: check] Error 2
gmake[3]: Leaving directory '/tmp/work/databases/postgresql-postgis2/work/postgis-3.1.0alpha2/regress/core'
gmake[2]: *** [Makefile:47: check-regress] Error 2
gmake[2]: Leaving directory '/tmp/work/databases/postgresql-postgis2/work/postgis-3.1.0alpha2/regress'
gmake[1]: *** [GNUmakefile:20: check-regress] Error 1
gmake[1]: Leaving directory '/tmp/work/databases/postgresql-postgis2/work/postgis-3.1.0alpha2'
gmake: *** [Makefile:6: check] Error 2
*** Error code 2

pgsql log is

2020-07-28 17:57:32.124 EDT [4078] LOG:  server process (PID 15569) was terminated by signal 6: Abort trap
2020-07-28 17:57:32.124 EDT [4078] DETAIL:  Failed process was running: CREATE TABLE "loadedshp" (gid serial,
        "the_geom" geography(POINT,4269));
2020-07-28 17:57:32.124 EDT [4078] LOG:  terminating any other active server processes
2020-07-28 17:57:32.124 EDT [731] WARNING:  terminating connection because of crash of another server process
2020-07-28 17:57:32.124 EDT [731] DETAIL:  The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2020-07-28 17:57:32.124 EDT [731] HINT:  In a moment you should be able to reconnect to the database and repeat your command.
2020-07-28 17:57:32.126 EDT [4078] LOG:  all server processes terminated; reinitializing
2020-07-28 17:57:32.202 EDT [16948] FATAL:  the database system is in recovery mode
2020-07-28 17:57:32.203 EDT [8216] LOG:  database system was interrupted; last known up at 2020-07-28 17:57:20 EDT
2020-07-28 17:57:32.210 EDT [16486] FATAL:  the database system is in recovery mode
2020-07-28 17:57:32.218 EDT [12092] FATAL:  the database system is in recovery mode
2020-07-28 17:57:32.225 EDT [29190] FATAL:  the database system is in recovery mode
2020-07-28 17:57:32.242 EDT [8216] LOG:  database system was not properly shut down; automatic recovery in progress
2020-07-28 17:57:32.243 EDT [8216] LOG:  redo starts at 0/1D75B6B0
2020-07-28 17:57:32.244 EDT [28974] FATAL:  the database system is in recovery mode
2020-07-28 17:57:32.251 EDT [8507] FATAL:  the database system is in recovery mode
2020-07-28 17:57:32.259 EDT [14794] FATAL:  the database system is in recovery mode
2020-07-28 17:57:32.267 EDT [4975] FATAL:  the database system is in recovery mode
2020-07-28 17:57:32.274 EDT [10013] FATAL:  the database system is in recovery mode
2020-07-28 17:57:32.462 EDT [8216] LOG:  invalid record length at 0/1E2861C0: wanted 24, got 0
2020-07-28 17:57:32.462 EDT [8216] LOG:  redo done at 0/1E285AA0
2020-07-28 17:57:32.462 EDT [8216] LOG:  last completed transaction was at log time 2020-07-28 17:57:31.936145-04
2020-07-28 17:57:32.524 EDT [4078] LOG:  database system is ready to accept connections

gdb says:

Reading symbols from /usr/pkg/bin/postgres...(no debugging symbols found)...done.
[New process 1]
Core was generated by `postgres'.
Program terminated with signal SIGABRT, Aborted.
#0  0x000078c18acfe7fa in _lwp_kill () from /usr/lib/libc.so.12
(gdb) bt
#0  0x000078c18acfe7fa in _lwp_kill () from /usr/lib/libc.so.12
#1  0x000078c18acfe0a2 in abort () from /usr/lib/libc.so.12
#2  0x000078c17d65ce8f in ?? () from /usr/lib/libc++.so.1
#3  0x000078c17cd40584 in osgeo::proj::io::AuthorityFactory::createProjectedCRS(std::string const&) const () from /usr/pkg/lib/libproj.so.15
#4  0x000078c17cd4d994 in osgeo::proj::io::AuthorityFactory::createFromCoordinateReferenceSystemCodes(std::string const&, std::string const&, std::string const&, std::string const&, bool, bool, bool, bool, bool, std::shared_ptr<osgeo::proj::metadata::Extent> const&, std::shared_ptr<osgeo::proj::metadata::Extent> const&) const ()
   from /usr/pkg/lib/libproj.so.15
#5  0x000078c17cccb374 in osgeo::proj::operation::CoordinateOperationFactory::Private::findOpsInRegistryDirect(dropbox::oxygen::nn<std::shared_ptr<osgeo::proj::crs::CRS> > const&, dropbox::oxygen::nn<std::shared_ptr<osgeo::proj::crs::CRS> > const&, osgeo::proj::operation::CoordinateOperationFactory::Private::Context&, bool&) ()
   from /usr/pkg/lib/libproj.so.15
#6  0x000078c17cce300e in osgeo::proj::operation::CoordinateOperationFactory::Private::createOperationsFromDatabase(dropbox::oxygen::nn<std::shared_ptr<osgeo::proj::crs::CRS> > const&, dropbox::oxygen::nn<std::shared_ptr<osgeo::proj::crs::CRS> > const&, osgeo::proj::operation::CoordinateOperationFactory::Private::Context&, osgeo::proj::crs::GeodeticCRS const*, osgeo::proj::crs::GeodeticCRS const*, osgeo::proj::crs::GeographicCRS const*, osgeo::proj::crs::GeographicCRS const*, osgeo::proj::crs::VerticalCRS const*, osgeo::proj::crs::VerticalCRS const*, std::vector<dropbox::oxygen::nn<std::shared_ptr<osgeo::proj::operation::CoordinateOperation> >, std::allocator<dropbox::oxygen::nn<std::shared_ptr<osgeo::proj::operation::CoordinateOperation> > > >&) () from /usr/pkg/lib/libproj.so.15
#7  0x000078c17cce11f8 in osgeo::proj::operation::CoordinateOperationFactory::Private::createOperations(dropbox::oxygen::nn<std::shared_ptr<osgeo::proj::crs::CRS> > const&, dropbox::oxygen::nn<std::shared_ptr<osgeo::proj::crs::CRS> > const&, osgeo::proj::operation::CoordinateOperationFactory::Private::Context&) () from /usr/pkg/lib/libproj.so.15
#8  0x000078c17ccea364 in osgeo::proj::operation::CoordinateOperationFactory::createOperations(dropbox::oxygen::nn<std::shared_ptr<osgeo::proj::crs::CRS> > const&, dropbox::oxygen::nn<std::shared_ptr<osgeo::proj::crs::CRS> > const&, dropbox::oxygen::nn<std::unique_ptr<osgeo::proj::operation::CoordinateOperationContext, std::default_delete<osgeo::proj::operation::CoordinateOperationContext> > > const&) const () from /usr/pkg/lib/libproj.so.15
#9  0x000078c17cd60069 in proj_create_operations () from /usr/pkg/lib/libproj.so.15
#10 0x000078c17cdbb3a8 in proj_create_crs_to_crs_from_pj () from /usr/pkg/lib/libproj.so.15
#11 0x000078c17cdbb9dd in proj_create_crs_to_crs () from /usr/pkg/lib/libproj.so.15
#12 0x000078c17da56e83 in GetPJUsingFCInfo () from /tmp/work/databases/postgresql-postgis2/work/postgis-3.1.0alpha2/regress/00-regress-install/lib/postgis-3.so
#13 0x000078c17da57181 in srid_check_latlong () from /tmp/work/databases/postgresql-postgis2/work/postgis-3.1.0alpha2/regress/00-regress-install/lib/postgis-3.so
#14 0x000078c17da37ec7 in geography_typmod_in () from /tmp/work/databases/postgresql-postgis2/work/postgis-3.1.0alpha2/regress/00-regress-install/lib/postgis-3.so
#15 0x00000000007dcaab in OidFunctionCall1Coll ()
#16 0x000000000055d3f6 in LookupTypeNameExtended ()
#17 0x000000000055d787 in typenameType ()
#18 0x000000000055e88c in transformColumnDefinition ()
#19 0x0000000000560797 in transformCreateStmt ()
#20 0x00000000006ee558 in ProcessUtilitySlow.isra.4 ()
#21 0x00000000006ed27d in standard_ProcessUtility ()
#22 0x00000000006eaf6f in PortalRunUtility ()
#23 0x00000000006eb8e5 in PortalRunMulti ()
#24 0x00000000006ec38e in PortalRun ()
#25 0x00000000006e855f in exec_simple_query ()
#26 0x00000000006e9948 in PostgresMain ()
#27 0x000000000068717e in PostmasterMain ()
#28 0x00000000008194af in main ()
(gdb) 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 194 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20200728/64bdac6d/attachment-0001.sig>

More information about the postgis-devel mailing list