We truncated the table core_url_rewrite
and deleted the files in var/locks/*
. What happened next is our server keeps using high CPU usage. See the high CPU usage below:
I restarted apache and it keeps coming back.I don't have any idea what's happening right now.
EDIT
Every year we cleaned up data by creating new website instance and we keep the old instance. Each user has a unique associated product and we have thousands of users on every year/website.
I already reindex all indexes, down the site and wait to complete the indexes. It was completed around 40 minutes because it recreates all core_url_rewrite
. I was thinking that it was completed successfully, but this high CPU usage keeps coming back.