[postgis-tickets] [PostGIS] #4144: If during writing tables that contains PostGIS geometry fields AUTOVACUUM is launched, it crashes and force PostgreSQL to restart.

PostGIS trac at osgeo.org
Thu Aug 9 00:54:42 PDT 2018


#4144: If during writing tables that contains PostGIS geometry fields AUTOVACUUM
is launched, it crashes and force PostgreSQL to restart.
----------------------+--------------------------
  Reporter:  zancos   |      Owner:  pramsey
      Type:  defect   |     Status:  new
  Priority:  medium   |  Milestone:  PostGIS GDAL
 Component:  postgis  |    Version:  2.4.x
Resolution:           |   Keywords:
----------------------+--------------------------

Comment (by Algunenano):

 The crashed process is the one `running: autovacuum: ANALYZE
 bug_schema.bug_table` so it could be a bug in Postgres itself, but it's
 impossible to say without, at least, a backtrace.
 Could you please install symbols for both Postgis and Postgresql to get a
 trace of the process crashing.


 Are you using indices, specifically in `"bounding_box"?

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