[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 ?
is the proxy database new, created for that exact same version that is running ?
is the server upgraded version, or a new installation of that specific version ?

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.
This line should be such:
[25916,7,"","",10064,"vm.memory.size[free]",30,0,3,"","",0,"","","0","","","","",0,0,"","","","",0,"",null,""]

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

Generated at Fri Mar 29 07:24:46 EET 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.