Ad Widget

Collapse

upgrade 1.9.7 to 1.9.8

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • warchild
    Junior Member
    • Jul 2010
    • 10

    #1

    upgrade 1.9.7 to 1.9.8

    I have upgraded to 1.9.8 from 1.9.7, with a few guesses using the zabbix/upgrade_incremental/./generate_version_patch scripts from svn
    I originally had this form going 1.9.6 to 1.9.7. After an svn up, it updated some files
    but I noticed there was not an entry in the releases file for 1.9.8, so I made it 1.9.8 23551 which is what i found in the logs when starting up! ( 96851:20111214:130041.721 Starting Zabbix Server. Zabbix 1.9.8 (revision 23551).)

    I now get
    96869:20111214:131425.673 [Z3005] query failed: [1054] Unknown column 'ns' in 'where clause' [select value from history_uint where itemid=35708 and clock=1322954460 and ns=750484693 limit 1]

    every second, in my logs, even in my backup dump, I do not see this ns column

    CREATE TABLE `history` (
    `itemid` bigint(20) unsigned NOT NULL DEFAULT '0', `clock` int(11) NOT NULL DEFAULT '0', `value` double(16,4) NOT NULL DEFAULT '0.0000', KEY `history_1` (`itemid`,`clock`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    CREATE TABLE `history_uint` (
    `itemid` bigint(20) unsigned NOT NULL DEFAULT '0',
    `clock` int(11) NOT NULL DEFAULT '0',
    `value` bigint(20) unsigned NOT NULL DEFAULT '0',
    KEY `history_uint_1` (`itemid`,`clock`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

    no ns column.

    any ideas? has a db migration been missed?

    # svn info
    Path: .
    URL: http://www.zabbix.org/svn/zabbixorg/...de_incremental
    Repository Root: http://www.zabbix.org/svn/zabbixorg
    Revision: 63
    Node Kind: directory
    Schedule: normal
    Last Changed Author: richlv
    Last Changed Rev: 63
    Last Changed Date: 2011-12-10 12:18:25 +1100 (Sat, 10 Dec 2011)
  • StephenKing
    Junior Member
    • Sep 2011
    • 19

    #2
    I just diffed the patch.sql files of 1.9.7 to 1.9.8 and executed those ALTER TABLE statements by hand.

    Should the upgrade script also work for minor updates? A lot of SQL queries would fail, of course.

    Comment

    Working...