求救：数据库反复无常：MySQL server error report

2016-07-07 15:18 来源：www.chinab4c.com 作者：ecshop专家



原来用这个空间，2.61版本。三天四次提示如下http://kinghon.8.bname.us/（原来该空间网址好像被举报过，提示有毒，但没关系，是指向我的网站，人格担保）那个空间管理员每次都是维修一小会就好了，但一会儿就会重新出现问题。
我迫不得已，重新换了空间http://kinghon.com/，又重新安装了2.72，可是当每天第一次打开就会出现如下样子。那个空间管理员也是调一下就好，明天还会这样子，找不到问题症结彻底解决，希望高手能帮忙看下，谢谢。（网站模板稍微修改过）。

MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => SELECT a.ad_id, a.position_id, a.media_type, a.ad_link, a.ad_code, a.ad_name, p.ad_width, p.ad_height, p.position_style, RAND() AS rnd FROM `a0613231210`.`ecs_ad` AS a LEFT JOIN `a0613231210`.`ecs_ad_position` AS p ON a.position_id = p.position_id WHERE enabled = 1 AND a.position_id = '2' AND start_time <= '1308871849' AND end_time >= '1308871849' ORDER BY rnd LIMIT 1 ) [2] => Array ( [error] => Can't create/write to file '#sql_5d0_0.MYD' (Errcode: 17) ) [3] => Array ( [errno] => 1 ) )

回答：
服务器数据库不稳定造成的。可能和补丁有关

不知道如何解决

现在变成这样了，首页不能打开http://www.kinghon.com/，其它页面畅通无阻
MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => SELECT a.ad_id, a.position_id, a.media_type, a.ad_link, a.ad_code, a.ad_name, p.ad_width, p.ad_height, p.position_style, RAND() AS rnd FROM `a0613231210`.`ecs_ad` AS a LEFT JOIN `a0613231210`.`ecs_ad_position` AS p ON a.position_id = p.position_id WHERE enabled = 1 AND a.position_id = '2' AND start_time <= '1309043809' AND end_time >= '1309043809' ORDER BY rnd LIMIT 1 ) [2] => Array ( [error] => Can't create/write to file '#sql_5d8_0.MYD' (Errcode: 17) ) [3] => Array ( [errno] => 1 ) )


其它页面http://www.kinghon.com/article.php?id=9