Well hot dang, I managed to reproduce this:
$ ./followlog "dbname = tschema" <log.sql
command failed at log line 30522:
COMMIT PREPARED
'257_dm0td2luMjAwMHByby8yNTM2AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA==_MQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=='
PANIC: failed to re-find shared lock object
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
$
So at least now we know it's not a Windows-specific issue, which is
something I was getting more and more worried about after two days of
not being able to duplicate the crash. I went so far as to make a
program that reads the log excerpt Michel sent, and execute the commands
in sequence on as many different connections as he had active ... and
darn if it doesn't fail. It seems fully reproducible on both 8.2 and
HEAD.
Now to start debugging. We can stop pestering Michel to run various
strange binaries, at least.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
