Problem Note 63963: A database connection fails and a "Timeout: Pool empty" error occurs when you search for information in SAS® Visual Investigator
When you use the search capability in SAS Visual Investigator, you might fail to get results. In your Search and Discovery (SAND) log, you see "Pool empty" error messages that are similar to the following:
2019-02-11 21:42:27.978 ERROR 12 — [o-8080-exec-171] o.h.engine.jdbc.spi.SqlExceptionHelper : sas.svi-datahub@@acme [271f5399ce537deb] [http-nio-8080-exec-171] Timeout: Pool empty. Unable to fetch a connection in 30 seconds, none available[size:100; busy:100; idle:0; lastwait:30000].
A potential workaround is to increase the number of connections in the connection pool for your application server. Eventually, however, the number of connections will be exhausted, and you might need to restart the application server to free up connections.
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
Operating System and Release Information
SAS System | SAS Visual Investigator | Linux for x64 | 10.4 | 10.5.1 | Viya | Viya |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2021-05-03 14:32:57 |
Date Created: | 2019-04-02 14:28:40 |