microsoft / microsoft/DurableFunctionsMonitor

MSSQL backend does not use correct task hub

Open
#236 4 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

P2
Dominant language
TypeScript
Stars
290
Forks
46
Avg merge
6m
Merged PRs (30d)
1

Description

When using durable functions monitor with the MSSQL backend in the default multi-tenant configuration, the monitor seems to discover the task hubs correctly, but does not use them when querying instances.

I have a SQL server deployment with 3 task hubs, the task hubs are correctly identified:
Image

Regardless of which task hub is selected, the dbo task hub contents is shown in the list

DBO
Image

DIO
Image

Nicktest
Image


I can see the data is available by querying the table directly.

Image


If I try and navigate to an instance directly using the id from the database, I get a not found error.

Image


I'm using the docker container to run functions monitor with this command:

docker run --rm -p 8072:80 \
    -e DFM_SQL_CONNECTION_STRING='<REDACTED>' \
    -e DFM_NONCE="i_sure_know_what_i_am_doing" \
    scaletone/durablefunctionsmonitor.mssql:6.6

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start with the MSSQL backend using the supplied Docker command and the default multi-tenant configuration, then compare the selected task hub with the SQL table contents. Reproduce the list and direct-instance queries for DBO, DIO, and Nicktest; done means each selected hub shows its own instances and direct navigation finds an instance from that hub.

Written by the indexing model from the issue text.

Assessment

Tech stack
azure, sql, typescript
Domain
backend, databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.