Consultor Eletrônico



Kbase P11634: Does the transaction backout within a log file indicate that a change was attempted to the database.
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   15/10/2008
Status: Verified

GOAL:

Does a transaction backout within a log file indicate that a change was attempted to the database.

FIX:

Yes, if a user is disconnected while attempting to perform a transaction.
This might be indicated in the log file as:

23:02:28 SRV 47: Begin transaction backout. (2252)
23:02:28 SRV 47: Transaction backout completed. (2253)
23:02:28 SRV 47: Logout by lindo_sql on . (453)

This indicates that a transaction begin note was created but the user disconnected or terminated before completing the transaction.