I am currently running Magento 2.1.7 and imported data from Magento 1.8.0. The process went smoothly but after installing some extensions, it appears that some of the reindex tables have been deleted. This is the message I get when trying to reindex:
Table design_config_dummy_cl does not exist
Table customer_dummy_cl does not exist
Table catalog_category_product_cl does not exist
Table catalog_product_category_cl does not exist
Table catalog_product_price_cl does not exist
Table catalog_product_attribute_cl does not exist
Table cataloginventory_stock_cl does not exist
Table catalogrule_rule_cl does not exist
Table catalogrule_product_cl does not exist
Table catalogsearch_fulltext_cl does not exist
Search Spell-Correction index has been rebuilt successfully in 00:00:02
Even after using the reset function then reindexing, the process is stuck:
Design Config Grid index is locked by another reindex process. Skipping.
Customer Grid index is locked by another reindex process. Skipping.
Category Products index is locked by another reindex process. Skipping.
Product Categories index is locked by another reindex process. Skipping.
Product Price index is locked by another reindex process. Skipping.
Product EAV index is locked by another reindex process. Skipping.
Stock index is locked by another reindex process. Skipping.
Catalog Rule Product index is locked by another reindex process. Skipping.
Catalog Product Rule index is locked by another reindex process. Skipping.
Catalog Search index is locked by another reindex process. Skipping.
Search Spell-Correction index has been rebuilt successfully in 00:00:02
Is there a way to resolve this issue?