April 25, 2016 at 9:46 pm
Backup Error
Error:3203, Severity 16, state 1
Read on "D:\MSSQL\DATA\database.mdf" failed: 1(Incorrect function.)
Error 3041, Severity 16, state
BACKUP failed to complete the command BACKUP DATABASE database. Check the backup application log for detailed messages.
Found it Windows Log
The operating system returned error 1(Incorrect function.) to SQL Server during a read at offset 0x000008d92d4000 in file 'D:\MSSQL\DATA\database.mdf_MSSQL_DBCC38'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
Tried to CheckDB
checkdb was aborted.
msg 0 level 11 state 0 line 0 a severe error occurred on the current command
xp_fixeddrives;
C291379
D971687
E1004183
System Error
FusionEventDriver
Cisco UCS 2600GB MLC Fusion ioMemory PX (2,0): Read request 3992 (FFFFE0002A8C76E0) failed (772:3749849280 - 8192). EB read count = 5939.
Can someone give me some lights π
April 25, 2016 at 10:16 pm
Help me please π thank you
April 25, 2016 at 10:22 pm
elie.etaxpoint (4/25/2016)
Help me please π thank you
What is the output of this code?
EXEC xp_fixeddrives;
π
April 25, 2016 at 10:26 pm
C291379
D971687
E1004183
It still have a lot of free space
April 25, 2016 at 10:28 pm
C291379
D971687
E1004183
April 25, 2016 at 10:36 pm
Looks like a problem with the drive / IO subsystem. Can you check the System Event Log if you find any related errors there? My guess is that you will find Event ID: 51
π
April 25, 2016 at 10:38 pm
Is the backup drive a local drive?
π
April 25, 2016 at 10:48 pm
Hi,
Yes I've tried it locally. There's no eventId 51 π
April 25, 2016 at 11:03 pm
What other earlier errors can you find in the sql server log?
EXEC sp_readerrorlog;
π
April 25, 2016 at 11:15 pm
Hi,
There was no earlier error aside from those.
There was a system error.
FusionEventDriver
Cisco UCS 2600GB MLC Fusion ioMemory PX (2,0): Read request 3992 (FFFFE0002A8C76E0) failed (772:3749849280 - 8192). EB read count = 5939.
Not sure if it's related π
April 25, 2016 at 11:23 pm
I suspect an IO subsystem failure, find it strange that there are no other errors in any logs. Can you post the full and unedited output of
dbcc checkdb (βyourdbnameβ) with no_infomsgs all_errormsgs
π
April 25, 2016 at 11:43 pm
Hi,
Took 5mins and no more messages.
Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.
April 25, 2016 at 11:50 pm
elie.etaxpoint (4/25/2016)
Hi,Took 5mins and no more messages.
Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.
You definitely have a serious problem with the IO subsystem, my suggestion is to bring in the hardware support.
A severe error occurred on the current command. The results, if any, should be discarded. means that the server was unable to perform the DBCC CHECKDB on the database!
π
April 26, 2016 at 12:06 am
Hi,
π Our last daily backup was last April 24, on April 25 it fails π can't restore to it.
Also Just now I check the mssql data directory.
I now have another database.mds_MSSQL_DBCC38. π
April 26, 2016 at 12:28 am
The problem is most likely the Fusion IO device, suggest you contact the vendor's support.
π
Also Just now I check the mssql data directory.
I now have another database.mds_MSSQL_DBCC38.
If the IO subsystem is failing then you may see erratic entries on the drive when listing out the content.
Viewing 15 posts - 1 through 15 (of 17 total)
You must be logged in to reply to this topic. Login to reply