[ZBX-14555] Can't select or update all items due many number of items and big ids. Request-URI Too Long Created: 2018 Jul 03  Updated: 2018 Sep 21

Status: Open
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 4.0.0alpha9
Fix Version/s: None

Type: Problem report Priority: Trivial
Reporter: Natalja Romancaka Assignee: Zabbix Development Team
Resolution: Unresolved Votes: 0
Labels: ids, items, massupdate
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: PNG File alert.png     PNG File loading.png    
Issue Links:
Duplicate

 Description   

Steps to reproduce:

  1. Create LLD
  2. Change items nextid in ids table to 999000 (to easier reach expected result)
  3. Generate 1000+ discovered items
  4. Set 1000 rows per page in user profile
  5. Go to Hosts-> Items
  6. Select all

Result:
Appears alert "We are sorry, the maximum possible number of elements to remember has been reached."

Steps to reproduce:

  1. first 3 steps as in previous scenario
  2. Set 500 rows per page in user profile
  3. Select all and press Mass update
  4. Check "Master item" and press Select

Result:
always displayed loading in popup, because of error "Failed to load resource: the server responded with a status of 414 (Request-URI Too Long)"



 Comments   
Comment by Oleksii Zagorskyi [ 2018 Sep 21 ]

ZBX-13332 is related.

Comment by Oleksii Zagorskyi [ 2018 Sep 21 ]

Let me post here one more real case (production). Not sure I need to report a new ZBX.

When attempting to link templates to another template.
Open one template, on "Linked templates" tab click Select button and you will see the "Request-URI Too Long" Apaches's error page.

In this real case URL is ~26K characters long.
See documentation for the param https://httpd.apache.org/docs/2.4/mod/core.html, there is an important note where the the param should be set.

Depending on distro and Apache configuration, as a workaround, need to add a line:

LimitRequestLine 30000

to one of these locations:

  • on RHEL/CentOS (comes withOUT virtual hosts enabled, if so) to /etc/httpd/conf/httpd.conf
  • on Debian/Ubuntu (comes with virtual hosts enabled) to /etc/apache2/sites-enabled/000-default.conf inside section <VirtualHost *:80>

The button Select constructs very long URL like:

&excludeids[]=10186&excludeids[]=10203&excludeids[]=10225&excludeids[]=10237

where are listed IDs of templates:

  • current template itself
  • already linked templates
  • templates linked to

The last point causes the URL to be so big.
Good example is build-in template "Template Module Generic SNMPv2", which causes 642 chars long link.

Generated at Sun Apr 06 21:48:23 EEST 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.