[ZBX-7561] [Z3005] query failed: [1364] Field 'hardware_full' doesn't have a default value [insert into host_inventory (hostid,inventory_mode) values Created: 2013 Dec 18 Updated: 2017 May 30 Resolved: 2014 Jan 09 |
|
Status: | Closed |
Project: | ZABBIX BUGS AND ISSUES |
Component/s: | Server (S) |
Affects Version/s: | 2.2.0 |
Fix Version/s: | 2.2.2rc1, 2.3.0 |
Type: | Incident report | Priority: | Major |
Reporter: | Robert VERBERT | Assignee: | Unassigned |
Resolution: | Fixed | Votes: | 0 |
Labels: | dbpatches, inventory | ||
Remaining Estimate: | Not Specified | ||
Time Spent: | Not Specified | ||
Original Estimate: | Not Specified | ||
Environment: |
Hedhat 6.4 Linux server OS on VMWARE machine ( 8Gb memory , 50Gb disk ) |
Description |
into the "zabbix_server.log" i find regular lines like this |
Comments |
Comment by richlv [ 2013 Dec 18 ] |
is this an upgrade or fresh installation ? |
Comment by Robert VERBERT [ 2013 Dec 18 ] |
This is a fresh install ( test from source version 2.2.0 ) This fresh install has only one item reference : a VMWare hyperV 5.1 The ame of the test is: to let the zabbix analyze the VMWare environment and automaticly start to monitor a newly created server. ( without intervention. ) |
Comment by richlv [ 2013 Dec 18 ] |
hrm, hardware_full field indeed does not have default value... |
Comment by Juris Miščenko (Inactive) [ 2014 Jan 03 ] |
Fixed in development branch svn://svn.zabbix.com/branches/dev/ZBX-7561 |
Comment by Alexander Vladishev [ 2014 Jan 09 ] |
(1) The changes should affect mysql only. sasha CLOSED |
Comment by Alexander Vladishev [ 2014 Jan 09 ] |
(2) Your solution isn't effective. The list of fields and empty values for them can be prepared once outside of a cycle. jurism Field determination has been moved outside of the general host loop. RESOLVED. sasha CLOSED |
Comment by Alexander Vladishev [ 2014 Jan 14 ] |
(3) compilation warning lld_host.c: In function ‘DBlld_hosts_save’: lld_host.c:1695:35: warning: variable ‘t’ set but not used [-Wunused-but-set-variable] sasha CLOSED |
Comment by Johannes [ 2014 Jan 15 ] |
is there a possiblity available to implement the change in 2.2.1? EDIT: changed sqlmode (mysql 5.5) to '' (to avoid using strict mode) temporary fixed crashes |
Comment by Alexander Vladishev [ 2014 Jan 18 ] |
johansen, yes, it is possible to use changes in the development branch for version 2.2.1. |
Comment by Alexander Vladishev [ 2014 Jan 18 ] |
Tested. Please review my changes in r41639. jurism Looks good! CLOSED. |
Comment by Alexander Vladishev [ 2014 Jan 29 ] |
Fixed in pre-2.2.2 r41946 and pre-2.3.0 (trink) r41947. |