使用的数据库是Postgres数据库V8。每一个小时就会出现一次服务器连接错误。服务器断开连接,需要重新连接。请在下面找到错误日志,并告知解决此错误的解决方案
2012-01-05 13:28:52 CEST LOG: server process (PID 6128) was terminated by exception 0xC0000017
2012-01-05 13:28:52 CEST HINT: See C include file "ntstatus.h" for a description of the hexadecimal value.
2012-01-05 13:28:52 CEST LOG: terminating any other active server processes
2012-01-05 13:28:52 CEST WARNING: terminating connection because of crash of another server process
2012-01-05 13:28:52 CEST DETAIL:The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2012-01-05 13:28:52 CEST HINT:In a moment you should be able to reconnect to the database and repeat your command.
2012-01-05 13:28:52 CEST WARNING:terminating connection because of crash of another server process
2012-01-05 13:28:52 CEST DETAIL:The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory
提前感谢
显然,状态是status_NO_MEMORY,所以查看服务器内存设置(shared_buffers、work_mem等),并在机器崩溃时监控机器上的内存使用情况(如果是常规的)。它总是与某种预定任务相吻合吗?