-
Incident report
-
Resolution: Incomplete
-
Major
-
None
-
3.2.0
-
Centos 7, postgreSQL
Hi,
I am trying to add a valuemap, and it fails because of a duplicate key error. Below the UI's error.
pg_query(): Query failed: ERROR: duplicate key value violates unique constraint "valuemaps_pkey" DETAIL: Key (valuemapid)=(19) already exists. [adm.valuemapping.php:108 ? CFrontendApiWrapper->create() ? CApiWrapper->__call() ? CFrontendApiWrapper->callMethod() ? CApiWrapper->callMethod() ? CFrontendApiWrapper->callClientMethod() ? CLocalApiClient->callMethod() ? call_user_func_array() ? CValueMap->create() ? DB::insertBatch() ? DBexecute() ? pg_query() in include/db.inc.php:530] Error in query [INSERT INTO valuemaps (name,valuemapid) VALUES ('test','19')] [ERROR: duplicate key value violates unique constraint "valuemaps_pkey" DETAIL: Key (valuemapid)=(19) already exists.] SQL statement execution has failed "INSERT INTO valuemaps (name,valuemapid) VALUES ('test','19')".
Effectively, looking at the table:
zabbix=# select * from valuemaps order by valuemapid;; valuemapid | name ------------+---------------------------------------- 1 | Service state 2 | Host availability 3 | Windows service state 4 | APC Battery Replacement Status 5 | APC Battery Status 6 | HP Insight System Status 7 | Dell Open Manage System Status 8 | SNMP interface status (ifOperStatus) 9 | SNMP device status (hrDeviceStatus) 10 | Zabbix agent ping status 11 | SNMP interface status (ifAdminStatus) 12 | VMware VirtualMachinePowerState 13 | VMware status 14 | Maintenance status 15 | Value cache operating mode 16 | Windows service startup type 17 | HTTP response status code 18 | 0:No, 1:Yes 19 | NetAppCfSetting 20 | NetAppCfState 21 | NetAppFcpTgtStatus 22 | NetAppFsStatus 23 | NetAppGlobalStatus 24 | NetAppLunOnline 25 | NetAppNvramBatteryStatus 26 | NetAppOverTemp 27 | NetAppRaidStatus 28 | NetAppSpareStatus 29 | NetAppVolStatus 30 | Server HP Fan 31 | Server HP Health 32 | RSS Feed 33 | SNMP Ilo 4 - Fan status 34 | SNMP Ilo 4 - Raid status 35 | SNMP Ilo 4 - Disk negotiated link rate 36 | SNMP Ilo 4 - Disk status 37 | SNMP Ilo 4 - Power supply 38 | FgVpnState 39 | fgHwSensorEntAlarmStatus 40 | F5 ltmPoolStatusAvailState 41 | NetAppcfInterconnectStatus 42 | NetAppcfPartnerStatus (42 rows)
I don't know why it tries to allocate ID 19 for my new value map.
I can try to update the current ID 19 to 43, and see what happens, but I am bit afraid of breaking other things while doing that.
Thank you for your help.