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执行查询没有问题,但程序中有时候会出现这种问题,
是什么原因呢?谢谢~~~
解决方案 »
- 这样生成gif图片不动-PHP
- 请教一个关于26个字母枚举的问题
- Fatal error: Call to undefined function pg_connect()
- Eclipse下php保存后没有实时的预览
- php操作sqlserver数据库问题
- OJS开放期刊系统的首页怎么修改
- PHP下查询MySQL.返回结果集的数据类型问题
- eclipse php
- 关于应聘PHP程序员问题
- 挑战极限:有字符串$string=$string = "aa='bb'; xxxx='s汉=字js\'ls\'f;f'; xxx=940; df3243_3495='sdk'";要求用正则表达式解析成array(
- 求 短信网址 插件的例子写法,内附详细资料……
- 当表单提交后,再次返回改页面Select中的Option就被清空了
Error 12 = Cannot allocate memory 重起下服务器或者重起下mysql可能会好
但是以后可能仍会出现
最好是修改服务器配置文件让系统分配给单个进程的内存大点,当然首先机器的内存得够,不过具体怎么改不清楚
http://forums.mysql.com/read.php?21,71414,71414