Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-26041

cannot insert multiple lines into history_text in same second due to primary key history_text_pkey

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Unresolved
    • Icon: Trivial Trivial
    • None
    • 7.0.8
    • Server (S)

      Hi Team,

      description

      I had collected the log from logstash. but there's one problem that if there are multiple logs output in same time, zabbix will deny them.

      Feb 12 16:13:14 cnnjlx12046 patroni[3332838]: 2025-02-12 16:13:14 HKT [3332838]: [67a8a51b.32dae6-6813354] zabbix@zabbix,app=[unknown] [23505] ERROR:  duplicate key value violates unique constraint "4985_1457_history_text_pkey"
      Feb 12 16:13:15 cnnjlx12046 patroni[3332838]: 2025-02-12 16:13:15 HKT [3332838]: [67a8a51b.32dae6-6813357] zabbix@zabbix,app=[unknown] [23505] ERROR:  duplicate key value violates unique constraint "4985_1457_history_text_pkey"
      Feb 12 16:13:15 cnnjlx12046 patroni[3332838]: 2025-02-12 16:13:15 HKT [3332838]: [67a8a51b.32dae6-6813360] zabbix@zabbix,app=[unknown] [23505] ERROR:  duplicate key value violates unique constraint "4985_1457_history_text_pkey"

      expect

      change column "history_text.clock" to milliseconds from second

            zabbix.support Zabbix Support Team
            cplove1987 Chuck Perry
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated: