search

canadasatellite-ca / site

The canadasatellite.ca website (Magento 2)
https://upwork.com/fl/mage2pro
0 stars 1 forks source link

«Memory size allocated for the temporary table is more than 20% of innodb_buffer_pool_size» for `Magento\Catalog\Model\Indexer\Product\Eav\Action\Full` #69

Closed dmitrii-fediuk closed 3 years ago

dmitrii-fediuk commented 3 years ago

Similar to https://github.com/canadasatellite-ca/site/issues/47

{
    "channel": "main",
    "datetime": {
        "date": "2021-04-01 09:00:47.183560",
        "timezone_type": 3,
        "timezone": "UTC"
    },
    "level": 300,
    "level_name": "WARNING",
    "Mage2.PRO": [
        {
            "Command": "bin/magento indexer:reindex",
            "mage2pro/core": "7.2.6",
            "Magento": "2.3.5-p2",
            "PHP": "7.2.34-8+ubuntu16.04.1+deb.sury.org+1"
        }
    ],
    "message": "Memory size allocated for the temporary table is more than 20% of innodb_buffer_pool_size. Please update innodb_buffer_pool_size or decrease batch size value (which decreases memory usages for the temporary table). Current batch size: 1000; Allocated memory size: 864000000 bytes; InnoDB buffer pool size: 4294967296 bytes."
}
Location:    vendor/mage2pro/core/Framework/Logger/Handler.php:55
Callee:      df_log_l
*****************1******************
Location:    vendor/monolog/monolog/src/Monolog/Logger.php:344
Callee:      Df\Framework\Logger\Handler::handle
*****************2******************
Location:    vendor/magento/framework/Logger/Monolog.php:48
Callee:      Monolog\Logger::addRecord
*****************3******************
Location:    vendor/monolog/monolog/src/Monolog/Logger.php:684
Callee:      Magento\Framework\Logger\Monolog::addRecord
*****************4******************
Location:    vendor/magento/framework/Indexer/BatchSizeManagement.php:57
Callee:      Monolog\Logger::warning
*****************5******************
Location:    vendor/magento/module-catalog/Model/ResourceModel/Product/Indexer/Eav/BatchSizeCalculator.php:56
Callee:      Magento\Framework\Indexer\BatchSizeManagement::ensureBatchSize
*****************6******************
Location:    vendor/magento/module-catalog/Model/Indexer/Product/Eav/Action/Full.php:131
Callee:      Magento\Catalog\Model\ResourceModel\Product\Indexer\Eav\BatchSizeCalculator::estimateBatchSize
*****************7******************
Location:    vendor/magento/module-catalog/Model/Indexer/Product/Eav.php:66
Callee:      Magento\Catalog\Model\Indexer\Product\Eav\Action\Full::execute
*****************8******************
Location:    vendor/magento/framework/Interception/Interceptor.php:58
Callee:      Magento\Catalog\Model\Indexer\Product\Eav::executeFull
*****************9******************
Location:    vendor/magento/framework/Interception/Interceptor.php:138
Callee:      Magento\Catalog\Model\Indexer\Product\Eav::___callParent
*****************10*****************
Location:    vendor/magento/framework/Interception/Interceptor.php:153
Callee:      Magento\Catalog\Model\Indexer\Product\Eav::Magento\Framework\Interception\{closure}
*****************11*****************
Location:    generated/code/Magento/Catalog/Model/Indexer/Product/Eav/Interceptor.php:26
Callee:      Magento\Catalog\Model\Indexer\Product\Eav::___callPlugins
*****************12*****************
Location:    vendor/magento/module-indexer/Model/Indexer.php:416
Callee:      Magento\Catalog\Model\Indexer\Product\Eav::executeFull
*****************13*****************
Location:    vendor/magento/module-indexer/Model/Indexer/DependencyDecorator.php:259
Callee:      Magento\Indexer\Model\Indexer::reindexAll
*****************14*****************
Location:    vendor/magento/module-indexer/Console/Command/IndexerReindexCommand.php:87
Callee:      Magento\Indexer\Model\Indexer\DependencyDecorator::reindexAll
*****************15*****************
Location:    vendor/symfony/console/Command/Command.php:255
Callee:      Magento\Indexer\Console\Command\IndexerReindexCommand::execute
*****************16*****************
Location:    vendor/symfony/console/Application.php:1009
Callee:      Symfony\Component\Console\Command\Command::run
*****************17*****************
Location:    vendor/symfony/console/Application.php:273
Callee:      Symfony\Component\Console\Application::doRunCommand
*****************18*****************
Location:    vendor/magento/framework/Console/Cli.php:115
Callee:      Symfony\Component\Console\Application::doRun
*****************19*****************
Location:    vendor/symfony/console/Application.php:149
Callee:      Magento\Framework\Console\Cli::doRun
*****************20*****************
Location:    bin/magento:23
Callee:      Symfony\Component\Console\Application::run
dmitrii-fediuk commented 3 years ago

It is occured again:

{
    "channel": "main",
    "datetime": {
        "date": "2021-05-01 09:02:23.726020",
        "timezone_type": 3,
        "timezone": "UTC"
    },
    "level": 300,
    "level_name": "WARNING",
    "Mage2.PRO": [
        {
            "Command": "bin/magento indexer:reindex",
            "mage2pro/core": "7.4.0",
            "Magento": "2.3.5-p2",
            "PHP": "7.2.34-8+ubuntu16.04.1+deb.sury.org+1"
        }
    ],
    "message": "Memory size allocated for the temporary table is more than 20% of innodb_buffer_pool_size. Please update innodb_buffer_pool_size or decrease batch size value (which decreases memory usages for the temporary table). Current batch size: 1000; Allocated memory size: 864000000 bytes; InnoDB buffer pool size: 4294967296 bytes."
}
Location:    vendor/mage2pro/core/Framework/Logger/Handler.php:55
Callee:      df_log_l
*****************1******************
Location:    vendor/monolog/monolog/src/Monolog/Logger.php:344
Callee:      Df\Framework\Logger\Handler::handle
*****************2******************
Location:    vendor/magento/framework/Logger/Monolog.php:48
Callee:      Monolog\Logger::addRecord
*****************3******************
Location:    vendor/monolog/monolog/src/Monolog/Logger.php:684
Callee:      Magento\Framework\Logger\Monolog::addRecord
*****************4******************
Location:    vendor/magento/framework/Indexer/BatchSizeManagement.php:57
Callee:      Monolog\Logger::warning
*****************5******************
Location:    vendor/magento/module-catalog/Model/ResourceModel/Product/Indexer/Eav/BatchSizeCalculator.php:56
Callee:      Magento\Framework\Indexer\BatchSizeManagement::ensureBatchSize
*****************6******************
Location:    vendor/magento/module-catalog/Model/Indexer/Product/Eav/Action/Full.php:131
Callee:      Magento\Catalog\Model\ResourceModel\Product\Indexer\Eav\BatchSizeCalculator::estimateBatchSize
*****************7******************
Location:    vendor/magento/module-catalog/Model/Indexer/Product/Eav.php:66
Callee:      Magento\Catalog\Model\Indexer\Product\Eav\Action\Full::execute
*****************8******************
Location:    vendor/magento/framework/Interception/Interceptor.php:58
Callee:      Magento\Catalog\Model\Indexer\Product\Eav::executeFull
*****************9******************
Location:    vendor/magento/framework/Interception/Interceptor.php:138
Callee:      Magento\Catalog\Model\Indexer\Product\Eav::___callParent
*****************10*****************
Location:    vendor/magento/framework/Interception/Interceptor.php:153
Callee:      Magento\Catalog\Model\Indexer\Product\Eav::Magento\Framework\Interception\{closure}
*****************11*****************
Location:    generated/code/Magento/Catalog/Model/Indexer/Product/Eav/Interceptor.php:26
Callee:      Magento\Catalog\Model\Indexer\Product\Eav::___callPlugins
*****************12*****************
Location:    vendor/magento/module-indexer/Model/Indexer.php:416
Callee:      Magento\Catalog\Model\Indexer\Product\Eav::executeFull
*****************13*****************
Location:    vendor/magento/module-indexer/Model/Indexer/DependencyDecorator.php:259
Callee:      Magento\Indexer\Model\Indexer::reindexAll
*****************14*****************
Location:    vendor/magento/module-indexer/Console/Command/IndexerReindexCommand.php:87
Callee:      Magento\Indexer\Model\Indexer\DependencyDecorator::reindexAll
*****************15*****************
Location:    vendor/symfony/console/Command/Command.php:255
Callee:      Magento\Indexer\Console\Command\IndexerReindexCommand::execute
*****************16*****************
Location:    vendor/symfony/console/Application.php:1009
Callee:      Symfony\Component\Console\Command\Command::run
*****************17*****************
Location:    vendor/symfony/console/Application.php:273
Callee:      Symfony\Component\Console\Application::doRunCommand
*****************18*****************
Location:    vendor/magento/framework/Console/Cli.php:115
Callee:      Symfony\Component\Console\Application::doRun
*****************19*****************
Location:    vendor/symfony/console/Application.php:149
Callee:      Magento\Framework\Console\Cli::doRun
*****************20*****************
Location:    bin/magento:23
Callee:      Symfony\Component\Console\Application::run
dmitrii-fediuk commented 3 years ago

It is occured again:

{
    "channel": "main",
    "datetime": {
        "date": "2021-05-13 09:01:33.741248",
        "timezone_type": 3,
        "timezone": "UTC"
    },
    "level": 300,
    "level_name": "WARNING",
    "Mage2.PRO": [
        {
            "Command": "bin/magento indexer:reindex",
            "mage2pro/core": "7.4.1",
            "Magento": "2.3.5-p2",
            "PHP": "7.2.34-8+ubuntu16.04.1+deb.sury.org+1"
        }
    ],
    "message": "Memory size allocated for the temporary table is more than 20% of innodb_buffer_pool_size. Please update innodb_buffer_pool_size or decrease batch size value (which decreases memory usages for the temporary table). Current batch size: 1000; Allocated memory size: 864000000 bytes; InnoDB buffer pool size: 4294967296 bytes."
}
Location:    vendor/mage2pro/core/Framework/Logger/Handler.php:55
Callee:      df_log_l
*****************1******************
Location:    vendor/monolog/monolog/src/Monolog/Logger.php:344
Callee:      Df\Framework\Logger\Handler::handle
*****************2******************
Location:    vendor/magento/framework/Logger/Monolog.php:48
Callee:      Monolog\Logger::addRecord
*****************3******************
Location:    vendor/monolog/monolog/src/Monolog/Logger.php:684
Callee:      Magento\Framework\Logger\Monolog::addRecord
*****************4******************
Location:    vendor/magento/framework/Indexer/BatchSizeManagement.php:57
Callee:      Monolog\Logger::warning
*****************5******************
Location:    vendor/magento/module-catalog/Model/ResourceModel/Product/Indexer/Eav/BatchSizeCalculator.php:56
Callee:      Magento\Framework\Indexer\BatchSizeManagement::ensureBatchSize
*****************6******************
Location:    vendor/magento/module-catalog/Model/Indexer/Product/Eav/Action/Full.php:131
Callee:      Magento\Catalog\Model\ResourceModel\Product\Indexer\Eav\BatchSizeCalculator::estimateBatchSize
*****************7******************
Location:    vendor/magento/module-catalog/Model/Indexer/Product/Eav.php:66
Callee:      Magento\Catalog\Model\Indexer\Product\Eav\Action\Full::execute
*****************8******************
Location:    vendor/magento/framework/Interception/Interceptor.php:58
Callee:      Magento\Catalog\Model\Indexer\Product\Eav::executeFull
*****************9******************
Location:    vendor/magento/framework/Interception/Interceptor.php:138
Callee:      Magento\Catalog\Model\Indexer\Product\Eav::___callParent
*****************10*****************
Location:    vendor/magento/framework/Interception/Interceptor.php:153
Callee:      Magento\Catalog\Model\Indexer\Product\Eav::Magento\Framework\Interception\{closure}
*****************11*****************
Location:    generated/code/Magento/Catalog/Model/Indexer/Product/Eav/Interceptor.php:26
Callee:      Magento\Catalog\Model\Indexer\Product\Eav::___callPlugins
*****************12*****************
Location:    vendor/magento/module-indexer/Model/Indexer.php:416
Callee:      Magento\Catalog\Model\Indexer\Product\Eav::executeFull
*****************13*****************
Location:    vendor/magento/module-indexer/Model/Indexer/DependencyDecorator.php:259
Callee:      Magento\Indexer\Model\Indexer::reindexAll
*****************14*****************
Location:    vendor/magento/module-indexer/Console/Command/IndexerReindexCommand.php:87
Callee:      Magento\Indexer\Model\Indexer\DependencyDecorator::reindexAll
*****************15*****************
Location:    vendor/symfony/console/Command/Command.php:255
Callee:      Magento\Indexer\Console\Command\IndexerReindexCommand::execute
*****************16*****************
Location:    vendor/symfony/console/Application.php:1009
Callee:      Symfony\Component\Console\Command\Command::run
*****************17*****************
Location:    vendor/symfony/console/Application.php:273
Callee:      Symfony\Component\Console\Application::doRunCommand
*****************18*****************
Location:    vendor/magento/framework/Console/Cli.php:115
Callee:      Symfony\Component\Console\Application::doRun
*****************19*****************
Location:    vendor/symfony/console/Application.php:149
Callee:      Magento\Framework\Console\Cli::doRun
*****************20*****************
Location:    bin/magento:23
Callee:      Symfony\Component\Console\Application::run
dmitrii-fediuk commented 3 years ago

It is because the /canadasatellite/core package has not yet been updated to 0.1.9.