Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-26547

"Database upgrade to primary keys" gives error

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Unresolved
    • Icon: Major Major
    • None
    • None
    • Documentation (D)
    • 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.

            zabbix.dev Zabbix Development Team
            kazuo.ito Kazuo Ito
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated: