search

OpenRailwayMap / server-admin

Issue tracker for admin stuff related to openrailwaymap.org instance.
4 stars 2 forks source link

API is down, database upgrade is stuck #14

Closed DerDakon closed 5 years ago

rurseekatze commented 5 years ago

The API works again.

The error was An error occurred during facility request: "error: could not load library "/usr/pgsql-9.6/lib/postgis-2.4.so": /usr/pgsql-9.6/lib/postgis-2.4.so: undefined symbol: GEOSFrechetDistanceDensify" Aborting.

I solved the problem with yum remove geos36 (https://gis.stackexchange.com/questions/304621/qgis-3-online-postgresql-database-error-undefined-symbol-geosfrechetdistance).

rurseekatze commented 5 years ago

The update itself seems to work. For example, I changed the operator of this station a couple of days ago and the object was updated in the database:

I think the problem is the tile caching/expiry mechanism.

DerDakon commented 5 years ago

The database update timestamp is 4 days old.

rurseekatze commented 5 years ago

The update process works again. It failed because of the same PostGIS problem as the API. After I fixed the PostGIS problem, the next run of the cronjob was successful and applied all pending diffs.