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
Conteúdo Excluesivo para Assinantes
Uma Subscrição do Liferay Enterprise fornece acesso a mais de 1.500 artigos que incluem práticas recomendadas, solução de problemas e outras soluções valiosas. Faça login para obter acesso completo.
Entrar