Agreements app times out

Description

In several tenants, we often see that Agreements app - v7.0.8 gets unresponsive. On digging further, we see that there are several active sessions getting created in the database and that the agreements app times out. Attached are performance insights and logs of the DB.

Workaround : Restarting the application is the only way to get it back on track.

CSP Request Details

None

CSP Rejection Details

None

Potential Workaround

None

Attachments

5

Checklist

hide

Activity

Show:

Jag Goraya December 9, 2024 at 11:40 AM

Additional guidance provided here:

Sobha Duvvuri November 19, 2024 at 2:30 PM

Yes, it is false for all tenants

Owen Stephens November 19, 2024 at 9:54 AM
Edited

Thank you

In your list of steps you don’t mention checking <tenantName>_mod_agreements.tenant_changelog_lock table. Can you confirm the locked column in this table is false

Sobha Duvvuri November 18, 2024 at 10:07 PM

Also please confirm you have checked all the levels of lock table as listed by Ethan below? Can you let us know if any of these have lock entries ?

Only federation_lock table has entries. Typical process that we follow to get the module back up and running -


  1. stop the container

  2. Delete entries in federation_lock table

  3. check if the system_changelog_lock table lock is set to true and if so, change it to false but in both cases, none of these were set to true

  4. start the container and it operates fine again

    Main step was to delete entries from federation_lock table

Sobha Duvvuri November 18, 2024 at 10:05 PM

We do not have a CPU allocation so the container can take as much CPU as needed from the underlying instance and each instance has typically 8 vCPUs - 8192 CPU to consume from

Done

Details

Assignee

Reporter

Components

Priority

Sprint

Development Team

Bienenvolk

Release

Not For Release

RCA Group

TBD

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs

Created November 7, 2024 at 11:49 PM
Updated December 18, 2024 at 2:00 PM
Resolved December 9, 2024 at 11:40 AM
TestRail: Cases
TestRail: Runs