Microsoft Orleans production setup

Question

Hello,

I am using the instructions in section "Reliable production deployment using SQL Server" (https://learn.microsoft.com/en-us/dotnet/orleans/host/configuration-guide/typical-configurations) in combination with the database creation scripts of https://learn.microsoft.com/en-us/dotnet/orleans/host/configuration-guide/adonet-configuration. When I run the application an exception with the message "Not all required queries found. Missing are: CleanupDefunctSiloEntriesKey" is raised. The question now is whether the provided SQL scripts are not up to date or where the error lies.

BR
Thomas

Answer 1

Hi,

"Not all required queries found. Missing are: CleanupDefunctSiloEntriesKey"
The question now is whether the provided SQL scripts are not up to date or where the error lies.

You are using the tag sql-server-general but the error is not from the SQL Server but from your application side. You better change the tag of the thread to something which better fit like the language which you are using, or even better might be to ask the question here:

https://github.com/dotnet/orleans/issues/

There are multiple discussions there which Google find for me with the same structure of "Not all required queries found. Missing are:"

Answer 2

Hi, I found a script which works fine for me here https://github.com/dotnet/orleans/blob/main/src/AdoNet/Orleans.Clustering.AdoNet/Migrations/SQLServer-Clustering-3.7.0.sql

Answer 3

I'm having the same problem after upgrading to version 7, using Oracle database. I can't find the script to create the query for the CleanupDefunctSiloEntriesKey key.