Ad Widget

Collapse

Cannot Upgrade MySQLDatabase from 1.4.4 to 1.5

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • 753713
    Senior Member
    • Apr 2006
    • 137

    #1

    Cannot Upgrade MySQLDatabase from 1.4.4 to 1.5

    Hi,

    I cannot upgrade Zabbix 1.4.4 MySQL Database to latest Beta Version 1.5 (05.01.2008)
    Error:

    ERROR 1054 (42S22) at line 38: Unknown column 'source' in 'field list'

    Christian
    Last edited by 753713; 06-01-2008, 00:15.
    ______________________________
    Version : 2.0.x
    Server OS: Ubuntu 12.04
    Zabbix Servers: 12
    Monitored Windows Server: ~ 1000
    ______________________________
  • mikecrowe
    Member
    • Dec 2007
    • 34

    #2
    DB upgrade instructions for 1.4.4 to 1.5-alpha

    Here's what I used to upgrade. I took a schema diff between 1.4.4 and 1.5 nightly (from nightly 2/12/2008).

    Enjoy.

    Code:
    #
    # DDL START
    #
    CREATE TABLE proxies (
        proxyid bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '',
        name varchar(64) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
        lastaccess int(11) NOT NULL DEFAULT '0' COMMENT '',
        PRIMARY KEY (proxyid),
        INDEX proxies_1 (name)
    ) DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='InnoDB free: 7168 kB';
    
    CREATE TABLE scripts (
        scriptid bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '',
        name varchar(255) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
        command varchar(255) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
        host_access int(11) NOT NULL DEFAULT '0' COMMENT '',
        PRIMARY KEY (scriptid)
    ) DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='InnoDB free: 7168 kB';
    
    CREATE TABLE sysmaps_link_triggers (
        linkid bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '',
        triggerid bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '',
        drawtype int(11) NOT NULL DEFAULT '0' COMMENT '',
        color varchar(6) NOT NULL DEFAULT '000000' COMMENT '' COLLATE latin1_swedish_ci,
        PRIMARY KEY (linkid, triggerid),
        INDEX sysmaps_link_triggers_1 (linkid)
    ) DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='InnoDB free: 7168 kB';
    
    CREATE TABLE trends_uint (
        itemid bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '',
        clock int(11) NOT NULL DEFAULT '0' COMMENT '',
        num int(11) NOT NULL DEFAULT '0' COMMENT '',
        value_min bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '',
        value_avg bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '',
        value_max bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '',
        PRIMARY KEY (itemid, clock)
    ) DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='InnoDB free: 7168 kB';
    
    ALTER TABLE config
        ADD event_ack_enable int(11) NOT NULL DEFAULT '1' COMMENT '' AFTER alert_usrgrpid,
        ADD event_expire int(11) NOT NULL DEFAULT '7' COMMENT '' AFTER event_ack_enable,
        ADD event_show_max int(11) NOT NULL DEFAULT '100' COMMENT '' AFTER event_expire,
        ADD default_theme varchar(128) NOT NULL DEFAULT 'default.css' COMMENT '' COLLATE latin1_swedish_ci AFTER event_show_max;
    
    
    ALTER TABLE dhosts
        MODIFY ip varchar(39) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci;
    
    
    ALTER TABLE drules
        ADD proxyid bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '' AFTER druleid;
    
    
    ALTER TABLE events
        DROP INDEX events_1,
        ADD INDEX events_1 (object, objectid, eventid);
    
    
    ALTER TABLE graphs
        ADD show_legend int(11) NOT NULL DEFAULT '0' COMMENT '' AFTER graphtype,
        ADD show_3d int(11) NOT NULL DEFAULT '0' COMMENT '' AFTER show_legend;
    
    
    ALTER TABLE hosts
        ADD proxyid bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '' AFTER hostid,
        MODIFY ip varchar(39) NOT NULL DEFAULT '127.0.0.1' COMMENT '' COLLATE latin1_swedish_ci,
        ADD INDEX hosts_3 (proxyid);
    
    
    ALTER TABLE items_applications
        ADD INDEX items_applications_2 (itemid);
    
    
    ALTER TABLE node_cksum
        ADD sync char(128) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci AFTER cksum,
        DROP cksumid,
        MODIFY nodeid int(11) NOT NULL DEFAULT '0' COMMENT '',
        DROP fieldname,
        MODIFY cksum text NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
        DROP PRIMARY KEY,
        DROP INDEX node_cksum_cksum_1,
        ADD INDEX node_cksum_cksum_1 (nodeid, tablename, recordid, cksumtype);
    
    DROP TABLE node_configlog;
    
    ALTER TABLE nodes
        MODIFY ip varchar(39) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
        DROP event_lastid,
        DROP history_lastid,
        DROP history_str_lastid,
        DROP history_uint_lastid;
    
    ALTER TABLE screens_items
        ADD dynamic int(11) NOT NULL DEFAULT '0' COMMENT '' AFTER url;
    
    
    ALTER TABLE sysmaps_links
        ADD drawtype int(11) NOT NULL DEFAULT '0' COMMENT '' AFTER selementid2,
        ADD color varchar(6) NOT NULL DEFAULT '000000' COMMENT '' COLLATE latin1_swedish_ci AFTER drawtype,
        DROP triggerid,
        DROP drawtype_off,
        DROP color_off,
        DROP drawtype_on,
        DROP color_on;
    
    
    ALTER TABLE triggers
        ADD type int(11) NOT NULL DEFAULT '0' COMMENT '' AFTER templateid,
        MODIFY comments blob NOT NULL DEFAULT '' COMMENT '';
    
    ALTER TABLE users
        ADD theme varchar(128) NOT NULL DEFAULT 'default.css' COMMENT '' COLLATE latin1_swedish_ci AFTER type;
    
    
    ALTER TABLE usrgrp
        ADD gui_access int(11) NOT NULL DEFAULT '0' COMMENT '' AFTER name,
        ADD users_status int(11) NOT NULL DEFAULT '0' COMMENT '' AFTER gui_access;
    
    
    #
    # DDL END
    #

    Comment

    Working...