http://bugzilla.novell.com/show_bug.cgi?id=623902
http://bugzilla.novell.com/show_bug.cgi?id=623902#c4
Jon Nelson
(In reply to comment #2)
[1] The only commandline arguments where the name of a local db. No host, users, etc. That shouldn't matter anyway, since it crashed in readline.
The piece of code that crashes isn't necessarily the piece of code that contains the bug. E.g. readline may crash on memory corruption caused by an unrelated command line switch.
That's very true.
[2] It happened after some time. Perhaps an hour.
Can you approximate how many SQL commands you had executed between the process start and the crash?
Dozens but not hundreds.
[3] UNfortunately, I don't recall exactly what they were but they were fairly long (3-10 line) sql queries. They didn't get saved to ~/.psql_history, of course. ;-)
If you still have the core file, you may find the SQL strings in there.
Generally speaking, it was nothing that I don't normally do anyway... so lots and lots of SELECTS (sometimes up to a screen long). Nothing special.
I should also note that postmaster has *crashed* on my machine since upgrading to openSUSE 11.3 (same config files, same database, same everything) at least 5 times in the last 36 hours.
What openSUSE and PostgreSQL versions were you using before?
openSUSE 11.2 and the stock postgresql version that came with it.
Eventually, I figured out that it was getting killed by the oom handler,
The oom handler kills the first process that requests memory when no more is available, but that's not necessarily the process that has actually caused the machine to be short on memory.
I didn't know that! Hmm. Indeed, the oom handler logs suggest that postmaster wasn't using *that* much memory: Jul 20 15:10:32 worklaptop kernel: [ 5262.441509] Killed process 2979 (postmaster) vsz:63772kB, anon-rss:28kB, file-rss:0kB .. In any case, if I continue to have postmaster issues I'll make another bug. I shouldn't have mixed these two up! For now, if I don't have any more psql segfaults I'll not worry about it. You can feel free to let this bug sit idle or whatever you feel is appropriate. I would like to note that openSUSE is (and has been), by far, the best platform I've yet used for PostgreSQL work. -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.