protheus-locks-deadlocks
Pass
Audited by Gen Agent Trust Hub on Jul 21, 2026
Risk Level: SAFECOMMAND_EXECUTION
Full Analysis
- [COMMAND_EXECUTION]: The skill provides SQL commands for monitoring system activity and database locks (e.g., sp_who2, queries against pg_stat_activity, and v$session). It also documents administrative commands for terminating database sessions (e.g., KILL, pg_terminate_backend, and ALTER SYSTEM KILL SESSION) as a last-resort remediation step for resolving leaked locks in production environments.
- [SAFE]: The ADVPL code snippets provided implement standard industry patterns for transaction scoping and record locking, such as using BEGIN SEQUENCE/RECOVER for error handling and ensuring MsUnlock() is called in all execution paths. Diagnostic functions like TopMemoStatus() are used correctly to export system state for troubleshooting.
Audit Metadata