Duplicate key after a vacuum

Поиск
Список
Период
Сортировка
Искать

Duplicate key after a vacuum

От:
"Gaetano Mendola" <mendola@bigfoot.com>
Дата:
Hi, I already cross posted this to bug and admin but I find the message
neather in admin and in bugs, anyway I repost it:


This problem is the second time that happen, the first time
Tom Lane suggest me that may be an impromper db shut down
did this, but this time I'm sure that is not the scene.

Here is the query:

empdb=# select oid,id_user_traffic, id_user from user_traffic where id_user
= 4338;
   oid   | id_user_traffic | id_user
---------+-----------------+---------
 1438117 |           11111 |    4338
 1438117 |           11111 |    4338
 1438117 |           11111 |    4338
 1438117 |           11111 |    4338
 1438117 |           11111 |    4338
 1438117 |           11111 |    4338
 1438117 |           11111 |    4338
 1438117 |           11111 |    4338
 1438117 |           11111 |    4338
 1438117 |           11111 |    4338
 1432439 |            2884 |    4338
 1432446 |            2885 |    4338
 1432455 |            2886 |    4338
 1432987 |            6780 |    4338
 1433032 |            6781 |    4338
 1434031 |            5976 |    4338
 1435875 |            6782 |    4338
 1439351 |           11109 |    4338
 1437999 |           11110 |    4338
 1438117 |           11111 |    4338
 1438117 |           11111 |    4338
(21 rows)

empdb=# select oid,id_user_traffic,id_user from user_traffic where
id_user_traffic = 11111;
   oid   | id_user_traffic | id_user
---------+-----------------+---------
 1438117 |           11111 |    4338
(1 row)


I think that this select return one row just because Postgres know
that id_user_traffic is a primary key!


This time I know that this happen just after a vacuum, you'll find attached
the log about the
process that did the vacuum.


PS:
empdb=# select version();
                           version
-------------------------------------------------------------
 PostgreSQL 7.3.2 on i686-pc-linux-gnu, compiled by GCC 2.96
(1 row)


