联系官方销售客服

1835022288

028-61286886

开发框架 版主:迅睿框架研发组
如何解读系统错误 MySQL server has
类型:迅睿CMS 更新时间:2020-10-08 13:37:56
PHP程序里面

如何解毒系统错误

WRITEPATH/error/log-2020-10-01.php


<?php defined('SYSTEMPATH') || exit('No direct script access allowed'); ?>


ERROR - 2020-10-01 05:55:35 --> MySQL server has gone away

#SQL:SELECT * FROM `dr_1_news` WHERE `dr_1_news`.`status` = 9 AND `dr_1_news`.`id` IN (select `id` from `dr_1_news_flag` where `flag`=2) ORDER BY `dr_1_news`.`updatetime` DESC LIMIT 6

#URL:http://www.gtsjj.com/list-jianjie.html

#0 /data/home/syu5378574954/htdocs/dayrui/System/Database/MySQLi/Connection.php(331): mysqli->query('SELECT * FROM `...')

#1 /data/home/syu5378574954/htdocs/dayrui/System/Database/BaseConnection.php(741): CodeIgniter\Database\MySQLi\Connection->execute('SELECT * FROM `...')

#2 /data/home/syu5378574954/htdocs/dayrui/System/Database/BaseConnection.php(669): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT * FROM `...')

#3 /data/home/syu5378574954/htdocs/dayrui/Fcms/Core/View.php(2308): CodeIgniter\Database\BaseConnection->query('SELECT * FROM `...')

#4 /data/home/syu5378574954/htdocs/dayrui/Fcms/Core/View.php(2138): Phpcmf\View->_query('SELECT * FROM `...', '', 0)

#5 /data/home/syu5378574954/htdocs/cache/template/template_pc_default_home_page.html.cache.php(99): Phpcmf\View->list_tag('action=module m...')

#6 /data/home/syu5378574954/htdocs/dayrui/Fcms/Core/View.php(230): include('/data/home/syu4...')

#7 /data/home/syu5378574954/htdocs/dayrui/Fcms/Control/Home/Module.php(201): Phpcmf\View->display('page.html')

#8 /data/home/syu5378574954/htdocs/dayrui/Core/Controllers/Category.php(65): Phpcmf\Home\Module->_Category(7, 'jianjie', 1)

#9 /data/home/syu5378574954/htdocs/dayrui/System/CodeIgniter.php(918): Phpcmf\Controllers\Category->index()

#10 /data/home/syu5378574954/htdocs/dayrui/System/CodeIgniter.php(404): CodeIgniter\CodeIgniter->runController(Object(Phpcmf\Controllers\Category))

#11 /data/home/syu5378574954/htdocs/dayrui/System/CodeIgniter.php(312): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false)

#12 /data/home/syu5378574954/htdocs/dayrui/Fcms/Init.php(378): CodeIgniter\CodeIgniter->run()

#13 /data/home/syu5378574954/htdocs/index.php(45): require('/data/home/syu4...')

#14 {main}





WRITEPATH/error/log-2020-10-08.php


<?php defined('SYSTEMPATH') || exit('No direct script access allowed'); ?>


ERROR - 2020-10-08 09:11:38 --> MySQL server has gone away

#SQL:SELECT * FROM `dr_1_news` WHERE `zdyurl` = 'opChinaReload'

#URL:http://www.gtsjj.com/opChinaReload.html

#0 /data/home/syu5378574954/htdocs/dayrui/System/Database/MySQLi/Connection.php(331): mysqli->query('SELECT *\nFROM `...')

#1 /data/home/syu5378574954/htdocs/dayrui/System/Database/BaseConnection.php(741): CodeIgniter\Database\MySQLi\Connection->execute('SELECT *\nFROM `...')

#2 /data/home/syu5378574954/htdocs/dayrui/System/Database/BaseConnection.php(669): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT *\nFROM `...')

#3 /data/home/syu5378574954/htdocs/dayrui/System/Database/BaseBuilder.php(1860): CodeIgniter\Database\BaseConnection->query('SELECT *\nFROM `...', Array, false)

#4 /data/home/syu5378574954/htdocs/dayrui/Fcms/Model/Content.php(765): CodeIgniter\Database\BaseBuilder->get()

#5 /data/home/syu5378574954/htdocs/dayrui/Fcms/Model/Content.php(782): Phpcmf\Model\Content->find_row('zdyurl', 'opChinaReload')

#6 /data/home/syu5378574954/htdocs/dayrui/Fcms/Control/Home/Module.php(315): Phpcmf\Model\Content->get_data(0, 0, Array)

#7 /data/home/syu5378574954/htdocs/dayrui/App/News/Controllers/Show.php(18): Phpcmf\Home\Module->_Show('7d86af50410afde...', Array, 1)

#8 /data/home/syu5378574954/htdocs/dayrui/System/CodeIgniter.php(918): Phpcmf\Controllers\Show->index()

#9 /data/home/syu5378574954/htdocs/dayrui/System/CodeIgniter.php(404): CodeIgniter\CodeIgniter->runController(Object(Phpcmf\Controllers\Show))

#10 /data/home/syu5378574954/htdocs/dayrui/System/CodeIgniter.php(312): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false)

#11 /data/home/syu5378574954/htdocs/dayrui/Fcms/Init.php(378): CodeIgniter\CodeIgniter->run()

#12 /data/home/syu5378574954/htdocs/index.php(45): require('/data/home/syu4...')

#13 {main}


回帖
  • 猪肉贩子
    #1楼    猪肉贩子
    2020-10-08 10:06:44
    Chrome 0
    阿里虚拟主机无法访问两回,提交工单是服务器io负载过高会影响服务器上所有的程序,包括ftp和控制面板的。请问我该如何查证问题所在
  • #2楼    迅睿框架创始人
    2020-10-08 10:11:08
    Google Pixel 手机 0
    就是负载高了
  • 猪肉贩子
    #3楼    猪肉贩子
    2020-10-08 10:13:38
    Chrome 0
    回复迅睿框架创始人 可我就几篇文章,而且没有收录呢?会不会是插件影响?比如蜘蛛监控插件?
  • #4楼    迅睿框架创始人
    2020-10-08 10:17:03
    Google Pixel 手机 0
    这个不好说,具体看哪个URL导致的过高了
  • 菠菜
    #5楼    菠菜
    2020-10-08 10:23:43
    Chrome 0
    看看访客是不是蜘蛛在无休止的爬页面
  • 小黄人 18html
    #6楼    小黄人 18html
    2020-10-08 10:55:48
    Chrome 0
    MYSQL挂了

  • 猪肉贩子
    #7楼    猪肉贩子
    2020-10-08 10:58:27
    Chrome 0
    菠菜 很久以前可能出现过。类似YandexBot之类的我已经按照网友的方法在.htaccess禁止了。robots.txt也只给了bd,360几个国内主流
  • 猪肉贩子
    #8楼    猪肉贩子
    2020-10-08 11:00:40
    Chrome 0
    小黄人 18html 嗯,阿里工单说是io负载过高。等待他们核查是否是网站程序进程导致
  • 小黄人 18html
    #9楼    小黄人 18html
    2020-10-08 11:12:23
    Chrome 0
    你可以试试开启缓存机制!迅睿的负载确实很高,以前用POSCMS的时候就有问题后来让公司买了 16GB 8核的服务器才搞定!
  • 猪肉贩子
    #10楼    猪肉贩子
    2020-10-08 11:35:32
    Chrome 0
    小黄人 18html 缓存方式有三种,文件、 Memcached、 Redis。虚拟主机适合哪种呢
  • 小黄人 18html
    #11楼    小黄人 18html
    2020-10-08 11:38:06
    Chrome 0
    猪肉贩子 用文件,其他2种需要服务器组件支持的!所以省事点就用文件
    满意答案
  • 猪肉贩子
    #12楼    猪肉贩子
    2020-10-08 13:37:56
    Chrome 0
    @小黄人 18html:非常感谢!