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
