On one of three CD servers every search we execute is sent to Azure Search like the following:
19660 02:11:05 INFO AzureSearch Query [sitecore_web_index]: &search=This_Is_Equal_ConstNode_Return_Nothing
I have confirmed that...
- There are no significant differences in any of the config files between this server and the other CD servers
- The only differences are database/redis connection strings and the
ApplicationInsights.Role
setting value
- The only differences are database/redis connection strings and the
- There are no differences in the bin directories between this server and the other CD servers
I have tried (unsuccessfully)...
- Switching this server to use another CD server's web database
- Restarting the server
To narrow down the issue, I also tried opening the same page in Experience Editor on the CM server and changing the sc_database
in the query string to use the web database of the offending CD server. In this case, all of the searches work as expected. This leads me to believe the database is not the issue.
Environment
- Sitecore 9.0.2
- Azure PaaS