Re: [Bacula-users] The table 'File' is full

2007-06-28 Thread Steve Thompson
On Thu, 28 Jun 2007, David Romerstein wrote:

> On Thu, 28 Jun 2007, Steve Thompson wrote:
>
>> 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
>
>> 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.
>
> This is documented in the user manual:
>
> http://www.bacula.org/dev-manual/Catalog_Maintenance.html#SECTION00244

How I missed that I do not know. Thanks!

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


Re: [Bacula-users] The table 'File' is full

2007-06-28 Thread David Romerstein
On Thu, 28 Jun 2007, Steve Thompson wrote:

> 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

> 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.

This is documented in the user manual:

http://www.bacula.org/dev-manual/Catalog_Maintenance.html#SECTION00244

-- D

-
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


Re: [Bacula-users] The table 'File' is full

2007-06-28 Thread Jorj Bauer
> The table 'File' is full
> 
> 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?

See

http://dev.mysql.com/doc/refman/4.1/en/full-table.html

I'd guess it's the "max_rows" / "avg_row_length" problem.

-- Jorj


pgp3dJhuMjd0Q.pgp
Description: PGP signature
-
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


[Bacula-users] The table 'File' is full

2007-06-28 Thread Steve Thompson
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


Re: [Bacula-users] The Table "file" is full!?

2006-06-26 Thread Frank Sweetser
On Mon, Jun 26, 2006 at 05:35:19PM +0200, Bernhard Suttner wrote:
> Helo,
> 
> I have the following error:
> 
> 26-Jun 17:31 Backup-Director: SkipperBackup.2006-06-26_06.00.01 Fatal error: 
> sql_create.c:734 Create db File record INSERT INTO File 
> (FileIndex,JobId,PathId,FilenameId,LStat,MD5) VALUES 
> (486853,1161,8383,10971,'gG 4IL IGk B A A A BkA BAA Q BEjTBI 6XZCc BDh0H3 A A 
> C','N//8UzJqZw/npXU/0G/XkC') failed. ERR=The table 'File' is full
> The table 'File' is full
> 
> i am using bacula 1.38.3. Any Idea?

Yep.

http://paramount.ind.wpi.edu/wiki/doku.php?id=faq#why_does_mysql_say_my_file_table_is_full

-- 
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

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


[Bacula-users] The Table "file" is full!?

2006-06-26 Thread Bernhard Suttner
Helo,

I have the following error:

26-Jun 17:31 Backup-Director: SkipperBackup.2006-06-26_06.00.01 Fatal error: 
sql_create.c:734 Create db File record INSERT INTO File 
(FileIndex,JobId,PathId,FilenameId,LStat,MD5) VALUES 
(486853,1161,8383,10971,'gG 4IL IGk B A A A BkA BAA Q BEjTBI 6XZCc BDh0H3 A A 
C','N//8UzJqZw/npXU/0G/XkC') failed. ERR=The table 'File' is full
The table 'File' is full

i am using bacula 1.38.3. Any Idea?




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


Re: [Bacula-users] The table 'File' is full

2006-02-02 Thread Alan Brown

On Wed, 1 Feb 2006, 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.


Only by default. It _can_ be increased and this is documented, plus has 
been discussed here/


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).


One some vendor-supplied mysql installs (ie, no fiddling allowed). Innodb 
isn't there (Suse!)


AB


---
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] The table 'File' is full

2006-02-02 Thread Sebastian Stark


Am 02.02.2006 um 18:31 schrieb Ryan Sizemore:


So it would *seem* that using this option (increasing max_rows) is a
better option that converting to InnoDB, since MyISAM is faster for
inserting. Does this make sense?


I really don't know, we chose this way because it seemed the least  
painful. No changes to configuration files necesssary, nothing new to  
learn, etc.


Like: "don't try to solve a problem by solving a harder one" :)


-Sebastian


Ryan

Sebastian Stark wrote:



This worked for me when I hit the limit:

  http://jeremy.zawodny.com/blog/archives/000796.html

Be sure to have a recent dump in case anything goes wrong.


-Sebastian

On Feb 1, 2006, at 3:37 PM, 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


I`m running bacula 1.38.2, with standard install besides som
alteration in the chio.changer scripts, on a FreeBSD 6.0-RELEASE

My MySQL database is 6.8G, while the File.MYD is 4.0G
My backup with most files are like this:

 FD Files Written:   3,876,210
 SD Files Written:   3,876,210
 FD Bytes Written:   256,133,597,826
 SD Bytes Written:   256,774,755,561

And i got ca 10 similar jobs, I have been running since 9/des-2005
How could this happend?

Roger Kvam




---
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] The table 'File' is full

2006-02-02 Thread Ryan Sizemore
So it would *seem* that using this option (increasing max_rows) is a
better option that converting to InnoDB, since MyISAM is faster for
inserting. Does this make sense?

Ryan

Sebastian Stark wrote:

>
> This worked for me when I hit the limit:
>
>   http://jeremy.zawodny.com/blog/archives/000796.html
>
> Be sure to have a recent dump in case anything goes wrong.
>
>
> -Sebastian
>
> On Feb 1, 2006, at 3:37 PM, 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
>>
>>
>> I`m running bacula 1.38.2, with standard install besides som 
>> alteration in the chio.changer scripts, on a FreeBSD 6.0-RELEASE
>>
>> My MySQL database is 6.8G, while the File.MYD is 4.0G
>> My backup with most files are like this:
>>
>>  FD Files Written:   3,876,210
>>  SD Files Written:   3,876,210
>>  FD Bytes Written:   256,133,597,826
>>  SD Bytes Written:   256,774,755,561
>>
>> And i got ca 10 similar jobs, I have been running since 9/des-2005
>> How could this happend?
>>
>> Roger Kvam
>>
>>
>>
>> ---
>> 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
>
>
>
>
> ---
> 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




---
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] The table 'File' is full

2006-02-02 Thread Daniel Holtkamp

Hi !

Marc Cousin wrote:

is there no performance impact ? innodb is not that good at inserting data ...


Well, i didn`t notice any different behaviour but the machine running 
bacula+mysql is pretty fast.


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] The table 'File' is full

2006-02-02 Thread Sebastian Stark


This worked for me when I hit the limit:

  http://jeremy.zawodny.com/blog/archives/000796.html

Be sure to have a recent dump in case anything goes wrong.


-Sebastian

On Feb 1, 2006, at 3:37 PM, 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


I`m running bacula 1.38.2, with standard install besides som  
alteration in the chio.changer scripts, on a FreeBSD 6.0-RELEASE


My MySQL database is 6.8G, while the File.MYD is 4.0G
My backup with most files are like this:

 FD Files Written:   3,876,210
 SD Files Written:   3,876,210
 FD Bytes Written:   256,133,597,826
 SD Bytes Written:   256,774,755,561

And i got ca 10 similar jobs, I have been running since 9/des-2005
How could this happend?

Roger Kvam



---
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




---
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] The table 'File' is full

2006-02-01 Thread Marc Cousin
is there no performance impact ? innodb is not that good at inserting data ...

Le Mercredi 01 Février 2006 16:08, Daniel Holtkamp a écrit :
> 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&kid3432&bid#0486&dat1642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] The table 'File' is full

2006-02-01 Thread Daniel Holtkamp

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,
--
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


[Bacula-users] The table 'File' is full

2006-02-01 Thread Roger Kvam

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


I`m running bacula 1.38.2, with standard install besides som alteration in the 
chio.changer scripts, on a FreeBSD 6.0-RELEASE

My MySQL database is 6.8G, while the File.MYD is 4.0G
My backup with most files are like this:

 FD Files Written:   3,876,210
 SD Files Written:   3,876,210
 FD Bytes Written:   256,133,597,826
 SD Bytes Written:   256,774,755,561

And i got ca 10 similar jobs, I have been running since 9/des-2005
How could this happend?

Roger Kvam



---
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] The table 'File' is full

2006-02-01 Thread Frank Sweetser
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?

-- 
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