Board index FlightGear Development Scenery

Scenemodels Database currently broken

Questions and discussion about enhancing and populating the FlightGear world.

Scenemodels Database currently broken

Postby Torsten » Wed Jul 19, 2017 7:02 pm

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
Code: Select all
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
flightgear.org - where development happens.
User avatar
Torsten
 
Posts: 648
Joined: Fri Feb 01, 2008 10:22 pm
Location: near Hamburg, Germany
Callsign: offline
Version: next
OS: Linux

Re: Scenemodels Database currently broken

Postby Torsten » Thu Jul 20, 2017 1:35 pm

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;"

Torsten
flightgear.org - where development happens.
User avatar
Torsten
 
Posts: 648
Joined: Fri Feb 01, 2008 10:22 pm
Location: near Hamburg, Germany
Callsign: offline
Version: next
OS: Linux


Return to Scenery

Who is online

Users browsing this forum: No registered users and 5 guests

cron