| Pradheep A R |
Thu May 07 11:34:03 BST 2009 |
| |
Hi, I use primrose and configured a set of databases to use from different db servers.
One of the db servers was rebooted when my application was running.
After that, the getConnections were sent to wrong pools.
I also experienced primrose returning connection waits to threads even when the database server is down.
Things became normal when i restarted tomcat.
Did any one experience this issue?
|
| |
| Pradhee |
Thu May 07 11:39:53 BST 2009 |
| |
|
| Pradheep A R |
Thu May 07 11:45:42 BST 2009 |
| |
Listing the properties i used to connect to the db servers.
# -----------------------------------------------
# SyncPool1 Properites
# -----------------------------------------------
poolName=syncPool1
base=1
overflow=1
idleTime=1200000
logLevel=error
driverClass=net.sourceforge.jtds.jdbc.Driver
driverURL=jdbc:jtds:sqlserver://dbserver1.com/db1;progName=MyWeb;packetSize=32768;
user=username
password=password
killActiveConnectionsOverAge=120000000
cycleConnections=1000
queueConnectionRequests=true
waitForConnectionIfDatabaseIsDown=true
log=/logLocation/test.log
# -----------------------------------------------
# myPool2 Properites
# -----------------------------------------------
poolName=myPool2
base=20
overflow=50
idleTime=1200000
logLevel=warn,info,error,crisis
driverClass=net.sourceforge.jtds.jdbc.Driver
driverURL=jdbc:jtds:sqlserver://dbserver2.com/db2;progName=MyEmail;packetSize=32768;
user=username
password=password
killActiveConnectionsOverAge=120000000
cycleConnections=1000
queueConnectionRequests=true
waitForConnectionIfDatabaseIsDown=true
log=/logLocation/test2.log
dbserver1.com/db1 was down and then connections that should go to myPool2 were going to SyncPool1 and primrose was giving connectionWaits even when dbserver1.com/db1 is down. |
|
