Ошибка mysql в файле engine classes mysql php в строке 52
Обновлено: 04.07.2024
Здравствуйте! Ошибка в следующем, при попытки оставить коммент или зарегистрироватся на сайте, сайт подвисает на 5-10 сек после чего выскакивает ошибка:
MySQL error in file: /engine/modules/addcomments.php at line 83
Error Number: 2006
The Error returned was:
MySQL server has gone away
SQL query:
MySQL error in file: /engine/modules/register.php at line 135
Error Number: 2006
The Error returned was:
MySQL server has gone away
SQL query:
INSERT INTO dle_spam_log (ip, is_spammer, date) VALUES ('91.188.158.114','0', '1494816981')
Посмотрите лог ошибок MySQL. В нем должна быть причина падения сервера.
Есть ли свободное место на диске?
170514 20:32:02 InnoDB: Waiting for the background threads to start
170514 20:32:03 InnoDB: 5.5.56 started; log sequence number 2259226
170514 20:32:03 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
170514 20:32:03 [Note] - '0.0.0.0' resolves to '0.0.0.0';
170514 20:32:03 [Note] Server socket created on IP: '0.0.0.0'.
170514 20:32:06 [Note] Event Scheduler: Loaded 0 events
170514 20:32:06 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.56' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) by Remi
170514 20:58:42 [Note] Plugin 'FEDERATED' is disabled.
170514 20:58:43 InnoDB: The InnoDB memory heap is disabled
170514 20:58:43 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170514 20:58:43 InnoDB: Compressed tables use zlib 1.2.3
170514 20:58:43 InnoDB: Using Linux native AIO
170514 20:58:44 InnoDB: Initializing buffer pool, size = 128.0M
170514 20:58:44 InnoDB: Completed initialization of buffer pool
170514 20:58:44 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
170514 20:58:44 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files.
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer.
170514 20:58:52 InnoDB: Waiting for the background threads to start
170514 20:58:53 InnoDB: 5.5.56 started; log sequence number 2259226
170514 20:58:53 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
170514 20:58:53 [Note] - '0.0.0.0' resolves to '0.0.0.0';
170514 20:58:53 [Note] Server socket created on IP: '0.0.0.0'.
170514 20:58:56 [Note] Event Scheduler: Loaded 0 events
170514 20:58:56 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.56' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) by Remi
Всегда ли вставка в таблицу dle_spam_log приводит к крэшу? Сделайте
CHECK TABLE dle_spam_log;
Читайте также: