Uploaded image for project: 'AdMax'
  1. AdMax
  2. ADMAX-2228

SearchEngineSummarizer: Creates too many DB connections

    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

            Activity

              People

              • Assignee:
                therouxj Jeff Theroux
                Reporter:
                therouxj Jeff Theroux
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: