"Database upgrade to primary keys" gives error

XMLWordPrintable

    • Type: Problem report
    • Resolution: Unresolved
    • Priority: Major
    • None
    • Affects Version/s: None
    • Component/s: Documentation (D)
    • Environment:
      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.

            Assignee:
            Zabbix Development Team
            Reporter:
            Kazuo Ito
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated: