V
V
VA2016-09-09 10:21:48
linux
VA, 2016-09-09 10:21:48

Is the database crashing (Mysql, Bitrix CMS)?

I can not understand, I increased the value of max_allowed_packet to 500M, after 5 days the base crashed again.

[Bitrix\Main\DB\SqlQueryException] 
Mysql query error: Got a packet bigger than 'max_allowed_packet' bytes (400) INSERT INTO b_event(`EVENT_NAME`, `LID`, `C_FIELDS`, `DATE_INSERT`, `DUPLICATE`) 
VALUES ('STATISTIC_DAILY_REPORT', 's1', 'a:10:{s:11:\"SERVER_TIME\";s:19:\"09.09.2016 09:13:40\";s:11:\"HTML_HEADER\";s:1737:\"\n
  \n	\n	\n	\n	\n	\n	\n	\";s:11:\"HTML_FOOTER\";s:26:\"\n	\n	\n \";s:11:\"HTML_COMMON\";s:5824:\"\n	
\n	\n	\n	\n	\n	\n	\n	\n	\n	\n	\n	\n	\n	\n	\n	\n	\n	
\n	\n	\n	\n	\n	\n	\n	\n	\n	\n	\n \n	\n	\n	\n	\n	\n	\n	
\n	\n	\n	\n	\n	\n	\n	\n


/home/bitrix/www/bitrix/modules/main/lib/db/mysqlconnection.php:104
#0: Bitrix\Main\DB\MysqlConnection->queryInternal(string, array, NULL)
  /home/bitrix/www/bitrix/modules/main/lib/db/connection.php:329
#1: Bitrix\Main\DB\Connection->query(string, NULL)
  /home/bitrix/www/bitrix/modules/main/lib/db/connection.php:378
#2: Bitrix\Main\DB\Connection->queryExecute(string)
  /home/bitrix/www/bitrix/modules/main/lib/db/connection.php:453
#3: Bitrix\Main\DB\Connection->add(string, array, string)
  /home/bitrix/www/bitrix/modules/main/lib/entity/datamanager.php:540
#4: Bitrix\Main\Entity\DataManager::add(array)
  /home/bitrix/www/bitrix/modules/main/lib/mail/event.php:52
#5: Bitrix\Main\Mail\Event::send(array)
  /home/bitrix/www/bitrix/modules/main/classes/general/event.php:81
#6: CAllEvent::Send(string, string, array)
  /home/bitrix/www/bitrix/modules/statistic/stat_tools.php:938
#7: SendDailyStatistics()
  /home/bitrix/www/bitrix/modules/main/classes/mysql/agent.php(159) : eval()'d code:1
#8: eval()
  /home/bitrix/www/bitrix/modules/main/classes/mysql/agent.php:159
#9: CAgent::ExecuteAgents(string)
  /home/bitrix/www/bitrix/modules/main/classes/mysql/agent.php:38
#10: CAgent::CheckAgents()
  /home/bitrix/www/bitrix/modules/main/include.php:270
#11: require_once(string)
  /home/bitrix/www/bitrix/modules/main/include/prolog_before.php:14
#12: require_once(string)
  /home/bitrix/www/bitrix/modules/main/include/prolog.php:10
#13: require_once(string)
  /home/bitrix/www/bitrix/header.php:1
#14: require(string)
  /home/bitrix/www/index.php:2

Answer the question

In order to leave comments, you need to log in

2 answer(s)
D
Dmitry Aitkulov, 2016-09-09
@Scarfase1989

writes in Russian
probably this parameter should be increased max_allowed_packet

A
Andrey Nikolaev, 2017-02-25
@gromdron

Just a tip: if you don't use it, turn off the web analytics module.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question