Probally while creating database at first we should have used MAX_ROWS and AVG_ROW_LENGTH options.
http://jeremy.zawodny.com/blog/archives/000796.html Arunav. ----- Original Message ----- From: "Arunav Mandal" <[EMAIL PROTECTED]> To: "Arunav Mandal" <[EMAIL PROTECTED]>; <bacula-users@lists.sourceforge.net> Sent: Friday, September 01, 2006 12:44 AM Subject: Re: [Bacula-users] Mysql tables 'File' is full new mail >I am altering the table now with > > alter table File max_rows = 200000000000; > > Some backups failed I guess other old backups are safe. > > Arunav. > > ----- Original Message ----- > From: "Arunav Mandal" <[EMAIL PROTECTED]> > To: <bacula-users@lists.sourceforge.net> > Sent: Friday, September 01, 2006 12:34 AM > Subject: [Bacula-users] Mysql tables 'File' is full new mail > > >>I am getting some errors now like this >> >> 01-Sep 00:26 bacula-dir: sql_create.c:732 INSERT INTO File >> (FileIndex,JobId,PathId,FilenameId,LStat,MD5) VALUES (3,179,14,34,'MC EGi >> EHJ C E H A BAA BAA I BE9gKM BE91M9 BE91M9 A A C','0') >> 01-Sep 00:26 bacula-dir: backup-pip.2006-09-01_00.24.02 Fatal error: >> sql_create.c:734 Create db File record INSERT INTO File >> (FileIndex,JobId,PathId,FilenameId,LStat,MD5) VALUES (3,179,14,34,'MC EGi >> EHJ C E H A BAA BAA I BE9gKM BE91M9 BE91M9 A A C','0') failed. ERR=The >> table >> 'File' is full >> The table 'File' is full >> >> The Database size is only 4.22GB. >> >> -rw-rw---- 1 mysql mysql 4.0G Aug 31 20:37 File.MYD >> >> Is this the reason? I am running 2.6.9-42.0.2.ELsmp kernel. >> >> >> Arunav. >> >> >> ------------------------------------------------------------------------- >> Using Tomcat but need to do more? Need to support web services, security? >> Get stuff done quickly with pre-integrated technology to make your job >> easier >> Download IBM WebSphere Application Server v.1.0.1 based on Apache >> Geronimo >> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 >> _______________________________________________ >> Bacula-users mailing list >> Bacula-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/bacula-users >> > > ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
