[postgis-tickets] [PostGIS] #3609: debbie crashing on PostgreSQL 9.6 builds

[PostGIS]

#3609: debbie crashing on PostgreSQL 9.6 builds
------------------------------------+----------------------------
  Reporter:  robe                   |      Owner:  robe
      Type:  defect                 |     Status:  new
  Priority:  blocker                |  Milestone:  PostGIS 2.3.0
 Component:  build/upgrade/install  |    Version:  trunk
Resolution:                         |   Keywords:  postgresql 9.6
------------------------------------+----------------------------

Comment (by robe):

 I built latest postgresql git branch under mingw and was also able to
 achieve a crash.

 Log shows this:


 {{{
 DETAIL:  Failed process was running: CREATE OR REPLACE VIEW
 geography_columns AS
                 SELECT
                         current_database() AS f_table_catalog,
                         n.nspname AS f_table_schema,
                         c.relname AS f_table_name,
                         a.attname AS f_geography_column,
                         postgis_typmod_dims(a.atttypmod) AS
 coord_dimension,
                         postgis_typmod_srid(a.atttypmod) AS srid,
                         postgis_typmod_type(a.atttypmod) AS type
                 FROM
                         pg_class c,
                         pg_attribute a,
                         pg_type t,
                         pg_namespace n
                 WHERE t.typname = 'geography'
                 AND a.attisdropped = false
                 AND a.atttypid = t.oid
                 AND a.attrelid = c.oid
                 AND c.relnamespace = n.oid
                 AND NOT pg_is_other_temp_schema(c.relnamespace)
                 AND has_table_privilege( c.oid, 'SELECT'::text );
 HINT:  See C include file "ntstatus.h" for a description of the
 hexadecimal value.
 LOG:  terminating any other active server processes
 WARNING:  terminating connection because of crash of another server
 process
 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.
 }}}

 What's interesting is that the crash doesn't happen if installing via
 extension.  Only old fashioned make check triggers this


 {{{

 -- so this works
 make check RUNTESTFLAGS=--extension

 -- so this crashes
 make check


 I think the culprit might be:


 {{{
 Prevent "snapshot too old" from trying to return pruned TOAST tuples.
 (Commit 3e2f3c2e423b3ae906668c186bac79522b8e3e29 by rhaas)
 }}}

 Because the earlier likely cause Tom Lane's commit (run that included that
 was successful).  Might have been a fluke which is why I haven't ruled
 that out.

--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3609#comment:4>
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.