Folks,

Just had a client report a core dump of 7.3.3 on on SunOS 2.9 after the system
was running for a couple of weeks.

I'm inclined to tell them to upgrade to 7.3.6 and try again, but was wondering
if this jogs anyone's memory. I've searched the archives and the HISTORY,
and the only 7.3.3 --> 7.3.6 core dumping issues I see relate to pg_dump, or
Solaris 7.

--
-Josh Berkus
Aglio Database Solutions
San Francisco


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Josh Berkus <josh (AT) agliodbs (DOT) com> writes:
Can't do much without more detail than that. A stack trace would be
most helpful, but at the very least I'd want to know what query dumped
core...

Is it reproducible?

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

Tom,

Apparently not ... just crops up randomly, after 2+ weeks of good service.
Will dig for more information ... and get them to upgrade to 7.3.6.

--
-Josh Berkus

______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh (AT) agliodbs (DOT) com
and data management solutions (415) 565-7293
for law firms, small businesses fax 651-9224
and non-profit organizations. San Francisco


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Josh Berkus <josh (AT) agliodbs (DOT) com> writes:
Yeah, given the presence of the sometimes-fails-to-restart-after-crash
bug in 7.3.3, it would be irresponsible not to make them update to 7.3.6
ASAP anyway.

I don't have very strong hope that 7.3.6 will cure their problem,
although I do see a couple of post-7.3.3 CVS entries that could possibly
be relevant, notably:

2003-07-17 16:52 tgl

* src/backend/utils/adt/selfuncs.c (REL7_3_STABLE): Work around
buggy strxfrm() present in some Solaris releases.

Don't recall now which are "some" Solaris releases.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)

Tom,

Turns out it is the "user with no password" bug, which was throught to affect
only Solaris 7 or 8. However, it turns out that they are using a
pre-release of Solaris 9, so they have the same issue. They've been told to
upgrage to 7.3.6.

--
-Josh Berkus
Aglio Database Solutions
San Francisco


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html