Re: pg crash shortly after 9.1.1 -> 9.1.2 upgrade

Joseph Shraibman <jks(at)selectacast(dot)net> writes:
> All was fine until:
> LOG: statement: select "_devel".cleanupEvent('10 minutes'::interval,
> 'false'::boolean);
> ERROR: could not open file "base/16406/2072097_fsm": Permission denied

That's pretty weird. What were the permissions on that file? Was it
properly owned by the postgres user?

> WARNING: AbortTransaction while in COMMIT state
> PANIC: cannot abort transaction 7108311, it was already committed

And that's even weirder, since it implies that we tried to open the FSM
file during post-commit cleanup. The commit-record printout suggests
that we probably were trying to delete the file due to a committed DROP
TABLE operation, but I don't understand why we tried to open the file
rather than just unlink it.

Can you reproduce this? Can you show us what cleanupEvent() does?

regards, tom lane