question

Greg14885 avatar image
Greg14885 asked

Is it possible to experience "Invalid Object" errors from a deadlock?

I am currently experiencing an intermittent issue where a stored procedure called by an application returns: [Microsoft][SQL Native Client][SQL Server]Invalid object name 'dbo.MyTable'., State:S0002 I thought it could have been a permissions issue for the application but as it happens intermittently this doesn't appear likely. The proc calls many other tables which it seemingly has no problems with, although I have had some deadlock errors which is my only other idea as to what could be going on. Hope you can help, Thanks Greg
sql-server-2008stored-procedureserror-messagedeadlock
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Greg14885 avatar image Greg14885 commented ·
Hi, I'm already aware of how to identify and fix blocking. I was more interested in if this invalid object error is a symptom of blocking.
0 Likes 0 ·

1 Answer

·
Grant Fritchey avatar image
Grant Fritchey answered
My first thought is, yeah, you could experience that from a deadlock situation if you're dealing with a temporary table of some type that is no longer a part of the situation, but from your answer posted in response to @askmlx121 comment, I'm wondering if you're hitting deadlocking at all. Are you seeing deadlock errors along with this error or just this error? If it's just this error it sounds more like a security issue than a deadlock or blocking problem. And no, I wouldn't expect to see an object doesn't exist error because of blocking. Just we're level set, a block is when resource is waiting on other resources. A dead lock is when two resources each has a resource the other needs, forcing the other to wait for infinity. One is chosen as a deadlock victim and the transaction is rolled back.
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Greg14885 avatar image Greg14885 commented ·
Thanks for that, it confirms what I was thinking. No, I'm not seeing deadlock errors at the same time as the invalid object error so I think the security issue route the one I'll go down. I'll post the findings.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.