Could not insert a query in SQL server

Question

I came around some weird thing in MS SQL server. I have two tables in my Database : "LogAnalyzer"

1> LogData

2> TestLogData

LogData contains around 9200192 rows and testLogdata around 1000 rows.

When I tried inserting a row in LogData it was taking like 10 minutes and still not inserting it .. It was just showing Executing Query

When I tried inserting a row in testLogData it did immediately.

Even when I connected the database through Java code it was behaving the same and I have properly closed the connection (I think)...

All worked fine after restarting the SQL server .. I dont know why this happened. As it was working all fine till now.

Please can anyone suggest the causes for this. I do not think its the size of the table because it worked fine after restart. (Query inserted immediately).

@dasblinkenlight - Sounds like blocking rather than deadlocks. deadlock would be detected and a transaction rolled back with an error message. — Martin Smith
– Martin Smith, Commented Jun 25, 2012 at 10:12
@RishiRanka - Most likely another open transaction holding a lock. Now you have restarted SQL Server will be impossible to tell unless it recurs. If this happens again look at sys.dm_os_waiting_tasks — Martin Smith
– Martin Smith, Commented Jun 25, 2012 at 10:18

Mark Gittoes · Accepted Answer · 2012-06-25 13:57:00Z

1

Please can anyone suggest the causes for this.

A possible cause is that your connection is being blocked by another connection which has a transaction open on the table that the blocked connection is trying to access.

Now that SQL Server has been restarted you can't perform any diagnostics to find the cause but if it happens again then you could run sp_who2 to see a list of connections and check the BlkBy column to see if your connection is blocked. If your connection is blocked then you can get the SPID of the blocking process and use kill to terminate the blocking process.

answered Jun 25, 2012 at 13:57

Mark Gittoes

1313 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Could not insert a query in SQL server

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related