[ovirt-users] PostgreSQL tuning in oVirt

[Hari Prasanth Loganathan]

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 at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20180312/ee89d8d4/attachment.html>