NYCPHP Meetup

[Glenn]

I don't have a definitive answer but I got curious and found this.

http://forums.admon.org/databases/8130-error-1018-hy000-cant-read-dir-errno-24-a.html

So maybe there is an issue where files are not closing properly.
...and restarting mysql reset the open files counter?

or something like that?

HTH,

Glenn

On Jan 3, 2011, at 10:15 AM, Nicholas Hart wrote:

> I am trying to configure mysql to use a different datadir than  
> default in order to move this to a larger volume.  I have copied all  
> mysql data from /var/lib/mysql to my new volume and ran both chown - 
> R mysql:mysql * and chmod -R 660 *  in order to setup correct  
> ownership and rights for the data.  It was working for a few days  
> until today upon going into mysql and typing show databases, I  
> receive the following error:  ERROR 1018 (HY000): Can't read dir of  
> '.' (errno: 24).  I quickly double checked my rights and found them  
> to be correct, then I restarted mysqld and this has fixed it for now.
>
> Has anyone else run into this problem?  I am concerned that it will  
> happen again if the actual cause is not corrected.  I am running the  
> latest Fedora on new quad core Dell hardware with 24GB RAM and 1.7TB  
> of disk.   Any help and/or suggestions much appreciated.  Thanks.
>
> Nick
> _______________________________________________
> New York PHP Users Group Community Talk Mailing List
> http://lists.nyphp.org/mailman/listinfo/talk
>
> http://www.nyphp.org/Show-Participation