[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 01:18:46 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 zancos):
Whole database dump attached. There is no indexes at all.
In our final database we have indexes, but none of them are over geo
fields. Only uuid and some text fields are indexed.
As I said, I'm not a database expert so I'm using postgresql/postgis
binaries with no debug symbols; thus, I haven't backtrace at the moment.
If you could not reproduce the problem, I could try to compile
postgresql/postgis in debug mode, but probably will take me some time.
Please, let me know...
--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4144#comment:2>
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