Collecting Solr based search-related MustGather data for search cache invalidation issues
Prepare the following MustGather information before you call HCL Support to help with the troubleshooting process.
Procedure
-
Configure the following trace specifications.
- In the Search server Docker container:
For information about how to set trace strings, Configuring logging for the Search server.*=info:com.ibm.commerce.foundation.*=all: com.ibm.commerce.search.*=all: org.apache.solr.*=all: com.ibm.commerce.solr.*=all
For information about how to configure trace strings, see - In the Search server Docker container:
-
Reproduce the problem.
Record the specific steps that you used to reproduce the problem and any details that might be relevant.
-
Run the following database queries to collect the necessary information from your database
(output results in CSV format).
SELECT * FROM CACHEIVL WHERE INSERTTIME > (PLS SET TO some time before current time as the table is very big)
Note: To monitor cache content or run cache invalidation instance, see Enabling cache monitoring.