Hello !
Daniel Holtkamp wrote:
13-Nov 04:23 backup-dir: Procars.2005-11-12_19.41.43 Fatal error:
sql_create.c:734 Create db File record INSERT INTO File
(FileIndex,JobId,PathId,FilenameId,LStat,MD5) VALUES
(1353546,678,49864,1041923,'DkB Bto/k IGw B JY JY A Ga BAA I BDdiPY
BC25yY
BDSPqH A A E','GUc1A4+aoRdfGC/Tv0hHF6+eM+M') failed. ERR=The table
'File' is
full
The table 'File' is full
MySQL ... dang, should`ve noted that ...
If it's MySQL, you have the option to tune the database settings.
Easily done with the graphical administration program, where you can
select the table you want to modify, set the expected row length and,
important in this case, you can also define the maximum number of rows
in the table.
Allright, i took a look at the Database.
Spotting the error was actually pretty easy. The "File" table has the
following details:
Rows: 35884993
Avg. row length: 115
Data length: 4294967276
Max data length: 4294967295
Index length: 1002577920
Data free: 142099940
I`ve reached the maximum Data length it seems ... mysql was unable to
extend the datafile - table full. The Mysql i installed uses the "MyISAM
Storage Engine" ... and i think the filesize-limit for those is 4GB
I`m gonna change the database to the "InnoDB Storage Engine" ... what do
you think, should i try to convert the old database into the new format
or should i just scrap the db completely and make it new ... this time
the right way.
I think i ran into this problem so quickly because we have countless
numbers of small files to backup. And it startet appearing after i put
our Solaris machine into the backup which alone has like 5 million files.
Is something like this mentioned in the documentation btw ? I figure
other users could run into this problem.
--
Daniel Holtkamp Riege Software International GmbH
System Administration Mollsfeld 10
40670 Meerbusch, Germany Phone: +49-2159-9148-41
mail: holtkamp [at] riege.com Fax: +49-2159-9148-11
--------------------------------------------------------------------
-------------------------------------------------------
SF.Net email is sponsored by:
Tame your development challenges with Apache's Geronimo App Server. Download
it for free - -and be entered to win a 42" plasma tv or your very own
Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
