[GitHub] [trafficcontrol] smalenfant opened a new issue #6094: LE: DB transaction stays open and caused login/timeouts/cookie issues

[GitBox <gi...@apache.org>]

smalenfant opened a new issue #6094:
URL: https://github.com/apache/trafficcontrol/issues/6094


   ## This Bug Report affects these Traffic Control components:
   
   - Traffic Ops
   
   ## Current behavior:
   
   I believe there is a few things here that compounded the issue. I first noticed that I couldn't login to Traffic Portal, but also that all APIs/cookies couldn't be used anymore. 
   
   This happened in the lab with `"max_db_connections": 20,`. I had the "autorenew" cron job running every 5 minutes (that was a test, forgot to put it back).
   
   The DB transactions did not expire. Traffic Ops restart is needed.
   
   I also had a few DS that had type=HTTP but sslKeyVersion != null. So LE was trying to renew those certificate as well. I don't think any of them was actually using Let's Encrypt.
   
   ERROR: autorenewcerts.go:134: 2021-08-10T14:43:10.616142838Z: no object found for the specified key with xmlId: ds1 and version: 10
   ERROR: autorenewcerts.go:134: 2021-08-10T14:43:10.63573371Z: no object found for the specified key with xmlId: ds2 and version: 4
   ERROR: autorenewcerts.go:134: 2021-08-10T14:43:10.677189119Z: no object found for the specified key with xmlId: ds3 and version: 2
   
   On the postgresql server, all connections were in transactions. 
   
   ```
   postgres: traffic_ops traffic_ops x.x.x.x(x) idle in transaction
   postgres: traffic_ops traffic_ops x.x.x.x(x) idle in transaction
   postgres: traffic_ops traffic_ops x.x.x.x(x) idle in transaction
   postgres: traffic_ops traffic_ops x.x.x.x(x) idle in transaction
   ```
   
   ## Expected behavior:
   
   Not running out of DB connections.
   
   ## Steps to reproduce:
   
   Pretty said in the current behavior. I'm not exactly sure if this can be reproduced easily.
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: issues-unsubscribe@trafficcontrol.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [trafficcontrol] ocket8888 closed issue #6094: LE: DB transaction stays open and caused login/timeouts/cookie issues

[GitBox <gi...@apache.org>]

ocket8888 closed issue #6094:
URL: https://github.com/apache/trafficcontrol/issues/6094


   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: issues-unsubscribe@trafficcontrol.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org