What are the challenges you face when working across database platforms? Take the survey
Options

backup failing - Thread 0 error

johnp12johnp12 Posts: 10
edited February 23, 2011 8:08PM in SQL Backup Previous Versions
Hello,

We have been using sql backup now for 2 years. as of last week we have been getting an issue every couple of days where our nighly backup has been failing, here is the data from the log file... any ideas?? thanks

SQL Backup log file 6.4.0.1004

-SQL "BACKUP DATABASE [DB802] TO DISK = 'D:\Backups\DB802\<AUTO>.sqb' WITH ERASEFILES = 3, DISKRETRYINTERVAL = 30, DISKRETRYCOUNT = 10, COMPRESSION = 4, THREADCOUNT = 6, VERIFY "

ERRORS AND WARNINGS


2/23/2011 4:00:01 AM: Backing up DB802 (full database) to:
2/23/2011 4:00:01 AM: D:\Backups\DB802\FULL_(local)_DB802_20110223_040001.sqb

2/23/2011 4:00:01 AM: BACKUP DATABASE [DB802] TO VIRTUAL_DEVICE = 'SQLBACKUP_35EFCF8F-FCEB-4366-80D5-7A823AF90409', VIRTUAL_DEVICE = 'SQLBACKUP_35EFCF8F-FCEB-4366-80D5-7A823AF9040901', VIRTUAL_DEVICE = 'SQLBACKUP_35EFCF8F-FCEB-4366-80D5-7A823AF9040902',
VIRTUAL_DEVICE = 'SQLBACKUP_35EFCF8F-FCEB-4366-80D5-7A823AF9040903', VIRTUAL_DEVICE = 'SQLBACKUP_35EFCF8F-FCEB-4366-80D5-7A823AF9040904', VIRTUAL_DEVICE = 'SQLBACKUP_35EFCF8F-FCEB-4366-80D5-7A823AF9040905' WITH BUFFERCOUNT = 30, BLOCKSIZE = 65536,
MAXTRANSFERSIZE = 1048576, NAME = N'Database (DB802), 2/23/2011 4:00:01 AM', DESCRIPTION = N'Backup on 2/23/2011 4:00:01 AM Server: WPED001 Database: DB802', FORMAT

2/23/2011 4:02:01 AM: Thread 0 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
2/23/2011 4:02:01 AM:
2/23/2011 4:02:01 AM: Thread 1 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
2/23/2011 4:02:01 AM:
2/23/2011 4:02:01 AM: Thread 2 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
2/23/2011 4:02:01 AM:
2/23/2011 4:02:01 AM: Thread 3 error:
Process terminated unexpectedly. Error code: -2139684861 (The api was waiting and the timeout interval had elapsed.)
2/23/2011 4:02:01 AM:
2/23/2011 4:02:01 AM: Thread 4 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
2/23/2011 4:02:01 AM:
2/23/2011 4:02:01 AM: Thread 5 error:
Process terminated unexpectedly. Error code: -2139684861 (The api was waiting and the timeout interval had elapsed.)
2/23/2011 4:02:01 AM:
2/23/2011 4:02:24 AM: SQL error 3013: SQL error 3013: BACKUP DATABASE is terminating abnormally.
2/23/2011 4:02:24 AM: SQL error 3271: SQL error 3271: A nonrecoverable I/O error occurred on file "SQLBACKUP_35EFCF8F-FCEB-4366-80D5-7A823AF90409:" 995(The I/O operation has been aborted because of either a thread exit or an application request.).

Comments

  • Options
    peteypetey Posts: 2,358 New member
    It looks like the backup kicked off at 4:00:01 AM, but was blocked. Your VDI timeout value was probably set to 2 minutes, which is why SQL Backup returned with a timeout error at 4:02:01 AM. Whatever was blocking the backup cleared up at 4:02:24, but SQL Backup had already aborted the backup process by then.

    Were there any database restructuring tasks running around that time, that might have blocked the backup? Or another backup (e.g. trx log backup) of the same database that may have been still running during that time?

    Thanks.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
Sign In or Register to comment.