We have a Magento 1.9.1 site with around 800k products. The core_url_rewrite table was truncated in order to get new url_rewrites after indexing.
The problem is the url_rewrite reindex is taking for 2 days already but there are no data found on the core_url_rewrite table. Also, when I open the rewrite table it shows 0-0 of 1,456,361 records found. This makes things even more complicated.
We updated the latest security patches before doing the reindex, is there any possibility that it affected the reindexing module?
Note: The server, 8 cores CPU, 30G RAM