I am getting below error every second or third day.
Exception #0 (Magento\Framework\DB\Adapter\LockWaitException): SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction, query was: INSERT INTO
customer_visitor
(customer_id
,session_id
,last_visit_at
) VALUES (?, ?, ?) Exception #1 (Zend_Db_Statement_Exception): SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction, query was: INSERT INTOcustomer_visitor
(customer_id
,session_id
,last_visit_at
) VALUES (?, ?, ?) Exception #2 (PDOException): SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
I see table customer_visitor have above 22000 records. Can we clear this table?
I also check in my staging site for same table having 12 records and it never increase records of customer visitor.
How can I cleaning up customer_visitor table log. is it creates any problems if cleaning up this table