Uploaded image for project: 'RAML Module Builder'
  1. RAML Module Builder
  2. RMB-729

waitQueueTimeout in forked vertx-sql-client driver (DB_MAXPOOLSIZE)

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • TBD
    • Resolution: Unresolved
    • 31.1.0
    • None
    • CP: Roadmap backlog
    • Core: Platform
    • GBV

    Description

      Implement waitQueueTimeout for vertx-sql-client ConnectionPool.

      The connection pool has a max size. RMB has DB_MAXPOOLSIZE to configure it.
      If there are more parallel requests that require a connection they are put into the
      wait queue. If connections in use take long or are not released after use the requests stay in the wait queue forever. The clients of the waiting requests do not get any feedback. They are stuck. The module is unresponsive.

      Solution: Add a waitQueueTimeout to ConnectionPool. A timeout failure is returned if the request stays in the pool longer than waitQueueTimeout. Add DB_WAITQUEUETIMEOUT to RMB.

      Workaround: Limit the number requests waiting in the wait queue: https://vertx.io/docs/apidocs/io/vertx/sqlclient/PoolOptions.html#setMaxWaitQueueSize-int-

       

      TestRail: Results

        Attachments

          Issue Links

            is duplicated by

            Bug - A problem which impairs or prevents the functions of the product. RMB-710 Timeout when exceeding DB_MAXPOOLSIZE

            • TBD - To be determined
            • Closed
            relates to

            Task - A task that needs to be done. RMB-663 patch idle connection release in the upstream vertx-sql-client driver

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed

            Story - Created by Jira Software - do not edit or delete. Issue type for a user story. RMB-680 DB connection pool utilization monitoring

            • P2 - normal priority level, must be included in the current development cycle
            • Open

            Task - A task that needs to be done. RMB-739 patch idle connection release in the forked vertx-sql-client driver

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed

            Activity

              People

                Unassigned Unassigned
                julianladisch Julian Ladisch
                Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                  Created:
                  Updated:

                  TestRail: Runs

                    TestRail: Cases