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

McDonaldR · August 10, 2015, 2:18pm

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@angus.gov.uk

Dave_Potts · August 10, 2015, 2:28pm

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@angus.gov.uk<mailto:mcdonaldr@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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

McDonaldR · August 10, 2015, 2:59pm

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:\Windows\System32
\WindowsPowerShell\v1.0\;D:\Php;D:\Php\ext;D:\PostgreSQL\9.2\bin;D:\PostgreSQL\9.2\lib

And:

Path=C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\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@lists.osgeo.org [mailto:pgrouting-users-bounces@lists.osgeo.org] On Behalf Of dave.potts@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@angus.gov.uk<mailto:mcdonaldr@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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

_______________________________________________
Pgrouting-users mailing list
Pgrouting-users@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.

robe · August 10, 2015, 3:14pm

I had to upgrade the gcc I am using for building with PostgreSQL 9.2 and
also they made a change in PostgreSQL 9.2 micros around 9.2.5 or so that is
incompatible with older postgresql 9.2 that forced a recompile of some
things.

I'll build a new PostgreSQL 9.2 and pgRouting 2.0.0 and test with latest 9.2
64-bit. If it goes well I'll push to application stack builder (PostgreSQL
9.2 PostGIS 2.1.8 and pgRouting 2.0.0)

Let me spin up a 9.2 64-bit to test with and see what's up.

Thanks,
Regina

-----Original Message-----
From: pgrouting-users-bounces@lists.osgeo.org
[mailto:pgrouting-users-bounces@lists.osgeo.org] On Behalf Of McDonaldR
Sent: Monday, August 10, 2015 10:59 AM
To: pgRouting users mailing list <pgrouting-users@lists.osgeo.org>
Subject: Re: [pgrouting-users] Could not load library librouting.dll error

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:\Windows\Syst
em32
\WindowsPowerShell\v1.0\;D:\Php;D:\Php\ext;D:\PostgreSQL\9.2\bin;D:\PostgreS
QL\9.2\lib

And:

Path=C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\Syst
em32
\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@lists.osgeo.org
[mailto:pgrouting-users-bounces@lists.osgeo.org] On Behalf Of
dave.potts@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@angus.gov.uk<mailto:mcdonaldr@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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

_______________________________________________
Pgrouting-users mailing list
Pgrouting-users@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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

Dave_Potts · August 10, 2015, 3:15pm

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:\Windows\System32
\WindowsPowerShell\v1.0\;D:\Php;D:\Php\ext;D:\PostgreSQL\9.2\bin;D:\PostgreSQL\9.2\lib

And:

Path=C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\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@lists.osgeo.org
[mailto:pgrouting-users-bounces@lists.osgeo.org] On Behalf Of
dave.potts@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@angus.gov.uk<mailto:mcdonaldr@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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

_______________________________________________
Pgrouting-users mailing list
Pgrouting-users@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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

McDonaldR · August 10, 2015, 4:01pm

Thank you Regina

It would be good to test that. Will the binaries also be available from winnie.postgis.net? We operate behind a firewall and cannot use the stack builder.

Ross

-----Original Message-----
From: pgrouting-users-bounces@lists.osgeo.org [mailto:pgrouting-users-bounces@lists.osgeo.org] On Behalf Of Paragon Corporation
Sent: 10 August 2015 16:14
To: 'pgRouting users mailing list'
Subject: Re: [pgrouting-users] Could not load library librouting.dll error

I had to upgrade the gcc I am using for building with PostgreSQL 9.2 and also they made a change in PostgreSQL 9.2 micros around 9.2.5 or so that is incompatible with older postgresql 9.2 that forced a recompile of some things.

I'll build a new PostgreSQL 9.2 and pgRouting 2.0.0 and test with latest 9.2 64-bit. If it goes well I'll push to application stack builder (PostgreSQL
9.2 PostGIS 2.1.8 and pgRouting 2.0.0)

Let me spin up a 9.2 64-bit to test with and see what's up.

Thanks,
Regina

-----Original Message-----
From: pgrouting-users-bounces@lists.osgeo.org
[mailto:pgrouting-users-bounces@lists.osgeo.org] On Behalf Of McDonaldR
Sent: Monday, August 10, 2015 10:59 AM
To: pgRouting users mailing list <pgrouting-users@lists.osgeo.org>
Subject: Re: [pgrouting-users] Could not load library librouting.dll error

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:\Windows\Syst
em32
\WindowsPowerShell\v1.0\;D:\Php;D:\Php\ext;D:\PostgreSQL\9.2\bin;D:\PostgreS
QL\9.2\lib

