Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-433

Doesn't see the page with screen (Monitoring and configuration)

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Cannot Reproduce
    • Icon: Major Major
    • None
    • 1.4.5
    • None
    • None
    • the GUI run on FastCGI with Nginx on gentoo distribution. There are 3 agents all on gentoo distribution on 3 computers. One is the same where there are server and Frontend. The database is save in postgresql

      When I want see a page with screen :

      /screens.php or /screenconf.php

      I can't see it. The request is too long. After see in my SQL log I see that there are a loop in request. I isolate the boucle and I paste here :

      Sep 10 10:33:43 bacchus postgres[5120]: [61339-1] LOG: statement: select * from screens_items where screenid=2
      Sep 10 10:33:43 bacchus postgres[5120]: [61340-1] LOG: statement: select distinct itemid from graphs_items where graphid=2
      Sep 10 10:33:43 bacchus postgres[5120]: [61341-1] LOG: statement: select itemid from items where itemid in (18467,18468,18469) and hostid in (-1)
      Sep 10 10:33:43 bacchus postgres[5120]: [61342-1] LOG: statement: select distinct itemid from graphs_items where graphid=3
      Sep 10 10:33:43 bacchus postgres[5120]: [61343-1] LOG: statement: select itemid from items where itemid in (18470,18472,18473) and hostid in (-1)
      Sep 10 10:33:43 bacchus postgres[5120]: [61344-1] LOG: statement: select distinct itemid from graphs_items where graphid=4
      Sep 10 10:33:43 bacchus postgres[5120]: [61345-1] LOG: statement: select itemid from items where itemid in (18440,18443) and hostid in (-1)
      Sep 10 10:33:43 bacchus postgres[5120]: [61346-1] LOG: statement: select distinct itemid from graphs_items where graphid=5
      Sep 10 10:33:43 bacchus postgres[5120]: [61347-1] LOG: statement: select itemid from items where itemid in (18505,18506) and hostid in (-1)
      Sep 10 10:33:43 bacchus postgres[5120]: [61348-1] LOG: statement: select screenid from screens where screenid=2 and (screenid/100000000000000) in (0)
      Sep 10 10:33:43 bacchus postgres[5120]: [61349-1] LOG: statement: select distinct n.nodeid,n.name as node_name,h.hostid,h.host, min(r.permission) as permission,ug.userid from
      Sep 10 10:33:43 bacchus postgres[5120]: [61349-2] hosts h left join hosts_groups hg on hg.hostid=h.hostid left join groups g on g.groupid=hg.groupid left join rights r on
      Sep 10 10:33:43 bacchus postgres[5120]: [61349-3] r.id=g.groupid and r.type=1 left join users_groups ug on ug.usrgrpid=r.groupid and ug.userid=1 left join nodes n on
      Sep 10 10:33:43 bacchus postgres[5120]: [61349-4] (h.hostid/100000000000000)=n.nodeid group by h.hostid,n.nodeid,n.name,h.host,ug.userid order by n.name,n.nodeid, h.host,
      Sep 10 10:33:43 bacchus postgres[5120]: [61349-5] permission , userid
      Sep 10 10:33:43 bacchus postgres[5120]: [61350-1] LOG: statement: select n.nodeid,min(r.permission) as permission, g.userid from nodes n left join rights r on r.id=n.nodeid and
      Sep 10 10:33:43 bacchus postgres[5120]: [61350-2] r.type=0 left join users_groups g on r.groupid=g.usrgrpid and g.userid=1 group by n.nodeid, g.userid order by nodeid desc,
      Sep 10 10:33:43 bacchus postgres[5120]: [61350-3] userid desc, permission desc
      Sep 10 10:33:43 bacchus postgres[5120]: [61351-1] LOG: statement: SELECT n.nodeid as nodeid,n.name as node_name,hg.groupid,hg.name,min(r.permission) as permission,g.userid FROM
      Sep 10 10:33:43 bacchus postgres[5120]: [61351-2] groups hg LEFT JOIN rights r ON r.id=hg.groupid and r.type=1 LEFT JOIN users_groups g ON r.groupid=g.usrgrpid and g.userid=1
      Sep 10 10:33:43 bacchus postgres[5120]: [61351-3] LEFT JOIN nodes n ON (hg.groupid/100000000000000)=n.nodeid GROUP BY n.nodeid, n.name, hg.groupid, hg.name, g.userid, g.userid
      Sep 10 10:33:43 bacchus postgres[5120]: [61351-4] ORDER BY n.name, hg.name, permission
      Sep 10 10:33:43 bacchus postgres[5120]: [61352-1] LOG: statement: select n.nodeid,min(r.permission) as permission, g.userid from nodes n left join rights r on r.id=n.nodeid and
      Sep 10 10:33:43 bacchus postgres[5120]: [61352-2] r.type=0 left join users_groups g on r.groupid=g.usrgrpid and g.userid=1 group by n.nodeid, g.userid order by nodeid desc,
      Sep 10 10:33:43 bacchus postgres[5120]: [61352-3] userid desc, permission desc
      Sep 10 10:33:43 bacchus postgres[5120]: [61353-1] LOG: statement: select * from screens_items where screenid=2
      Sep 10 10:33:43 bacchus postgres[5120]: [61354-1] LOG: statement: select distinct itemid from graphs_items where graphid=2
      Sep 10 10:33:43 bacchus postgres[5120]: [61355-1] LOG: statement: select itemid from items where itemid in (18467,18468,18469) and hostid in (-1)
      Sep 10 10:33:43 bacchus postgres[5120]: [61356-1] LOG: statement: select distinct itemid from graphs_items where graphid=3
      Sep 10 10:33:43 bacchus postgres[5120]: [61357-1] LOG: statement: select itemid from items where itemid in (18470,18472,18473) and hostid in (-1)
      Sep 10 10:33:43 bacchus postgres[5120]: [61358-1] LOG: statement: select distinct itemid from graphs_items where graphid=4
      Sep 10 10:33:43 bacchus postgres[5120]: [61359-1] LOG: statement: select itemid from items where itemid in (18440,18443) and hostid in (-1)
      Sep 10 10:33:43 bacchus postgres[5120]: [61360-1] LOG: statement: select distinct itemid from graphs_items where graphid=5
      Sep 10 10:33:43 bacchus postgres[5120]: [61361-1] LOG: statement: select itemid from items where itemid in (18505,18506) and hostid in (-1)
      Sep 10 10:33:43 bacchus postgres[5120]: [61362-1] LOG: statement: select screenid from screens where screenid=2 and (screenid/100000000000000) in (0)
      Sep 10 10:33:43 bacchus postgres[5120]: [61363-1] LOG: statement: select distinct n.nodeid,n.name as node_name,h.hostid,h.host, min(r.permission) as permission,ug.userid from
      Sep 10 10:33:43 bacchus postgres[5120]: [61363-2] hosts h left join hosts_groups hg on hg.hostid=h.hostid left join groups g on g.groupid=hg.groupid left join rights r on
      Sep 10 10:33:43 bacchus postgres[5120]: [61363-3] r.id=g.groupid and r.type=1 left join users_groups ug on ug.usrgrpid=r.groupid and ug.userid=1 left join nodes n on
      Sep 10 10:33:43 bacchus postgres[5120]: [61363-4] (h.hostid/100000000000000)=n.nodeid group by h.hostid,n.nodeid,n.name,h.host,ug.userid order by n.name,n.nodeid, h.host,
      Sep 10 10:33:43 bacchus postgres[5120]: [61363-5] permission , userid
      Sep 10 10:33:43 bacchus postgres[5120]: [61364-1] LOG: statement: select n.nodeid,min(r.permission) as permission, g.userid from nodes n left join rights r on r.id=n.nodeid and
      Sep 10 10:33:43 bacchus postgres[5120]: [61364-2] r.type=0 left join users_groups g on r.groupid=g.usrgrpid and g.userid=1 group by n.nodeid, g.userid order by nodeid desc,
      Sep 10 10:33:43 bacchus postgres[5120]: [61364-3] userid desc, permission desc
      Sep 10 10:33:43 bacchus postgres[5120]: [61365-1] LOG: statement: SELECT n.nodeid as nodeid,n.name as node_name,hg.groupid,hg.name,min(r.permission) as permission,g.userid FROM
      Sep 10 10:33:43 bacchus postgres[5120]: [61365-2] groups hg LEFT JOIN rights r ON r.id=hg.groupid and r.type=1 LEFT JOIN users_groups g ON r.groupid=g.usrgrpid and g.userid=1
      Sep 10 10:33:43 bacchus postgres[5120]: [61365-3] LEFT JOIN nodes n ON (hg.groupid/100000000000000)=n.nodeid GROUP BY n.nodeid, n.name, hg.groupid, hg.name, g.userid, g.userid
      Sep 10 10:33:43 bacchus postgres[5120]: [61365-4] ORDER BY n.name, hg.name, permission
      Sep 10 10:33:43 bacchus postgres[5120]: [61366-1] LOG: statement: select n.nodeid,min(r.permission) as permission, g.userid from nodes n left join rights r on r.id=n.nodeid and
      Sep 10 10:33:43 bacchus postgres[5120]: [61366-2] r.type=0 left join users_groups g on r.groupid=g.usrgrpid and g.userid=1 group by n.nodeid, g.userid order by nodeid desc,
      Sep 10 10:33:43 bacchus postgres[5120]: [61366-3] userid desc, permission desc
      Sep 10 10:33:43 bacchus postgres[5120]: [61367-1] LOG: statement: select * from screens_items where screenid=2
      Sep 10 10:33:43 bacchus postgres[5120]: [61368-1] LOG: statement: select distinct itemid from graphs_items where graphid=2
      Sep 10 10:33:43 bacchus postgres[5120]: [61369-1] LOG: statement: select itemid from items where itemid in (18467,18468,18469) and hostid in (-1)
      Sep 10 10:33:43 bacchus postgres[5120]: [61370-1] LOG: statement: select distinct itemid from graphs_items where graphid=3
      Sep 10 10:33:43 bacchus postgres[5120]: [61371-1] LOG: statement: select itemid from items where itemid in (18470,18472,18473) and hostid in (-1)
      Sep 10 10:33:43 bacchus postgres[5120]: [61372-1] LOG: statement: select distinct itemid from graphs_items where graphid=4
      Sep 10 10:33:43 bacchus postgres[5120]: [61373-1] LOG: statement: select itemid from items where itemid in (18440,18443) and hostid in (-1)
      Sep 10 10:33:43 bacchus postgres[5120]: [61374-1] LOG: statement: select distinct itemid from graphs_items where graphid=5
      Sep 10 10:33:43 bacchus postgres[5120]: [61375-1] LOG: statement: select itemid from items where itemid in (18505,18506) and hostid in (-1)
      Sep 10 10:33:43 bacchus postgres[5120]: [61376-1] LOG: statement: select screenid from screens where screenid=2 and (screenid/100000000000000) in (0)
      Sep 10 10:33:43 bacchus postgres[5120]: [61377-1] LOG: statement: select distinct n.nodeid,n.name as node_name,h.hostid,h.host, min(r.permission) as permission,ug.userid from
      Sep 10 10:33:43 bacchus postgres[5120]: [61377-2] hosts h left join hosts_groups hg on hg.hostid=h.hostid left join groups g on g.groupid=hg.groupid left join rights r on
      Sep 10 10:33:43 bacchus postgres[5120]: [61377-3] r.id=g.groupid and r.type=1 left join users_groups ug on ug.usrgrpid=r.groupid and ug.userid=1 left join nodes n on
      Sep 10 10:33:43 bacchus postgres[5120]: [61377-4] (h.hostid/100000000000000)=n.nodeid group by h.hostid,n.nodeid,n.name,h.host,ug.userid order by n.name,n.nodeid, h.host,
      Sep 10 10:33:43 bacchus postgres[5120]: [61377-5] permission , userid
      Sep 10 10:33:43 bacchus postgres[5120]: [61378-1] LOG: statement: select n.nodeid,min(r.permission) as permission, g.userid from nodes n left join rights r on r.id=n.nodeid and
      Sep 10 10:33:43 bacchus postgres[5120]: [61378-2] r.type=0 left join users_groups g on r.groupid=g.usrgrpid and g.userid=1 group by n.nodeid, g.userid order by nodeid desc,
      Sep 10 10:33:43 bacchus postgres[5120]: [61378-3] userid desc, permission desc
      Sep 10 10:33:43 bacchus postgres[5120]: [61379-1] LOG: unexpected EOF on client connection

      .
      With this issue, I can't see screen and configure it. It's appear when I try configure a screen to test.

            Unassigned Unassigned
            shingara Cyril Mougel
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: