Pgre DB Crashes consistently

[shyamMelwani]

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

 

[kordaff]

Have you tested it with Perl using DBD:g/DBI to see if it have the same type of crash as JBoss? There is a new version of postgresql out now, 8.1. It may be a recent bug fix there.

What sort of table structure / query fingerprint are we talking about? What's the insert to query ratio?

Perl is just an idea, maybe it will eliminate the chance that it's a problem with JBoss etc. Also, maybe try running postgres on a Linux or FreeBSD server and see if that makes it more stable...

 

[PriceComparison]

Vimalesh,

Postgresql is a GREAT server. Mixing or using it on Windows is ...hmm... insulting? At least that is in my opinion.
Postgresql was written originaly in BSD, best platform to use is FreeBSD. But the fastest platform is Linux. Particularly Gentoo Linux.

Basicaly I am saying forget about fixing this problem, you will have many more if you do not switch to *nix.

Andrew - DBA for

http://www.PriceComparison.com

 

[Truusvlugindewind]

Agree. But I am really curious how DragonFly BSD would perform as a databas server. Could be interesting...