Hello,
On Monday 14 November 2005 15:42, Daniel Holtkamp wrote:
> 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.
Yes, 40+GB is really big. I consider anything over 1GB big.
>
> Is something like this mentioned in the documentation btw ? I figure
> other users could run into this problem.
The problem of running into table or database size limits is not discussed in
the manual, but there is a bit of information on sizing your DB in the
chapter(s) dealing with MySQL.
--
Best regards,
Kern
(">
/\
V_V
-------------------------------------------------------
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
