1.3.5 zabbix_server crash.

[zabbix_es]

Field iprange is no in table drules ...



21903:20070418:110333 Starting zabbix_server. ZABBIX 1.3.5.
21903:20070418:110333 **** Enabled features ****
21903:20070418:110333 SNMP monitoring: NO
21903:20070418:110333 WEB monitoring: YES
21903:20070418:110333 Jabber notifications: NO
21903:20070418:110333 **************************
21904:20070418:110333 server #1 started [Poller. SNMP:OFF]
21905:20070418:110333 server #2 started [Poller. SNMP:OFF]
21906:20070418:110333 server #3 started [Poller. SNMP:OFF]
21907:20070418:110333 server #4 started [Poller. SNMP:OFF]
21908:20070418:110333 server #5 started [Poller. SNMP:OFF]
21909:20070418:110333 server #6 started [Poller. SNMP:OFF]
21910:20070418:110333 server #7 started [Trapper]
21911:20070418:110333 server #8 started [Trapper]
21912:20070418:110333 server #9 started [Trapper]
21913:20070418:110333 server #10 started [Trapper]
21914:20070418:110333 server #11 started [Trapper]
21915:20070418:110333 server #12 started [ICMP pinger]
21919:20070418:110333 server #13 started [Alerter]
21920:20070418:110333 server #14 started [Housekeeper]
21920:20070418:110333 Executing housekeeper
21922:20070418:110333 server #16 started [Poller for unreachable hosts. SNMP:OFF]
21923:20070418:110333 server #17 started [Node watcher. Node ID:0]
21924:20070418:110333 server #18 started [HTTP Poller]
21925:20070418:110333 server #19 started [HTTP Poller]
21921:20070418:110333 server #15 started [Timer]
21926:20070418:110333 server #20 started [HTTP Poller]
21927:20070418:110333 server #21 started [HTTP Poller]
21928:20070418:110333 server #22 started [HTTP Poller]
21930:20070418:110333 server #23 started [Discoverer]
21903:20070418:110333 server #0 started [Watchdog]
21930:20070418:110334 Query::select druleid,iprange,delay,nextcheck,name,status from drules where status=0 and nextcheck<=1176887013 and mod(druleid,1)=0 and druleid>=100000000000000*0 and druleid<=(100000000000000*0+99999999999999)
21930:20070418:110334 Query failed:Unknown column 'iprange' in 'field list' [1054]
21903:20070418:110334 One child process died. Exiting ...
21903:20070418:110336 ZABBIX Server stopped

[Calypso]

Well, as a matter of fact, it is:

CREATE TABLE drules (
druleid bigint unsigned DEFAULT '0' NOT NULL,
name varchar(255) DEFAULT '' NOT NULL,
iprange varchar(255) DEFAULT '' NOT NULL,

[from mysql.sql in create/schema]

However, it wasn't in 1.3.4 - if you use 1.3.5 in 1.3.4 dataschema you have a problem...

If you don't use mysql as database backend, forgive my comment.

[NOB]

Hi,

of course, the schema has changed from 1.3.4 to 1.3.5.
Even for PostgreSQL, of course.
The schema of a certain version is identical (modulo DB-specific differences
e.g. in SQL syntax) for all DBs.

I did create an update script (didn't want to loose all my data)
for me. For simplicity, it drops a few tables I didn't use before
but does updates to other tables (removal of columns).

Regards,

Norbert.

[zabbix_es]

1.3.5 Update of table drules from 1.3.4

Thank you Calypso!.

Yes, in fact, MySQL is my database backend.

I fixed this error with next SQL sentence:

ALTER TABLE zabbix.drules ADD iprange VARCHAR(255) DEFAULT '' NOT NULL
AFTER name;

Well, as a matter of fact, it is:

CREATE TABLE drules (
druleid bigint unsigned DEFAULT '0' NOT NULL,
name varchar(255) DEFAULT '' NOT NULL,
iprange varchar(255) DEFAULT '' NOT NULL,

[from mysql.sql in create/schema]

However, it wasn't in 1.3.4 - if you use 1.3.5 in 1.3.4 dataschema you have a problem...

If you don't use mysql as database backend, forgive my comment.

[zabbix_es]

1.3.5 Schema differences with 1.3.4

OK,

I will compare both schemas and I will try to do an MySQL update script.

[NOB]

Hi,

rows ipfirst and iplast were removed from this DB table and other
changes.

Here is my update script - ymmv - for PostgreSQL.
Warning: It drops tables drules and slides
instead of doing the right updates.
I didn't have any entries in those.

HTH,

Norbert.

[zabbix_es]

MySQL schema upgrade zabbix from v1.3.4 to v1.3.5

I have attached MySQL script to upgrade schema from zabbix v1.3.4 to v1.3.5.

[zabbix_es]

Oops!

Sorry! I forgot to attach the script ...

I have attached MySQL script to upgrade schema from zabbix v1.3.4 to v1.3.5.