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

Add note about log_bin_trust_function_creators during upgrade to 6.0

XMLWordPrintable

    • Icon: Documentation task Documentation task
    • Resolution: Fixed
    • Icon: Trivial Trivial
    • 7.0 (plan)
    • 6.0.14rc1
    • Server (S)
    • None
    • Documentation backlog
    • 0.5

      Steps to reproduce:
      If you doing upgrade with mysql or mariadb.

      Upgrade might be failed with

      11785:20230216:084114.168 using configuration file: /etc/zabbix/zabbix_server.conf
      11785:20230216:084114.207 current database version (mandatory/optional): 05000000/05000007
      11785:20230216:084114.207 required mandatory version: 06000000
      11785:20230216:084114.207 optional patches were found
      11785:20230216:084114.207 starting automatic database upgrade
      
       11785:20230216:084148.675 cannot convert calculated item "333743"formula
      
      11785:20230216:084210.583 \[Z3005] query failed: \[1419] You do not have the SUPER privilege and binary logging is enabled (you _might_ want to use the less safe log_bin_trust_function_creators variable) \[create trigger hosts_name_upper_insert
      before insert on hosts for each row
      set new.name_upper=upper([new.name|http://new.name])]
      11785:20230216:084210.587 database upgrade failed
      

      Expected:

      Need to do steps like we have in upgrade notes for 6.2 here
      https://www.zabbix.com/documentation/6.2/en/manual/installation/upgrade_notes_620?hl=log_bin_trust_function_creators

      Please add it there as well.

            mgeneralova Marina Generalova (Inactive)
            neogan Andrei Gushchin (Inactive)
            Team A
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: