Issue
- You might face a requirement where you need to update your database indexes, such as during an upgrade process or a database migration process
Environment
- Liferay DXP 7.0+
Resolution
- Up until Liferay DXP 7.3:
- setting the
database.indexes.update.on.startup=trueproperty in the portal-ext.properties will update the indexes for core tables such as User, ResourcePermission, etc., but not for module tables - therefore, you will have to run the
updateIndexesAllfrom the GoGo shell in order to update all indexes
- setting the
-
From Liferay DXP 7.4:
-
LPS-109189 has been implemented and so the
database.indexes.update.on.startupproperty will cover both core and module tables as well
-
LPS-109189 has been implemented and so the
- Please note that, we only delete the obsolete indexes and create the missed ones, we do not regenerate all indexes
Contenido exclusivo para suscriptores.
Una Suscripción Enterprise de Liferay proporciona acceso a más de 1.500 artículos que incluyen las mejores practicas, diagnóstico de problemas y otras soluciones útiles. Inicia sesión para tener un acceso completo.
Inicia sesión