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

SQL errors during upgrade from 2.4 to 3.0

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Major
    • Resolution: Won't fix
    • Affects Version/s: 3.0.0
    • Fix Version/s: None
    • Component/s: Server (S)
    • Labels:
    • Environment:
      Centos 7 zabbix server and centos 6.7 DataBase

      Description

      I installed zabbix 3.0 on centos 7 and I have to conect a DB mysq 5.6 (centos 6.7) in this DB is all my data, when the DB is connect, zabbix upgrate de database but display and error:

      "Can't create table 'zabbix.#sql-7e2d_3e' (errno: 150) [alter table application_prototype add constraint c_application_prototype_1 foreign key (itemid) references items (itemid) on delete cascade]" (zabbix.log)

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              kross137 Cristhian Carrera
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: