search

Starefossen / docker-pgrouting

:whale: Docker Image for pgRouting with PostGIS and official Postgres Docker Image
https://registry.hub.docker.com/u/starefossen/pgrouting/
MIT License
33 stars 19 forks source link

ERROR: could not access file "$libdir/librouting": No such file or directory #6

Open edwardsamuel opened 8 years ago

edwardsamuel commented 8 years ago

I run this Docker image using the following command:

docker run -d --name ${POSTGRES_CONTAINER_NAME} -p 5432:5432 -e POSTGRES_USER="${POSTGRES_USER}" -e POSTGRES_PASSWORD="${POSTGRES_PASSWORD}" -v ${POSTGRES_HOST_DATA_PATH}:/var/lib/postgresql/data starefossen/pgrouting:9.4-2.1-2.1

When we run PGRouting queries, like:

SELECT seq, id1 vertex_id, id2 line_id, cost
FROM pgr_dijkstra(
  'SELECT id, source::int, target::int, cost FROM osm_2po_4pgr WHERE geom_way && ST_Expand(ST_SetSRID(ST_MakeEnvelope(-87.6902068, 41.8844823, -87.6363398, 41.939693), 4326), 0.02)',
  6276441, 6334195, false, false
)

It gave me this error:

ERROR:  could not access file "$libdir/librouting": No such file or directory

********** Error **********

ERROR: could not access file "$libdir/librouting": No such file or directory
SQL state: 58P01

Last time, I run from latest (it should be 9.4-2.1-2.0 at that time) and it run properly. But, when I re-download the latest or 9.4-2.1-2.1, it is broken.

Starefossen commented 8 years ago

Thanks for the report @edwardsamuel, I will be checking up on this as soon as I have the time.

edwardsamuel commented 8 years ago

I think the issue was come out because I upgraded my existing data to the current images. The mdillon/postgis was upgraded to 2.2. After I did ALTER EXTENSION postgis UPDATE;, the problem was gone.

I created an issue in https://github.com/appropriate/docker-postgis/issues/26 to asked mdillon/postgis to keep minor version tags.