2025.04.10 05:51:37.135 *E* [db.drv             ] SQL query failed (Query = "INSERT INTO interface_vlan_list (iface_id,vlan_id) VALUES (?,?)"): 23505 ERROR:  duplicate key value violates unique constraint "interface_vlan_list_pkey"
DETAIL:  Key (iface_id, vlan_id)=(5667, 1) already exists.

with debug sql on

2025.04.10 07:08:02.407 *D* [db.query           ] {0x74e9e1902580} bind at pos 1: "5480"
2025.04.10 07:08:02.407 *D* [db.query           ] {0x74e9e1902580} bind at pos 2: "53"
2025.04.10 07:08:02.407 *D* [db.query           ] {0x74e9e1902580} bind at pos 3: "508"
2025.04.10 07:08:02.407 *D* [db.query           ] {0x74e9e1902580} bind at pos 4: "5C5EAB72090E"
2025.04.10 07:08:02.407 *D* [db.query           ] {0x74e9e1902580} bind at pos 5: "0"
2025.04.10 07:08:02.407 *D* [db.query           ] {0x74e9e1902580} bind at pos 6: "524"
2025.04.10 07:08:02.407 *D* [db.query           ] Successful sync query: "INSERT INTO idata_70084 (item_id,idata_timestamp,idata_value,raw_value) VALUES (27588,1744268882,'6','6')" [0 ms]
2025.04.10 07:08:02.407 *D* [db.query           ] {0x74e9e1902580} bind at pos 7: "0"
2025.04.10 07:08:02.407 *D* [db.query           ] {0x74e9e1902580} bind at pos 8: "0"
2025.04.10 07:08:02.407 *D* [db.query           ] {0x74e9e1902580} bind at pos 9: "0"
2025.04.10 07:08:02.407 *D* [db.query           ] {0x74e9e1902580} bind at pos 10: "0"
2025.04.10 07:08:02.407 *D* [db.query           ] {0x74e9e1902580} bind at pos 11: "0"
2025.04.10 07:08:02.407 *D* [db.query           ] {0x74e9e1902580} bind at pos 12: "0"
2025.04.10 07:08:02.407 *D* [db.query           ] {0x74e9e1902580} bind at pos 13: "ge-0/0/11.0"
2025.04.10 07:08:02.407 *D* [db.query           ] {0x74e9e1902580} bind at pos 14: "1"
2025.04.10 07:08:02.407 *D* [db.query           ] {0x74e9e1902580} bind at pos 15: "2"
2025.04.10 07:08:02.407 *D* [db.query           ] {0x74e9e1902580} bind at pos 16: "0"
2025.04.10 07:08:02.407 *D* [db.query           ] {0x74e9e1902580} bind at pos 17: "0"
2025.04.10 07:08:02.407 *D* [db.query           ] {0x74e9e1902580} bind at pos 18: "0"
2025.04.10 07:08:02.407 *D* [db.query           ] {0x74e9e1902580} bind at pos 19: "1514"
2025.04.10 07:08:02.407 *D* [db.query           ] {0x74e9e1902580} bind at pos 20: "0"
2025.04.10 07:08:02.407 *D* [db.query           ] {0x74e9e1902580} bind at pos 21: "5503"
2025.04.10 07:08:02.407 *D* [db.query           ] {0x74e9e1902580} bind at pos 22: ""
2025.04.10 07:08:02.407 *D* [db.query           ] {0x74e9e1902580} bind at pos 23: "2"
2025.04.10 07:08:02.407 *D* [db.query           ] {0x74e9e1902580} bind at pos 24: "1"
2025.04.10 07:08:02.407 *D* [db.query           ] {0x74e9e1902580} bind at pos 25: ""
2025.04.10 07:08:02.407 *D* [db.query           ] {0x74e9e1902580} bind at pos 26: ""
2025.04.10 07:08:02.407 *D* [db.query           ] {0x74e9e1902580} bind at pos 27: "0"
2025.04.10 07:08:02.407 *D* [db.query           ] {0x74e9e1902580} bind at pos 28: "0"
2025.04.10 07:08:02.407 *D* [db.query           ] {0x74e9e1902580} bind at pos 29: "0"
2025.04.10 07:08:02.407 *D* [db.query           ] {0x74e9e1902580} bind at pos 30: "ge-0/0/11.0"
2025.04.10 07:08:02.407 *D* [db.query           ] {0x74e9e1902580} bind at pos 31: "5664"
2025.04.10 07:08:02.407 *D* [db.query           ] Successful prepared sync query: "INSERT INTO interfaces (node_id,if_type,if_index,mac_addr,required_polls,bridge_port,phy_chassis,phy_module,phy_pic,phy_port,peer_node_id,peer_if_id,description,admin_state,oper_state,dot1x_pae_state,dot1x_backend_state,peer_proto,mtu,speed,parent_iface,iftable_suffix,last_known_oper_state,last_known_admin_state,if_alias,ospf_area,ospf_if_type,ospf_if_state,stp_port_state,if_name,id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ON CONFLICT (id) DO UPDATE SET node_id=excluded.node_id,if_type=excluded.if_type,if_index=excluded.if_index,mac_addr=excluded.mac_addr,required_polls=excluded.required_polls,bridge_port=excluded.bridge_port,phy_chassis=excluded.phy_chassis,phy_module=excluded.phy_module,phy_pic=excluded.phy_pic,phy_port=excluded.phy_port,peer_node_id=excluded.peer_node_id,peer_if_id=excluded.peer_if_id,description=excluded.description,admin_state=excluded.admin_state,oper_state=excluded.oper_state,dot1x_pae_state=excluded.dot1x_pae_state,dot1x_backend_state=excluded.dot1x_backend_state,peer_proto=excluded.peer_proto,mtu=excluded.mtu,speed=excluded.speed,parent_iface=excluded.parent_iface,iftable_suffix=excluded.iftable_suffix,last_known_oper_state=excluded.last_known_oper_state,last_known_admin_state=excluded.last_known_admin_state,if_alias=excluded.if_alias,ospf_area=excluded.ospf_area,ospf_if_type=excluded.ospf_if_type,ospf_if_state=excluded.ospf_if_state,stp_port_state=excluded.stp_port_state,if_name=excluded.if_name" [1 ms]
2025.04.10 07:08:02.407 *D* [db.query           ] {0x74e9e1902580} Successful prepare: "DELETE FROM interface_vlan_list WHERE iface_id=?" [0 ms]
2025.04.10 07:08:02.407 *D* [db.query           ] {0x74e9e1902580} bind at pos 1: "5664"
2025.04.10 07:08:02.408 *D* [db.query           ] Successful sync query: "INSERT INTO idata_69641 (item_id,idata_timestamp,idata_value,raw_value) VALUES (40619,1744268882,'0','0')" [0 ms]
2025.04.10 07:08:02.408 *D* [db.query           ] Successful prepared sync query: "DELETE FROM interface_vlan_list WHERE iface_id=?" [0 ms]
2025.04.10 07:08:02.408 *D* [db.query           ] {0x74e9e1902580} Successful prepare: "INSERT INTO interface_vlan_list (iface_id,vlan_id) VALUES (?,?)" [0 ms]
2025.04.10 07:08:02.408 *D* [db.query           ] {0x74e9e1902580} bind at pos 1: "5664"
2025.04.10 07:08:02.408 *D* [db.query           ] {0x74e9e1902580} bind at pos 2: "0"
2025.04.10 07:08:02.408 *D* [db.query           ] Successful prepared sync query: "INSERT INTO interface_vlan_list (iface_id,vlan_id) VALUES (?,?)" [0 ms]
2025.04.10 07:08:02.408 *D* [db.query           ] {0x74e9e1902580} bind at pos 2: "0"
2025.04.10 07:08:02.408 *D* [db.query           ] Failed prepared sync query: "INSERT INTO interface_vlan_list (iface_id,vlan_id) VALUES (?,?)" [1 ms]
2025.04.10 07:08:02.408 *E* [db.drv             ] SQL query failed (Query = "INSERT INTO interface_vlan_list (iface_id,vlan_id) VALUES (?,?)"): 23505 ERROR:  duplicate key value violates unique constraint "interface_vlan_list_pkey"
DETAIL:  Key (iface_id, vlan_id)=(5664, 0) already exists.
2025.04.10 07:08:02.408 *D* [db.query           ] {0x74e9d0e05020} bind at pos 1: "33525474"
2025.04.10 07:08:02.408 *D* [db.query           ] {0x74e9d0e05020} bind at pos 2: "52"
2025.04.10 07:08:02.408 *D* [db.query           ] {0x74e9d0e05020} bind at pos 3: "1744268882"
2025.04.10 07:08:02.408 *D* [db.query           ] {0x74e9d0e05020} bind at pos 4: "0"
2025.04.10 07:08:02.408 *D* [db.query           ] {0x74e9d0e05020} bind at pos 5: "1744268882"
2025.04.10 07:08:02.408 *D* [db.query           ] {0x74e9d0e05020} bind at pos 6: "100"
2025.04.10 07:08:02.408 *D* [db.query           ] {0x74e9d0e05020} bind at pos 7: "0"
2025.04.10 07:08:02.408 *D* [db.query           ] {0x74e9d0e05020} bind at pos 8: "0"
2025.04.10 07:08:02.408 *D* [db.query           ] {0x74e9d0e05020} bind at pos 9: "4"
2025.04.10 07:08:02.408 *D* [db.query           ] {0x74e9d0e05020} bind at pos 10: "Database query failed (Query: INSERT INTO interface_vlan_list (iface_id,vlan_id) VALUES (?,?); Error: 23505 ERROR:  duplicate key value violates unique constraint "interface_vlan_list_pkey"
DETAIL:  Key (iface_id, vlan_id)=(5664, 0) already exists.)"
2025.04.10 07:08:02.408 *D* [db.query           ] {0x74e9d0e05020} bind at pos 11: "0"
2025.04.10 07:08:02.408 *D* [db.query           ] {0x74e9d0e05020} bind at pos 12: ""
2025.04.10 07:08:02.408 *D* [db.query           ] {0x74e9d0e05020} bind at pos 13 (UTF-8): "{"id":33525474,"rootId":0,"code":52,"name":"SYS_DB_QUERY_FAILED","timestamp":1744268882,"originTimestamp":1744268882,"origin":0,"source":100,"zone":0,"dci":0,"severity":4,"message":"Database query failed (Query: INSERT INTO interface_vlan_list (iface_id,vlan_id) VALUES (?,?); Error: 23505 ERROR:  duplicate key value violates unique constraint \"interface_vlan_list_pkey\"\nDETAIL:  Key (iface_id, vlan_id)=(5664, 0) already exists.)","lastAlarmKey":"","lastAlarmMessage":"","tags":null,"parameters":[{"name":"query","value":"INSERT INTO interface_vlan_list (iface_id,vlan_id) VALUES (?,?)"},{"name":"message","value":"23505 ERROR:  duplicate key value violates unique constraint \"interface_vlan_list_pkey\"\nDETAIL:  Key (iface_id, vlan_id)=(5664, 0) already exists."},{"name":"connectionLost","value":"0"},{"name":"hash","value":"Какой-то повторяющийся хэш. Убрал"}]}"
2025.04.10 07:08:02.408 *D* [db.query           ] ROLLBACK TRANSACTION successful (level 0)
2025.04.10 07:08:02.409 *D* [db.query           ] BEGIN TRANSACTION successful (level 1)