Invalid SPID nnn specified when logging to a table

[genetsmartx]

Invalid SPID nnn specified when logging to a table

[erikdarlingdata]

Hi Gene,

The whole point of the empty catch block is to discard any errors like the one you're seeing:

This throw an error:
DBCC INPUTBUFFER(32767);

But this doesn't:

BEGIN TRY
    DBCC INPUTBUFFER(32767);
END TRY;
BEGIN CATCH
END CATCH;

So it seems odd that it would still bubble up at all. Are you sure you've got this tracked down correctly?

Thanks!

[genetsmartx]

Hey Erik,
Thanks for the explanation on the CATCH. I get it. Most of the time the call works to log to the table. During the early morning hours we go through some heavy data loading and monitor for thread pool, disk latency etc.

But at the time of some of the failures/errors, we were sitting pretty. Batch requests down. Memory and CPU at baseline.

The only thing that would cause this error is the INPUTBUFFER call. Not sure why it surfaces but that seems like the cause inside sp_WhoIsActive.

We run it every 20 seconds so perhaps the DELETE is running when the next call starts. But the job should finish the INSERT and the DELETE and end solidly. Then the new iteration should start.

I am willing to take any suggestions to "track it down correctly"

I think maybe wrapping the call to log it in a transaction might help.

[erikdarlingdata]

Hi Gene,

Sorry for over-explaining. You seemed surprised by the empty catch block, so I figured I'd throw it out there.

This is a tough one to take on, because a lot of issues that get reported as bugs here come down to a variety of local factors that are impossible to reproduce outside of a particular user environment/setup.

If you come up with a code fix on your end that solves the problem, you can submit a PR for review. I don't have the bandwidth to either try to reproduce the issue, or make shot-in-the-dark code changes and await feedback.

Thanks,
Erik

[genetsmartx]

Yes I was indeed surprised. Thank you for that Erik. I understand completely. Thank you. I will see if I can solve it. Will submit a PR if I find an answer. Thank you.