<div dir="ltr"><div><div><div><div>Hi Team,<br><br></div>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.<br><br></div>But after the long run, we are getting the below error from PostgreSQL but the oVirt is still running successfully. <br><br>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. <br><br></div>1) Could somebody explain this error?<br></div><div>2) What are the tuning parameters for PostgreSQL?<br><br></div><div>SystemConfiguration for reference :<br><br></div><div>16 GB Ram,<br></div><div>5GB for Ovirt<br>Architecture: x86_64<br>CPU op-mode(s): 32-bit, 64-bit<br>Byte Order: Little Endian<br>CPU(s): 4<br>On-line CPU(s) list: 0-3<br>Thread(s) per core: 1<br>Core(s) per socket: 4<br>Socket(s): 1<br>NUMA node(s): 1<br>Vendor ID: GenuineIntel<br>CPU family: 6<br>Model: 58<br>Model name: Intel(R) Core(TM) i5-3450 CPU @ 3.10GHz<br>Stepping: 9<br>CPU MHz: 3369.191<br>BogoMIPS: 6200.27<br>Virtualization: VT-x<br>L1d cache: 32K<br>L1i cache: 32K<br>L2 cache: 256K<br>L3 cache: 6144K<br>NUMA node0 CPU(s): 0-3<br><br></div><div>OS: Cent OS<br></div><div><br></div><div>Thanks,<br></div><div>Hari <br></div></div>
<br>
<p style="text-align:justify"><span lang="EN-US"><font size="1">DISCLAIMER</font></span></p>
<p style="text-align:justify"><font size="1"><span lang="EN-US">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 <a href="mailto:it@msystechnologies.com" target="_blank">it@msystechnologies.com</a>,
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.</span></font></p>
<font size="1"><span lang="EN-US">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 </span>all reasonable
precautions have been taken to ensure no viruses are present in this e-mail<span lang="EN-US">. </span>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</font>