Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Errors during Dequeue operation are not reporting the correct query in the exception message #1

Open
claytona-armstrong5 opened this issue Dec 27, 2017 · 0 comments
Assignees
Labels

Comments

@claytona-armstrong5
Copy link

While investigating an issue that we are sometimes experiencing, I noticed there seems to be a bug in the "GetMessage" method of SqlQueue.

If there is an exception, it is reporting that the query it was attempting to run was "_createQuery".
But that one is the query for creating the queue.
The query it was trying to run was actually dynamic, based on "Script.QueueDequeue"

The exception message also reports the query as "RawQuery", presumably because that class does not override the ToString() method? (Although this issue may be moot once the above was fixed?)

As an example of what I mean, we sometimes get the below error:

Shuttle.Esb.Sql.Queue.SqlQueue.Error - Could not dequeue message from queue 'sql://messaging/payments-work'. Exception: A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.). Query: Shuttle.Core.Data.RawQuery

(The root cause of that error is a different matter... we are occasionally seeing very strange behaviour; it appears like successful messages from the past are getting reprocessed. I might log a separate issue for that)

@eben-roux eben-roux self-assigned this Dec 27, 2017
@eben-roux eben-roux added the bug label Dec 27, 2017
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants