buffer flush took longer time than slow_flush_log_threshold POSTGRES

Skip to first unread message


Dec 17, 2021, 4:03:34 AM12/17/21
to Fluentd Google Group
I have this recurring error that I can't solve on postgres plugin, and I'm not sure where to intervene. The cpu is ok and there are no bottlenecks.

 buffer flush took longer time than slow_flush_log_threshold

I always get this error

<match zeek_dns>
  type postgres
    flush_thread_count 8
host "#{ENV['DB_SERVER']}"
  port "#{ENV['DB_PORT']}"
  database "#{ENV['DB_NAME']}"
  username "#{ENV['DB_USERNAME_FEEDER']}"
  password "#{ENV['PSH']}"
  key_names ts,uid,id.orig_h,id.orig_p,id.resp_h,id.resp_p,proto,trans_id,rtt,query,qclass,qclass_name,qtype,qtype_name,rcode,rcode_name,AA,TC,RD,RA,Z,answers,TTLs,rejected
  sql INSERT INTO dns(ts,uid,id_orig_h,id_orig_p,id_resp_h,id_resp_p,proto,trans_id,rtt,query,qclass,qclass_name,qtype,qtype_name,rcode,rcode_name, aa,tc,rd,ra,z,answers,ttls,rejected) values (to_timestamp($1),$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24)
  flush_interval 5s

Can you help me?

José Lecaros

Dec 22, 2021, 4:02:37 PM12/22/21
to Fluentd Google Group
Hi Vazel,
there are more active users in slack channel slack.Fluentd.org
If you haven't solved your issue, you can try there.
Reply all
Reply to author
0 new messages