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

          causes

          Problem report - Problem report ZBX-14670 Wrong column name in zabbix 4.0.0-1.1alpha9

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed
          duplicates

          Change Request - An Change Request or enhancement Improvement to an existing feature or task. ZBXNEXT-4662 [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' at line 1 [select groupid,name from groups]

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Change Request - An Change Request or enhancement Improvement to an existing feature or task. ZBXNEXT-4644 Web display window data error

          • Major - Major loss of function.
          • Closed

          Incident report - Incident report ZBX-14705 zabbix3+ 在mysql8上无法使用

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Incident report - Incident report ZBX-14704 zabbix3+ mysql8

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Incident report - Incident report ZBX-14598 –Error in query [SELECT g.groupid,g.name FROM groups g...

          • Major - Major loss of function.
          • Closed
          is duplicated by

          Problem report - Problem report ZBX-14486 zabbix+mysql8.0.11 zabbix.groups synatx error

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Incident report - Incident report ZBX-13777 Error zabbix-proxy on MySQL 8.0.11

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Incident report - Incident report ZBX-14311 zabbix does not compile with MySQL 8.0.x

          • Trivial - Cosmetic problem like misspelt words or misaligned text.
          • Closed

          Problem report - Problem report ZBX-14367 zabbix server log: ERROR 1064 (42000) 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' at line 1

          • Trivial - Cosmetic problem like misspelt words or misaligned text.
          • Closed
          mentioned in

          Page Loading...

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: