On Mon, 14 Sep 2009, Silver Salonen wrote:
> Hello.
>
> I've got a problem in Bacula 3.0.2 - one backup of a server always fails with
> error:
>
> JobId 14638: Fatal error: sql_create.c:806 Fill Filename table Query failed:
> INSERT INTO Filename (Name) SELECT a.Name FROM (SELECT DISTINCT Name FROM
> batch) AS a WHERE NOT EXISTS (SELECT Name FROM Filename AS f WHERE f.Name =
> a.Name): ERR=Got error 28 from storage engine
Google search: Mysql error 28
http://www.mysql.com/news-and-events/newsletter/2003-10/a0000000249.html
What is error 28 and how can I avoid it?
Using the command line tool perror you can find out, what the error 28
means.
> perror 28
Error code 28: No space left on device
If you get his error, you need to check all filesystems where MySQL
operates. It may be single filesystem or as we recommend you can have
datadir, tmpdir and log files split into dedicated filesystems. MySQL
often creates temporary tables for some queries - most of them are placed
in tmpdir, but some into database directory (e.g. ALTER TABLE). You must
ensure, that there is enough free disk space available for MySQL
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|