Opened 8 years ago
Closed 3 years ago
#954 closed task (wontfix)
Increase database pool size for Component Registry
| Reported by: | Twan Goosen | Owned by: | Sander Maijers |
|---|---|---|---|
| Priority: | major | Milestone: | |
| Component: | System administration | Version: | |
| Keywords: | clarinvm.ics.muni.cz, catalog.clarin.eu | Cc: | Willem Elbers, Dieter Van Uytvanck |
Description
On 22 June there were some issues with the Component Registry that could be traced back to the following JDBC issue:
org.apache.tomcat.jdbc.pool.PoolExhaustedException: [ajp-nio-8009-exec-6] Timeout: Pool empty. Unable to fetch a connection in 4 seconds, none available[size:25; busy:25; idle:0; lastwait:4000].
This seems to have been a genuine case of a high demand, although I have not been able to confirm this e.g. by looking at the access statistics as I do not have access to the host. Feel free to look into this. Assuming no other cause can be determined, my proposal is to increase the number of connections in the database pool for the Component Registry database and possibly also increase the wait time (4000ms seems a bit short, though not sure if that is due to configuration).
Change History (2)
comment:1 Changed 8 years ago by
| Cc: | Willem Elbers Dieter Van Uytvanck added |
|---|
comment:2 Changed 3 years ago by
| Resolution: | → wontfix |
|---|---|
| Status: | new → closed |
Note: See
TracTickets for help on using
tickets.
Not longer relevant due to dockerisation