2026-09-01 22:22:00 — PHP8.5.2 — search/news/keyword-%E5%8D%B0%E5%88%B7

CodeIgniter\Database\Exceptions\DatabaseException #1213

Deadlock found when trying to get lock; try restarting transaction
DELETE FROM `dr_1_news_search`
WHERE `inputtime` < 1788268920

/www/wwwroot/xun.niuqiqi.com/dayrui/System/Database/BaseConnection.php at line 684

677                     }
678                 }
679 
680                 // Let others do something with this query.
681                 Events::trigger('DBQuery', $query);
682 
683                 if ($exception instanceof DatabaseException) {
684                     throw new DatabaseException(
685                         $exception->getMessage().'<br>'.$query,
686                         $exception->getCode(),
687                         $exception,
688                     );
689                 }
690 
691                 return false;
    Caused by:
    CodeIgniter\Database\Exceptions\DatabaseException #1213
    Deadlock found when trying to get lock; try restarting transaction    
    /www/wwwroot/xun.niuqiqi.com/dayrui/System/Database/MySQLi/Connection.php:332    
    Caused by:
    mysqli_sql_exception #1213
    Deadlock found when trying to get lock; try restarting transaction    
    /www/wwwroot/xun.niuqiqi.com/dayrui/System/Database/MySQLi/Connection.php:327    
  1. /www/wwwroot/xun.niuqiqi.com/dayrui/System/Database/MySQLi/Connection.php : 327   —  mysqli->query ()

    320             $this->connID->next_result();
    321             if ($res = $this->connID->store_result()) {
    322                 $res->free();
    323             }
    324         }
    325 
    326         try {
    327             return $this->connID->query($this->prepQuery($sql), $this->resultMode);
    328         } catch (mysqli_sql_exception $e) {
    329             log_message('error', (string) $e);
    330 
    331             if ($this->DBDebug) {
    332                 throw new DatabaseException($e->getMessage(), $e->getCode(), $e);
    333             }
    334         }
    
  2. /www/wwwroot/xun.niuqiqi.com/dayrui/System/Database/BaseConnection.php : 729   —  CodeIgniter\Database\MySQLi\Connection->execute ()

    722      */
    723     public function simpleQuery(string $sql)
    724     {
    725         if (empty($this->connID)) {
    726             $this->initialize();
    727         }
    728 
    729         return $this->execute($sql);
    730     }
    731 
    732     /**
    733      * Disable Transactions
    734      *
    735      * This permits transactions to be disabled at run-time.
    736      *
    
  3. /www/wwwroot/xun.niuqiqi.com/dayrui/System/Database/BaseConnection.php : 646   —  CodeIgniter\Database\BaseConnection->simpleQuery ()

    639 
    640             return $query;
    641         }
    642 
    643         // Run the query for real
    644         try {
    645             $exception      = null;
    646             $this->resultID = $this->simpleQuery($query->getQuery());
    647         } catch (DatabaseException $exception) {
    648             $this->resultID = false;
    649         }
    650 
    651         if ($this->resultID === false) {
    652             $query->setDuration($startTime, $startTime);
    653 
    
  4. /www/wwwroot/xun.niuqiqi.com/dayrui/System/Database/BaseBuilder.php : 2848   —  CodeIgniter\Database\BaseConnection->query ()

    2841             $sql = $this->_limit($sql, true);
    2842         }
    2843 
    2844         if ($resetData) {
    2845             $this->resetWrite();
    2846         }
    2847 
    2848         return $this->testMode ? $sql : $this->db->query($sql, $this->binds, false);
    2849     }
    2850 
    2851     /**
    2852      * Sets data and calls batchExecute to run queries
    2853      *
    2854      * @param array|object|null $set         a dataset
    2855      * @param array|RawSql|null $constraints
    
  5. /www/wwwroot/xun.niuqiqi.com/dayrui/App/Module/Models/Search.php : 290   —  CodeIgniter\Database\BaseBuilder->delete ()

    283             $time = SYS_CACHE_SEARCH * 3600;
    284             if ($data && $data['inputtime'] + $time < SYS_TIME) {
    285                 $data = [];
    286             }
    287             $this->db->table($this->mytable.'_search')->where('inputtime <'. (SYS_TIME - $time))->delete();
    288         } else {
    289             $data = [];
    290             $this->db->table($this->mytable.'_search')->where('inputtime <'. (SYS_TIME - 3600))->delete();
    291         }
    292         // 缓存不存在重新入库更新缓存
    293         if (!$data) {
    294 
    295             // 组合sql查询结果
    296             $sql = "SELECT `{$table}`.`id` FROM `".$table."` {$where_sql} ORDER BY NULL ";
    297 
    
  6. /www/wwwroot/xun.niuqiqi.com/dayrui/App/Module/Extends/Home/Module.php : 157   —  Phpcmf\Model\Module\Search->get_data ()

    150                 'params' => $get,
    151                 'keyword' => $get['keyword'],
    152                 'contentid' => 0,
    153                 'inputtime' => SYS_TIME
    154             ];
    155         } else {
    156             // 搜索数据
    157             $data = $search->get_data();
    158             if (isset($data['code']) && $data['code'] == 0 && $data['msg']) {
    159                 $this->_msg(0, $data['msg']);
    160             }
    161             unset($data['params']['page']);
    162         }
    163 
    164         // 格式化数据
    
  7. /www/wwwroot/xun.niuqiqi.com/dayrui/App/News/Controllers/Search.php : 14   —  Phpcmf\Home\Module->_Search ()

     7 class Search extends \Phpcmf\Home\Module
     8 {
     9 
    10     public function index() {
    11         // 初始化模块
    12         $this->_module_init();
    13         // 调用搜索方法
    14         $this->_Search();
    15     }
    16 
    17 }
    18 
    
  8. /www/wwwroot/xun.niuqiqi.com/dayrui/System/Extend/Run.php : 149   —  Phpcmf\Controllers\Search->index ()

    142                         'value' => $value
    143                     ]);
    144 
    145                 }
    146             }
    147         }
    148 
    149         $app->$method();
    150 
    151         if (CI_DEBUG) {
    152             $tool = new \CodeIgniter\Debug\Toolbar(config(\Config\Toolbar::class));
    153             $tool->prepare($this);
    154         }
    155         
    156        
    
  9. /www/wwwroot/xun.niuqiqi.com/dayrui/System/Init.php : 402   —  Frame\Run->bootWeb ()

    395         $tool->respond();
    396     });
    397 }
    398 
    399 
    400 // 启动框架
    401 $run = new \Frame\Run();
    402 $run->bootWeb();
    403 
    404 
    
  10. require /www/wwwroot/xun.niuqiqi.com/dayrui/Fcms/Init.php   —   require()

  11. require /www/wwwroot/xun.niuqiqi.com/public/index.php   —   require()

$_SERVER

Key Value
USER www
HOME /home/www
HTTP_ACCEPT_ENCODING gzip, br, zstd, deflate
HTTP_USER_AGENT Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
HTTP_ACCEPT */*
PATH_INFO
HTTP_HOST xun.niuqiqi.com
REDIRECT_STATUS 200
SERVER_NAME xun.niuqiqi.com
SERVER_PORT 443
SERVER_ADDR 10.0.16.9
REMOTE_PORT 11807
REMOTE_ADDR 216.73.216.43
SERVER_SOFTWARE nginx/1.28.3
GATEWAY_INTERFACE CGI/1.1
HTTPS on
REQUEST_SCHEME https
SERVER_PROTOCOL HTTP/2.0
DOCUMENT_ROOT /www/wwwroot/xun.niuqiqi.com/public
DOCUMENT_URI /index.php
REQUEST_URI /search/news/keyword-%E5%8D%B0%E5%88%B7
SCRIPT_NAME /index.php
CONTENT_LENGTH
CONTENT_TYPE
REQUEST_METHOD GET
QUERY_STRING
SCRIPT_FILENAME /www/wwwroot/xun.niuqiqi.com/public/index.php
FCGI_ROLE RESPONDER
PHP_SELF /index.php
REQUEST_TIME_FLOAT
1788272520.5257
REQUEST_TIME
1788272520

Constants

Key Value
IS_DEV
1
IS_EDIT_TPL
0
ROOTPATH /www/wwwroot/xun.niuqiqi.com/public/
WEBPATH /www/wwwroot/xun.niuqiqi.com/public/
FCPATH /www/wwwroot/xun.niuqiqi.com/dayrui/
WRITEPATH /www/wwwroot/xun.niuqiqi.com/cache/
CONFIGPATH /www/wwwroot/xun.niuqiqi.com/config/
SELF index.php
IS_ADMIN

                                                                    
IS_VERSION
1
FRAMEPATH /www/wwwroot/xun.niuqiqi.com/dayrui/System/
CMSPATH /www/wwwroot/xun.niuqiqi.com/dayrui/Fcms/
MAX_CATEGORY
300
COREPATH /www/wwwroot/xun.niuqiqi.com/dayrui/Fcms/
BASEPATH /www/wwwroot/xun.niuqiqi.com/dayrui/System/System/
APPSPATH /www/wwwroot/xun.niuqiqi.com/dayrui/App/
MYPATH /www/wwwroot/xun.niuqiqi.com/dayrui/My/
TPLPATH /www/wwwroot/xun.niuqiqi.com/template/
IS_XRDEV
0
MOBILE_TPL_DIR mobile
UEDITOR_IMG_TITLE {cms_img_title}
TESTPATH /www/wwwroot/xun.niuqiqi.com/cache/tests/
TEMPPATH /www/wwwroot/xun.niuqiqi.com/dayrui/Fcms/Temp/
COMPOSER_PATH /www/wwwroot/xun.niuqiqi.com/public/vendor/autoload.php
IS_AJAX

                                                                    
IS_POST

                                                                    
IS_AJAX_POST

                                                                    
SYS_TIME
1788272520
SYS_DEBUG
1
SYS_ADMIN_CODE
0
SYS_ADMIN_LOG
0
SYS_AUTO_FORM
0
SYS_ADMIN_PAGESIZE
10
SYS_CRON_AUTH
0
SYS_TABLE_ISFOOTER
0
SYS_SMS_IMG_CODE
0
SYS_GO_404
0
SYS_THEME_ROOT_PATH
1
SYS_301
1
SYS_NOT_UPDATE
1
SYS_URL_ONLY
0
SYS_URL_REL
1
SYS_KEY PHPCMFb52d772433252cf02f8105df2499d057
SYS_API_TOKEN
SYS_CSRF
0
SYS_CSRF_TIME
1
SYS_API_REL
0
SYS_HTTPS
1
SYS_NOT_ADMIN_CACHE
1
SYS_ADMIN_MODE
0
SYS_ADMIN_LOGINS
10
SYS_ADMIN_LOGIN_AES
SYS_ATTACHMENT_DOWN_REMOTE
SYS_ATTACHMENT_DOWN_SIZE
SYS_ADMIN_LOGIN_TIME
0
SYS_LOGIN_AES
0
SYS_ADMIN_OAUTH
0
SYS_ADMIN_SMS_LOGIN
0
SYS_ADMIN_SMS_CHECK
0
SYS_ATTACHMENT_DB
SYS_ATTACHMENT_PAGESIZE
SYS_ATTACHMENT_GUEST
SYS_ATTACHMENT_CF
SYS_ATTACHMENT_REL
SYS_ATTACHMENT_PATH
SYS_ATTACHMENT_SAVE_TYPE
SYS_ATTACHMENT_SAVE_DIR
SYS_ATTACHMENT_SAVE_ID
SYS_ATTACHMENT_URL
SYS_AVATAR_PATH
SYS_AVATAR_URL
SYS_API_CODE
0
SYS_ATTACHMENT_SAFE
IS_ADMIN_CACHE 1
SQGS 迅睿CMS开源框架
CI_DEBUG
1
IS_FB_DEBUG
0
ENVIRONMENT development
SYS_CACHE
0
SYS_CACHE_TYPE
0
SYS_CACHE_SHOW
0
SYS_CACHE_LIST
0
SYS_CACHE_SEARCH
0
SYS_CACHE_SMS
0
SYS_CACHE_CRON
0
SYS_CACHE_CLEAR
0
FC_NOW_URL https://xun.niuqiqi.com/search/news/keyword-%E5%8D%B0%E5%88%B7
FC_NOW_HOST https://xun.niuqiqi.com/
DOMAIN_NAME xun.niuqiqi.com
WEB_DIR /
CMSURI search/news/keyword-%E5%8D%B0%E5%88%B7
IS_API

                                                                    
IS_USE_MEMBER /www/wwwroot/xun.niuqiqi.com/dayrui/App/Member/
IS_USE_MODULE /www/wwwroot/xun.niuqiqi.com/dayrui/App/Module/
APPPATH /www/wwwroot/xun.niuqiqi.com/dayrui/App/News/
APP_DIR news
IS_MEMBER

                                                                    
IS_HOME
1
FRAME_PHP_VERSION 8.0
FRAME_NAME System
FRAME_VERSION 4.7
EXIT_SUCCESS
0
EXIT_ERROR
1
EXIT_CONFIG
3
EXIT_UNKNOWN_FILE
4
EXIT_UNKNOWN_CLASS
5
EXIT_UNKNOWN_METHOD
6
EXIT_USER_INPUT
7
EXIT_DATABASE
8
EXIT__AUTO_MIN
9
EXIT__AUTO_MAX
125
EVENT_PRIORITY_LOW
200
EVENT_PRIORITY_NORMAL
100
EVENT_PRIORITY_HIGH
10
IS_COMMON
1
IS_SITES
0
CMF_NAME 迅睿框架开源版
CMF_VERSION 4.7.1
CMF_UPDATE_TIME 1776407524
SITE_ID
1
SITE_URL https://xun.niuqiqi.com/
SITE_MURL https://xun.niuqiqi.com/
SITE_NAME 牛七七
SITE_LOGO https://xun.niuqiqi.com/uploadfile/attachments/202006/417ff46956333bc.png
SITE_IS_MOBILE
0
SITE_IS_MOBILE_HTML
0
SITE_MOBILE_DIR mobile
SITE_MOBILE_NOT_PAD
0
SITE_THUMB_WATERMARK
0
SITE_THEME niu7
SITE_SEOJOIN _
SITE_REWRITE
0
SITE_TEMPLATE niuq
SITE_LANGUAGE zh-cn
SITE_TIME_FORMAT Y-m-d H:i:s
ADMIN_URL https://xun.niuqiqi.com/
PAY_URL https://xun.niuqiqi.com/
ROOT_URL https://xun.niuqiqi.com/
OAUTH_URL https://xun.niuqiqi.com/
THEME_PATH /static/
LANG_PATH /api/language/zh-cn/
ROOT_THEME_PATH /static/
HOME_THEME_PATH /static/niu7/
MOBILE_THEME_PATH https://xun.niuqiqi.com/static/niu7/
SYS_UPLOAD_PATH /www/wwwroot/xun.niuqiqi.com/public/uploadfile/
SYS_UPLOAD_URL https://xun.niuqiqi.com/uploadfile/
CLIENT_URL https://xun.niuqiqi.com/
CLIENT_NAME pc
IS_CLIENT
MEMBER_URL https://xun.niuqiqi.com/index.php?s=member
SITE_FID
0
MEMBER_CNAME 昵称
SITE_ICP 湘ICP备12003358号
SITE_TONGJI
SITE_LOGIN_TIME
36000
SITE_SCORE 金币
SITE_EXPERIENCE 经验
IS_API_HTTP
0
USER_HTTP_CODE dbc88ac87b0a26331dc6567b710f8936
MOD_DIR news
IS_SHARE 1
IS_COMMENT
0
MODULE_URL /
MODULE_NAME 文章
  1. /www/wwwroot/xun.niuqiqi.com/public/index.php
  2. /www/wwwroot/xun.niuqiqi.com/dayrui/Fcms/Init.php
  3. /www/wwwroot/xun.niuqiqi.com/config/custom.php
  4. /www/wwwroot/xun.niuqiqi.com/cache/config/system.php
  5. /www/wwwroot/xun.niuqiqi.com/config/rewrite.php
  6. /www/wwwroot/xun.niuqiqi.com/cache/config/domain_app.php
  7. /www/wwwroot/xun.niuqiqi.com/dayrui/Fcms/Core/Helper.php
  8. /www/wwwroot/xun.niuqiqi.com/dayrui/System/Init.php
  9. /www/wwwroot/xun.niuqiqi.com/dayrui/Fcms/Core/Auto.php
  10. /www/wwwroot/xun.niuqiqi.com/dayrui/Fcms/Core/Service.php
  11. /www/wwwroot/xun.niuqiqi.com/dayrui/Fcms/Core/Hooks.php
  12. /www/wwwroot/xun.niuqiqi.com/dayrui/System/Extend/Run.php
  13. /www/wwwroot/xun.niuqiqi.com/dayrui/Fcms/Core/Phpcmf.php
  14. /www/wwwroot/xun.niuqiqi.com/dayrui/System/Extend/Controller.php
  15. /www/wwwroot/xun.niuqiqi.com/dayrui/App/Module/Config/Auto.php
  16. /www/wwwroot/xun.niuqiqi.com/dayrui/App/Module/Config/Hooks.php
  17. /www/wwwroot/xun.niuqiqi.com/dayrui/App/Module/Config/Filters.php
  18. /www/wwwroot/xun.niuqiqi.com/dayrui/App/Member/Config/Hooks.php
  19. /www/wwwroot/xun.niuqiqi.com/dayrui/System/Config/Services.php
  20. /www/wwwroot/xun.niuqiqi.com/dayrui/System/Config/BaseService.php
  21. /www/wwwroot/xun.niuqiqi.com/dayrui/System/Config/Factories.php
  22. /www/wwwroot/xun.niuqiqi.com/dayrui/System/Config/Factory.php
  23. /www/wwwroot/xun.niuqiqi.com/dayrui/System/Config/BaseConfig.php
  24. /www/wwwroot/xun.niuqiqi.com/dayrui/System/Config/Exceptions.php
  25. /www/wwwroot/xun.niuqiqi.com/dayrui/System/Debug/Exceptions.php
  26. /www/wwwroot/xun.niuqiqi.com/dayrui/System/Events/Events.php
  27. /www/wwwroot/xun.niuqiqi.com/dayrui/System/Debug/Timer.php
  28. /www/wwwroot/xun.niuqiqi.com/dayrui/System/Config/Toolbar.php
  29. /www/wwwroot/xun.niuqiqi.com/dayrui/System/Debug/Toolbar.php
  30. /www/wwwroot/xun.niuqiqi.com/dayrui/System/Debug/Toolbar/Collectors/Database.php
  31. /www/wwwroot/xun.niuqiqi.com/dayrui/System/Debug/Toolbar/Collectors/BaseCollector.php
  32. /www/wwwroot/xun.niuqiqi.com/dayrui/System/Config/Database.php
  33. /www/wwwroot/xun.niuqiqi.com/dayrui/System/Database/Config.php
  34. /www/wwwroot/xun.niuqiqi.com/dayrui/System/Debug/Toolbar/Collectors/Views.php
  35. /www/wwwroot/xun.niuqiqi.com/dayrui/Fcms/Core/View.php
  36. /www/wwwroot/xun.niuqiqi.com/dayrui/Fcms/Library/Input.php
  37. /www/wwwroot/xun.niuqiqi.com/dayrui/System/Debug/Toolbar/Collectors/Files.php
  38. /www/wwwroot/xun.niuqiqi.com/dayrui/System/Debug/Toolbar/Collectors/Routes.php
  39. /www/wwwroot/xun.niuqiqi.com/dayrui/App/News/Controllers/Search.php
  40. /www/wwwroot/xun.niuqiqi.com/dayrui/App/Module/Extends/Home/Module.php
  41. /www/wwwroot/xun.niuqiqi.com/cache/config/site.php
  42. /www/wwwroot/xun.niuqiqi.com/dayrui/My/Config/Version.php
  43. /www/wwwroot/xun.niuqiqi.com/dayrui/Fcms/Library/Cache.php
  44. /www/wwwroot/xun.niuqiqi.com/dayrui/Fcms/Library/Lang.php
  45. /www/wwwroot/xun.niuqiqi.com/public/api/language/zh-cn/lang.php
  46. /www/wwwroot/xun.niuqiqi.com/dayrui/Fcms/Library/Security.php
  47. /www/wwwroot/xun.niuqiqi.com/dayrui/Fcms/Model/Member.php
  48. /www/wwwroot/xun.niuqiqi.com/dayrui/Fcms/Core/Model.php
  49. /www/wwwroot/xun.niuqiqi.com/dayrui/System/Extend/Model.php
  50. /www/wwwroot/xun.niuqiqi.com/config/database.php
  51. /www/wwwroot/xun.niuqiqi.com/dayrui/System/Database/Database.php
  52. /www/wwwroot/xun.niuqiqi.com/dayrui/System/Database/MySQLi/Connection.php
  53. /www/wwwroot/xun.niuqiqi.com/dayrui/System/Database/BaseConnection.php
  54. /www/wwwroot/xun.niuqiqi.com/dayrui/System/Database/ConnectionInterface.php
  55. /www/wwwroot/xun.niuqiqi.com/dayrui/App/Module/Config/Run.php
  56. /www/wwwroot/xun.niuqiqi.com/cache/config/domain_client.php
  57. /www/wwwroot/xun.niuqiqi.com/dayrui/Fcms/Library/Router.php
  58. /www/wwwroot/xun.niuqiqi.com/dayrui/App/Member/Libraries/Member_auth.php
  59. /www/wwwroot/xun.niuqiqi.com/config/hooks.php
  60. /www/wwwroot/xun.niuqiqi.com/dayrui/System/Extend/Hook.php
  61. /www/wwwroot/xun.niuqiqi.com/dayrui/App/Member/Libraries/Member.php
  62. /www/wwwroot/xun.niuqiqi.com/dayrui/App/Module/Config/Module_init.php
  63. /www/wwwroot/xun.niuqiqi.com/dayrui/Fcms/Model/Content.php
  64. /www/wwwroot/xun.niuqiqi.com/dayrui/App/Module/Models/Content.php
  65. /www/wwwroot/xun.niuqiqi.com/dayrui/Fcms/Model/Search.php
  66. /www/wwwroot/xun.niuqiqi.com/dayrui/App/Module/Models/Search.php
  67. /www/wwwroot/xun.niuqiqi.com/dayrui/System/Database/MySQLi/Builder.php
  68. /www/wwwroot/xun.niuqiqi.com/dayrui/System/Database/BaseBuilder.php
  69. /www/wwwroot/xun.niuqiqi.com/dayrui/System/Traits/ConditionalTrait.php
  70. /www/wwwroot/xun.niuqiqi.com/dayrui/System/Database/Query.php
  71. /www/wwwroot/xun.niuqiqi.com/dayrui/System/Database/QueryInterface.php
  72. /www/wwwroot/xun.niuqiqi.com/dayrui/System/Database/Exceptions/DatabaseException.php
  73. /www/wwwroot/xun.niuqiqi.com/dayrui/System/Exceptions/RuntimeException.php
  74. /www/wwwroot/xun.niuqiqi.com/dayrui/System/Exceptions/ExceptionInterface.php
  75. /www/wwwroot/xun.niuqiqi.com/dayrui/System/Database/Exceptions/ExceptionInterface.php
  76. /www/wwwroot/xun.niuqiqi.com/dayrui/System/Exceptions/HasExitCodeInterface.php
  77. /www/wwwroot/xun.niuqiqi.com/dayrui/System/Debug/ExceptionHandler.php
  78. /www/wwwroot/xun.niuqiqi.com/dayrui/System/Debug/BaseExceptionHandler.php
  79. /www/wwwroot/xun.niuqiqi.com/dayrui/System/Debug/ExceptionHandlerInterface.php
  80. /www/wwwroot/xun.niuqiqi.com/dayrui/System/Exceptions/Views/html/error_exception.php