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