smallclanger
06-12-2006, 12:21
HI all,
I've just finished attempting to upgrade a long-running 1.0 server to 1.1.4. The frontend is in place, all of the patches have been applied in sequence (The last being 1.1beta12_to_1.1) and the server/agents have been compiled and installed. I've created a server config and when I attempt to start the server, I get the following in the logs:
031142:20061206:110718 server #9 started [Poller. SNMP:OFF]
031134:20061206:110718 Query::select i.itemid,i.key_,h.host,h.port,i.delay,i.descriptio n,i.nextcheck,i.type,i.snmp_community,i.snmp_oid,h .useip,h.ip,i.history,i.lastvalue,i.prevvalue,i.ho stid,h.status,i.value_type,h.network_errors,i.snmp _port,i.delta,i.prevorgvalue,i.lastclock,i.units,i .multiplier,i.snmpv3_securityname,i.snmpv3_securit ylevel,i.snmpv3_authpassphrase,i.snmpv3_privpassph rase,i.formula,h.available from items i,hosts h where i.nextcheck<=1165403238 and i.status=0 and i.type not in (2,7) and ((h.status=0 and h.available!=2) or (h.status=0 and h.available=2 and h.disable_until<=1165403238)) and h.hostid=i.hostid and i.itemid%6=0 and i.key_ not in ('status','icmpping','icmppingsec','zabbix[log]') order by i.nextcheck
031134:20061206:110718 Query failed:Unknown column 'h.network_errors' in 'field list' [1054]
There's a few of those, then:
031140:20061206:110718 Query failed:Unknown column 'h.network_errors' in 'field list' [1054]
031124:20061206:110718 One child process died. Exiting ...
031124:20061206:110718 Got QUIT or INT or TERM or PIPE signal. Exiting...
...until it quits.
As far as I can make out, the 1.1beta5_to_1.1beta6 mysql patch dropped network_errors from the table and nothing since has reinstated it.
The zabbix_server binary version, however, is reporting as 1.1beta2. Is this normal? I've compiled it from a fresh download of the 1.1.4 source, but perhaps the server binary hasn't changed since beta2?
After patching, the hosts table structure is as follows:
mysql> show columns from hosts;
+---------------+--------------+------+-----+-----------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------+--------------+------+-----+-----------+----------------+
| hostid | int(4) | | PRI | NULL | auto_increment |
| host | varchar(64) | | UNI | | |
| useip | int(1) | | | 1 | |
| ip | varchar(15) | | | 127.0.0.1 | |
| port | int(4) | | | 0 | |
| status | int(4) | | MUL | 0 | |
| disable_until | int(4) | | | 0 | |
| error | varchar(128) | | | | |
| available | int(4) | | | 0 | |
| errors_from | int(4) | | | 0 | |
| templateid | int(4) | | | 0 | |
+---------------+--------------+------+-----+-----------+----------------+
Versions:
Apache/2.0.54 (Debian GNU/Linux) DAV/2 SVN/1.2.3 mod_python/3.1.3 Python/2.3.5 PHP/4.4.0-4
mysql Ver 14.7 Distrib 4.1.14, for pc-linux-gnu (i486) using readline 5.0
Config:
Server=1
StartPollers=5
StartTrappers=2
ListenIP=127.0.0.1
ListenPort=10051
HousekeepingFrequency=1
SenderFrequency=30
DebugLevel=3
Timeout=5
UnreachablePeriod=300
UnavailableDelay=15
UnavailableDelay=120
PidFile=/var/run/zabbix/zabbix_server.pid
LogFile=/var/log/zabbix/zabbix_server.log
AlertScriptsPath=/home/zabbix/bin/
DBHost=localhost
DBName=zabbix
DBUser=zabbix
DBPassword=xxxxxx
I've just finished attempting to upgrade a long-running 1.0 server to 1.1.4. The frontend is in place, all of the patches have been applied in sequence (The last being 1.1beta12_to_1.1) and the server/agents have been compiled and installed. I've created a server config and when I attempt to start the server, I get the following in the logs:
031142:20061206:110718 server #9 started [Poller. SNMP:OFF]
031134:20061206:110718 Query::select i.itemid,i.key_,h.host,h.port,i.delay,i.descriptio n,i.nextcheck,i.type,i.snmp_community,i.snmp_oid,h .useip,h.ip,i.history,i.lastvalue,i.prevvalue,i.ho stid,h.status,i.value_type,h.network_errors,i.snmp _port,i.delta,i.prevorgvalue,i.lastclock,i.units,i .multiplier,i.snmpv3_securityname,i.snmpv3_securit ylevel,i.snmpv3_authpassphrase,i.snmpv3_privpassph rase,i.formula,h.available from items i,hosts h where i.nextcheck<=1165403238 and i.status=0 and i.type not in (2,7) and ((h.status=0 and h.available!=2) or (h.status=0 and h.available=2 and h.disable_until<=1165403238)) and h.hostid=i.hostid and i.itemid%6=0 and i.key_ not in ('status','icmpping','icmppingsec','zabbix[log]') order by i.nextcheck
031134:20061206:110718 Query failed:Unknown column 'h.network_errors' in 'field list' [1054]
There's a few of those, then:
031140:20061206:110718 Query failed:Unknown column 'h.network_errors' in 'field list' [1054]
031124:20061206:110718 One child process died. Exiting ...
031124:20061206:110718 Got QUIT or INT or TERM or PIPE signal. Exiting...
...until it quits.
As far as I can make out, the 1.1beta5_to_1.1beta6 mysql patch dropped network_errors from the table and nothing since has reinstated it.
The zabbix_server binary version, however, is reporting as 1.1beta2. Is this normal? I've compiled it from a fresh download of the 1.1.4 source, but perhaps the server binary hasn't changed since beta2?
After patching, the hosts table structure is as follows:
mysql> show columns from hosts;
+---------------+--------------+------+-----+-----------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------+--------------+------+-----+-----------+----------------+
| hostid | int(4) | | PRI | NULL | auto_increment |
| host | varchar(64) | | UNI | | |
| useip | int(1) | | | 1 | |
| ip | varchar(15) | | | 127.0.0.1 | |
| port | int(4) | | | 0 | |
| status | int(4) | | MUL | 0 | |
| disable_until | int(4) | | | 0 | |
| error | varchar(128) | | | | |
| available | int(4) | | | 0 | |
| errors_from | int(4) | | | 0 | |
| templateid | int(4) | | | 0 | |
+---------------+--------------+------+-----+-----------+----------------+
Versions:
Apache/2.0.54 (Debian GNU/Linux) DAV/2 SVN/1.2.3 mod_python/3.1.3 Python/2.3.5 PHP/4.4.0-4
mysql Ver 14.7 Distrib 4.1.14, for pc-linux-gnu (i486) using readline 5.0
Config:
Server=1
StartPollers=5
StartTrappers=2
ListenIP=127.0.0.1
ListenPort=10051
HousekeepingFrequency=1
SenderFrequency=30
DebugLevel=3
Timeout=5
UnreachablePeriod=300
UnavailableDelay=15
UnavailableDelay=120
PidFile=/var/run/zabbix/zabbix_server.pid
LogFile=/var/log/zabbix/zabbix_server.log
AlertScriptsPath=/home/zabbix/bin/
DBHost=localhost
DBName=zabbix
DBUser=zabbix
DBPassword=xxxxxx