Using Bacula 2.0.3 with MySQL 4.1.20 on a CentOS 4.5 x86 director. Doing a full backup of a new file system from a 2.0.3/CentOS 4.5/x86_64 client gives:
28-Jun 12:33 dante-dir: No prior Full backup Job record found. 28-Jun 12:33 dante-dir: No prior or suitable Full backup found in catalog. Doing FULL backup. 28-Jun 12:33 dante-dir: Start Backup JobId 1800, Job=inca-10_data1.2007-06-28_12.33.36 28-Jun 12:33 dante-sd: Volume "Backup-0551" previously written, moving to end of data. 28-Jun 12:33 dante-dir: inca-10_data1.2007-06-28_12.33.36 Fatal error: sql_create.c:751 sql_create.c:751 insert INSERT INTO File (FileIndex,JobId,PathId,FilenameId,LStat,MD5) VALUES (1,1800,8249353,345586,'gR BrMoF IGk B RK P1 A A BAA A BGHokQ BGHnZi BGgaUz A A E','1B2M2Y8AsgTpgAmY7PhCfg') failed: The table 'File' is full 28-Jun 12:33 dante-dir: sql_create.c:751 INSERT INTO File (FileIndex,JobId,PathId,FilenameId,LStat,MD5) VALUES (1,1800,8249353,345586,'gR BrMoF IGk B RK P1 A A BAA A BGHokQ BGHnZi BGgaUz A A E','1B2M2Y8AsgTpgAmY7PhCfg') 28-Jun 12:33 dante-dir: inca-10_data1.2007-06-28_12.33.36 Fatal error: sql_create.c:753 Create db File record INSERT INTO File (FileIndex,JobId,PathId,FilenameId,LStat,MD5) VALUES (1,1800,8249353,345586,'gR BrMoF IGk B RK P1 A A BAA A BGHokQ BGHnZi BGgaUz A A E','1B2M2Y8AsgTpgAmY7PhCfg') failed. ERR=The table 'File' is full28-Jun 12:33 dante-dir: inca-10_data1.2007-06-28_12.33.36 Fatal error: catreq.c:476 Attribute create error. sql_create.c:753 Create db File record INSERT INTO File (FileInde ,JobId,PathId,FilenameId,LStat,MD5) VALUES (1,1800,8249353,345586,'gR BrMoF IGk B RK P1 A A BAA A BGHokQ BGHnZi BGgaUz A A E','1B2M2Y8AsgTpgAmY7PhCfg') failed. ERR=The table 'File' is full28-Jun 12:33 dante-dir: inca-10_data1.2007-06-28_12.33.36 Fatal error: sql_create.c:751 sql_create.c:751 insert INSERT INTO File (FileIndex,JobId,PathId,FilenameId,LStat,MD5) VALUES (2,1800,8249353,346071,'gR BrMtx IGk B RK P1 A A BAA A BGHnYa BGHnYa BGgaUz A A E','1B2M2Y8AsgTpgAmY7PhCfg') failed: The table 'File' is full ...and so on for several thousand entries. There are about 10 million files in this file system, but the initial error message as shown above appears right at the beginning of the backup (within one minute). A 'status dir' shows the backup as no longer running, but a 'status client' shows the backup as still active for another hour or so, when it disappears after apparently saving about 177,000 files. I've tried starting mysqld with the big-tables option, but that shouldn't be needed with this version of mysql, and in any event it doesn't make any difference. The /var/bacula filesystem has plenty of free space (about 8GB). The bacula mysql database is about 6GB in size, and there is about 9GB free on that file system. Que? -Steve ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
