Tony,
That is my problem exactly. I have yet to find a resolution to it.
I periodically restart my SQL databases. I tried increasing open file limits
to obscene amounts (30,000+) and the problem just never goes away.
If you hear anything, I would be greatful of sharing. If I ever resolve it,
I will also let you know.
Jason
>
> -----Original Message-----
> From: tonyb@vegan.net [mailto:tonyb@vegan.net]
> Sent: Friday, April 09, 2004 7:18 PM
> To: sparc@openbsd.org
>
> Hi All,
>
> I've got a curious problem with running MySQL 4.0.17 and
> 4.0.18 on OpenBSD
> 3.4 SPARC64 on my Sun Ultra 5.
>
> MySQL compiles cleanly and starts up fine. When I run
> sql-bench, the included benchmarking utility, it completes a
> few tests successfully, then dies on error during the
> "create" test, and any subsequent tests fail.
>
> The errors are this:
>
> Can't execute command 'create table onek (unique1 int(5) NOT
> NULL,unique2
> int(4) NOT NULL,two int(4),four int(4),ten int(4),twenty
> int(4),hundred
> int(4) NOT NULL,thousand int(4),twothousand int(4),fivethous
> int(4),tenthous int(4),odd int(4),even int(4),stringu1
> char(16),stringu2
> char(16),string4 char(16),UNIQUE (unique1),UNIQUE
> (unique2),INDEX hundred1 (hundred))'
> Error: Can't create/write to file './test/onek.frm' (Errcode: 9)
>
> (The MySQL user has the ability to write to that directory with no
> problem)
>
> or this:
>
> Accessing tables
> Can't find file: './test/bench_60.frm' (errno: 9) at
> ./test-create line
> 137
>
> (The file is, in fact, there)
>
> Initially, I thought it might be a permissions problem. But
> the mysql users and groups are setup correctly, and the files
> are there. I even (in a very un-OpenBSD-esque manner)
> chmod'd the MySQL data directory to 777, yet still the
> problem persists. MySQL couldn't find files that were there
> in some cases and couldn't write to the directory in others.
>
> The file system has plenty of space and inodes available, so
> that isn't the issue either.
>
> Could this be an issue where there are too many files open?
> Or perhaps some odd MySQL bug with OpenBSD (these test for
> the same version of MySQL run fine under Solaris, Linux, and
> FreeBSD on my Ultra 5).
>
> I tried changing some sysctl variables, but the problem still
> persisted.
>
> Specifically:
>
> sysctl -w kern.maxfiles=11000
> sysctl -w kern.maxproc=6000
>
> I'm not familiar enough with OpenBSD sysctls to know if that
> would or wouldn't be effective. I boosted them off the prep
> list for this:
> http://bulk.fefe.de/scalability/
>
> Since the tests start OK, and several complete fine, that is
> what led me to believe it might be a too-many-files open issue.
>
> Google only provided on instance of someone having a similar problem:
>
> http://vbmysql.com/forums/index.php?t=tree&th=16988&rid=0
>
> I believe his problem is identical to mine.
>
> Any thoughts?
>
> Cheers,
>
> Tony
|