search

Particular / ServiceControl

Backend for ServiceInsight and ServicePulse
https://docs.particular.net/servicecontrol/
Other
53 stars 47 forks source link

Error instance does not create subscription table when used with SQL Transport #3676

Open mikeminutillo opened 1 year ago

mikeminutillo commented 1 year ago

Describe the bug

Description

When using SQL Transport, the native pub-sub Subscription table is not created, which means that the endpoints need to enable backwards compatibility mode in order to subscribe to ServiceControl integration events.

Expected behavior

The pub-sub Subscription table should be created

Actual behavior

The pub-sub Subscription table is not created.

Versions

Please list the version of the relevant packages or applications in which the bug exists.

Steps to reproduce

  1. Create a new instance of ServiceControl targeting SQL Transport using ServiceControl Management or the Powershell installers
  2. Review the tables created as part of installation. The Subscription table is not created.

Relevant log output

No response

Additional Information

Workarounds

  1. Manually create the subscriptions table
  2. Use installers on any endpoint with the SQL Transport.
  3. Enable message-driven compatibility mode in endpoints that need to subscribe to ServiceControl integration events.

Possible solutions

Additional information

The issue seems to be the way that SQL Transport creates the subscription table. It is done via an installer and not with the queue tables. ServiceControl does not enable installers (although perhaps it should).

danielmarbach commented 1 year ago

We've reviewed the issue and added it to our backlog. It's eligible to be picked up for a future release, but we can't provide a firm timeline.