begin 666 f2.zip
M4$L#!!0````(`&"8GBY,,FKAS1<``'[N```&````9C(N;&]GQ5W?D]LVDGZ_
MOX)OFU2=)P3X>U)YQ'6'/F;\\/K
M[]\WDKXY5^4W#_GQF^97#VE59Z6S?U_D^KS^S4 8#_%7['19J
M[ZU+I@^4_+^&519&L I1X%W2D\D(
M_N7UN\:Y%I=!ZKQ[Z_RI./[IVU]?OGK__B^.\^OKG[]_^\MKY^5?7_[XM[^_
M=CBR?'<-X_AB7>/X//7_WFK0%Z\^#G;MX/&.3UNMLJ?[(O'
M._7'759MR_S4_,N+%RSPX(7HX7]*'[/*$?+>>?64'A^SG>/^M_/Z<*H_.^ZW
MSKOSR1%>XMX[OZ;;YE_^-\M.S?_?']]7ZG?%'5.P(ON?;]X52@GGU4_OVUE0
M?=/\]]Q,!$=I>FIPU4_"Y@<\^'"&M+I0*_A=]X>-"'T1,BF+`&7N/&.S=+D\
M?2(&72Z?KKC7Z.4QW7_^3Q/.S ZQ";) D1-Z]#Z6Q?D$C(#"!BX!"/@V,/6R4GT1'F>6G"PEU.J(I9UL,[A8D ;>M$Z+C:<=[$"#%B^"4)3%ZO"`I?)&/2QZC.SC$7".(ZB
MQ)J/V81/&.UEG\<7"]7 S]:?3]PQJXEE$:<1-.99Q02<4#;BFR D3=!PQ8*,
M:/[3NB[SAS/;<<3 "&$R;P3?12:"QUOLE&CCQ>X6.R2D'7K..+B12QMCNT^K
MBF>(2$ /'L\;(@SG[2 2R6)*B39VXC>LHY$D#='R-<&4**9'&R$_/F7*TT$[
MX,B^G4B&$KHPDL'A`]("'5DLV+EP3:(-?MU#_%&OK>.$>+%6W8<7I!&Z/ABP4H3.^@7!1S8
MXZ1-@MDE@6D$SZX1? ,CZ%8$#T4-:!ND!T _CAERZ/>-V:>$+F0?AX](]M,#
M"S V(;Z "4,<->%0+V+S18 2:Y/\Q#4@OYCFP'#(N2WR"%.;!<-Q-?MCQ/7,
MIL!X_">+DY X/+T]OG#%`C78'>\5;6=%(M,&FAWR#?X'[ 8HH59-0&^/.[)8
ML 9;Y'U:/F;%P[^R;8:K(5
M.#3<)",3(ES'$HU4BY9(7'I_W-/%PC78(]=E_OB8P:;PXH
MN5;M0.^2G^F:H/HHJL$F>9]7=7;4F %'MG3F0@E=: ,\
ME@46;Y!Q>'J#W+/%PC78(E=/Z:[X@VD#N$U&YD$2&Q_C4%*M&F$NH(35'?#D
M$4>V%$U20JVR14>3EY'%`94F)RW%\6-65KI".AP;1I*8[Q8K>0ZY.)3$X0V.
M6GK"6, &L>0N.V7''=,,,)0,$/\=>6XR9P@?5"Y0DLU/'V.^)>A@\L(7"]0@
MEFS.-'?9!Z898"B)U$((;[9 CSD;[ :39'9@#NP1PE4KL@DI62( X'A4JN%T=WS&\!S!*$K5F"L5D"?=1&P!N[7M^-F?S9
M<;VDT&6CF(#7)Q3.#_M\>Z>&6PXV900>3"2HR Q)YR3Q;#*!290NF>#K2^ \
MW9).P&L/W0<\3<#0/+6O][07M'.E-G> =1P/^E)F!HF#'3[7-!.SVFFZ8),\\@]SBJG4X?4NA"KX##FSK1
M2"9@VT5 6W*BE%"K=&GC5S"N6)#ZR/6*^:$H#]R1:N>TB11JE7K3F%6-U(1)
MEYV@E11JDZX0\:?]J&(!4C[UTL+*'*F:SA[[U+/Z>FZ@WMBG>B[3IX9?PJ>&
M=GUJ2/C4YW'%@J1\:IF=BI(]5K^$5PWM>M70V*MZ+M.KAE_"JX9VO6I$>-7G
M<<6"I/WJ4W9(>=Q'7\*M1G;=ZFP;$1RJ@NE6+?41D4*MTD6ZU698L1 IK[I/
M/Q=G<"Q @'X)I[JX?8B -W:J@0L.!0CH+^%4([M.-2:/=%H)7\RV[D_KO$G!R\K("'AMJ;V&KC&HC%!0?:G]3A8[[+RONN3B0,6EOLFS\+
MW_7OG1^R?59G\$2&%-E:8,0]2#=J1S\!'&IUV>:;-MG8*^*'*RD2VE(DTBM2
MG(]U<^/9<[92K&60R$@/CZ]'K-6CJ-JK`'H]_+7TB(WT$'P]$KT]TG+7*Q%$
M*RF1:)2 GHEOC,35*M&(9C2O=PDT`
M^[.+!] E7DD7WT@7_OJ1Z!?UHGS(5="S.=7'?L+[,EE)&5NK>J)?U9NC_-^S
MLKJN(FO->5NK>J)?U4_Y=1%QUS*&V8JNN["2`-:OZ(=TNTEW._7K5WM$:\UX
MLU7]!A^L7]4'NFR.17E(>V_LQ2L%*HENC5\>< G7A6O\='O0A/;M#W[/^DA2
M^-X:BK7R313C>F<%#%=]H%@;Y _5DOXJTZF5;DFM81CPK-M][M2*!G)>% *)5QP:Q/Y)6:*
M)T0\U3'479]%P,]UM4\33K$;@;*/\$3SDL$UPI/^-*X@I0^C)FTYIKA+
M=,3[*+"$,3E4JRP>R_1PS3!(WUPO4OQ +^\RH/RQ7LE=K/-Z/KKT2QB2ZW0:
M!N1Q&#+4HJ0/U!*>+J$E9\R%`^M"-3K?X&SN()?+B$K+%NDT+A"C+7H'?#0$-6$"UE+'!L06G0
M;S6$G5-^4NBRI1R'UW>L:JAB@0K"`-OB6)?IMJXZ0_,,H6E:M6\(;,5XZ+N#$D_S\S^P#1*NY5H:74!`8^<#4WH8L%BIT+9
M`;QK1:#!'3H2&Z]'O=T].M;SJ2AB06';\Z8-HDFD'[,;G(^FW3,:7*(GIGOT
M6+B3%2 (HD'9:#2]]9@4;VZ"@&\"K.ES3!L+%MNN-\^B_)%^9@8M,>MI)?/2
M)E*JU1E@^KY[V/1?\_BRTU-/"K5*E_:QD?&H8N'I8T9XVO.45W51,M?+!(:-
M$?(NJA B7LEO)[K84:$.2\VN-.Y9#]3Q+:!_H&Z&+Q8P
M%BU>D)GT\QZG6XO^Q2$B#F]\EA/X$9,O2V+#*;[LN>(`SCQ(UZ?9FS8?0'[@HI"P
M>:@#:GN'.D+.UR4"`XD"
MPVM]FEZO7K7G4\S3/KUJY5ZO^!%!\\0`HA4E?*B5/Z.5KB>>`(9W_(RTZJW5
M]WG%YH:B) ]5$CJ59MY("+#^12'A;3\CE4;W_;B^N3J45*@.F/)!S%<'7OAS
MMPBJN6
M]F8944H]+R0BB))^+?&]F"L?+";B,O!"'CS"U@CD!4@H.T4S))"
MEX4].#S6FM7-2!8>=B)7[0O8_$/@P7.XP6"=%G>+:);U:7\H*=8JZ\CY6TO2
M`$SZ]RZZYJ!]5_\J'L:,-W !"@==

]]$NG"FCD2"// M132B! \U:IN+/7>J$;S2K %&HUL/7LO6:P1O'&CN+QIK)!"-*,%#C0*=1N(N M!L&-`L8>@%+ \)*VH4;-L)M7)YI7AY0*#"0GW=_>70+"3QI8?R]$-^0&MY=> M59'QS6J8W;\*G!0)[.OO@5 [,ENJ^&9WL&I502ZY5L!P]]:J, PUX$Y"LRX$"L^2FB53S`,K3<8[#(V>O'4TL/.SD=2:K3X/"_0+2 MY2778G[1AH&$#XQ/70,I>7P%%DY=381:I0LY==6>?M"(V(EK4_NAOV:!QF4= MOO(ZY8H-@A[*!XF,D_Z[%QLXL&381:I1\YA!T0Q8+$CF&O M]Y> T@,26--7AY2*!<%*$V!99QT-CQS"CMEBH6(GL,-:P-;(<]=:T&)8Y[*> MV1O3)E(7G';1\$BXB%''DD%V@]QN$]Y=D^Y:1EG4#D+#4^T@MQH"BRN'UFX+ M!M4//GS(M\ @(2H"1ID^8I%8)N8FH01#DURVC@*8!!RLD/#8>XMSS+'PL4QU M"SH?2.' ,&4=8R^%24_,%EP*P>.,D;86VEF"PR-IZS%C+%0L?]TA;HI35K;_ MHN\FI*78:"0QD;K0;>'PIHTD41@G3+XL-)*8"+5*%Q:.S@\TE@@L/%6?N]6I MQ# Z1<[!I.%]`R9B;1IDT+\'S\%V-_J3& M.!S&O^H?V)72F(6!,BE7+)N99 M'4JL54-@_220,A8T%HL.%G*N'6 <&H3SAHC<^9MC/(_'E2X4E3.FT!Z&X?!( M*#JD:X*)GD7&6!@Z[Y%P3$WVZ,*3!H2WK=!'OVH^M"2#6A"E=S+M>;S'0CUD<67,#!-+'K8;L;-MJ`&Q 23:W M@;8\!8?'+VH<,C:!Q:J#Y,Q#9%-7U+V#"8R!@VMV[X@Q/-^?]1\RFK)%238W M1J S!@Z/O4<&2&,A8RTHVW-9-A=RSER/0H/K*[:>X;+^@5#I#Y^>#>/!BX:Q MY!$U?E5SYEH#<8,%]-5:^6GZ0*B*S'M=A(SC01U=`-)TE$A8YP2#)]UJ)+$^ M$2E@R1:T]+CJ:?2V/&X@4K:!@:3NP$1B&R(Y>H&M*WJ*1P7VB;;FB80EC1#J M*TX)8+AP^,E@:R1"D*UI>6_<5=R7V'NN&UY]EAIU6UV64?TO.^GGHL`I>5_S6\2LM$ZK)PBH!'5H\15Q-0 M-$9#>Q>[-0DD"SS\B\+>Q42YP?D,9N(E,IX-J,([IO")$<2=:'>L,AP;(;GS M=0F;`/7F6/MB3]<0,+AW44^*MB_VB)M=KFB*;::\L;"12^YT.>124Q6N97AD:V!T"7NB(37IWHU MFV'/"YET67B?S$2H5;J03*\VU:X`!0I(5AN<"A443NM825BTCG7*O>G1DX'4 MA>2C\%CCVY J%B:9ZM56>)"P,*#T_ `)7GS?G1P[-:O4M6533=3Q=68F7V%) M310)3Q46:.H[2$PLD'QNDF).!,U+9,,L9CS-0HA)`"."ZTORL<>;#LL>)*/A M32L)XJ:5FL>:C4H"`Z%6Z4(J";JQ-<'#>CBEAY4--&\MGAT=*!@9$L2"Q@H%+5EH!PTT/B6OA+703H5;I1PH%1E2Q0.G+R^M: M">+RSRM578G_Q3$C#D_>6WYABH6)-C]=O)D"WI[+O/[,- $K=)S-V3--L#AR M1.&Q-\:F;+%PL>CQ4#WJVTI(5-938[,U,CP++'MJC(9'PL4!41-(K/58FKTT M5APWJ>:TA 2W<%^:B="%-L#A35X:Z_EB(6/YQ^Z1C*8D7^T(/C$-P7H")YY= M$@2/JD5/X-#PID_@!*X73&[")<%MO#9F(M0F85A/U'1\L7"Q.+('9O+/*C<5 MLRMH$/(H6AQ%XO &S^!,0Q@<4$60/[S^_OV?%>*KXG#(ZW?74LGF!^EQQ\)3 MWNW'MPW:[GRI!K]W0M>[\_LK]FH417S&JIT-V MN DDN8)T'_]_4$L!`A0`% ````@`8)B>+DPR:N'-%P``?NX```8````````` F`0`@`+:!`````&8R+FQO9U!+!08``````0`!`#0```#Q%P`````` ` end

FAQ