[10501] PDOException in Connection.php line 385

SQLSTATE[HY000]: General error: 1030 Got error 28 from storage engine

  1. $this->PDOStatement->execute();
  2. // 调试结束
  3. $this->debug(false, '', $master);
  4. // 返回结果集
  5. return $this->getResult($pdo, $procedure);
  6. } catch (\PDOException $e) {
  7. if ($this->isBreak($e)) {
  8. return $this->close()->query($sql, $bind, $master, $pdo);
  9. }
  10. throw new PDOException($e, $this->config, $this->getLastsql());
  11. } catch (\Throwable $e) {
  12. if ($this->isBreak($e)) {
  13. return $this->close()->query($sql, $bind, $master, $pdo);
  14. }
  15. throw $e;
  16. } catch (\Exception $e) {
  17. if ($this->isBreak($e)) {
  18. return $this->close()->query($sql, $bind, $master, $pdo);
  19. }

Call Stack

  1. in Connection.php line 385
  2. at Connection->query('SHOW COLUMNS FROM `z...', [], false, true) in Mysql.php line 65
  3. at Mysql->getFields('`zq_douyin_goods`') in Query.php line 1921
  4. at Query->getTableInfo('zq_douyin_goods', 'type') in Query.php line 1969
  5. at Query->getFieldsType('zq_douyin_goods') in Query.php line 1975
  6. at Query->getFieldsBind('zq_douyin_goods') in Builder.php line 270
  7. at Builder->buildWhere(['AND' => [['exp', object(Expression)]]], ['alias' => ['zq_douyin_goods' => 'a'], 'join' => [[['zq_douyin_coupon' => 'b'], 'LEFT', 'a.num_iid = b.goods_...'], [['zq_seller' => 'u'], 'LEFT', 'a.zq_id = u.user_id'], [['zq_seller_info' => 's'], 'LEFT', 'u.id = s.seller_id']], 'where' => ['AND' => [['exp', object(Expression)]]], ...]) in Builder.php line 240
  8. at Builder->parseWhere(['AND' => [['exp', object(Expression)]]], ['alias' => ['zq_douyin_goods' => 'a'], 'join' => [[['zq_douyin_coupon' => 'b'], 'LEFT', 'a.num_iid = b.goods_...'], [['zq_seller' => 'u'], 'LEFT', 'a.zq_id = u.user_id'], [['zq_seller_info' => 's'], 'LEFT', 'u.id = s.seller_id']], 'where' => ['AND' => [['exp', object(Expression)]]], ...]) in Builder.php line 719
  9. at Builder->select(['alias' => ['zq_douyin_goods' => 'a'], 'join' => [[['zq_douyin_coupon' => 'b'], 'LEFT', 'a.num_iid = b.goods_...'], [['zq_seller' => 'u'], 'LEFT', 'a.zq_id = u.user_id'], [['zq_seller_info' => 's'], 'LEFT', 'u.id = s.seller_id']], 'where' => ['AND' => [['exp', object(Expression)]]], ...]) in Query.php line 2462
  10. at Query->getPdo() in Query.php line 441
  11. at Query->value('COUNT(*) AS tp_count', 0, true) in Query.php line 576
  12. at Query->aggregate('COUNT', '*', true) in Query.php line 551
  13. at Query->count() in Query.php line 1484
  14. at Query->paginate(100, false, ['type' => 'bootstrap5', 'var_page' => 'page', 'list_rows' => 15, ...]) in DouyinGoods.php line 32
  15. at DouyinGoods->getGoodsInfo('1=1 and a.is_on = 1 ...', 'a.createtime desc', '', ['view' => 'lists', 'sort' => null, 'volume' => null, ...], 100) in DouyinGoods.php line 143
  16. at DouyinGoods->getGoods('', 100, '1=1 and a.is_on = 1 ...', 'a.createtime desc') in Lists.php line 40
  17. at Lists->index()
  18. at ReflectionMethod->invokeArgs(object(Lists), []) in App.php line 343
  19. at App::invokeMethod([object(Lists), 'index'], []) in App.php line 611
  20. at App::module(['dy', 'lists', 'index'], ['app_host' => '', 'app_debug' => '1', 'app_trace' => '', ...], true) in App.php line 456
  21. at App::exec(['type' => 'module', 'module' => ['dy', 'lists', 'index']], ['app_host' => '', 'app_debug' => '1', 'app_trace' => '', ...]) in App.php line 139
  22. at App::run() in start.php line 19
  23. at require('/www/wwwroot/www.fly...') in index.php line 26

Exception Datas

PDO Error Info
SQLSTATE HY000
Driver Error Code 1030
Driver Error Message Got error 28 from storage engine
Database Status
Error Code 10501
Error Message SQLSTATE[HY000]: General error: 1030 Got error 28 from storage engine
Error SQL SHOW COLUMNS FROM `zq_douyin_goods`
Database Config
type mysql
hostname localhost
database www_flycms_cn
hostport
dsn
params []
charset utf8mb4
prefix zq_
debug true
deploy 0
rw_separate false
master_num 1
slave_no
read_master false
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

cat
29
cat_name
鞋品
POST Data
empty
Files
empty
Cookies
empty
Session
empty

Server/Request Data

USER
www
HOME
/home/www
PHP_APP_DEBUG
1
PHP_APP_TRACE
PHP_ZUANQUN_STATIC_DOMAIN
https://static.flycms.cn
PHP_ZUANQUN_SESSION_DOMAIN
.flycms.cn
HTTP_HOST
dy.flycms.cn
HTTP_USER_AGENT
claudebot
HTTP_ACCEPT
*/*
PATH_INFO
/lists/index.html
REDIRECT_STATUS
200
SERVER_NAME
www.flycms.cn
SERVER_PORT
80
SERVER_ADDR
172.26.13.69
REMOTE_PORT
35564
REMOTE_ADDR
18.209.209.246
SERVER_SOFTWARE
nginx/1.18.0
GATEWAY_INTERFACE
CGI/1.1
REQUEST_SCHEME
http
SERVER_PROTOCOL
HTTP/1.1
DOCUMENT_ROOT
/www/wwwroot/www.flycms.cn/flycms/public
DOCUMENT_URI
/index.php
REQUEST_URI
/lists/index.html?cat=29&cat_name=%E9%9E%8B%E5%93%81
SCRIPT_NAME
/index.php
CONTENT_LENGTH
CONTENT_TYPE
REQUEST_METHOD
GET
QUERY_STRING
s=/lists/index.html&cat=29&cat_name=%E9%9E%8B%E5%93%81
SCRIPT_FILENAME
/www/wwwroot/www.flycms.cn/flycms/public/index.php
FCGI_ROLE
RESPONDER
PHP_SELF
/index.php
REQUEST_TIME_FLOAT
1711666048.1586
REQUEST_TIME
1711666048
Environment Variables
empty

ThinkPHP Constants

APP_PATH
/www/wwwroot/www.flycms.cn/flycms/public/../application/
EXTEND_PATH
/www/wwwroot/www.flycms.cn/flycms/public/../library/
THINK_VERSION
5.0.24
THINK_START_TIME
1711666048.1591
THINK_START_MEM
404384
EXT
.php
DS
/
THINK_PATH
/www/wwwroot/www.flycms.cn/flycms/thinkphp/
LIB_PATH
/www/wwwroot/www.flycms.cn/flycms/thinkphp/library/
CORE_PATH
/www/wwwroot/www.flycms.cn/flycms/thinkphp/library/think/
TRAIT_PATH
/www/wwwroot/www.flycms.cn/flycms/thinkphp/library/traits/
ROOT_PATH
/www/wwwroot/www.flycms.cn/flycms/
VENDOR_PATH
/www/wwwroot/www.flycms.cn/flycms/vendor/
RUNTIME_PATH
/www/wwwroot/www.flycms.cn/flycms/runtime/
LOG_PATH
/www/wwwroot/www.flycms.cn/flycms/runtime/log/
CACHE_PATH
/www/wwwroot/www.flycms.cn/flycms/runtime/cache/
TEMP_PATH
/www/wwwroot/www.flycms.cn/flycms/runtime/temp/
CONF_PATH
/www/wwwroot/www.flycms.cn/flycms/public/../application/
CONF_EXT
.php
ENV_PREFIX
PHP_
IS_CLI
false
IS_WIN
false