Magento Error Importing Products

Question

I ran into a problem while importing products in magento .
In fact, I have one Magento project with several websites.
When I start importing products using the default magento import function, I get this type of error

 "mysql error 1205 lock wait timeout exceeded try restarting transaction." 

and sometimes products are fully imported, but re-indexing takes a lot of time.

So, has any of you encountered such a problem, and if so, what should I do to solve this problem?

• I am also trying re-indexing use SSH , but still run into these kinds of errors.

Hope I get an answer very soon.

Answer 1

You probably have problems locking records on your MySQL server. Try restarting it: it automatically runs a corruption check on all tables. Let us know if this solves your problem!