Issue   

Database deadlocks occur in the pr_operators table when applying customizations to the table’s activity logic. These deadlocks may also arise when using the model operator in an OAuth2 configuration. Changing the DSS to True bypasses the indexing updates caused by the operator login activity. As a result, operator-specific fields such as pyLastSignOn might not be immediately reflected in search indexes. 

The following symptoms occur as part of this issue:  

• Users are unable to access their production environments during updates and migration.  

• Deadlocks occur in the pr_operators table.  

• Requestors (operators who are logging) experience abnormal spikes.  

• High volume of inserts in the pr_operators table.  

• Nodes become unhealthy and go down.  

• Spikes in the CPU usage.  

Root Cause  

The database deadlocks occur in the pr_operators table as customizations to the table’s activity logic overrides the DSS operator/status/skipDBSave.  

Solution  

A bug has been raised to set the DSS settings to True by default in the upcoming release. This change will resolve the database spikes in the pr_operators table when using the model operator in the OAuth2 configuration. This Known Issue document will be updated with release details when the fix for this issue is available.  

As a best practice, avoid making customizations to the pr_operators table.