undefinied index linking snmp templates

[andrea.consadori]

hi all,
i've a strange issue,
after upgrading from standalone to master node all is working,
child node works but if on master node i try to link an existend template i've the issue described in screenshot.

what can be?

any idea on how to fix it?

[andrea.consadori]

how can i fix "parent_itemid" is missing in table "item_discovery"?

mysql> show keys from item_discovery;
+----------------+------------+--------------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+----------------+------------+--------------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+
| item_discovery | 0 | PRIMARY | 1 | itemdiscoveryid | A | 9700 | NULL | NULL | | BTREE | |
| item_discovery | 0 | item_discovery_1 | 1 | itemid | A | 9700 | NULL | NULL | | BTREE | |
| item_discovery | 0 | item_discovery_1 | 2 | parent_itemid | A | 9700 | NULL | NULL | | BTREE | |
| item_discovery | 1 | c_item_discovery_2 | 1 | parent_itemid | A | 2425 | NULL | NULL | | BTREE | |
+----------------+------------+--------------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+
4 rows in set (0.00 sec)

[andrea.consadori]

to fix my issue i use:

update item_discovery set parent_itemid=parent_itemid+100100000000000 WHERE parent_itemid<100100000000000;

and

update item_discovery set itemid=itemid+100100000000000 WHERE itemid<100100000000000;

now start a new issue:

"Cannot implode expression "{:.}*ERROR*=1". Incorrect trigger expression. Check expression part starting from "{:.}*ERROR*=1"."

any hints?

[andrea.consadori]

Standby to master migration issues [Fixed]

recreate by hand my interface trigger fix my last issue.