Intermittent problem with MySQL

dkjohnson

I have an intermittent problem that occurs with mySQL / PHP. Every now and then, for no reason I can see, a particular PHP script which accesses a mySQL db starts producing the following message:

Can't create/write to file '/tmp/root-tmp.02a19f143d3ef659/files/#sql87f_7_0.MYI' (Errcode: 13)

From the mySQL manual, this appears to be a permissioning error. However, everything else (using same db, web server) works fine. Finally, it will sometimes just 'go away' after rekicking the server a few times. Whazzup? Anyone else seen / solved this problem?

Thanks!

notionlogic

Just off the top of my head... it's not a disk space problem in the /tmp area is it?

Probably not but it's worth a try 🙂

dkjohnson

I checked available disk space; tmp is on a 250 MB partition with at least 60% free space; I don't think that's the problem.

It's odd, and it's really bugging me!

dkjohnson

Well, I think maybe I figured out what the problem was, though I'm not positive. I THINK the problem, although it's reporting as a mySQL error, is actually a PHP programmer problem.

I think the PHP script was consuming more memory than the max (8 M😎 specified in the php.ini file. I bumped up the memory, and now the problem appears to be solved. That wasn't the only thing I tried, but that was what worked. It makes sense as I was using a very large include file (~12000 lines of code) during development, and some queries return large data sets. Anyway, will update if something else pops up.