Hi. A customer is running sqla 11.0.1.2044. They periodically will see the following error...

SQLANYs_resqprod: Fatal error: disk full when writing to "d:\resq\resqwin\resqprod\db\resqprod.log"

... even though the disk has plenty of space. Any suggestions?

Thanks, Doug

P.S. Tried to upload an sqla crash dump file, but was unsuccessful.

asked 18 Jun '13, 15:59

dejstone's gravatar image

dejstone
959395069
accept rate: 0%

edited 18 Jun '13, 17:10

Volker%20Barth's gravatar image

Volker Barth
30.3k300452660


Hi Doug,

There was a fix in CR #670470 in 11.0.1.2689 to "fix" potentially misleading error codes when writing to the disk that would otherwise indicate that the disk was full. There may be an alternative issue with the file system that would be correctly reported with a newer build. I would recommend upgrading and check to see if the 'out of disk space' message changes.


Another frequent issue is one dealing with the temporary file - remember that while in operation, the database server will maintain the temporary file to store temporary results. Once the server is shut down, this file is cleared which sometimes makes it "look" like you have plenty of space when you go to check the free space afterwards -- when really it's the temporary file taking up the disk space during operation. To set the temporary file location, see the documentation.

permanent link

answered 18 Jun '13, 16:30

Jeff%20Albion's gravatar image

Jeff Albion
10.7k171174
accept rate: 24%

Thanks Jeff. Yes, I will recommend that they upgrade sqla and I may use the -dt option to relocate the temporary file. Thanks again.

(18 Jun '13, 16:35) dejstone

I just found that the server's virtual drive is set about 5 gig below the recommended size. Also, the drive was setup to reside on C: drive, the smallest drive, with only 2 gig free. I am asking sys admin to resize the virtual drive and move it to a drive with more room.

permanent link

answered 18 Jun '13, 16:31

dejstone's gravatar image

dejstone
959395069
accept rate: 0%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×137
×37
×20
×10

question asked: 18 Jun '13, 15:59

question was seen: 2,743 times

last updated: 18 Jun '13, 17:10