Обсуждение: Memory allocation and Vacuum abends
Hi all,
I have a 4 CPU, 4GB Ram memory box running PostgreSql 8.2.3 under Win 2003 in a very high IO intensive insert application.
The application inserts about 570 rows per minute or 9 rows per second.
We have been facing some memory problem that we cannot understand.
From time to time memory allocation goes high and even after we stop postgresql service the memory continues allocated and if were restart the service the Postgres crash over.
It’s a 5 GB database size already that was born 1 and a half month ago. We have 2 principal tables partitioned.
Above is the log file. Do anyone have any idea what could the problem be……
Thanks in advance.
2007-05-23 13:21:00 LOG: CreateProcess call failed: A blocking operation was interrupted by a call to WSACancelBlockingCall.
(error code 1450)
2007-05-23 13:21:00 LOG: could not fork new process for connection: A blocking operation was interrupted by a call to WSACancelBlockingCall.
2007-05-23 13:21:06 LOG: could not receive data from client: An operation on a socket could not be performed because the system lacked sufficient buffer space or because a queue was full.
2007-05-23 13:21:17 LOG: server process (PID 256868) exited with exit code 128
2007-05-23 13:21:17 LOG: terminating any other active server processes
2007-05-23 13:21:17 WARNING: terminating connection because of crash of another server process
2007-05-23 13:21:17 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.
2007-05-23 13:21:17 HINT: In a moment you should be able to reconnect to the database and repeat your command.
2007-05-23 13:21:17 WARNING: terminating connection because of crash of another server process
2007-05-23 13:21:17 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.
2007-05-23 13:21:17 WARNING: terminating connection because of crash of another server process
2007-05-23 13:21:17 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.
What does top report as using the most memory? On Wed, May 23, 2007 at 11:01:24PM -0300, Leandro Guimar?es dos Santos wrote: > Hi all, > > > > I have a 4 CPU, 4GB Ram memory box running PostgreSql 8.2.3 under Win 2003 in a very high IO intensive insert application. > > > > The application inserts about 570 rows per minute or 9 rows per second. > > > > We have been facing some memory problem that we cannot understand. > > > > From time to time memory allocation goes high and even after we stop postgresql service the memory continues allocatedand if were restart the service the Postgres crash over. > > > > It's a 5 GB database size already that was born 1 and a half month ago. We have 2 principal tables partitioned. > > > > Above is the log file. Do anyone have any idea what could the problem be...... > > > > Thanks in advance. > > > > > > 2007-05-23 13:21:00 LOG: CreateProcess call failed: A blocking operation was interrupted by a call to WSACancelBlockingCall. > > (error code 1450) > > 2007-05-23 13:21:00 LOG: could not fork new process for connection: A blocking operation was interrupted by a call toWSACancelBlockingCall. > > > > 2007-05-23 13:21:06 LOG: could not receive data from client: An operation on a socket could not be performed because thesystem lacked sufficient buffer space or because a queue was full. > > 2007-05-23 13:21:17 LOG: server process (PID 256868) exited with exit code 128 > > 2007-05-23 13:21:17 LOG: terminating any other active server processes > > 2007-05-23 13:21:17 WARNING: terminating connection because of crash of another server process > > 2007-05-23 13:21:17 DETAIL: The postmaster has commanded this server process to roll back the current transaction andexit, because another server process exited abnormally and possibly corrupted shared memory. > > 2007-05-23 13:21:17 HINT: In a moment you should be able to reconnect to the database and repeat your command. > > 2007-05-23 13:21:17 WARNING: terminating connection because of crash of another server process > > 2007-05-23 13:21:17 DETAIL: The postmaster has commanded this server process to roll back the current transaction andexit, because another server process exited abnormally and possibly corrupted shared memory. > > 2007-05-23 13:21:17 WARNING: terminating connection because of crash of another server process > > 2007-05-23 13:21:17 DETAIL: The postmaster has commanded this server process to roll back the current transaction andexit, because another server process exited abnormally and possibly corrupted shared memory. > > > -- Jim Nasby decibel@decibel.org EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)