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

Question

question

Greg14885 asked Feb 21, '13

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-2008 stored-procedures error-message deadlock

2

10 |1200

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

askmlx121 commented · Feb 22, 2013 at 06:32 AM

http://sqltechi.blogspot.in/2013/02/identify-blocking-in-sql-server-easy-way.html Hope it may help

0 ·

Greg14885 commented · Feb 22, 2013 at 09:18 AM

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 ·

Answer 1 · 2013-02-23T14:25:41Z

Grant Fritchey answered Feb 23, '13

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

10 |1200

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

Greg14885 commented · Feb 25, 2013 at 09:23 AM

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 ·

question