[ZBXNEXT-6109] LLD Max Returned value through a Proxy limit 65536 characters ? Created: 2020 Aug 05 Updated: 2020 Sep 08 Resolved: 2020 Sep 08 |
|
Status: | Closed |
Project: | ZABBIX FEATURE REQUESTS |
Component/s: | Documentation (D) |
Affects Version/s: | 5.0.2 |
Fix Version/s: | None |
Type: | Change Request | Priority: | Critical |
Reporter: | Dimitri Bellini | Assignee: | Andris Zeila |
Resolution: | Cannot Reproduce | Votes: | 0 |
Labels: | None | ||
Remaining Estimate: | Not Specified | ||
Time Spent: | Not Specified | ||
Original Estimate: | Not Specified | ||
Environment: |
Centos 7.x |
Attachments: |
![]() ![]() ![]() ![]() ![]() |
||||
Issue Links: |
|
Description |
Hi DevTeam, we have discovery a very confusing situation/limit of LLD disocvery. From the Doc (https://www.zabbix.com/documentation/current/manual/discovery/low_level_discovery)
So the Proxy have a huge limit to only 64k returned value! I think this a problem for Big installation that use Zabbix Proxy to monitoring Windows Services or applications/RestAPI. What do you think to find a solution and align the limits of Zabbix Server and Zabbix Proxy to the same level? Thanks so much
|
Comments |
Comment by Oleksii Zagorskyi [ 2020 Aug 05 ] |
On mysql "proxy_history.value" has "longtext" type, which is limited for 4GB. |
Comment by Dimitri Bellini [ 2020 Aug 05 ] |
HI Oleksii, Fantastic but why do you have so huge type Strange?
|
Comment by Oleksii Zagorskyi [ 2020 Aug 05 ] |
I am agree that makes sense to add one more column to the table - "Longtext". |
Comment by Dimitri Bellini [ 2020 Aug 05 ] |
Hi Oleksii, Maybe i missed something but how we can decide what table the LLD have to use on the Proxy? At the moment with a fresh Zabbix 5.0 installation we still have this kind of limits, do you mention some sort of workaround? Thanks so much |
Comment by Oleksii Zagorskyi [ 2020 Aug 05 ] |
The limit comes from user parameter, not from the fact that you use proxy. Maybe the 2nd sentence, you initially quoted, sounds more scary than it is actually, and it may mislead. I'd rewrite the sentence or would remove it at all. |
Comment by Andris Zeila [ 2020 Aug 05 ] |
The table lists data limits for item value types (character, log text). LLD rules (while technically stored into items table) is different matter. |
Comment by Dimitri Bellini [ 2020 Aug 05 ] |
I think if the returned value is related to DB type i would suggest to mention on the docs. In our case we have installed the Zabbix Proxy DB on a Centos 7.7 with the default MariaDB 5.5.64, at the moment the table of "proxy_history" is defined like this: so is defined as "longtext", maybe is a problem related to the MariaDB version 5.5 ? |
Comment by Dimitri Bellini [ 2020 Sep 08 ] |
The problem was not reproducible, so we can close the issue. |