DB flexible intervals field too small ! Can i resize db field ?

[alex790]

Hi,
I tried to specify item flexible interval, every 10s when between H:59 and H+1:10, by specifying all time intervals (reading the manual, i did not find any better way), but the configuration line is too long for the database:

Error when importing my XML:

(...)
UPDATE items SET description='Resque Redis data collection time',key_='resque_monitor_to_zabbix',hostid=10068,delay=60,history=90,type=0,snmp_community='',snmp_oid='',value_type=3, data_type=0,trapper_hosts='',snmp_port=161,units='s',multiplier=0,delta=0,snmpv3_securityname='', snmpv3_securitylevel=0,snmpv3_authpassphrase='',snmpv3_privpassphrase='',formula='0',trends=365,logtimefmt='', valuemapid=0,delay_flex=
'10/1-7,23:59-00:10;10/1-7,00:59-01:10;10/1-7,01:59-02:10;10/1-7,02:59-03:10;10/1-7,03:59-04:10;10/1-7,04:59-05:10;10/1-7,05:59-06:10;10/1-7,06:59-07:10;10/1-7,07:59-08:10;10/1-7,08:59-09:10;10/1-7,09:59-10:10;10/1-7,10:59-11:10;10/1-7,11:59-12:10;10/1-7,12:59-13:10;10/1-7,13:59-14:10;10/1-7,14:59-15:10;10/1-7,15:59-16:10;10/1-7,16:59-17:10;10/1-7,17:59-18:10;10/1-7,18:59-19:10;10/1-7,19:59-20:10;10/1-7,20:59-21:10;10/1-7,21:59-22:10;10/1-7,22:59-23:10'
,params='',ipmi_sensor='',templateid=24463,authtype=0,username='',password='',publickey='',privatekey='' WHERE itemid=24595]
[ERROR: value too long for type character varying(255)]
pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block[/usr/share/zabbix/include/db.inc.php:439]
Error in query [SELECT * FROM items WHERE (itemid IN (24595)) ]
[ERROR: current transaction is aborted, commands ignored until end of transaction block]
(...)

Can i simply alter the items.delay_flex field (PostgreSQL) to a varchar(1500) for example ? Would i need to resize some other fields on some other tables as well ?

[richlv]

maybe you can try adding multiple flexible intervals ?

[alex790]

It does not change anything. Zabbix (either web interface or xml import) concatenates all in one string before storing in the 'delay_flex' db field. The field varchar(255) is simply too short and i wonder of any possible side effects if i alter the field to varchar(1500) for example.
I also wonder if there is simply a better way to achieve the same thing (cf How to flexible intervals -each- hour during a few minutes )

[richlv]

It does not change anything. Zabbix (either web interface or xml import) concatenates all in one string before storing in the 'delay_flex' db field.

ah, darn, right. might be worth searching the issue tracker for already reported potential improvements and reporting a new one if none found