(SA) Support Tip: How to fix the error "ConnectionPool lcrep: all connections in use" in vault logs
If an SA mesh experiences a large number of transactions that are not sent/received between the SA cores you can check the vault logs under /var/log/opsware/vault/ for the following error message:
[com.opsware.omb.db.ConnectionPool] [waitForConnection] ConnectionPool lcrep: all connections in use
This error message will occur if the database pool of connections is completely used and the vault is waiting for an available connection.
You may increase the number of available connections by following these steps:
1. Edit the vault configuration file on each SA infrastructure server:
2. Add/Modify the parameter com.opsware.omb.dbpool.poolSize (it is missing by default) and set the pool size to 20 (or more):
3. Restart the master gateway and the vault after the change:
/etc/init.d/opsware-sas restart opswgw-mgw vaultdaemon
For more information please refer to the following knowledge document:
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.