[pgsql-jp: 40170] update文のフリーズ

[Eiichiro Sakai]

$B%a!<%j%s%0%j%9%H3F0L(B

$B$O$8$a$^$7$F!#(B
$B<r0f$H?=$7$^$9!#(B

postgres8.3.7$B$r1?MQ$7$F$$$k$N$G$9$,!"0J2<$N$h$&$J8=>]$K(B
$BAx6x$7=u8@$r$$$?$@$-$?$/%]%9%H$5$;$F$$$?$@$-$^$7$?!#(B

$B0J2<$N$h$&$J(BSQL$B$r(Bpgpool$B-6!J(B2.1$B!K7PM3$GJ#?t$N%W%m%;%9$h$jBgNL$K<B9T$7$F$$$?$H(B
$B$3$m(B
update$BJ8!J2<5--"!K$,ESCf$G%U%j!<%:$7!"$=$N8eF1MM$N(BSQL$B$r<B9T$7$F$b(B
select for update$BJ8!J2<5--!!K$,%m%C%/BT$A$N>uBV$H$J$jBZN1$7B3$1$F$$$/>u67$H(B
$B$J$j$^$7$?!#(B

begin;
select * from tableA where id = 1;$B!J-!!K(B
$B$=$NB>$N=hM}(B
update tableA SET column = xx where id = 1;$B!J-"!K(B
commit;

$B#1!%%H%j%,$H$J$C$?(Bupdate$BJ8$N(BSQL$B%m%0$r8+$k$H(Bbind$B$^$G$O=PNO$5$l$F$$$^$9$,!"(B
$B!!!!(Bexecute$B$N%m%0$,=PNO$5$l$F$$$J$$>u67$G;_$^$C$F$7$^$C$F$$$^$9!#(B
$B!!!!$3$l$O$I$N$h$&$J;~$KH/@8$7$&$k$G$7$g$&$+!)(B
$B!!!!2sHr:v$r$4B8$8$NJ}$,$$$i$C$7$c$l$P$465<x$$$?$@$1$l$P$H;W$$$^$9!#(B

$B#2!%-"$G%U%j!<%:8e$N(Bpg_stat_activity$B$r8+$k$H%U%j!<%:$,5/$3$kA0$K<B9T$5$l$F$$(B
$B$k$,(B
$B!!!!-!$G%m%C%/BT$A$N$^$^$H$J$C$F$$$k%H%i%s%6%/%7%g%s$,B??tB8:_$7$F$$$^$7$?!#(B
$B!!!!$?$@!"%U%j!<%:$,5/$3$kA0$OB>$N$$$/$D$+$N%H%i%s%6%/%7%g%s$O ＠ 5>o=*N;!J>e5-(B
commit$B$^$G=*N;!K(B
$B!!!!$7$F$$$k>uBV$G$9!#(B
$B!!!!$3$N$3$H$h$j(Bpostgres$B$OI,$:$7$b%m%C%/MW5a$,$"$C$?=gHV$K%m%C%/<hF@(B
$B!!!!$7$F$$$k$o$1$G$O$J$$$h$&$K;W$($^$9$,M}2r$O ＠ 5$7$$$G$7$g$&$+!)(B


$B$*K;$7$$$H$3$m?=$7Lu$"$j$^$;$s$,!"2?B4$h$m$7$/$*4j$$$$$?$7$^$9!#(B

---------------------------------------
Agate Inc.
$B<r0f!!1Q0lO:(B
E-Mail$B!'(Bsakai ＠ agate-japan.com