On 3/2/2010 6:39 PM, Richard Hartmann wrote:
> Hi all,
>
> how many backups can I start at once without causing errors?
> Even with "only" 15 backups starting at once, I get one of the two
> failures below:
>
> Fatal error: sql_create.c:784 Lock Path table Query failed: LOCK
> TABLES Path write, batch write, Path as p write: ERR=Can't find file:
> './bacula/Path.frm' (errno: 13)
> Fatal error: sql_create.c:801 Lock Filename table Query failed: LOCK
> TABLES Filename write, batch write, Filename as f write: ERR=Can't
> find file: './bacula/Filename.frm' (errno: 13)
>
>    
That's MySQL complaining about not finding table files.  Check its 
configuration for the value of "open_files_limit".  Increase the value 
if it's small.  If it looks large enough, check your system 
configuration for restrictions on the number of open files.

Note that MySQL under Windows before 6.x can only handle 2048 open 
files, period, as that's the limit of its POSIX implementation (6.x uses 
native Windows API's to increase that limit).


------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users