Error 7409

Severity

20

Message text

This task tried to sleep waiting for space to become available in the log, but could not.  The current command is being aborted because no further database changes can be logged.

Explanation

The last-chance threshold has been reached in a database. All transactions trying to write to the transaction log should be put to sleep until space is free in the transaction log. Adaptive Server was unable to put the transaction to sleep, so the transaction has been aborted.

Action

Verify that the threshold action defined for the last-chance threshold has executed successfully. If it did not complete, manually execute a dump transaction command to create free space in the log. Then rerun the transaction that was aborted. If the transaction still fails, check the Adaptive Server error log for additional information.

Refer to the chapter “Managing Free Space with Thresholds” in the System Administration Guide: Volume 2 for information about last-chance thresholds.

Versions in which this error is raised

All versions