Internal I/O request

Question

Internal I/O request

Congruent Influence

Default port

Points: 1416
More actions
October 16, 2002 at 2:35 pm

#158208

I have been receiving this error periodically in doing backups. The backup will fail. It doesn't matter if it is a full backup or a transaction log backup.
The error is as follows:
Internal I/O request 0x6E704D78: Op: ReadLogScattered, pBuffer: 0x0B270000, Size: 983040, Position: 5930033152, EndingOffset: 5932025856, SegLen: 983040, SegStride: 983040, UMS: Internal: 0x20202020, InternalHigh: 0x70012020, Offset: 0xD29200, OffsetHigh: 0x0, m_buf: 0x0B270000, m_len: 983040, m_actualBytes: 0, m_errcode: 1450, File: ...................
The error is typically accompanied with the following error:
BackupIoRequest::WaitForIoCompletion: write failure on backup device 'yadayada.ldf'. Operating system error 1450(Insufficient system resources exist to complete the requested service.).
Typically, if I restart the backup, the job will succeed. However, I have seen it where this will go on all day. That makes me nervous. When I ran into this on an all day situation, I ran DBCC CheckDb and that fixed things that day. That was on a weekend however when I can get away with doing something like that.
Any suggestions for preventative medicine in the future? Aditionally, does anyone have a general guideline they follow as to how frequently to run DBCC CheckDB?
Remember this when a developer tells you it will just be temporary. Temporary = Permanent.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 1

I did see same problem in my server too. There is a regristry need to be modified. I will try to find it out.

Can you check the errors in system and application logs around that period which you got insufficient resource error message?

Can you also provide your hardware info too?

Edited by - Allen_Cui on 10/16/2002 7:15:13 PM

Antares686 SSC Guru Points: 125444 More actions · Answer 2

I believe this is the KB Article Allen is referring to

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q304101

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 3

Thanks Antares686.

If you also have event id 2020/2021 in the application log, pls refer Q317249 too.

Do you configur OS with either 3GB or PAE and AWE for SQL Server?

Congruent Influence Default port Points: 1416 More actions · Answer 4

Thanks for the replies. I think this KB article will have something that can help. I have not seen events 2020/2021. We are running Win 2k AS with 6gb ram 8 cpus on a compaq box. We are using AWE.

Remember this when a developer tells you it will just be temporary. Temporary = Permanent.