shyamMelwani
Programmer
We are in the process of stress testing our application which uses postgres db (8.0 on windows XP) as the back-end. The application is j2ee based and uses the connection pool facility of jboss.
The DB log consistently reports the following error after 3 min of stress (50 db calls/sec - including inserts and fetches)
******
2005-12-15 16:26:07 LOG: server process (PID 3848) was terminated by signal 66
2005-12-15 16:26:07 LOG: terminating any other active server processes
2005-12-15 16:26:07 WARNING: terminating connection because of crash of another server process
2005-12-15 16:26:07 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.
2005-12-15 16:26:07 HINT: In a moment you should be able to reconnect to the database and repeat your command.
*******
Following are the changes in the postgresql.conf
max_connections = 105
shared_buffers = 10000
work_mem = 8192
Any help in resolving this error will be appreciated.
- Vimalesh
The DB log consistently reports the following error after 3 min of stress (50 db calls/sec - including inserts and fetches)
******
2005-12-15 16:26:07 LOG: server process (PID 3848) was terminated by signal 66
2005-12-15 16:26:07 LOG: terminating any other active server processes
2005-12-15 16:26:07 WARNING: terminating connection because of crash of another server process
2005-12-15 16:26:07 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.
2005-12-15 16:26:07 HINT: In a moment you should be able to reconnect to the database and repeat your command.
*******
Following are the changes in the postgresql.conf
max_connections = 105
shared_buffers = 10000
work_mem = 8192
Any help in resolving this error will be appreciated.
- Vimalesh