Ad Widget

**markfree** · 30-11-2021, 17:58

I ran a check but there was no issues.

Code:

# mysqlcheck --auto-repair=true -u -p [zabbix_db]
OK

When I select valuemap table, it shows empty sets, but valuemaps.

Code:

mysql> select * from valuemap;
Empty set (0.00 sec)

mysql> select * from valuemap_mapping;
Empty set (0.00 sec)

mysql> select * from valuemaps;
+------------+-----------------------------------------------------------------+
| valuemapid | name |
+------------+-----------------------------------------------------------------+
| 4 | APC Battery Replacement Status |
| 5 | APC Battery Status |
| 77 | Boolean |
(...)
+------------+-----------------------------------------------------------------+
91 rows in set (0.00 sec)

I think the issue might be related to this value mapping

Boolean
False ⇒ 0
false ⇒ 0
true ⇒ 1
True ⇒ 1

**tim.mooney** · 01-12-2021, 11:24

You are correct, the issue is related to those. It's not a database corruption issue, it's with older values that do not comply with your updated schema.

In some collations, including utf8_bin, they are the same. Hence the duplicate entry.

I'm not sure where the two sets of value maps for true/True and false/False came from, but if you have an idea what items might have been using them, you probably need to decide which pair you get rid of (either True and False or true and false). I don't know where they came from, so it's hard to advise which ones should be deleted, but my suspicious is that it doesn't really matter which ones you get rid of.

If you're afraid to get rid of them, what you could do instead is rename one set of them, to something like "Duplicate_False" and "Duplicate_True". You'll have to find a way to uniquely identify them, but it looks like there might be a unique id you can use to select them.

Ad Widget

Zabbix DB update error - Duplicate entry

Zabbix DB update error - Duplicate entry

Comment

Comment