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)
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)
Comment