Re: [Virtuoso-users] Log out of disk

[Erick A. <er...@ps...>]

Hi Ted,

 indeed, it was due to the lack of disk space while writing the log 
files (my virtuoso.trx file, located in a small partition, was huge). I 
made a checkpoint and I also set the *AutoCheckpointLogSize* in my INI 
file. The program works again!

thanks!
Erick

Ted Thibodeau Jr wrote:
> Hi, Erick --
>
> * Erick Antezana [2008/08/08 12:29 AM +0200] wrote:
>   
>>  I got this error while loading some graphs using a perl script:
>>
>> DBD::ODBC::st execute failed: [unixODBC][OpenLink][Virtuoso iODBC
>> Driver][Virtuoso Server]SR174: Log out of disk (SQL-40004)
>>
>> any idea what this means?
>>     
>
> The Virtuoso Server writes a number of different logs, at a number
> of different levels, depending on various INI settings.
>
>    http://docs.openlinksw.com/virtuoso/dbadm.html
>
> The error you report indicates that there is no more disk space
> available for one of these logs -- which can be a major issue, if
> the logs are being written to the same disk as your DB and other
> files, and even more so if it is your OS boot disk.
>
> If you have not already done so, I recommend immediately reviewing
> your log settings, and instituting log-rolling (periodically moving
> the existing log to a gzipped archive).  Most environments do not
> require retention of more than the last few days or weeks of log;
> rotation and discard routines can be set on a time or size basis,
> depending on environment and other needs.
>
> Hope that helps,
>
> Ted
>
>
>
>
>