Re: problem: long transaction aborted, logs full

On 23 Oct 1994, John Blomberg wrote: } Messages from log file: } } 15:22:41 INFORMIX-OnLine Initialized -- Shared Memory Initialized } 15:22:41 Physical Recovery Started } 15:22:42 Checkpoint Completed } 15:22:42 Physical Recovery Complete: 16 Pages Restored } 15:22:42 Aborting Long Transaction: pid = 0, uid = 11 } } After about 5 minutes ... } Logical Log Files are Full -- Backup is Needed run tbtape -a : it'll back up your Logical Logs, and away you go again. Our 12 logs fill periodically, if the users were overly active on the weekends. We just do the backup, and things continue, after a log becomes free. B.