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

Details

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

    Description

      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...

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: