Things I've tried so far:
- Checking the mariadb tables -- no problems.
- Reducing accepts in the mojolicious settings.
- Increasing accepts
- Increasing graceful_timeout
- Increasing inactivity_timeout
- Increasing heartbeat_timeout (Logically speaking, it does not seem to be a timeout issue, since the transactions that show this error are very short.)
- Reducing workers and spares (on the theory it's a race condition and fewer processes competing for the DB will help)
- Disabling antivirus endpoint protection on the server
Nothing seems to make a difference, I'm still getting "unable to retrieve permissions" errors. This is becoming an absolute fiasco. It's happened over 4000 times in the last week, affecting over 600 different students. This same server seemed to run fine under lighter load during summer term. I'm running out of knobs I can try tweaking, so I'm hoping for some suggestions.
- Checking the mariadb tables -- no problems.
- Reducing accepts in the mojolicious settings.
- Increasing accepts
- Increasing graceful_timeout
- Increasing inactivity_timeout
- Increasing heartbeat_timeout (Logically speaking, it does not seem to be a timeout issue, since the transactions that show this error are very short.)
- Reducing workers and spares (on the theory it's a race condition and fewer processes competing for the DB will help)
- Disabling antivirus endpoint protection on the server
Nothing seems to make a difference, I'm still getting "unable to retrieve permissions" errors. This is becoming an absolute fiasco. It's happened over 4000 times in the last week, affecting over 600 different students. This same server seemed to run fine under lighter load during summer term. I'm running out of knobs I can try tweaking, so I'm hoping for some suggestions.