SQL server was down on one of my boxes today, so I naturally restart it and get:


[root@xxx root]# service mysqld stop
Stopping MySQL: [FAILED]
[root@xxx root]# service mysqld status
mysqld (pid 30572 30467 30361 30357 30162 27065 26449 23953 22312 21738 21296 21019 20901 20601 20018 19112 19004 18007 18006 18005 18003) is running...
[root@xxx root]# service mysqld start
Starting MySQL: [ OK ]


(It seems I have to kill all the PIDs somehow to kill the server. I can't just stop the SQL over the command line. Then it says 'subsys locked' when I check the status of MySQL. This is where I rebooted it)


[root@gold root]# service mysqld status
mysqld (pid 30572 30467 30361 30357 30162 27065 26449 23953 22312 21738 21296 21019 20901 20601 20018 19112 19004 18007 18006 18005 18003) is running...
[root@gold root]# killall mysqld
[root@gold root]# service mysqld status
mysqld (pid 5381 21738 19004 18006 18005 18003) is running...
[root@gold root]# killall mysqld
[root@gold root]# service mysqld status
mysqld (pid 5381 21738 18006 18005 18003) is running...
[root@gold root]# kill -9 21738
[root@gold root]# service mysqld status
mysqld dead but subsys locked



mysql> show databases;
+-------------+
| Database |
+-------------+
| something1 |
| something2 |
| mysql |
| steel |
+-------------+
4 rows in set (0.00 sec)

mysql> use steel
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Didn't find any fields in table 'phpbb_posts_text'
Database changed
mysql>



mysql> CREATE TABLE bar (m INT);
ERROR 3: Error writing file './mohtalimdb/bar.frm' (Errcode: 28)


How would I go about fixing this problem? I've restarted SQL as well as rebooted the server. We're now at the bottom post where the user can do SELECT, but not CREATE and INSERT a table.

jt

try using check and recover on the affected tables..