On Tue, Feb 05, 2002 at 07:59:20AM -0700, Randy Arabie wrote: > On Mon, 4 Feb 2002, Randy Arabie wrote: > > > Right. Like this: > > > > mysql -u someuser -p -D somedatabase < ./data.sql > > > > No. I didn't raise the shell limits, I rose the kernel maxfiles and > > the mysqld process proc.pid.rlimit.descriptors.soft limit. > > > > I'll try the shell tonight. > > Summary of Last Nights activities: > > 1) Switched back to the GENERIC kernel. > 2) Edit /etc/sysctl.conf; added a line kern.maxfiles=5000 > 3) Reboot > 4) Bump hard and soft proc.[mysqld_pid].rlimit.descriptors up to 2500. > 5) Bump hard and soft proc.[shell_pid].rlimit.descriptors up to 2500. > 6) Attempt to load the data, failure once again, same error message: > > "ERROR 1017 at line 445: Can't find file: './geeklog/userinfo.frm' (errno: 23)" > > 7) fstat | wc -l shows 203 open files (done immediately following step 6 above. > 8) fstat | grep mysqld | wc -l shows mysqld only has 64 open files. > 9) The database only has 38 tables, and the datafile I'm trying to load is only > 37 KB. > > Someone suggested a few days ago that perhaps the error reported is not accurate. >How would > I test that? > > My 'gut' says this is probably an easily resolved configuration issue, but I'm >stumped on > where to go next.
Now I would try to ktrace both mysqld and the mysql loading the tables ... -- Manuel Bouyer, LIP6, Universite Paris VI. [EMAIL PROTECTED] -- --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php