And:

Path=C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\Syst
em32
\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@lists.osgeo.org
[mailto:pgrouting-users-bounces@lists.osgeo.org] On Behalf Of dave.potts@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@angus.gov.uk<mailto:mcdonaldr@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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

_______________________________________________
Pgrouting-users mailing list
Pgrouting-users@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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

_______________________________________________
Pgrouting-users mailing list
Pgrouting-users@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.

McDonaldR · August 10, 2015, 4:15pm

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@lists.osgeo.org [mailto:pgrouting-users-bounces@lists.osgeo.org] On Behalf Of dave.potts@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@lists.osgeo.org
[mailto:pgrouting-users-bounces@lists.osgeo.org] On Behalf Of
dave.potts@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@angus.gov.uk<mailto:mcdonaldr@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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

_______________________________________________
Pgrouting-users mailing list
Pgrouting-users@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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

_______________________________________________
Pgrouting-users mailing list
Pgrouting-users@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.

robe · August 10, 2015, 4:22pm

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@lists.osgeo.org
[mailto:pgrouting-users-bounces@lists.osgeo.org] On Behalf Of McDonaldR
Sent: Monday, August 10, 2015 12:16 PM
To: pgRouting users mailing list <pgrouting-users@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@lists.osgeo.org
[mailto:pgrouting-users-bounces@lists.osgeo.org] On Behalf Of
dave.potts@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@lists.osgeo.org
[mailto:pgrouting-users-bounces@lists.osgeo.org] On Behalf Of
dave.potts@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@angus.gov.uk<mailto:mcdonaldr@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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

_______________________________________________
Pgrouting-users mailing list
Pgrouting-users@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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

_______________________________________________
Pgrouting-users mailing list
Pgrouting-users@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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

robe · August 10, 2015, 4:29pm

Yes. The binaries get created by Winnie and I test and package to push to
stack builder and also copy to http://download.osgeo.org/postgis/windows/
So they are always available on her first and released on osgeo

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

Thank you Regina

It would be good to test that. Will the binaries also be available from
winnie.postgis.net? We operate behind a firewall and cannot use the stack
builder.

Ross

-----Original Message-----
From: pgrouting-users-bounces@lists.osgeo.org
[mailto:pgrouting-users-bounces@lists.osgeo.org] On Behalf Of Paragon
Corporation
Sent: 10 August 2015 16:14
To: 'pgRouting users mailing list'
Subject: Re: [pgrouting-users] Could not load library librouting.dll error

I had to upgrade the gcc I am using for building with PostgreSQL 9.2 and
also they made a change in PostgreSQL 9.2 micros around 9.2.5 or so that is
incompatible with older postgresql 9.2 that forced a recompile of some
things.

I'll build a new PostgreSQL 9.2 and pgRouting 2.0.0 and test with latest 9.2
64-bit. If it goes well I'll push to application stack builder (PostgreSQL
9.2 PostGIS 2.1.8 and pgRouting 2.0.0)

Let me spin up a 9.2 64-bit to test with and see what's up.

Thanks,
Regina

-----Original Message-----
From: pgrouting-users-bounces@lists.osgeo.org
[mailto:pgrouting-users-bounces@lists.osgeo.org] On Behalf Of McDonaldR
Sent: Monday, August 10, 2015 10:59 AM
To: pgRouting users mailing list <pgrouting-users@lists.osgeo.org>
Subject: Re: [pgrouting-users] Could not load library librouting.dll error

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:\Windows\Syst
em32
\WindowsPowerShell\v1.0\;D:\Php;D:\Php\ext;D:\PostgreSQL\9.2\bin;D:\PostgreS
QL\9.2\lib

And:

Path=C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\Syst
em32
\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@lists.osgeo.org
[mailto:pgrouting-users-bounces@lists.osgeo.org] On Behalf Of
dave.potts@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@angus.gov.uk<mailto:mcdonaldr@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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

_______________________________________________
Pgrouting-users mailing list
Pgrouting-users@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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

_______________________________________________
Pgrouting-users mailing list
Pgrouting-users@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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

McDonaldR · August 10, 2015, 4:46pm

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@lists.osgeo.org [mailto:pgrouting-users-bounces@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@lists.osgeo.org
[mailto:pgrouting-users-bounces@lists.osgeo.org] On Behalf Of McDonaldR
Sent: Monday, August 10, 2015 12:16 PM
To: pgRouting users mailing list <pgrouting-users@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@lists.osgeo.org
[mailto:pgrouting-users-bounces@lists.osgeo.org] On Behalf Of dave.potts@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@lists.osgeo.org
[mailto:pgrouting-users-bounces@lists.osgeo.org] On Behalf Of
dave.potts@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@angus.gov.uk<mailto:mcdonaldr@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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

_______________________________________________
Pgrouting-users mailing list
Pgrouting-users@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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

_______________________________________________
Pgrouting-users mailing list
Pgrouting-users@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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

_______________________________________________
Pgrouting-users mailing list
Pgrouting-users@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.

robe · August 10, 2015, 11:06pm

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-----
From: Paragon Corporation [mailto:lr@pcorp.us]
Sent: Monday, August 10, 2015 12:29 PM
To: 'pgRouting users mailing list' <pgrouting-users@lists.osgeo.org>
Subject: RE: [pgrouting-users] Could not load library librouting.dll error

Yes. The binaries get created by Winnie and I test and package to push to
stack builder and also copy to http://download.osgeo.org/postgis/windows/
So they are always available on her first and released on osgeo

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

Thank you Regina

It would be good to test that. Will the binaries also be available from
winnie.postgis.net? We operate behind a firewall and cannot use the stack
builder.

Ross

-----Original Message-----
From: pgrouting-users-bounces@lists.osgeo.org
[mailto:pgrouting-users-bounces@lists.osgeo.org] On Behalf Of Paragon
Corporation
Sent: 10 August 2015 16:14
To: 'pgRouting users mailing list'
Subject: Re: [pgrouting-users] Could not load library librouting.dll error

I had to upgrade the gcc I am using for building with PostgreSQL 9.2 and
also they made a change in PostgreSQL 9.2 micros around 9.2.5 or so that is
incompatible with older postgresql 9.2 that forced a recompile of some
things.

I'll build a new PostgreSQL 9.2 and pgRouting 2.0.0 and test with latest 9.2
64-bit. If it goes well I'll push to application stack builder (PostgreSQL
9.2 PostGIS 2.1.8 and pgRouting 2.0.0)

Let me spin up a 9.2 64-bit to test with and see what's up.

Thanks,
Regina

-----Original Message-----
From: pgrouting-users-bounces@lists.osgeo.org
[mailto:pgrouting-users-bounces@lists.osgeo.org] On Behalf Of McDonaldR
Sent: Monday, August 10, 2015 10:59 AM
To: pgRouting users mailing list <pgrouting-users@lists.osgeo.org>
Subject: Re: [pgrouting-users] Could not load library librouting.dll error

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:\Windows\Syst
em32
\WindowsPowerShell\v1.0\;D:\Php;D:\Php\ext;D:\PostgreSQL\9.2\bin;D:\PostgreS
QL\9.2\lib

And:

Path=C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\Syst
em32
\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@lists.osgeo.org
[mailto:pgrouting-users-bounces@lists.osgeo.org] On Behalf Of
dave.potts@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@angus.gov.uk<mailto:mcdonaldr@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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

_______________________________________________
Pgrouting-users mailing list
Pgrouting-users@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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

_______________________________________________
Pgrouting-users mailing list
Pgrouting-users@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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

robe · August 10, 2015, 11:11pm

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@lists.osgeo.org
[mailto:pgrouting-users-bounces@lists.osgeo.org] On Behalf Of Paragon
Corporation
Sent: Monday, August 10, 2015 7:06 PM
To: 'pgRouting users mailing list' <pgrouting-users@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-----

robe · August 11, 2015, 1:03am

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@pcorp.us ) and we'll take a look.

Thanks,
Regina

-----Original Message-----
From: Paragon Corporation [mailto:lr@pcorp.us]
Sent: Monday, August 10, 2015 7:11 PM
To: 'pgRouting users mailing list' <pgrouting-users@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@lists.osgeo.org
[mailto:pgrouting-users-bounces@lists.osgeo.org] On Behalf Of Paragon
Corporation
Sent: Monday, August 10, 2015 7:06 PM
To: 'pgRouting users mailing list' <pgrouting-users@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-----

McDonaldR · August 11, 2015, 3:57pm

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@lists.osgeo.org [mailto:pgrouting-users-bounces@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@pcorp.us ) and we'll take a look.

Thanks,
Regina

-----Original Message-----
From: Paragon Corporation [mailto:lr@pcorp.us]
Sent: Monday, August 10, 2015 7:11 PM
To: 'pgRouting users mailing list' <pgrouting-users@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@lists.osgeo.org
[mailto:pgrouting-users-bounces@lists.osgeo.org] On Behalf Of Paragon Corporation
Sent: Monday, August 10, 2015 7:06 PM
To: 'pgRouting users mailing list' <pgrouting-users@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@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.