Hi,
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,
# 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,
Regards,
Sac
-----Original Message-----
From: John Drescher [mailto:dresche...@gmail.com]
Sent: Montag, 8. Juni 2009 12:33
To: Holikar, Sachin (ext)
Cc: James Harper; bacula-users@lists.sourceforge.net
Subject: Re: [Bacula-users] Bacula Fatal Error
On 6/8/09, Holikar, Sachin (ext) <sachin.holikar....@siemens.com> wrote:
>
> Thanks Mr. Harper for the reply. Me too found that this happenes sometimes
> when the mysql file tbl_name MAX_ROWS value reaches its limits.
> We shall increase this limit and see if the error persists.
> One point you mentioned about spooling to the same volume. The details of
> the spool are ,
>
> Maximum Spool Size = 8G
> Maximum Job Spool Size = 8G
> SpoolDirectory = /var/backup;
>
> But currently /var partition has 13 GB free space. Isnt it enough for our
> backup? What if we disable the spooling. Will it help?
> I would like to know how you pointed out "You are spooling to the same
> volume as your database" ??
>
Do not disable spooling. If you are running out of space reduce its
size to something like 4GB.
Also could you answer the question about rows in the file table? To me
this is most likely 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
