search

VEuPathDB / EdaSubsettingService

A REST service to provide data and subsetting in the Exploratory Data Analysis Workspace
Apache License 2.0
0 stars 0 forks source link

Look into connection leak issues in QA #132

Open dmgaldi opened 7 months ago

dmgaldi commented 7 months ago

The following SQL queries are for 

        at org.gusdb.fgputil.db.stream.ResultSets.openStream(ResultSets.java:35)
        at org.gusdb.fgputil.db.stream.ResultSets.openStream(ResultSets.java:23)
        at org.veupathdb.service.eda.ss.model.db.FilteredResultFactory.produceVariableDistribution(FilteredResultFactory.java:464)
6da709b16e9d9648756c769bd373f202: 3 instances

  Instance details:

    org.gusdb.fgputil.db.leakmonitor.CloseableObjectType@cc99910 for app-db, open for 1171274.599 seconds, retrieved from pool at 2024-01-10T21:08:06.412 during request with ID 35GLS
    org.gusdb.fgputil.db.leakmonitor.CloseableObjectType@cc99910 for app-db, open for 1172511.82 seconds, retrieved from pool at 2024-01-10T20:47:29.191 during request with ID 7YVij
    org.gusdb.fgputil.db.leakmonitor.CloseableObjectType@cc99910 for app-db, open for 1171452.774 seconds, retrieved from pool at 2024-01-10T21:05:08.237 during request with ID 22UiO

This batch got stuck back on Jan 10 possibly when the service was under heavy load.

    org.gusdb.fgputil.db.leakmonitor.CloseableObjectType@cc99910 for app-db, open for 72644.708 seconds, retrieved from pool at 2024-01-23T14:18:36.302 during request with ID 3Azf5
    org.gusdb.fgputil.db.leakmonitor.CloseableObjectType@cc99910 for app-db, open for 72643.469 seconds, retrieved from pool at 2024-01-23T14:18:37.542 during request with ID 6Si5E
    org.gusdb.fgputil.db.leakmonitor.CloseableObjectType@cc99910 for app-db, open for 74447.649 seconds, retrieved from pool at 2024-01-23T13:48:33.362 during request with ID 5J5VA
    org.gusdb.fgputil.db.leakmonitor.CloseableObjectType@cc99910 for app-db, open for 1171078.951 seconds, retrieved from pool at 2024-01-10T21:11:22.06 during request with ID 3m7Pl
    org.gusdb.fgputil.db.leakmonitor.CloseableObjectType@cc99910 for app-db, open for 76246.898 seconds, retrieved from pool at 2024-01-23T13:18:34.113 during request with ID 4NXT1
    org.gusdb.fgputil.db.leakmonitor.CloseableObjectType@cc99910 for app-db, open for 1.042 seconds, retrieved from pool at 2024-01-24T10:29:19.969 during request with ID 1EFSI
    org.gusdb.fgputil.db.leakmonitor.CloseableObjectType@cc99910 for app-db, open for 1172002.409 seconds, retrieved from pool at 2024-01-10T20:55:58.602 during request with ID 57DQN
    org.gusdb.fgputil.db.leakmonitor.CloseableObjectType@cc99910 for app-db, open for 1170592.024 seconds, retrieved from pool at 2024-01-10T21:19:28.987 during request with ID 1tNF6
    org.gusdb.fgputil.db.leakmonitor.CloseableObjectType@cc99910 for app-db, open for 76246.927 seconds, retrieved from pool at 2024-01-23T13:18:34.084 during request with ID 3roxe
    org.gusdb.fgputil.db.leakmonitor.CloseableObjectType@cc99910 for app-db, open for 74449.641 seconds, retrieved from pool at 2024-01-23T13:48:31.37 during request with ID 3Qp2P
    org.gusdb.fgputil.db.leakmonitor.CloseableObjectType@cc99910 for app-db, open for 72643.587 seconds, retrieved from pool at 2024-01-23T14:18:37.424 during request with ID 1Gnfw
    org.gusdb.fgputil.db.leakmonitor.CloseableObjectType@cc99910 for app-db, open for 74448.539 seconds, retrieved from pool at 2024-01-23T13:48:32.472 during request with ID 7ez5Z
    org.gusdb.fgputil.db.leakmonitor.CloseableObjectType@cc99910 for app-db, open for 72643.758 seconds, retrieved from pool at 2024-01-23T14:18:37.253 during request with ID 6DiBQ
    org.gusdb.fgputil.db.leakmonitor.CloseableObjectType@cc99910 for app-db, open for 74449.226 seconds, retrieved from pool at 2024-01-23T13:48:31.785 during request with ID 1R6wu
    org.gusdb.fgputil.db.leakmonitor.CloseableObjectType@cc99910 for app-db, open for 72643.059 seconds, retrieved from pool at 2024-01-23T14:18:37.952 during request with ID 1lkfr
    org.gusdb.fgputil.db.leakmonitor.CloseableObjectType@cc99910 for app-db, open for 1169890.208 seconds, retrieved from pool at 2024-01-10T21:31:10.803 during request with ID 4JLIH
    org.gusdb.fgputil.db.leakmonitor.CloseableObjectType@cc99910 for app-db, open for 76246.987 seconds, retrieved from pool at 2024-01-23T13:18:34.024 during request with ID 5qyxN
dmgaldi commented 7 months ago

These requests also got stuck on Jan 10:

Found the following stuck SQL from Jan 24: