Details
-
Type: Bug
-
Status: Closed
-
Priority: Major
-
Resolution: Duplicate
-
Affects Version/s: unspecified
-
Fix Version/s: None
-
Component/s: Data Summarization
-
Labels:None
-
Environment:
Operating System: Linux
Platform: PC
-
Bugzilla Id:3213
Description
Currently, one WarehouseSummarizer instance is created for each TSA Account (in
the the SearchEngineSummarizer.WarehouseSummarizerSearchEngineAccountDispatcher
class). This creates a new database pool for each account, which can result in
too many database connections being open at once.
To fix this, we need to fix the concurrency issues with the
MultiPlexDatabasePool class, and then we need to share a common DatabasePool
between SearchEngineSummarizer and WarehouseSummarizer by passing the existing
pool to the WarehouseSummarizer.
2009-09-05 04:05:20.478 (2) [P191T0]: Exception [creating pooled
Database]:com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Too
many connections
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:921)
2009-09-05 04:05:20.479 (1) [P191T0]: Exception [Account #620 Catch All
]:java.lang.NullPointerException
2009-09-05 04:05:20.504 (2) [P190T9]: Exception [creating pooled
Database]:com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Too
many connections
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:921)
2009-09-05 04:05:20.505 (1) [P190T9]: Exception [Account #534 Catch All
]:java.lang.NullPointerException
2009-09-05 04:05:20.659 (2) [P193T0]: Exception [creating pooled
Database]:com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Too
many connections
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:921)
2009-09-05 04:05:20.660 (1) [P193T0]: Exception [Account #580 Catch All
]:java.lang.NullPointerException
Attachments
Issue Links
- duplicates
-
ADMAX-2209 SearchEngineSummarizer loses database connection
- Closed