Hi
I met a deadlock when I update amounts of text-type data with multiple clients.
And there's no deadlock if I set autovacuum to off. Error messages about the
deadlock are as follows.
2021-09-14 09:18:40.392 CST [428452] ERROR: deadlock detected
2021-09-14 09:18:40.392 CST [428452] DETAIL: Process 428452 waits for ShareLock on transaction 1725; blocked by
process428455.
Process 428455 waits for ShareLock on transaction 1723; blocked by process 428452.
Process 428452: UPDATE tbl SET body = upper(body);
Process 428455: UPDATE tbl SET body = upper(body);
2021-09-14 09:18:40.392 CST [428452] HINT: See server log for query details.
2021-09-14 09:18:40.392 CST [428452] CONTEXT: while rechecking updated tuple (0,1) in relation "tbl"
2021-09-14 09:18:40.392 CST [428452] STATEMENT: UPDATE tbl SET body = upper(body);
I'm not sure if I used it inappropriately, or it's unexpected. Could someone
take a look at this problem?
Attach a script to reproduce it. It took about 2~3 minutes to run it on my
machine.
FYI, I found this problem on HEAD and I could reproduce at PG14 and PG13. I
didn't try other versions.
Regards
Tang
