Uploaded image for project: 'ZABBIX FEATURE REQUESTS'
  1. ZABBIX FEATURE REQUESTS
  2. ZBXNEXT-1391

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

    XMLWordPrintable

    Details

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

      Description

      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.

        Attachments

          Activity

            People

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

              Dates

              Created:
              Updated:
              Resolved: