Site down (Base table or view not found)

[dtacoll]

Hi

Im having a bit of an emergency. My site unexpectedly went down, with the following error:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'test1.catalog_product_index_price' doesn't exist

You can see what im talking about here.

http://www.dtacollectibles.com/new-arrival

Please help as I am currently losing sales. 

Thanks!

-Tyler

[Gabriel Guarino · Accepted solution]

Hi @dtacoll,

I am sorry you are experiencing that critical issue on your website.

As you can see in the error message, that table is missing in your database.

Do you have a recent database backup to restore?

Regards.
Gabriel

[dtacoll]

Hi,

I was able to fix the issue by restoring the table, and restarting MySQL.

Thanks!

[liquidia]

Hello @dtacoll  Can you please explain how did you restore ted that table? I am getting following error 

"base table or view not found: 1932 table '.catalog_product_index_price replica'

P.S:Using magento 2.3.3