DB field to short for logfile monitoring

[Doomshammer]

Hi,

my Zabbix Server just died while writing logfiles into the DB:

15821:20080416:124347 Query::insert into history_log (id,clock,itemid,timestamp,value,source,severity) values (32,1208364227,19802,0,'Apr 14 03:34:09 zabbixzone sm-mta[12467]: [ID 801593 mail.info] m3E7Y9vd012467: from=<[email protected]>, size=499, class=0, nrcpts=1, msgid=<[email protected] domain.com>, proto=SMTP, daemon=MTA-v4, relay=localhost [127.0.0.1]','',0)
15821:20080416:124347 Query failed:PGRES_FATAL_ERROR:ERROR: value too long for type character varying(255)

I can alter the table, but I think this should be done for the official release as well:

ALTER TABLE history_log ALTER value TYPE character varying(1024);

[Doomshammer]

This will be needed then as well:

zabbix=> ALTER TABLE items ALTER pvalue TYPE character varying(1024);
zabbix=> ALTER TABLE items ALTER prevvalue TYPE character varying(1024);