Hello Magento Community,
I am facing issue on magento 2 during indexing. When try to index from admin panel then it shows me product price status is processing. And when I try to execute commands then it's take 10-20 min to execute and show me database error. Please see also error "SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction, query was: RENAME TABLE cataloginventory_stock_status TO cataloginventory_stock_status_outdated,cataloginventory_stock_status_replica TO cataloginventory_stock_status,cataloginventory_stock_status_outdated TO cataloginventory_stock_status_replica
process error during indexation process:"
I request magento community members to help me to fix this issue. Many Thanks
Best Regards
Haroon