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

XMLWordPrintable

    • Type: Problem report
    • Resolution: Won't fix
    • Priority: Trivial
    • None
    • Affects Version/s: 7.0.8
    • Component/s: 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

            Assignee:
            Zabbix Support Team
            Reporter:
            Chuck Perry
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: