Uploaded image for project: 'ZABBIX FEATURE REQUESTS'
  1. ZABBIX FEATURE REQUESTS
  2. ZBXNEXT-4569

"groups" (8.0.2) and "function" (8.0.1) are reserved words since MySQL 8.0

XMLWordPrintable

    • Sprint 14, Sprint 15, Sprint 16, Sprint 32, Sprint 33, Sprint 34, Sprint 35, Sprint 36
    • 2

      Trying to install Zabbix 3.2.6, using MySQL 8.0.2 I got this message (among many similar ones):

         ...
          26:20170801:200803.540 completed 86% of database upgrade
          26:20170801:200804.646 completed 87% of database upgrade
          26:20170801:200805.131 completed 88% of database upgrade
          26:20170801:200805.935 [Z3005] query failed: [1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups
       (groupid)' at line 1 [alter table corr_condition_group add constraint c_corr_condition_group_2 foreign key (groupid) references groups (groupid)]
          26:20170801:200805.936 database upgrade failed
      

      I checked, and as per the official MySQL documentation ( https://dev.mysql.com/doc/refman/8.0/en/keywords.html ), "groups" is added as a reserved word since version 8.0.2.

      Also, as the schema.sql is properly backticked - there is a chance this requires a considerable refactoring effort to fix...

            vso Vladislavs Sokurenko
            ppeterka Peter Pasztor
            Team A
            Votes:
            0 Vote for this issue
            Watchers:
            15 Start watching this issue

              Created:
              Updated:
              Resolved: