[pgrouting-users] alphashape with less than 3 points crashing server process

McDonaldR McDonaldR at angus.gov.uk
Mon Apr 18 06:39:56 PDT 2016

New issue logged on Github together with sample network edges and nodes.

From: Pgrouting-users [mailto:pgrouting-users-bounces at lists.osgeo.org] On Behalf Of dave.potts at pinan.co.uk
Sent: 16 April 2016 08:36
To: pgRouting users mailing list
Subject: Re: [pgrouting-users] alphashape with less than 3 points crashing server process

It may be missing a try catch, but is the input data valid ?

16 April 2016 08:00, "Vicky Vergara" <vicky at georepublic.de<mailto:%22Vicky%20Vergara%22%20%3cvicky at georepublic.de%3e>> wrote:
it doesnt have the try catch

On Fri, Apr 15, 2016 at 11:03 PM, Stephen Woodbridge <woodbri at swoodbridge.com<mailto:woodbri at swoodbridge.com>> wrote:

On 4/15/2016 9:32 PM, Daniel Kastl wrote:
2016-04-15 14:40:15 BST  LOG  server process (PID 5044) was terminated
by exception 0xC0000005

2016-04-15 14:40:15 BST  LOG  terminating any other active server

2016-04-15 14:40:15 BST  WARNING  terminating connection because of
crash of another server process

So, I guess my question is, is there any way I can get my function to
fail gracefully when I hit this exception and stop my connection
terminating and the process crashing?

I remember, that this was an issue in the past, but I thought it had be
resolved long time ago by returning an error and not crashing the
process, so I don't even remember when.
We will look into this. Thanks for reporting.

The short answer is this is a bug and the way to stop the server from crashing is to fix the bug. The best way to do this is to find a case where you can repeat the issue and file a test case, then we can debug the issues and put in a fix for it.

The reason for the crash is because when something bad and unexpected happens the database can not be sure that all the other processes are in a stable state so it kills all the database processes so that the database will get recovered into a known stable state. While this may be annoying it is better than continuing with possible damaged and inconsistent data that will impact future results or potential destroy more data or return bad data.

If you have a test case that fails we would really like to get it so we can address this problem.


This email has been checked for viruses by Avast antivirus software.

Pgrouting-users mailing list
Pgrouting-users at lists.osgeo.org<mailto:Pgrouting-users at lists.osgeo.org>


Georepublic UG (haftungsbeschränkt) Salzmannstraße 44, 81739 München, Germany Vicky Vergara Operations Research eMail: vicky at georepublic.de<http://georepublic.de> Web: https://georepublic.info Tel: +49 (089) 4161 7698-1 Fax: +49 (089) 4161 7698-9 Commercial register: Amtsgericht München, HRB 181428 CEO: Daniel Kastl

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20160418/c38b072f/attachment-0001.html>

More information about the Pgrouting-users mailing list