Error Encountered: Upgrade Process Stuck

[victor]

- How long does the process shown in your screenshot take? Does it terminate with some kind of error or are you just stopping the process yourself? Since the size of your database is extremely large, depending on the capacity of your server, the Rebuild process may take a very long time.
- Are there any errors in the EspoCRM logs other than the one you started the thread with?
- When the terminal window stuck, open another terminal window > login to the database > run:

show processlist;

- Send a screenshot to the forum, like:

[sapyantuk]

victor

Please check this

[sapyantuk]

Please check this

[sapyantuk]

create index IDX is taking a lot of time

[sapyantuk]

[2024-04-26 04:18:57] ALERT: Rebuild database error: An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'IDX_TYPE'
[2024-04-26 04:18:57] ALERT: Rebuild database error: An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'IDX_TYPE'
[2024-04-26 04:22:34] ALERT: Rebuild database error: An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'IDX_TARGET_TYPE'
[2024-04-26 04:22:34] ALERT: Rebuild database error: An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'IDX_TARGET_TYPE'
[2024-04-26 04:26:40] ALERT: Rebuild database error: An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'IDX_PARENT_ID'
[2024-04-26 04:26:40] ALERT: Rebuild database error: An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'IDX_PARENT_ID'
[2024-04-26 04:26:40] ERROR: (500) Error while rebuilding database. See log file for details.; POST /Admin/rebuild; line: 136, file: /home/abc.com/public_html/application/Espo/Core/DataManager.php
[2024-04-26 04:26:40] ERROR: (500) Error while rebuilding database. See log file for details.; POST /Admin/rebuild; line: 136, file: /home/abc.com/public_html/application/Espo/Core/DataManager.php


Log

[victor]

- Try to uninstall and remove unofficial extensions and make Hard Rebuild: https://docs.espocrm.com/administrat.../#hard-rebuild.
- If Hard Rebuild is successfull, then try to upgrade your instance (without installing any extension before the upgrade).