Welcome Guest ( Log In | Register )

Bump Topic Topic Closed RSS Feed

Outline · [ Standard ] · Linear+

 deadlock error

views
     
TScubiclecarbonate
post Jun 21 2017, 01:10 PM, updated 9y ago

On my way
****
Junior Member
558 posts

Joined: Jul 2011


mySQL query error: INSERT INTO ibf_reply_tracker
(subject_id, topic_id, post_id, count, type)
SELECT member_id, topic_id, 85365350, 1, 'reply'
FROM ibf_tracker
WHERE topic_id = 3943906
AND member_id != 529695
ON DUPLICATE KEY UPDATE count = count + 1

mySQL error: Deadlock found when trying to get lock; try restarting transaction
mySQL error code:
Date: Wednesday 21st 2017f June 2017 01:03:02 PM
digital_ice7
post Jun 21 2017, 03:17 PM

New Member
*
Junior Member
6 posts

Joined: Dec 2004
From: Kuala Lumpur


to avoid this use can use with(nolock)...

https://www.mssqltips.com/sqlservertip/2470...er-nolock-hint/
https://stackoverflow.com/questions/686724/...use-with-nolock

Topic ClosedOptions
 

Change to:
| Lo-Fi Version
0.0154sec    0.83    5 queries    GZIP Disabled
Time is now: 22nd December 2025 - 10:55 AM