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

1.8.5 to 1.9.8 upgrade problems with mysql

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Fixed
    • Icon: Trivial Trivial
    • None
    • 1.9.8 (beta)
    • Installation (I)
    • None

      Today i upgraded my testinstall to 1.9.8, and i noticed a few bumps in the upgrade process, mainly the mysql patch:

      1) Mysql does not like comments starting with '---', replace them with '-'

      Example:
      – comment
      ---- not a comment

      select 1
      #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 '---- not a comment select 1' at line 2

      2) There is a function called 'zbx_convert_simple_checks'. I'm using a replicated setup with binlogging, so mysql warns me:
      #1418 - This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you might want to use the less safe log_bin_trust_function_creators variable)

      Both errors will halt the patch at that point, and to continue you need to fix the problem and restart from that position in the patch.

            Unassigned Unassigned
            kees Kees Hoekzema
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: