[pgrouting-users] Could not load library librouting.dll error
McDonaldR
McDonaldR at angus.gov.uk
Mon Aug 10 09:46:30 PDT 2015
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-binaries-2.0.0w64.zip). If I install the gcc48 version (http://winnie.postgis.net/download/windows/pg92/buildbot/pgrouting-pg92-binaries-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-binaries-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: 10 August 2015 17:23
To: 'pgRouting users mailing list'
Subject: Re: [pgrouting-users] Could not load library librouting.dll error
Ross,
The libstdc++6.dll comes distributed with PostGIS. It should be in your PostgreSQL/bin folder so you dshouldn't ened to be fussing with environment paths.
Is your PostGIS 2.1.7 working okay?
Given that you are running a newer 9.2, you'll need the ones on Winnie marked gcc48 .
Sorry haven't tried checking on my test server yet. In the middle of a client emergency at the moment.
The one marked 9.2pgroutingbeta1gcc48 on Winnie should work. The 2.0.0 might be because it was compiled against a pre 9.2.5 postgres and older gcc, and I need to recompile for newer postgres.
Thanks,
Regina
-----Original Message-----
From: pgrouting-users-bounces at lists.osgeo.org
[mailto:pgrouting-users-bounces at lists.osgeo.org] On Behalf Of McDonaldR
Sent: Monday, August 10, 2015 12:16 PM
To: pgRouting users mailing list <pgrouting-users at lists.osgeo.org>
Subject: Re: [pgrouting-users] Could not load library librouting.dll error
Hello Dave
With the updated PATH variable the Dependency Walker finds the correct DLLs that were missing before but now there are 5 more that appear in the list related to LIBSTDC++-6.dll:
IESHIMS.dll
MF.dll
MFPLAT.dll
MFREADWRITE.dll
WLANAPI.dll
The database service has been restarted.
I've also rebooted.
I still get the librouting.dll not found error.
Ross
-----Original Message-----
From: pgrouting-users-bounces at lists.osgeo.org
[mailto:pgrouting-users-bounces at lists.osgeo.org] On Behalf Of dave.potts at pinan.co.uk
Sent: 10 August 2015 16:16
To: pgRouting users mailing list
Subject: Re: [pgrouting-users] Could not load library librouting.dll error
How did you restart the database ?
The way that windows works means that an changed envronmential variable is only available after its been changed.
So a new dos window will the changed value.
If your running your database as a service, it will not see the changed envronmential variable util its restarted. Perhaps you need to changed the value then do a reboot?
> Thanks for the reply, Dave
>
> I've tried with the PATH set to both:
>
> Path=C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Window
> s\System32
> \WindowsPowerShell\v1.0\;D:\Php;D:\Php\ext;D:\PostgreSQL\9.2\bin;D:\Po
> stgreSQL\9.2\lib
>
> And:
>
> Path=C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Window
> s\System32 \WindowsPowerShell\v1.0\;D:\Php;D:\Php\ext
>
> I wonder if it is something to do with the way PostgreSQL, PostGIS and
> PgRouting are compiled? Looking at
> http://winnie.postgis.net/download/windows/pg92/buildbot/ there are
> versions compiled with GCC4.8 and others with something else. I've
> tried all the 64bit binary versions there with no luck.
>
> Ross
>
> -----Original Message-----
> From: pgrouting-users-bounces at lists.osgeo.org
> [mailto:pgrouting-users-bounces at lists.osgeo.org] On Behalf Of
> dave.potts at pinan.co.uk
> Sent: 10 August 2015 15:28
> To: pgRouting users mailing list
> Subject: Re: [pgrouting-users] Could not load library librouting.dll
> error
>
> Hi
>
> What is the environmental variable path set to ?
>
> You can get its value by opening a dos window and typing set
>
> This variable lists the folders that an application will search
> through to find library files.
>
> You can change its value by selecting control panel-->Adminstrative
> Tools-> Right click on computer select properties-> select advanced
> system settings and the envrionment variable button is on the lower
> right hand side
>
> The value should be a list off folders to search seperated by a ;
> character.
>
> Dave
>
> #> Hello list,
>>
>> I am running 64bit PostgreSQL 9.2.13 with PostGIS 2.1.7 on Windows
>> Server
>> 2008 R2. I have pgRouting installed (2.0.0 build 40, hash 567ac3b,
>> boost
>> 1.46.1)
>>
>> I am getting an error when trying to use pgRouting.
>>
>> [ERROR: could not load library "D:/PostgreSQL/9.2/lib/librouting.dll":
>> The specified procedure could not be found.
>> SQL state: 58P01]
>>
>> SQL state error 58P01 is UNDEFINED FILE.
>>
>> Using dependency walker it tells me that librouting.dll cannot find
>> libgcc_s_sjlj-1.dll and libstdc++-6.dll and postgres.exe. These
>> files all exist in the \bin folder of my PostgreSQL install. The
>> PgRouting files are all installed in the \lib folder.
>>
>> I get the error when using both the PgAdmin SQL pane and the
>> pgRouting Layer plugin in QGIS.
>>
>> Any pointers or suggestions appreciated.
>>
>> Thanks
>>
>> Ross
>>
>> Ross McDonald | GIS Data Coordinator | Resources Department, IT
>> Division | Angus Council, Angus House, Orchardbank Business Park,
>> Forfar, DD8 1AT
>> T: 01307 476419 | F: 01307 476401 | E:
>> mcdonaldr at angus.gov.uk<mailto:mcdonaldr at angus.gov.uk>
>>
>>
>>
>> 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.
>> _______________________________________________
>> Pgrouting-users mailing list
>> Pgrouting-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>
>
> _______________________________________________
> 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.
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>
_______________________________________________
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.
_______________________________________________
Pgrouting-users mailing list
Pgrouting-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users
_______________________________________________
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.
More information about the Pgrouting-users
mailing list