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

Tue Aug 11 08:57:26 PDT 2015

Regina

Your new package works perfectly.  Thank you.

So that's this PgRouting (http://winnie.postgis.net/download/windows/pg92/buildbot/pgrouting-pg92-binaries-2.0.0w64gcc48.zip) running with PostgreSQL 9.2.13 64bit with PostGIS 2.1.7 on Windows Server 2008 R2 in our production database.

I'll test the PgRouting beta 2.1.0 on our dev database and let you know how it goes.

Thanks again

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: 11 August 2015 02:03
To: 'pgRouting users mailing list'
Subject: Re: [pgrouting-users] Could not load library librouting.dll error

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

_______________________________________________
Pgrouting-users mailing list
Pgrouting-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

This message is strictly confidential. If you have received this in error, please inform the sender and remove it from your system. If received in error you may not copy, print, forward or use it or any attachment in any way. This message is not capable of creating a legal contract or a binding representation and does not represent the views of Angus Council. Emails may be monitored for security and network management reasons. Messages containing inappropriate content may be intercepted. Angus Council does not accept any liability for any harm that may be caused to the recipient system or data on it by this message or any attachment.