On Sat, 2 Feb 2002, Manuel Bouyer wrote: > On Sat, Feb 02, 2002 at 08:23:49AM -0700, Randy Arabie wrote: > > Environment: AlphaStation 255 w/ 64 MB RAM > > NetBSD 1.5.2 - custom kernel > > MySQL 3.23.47 > > > > I'm trying to load data into tables in a mysql database. When I feed the > > load script into the database it fails about 3/4 through. Error follows: > > > > <SNIP> > > ERROR 1105 at line 11: File ./geeklog/userinfo.MYD not found (Errcode: 23) > > </SNIP> > > 23 is "Too many open files in system" > > Maybe the whole system has too many open files ? > The limit is kern.maxfiles and you can count them with 'fstat'.
The output of "# fstat | wc -l" is 213. kern.maxfiles = 1772 > You may also want to ktrace mysqld while trying to load the > database to get more details. Tried this. I'm not much on analyzing a kernel trace, but I could see from the trace that the file was opened. And, it appears that some of the data was inserted. However, I can't check via the database. When I log in and try "desc tablename" I get the same Errcode: 23 for the corresponding mysql *.MYD file. This happens with a number of the tables in the database. -- Cheers! Randy --------------------------------------------------------------------- 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