Transaction quotas

Transaction quotas allow you to define a quota policy for different types of transactions. A transaction quota cancels any transaction in violation of the policy and notifies the user of the cancellation.

The Transaction Quotas plugin is active by default on all new and upgraded instances.
Figure 1. Transaction canceled
Canceled transaction
The transaction quota also writes the cancellation message to the log file as a warning.
Figure 2. Transaction cancelled log
Log of a canceled transaction

Typically, administrators set transaction quotas to prevent poorly performing queries and scripts from consuming system resources. This ensures that no transaction consumes enough resources to prevent other transactions from running. Administrators can also view cancellation log messages to identify transactions that might consume excessive resources.

How transaction quotas work

Transactions use the Quota Manager, which is a background thread that cancels transactions. The Quota Manager performs the following actions.
  1. Obtains a list of active transactions, similar to the list under User Administration > Active Transactions.
  2. Cycles through each transaction, and matches it to a quota rule if it does not have one assigned to it. If a transaction changes or there is a new quota rule, the Quota Manager reprocesses the transaction.
  3. Cancels the transaction if it has been running longer than the specified quota maximum.
  4. Logs the running transactions.
  5. Sleeps until the next heartbeat, which is controlled by the glide.quota.manager.heartbeat system property.

Transaction cancellation examples

Transactions can be canceled for more than one reason. Look for the following indicators.

  • maximum execution time exceeded: This message appears when the glide.quota.manager threads cancels the transaction.
  • canceled by other transaction: This message appears when the transaction was canceled by the session thread that initially issued it, and not by the glide.quota.manager thread.
  • canceled by user request: This message appears when the user clicked the red X button to cancel the running transaction.
If you are looking for transactions that were canceled by glide.quota.manager, Search for the [Message] [Contains] [maximum execution time exceeded] combination. For example:
Cancelling transaction /home.do - Default-thread-11.0 (maximum execution time exceeded): Thread Default-thread-11.0 (Default-thread-11.0, F530DD111B11111111FC031767DA158E), after 30000ms
.