DEV Community

Ahmed AbdElLatif
Ahmed AbdElLatif

Posted on

Solving Magento Re-indexing Error on Replica Database

A common issue that face many developers who are working on magento 2.x, is indexing error that arise when importing and existing website database to a replica website that acts as back up for the original one, which impact cron jobs.

Alt Text

A quick solution provided by magento CLI is to use the following reindexing command in magento project root:

bin/magento indexer:reindex indexer_name
Enter fullscreen mode Exit fullscreen mode

If everything was working fine so you should see this:

indexer_name has been rebuilt successfully in x time
Enter fullscreen mode Exit fullscreen mode

The other scenario is having error like this:

SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'dummy_user'@'localhost' (using password: YES), query was: "What ever SQL statement"

sample error:
Alt Text

This error indicates an issue with view "inventory_stock_1".

The issue is that the DEFINER has wrong user.

To solve this

Through phpmyadmin interface:

  1. Navigate to the required view, in our case "inventory_stock_1".
  2. Go to Structure Tab.
  3. Select Edit View

Alt Text

  1. Add the right db user name in definer field

Alt Text

Note: you can get the right username navigating from magento project root directory to app/etc/env.php.

Now hopefully you can navigate back to your magento project root directory and use rendinxing command.

A Treat

In some cases after reindxing you may face invalidated cache disclaimer like this one.

Alt Text

All you need is to click on Cache Management and select the invalidated cache(s).

Alt Text

Then choose refresh, click submit and all is fine!

Alt Text

Top comments (0)