Reported on Community Beta Program: https://dev.liferay.com/web/liferay-7.1-community-beta-program/feedback/-/message_boards/message/1690513
Steps to Reproduce:
- Download sample database from: https://ftp.liferay.com/lr71_upgrade.sql.zip
- Import sample database with a number of entries similar to the community site.
- Attempt upgrade to Liferay 7.1 Alpha 2
Expected Result: Upgrade completes successfully
Actual Result: Upgrade hangs during VerifyResourcePermissions step.
The issue can be traced back to this commit: https://github.com/liferay/liferay-portal/commit/387044544ae67e6be2ce659c66aa4badf9628106.
The upgrade process hangs on the left join in the query in the code. If I revert the code back to not having a left join the upgrade completes fine.