Problem with mysql 8.0.17 innodb cluster tables
I am finishing up a setup of a MySQL InnoDB cluster and I am seeing an error when the zabbix server tries an insert in to the history tables. I am using the 4.4a3 zabbix
history
history_uint
history_str
history_log
history_text
I also saw this in the dbversion table
The Error message:
[Z3005] query failed: [3098] The table does not comply with the requirements by an external plugin. [insert into history_unit (itemid, clock,ns,value) values (23662, 1569438442, 841640353,0);
When I look at these tables I find it does not have a primary key, which I believe is required for the innodb cluster.
I am wondering what is the recommended way to create a primary key?
history
history_uint
history_str
history_log
history_text
I also saw this in the dbversion table
The Error message:
[Z3005] query failed: [3098] The table does not comply with the requirements by an external plugin. [insert into history_unit (itemid, clock,ns,value) values (23662, 1569438442, 841640353,0);
When I look at these tables I find it does not have a primary key, which I believe is required for the innodb cluster.
I am wondering what is the recommended way to create a primary key?