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:dresche...@gmail.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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
