Re: [GENERAL] pg crash shortly after 9.1.1 -> 9.1.2 upgrade

2011-12-20 Thread Tom Lane
Joseph Shraibman writes: > On 12/08/2011 12:54 AM, Tom Lane wrote: >> Joseph Shraibman 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 >> T

Re: [GENERAL] pg crash shortly after 9.1.1 -> 9.1.2 upgrade

2011-12-07 Thread Joseph Shraibman
On 12/08/2011 12:54 AM, Tom Lane wrote: Joseph Shraibman 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

Re: [GENERAL] pg crash shortly after 9.1.1 -> 9.1.2 upgrade

2011-12-07 Thread Tom Lane
Joseph Shraibman 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 own

[GENERAL] pg crash shortly after 9.1.1 -> 9.1.2 upgrade

2011-12-07 Thread Joseph Shraibman
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 STATEMENT: select "_devel".cleanupEvent('10 minutes'::interval, 'false'::boolean); WARNING: AbortTransaction w