Discuz! info: MySQL Query ErrorUser: dude
Time: 2007-3-18 8:15pm
Script: /pic.phpSQL: SELECT attach.aid, attach.attachment, t.tid, t.fid, t.subject FROM cdb_attachments attach LEFT JOIN cdb_threads t ON t.tid=attach.tid WHERE attach.readperm='0' AND displayorder>='0' AND filetype='image/pjpeg' AND t.fid IN (14,15,16,17,18,20,21,22,23,24,25,26,27,28,29,30,31,32,34,35,36,37,39,40,41,42,43,44,45,46,47,48,49,52,53,54,55,56,57,58,59,61,62,63) GROUP BY attach.tid ORDER BY attach.dateline DESC LIMIT 100
Error: Got error 12 from storage engine
Errno.: 1030
直接到mysql shell,或者phpmyadmin执行查询没有问题,但程序中有时候会出现这种问题,
是什么原因呢?谢谢~~~
Time: 2007-3-18 8:15pm
Script: /pic.phpSQL: SELECT attach.aid, attach.attachment, t.tid, t.fid, t.subject FROM cdb_attachments attach LEFT JOIN cdb_threads t ON t.tid=attach.tid WHERE attach.readperm='0' AND displayorder>='0' AND filetype='image/pjpeg' AND t.fid IN (14,15,16,17,18,20,21,22,23,24,25,26,27,28,29,30,31,32,34,35,36,37,39,40,41,42,43,44,45,46,47,48,49,52,53,54,55,56,57,58,59,61,62,63) GROUP BY attach.tid ORDER BY attach.dateline DESC LIMIT 100
Error: Got error 12 from storage engine
Errno.: 1030
直接到mysql shell,或者phpmyadmin执行查询没有问题,但程序中有时候会出现这种问题,
是什么原因呢?谢谢~~~
Error 12 = Cannot allocate memory 重起下服务器或者重起下mysql可能会好
但是以后可能仍会出现
最好是修改服务器配置文件让系统分配给单个进程的内存大点,当然首先机器的内存得够,不过具体怎么改不清楚
http://forums.mysql.com/read.php?21,71414,71414