A 9.1Beta1 test report from Richard Broersma (and confirmed on another system by Mark Watson) showed up pgsql-testers this week at http://archives.postgresql.org/pgsql-testers/2011-05/msg00000.php with the following test crashing his Windows server every time:

SELECT 'INFINITY'::TIMESTAMP;

That works fine for me on Linux. Richard chased the error in the logs, which was a generic "you can't touch that memory" one, down to a full stack trace: http://archives.postgresql.org/pgsql-testers/2011-05/msg00009.php

It looks like it's losing its mind inside of src/backend/utils/adt/datetime.c , specifically at this line in datebsearch:

   3576     while (last >= base)
   3577     {
   3578         position = base + ((last - base) >> 1);
   3579         result = key[0] - position->token[0];

Why crash there only on Windows? Was the problem actually introduced above this part of the code? These are all questions I have no answer for.

--
Greg Smith   2ndQuadrant US    g...@2ndquadrant.com   Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support  www.2ndQuadrant.us



--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to