x

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

more ▼

asked Feb 21, 2013 at 11:04 AM in Default

avatar image

Greg14885
30 1 1 6

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.

Feb 22, 2013 at 09:18 AM Greg14885
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered Feb 23, 2013 at 02:25 PM

avatar image

Grant Fritchey ♦♦
137k 20 44 81

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.

Feb 25, 2013 at 09:23 AM Greg14885
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x2188
x476
x89
x64

asked: Feb 21, 2013 at 11:04 AM

Seen: 16223 times

Last Updated: Feb 25, 2013 at 09:32 AM

Copyright 2017 Redgate Software. Privacy Policy