orleans icon indicating copy to clipboard operation
orleans copied to clipboard

Add missing query CleanupDefunctSiloEntriesKey to MySQL-Clustering

Open juan-arias opened this issue 1 year ago • 1 comments

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

Microsoft Reviewers: Open in CodeFlow

juan-arias avatar Mar 07 '24 01:03 juan-arias