orleans icon indicating copy to clipboard operation
orleans copied to clipboard

CleanupDefunctSiloEntries key insert is missing in sql files

Open ka4ep opened this issue 2 years ago • 11 comments

I've created a new fresh Sql Server database, have run all the System.Data.SqlClient invariant queries for that database from the manual page https://learn.microsoft.com/en-us/dotnet/orleans/host/configuration-guide/adonet-configuration. Program is configured to use it for storage, clustering and reminders; all the nuget packages are 7.0.0. During silo start all of a sudden I've caught an exception:

System.ArgumentException: Not all required queries found. Missing are: CleanupDefunctSiloEntriesKey
   at Orleans.Clustering.AdoNet.Storage.DbStoredQueries..ctor(Dictionary`2 queries) in /_/src/AdoNet/Shared/Storage/DbStoredQueries.cs:line 39
   at Orleans.Clustering.AdoNet.Storage.RelationalOrleansQueries.CreateInstance(String invariantName, String connectionString) in /_/src/AdoNet/Shared/Storage/RelationalOrleansQueries.cs:line 71
   at Orleans.Runtime.MembershipService.AdoNetClusteringTable.InitializeMembershipTable(Boolean tryInitTableVersion) in /_/src/AdoNet/Orleans.Clustering.AdoNet/Messaging/AdoNetClusteringTable.cs:line 37
   at Orleans.Runtime.MembershipService.MembershipTableManager.Start() in /_/src/Orleans.Runtime/MembershipService/MembershipTableManager.cs:line 170
   at Orleans.Runtime.MembershipService.MembershipTableManager.<>c__DisplayClass59_0.<<Orleans-ILifecycleParticipant<Orleans-Runtime-ISiloLifecycle>-Participate>g__OnRuntimeGrainServicesStart|0>d.MoveNext() in /_/src/Orleans.Runtime/MembershipService/MembershipTableManager.cs:line 877
--- End of stack trace from previous location ---
   at Orleans.Runtime.SiloLifecycleSubject.MonitoredObserver.OnStart(CancellationToken ct) in /_/src/Orleans.Runtime/Lifecycle/SiloLifecycleSubject.cs:line 134
   at Orleans.LifecycleSubject.OnStart(CancellationToken cancellationToken) in /_/src/Orleans.Core/Lifecycle/LifecycleSubject.cs:line 118
   at Orleans.Runtime.Scheduler.AsyncClosureWorkItem.Execute() in /_/src/Orleans.Runtime/Scheduler/ClosureWorkItem.cs:line 34
   at Orleans.Runtime.Silo.StartAsync(CancellationToken cancellationToken) in /_/src/Orleans.Runtime/Silo/Silo.cs:line 213

Indeed, OrleansQuery table does not have CleanupDefunctSiloEntries query key: image Then I've double-checked https://github.com/dotnet/orleans/tree/main/src/AdoNet and... there's no corresponding insert in any of .sql files. What should be the QueryText for CleanupDefunctSiloEntries?

ka4ep avatar Dec 07 '22 13:12 ka4ep