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 [email protected].
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.
