Skip to content

End Conversation logs an error "database is closed" #813

@vivekburman

Description

@vivekburman

Describe the bug

As per MS documentation https://learn.microsoft.com/en-us/sql/t-sql/statements/end-conversation-transact-sql?view=sql-server-ver17 both parties must call END Conversation due to this, when the consumer gets notified with messageType "http://schemas.microsoft.com/SQL/ServiceBroker/EndDialog" and tries to call END Conversation from its side, an error "database is closed is returned"

To Reproduce

Have a Producer and Consumer for Service Broker and call End Conversation from both sides after completion.

Expected behavior
Either its an expected behavior and user must handle this case as an exceptional case not log it as error. Or the error message shouldn't be returned.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions