-
Problem report
-
Resolution: Unresolved
-
Major
-
None
-
None
-
Azure Database for MySQL 8.0.40
In Azure MySQL, sql_generate_invisible_primary_key is set to On by default.
Therefore, the my_row_id column is added to the history table.
If you run util.importTable in this state, the following error will occur:
history_text.csv error 1366: Incorrect integer value : 'xxxxx' for column 'ns' at row 1
Please consider adding the following settings to the "Create initial database" section of MySQL in "Download and install Zabbix".
set global sql_generate_invisible_primary_key = off;
Since sql_generate_invisible_primary_key is OFF by default in MySQL, enabling it in may involve untested behavior and could cause unexpected issues.