Zabbix Proxy DB update error

[globe]

HI All,

since a few days I added a new Proxy to the Master Node and i get some strange errors of the regexp :
query failed: [1364] Field 'test_string' doesn't have a default value [insert into regexps (regexpid,name) values

both server and proxy are on 2.0.6
anybody an idea?

Thanks Globe

Debug output:

 12870:20130902:154900.082 End of process_proxyconfig_table():SUCCEED
 12870:20130902:154900.103 In process_proxyconfig_table() table:'drules'
 12870:20130902:154900.103 query [txnlev:1] [select druleid from drules]
 12870:20130902:154900.104 End of process_proxyconfig_table():SUCCEED
 12870:20130902:154900.104 In process_proxyconfig_table() table:'dchecks'
 12870:20130902:154900.104 query [txnlev:1] [select dcheckid from dchecks]
 12870:20130902:154900.104 End of process_proxyconfig_table():SUCCEED
 12870:20130902:154900.104 In process_proxyconfig_table() table:'regexps'
 12870:20130902:154900.104 query [txnlev:1] [select regexpid from regexps]
 12870:20130902:154900.104 query [txnlev:1] [insert into regexps (regexpid,name) values (200200000000001,'File systems for discovery');
insert into regexps (regexpid,name) values (200200000000002,'Network interfaces for discovery');
insert into regexps (regexpid,name) values (200200000000003,'Storage devices for SNMP discovery');
]
 12870:20130902:154900.104 [Z3005] query failed: [1364] Field 'test_string' doesn't have a default value [insert into regexps (regexpid,name) values (200200000000001,'File systems fo
r discovery');
insert into regexps (regexpid,name) values (200200000000002,'Network interfaces for discovery');
insert into regexps (regexpid,name) values (200200000000003,'Storage devices for SNMP discovery');
]
 12870:20130902:154900.104 query [insert into regexps (regexpid,name) values (200200000000001,'File systems for discovery');
insert into regexps (regexpid,name) values (200200000000002,'Network interfaces for discovery');
insert into regexps (regexpid,name) values (200200000000003,'Storage devices for SNMP discovery');
] failed, setting transaction as failed
 12870:20130902:154900.104 End of process_proxyconfig_table():FAIL
 12870:20130902:154900.104 failed to update local proxy configuration copy: database error
 12870:20130902:154900.104 query [txnlev:1] [rollback;]
 12873:20130902:154900.286 In host_availability_sender()
 12873:20130902:154900.286 In get_host_availability_data()
 12873:20130902:154900.286 query [txnlev:0] [select hostid,available,error,snmp_available,snmp_error,ipmi_available,ipmi_error,jmx_available,jmx_error from hosts]
 12873:20130902:154900.287 End of get_host_availability_data():FAIL
 12873:20130902:154900.287 End of host_availability_sender()
 12873:20130902:154900.287 In history_sender()
 12873:20130902:154900.287 In proxy_get_history_data() table:'proxy_history'
 12873:20130902:154900.287 In proxy_get_lastid() [proxy_history.history_lastid]
 12873:20130902:154900.287 query [txnlev:0] [select nextid from ids where table_name='proxy_history' and field_name='history_lastid']
 12873:20130902:154900.287 End of proxy_get_lastid():0

[Heilig]

What version of mysql are you using? Please, read:

https://support.zabbix.com/browse/ZBX-6936

[globe]

Hi Heilig,

I'm using mysql Ver 14.14 Distrib 5.5.32, for Linux (x86_64)
I also adapted the description fields and 'test_string' in the table regexps to just text as mentioned in the Bug below and now it's working.

Thanks Globe