For Tridion Sites 9.1 and earlier versions, how to remove unnecessary data in the state store database?
000010734|1/11/2021 3:18 PM
SDL Tridion Sites
Administrator would like to remove unnecessary data from the state store database. Administrator sees that bulk publishing will fail, be partially fail, be slow to complete, or trigger high memory consumption on CD server.
It's possible to cleanup the State Store database by using new functionality, which will periodically clean the database as stated in our documentation here.
For SDL Web 8.5 the CD_184.108.40.20638 hotfix needs to be applied.
This is already included in the Tridion Sites 9.1 release.
Only the Deployer application.properties file needs to be configured, no task scheduler or O/S cron job is needed.
Also, the administrator may not see that the records are added to the state store tables if testing. It only happens occasionally when doing high-volume publishing. As the records accumulate, then the administrator will eventually see high memory utilization and/or publishing failures. To verify if the hotfix is configured successfully, it should be sufficient to check the state store tables occasionally and see if the high memory symptoms are occurring again. If they are and there is another buildup of rows in the state store tables, then the hotfix is not working as expected and the administrator should submit a support ticket.
The hotfix will remove unneeded data from these state store tables, and is the equivalent of running these SQL commands manually.
delete from EXECUTION
delete from EXECUTION_PROPERTY
delete from PIPELINE
delete from STEP