[Flightgear-devel] Scenemodels Database currently broken

[Torsten Dreyer]

Hi,

there is a bug triggering an error when using the scenemodels database.
The export job breaks and there are currently no updates sent to TerraSync.
Other services on https://scenery.flightgear.org/ are most likely also
affected.
It looks like a broken dependency after the last software update, luckily
there is no data loss.

The error message seen is
"psycopg2.OperationalError: could not load library
"/usr/lib/postgresql93/lib64/postgis-2.3.so": /usr/lib/postgresql93/lib64/
postgis-2.3.so: undefined symbol: GEOSMinimumClearance"

I'll post a message when it's back in service.

[Torsten Dreyer]

The database is back in service, everything should be working again.
Please report if not.

The reason for the outage was:
postgis got updated from 2.1 to 2.3 which requires libgeos-3.6 (installed
was 3.5).
Because of that, the extension update in postgres failed.

Solution was (for the records, in case anybody else suffers from the same
problem):
- stop postgres server
- update libgeos to 3.6.1 (also libgeos_c1)
- start postgres server
- for every database using postgis, do "psql -d mygisdb" and execute "alter
extension postgis update;"

Post by Torsten Dreyer
Hi,
there is a bug triggering an error when using the scenemodels database.
The export job breaks and there are currently no updates sent to TerraSync.
Other services on https://scenery.flightgear.org/ are most likely also
affected.
It looks like a broken dependency after the last software update, luckily
there is no data loss.
The error message seen is
"psycopg2.OperationalError: could not load library
"/usr/lib/postgresql93/lib64/postgis-2.3.so": /usr/lib/postgresql93/lib64/
postgis-2.3.so: undefined symbol: GEOSMinimumClearance"
I'll post a message when it's back in service.
--
Torsten Dreyer