Hi Team,

We increased the number of threads in Apache web server and JBoss and we are able to scale up to 500 concurrent requests in oVirt.

But after the long run, we are getting the below error from PostgreSQL but the oVirt is still running successfully.

org.springframework.dao.DataAccessResourceFailureException: PreparedStatementCallback; SQL [select * from getvdcoptionbyname(?, ?)]; This connection has been closed.; nested exception is org.postgresql.util.PSQLException: This connection has been closed.

1) Could somebody explain this error?
2) What are the tuning parameters for PostgreSQL?

SystemConfiguration for reference :

16 GB Ram,
5GB for Ovirt
Architecture:          x86_64
CPU op-mode(s):        32-bit, 64-bit
Byte Order:            Little Endian
CPU(s):                4
On-line CPU(s) list:   0-3
Thread(s) per core:    1
Core(s) per socket:    4
Socket(s):             1
NUMA node(s):          1
Vendor ID:             GenuineIntel
CPU family:            6
Model:                 58
Model name:            Intel(R) Core(TM) i5-3450 CPU @ 3.10GHz
Stepping:              9
CPU MHz:               3369.191
BogoMIPS:              6200.27
Virtualization:        VT-x
L1d cache:             32K
L1i cache:             32K
L2 cache:              256K
L3 cache:              6144K
NUMA node0 CPU(s):     0-3

OS: Cent OS

Thanks,
Hari

DISCLAIMER

The information in this e-mail is confidential and may be subject to legal privilege. It is intended solely for the addressee. Access to this e-mail by anyone else is unauthorized. If you have received this communication in error, please address with the subject heading "Received in error," send to it@msystechnologies.com,  then delete the e-mail and destroy any copies of it. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. The views, opinions, conclusions and other information expressed in this electronic mail and any attachments are not given or endorsed by the company unless otherwise indicated by an authorized representative independent of this message.

MSys cannot guarantee that e-mail communications are secure or error-free, as information could be intercepted, corrupted, amended, lost, destroyed, arrive late or incomplete, or contain viruses, though all reasonable precautions have been taken to ensure no viruses are present in this e-mail. As our company cannot accept responsibility for any loss or damage arising from the use of this e-mail or attachments we recommend that you subject these to your virus checking procedures prior to use