here is a delete query:
< 2017-06-30 07:44:36.739 EDT >LOG: duration: 515.967 ms execute
<unnamed>: DELETE FROM fact_values fv
WHERE fv.id in
($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35,$36,$37,$38,$39,$40,$41,$42,$43,$44,$45)
AND NOT EXISTS (SELECT 1 FROM facts f
WHERE f.fact_value_id in
($46,$47,$48,$49,$50,$51,$52,$53,$54,$55,$56,$57,$58,$59,$60,$61,$62,$63,$64,$65,$66,$67,$68,$69,$70,$71,$72,$73,$74,$75,$76,$77,$78,$79,$80,$81,$82,$83,$84,$85,$86,$87,$88,$89,$90)
AND f.fact_value_id = fv.id
AND (f.factset_id,
f.fact_path_id,
f.fact_value_id) NOT in
(($91,$92,$93),($94,$95,$96),($97,$98,$99),($100,$101,$102),($103,$104,$105),($106,$107,$108),($109,$110,$111),($112,$113,$114),($115,$116,$117),($118,$119,$120),($121,$122,$123),($124,$125,$126),($127,$128,$129),($130,$131,$132),($133,$134,$135),($136,$137,$138),($139,$140,$141),($142,$143,$144),($145,$146,$147),($148,$149,$150),($151,$152,$153),($154,$155,$156),($157,$158,$159),($160,$161,$162),($163,$164,$165),($166,$167,$168),($169,$170,$171),($172,$173,$174),($175,$176,$177),($178,$179,$180),($181,$182,$183),($184,$185,$186),($187,$188,$189),($190,$191,$192),($193,$194,$195),($196,$197,$198),($199,$200,$201),($202,$203,$204),($205,$206,$207),($208,$209,$210),($211,$212,$213),($214,$215,$216),($217,$218,$219),($220,$221,$222),($223,$224,$225)))
< 2017-06-30 07:44:36.739 EDT >DETAIL: parameters: $1 = '68711515', $2 =
'68711524', $3 = '458273', $4 = '67552938', $5 = '67552948', $6 =
'68711512', $7 = '43557379', $8 = '68711519', $9 = '68584340', $10 =
'68664231', $11 = '68711523', $12 = '68711510', $13 = '68711522', $14 =
'68711506', $15 = '46742800', $16 = '68711508', $17 = '67891543', $18 =
'68711522', $19 = '68711518', $20 = '53900313', $21 = '68711516', $22 =
'68711526', $23 = '68542183', $24 = '67552962', $25 = '68584328', $26 =
'67552961', $27 = '68711511', $28 = '68711521', $29 = '68664249', $30 =
'68584345', $31 = '68711517', $32 = '640285', $33 = '68711514', $34 =
'68711520', $35 = '68653160', $36 = '65529523', $37 = '68584343', $38 =
'68711525', $39 = '68711513', $40 = '64276521', $41 = '13740347', $42 =
'68711509', $43 = '24482470', $44 = '67891543', $45 = '68711507', $46 =
'68711515', $47 = '68711524', $48 = '458273', $49 = '67552938', $50 =
'67552948', $51 = '68711512', $52 = '43557379', $53 = '68711519', $54 =
'68584340', $55 = '68664231', $56 = '68711523', $57 = '68711510', $58 =
'68711522', $59 = '68711506', $60 = '46742800', $61 = '68711508', $62 =
'67891543', $63 = '68711522', $64 = '68711518', $65 = '53900313', $66 =
'68711516', $67 = '68711526', $68 = '68542183', $69 = '67552962', $70 =
'68584328', $71 = '67552961', $72 = '68711511', $73 = '68711521', $74 =
'68664249', $75 = '68584345', $76 = '68711517', $77 = '640285', $78 =
'68711514', $79 = '68711520', $80 = '68653160', $81 = '65529523', $82 =
'68584343', $83 = '68711525', $84 = '68711513', $85 = '64276521', $86 =
'13740347', $87 = '68711509', $88 = '24482470', $89 = '67891543', $90 =
'68711507', $91 = '537', $92 = '259', $93 = '68711515', $94 = '537', $95 =
'791', $96 = '68711524', $97 = '537', $98 = '316', $99 = '458273', $100 =
'537', $101 = '43891', $102 = '67552938', $103 = '537', $104 = '308', $105
= '67552948', $106 = '537', $107 = '309', $108 = '68711512', $109 = '537',
$110 = '1278', $111 = '43557379', $112 = '537', $113 = '719', $114 =
'68711519', $115 = '537', $116 = '1288', $117 = '68584340', $118 = '537',
$119 = '43927', $120 = '68664231', $121 = '537', $122 = '257', $123 =
'68711523', $124 = '537', $125 = '388', $126 = '68711510', $127 = '537',
$128 = '250', $129 = '68711522', $130 = '537', $131 = '97', $132 =
'68711506', $133 = '537', $134 = '43906', $135 = '46742800', $136 = '537',
$137 = '1286', $138 = '68711508', $139 = '537', $140 = '325', $141 =
'67891543', $142 = '537', $143 = '336', $144 = '68711522', $145 = '537',
$146 = '43908', $147 = '68711518', $148 = '537', $149 = '737', $150 =
'53900313', $151 = '537', $152 = '799', $153 = '68711516', $154 = '537',
$155 = '43918', $156 = '68711526', $157 = '537', $158 = '759', $159 =
'68542183', $160 = '537', $161 = '385', $162 = '67552962', $163 = '537',
$164 = '1277', $165 = '68584328', $166 = '537', $167 = '4', $168 =
'67552961', $169 = '537', $170 = '192', $171 = '68711511', $172 = '537',
$173 = '1273', $174 = '68711521', $175 = '537', $176 = '794', $177 =
'68664249', $178 = '537', $179 = '43873', $180 = '68584345', $181 = '537',
$182 = '895', $183 = '68711517', $184 = '537', $185 = '104', $186 =
'640285', $187 = '537', $188 = '321', $189 = '68711514', $190 = '537', $191
= '911', $192 = '68711520', $193 = '537', $194 = '47201', $195 =
'68653160', $196 = '537', $197 = '1284', $198 = '65529523', $199 = '537',
$200 = '1294', $201 = '68584343', $202 = '537', $203 = '210', $204 =
'68711525', $205 = '537', $206 = '176', $207 = '68711513', $208 = '537',
$209 = '711', $210 = '64276521', $211 = '537', $212 = '43921', $213 =
'13740347', $214 = '537', $215 = '43852', $216 = '68711509', $217 = '537',
$218 = '1299', $219 = '24482470', $220 = '537', $221 = '109', $222 =
'67891543', $223 = '537', $224 = '706', $225 = '68711507'
On Wednesday, June 28, 2017 at 12:25:57 PM UTC-4, Peter Krawetzky wrote:
>
> Last Sunday we hit a wall on our 3.0.2 puppetdb server. The cpu spiked
> and the KahaDB logs started to grow eventually almost filling a
> filesystem. I stopped the service, removed the mq directory per a
> troubleshooting guide, and restarted. After several minutes the same
> symptoms began again and I have not been able to come up with a puppetdb or
> postgresql config to fix this.
>
> We tried turning off storeconfig in the puppet.conf file on our puppet
> master servers but that doesn't appear to have resolved the problem. I
> also can't find a good explanation as to what this parameter really does or
> does not do even in the puppet server documentation. Anyone have a better
> insight into this?
>
> Also is there a way to just turn off puppetdb?
>
> I've attached a file that is a snapshot of the puppetdb dashboard.
>
> Anyone experience anything like this?
>
--
You received this message because you are subscribed to the Google Groups
"Puppet Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to puppet-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/puppet-users/cf08f713-ad6d-4e63-b07d-4c3dd3fdfbe1%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
