Ad Widget

Collapse

Can't create table 'zabbix.#sql-355_4' (errno: 150)

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • gutotknet
    Junior Member
    • Feb 2012
    • 11

    #1

    Can't create table 'zabbix.#sql-355_4' (errno: 150)

    When upgrading from 2.0.8 to 2.2.1 I got this error.
    ------------------/------------------------------
    1278:20140110:163343.225 [Z3005] query failed: [1005] Can't create table 'zabbix.#sql-355_4' (errno: 150) [alter table application_template add constraint c_application_template_1 foreign key (applicationid) references applications (applicationid) on delete cascade]
    1278:20140110:163343.225 database upgrade failed
    ------------------------/----------------------------

    Wahte can I do? I'm using MySql.
  • jan.garaj
    Senior Member
    Zabbix Certified Specialist
    • Jan 2010
    • 506

    #2
    It's MySQL error.

    Read http://stackoverflow.com/questions/1...ving-errno-150 and check your LATEST FOREIGN KEY ERROR from MySQL for more details.
    Devops Monitoring Expert advice: Dockerize/automate/monitor all the things.
    My DevOps stack: Docker / Kubernetes / Mesos / ECS / Terraform / Elasticsearch / Zabbix / Grafana / Puppet / Ansible / Vagrant

    Comment

    Working...