dbTalk Databases Forums  

Sybase 11.0.3 - QRL Filter - No space

comp.databases.sybase comp.databases.sybase


Discuss Sybase 11.0.3 - QRL Filter - No space in the comp.databases.sybase forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Geezer From Freezer
 
Posts: n/a

Default Sybase 11.0.3 - QRL Filter - No space - 03-02-2004 , 08:51 AM






I am trying to add a "system" onto a repository using a 3rd party tool.
Whenever I do this, I get
"I/O while writing to QRL filter temporary file - no space left on device"

I have tried to do a google search and it yields nothing.

Sybase installation is on Solaris 8 - any suggestions?

Reply With Quote
  #2  
Old   
Bret Halford
 
Posts: n/a

Default Re: Sybase 11.0.3 - QRL Filter - No space - 03-02-2004 , 12:25 PM






Geezer From Freezer <Geezer (AT) Freezer (DOT) com> wrote

Quote:
I am trying to add a "system" onto a repository using a 3rd party tool.
Whenever I do this, I get
"I/O while writing to QRL filter temporary file - no space left on device"

I have tried to do a google search and it yields nothing.

Sybase installation is on Solaris 8 - any suggestions?

Sounds like an OS error - some file system on your box is filling
up. Try using "df -k" and see if any are at 100%.

-bret


Reply With Quote
  #3  
Old   
Geezer From Freezer
 
Posts: n/a

Default Re: Sybase 11.0.3 - QRL Filter - No space - 03-03-2004 , 10:17 AM





Bret Halford wrote:
Quote:

Sounds like an OS error - some file system on your box is filling
up. Try using "df -k" and see if any are at 100%.

-bret
Already check that, all FS have lots of space. Temp has over a Gb free.


Reply With Quote
  #4  
Old   
Bret Halford
 
Posts: n/a

Default Re: Sybase 11.0.3 - QRL Filter - No space - 03-03-2004 , 04:40 PM



Geezer From Freezer <Geezer (AT) Freezer (DOT) com> wrote

Quote:
Bret Halford wrote:


Sounds like an OS error - some file system on your box is filling
up. Try using "df -k" and see if any are at 100%.

-bret

Already check that, all FS have lots of space. Temp has over a Gb free.
Ok. Any chance that the underlying operation is loading the
dump of a database into ASE? (perhaps check if a similar message is
being reported to the backupserver errorlog.) If a database
is dumped into a file system and it fills during the dump (so the
dump file isn't complete), an attempt to load that dump will generate
a "device out of space" error (strange as that may sound).


Do any entries at all get reported to the ASE or Backupserver
errorlogs
when this happens?

If not, you might try running ASE with traceflag 3602 active - this
causes
all messages normally sent just to the client to the errorlog as well
- and might provide some clues.

-bret


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.