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
|
Locked
