Re: [Bacula-users] Re: The table 'File' is full
Hi ! Roger wrote: What will happend to the MyISAM file, will it be converted, or just left behind an I need to start my backups from scratch? I think the MyISAM files got converted and deleted. Actually i`m pretty sure about that :) Best regards, -- Daniel HoltkampRiege Software International GmbH System Administration Mollsfeld 10 40670 Meerbusch, Germany Phone: +49-2159-9148-41 mail: holtkamp [at] riege.comFax: +49-2159-9148-11 --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Re: The table 'File' is full
On Wed, Feb 01, 2006 at 05:06:38PM -, Dominic Marks wrote: > Perhaps InnoDB should be the default MySQL database format in the next > Bacula release, Kern? And if so, perhaps also consider enabling foreign key constraints? This would eliminate 90% of the work that dbcheck currently has to do... -- Frank Sweetser fs at wpi.edu | For every problem, there is a solution that WPI Network Engineer | is simple, elegant, and wrong. - HL Mencken GPG fingerprint = 6174 1257 129E 0D21 D8D4 E8A3 8E39 29E3 E2E8 8CEC --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Re: The table 'File' is full
Roger wrote: > mysql> select count(*) from File; > +--+ > | count(*) | > +--+ > | 47405618 | > +--+ > 1 row in set (0.00 sec) > Perhaps InnoDB should be the default MySQL database format in the next Bacula release, Kern? > Frank Sweetser wrote: >> On Wed, Feb 01, 2006 at 03:37:11PM +0100, Roger Kvam wrote: >> >>>27-Jan 00:45 alexandria-dir: LogicBackupAvr32.2006-01-27_00.05.10 Fatal >>>error: sql_create.c:732 sql_create.c:732 insert INSERT INTO File >>>(FileIndex,JobId,PathId,FilenameId,LStat,MD5) VALUES >>>(55527,829,2825202,2033976,'Bc sHVV IGk B Yc Y CwOuQ WvE BAA C4 BD0Kbs >>>BD0Kbs BD2MTW A A C','0') failed: >>>The table 'File' is full >> >> >> If you start up the mysql client, what does the query >> >> select count(*) from File; >> >> return? >> > > > > --- > This SF.net email is sponsored by: Splunk Inc. Do you grep through log > files > for problems? Stop! Download the new AJAX search engine that makes > searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 > ___ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users > -- Dominic Marks --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://sel.as-us.falkag.net/sel?cmd=lnk&kid3432&bid#0486&dat1642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Re: The table 'File' is full
What will happend to the MyISAM file, will it be converted, or just left behind an I need to start my backups from scratch? Roger Kvam Daniel Holtkamp wrote: Hi ! Roger Kvam wrote: My MySQL database is 6.8G, while the File.MYD is 4.0G You ran into a mysql-limit there. The File Table apparently uses MyISAM as storage engine and the max-limit there is 4 GB. Fire up mysql-administrator and change the storage engine to InnoDB then you`re fine. (On my system i changed all tables to InnoDB - just in case). Best regards, --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Re: The table 'File' is full
mysql> select count(*) from File; +--+ | count(*) | +--+ | 47405618 | +--+ 1 row in set (0.00 sec) Frank Sweetser wrote: On Wed, Feb 01, 2006 at 03:37:11PM +0100, Roger Kvam wrote: 27-Jan 00:45 alexandria-dir: LogicBackupAvr32.2006-01-27_00.05.10 Fatal error: sql_create.c:732 sql_create.c:732 insert INSERT INTO File (FileIndex,JobId,PathId,FilenameId,LStat,MD5) VALUES (55527,829,2825202,2033976,'Bc sHVV IGk B Yc Y CwOuQ WvE BAA C4 BD0Kbs BD0Kbs BD2MTW A A C','0') failed: The table 'File' is full If you start up the mysql client, what does the query select count(*) from File; return? --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
