On Fri, 13 Jul 2007, Marcos Laufer wrote: > I am having a very strange problem on a 3.9 , suddenly i can't access any > table > on the databases. I have around 100 databases on this server and can't access > not even one. This is a production server and i am in an urge to solve it, if > anyone > can help i would appreciate it: > > # mysql mysql -p > Enter password: > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 303342 to server version: 5.0.18 > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > mysql> show tables; > ERROR 1018 (HY000): Can't read dir of './mysql/' (errno: 9) > mysql> > > > I have backups of all databases, including mysql database which i think is the > one > broken , how can i restore it ? > > Thanks for your help
You are running out of file descriptors. Search the archives for answers. -Otto