BUG #1500: child dead
The following bug has been logged online:
Bug reference: 1500
Logged by: nagash
Email address: postgresql@nagash.org
PostgreSQL version: 8.0.1
Operating system: RedHat
Description: child dead
Details:
site_utf=# SELECT to_char(NOW() - '2000-10-02'::date, 'YYYYMonDD');
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
tested on 2 servers and it show with exactly 'YYYYMonDD' if I write
SELECT to_char(NOW() - '2000-10-02'::date, 'YYYY');
it will be OK
"nagash" <postgresql@nagash.org> writes:
site_utf=# SELECT to_char(NOW() - '2000-10-02'::date, 'YYYYMonDD');
server closed the connection unexpectedly
Hmm, I get bad output rather than a core dump, but it certainly seems
like a "must fix" if a dump is possible. Karel, can you look into it?
regression=# select to_char('1605 days 12:09:35'::interval, 'YYYYMonDD');
to_char
-----------
0001�@16
(1 row)
regression=#
regards, tom lane
Tom Lane wrote:
"nagash" <postgresql@nagash.org> writes:
site_utf=# SELECT to_char(NOW() - '2000-10-02'::date, 'YYYYMonDD');
server closed the connection unexpectedlyHmm, I get bad output rather than a core dump, but it certainly seems
like a "must fix" if a dump is possible. Karel, can you look into it?
I got sig-11 here (although that was with an 8.0 beta I had lying
around) - does it with intervals but not with dates.
--
Richard Huxton
Archonet Ltd
SELECT to_char(NOW() - '2000-10-02'::date, 'YYYYMonDD');
Clear CRASH and autorestart.
Need fix :-|
pg 8.0.1 FreeBSD 5.2.1
Core size 3334144
Best regards,
Alexander Kirpa
Import Notes
Resolved by subject fallback
If it's any help, on windows 8.0.0, I get a popup that says
'The instruction at "0x78001d90" referenced memory at "0x00000000". The
memory could not be read."
klint.
+---------------------------------------+-----------------+
: Klint Gore : "Non rhyming :
: EMail : kg@kgb.une.edu.au : slang - the :
: Snail : A.B.R.I. : possibilities :
: Mail University of New England : are useless" :
: Armidale NSW 2351 Australia : L.J.J. :
: Fax : +61 2 6772 5376 : :
+---------------------------------------+-----------------+