The patch.sql script to convert the database to v2.0 fails with "PROCEDURE zbx_convert_operations already exists"

XMLWordPrintable

    • Type: New Feature Request
    • Resolution: Won't fix
    • Priority: Minor
    • None
    • Affects Version/s: 2.0.2
    • Component/s: Server (S)
    • Environment:
      Suse Linux Enterprise Server 10 SP 4, mysql 5.0.26

      During conversion of the database to v2.0 I get the following error:
      ERROR 1304 (42000) at line 1311: PROCEDURE zbx_convert_operations already exists
      Failed to patch Zabbix database. Restore from backup

      I think the reason is that "DROP PROCEDURE zbx_convert_operations" failed, but there was no error message for that. First I ran the patch script as database user zabbix. I had no idea how to fix the privileges, so I restored the database and re-ran the patch script as database user root. That worked just fine.

      It would save a lot of time if the patch script would check for sufficient privileges to run before running into an error.

            Assignee:
            Unassigned
            Reporter:
            Unix Beheer
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: