search

mbari-org / oni

Organism Naming Infrastructure
https://mbari-org.github.io/oni/docs
0 stars 0 forks source link

Timeouts are occurring in the fast phylogeny up/down endpoints #4

Closed hohonuuli closed 2 months ago

hohonuuli commented 3 months ago

While doing integration testing at DARC, I ran into stability issues with Oni. Sometimes it would work fine, other times it would timeout waiting for a response from the database. This was most evident from calls to the fast phylogeny endpoints, but it appears to occur in other db calls too. I need to look to see if some of the calls are triggering deadlocks or if the virtual threads are getting pinned, which would also cause deadlocks.

hohonuuli commented 3 months ago

This may related to brettwooldridge/HikariCP#2151. I'm using org.hibernate.hikaricp.internal.HikariCPConnectionProvider under the hood. Source