Hello,

Before going ahead with this step, would like to understand ....how reducing 
the spool size will help?  


Thanks,
Sac
-----Original Message-----
From: John Drescher [mailto:drescherjm AT gmail DOT com] 
Sent: Montag, 8. Juni 2009 13:02
To: Holikar, Sachin (ext); bacula-users
Subject: Re: [Bacula-users] Bacula Fatal Error

> Yes, we will not disable spooling but you are asking to reduce the size to 
> 4GB of what ??
>
> And I guess this is what you require,
>

Is this the same machine that has the storage? If so reduce the

 Maximum Spool Size = 8G
 Maximum Job Spool Size = 8G

to

 Maximum Spool Size = 4G
 Maximum Job Spool Size = 4G

and see if the problem goes away.


>
> # mysql
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 3930 to server version: 4.1.22-standard
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
> mysql> show table status from bacula like 'File';
> +------+--------+---------+------------+----------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-------------------+----------+----------------+---------+
> | Name | Engine | Version | Row_format | Rows     | Avg_row_length | 
> Data_length | Max_data_length | Index_length | Data_free | Auto_increment | 
> Create_time         | Update_time         | Check_time          | Collation   
>       | Checksum | Create_options | Comment |
> +------+--------+---------+------------+----------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-------------------+----------+----------------+---------+
> | File | MyISAM |       9 | Dynamic    | 39645618 |            108 | 
>  4294967228 |      4294967295 |   1189547008 |         0 |       76130637 | 
> 2008-04-10 15:57:33 | 2009-06-07 10:49:21 | 2008-04-11 22:14:36 | 
> latin1_swedish_ci |     NULL |                |         |
> +------+--------+---------+------------+----------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-------------------+----------+----------------+---------+
> 1 row in set (0.00 sec)
>
>
> Please let me know if you need anymore details,
>

You have 39645618 rows which is definitely less than 2 ^32 rows so
this is not the problem.

John

------------------------------------------------------------------------------
OpenSolaris 2009.06 is a cutting edge operating system for enterprises 
looking to deploy the next generation of Solaris that includes the latest 
innovations from Sun and the OpenSource community. Download a copy and 
enjoy capabilities such as Networking, Storage and Virtualization. 
Go to: http://p.sf.net/sfu/opensolaris-get
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users