cancel
Showing results for 
Search instead for 
Did you mean: 

Magento 2 After Migration innodb_buffer_pool_size error

Re: Magento 2 After Migration innodb_buffer_pool_size error

@Nishu Jindal  Shall i enable all store form Magento 1 then shall i migrate?  Is it right practice?

Re: Magento 2 After Migration innodb_buffer_pool_size error

Hi @Aveeva ,

 

No, we need to change the group ids of stores that are present with us. So that it will not through us No such entity error in reindexing.

 

Currently what you can do is if you don't need these stores, then take the backup of store table and delete entries that don't have matching group_id in store_group table and check whether it helps us to resolve the issue or not.

 

 

Hope this helps you!

Problem Solved! Click Kudos & Accept as Solution!

Re: Magento 2 After Migration innodb_buffer_pool_size error

@Nishu Jindal  After deleting id from store table, 

 

store group table: https://snipboard.io/XZISA7.jpg

 

store table: https://snipboard.io/O8fQ5Y.jpg

 

then run upgrade command getting following error,

 

[root@centos-4cpu-8gb-uk-lon1 giriusa]# php bin/magento setup:upgrade           
The store that was requested wasn't found. Verify the store and try again. [root@centos-4cpu-8gb-uk-lon1 giriusa]#

 

How to solve this error?

 

Re: Magento 2 After Migration innodb_buffer_pool_size error

Hi @Aveeva ,

 

Store_id 8 is also having group id as 8 please change that id to some other Id which exists (example group_id : 9).

 

Hope this helps you!

problem Solved! Click Kudos & Accept as Solution!

Re: Magento 2 After Migration innodb_buffer_pool_size error

@Nishu Jindal  Yes, now i updated.

 

store group table: https://snipboard.io/9fValB.jpg

store table: https://snipboard.io/0HwaWO.jpg

 

still, upgrade issue:

https://snipboard.io/Dg2bVs.jpg

 

Re: Magento 2 After Migration innodb_buffer_pool_size error

@Nishu Jindal Anything else i missed out?

Re: Magento 2 After Migration innodb_buffer_pool_size error

Hi @Aveeva,

Can you please run below commands on your database 

SET FOREIGN_KEY_CHECKS=0;UPDATE `store` SET store_id = 0 WHERE code='admin';UPDATE `store_group` SET group_id = 0 WHERE name='Default';UPDATE `store_website` SET website_id = 0 WHERE code='admin';UPDATE `customer_group` SET customer_group_id = 0 WHERE customer_group_code='NOT LOGGED IN';SET FOREIGN_KEY_CHECKS=1;

 Clear the cache and try to run the setup:upgrade command.

 

Hope this helps you!

Problem Solved! Click Kudos & Accept as Solution!

Re: Magento 2 After Migration innodb_buffer_pool_size error

@Nishu Jindal  Getting the same error. anything else i missed out?

Re: Magento 2 After Migration innodb_buffer_pool_size error

Hi @Aveeva ,

 

Can you check below

go to store_website into table and check which store id there that is not into store table.

 

find such a store and remove it.

 

It is happen when you migrate from magento1 and in magento 1 you deleted some store.

 

Hope this helps you!

Problem Solved! Click Kudos & Accept as Solved!

Re: Magento 2 After Migration innodb_buffer_pool_size error