[postgis-users] update postgis an problem pg_dump vacuumdb

[Alain Benard]

Hi,
We are working with Centos 8 / Postgres 12.5 and postgis 2.5 and last week (30 March) an update modified the following packages:
update:
   gdal32-libs-3.2.2-13.rhel8.x86_64
   geos39-3.9.1-1.rhel8.x86_64
   libgeotiff16-1.6.0-2.rhel8.x86_64
   libgeotiff16-devel-1.6.0-2.rhel8.x86_64
   libspatialite50-5.0.1-2.rhel8.x86_64
   libspatialite50-devel-5.0.1-2.rhel8.x86_64
   postgis25_12-2.5.5-4.rhel8.x86_64
   postgis25_12-client-2.5.5-4.rhel8.x86_64
   postgis25_12-docs-2.5.5-4.rhel8.x86_64
   postgis25_12-utils-2.5.5-4.rhel8.x86_64
installed:
   proj80-8.0.0-1.rhel8.x86_64
Completed !

Since this date our backup script has crashed randomly on the vacuumdb or pg_dum commands with messages such as the following:
LOG: server process (PID 1750919) was terminated by signal 6: Aborted
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.
HINT: In a moment you should be able to reconnect to the database and repeat your command.
the pg_dump command which crashes is not on a particular base and by replaying the dumps one by one all the bases can be saved (sometimes after one or more crashes).

If I try to cancel the March 30 update I get:
                dnf history undo xx
    Installer proj80-8.0.0-1.rhel8.x86_64                @pgdg-common
    Upgrade   gdal32-libs-3.2.2-13.rhel8.x86_64          @pgdg-common
    Upgraded  gdal32-libs-3.2.1-1.rhel8.x86_64           @@System
    Upgrade   geos39-3.9.1-1.rhel8.x86_64                @pgdg-common
    Upgraded  geos39-3.9.0-1.rhel8.x86_64                @@System
    Upgrade   libgeotiff16-1.6.0-2.rhel8.x86_64          @pgdg-common
    Upgraded  libgeotiff16-1.6.0-1.rhel8.x86_64          @@System
    Upgrade   libgeotiff16-devel-1.6.0-2.rhel8.x86_64    @pgdg-common
    Upgraded  libgeotiff16-devel-1.6.0-1.rhel8.x86_64    @@System
    Upgrade   libspatialite50-5.0.1-2.rhel8.x86_64       @pgdg-common
    Upgraded  libspatialite50-5.0.1-1.rhel8.x86_64       @@System
    Upgrade   libspatialite50-devel-5.0.1-2.rhel8.x86_64 @pgdg-common
    Upgraded  libspatialite50-devel-5.0.1-1.rhel8.x86_64 @@System
    Upgrade   postgis25_12-2.5.5-4.rhel8.x86_64          @pgdg12
    Upgraded  postgis25_12-2.5.5-2.rhel8.x86_64          @@System
    Upgrade   postgis25_12-client-2.5.5-4.rhel8.x86_64   @pgdg12
    Upgraded  postgis25_12-client-2.5.5-2.rhel8.x86_64   @@System
    Upgrade   postgis25_12-docs-2.5.5-4.rhel8.x86_64     @pgdg12
    Upgraded  postgis25_12-docs-2.5.5-2.rhel8.x86_64     @@System
    Upgrade   postgis25_12-utils-2.5.5-4.rhel8.x86_64    @pgdg12
    Upgraded  postgis25_12-utils-2.5.5-2.rhel8.x86_64    @@System
No gdal32-libs-3.2.1-1.rhel8.x86_64 packages are available.
Error: no matching package
Thank's for advance for your help.
Alain



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20210406/a79e4d76/attachment.html>