Products Solutions Support Services Partners Communities Company

Solution SOL14674

Title

Error: "Operating System Error 995" when performing backup or restore; flush failures on backup device.

Problem Description


Errors displayed intermittently in the SQL Server Error Log or Verbose LiteSpeed log files when performing backup / restore:

"write failure on backup device 'VDI_25CCCF9E-998A-4DA1-B433-386B20D5E949_1'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.)."

"BackupVirtualDeviceFile::RequestDurableMedia: Flush failure on backup device 'VDI_25CCCF9E-998A-4DA1-B433-386B20D5E949_1'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.)."

Cause

"Operating System Error 995" is a general error message reported when the I/O operation has been aborted because of the thread exit or application request.

During the LiteSpeed backup/restore operation, it would generate one to many processes to accessing the backup file(s). Whenever it encounter a non-recoverable error, it will abort the current threads/proccess.  As a result, "Operating System Error 995" is being log into LiteSpeed Log, SQL Error Log and Application Event Viewer Log

The actual error could be caused by but not limited to the following issues:
1) Resources issues
2) Network issues
3) Configuration issues
4) Memory issues
5) SQL Server issues
6) Third Party issues

Resolution

Try to reduce memtoleave issues by reducing @maxtransfersize or @threads parameter until backup/restores stabilise. Trial and error is the best, if not direct, method of resolving these types of issues.

The following is an example of LiteSpeed Log indicating there was a network issue:

2009-01-11 04:43:09.14 spid64      Error: 18210, Severity: 16, State: 1.
2009-01-11 04:43:09.14 spid64      BackupMedium::ReportIoError: write failure on backup device 'VDI_25CCCF9E-998A-4DA1-B433-386B20D5E949_2'. Operating system error 64(The specified network name is no longer available.).
2009-01-11 04:43:09.14 spid64      Error: 18210, Severity: 16, State: 1.
2009-01-11 04:43:09.14 spid64      BackupMedium::ReportIoError: write failure on backup device 'VDI_25CCCF9E-998A-4DA1-B433-386B20D5E949_0'. Operating system error 64(The specified network name is no longer available.).
2009-01-11 04:43:09.14 Backup      Error: 3041, Severity: 16, State: 1.
2009-01-11 04:43:09.14 Backup      BACKUP failed to complete the command BACKUP DATABASE Sample. Check the backup application log for detailed messages.
2009-01-11 04:43:09.14 spid64      Error: 18210, Severity: 16, State: 1.
2009-01-11 04:43:09.14 spid64      BackupMedium::ReportIoError: write failure on backup device 'VDI_25CCCF9E-998A-4DA1-B433-386B20D5E949_1'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.).
2009-01-11 04:43:09.14 spid64      Error: 18210, Severity: 16, State: 1.
2009-01-11 04:43:09.14 spid64      BackupVirtualDeviceFile::RequestDurableMedia: Flush failure on backup device 'VDI_25CCCF9E-998A-4DA1-B433-386B20D5E949_0'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.).
2009-01-11 04:43:09.14 spid64      Error: 18210, Severity: 16, State: 1.
2009-01-11 04:43:09.14 spid64      BackupVirtualDeviceFile::RequestDurableMedia: Flush failure on backup device 'VDI_25CCCF9E-998A-4DA1-B433-386B20D5E949_1'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.).
2009-01-11 04:43:09.14 spid64      Error: 18210, Severity: 16, State: 1.
2009-01-11 04:43:09.14 spid64      BackupVirtualDeviceFile::RequestDurableMedia: Flush failure on backup device 'VDI_25CCCF9E-998A-4DA1-B433-386B20D5E949_2'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.).

In this case, LiteSpeed was using 3 threads to performing backup.  'VDI_25CCCF9E-998A-4DA1-B433-386B20D5E949_0', 'VDI_25CCCF9E-998A-4DA1-B433-386B20D5E949_1', 'VDI_25CCCF9E-998A-4DA1-B433-386B20D5E949_2' is being generated for accessing the backup file(s).
'VDI_25CCCF9E-998A-4DA1-B433-386B20D5E949_2' and 'VDI_25CCCF9E-998A-4DA1-B433-386B20D5E949_0' first encounter the network error - "Operating system error 64(The specified network name is no longer available.)."  LiteSpeed then start aborting all the processes. 
The 'VDI_25CCCF9E-998A-4DA1-B433-386B20D5E949_1' encountered the abort command before hitting the network error.  So, it received "write failure on backup device 'VDI_25CCCF9E-998A-4DA1-B433-386B20D5E949_1'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request".

Then all the processes also hit the "Operating System Error 995" as a result of the processes abortion.

Note:  This issue has been known to occur on both 4.x and 5 .x versions of LiteSpeed

Additional Information

For trouble-shooting Memory Issue:
To tracking SQL Server MemtoLeave...

FIRST, create the following table:
CREATE TABLE [dbo].[MemToLeave](
[CONTIGUOUSSIZE] [int] NULL,
[RecordId] [int] IDENTITY(1,1) NOT NULL,
[RecordDate] [datetime] NOT NULL CONSTRAINT [DF_MemToLeave_RecordDate] DEFAULT (getdate())
) ON [PRIMARY]

THEN, create a job with the following:
declare @tmp_select char(500)
set @tmp_select = 'execute master.dbo.xp_memory_size'
INSERT INTO MemToLeave (CONTIGUOUSSIZE)
exec(@tmp_select)

This should assist in determining which parameters (-g switch for example) may be best in your setup.

Also, please check the following:  http://support.microsoft.com/kb/934396 

Environment

Product: LiteSpeed for SQL Server
Attachments: Memory troubleshooting.doc
Client OS: Unix - All
Server OS: Windows - All
Database: SQL Server - All

Feedback

How Useful was this Content?
Not at all useful    1   2   3   4   5    Extremely useful

Do you have a comment concerning this document?

 

Announcements

Featured Support Offering:
Business Critical Support Available NOW - 24x7, 365 days a year