Magento 2 After Migration innodb_buffer_pool_size error

[Aveeva]

How to solve the following error,

main.WARNING: 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: 556; Allocated memory size: 28022400 bytes; InnoDB buffer pool size: 134217728 bytes. [] []

Reindex issue, No such entity error.

[Nishu Jindal]

Hi @Aveeva,

Can you please check below link for your error:

https://magento.stackexchange.com/questions/207457/magento-2-please-update-innodb-buffer-pool-size-o...

Hope this helps you!

Problem Solved! Click Kudos & Accept as Solution!

[Aveeva]

@Nishu Jindal  After update size, getting the same issue,

Path: app/code/Magento/Catalog/etc/di.xml

    <type name="Magento\Catalog\Model\ResourceModel\Product\Indexer\Price\BatchSizeCalculator">
        <arguments>
            <argument name="batchRowsCount" xsi:type="array">
                <item name="default" xsi:type="number">100000</item>
            </argument>
            <argument name="estimators" xsi:type="array">
                <item name="default" xsi:type="object">Magento\Catalog\Model\Indexer\Price\BatchSizeManagement</item>
            </argument>
        </arguments>
    </type>

    <type name="Magento\Catalog\Model\Indexer\Category\Product\Action\Full">
        <arguments>
            <argument name="batchRowsCount" xsi:type="number">100000</argument>
            <argument name="batchSizeManagement" xsi:type="object">Magento\Catalog\Model\Indexer\CategoryProductBatchSize</argument>
        </arguments>
    </type>

After update size then run,

1)  rm -rf var/di/* var/generation/* var/cache/* var/log/* var/page_cache/* var/session/* var/view_preprocessed/* pub/static/*
2)  php bin/magento setup:upgrade
3)  php bin/magento setup:di:compile
4) php bin/magento setup:static-content:deploy -f

5)  php bin/magento indexer:reset

6)  php bin/magento indexer:reindex
7)  php bin/magento cache:clean

8)  php bin/magento cache:flush

How to solve this error?

Note : etc/my.cnf => innodb_buffer_pool_size = 4084M

[Nishu Jindal]

Hi @Aveeva,

Can you check below link for editing my.cnf file

https://www.inmotionhosting.com/support/website/databases/edit-mysql-my-cnf/

Hope this helps you!

Problem Solved! Click Kudos & Accept as Solution!

[Aveeva]

@Nishu Jindal  my.cnf file :

# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html

[mysqld]
#
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
#innodb_buffer_pool_size = 1G
innodb_buffer_pool_size = 4084M
#
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
#
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
innodb_file_per_table = 0
wait_timeout = 28800

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

after restart MySQL still getting the same issue.

Error Screenshot :

https://snipboard.io/2RsPWH.jpg

[Nishu Jindal]

Hi @Aveeva ,

Can you check below link for your issue:

https://github.com/magento/magento2/issues/10091

https://magento.stackexchange.com/questions/106793/magento-2-reindex-returns-no-such-entity

Hope this helps you!

Problem Solved! Click Kudos & Accept as Solution!

[Aveeva]

@Nishu Jindal From Github,  

SOLVED:
There was 1 store on 'stores' table that was relating with an 'store_group' that wasn´t there. Changed the ID and reindex worked fine

My table : SELECT * FROM store_group

Screenshot : https://snipboard.io/ZEHxA3.jpg

What is the error in this?

[Nishu Jindal]

Hi @Aveeva,

Can you please share the stores table screenshot as well. 

Thanks!

[Aveeva]

@Nishu Jindal Store screenshot: https://snipboard.io/mtcjSY.jpg

[Nishu Jindal]

HI @Aveeva ,

Please check in your store table there is one column named as group_id having values like(0,1,3,4,5,6..) But we don't have group_id value in store_group table corresponding to (3,5,6,7).

Please change the Ids or remove them from the store table as I can see these stores are not active at all.

Please take before of database before doing any operation.

 Hope this helps you!

Problem Solved! Click Kudos & Accept as Solution!