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




-- 
A: Yes.                      http://www.guckes.net/faq/attribution.html
| Q: Are you sure?
| | A: Because it reverses the logical flow of conversation.
| | | Q: Why is top posting frowned upon?

Ted Thibodeau, Jr.           //               voice +1-781-273-0900 x32
Evangelism & Support         //        mailto:tthibod...@openlinksw.com
OpenLink Software, Inc.      //              http://www.openlinksw.com/
                                 http://www.openlinksw.com/weblogs/uda/
OpenLink Blogs              http://www.openlinksw.com/weblogs/virtuoso/
                               http://www.openlinksw.com/blog/~kidehen/
    Universal Data Access and Virtual Database Technology Providers

Reply via email to