> 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" ?? > Thanks in adv.
If /var/backup and /var/mysql (or wherever your mysql database are stored) are on the same volume/partition, and the spool size is unlimited, then spooling will happen until the volume fills up. You appear to have specified a limit of 8G for your spool size and if you have 13G free then I guess this isn't your problem. James ------------------------------------------------------------------------------ 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
