Discuz!出现问题
昨天晚上登录论坛,出现如下症状如下:
Discuz! info: MySQL Query Error
User: cat
Time: 2008-10-23 3:38pm
Script: /index.php
SQL: SELECT attach.aid, attach.attachment, t.tid, t.fid, t.subject FROM [Table]attachments attach LEFT JOIN [Table]threads t ON t.tid=attach.tid WHERE attach.readperm='0' AND t.displayorder>='0' AND attach.filetype like 'image/%g%' GROUP BY attach.tid ORDER BY rand() DESC LIMIT 0, 50
Error: Error writing file '/tmp/MYGjPsWH' (Errcode: 28)
Errno.: 3
Similar error report has beed dispatched to administrator before.
打开页面,头部出现了,中间的某个插件部分就出不来了。开始判断是插件问题吧:更新缓存试一试。不成功。把插件首页N格(缓存)禁止了。
首页是出来了,但是刷新几下就出现Too many connections的错误。
又到后台看看错误记录,终于发现问题了,采集机器人过来了,有如下几个IP的记录特别多。
58.60.13.231
58.60.14.231
58.60.14.241
121.14.96.153
121.14.96.152
121.14.75.53
58.60.14.236
禁止IP吧。把后台什么该刷新的再刷新一次。
还是莫名奇妙的那几个IP可以混上来的,郁闷ing,RP爆发中。
MySQL 121.14.96.152|121.14.96.152 08-10-23 16:00 index.php : Too many connections
记下这几个IP,巨恐怖的采集服务器。

晕,同遇...
直接
max_connections= 1000
wait_timeout = 5