Hello All,
In our setup under heavy load (too many client performing
updates) we have observed the underlying CIFS module runs out of memory and the
database crashes or goes in recovery mode.
Nov 28 09:17:32 ng78 kernel: CIFS VFS
(1006f1e5e,pid=19342): Error in Open = Out of memory<3> ISVS(0615,i=96)
ro nOe u fmoy<3> CIFS VFS(1006f16,pid196) ror i pn u fmmor
Nov 28 09:17:32 ng78 postgres[19342]: [10-1] 192.168.20.78 19342 2013-11-28
09:17:32.882 PST ERROR: could not open file "base/16384/16794":
Cannot allocate memory
Nov 28 09:17:32 ng78 postgres[19342]: [10-2] 192.168.20.78 19342 2013-11-28
09:17:32.882 PST STATEMENT: select
The physical memory on the machine is 64 GB
Postgres version 9.0.4
Hardware is 64 bit
I wish to know why is the database crashing if the file
open fails? Why can't it handle it gracefully by rolling back the transaction?
Umesh