Frequent SQL Server Errors
Printed From: Progarchives.com
Category: Site News, Newbies, Help and Improvements
Forum Name: Report bugs here
Forum Description: Help us improve the site from a tech standpoint
URL: http://www.progarchives.com/forum/forum_posts.asp?TID=112737
Printed Date: November 23 2024 at 23:46
Software Version: Web Wiz Forums 11.01 - http://www.webwizforums.com
Topic: Frequent SQL Server Errors
Posted By: wiz_d_kidd
Subject: Frequent SQL Server Errors
Date Posted: January 23 2018 at 08:53
|
For the last few days, I've been getting an error when trying to load some pages in PA... ------ Microsoft SQL Server Native Client 11.0 error '80004005' Transaction (Process ID 139) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. /artist.asp, line 13 ------ It usually happens when I click a link to a band page or a specific album. I have to try 2 or 3 times to reload before the page comes up. What's going on? |
Replies:
Posted By: someone_else
Date Posted: January 23 2018 at 09:12
|
The same for me, even on pages that are rarely queried. Not a showstopper, just slightly annoying. One or two retries will do. ------------- 
|
Posted By: Davesax1965
Date Posted: January 25 2018 at 06:49
|
Ex database administrator here (admittedly on Oracle, not SQL Server, same principle). This is a temporary error which should resolve itself given time. Basically, a query to a database table has failed, the table data (ie the page, a comment, whatever) ends up locked. This means that SQL Server thinks it's been looked at or updated at the moment, so the data is locked until the (supposed) update finishes. Actually, it never will as the data update has failed. Anyway, after a certain period there's a background process which resolves the lock. OR in nasty cases, it can stay locked until the next reboot. Nothing you can do about it, the database for the site won't be monitored by the ISP. Just wait. ------------- |
Posted By: Davesax1965
Date Posted: January 25 2018 at 06:50
|
Tech bumf here. https://sqlbak.com/academy/transaction-process-id-was-deadlocked-on-lock-resources-with-another-process-and-has-been-chosen-as-the-deadlock-victim-msg-1205/ ------------- |