update postgis an problem pg_dump vacuumdb

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

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

 

 


_______________________________________________
postgis-users mailing list
[hidden email]
https://lists.osgeo.org/mailman/listinfo/postgis-users