orleans
orleans copied to clipboard
Add missing query CleanupDefunctSiloEntriesKey to MySQL-Clustering
Problem:
As written in the issue https://github.com/dotnet/orleans/issues/8676 and docs, to set up ADO.NET clustering using the MySQL you need to run 2 scripts in sequence:
main script for MySQL clustering script for MySQL However, the clustering script does not include the creation of the CleanupDefunctSiloEntriesKey query required by the ADO.NET implementation (Microsoft.Orleans.Clustering.AdoNet) in both the 7.2.x and the 8.0.x versions of Orleans.
Missing query causes an exception at program startup.
Proposed solution:
Add the missing query to clustering sql script.
Followed the same pattern as proposed in https://github.com/dotnet/orleans/pull/8811