[ZBX-4628] Can't use Zabbix Proxy 1.9.10 (invalid number of fields) Created: 2012 Feb 07 Updated: 2017 May 30 Resolved: 2012 Feb 13 |
|
Status: | Closed |
Project: | ZABBIX BUGS AND ISSUES |
Component/s: | Proxy (P), Server (S) |
Affects Version/s: | 2.0.0rc1 |
Fix Version/s: | 2.0.0rc1 |
Type: | Incident report | Priority: | Critical |
Reporter: | Marcus Oliveira | Assignee: | Unassigned |
Resolution: | Fixed | Votes: | 0 |
Labels: | None | ||
Remaining Estimate: | Not Specified | ||
Time Spent: | Not Specified | ||
Original Estimate: | Not Specified | ||
Environment: |
CentOS 6.2 x86_64 and also reproduced on FreeBSD 8.1 amd64 |
Description |
When trying to use Zabbix Proxy 1.9.9/1.9.10 I receive the error described below (the proxy starts but Server is unable to receive data) : 25663:20120207:183323.768 invalid number of fields "[25916,7,"","",10064,"vm.memory.size[free]",30,0,3,"","",0,"","","0","","","","",0,0,"","","","",0,"",,""]" I can confirm the problem happens on MySQL and SQLite3. Thanks for the awsome software. Marcus |
Comments |
Comment by Marcus Oliveira [ 2012 Feb 07 ] |
The problem also happens on 1.9.8. Marcus |
Comment by richlv [ 2012 Feb 07 ] |
are you using the exact same version of server and proxy ? |
Comment by Marcus Oliveira [ 2012 Feb 07 ] |
> are you using the exact same version of server and proxy ? Tried almost everything... including compiling the binaries for both Server and Proxy with the same tar file. > is the proxy database new, created for that exact same version that is running ? Brand new. Yes. is the server upgraded version, or a new installation of that specific version ? Server is an upgraded database from 1.8.10. Proxy is a new database as said previously. Thanks for the fast answer... Marcus |
Comment by Marcus Oliveira [ 2012 Feb 08 ] |
Just to be clear enough : The error is generated in Zabbix Proxy's log. Thanks for the awesome software. Marcus |
Comment by Marcus Oliveira [ 2012 Feb 09 ] |
Could you tell me the table where this line would be inserting ? I'll try to identify the problem. OBS : This should be informed in the debug message. Marcus |
Comment by Alexander Vladishev [ 2012 Feb 13 ] |
Could you execute SQL statement on server side and attach its output: select * from items where itemid = 25916 What database you use on server side? The problem happens in the absence of one of values. But I can't reproduce it. |
Comment by Alexander Vladishev [ 2012 Feb 13 ] |
A problem is localized! It will be fixed as soon as possible. |
Comment by Alexander Vladishev [ 2012 Feb 13 ] |
Fixed in the development branch svn://svn.zabbix.com/branches/dev/ZBX-4628 |
Comment by dimir [ 2012 Feb 13 ] |
Tested. The null-value check was added. |
Comment by Marcus Oliveira [ 2012 Feb 13 ] |
Thanks a lot. When will it be implemented in the nightly builds so I can test it? Marcus |
Comment by Alexander Vladishev [ 2012 Feb 13 ] |
Fixed in version pre-1.9.10, revision 25365. Changes will be included into the night build also. Please confirm, if the problem doesn't repeat. |
Comment by Marcus Oliveira [ 2012 Feb 14 ] |
Thanks, Compiled and updated Server and Proxy. Now we have a new error : 56829:20120213:225945.279 failed to update local proxy cofiguration copy: column "hosts.ipmi_username" cannot be null Marcus |
Comment by Alexander Vladishev [ 2012 Feb 14 ] |
What database you use on server side? |
Comment by Marcus Oliveira [ 2012 Feb 14 ] |
Oracle. Marcus |
Comment by Alexander Vladishev [ 2012 Feb 14 ] |
Fixed collecting of configuration data by Zabbix server with ORACLE DB in version pre-1.9.10, revision 25380. |
Comment by Alexander Vladishev [ 2012 Feb 14 ] |
Please retest it on your environment. |
Comment by Marcus Oliveira [ 2012 Feb 14 ] |
Sure. I'll do it as soon the nightly build is available. But, just to make sure. This error is seen in the Proxy side log. Was it a problem in the Server side ? I'd like to understand how it works so I can be more effective in helping to find the problems. Marcus |
Comment by Marcus Oliveira [ 2012 Feb 15 ] |
It worked, thanks a lot. Marcus |