Ah, I see you found the solution... On 9/1/2006 12:47 AM, Arunav Mandal wrote: > Probally while creating database at first we should have used MAX_ROWS and > AVG_ROW_LENGTH options.
probably... any real-life values for AVG_ROW_LENGTH? I offer 111... Arno > > 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 -- IT-Service Lehmann [EMAIL PROTECTED] Arno Lehmann http://www.its-lehmann.de ------------------------------------------------------------------------- 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
