[pgrouting-users] Could not load library librouting.dll error

[Paragon Corporation]

Ross,

I recompiled pgRouting 2.0.0 against PostgreSQL 9.2.11 and installs fine now
on my 9.2 Windows 64-bit test instance.  Please give that a try.  Also built
PostGIS 2.1.8 which I am planning to package up this weekend along with the
newer pgrouting 2.0.0 binaries to remedy this issue for others.

I am however unable to replicate the issue you are having on my 2.1.0beta
install with the query you provided so seems data specific.

If you can provide a link to the data (if private just send me link via my
email lr at pcorp.us ) and we'll take a look.

Thanks,
Regina

-----Original Message-----
From: Paragon Corporation [mailto:lr at pcorp.us] 
Sent: Monday, August 10, 2015 7:11 PM
To: 'pgRouting users mailing list' <pgrouting-users at lists.osgeo.org>
Subject: RE: [pgrouting-users] Could not load library librouting.dll error

Ross,
Sorry I missed your last message.


Ross,

Sorry I missed your last message.  I'll let you know as soon as I have the
pgrouting 2.0.0 compiled and will check out the 2.1 error you are getting.

If you can provide some sample data, that would be great.

Thanks, 
Regina

-----
Hi Regina,

Libstdc++-6.dll is in the \bin folder and PostGIS is working correctly.

The PostGIS version I installed was 2.1.7 w 64 gcc 48

The pgRouting files I installed are 2.0.0w64
(http://winnie.postgis.net/download/windows/pg92/buildbot/pgrouting-pg92-bin
aries-2.0.0w64.zip).  If I install the gcc48 version
(http://winnie.postgis.net/download/windows/pg92/buildbot/pgrouting-pg92-bin
aries-2.0w64gcc48.zip) of pgrouting it crashes the database.  Trying with
the 2.1.0 betaw64gcc48
(http://winnie.postgis.net/download/windows/pg92/buildbot/pgrouting-pg92-bin
aries-2.1.0-betaw64gcc48.zip) version crashes the database instantly.

The log says:

2015-08-10 17:34:37 BST LOG:  server process (PID 4028) was terminated by
exception 0xC0000005
2015-08-10 17:34:37 BST DETAIL:  Failed process was running:
                    SELECT seq, id1 AS node, id2 AS edge, cost FROM
pgr_dijkstra('
                        SELECT gid AS id,
                            source::int4 AS source,
                            target::int4 AS target,
                            cost_time::float8 AS cost
                            FROM itn_network',
                        3085, 10925, false, false)
2015-08-10 17:34:37 BST HINT:  See C include file "ntstatus.h" for a
description of the hexadecimal value.
2015-08-10 17:34:37 BST LOG:  terminating any other active server processes
2015-08-10 17:34:37 BST WARNING:  terminating connection because of crash of
another server process
2015-08-10 17:34:37 BST 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.
2015-08-10 17:34:37 BST HINT:  In a moment you should be able to reconnect
to the database and repeat your command.
2015-08-10 17:34:37 BST WARNING:  terminating connection because of crash of
another server process
2015-08-10 17:34:37 BST 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.
2015-08-10 17:34:37 BST HINT:  In a moment you should be able to reconnect
to the database and repeat your command.
2015-08-10 17:34:37 BST WARNING:  terminating connection because of crash of
another server process
2015-08-10 17:34:37 BST 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.
2015-08-10 17:34:37 BST HINT:  In a moment you should be able to reconnect
to the database and repeat your command.
2015-08-10 17:34:37 BST WARNING:  terminating connection because of crash of
another server process
2015-08-10 17:34:37 BST 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.
2015-08-10 17:34:37 BST HINT:  In a moment you should be able to reconnect
to the database and repeat your command.
2015-08-10 17:34:37 BST LOG:  all server processes terminated;
reinitializing
2015-08-10 17:34:47 BST FATAL:  pre-existing shared memory block is still in
use
2015-08-10 17:34:47 BST HINT:  Check if there are any old server processes
still running, and terminate them.

It crashes when I run the PgRouting Layer plugin in QGIS to solve a route
between two points.  The error I get from QGIS is [null argument to internal
routine].

Running the same query in the PgAdmin SQL pane crashes the database
instantly.

I have to go but I'll look at it again tomorrow morning.

Thanks for the help

Ross
-----Original Message-----
From: pgrouting-users-bounces at lists.osgeo.org
[mailto:pgrouting-users-bounces at lists.osgeo.org] On Behalf Of Paragon
Corporation
Sent: Monday, August 10, 2015 7:06 PM
To: 'pgRouting users mailing list' <pgrouting-users at lists.osgeo.org>
Subject: Re: [pgrouting-users] Could not load library librouting.dll error

Ross,

I confirmed the pgrouting 2.0.0 binaries don't work with latest postgresql
9.2 64-bit but the pgrouting 2.1 beta works.

If you can give that a try that would be great, since we are very close to
releasing pgRouting 2.1 anyway and would like some testers.

However I am working on recompiling 2.0.0 for newer postgresql 9.2.  Should
have sometime tomorrow.

Note that with pgRouting 2.0 the .dll is now versioned, so you would need to
do an ALTER EXTENSION .. to upgrade a 2.0.

Since it is versioned, the 2.1 and 2.0 can coexist on the same server as
long as they are in different databases.


Thanks,
Regina



-----Original Message-----