пятница, 31 июля 2015 г.

Битрикс: ошибка Mysql query error: The SELECT would examine more than MAX_JOIN_SIZE rows

Ситуация

Битрикс 15.5.3

В новом модуле рассылки на странице

/bitrix/admin/sender_mailing_recipient_admin.php?MAILING_ID=13&lang=ru#authorize

появилась ошибка

[Bitrix\Main\DB\SqlQueryException] 
Mysql query error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay (400)
SELECT 
 `sender_posting_recipient`.`NAME` AS `NAME`,
 `sender_posting_recipient`.`EMAIL` AS `EMAIL`,
 COUNT(`sender_posting_recipient_posting_read`.`ID`) AS `READ_CNT`,
 COUNT(`sender_posting_recipient_posting_click`.`ID`) AS `CLICK_CNT`,
 COUNT(`sender_posting_recipient_posting_unsub`.`ID`) AS `UNSUB_CNT`
FROM `b_sender_posting_recipient` `sender_posting_recipient` 
LEFT JOIN `b_sender_posting_read` `sender_posting_recipient_posting_read` ON `sender_posting_recipient`.`ID` = `sender_posting_recipient_posting_read`.`RECIPIENT_ID`
LEFT JOIN `b_sender_posting_unsub` `sender_posting_recipient_posting_unsub` ON `sender_posting_recipient`.`ID` = `sender_posting_recipient_posting_unsub`.`RECIPIENT_ID`
LEFT JOIN `b_sender_posting_click` `sender_posting_recipient_posting_click` ON `sender_posting_recipient`.`ID` = `sender_posting_recipient_posting_click`.`RECIPIENT_ID`
LEFT JOIN `b_sender_posting` `sender_posting_recipient_posting` ON `sender_posting_recipient`.`POSTING_ID` = `sender_posting_recipient_posting`.`ID`
WHERE `sender_posting_recipient_posting`.`MAILING_ID` = 13
AND `sender_posting_recipient_posting`.`MAILING_CHAIN_ID` = 30
GROUP BY `sender_posting_recipient`.`NAME`, `sender_posting_recipient`.`EMAIL`, `sender_posting_recipient`.`ID`
ORDER BY `sender_posting_recipient`.`ID` DESC
/home/virtwww/w_vavilon-shop-com-ua_a98650c1/http/bitrix/modules/main/lib/db/mysqlconnection.php:104
#0: Bitrix\Main\DB\MysqlConnection->queryInternal(string, array, NULL)
 /home/virtwww/w_vavilon-shop-com-ua_a98650c1/http/bitrix/modules/main/lib/db/connection.php:332
#1: Bitrix\Main\DB\Connection->query(string)
 /home/virtwww/w_vavilon-shop-com-ua_a98650c1/http/bitrix/modules/main/lib/entity/query.php:1749
#2: Bitrix\Main\Entity\Query->query(string)
 /home/virtwww/w_vavilon-shop-com-ua_a98650c1/http/bitrix/modules/main/lib/entity/query.php:454
#3: Bitrix\Main\Entity\Query->exec()
 /home/virtwww/w_vavilon-shop-com-ua_a98650c1/http/bitrix/modules/main/lib/entity/datamanager.php:230
#4: Bitrix\Main\Entity\DataManager::getList(array)
 /home/virtwww/w_vavilon-shop-com-ua_a98650c1/http/bitrix/modules/sender/admin/mailing_recipient_admin.php:130
#5: require(string)
 /home/virtwww/w_vavilon-shop-com-ua_a98650c1/http/bitrix/admin/sender_mailing_recipient_admin.php:2

Примечание

Чтобы увидеть текст ошибки - изменил настройки параметров ядра
https://dev.1c-bitrix.ru/learning/course/index.php?COURSE_ID=43&LESSON_ID=2795 
а именно: 
файл bitrix\.settings.php 
в разделе exception_handling

'exception_handling' => 
  array (
    'value' => 
    array (
      'debug' => false,
      'handled_errors_types' => 4437,
      'exception_errors_types' => 4437,
      'ignore_silence' => false,
      'assertion_throws_exception' => true,
      'assertion_error_type' => 256,
      'log' => NULL,
    ),
заменил 
'debug' => false,
на
'debug' => true,

Решение

Решения пока не нашел. отправил запрос в службу поддержки Битрикса

1 комментарий:

  1. вижу ваш сайт https://vavilon-shop.com.ua жив и трудится
    може рассказать что за *косяк у ВАС был?

    ОтветитьУдалить