Skip to Content

Error 4224

Severity

10

Message text

WARNING: The transaction log for database ‘%.*s’ (dbid %d) can no longer be dumped due to user ‘%.*s’ (suid %d) executing %s.

Explanation

This warning is raised when a user executes a command that is minimally logged (such as select into) or otherwise does something that interrupts the sequence of transactions in the log (such as dump transaction with truncate_only).  After this happens, attempts to dump the transaction log will fail until a full database dump is taken.  

Action

If you wish to continue taking transaction log dumps you will need to take a full database dump first.

Database options can be set to prevent the use of commands that break the transaction log dump sequence.  See the Reference Manual entry on sp_dboption for details on the “select into”, “full logging” and “enforce dump tran sequence” options.  Turning “select into” off prevents the use of most minimally logged commands but does not prevent the use of dump transaction with truncate_only.

If you don’t care about taking transaction log dumps, consider setting the “truncate log on ckpt” option for this database.

Versions in which this error is raised

This warning was introduced in ASE 15.5 ESD #4 and 15.7 ESD #1 to help identify who and what was causing transaction log sequences to be interrupted.  Until 15.7 ESD #2, this warning was also unnecessarily raised for databases that had the “truncate log on ckpt” option turned on.

One of my current projects is updating and expanding the ASE Troubleshooting and Error Messages Guide (TSG).  As I update existing error writeups and create new ones, I’ll be posting the new content to this blog rather than making you wait for the next edition of the TSG.  If there is an error message that you are particularly interested in seeing a writeup on, please feel free to send me a direct message giving the error number or text and any comments you may have on the message and I’ll plan to work on it sooner rather than later.  If your need for an explanation is urgent, please follow the usual process for opening a Technical Support case (SAP message) for assistance with your situation.

-bret

To report this post you need to login first.

3 Comments

You must be Logged on to comment or reply to a post.

  1. guest 020415

    Hello Bret,

    Firstly thank you for your post. It helped me understand the error I am getting. I had scheduled the tran log backups through DBACOCKPIT and it ran successfully for some time before giving me the error. I had set the parameters as below before starting the tran log backups;

    sp_dboption SID , ‘full logging for all’, true

    sp_dboption SID , ‘trunc’, false

    sp_dboption SID , ‘enforce dump tran sequence’, true

    Any additional parameters that I need to add to avoid this error.  Any reply from your end will be very much appreciated.

    Thanks and Regards

    Surajit

    (0) 
    1. Bret Halford Post author

      Hi Surajit,

      What is your ASE version (select @@version)?

      In the 4224 message you recieved, what did it say about who did what to break the sequence?

      -bret

      (0) 
      1. guest 020415

        Hello Bret,

        Thank you for getting back to me. My Sybase ASE version is 15.7.0.42. My OS is based on RHEL 6.

        The backup log message reads as below;

        WARNING: The transaction log for database ‘SID’ (dbid 4) can no longer be dumped due to user ” (suid 0) executing DU

        MP TRAN WITH TRUNCATE_ONLY.

        That is the latest entry on the backup log.

        My thought was i can avoid these situations by setting the parameter ‘ enforce dump tran sequence’ to true.

        Thanks

        Surajit

        (0) 

Leave a Reply