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

dave.potts at pinan.co.uk dave.potts at pinan.co.uk
Sat Apr 16 00:36:10 PDT 2016


It may be missing a try catch, but is the input data valid ?
16 April 2016 08:00, "Vicky Vergara"  wrote:

it doesnt have the try catch
On Fri, Apr 15, 2016 at 11:03 PM, Stephen Woodbridge  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
processes

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.

Thanks,
 -Steve

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus (https://www.avast.com/antivirus)
_______________________________________________
Pgrouting-users mailing list
Pgrouting-users at lists.osgeo.org (mailto:Pgrouting-users at lists.osgeo.org)
http://lists.osgeo.org/mailman/listinfo/pgrouting-users (http://lists.osgeo.org/mailman/listinfo/pgrouting-users)
--
	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 (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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20160416/4d3f3e73/attachment-0001.html>


More information about the Pgrouting-users mailing list