mysql general error_SQLSTATE[HY000]: General error:

在后台操作的时候，偶尔出现这个 问题，请问是咋回事啊？

我的这个目录C:\Users\41639\AppData\Local\Temp\ 是完全可写的

[10501] PDOException in Connection.php line 388

SQLSTATE[HY000]: General error: 1036 Table 'C:\Users\41639\AppData\Local\Temp#sql2c7c_9_2' is read only

$this->PDOStatement->execute();

// 调试结束

$this->debug(false);

// 返回结果集

return $this->getResult($pdo, $procedure);

} catch (\PDOException $e) {

if ($this->isBreak($e)) {

return $this->close()->query($sql, $bind, $master, $pdo);

}

throw new PDOException($e, $this->config, $this->getLastsql());

} catch (\Exception $e) {

if ($this->isBreak($e)) {

return $this->close()->query($sql, $bind, $master, $pdo);

}

throw $e;

}

}

/**Call Stack

in Connection.php line 388

at Connection->query('SHOW COLUMNS FROM `f...', [], false, true) in Mysql.php line 65

at Mysql->getFields('fa_auth_rule') in Query.php line 1749

at Query->getTableInfo('fa_auth_rule', 'type') in Query.php line 1797

at Query->getFieldsType('fa_auth_rule') in Query.php line 1803

at Query->getFieldsBind('fa_auth_rule') in Builder.php line 256

at Builder->buildWhere(['AND' => ['status' => 'normal']], ['multi' => ['AND' => ['status' => ['normal']]], 'where' => ['AND' => ['status' => 'normal']], 'field' => ['id', 'pid', 'condition', ...], ...]) in Builder.php line 226

at Builder->parseWhere(['AND' => ['status' => 'normal']], ['multi' => ['AND' => ['status' => ['normal']]], 'where' => ['AND' => ['status' => 'normal']], 'field' => ['id', 'pid', 'condition', ...], ...]) in Builder.php line 690

at Builder->select(['multi' => ['AND' => ['status' => ['normal']]], 'where' => ['AND' => ['status' => 'normal']], 'field' => ['id', 'pid', 'condition', ...], ...]) in Query.php line 2331

at Query->select() in Auth.php line 220

at Auth->getRuleList(1) in Auth.php line 207

at Auth->getRuleList(1) in Auth.php line 104

at Auth->check('auth/rule/edit', 1, 'or', 'url') in Auth.php line 124

at Auth->check('auth/rule/edit') in Backend.php line 121

at Backend->_initialize() in Rule.php line 24

at Rule->_initialize() in Controller.php line 57

at Controller->__construct(object(Request))

at ReflectionClass->newInstanceArgs([object(Request)]) in App.php line 216

at App::invokeClass('app\admin\controller...') in Loader.php line 400

at Loader::controller('auth.rule', 'controller', false, 'Error') in App.php line 388

at App::module(['admin', 'auth.rule', 'edit'], ['app_host' => '', 'app_debug' => true, 'app_trace' => false, ...], null) in App.php line 296

at App::exec(['type' => 'module', 'module' => ['admin', 'auth.rule', 'edit']], ['app_host' => '', 'app_debug' => true, 'app_trace' => false, ...]) in App.php line 124

at App::run() in start.php line 18

at require('C:\phpStudy\WWW\fa\t...') in index.php line 24

Exception Datas

PDO Error Info

SQLSTATE HY000

Driver Error Code 1036

Driver Error Message Table 'C:\Users\41639\AppData\Local\Temp#sql2c7c_9_2' is read only

Database Status

Error Code 10501

Error Message SQLSTATE[HY000]: General error: 1036 Table 'C:\Users\41639\AppData\Local\Temp#sql2c7c_9_2' is read only

Error SQL SHOW COLUMNS FROM fa_auth_rule

Database Config

type mysql

hostname localhost

database fastadmin

hostport

dsn

params []

charset utf8

prefix fa_

debug true

deploy 0

rw_separate false

master_num 1

slave_no

fields_strict true

result_type 2

resultset_type array

auto_timestamp false

datetime_format false

sql_explain false

builder

query \think\db\Query

break_reconnect false

Environment Variables

GET Data

dialog 1

POST Dataempty

Filesempty

Cookies

PHPSESSID qpt9v1mofakijiprcb92k75su3

Session

think { "admin": { "id": 1, "username": "admin", "nickname": "Admin", "password": "59457eba29e45203e58711b88fca3b3b", "salt": "73a0b5", "avatar": "\/assets\/img\/avatar.png", "email": "admin@admin.com", "loginfailure": 0, "logintime": 1513260104, "createtime": 1492186163, "updatetime": 1513260104, "token": "bc43a2e9-d4b1-4329-a77d-86affad3331e", "status": "normal" } }

Server/Request Data

PATH C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\GtkSharp\2.12\bin;C:\Sqlite;C:\Program Files (x86)\NVIDIA Corporation\PhysX\Common;C:\phpStudy\php\php-5.6.27-nts;C:\Users\41639\AppData\Local\Microsoft\WindowsApps;C:\Sqlite;

SYSTEMROOT C:\Windows

COMSPEC C:\Windows\system32\cmd.exe

PATHEXT .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC

WINDIR C:\Windows

PHP_FCGI_MAX_REQUESTS 1000

PHPRC C:/phpStudy/php/php-5.6.27-nts/

FCGI_SHUTDOWN_EVENT 2184

SCRIPT_NAME /fa/public/index.php

REQUEST_URI /fa/public/admin/auth/rule/edit/ids/188?dialog=1

QUERY_STRING dialog=1

REQUEST_METHOD GET

SERVER_PROTOCOL HTTP/1.1

GATEWAY_INTERFACE CGI/1.1

REDIRECT_QUERY_STRING dialog=1

REDIRECT_URL /fa/public/admin/auth/rule/edit/ids/188

REMOTE_PORT 58068

SCRIPT_FILENAME C:/phpStudy/WWW/fa/public/index.php

SERVER_ADMIN admin@phpStudy.net

CONTEXT_DOCUMENT_ROOT C:/phpStudy/WWW

CONTEXT_PREFIX

REQUEST_SCHEME http

DOCUMENT_ROOT C:/phpStudy/WWW

REMOTE_ADDR ::1

SERVER_PORT 80

SERVER_ADDR ::1

SERVER_NAME localhost

SERVER_SOFTWARE Apache/2.4.23 (Win32) OpenSSL/1.0.2j mod_fcgid/2.3.9

SERVER_SIGNATURE

SystemRoot C:\Windows

HTTP_COOKIE PHPSESSID=qpt9v1mofakijiprcb92k75su3

HTTP_ACCEPT_LANGUAGE zh-CN,zh;q=0.9

HTTP_ACCEPT_ENCODING gzip, deflate, br

HTTP_REFERER https://localhost/fa/public/admin/auth/rule?addtabs=1

HTTP_ACCEPT text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,/;q=0.8

HTTP_USER_AGENT Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.18 Safari/537.36

HTTP_UPGRADE_INSECURE_REQUESTS 1

HTTP_CONNECTION close

HTTP_HOST localhost

REDIRECT_STATUS 200

REDIRECT_PATH_INFO admin/auth/rule/edit/ids/188

FCGI_ROLE RESPONDER

PHP_SELF /fa/public/index.php

REQUEST_TIME_FLOAT 1513260193.1722

REQUEST_TIME 1513260193

PATH_INFO admin/auth/rule/edit/ids/188

Environment Variablesempty

ThinkPHP Constants

APP_PATH C:\phpStudy\WWW\fa\public/../application/

THINK_VERSION 5.0.12

THINK_START_TIME 1513260193.1736

THINK_START_MEM 145568

EXT .php

DS \

THINK_PATH C:\phpStudy\WWW\fa\thinkphp\

LIB_PATH C:\phpStudy\WWW\fa\thinkphp\library\

CORE_PATH C:\phpStudy\WWW\fa\thinkphp\library\think\

TRAIT_PATH C:\phpStudy\WWW\fa\thinkphp\library\traits\

ROOT_PATH C:\phpStudy\WWW\fa\

EXTEND_PATH C:\phpStudy\WWW\fa\extend\

VENDOR_PATH C:\phpStudy\WWW\fa\vendor\

RUNTIME_PATH C:\phpStudy\WWW\fa\runtime\

LOG_PATH C:\phpStudy\WWW\fa\runtime\log\

CACHE_PATH C:\phpStudy\WWW\fa\runtime\cache\

TEMP_PATH C:\phpStudy\WWW\fa\runtime\temp\

CONF_PATH C:\phpStudy\WWW\fa\public/../application/

CONF_EXT .php

ENV_PREFIX PHP_

IS_CLI false

IS_WIN true

ADDON_PATH C:\phpStudy\WWW\fa\addons\

IS_ADDTABS false

IS_DIALOG true

IS_AJAX false