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:"
![Screenshot 2024-01-29 1622361.png](/skins/images/DD5C9DEBA479C1E0DE707EF8566B3BC0/responsive_peak/images/image_unmoderated.gif)
I request magento community members to help me to fix this issue. Many Thanks
Best Regards
Haroon