Magento 2.3 - Theme Configuration mismatch after migration from magento 1.9 multi-store website?

[Aveeva]

After migration, my multi-store website to Magento 2.3.4 Back-end working good all data migrated successfully my theme completely collapsed getting following error,

Following are my errors after migration,

Frond-end error :

1. https://snipboard.io/Dw47EM.jpg

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

System.log:

https://justpaste.it/5ry3a

Debug.log:

https://justpaste.it/42t47

Try lots of combinations to solve the issue, still facing the issue.

Server details: Localhost - Centos 7, Nginx, Magento 2.3.4, paid theme (http://www.codazon.com/document/fastest/magento2/index.html)

[Bhanu Periwal]

Hi @Aveeva 

For issue "Memory size allocated for the temporary table is more than " kindly refer below url:
https://magento.stackexchange.com/questions/207457/magento-2-please-update-innodb-buffer-pool-size-o... 

Regarding message "main.DEBUG: cache_invalidate":

It is in not an error.

It looks like there is no way to disable those debug messages for now:
https://github.com/magento/magento2/issues/4362

Also the "Cache Invalidated" notification in magento admin panel is not an error.

You should not refresh your cache every minute.

The same way as you do not refresh your web browser cache every minute.

If you don't need caching just disable it.

If issue resolve, please click on 'Kudos' & Accept as Solution!

[Aveeva]

@Bhanu Periwal  

Decrease batch size:

Path: /magentoRoot/vendor/magento/module-catalog/etc/di.xml

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

after that i will get following error, system.log => justpaste.it/4zc1e debug.log => justpaste.it/2l866

[Bhanu Periwal]

Hi @Aveeva 

Kindly refer below link to resolve "Broken reference: the 'catalog.compare.sidebar" :

https://github.com/magento/data-migration-tool/issues/452

If issue resolve, please click on 'kudos' & Accept as Solution!