Reindex catalog_url always search for SELECT core_url_rewrite.* FROM core_url_rewrite WHERE (store_id = '1') AND (request_path = '-')

[matteotestoni]

Preconditions (*)

1. openmage 20.10.2
2. /opt/plesk/php/8.0/bin/php -d memory_limit=-1 shell/indexer.php --reindex catalog_url
3. same with php 8.2
4. if i watch queries always search for SELECT core_url_rewrite.* FROM core_url_rewrite WHERE (store_id = '1') AND (request_path = '-')

Steps to reproduce (*)

1. go to ssh
2. launch opt/plesk/php/8.0/bin/php -d memory_limit=-1 shell/indexer.php --reindex catalog_url

Expected result (*)

1. [Screenshots, logs or description]
2. reindex core_url_rewrite

Actual result (*)

1. reindex stuck
2. core_url_rewrite empty and never populated

[TangLiang]

try to TRUNCATE the core_url_rewrite table first and do the reindex again.