[ZBX-4586] Incorrect application on cloned item Created: 2012 Jan 26  Updated: 2017 May 30  Resolved: 2012 Jan 31

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: API (A), Frontend (F)
Affects Version/s: 1.8.10, 1.9.8 (beta)
Fix Version/s: 1.8.11, 1.9.9 (beta)

Type: Incident report Priority: Blocker
Reporter: Alexander Vladishev Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: applications, cloning, items
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: JPEG File screenshot-1.jpg     JPEG File screenshot-2.jpg     JPEG File screenshot-3.jpg     JPEG File screenshot-4.jpg     JPEG File screenshot-5.jpg    
Issue Links:
Duplicate

 Description   

– Posted by Kodai Terashima –

I confirmed this issue.

1. open item configuration screen (specific item)
2. press "clone" (screenshot-1)
3. change "Host" (screenshot-2), and save
4. both of origial item and copied item are same host in [Monitoring]->[Latest Data] screen.

  • This problem is occurred when original item has application.
  • In configuration screen, copied item don't have any problem, only in latest data screen has problem.
  • if we copy same item using bottom of item list (mass update function), this problem is not occurred.


 Comments   
Comment by Pavels Jelisejevs (Inactive) [ 2012 Jan 27 ]

In the trunk such items are not displayed on Latest Data page at all.

Comment by Pavels Jelisejevs (Inactive) [ 2012 Jan 27 ]

Fixed for 1.8 in /branches/dev/ZBX-4586.

RESOLVED.

Comment by Pavels Jelisejevs (Inactive) [ 2012 Jan 31 ]

Added item's application validation to the Item.update and Item.create API methods.

Comment by Alexander Vladishev [ 2012 Jan 31 ]

Successfully tested!

Please review my changes in r25102.

Comment by Pavels Jelisejevs (Inactive) [ 2012 Jan 31 ]

Merged to 1.8 r25112.

Comment by Pavels Jelisejevs (Inactive) [ 2012 Jan 31 ]

My mistake, it seems that cloning works correctly in the trunk, but I've added the same application validation I've implemented in 1.8. It's available in /branches/dev/ZBX-4586-trunk.

Comment by Alexander Vladishev [ 2012 Feb 01 ]

(1) A 'host' field is not used
class.citemgeneral.php:119,133

<pavels> RESOLVED.
<Sasha> CLOSED

Comment by Alexander Vladishev [ 2012 Feb 01 ]

(2) class.citemgeneral.php:284 An error message violate coding guidelines.

<pavels> RESOLVED.
<Sasha> CLOSED

Comment by Alexander Vladishev [ 2012 Feb 01 ]

(3) Errors, when creating new item with applications:

  • in_array() expects parameter 2 to be array, null given [api/classes/class.citemgeneral.php:283]
  • Undefined index: name [api/classes/class.citemgeneral.php:284]
  • Application with ID "292" is not available on host "" [CItem.create -> CItem.checkInput -> CItemGeneral.checkInput]

<pavels> RESOLVED.
<Sasha> CLOSED

Comment by Pavels Jelisejevs (Inactive) [ 2012 Feb 01 ]

Merged to trunk r25140.

CLOSED.





[ZBX-4584] unsuccessful iconmap update claims it was "creating" Created: 2012 Jan 26  Updated: 2017 May 30  Resolved: 2012 Jan 26

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: API (A)
Affects Version/s: None
Fix Version/s: 1.9.9 (beta)

Type: Incident report Priority: Minor
Reporter: richlv Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: iconmapping
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified


 Description   

splitting out (9) from ZBXNEXT-785

class.ciconmap.php : public function update(array $iconMaps)
"self::exception(ZBX_API_ERROR_PERMISSIONS, _('Only super admins can create icon maps.'));"

update function claims creation was unsuccessful



 Comments   
Comment by Alexey Fukalov [ 2012 Jan 26 ]

svn://svn.zabbix.com/trunk 25028





[ZBX-4577] Proxy does not synchronize: failed to update local proxy cofiguration copy Created: 2012 Jan 23  Updated: 2017 May 30  Resolved: 2012 Jan 27

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Java gateway (J)
Affects Version/s: None
Fix Version/s: 1.9.9 (beta)

Type: Incident report Priority: Blocker
Reporter: Alain Ganuchaud Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Redhat EL6.1 / Postgres 8.4.7 / Zabbix 1.9.8
for both Master and proxies



 Description   

Some servers are monitored only when monitoring is done through Master not proxies, it seems proxies do not have the right configuration. Below is the proxy log in debug 4:
........................
16493:20120118:214252.927 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: duplicate key value violates unique constraint "hosts_templates_1"
[update hosts_templates set hostid=10127,templateid=10122 where hosttemplateid=80;
update hosts_templates set hostid=10101,templateid=10123 where hosttemplateid=81;
......................................
insert into hosts_templates (hosttemplateid,hostid,templateid) values (961,11005,10120);
insert into hosts_templates (hosttemplateid,hostid,templateid) values (967,11011,10122);
16493:20120118:214252.928 failed to update local proxy cofiguration copy
..................



 Comments   
Comment by Alexander Vladishev [ 2012 Jan 24 ]

Related issue: ZBX-3739

Comment by Alexander Vladishev [ 2012 Jan 27 ]

Fixed in the development branch svn://svn.zabbix.com/branches/dev/ZBX-4577-trunk.

In version 1.8.х such error is eliminated.

Comment by dimir [ 2012 Jan 31 ]

Tested. Great performance improvement in the DBadd_condition_alloc() function!

Comment by Alexander Vladishev [ 2012 Jan 31 ]

Fixed in version pre-1.9.9, r25120.

Comment by Chang [ 2013 Sep 27 ]

really fixed it ? why does my zabbix_proxy has this error ? version:2.0.8 ... I retry to import the database , but it doesn't helpful.





[ZBX-4574] ctemplate->unlink fails when targetids = null Created: 2012 Jan 23  Updated: 2017 May 30  Resolved: 2012 Mar 14

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 1.9.8 (beta)
Fix Version/s: 1.9.9 (beta)

Type: Incident report Priority: Major
Reporter: Timo A. Hummel Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Duplicate
duplicates ZBX-4573 API call to delete templates doesn't ... Closed

 Description   

When targetids in ctemplate->unlink is set to null, the generated SQL statement fails because the following statement is generated:

SELECT DISTINCT g.graphid,g.name,g.flags,h.name as host FROM graphs g WHERE EXISTS (SELECT ggi.graphid FROM graphs_items ggi,items ii WHERE ggi.graphid=g.templateid AND ii.itemid=ggi.itemid AND (ii.hostid IN ('10002')) ) AND (g.flags IN ('0','1'))

Because h is not included in all cases (=when targetids is null), the SQL statement fails. As I honestly have no idea what happens where and why due to no documentation, I have no idea how to fix that. For my bug reporting issues, I simply have set the following near line 2092:

$sql_from = ' graphs g,hosts h';



 Comments   
Comment by Timo A. Hummel [ 2012 Jan 23 ]

The file is class.ctemplate.php

Comment by Alexei Vladishev [ 2012 Feb 24 ]

See also ZBX-4573

Comment by Alexey Fukalov [ 2012 Mar 14 ]

Fixed in ZBX-4519.





[ZBX-4570] Need to fix the following SQL query for the Mysql DB in the Report->Availability report Created: 2012 Jan 23  Updated: 2017 May 30  Resolved: 2012 Jan 23

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 1.9.9 (beta)
Fix Version/s: 1.9.9 (beta)

Type: Incident report Priority: Blocker
Reporter: Igor Danoshaites (Inactive) Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified


 Description   

Need to fix the following SQL query "select count(e.*) AS cnt,MIN(e.clock) AS minn, MAX(e.clock) AS maxx FROM events e WHERE e.objectid=13025 AND e.object=0 AND clock>=1327057886 AND clock<=1327057886" for the Mysql DB in the Report->Availability report

When executing under PostgreSQL DB it is working fine.



 Comments   
Comment by Igor Danoshaites (Inactive) [ 2012 Jan 23 ]

When executing such SQL statement on MySQL DB appears the following error:

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*) AS cnt,MIN(e.clock) AS minn, MAX(e.clock) AS maxx FROM events e WHERE e.objec' at line 1

BUT when executing this SQL query under PostgreSQL DB all is fine:

postgres=# select count(e.*) AS cnt,MIN(e.clock) AS minn, MAX(e.clock) AS maxx FROM events e WHERE e.objectid=13025 AND e.object=0 AND clock>=1327057886 AND clock<=1327057886

postgres-# ;
cnt | minn | maxx
-------------
0 | |
(1 row)

Comment by Igor Danoshaites (Inactive) [ 2012 Jan 23 ]

This problem appears for both report modes: "By host" and "By trigger template".

Comment by Alexander Vladishev [ 2012 Jan 23 ]

Broken in r24440 (ZBXNEXT-905)

Comment by Alexander Vladishev [ 2012 Jan 23 ]

Fixed in the development branch svn://svn.zabbix.com/branches/dev/ZBX-4570

Comment by Pavels Jelisejevs (Inactive) [ 2012 Jan 24 ]

(1) Please review my changes in r24992. If everything is ok - you can merge.

<Sasha> CLOSED

TESTED.

Comment by Alexander Vladishev [ 2012 Jan 24 ]

Fixed in version pre-1.9.9, revision 24995.





[ZBX-4564] change Zabbix daemons priority on Linux Created: 2012 Jan 19  Updated: 2017 May 30  Resolved: 2012 Jan 26

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Agent (G), Proxy (P), Server (S)
Affects Version/s: None
Fix Version/s: 1.8.11, 1.9.9 (beta)

Type: Incident report Priority: Major
Reporter: Oleksii Zagorskyi Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Duplicate
is duplicated by ZBX-4826 Something (agent?) on heavily-loaded ... Closed

 Description   

All zabbix daemons start with priority "5" as hardcoded in the sources.
See revision 228 dated from 2001-10-01.
That was Zabbix 1.0alpha12

Would be nice to remove this code, which allows to control priority at init scripts level.
Currently default priority for daemons and other process in Linux is "0" so the priority "5" it's sort of "outdated" feature.

#ifdef HAVE_SYS_RESOURCE_SETPRIORITY
if (0 != setpriority(PRIO_PROCESS, 0, 5))
zbx_error("Unable to set process priority to 5. Leaving default.");
#endif



 Comments   
Comment by Alexei Vladishev [ 2012 Jan 19 ]

I think we should remove this code as suggested. I am working on it.

Comment by Alexei Vladishev [ 2012 Jan 24 ]

Fixed in dev branch branches/dev/ZBX-4564, ready to test.

<zalex> Agent and Server of dev branch tested. All is fine. Seems ready to code review and merge.

Comment by Alexander Vladishev [ 2012 Jan 25 ]

Great! Tested successfully!

Comment by Alexei Vladishev [ 2012 Jan 26 ]

Implemented in revision 25024.

Comment by Oleksii Zagorskyi [ 2012 Jan 26 ]

Note: Fixed in pre-1.8.11 r25022, pre-1.9.9 r25023





[ZBX-4558] The trigger is updated not correctly Created: 2012 Jan 17  Updated: 2017 May 30  Resolved: 2012 Feb 02

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: API (A)
Affects Version/s: 1.9.8 (beta)
Fix Version/s: 1.9.9 (beta)

Type: Incident report Priority: Blocker
Reporter: Alexander Vladishev Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: triggers
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

trunk, revision 24812


Attachments: JPEG File triggers.jpg    

 Description   

I have template with item and trigger:
item:
agent.ping
trigger:

{template:agent.ping.last(0)}

... and host with linked template.

I change trigger name and expression:
trigger => trigger2

{template:agent.ping.last(0)}

=>

{host:agent.ping.last(0)}

Consequences:

  • the trigger in the template disappears <-- correctly
  • the trigger in the host links to itself <-- not correctly
  • the host has a new trigger <-- correctly

See a screenshot.



 Comments   
Comment by Pavels Jelisejevs (Inactive) [ 2012 Jan 20 ]

(1) If we change the trigger back, from host:agent.ping.last(0) to template:agent.ping.last(0) the templated triggers 'flag' and 'value_type' values are reset.

RESOLVED.

<Sasha> REOPENED
The "Multiple problem events" flag now "blinks".
Steps to reproduce:

  • create trigger prototype and save
  • open it: Multiple problem events[checked]; save
  • open it again: Multiple problem events[unchecked]; save
  • open it again: Multiple problem events[checked]; save

<pavels> RESOLVED.

<Sasha> CLOSED

Comment by Alexander Vladishev [ 2012 Jan 21 ]

(2) There is no information message about removed trigger. Audit record too.

<pavels> We've decided not to add audit records, but I've added the info messages. RESOLVED.

<richlv> why audit records won't be added ?

<pavels> I fear, that their current implementation may cause performance problems if a large amount of hosts is affected.

<Sasha> CLOSED

Comment by Alexander Vladishev [ 2012 Jan 22 ]

(3) Please review my changes in r24944:24945

<pavels> Thnx, CLOSED.

Comment by Alexander Vladishev [ 2012 Jan 22 ]

(4) No audit records for operations Create and Update.

<pavels> RESOLVED.
<Sasha> CLOSED Please review my changes in r25019.

<pavels> Thanks, everything OK.

Comment by Pavels Jelisejevs (Inactive) [ 2012 Jan 26 ]

There was a conflict when updating to the latest trunk in r25030 class.ctrigger.php. Please review.

<Sasha>

  • db_items and db_trigger should be renamed to dbItems and dbTrigger
  • trunk/frontends/php/api/classes/class.ctrigger.php:1511,1513,1538,1539 - indentation should be fixed
  • trunk/frontends/php/api/classes/class.ctrigger.php:2103 - translation has disappeared (S_INCORRECT_DEPENDENCY => _('Incorrect dependency'))

<pavels> RESOLVED.

<Sasha> CLOSED Please review r25033.

Comment by Pavels Jelisejevs (Inactive) [ 2012 Jan 26 ]

Merged to trunk r25039.

CLOSED.

Comment by Alexander Vladishev [ 2012 Feb 01 ]

Reopened: See ZBX-4598 for more details.

<pavels> The new bugs will be fixed in ZBX-4598, so I'll close this issue.





[ZBX-4555] 1.9.8 fails to compile on Solaris Created: 2012 Jan 16  Updated: 2017 May 30  Resolved: 2012 Jan 17

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Installation (I)
Affects Version/s: 1.9.8 (beta)
Fix Version/s: 1.9.9 (beta)

Type: Incident report Priority: Minor
Reporter: Lawrence Assignee: dimir
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Solaris
SunOS 5.10 Generic_142910-17 i86pc i386 i86pc



 Description   

Seems two files aren't compiling:
sysinfo.c
misc.c
both were somewhere in the src/lib/* subtree.

I added
#include <limits.h>
And that solved the problem.



 Comments   
Comment by dimir [ 2012 Jan 17 ]

Thanks for the report. We've discovered this problem recently in another issue and have fixed it there but it's not merged to trunk yet so we will move the fix here.

Comment by dimir [ 2012 Jan 17 ]

We decided to add special define ZBX_IS_UINT64_MAX_LEN for is_uint64_n() function instead of using INT_MAX.

Fixed in development branch svn://svn.zabbix.com/branches/dev/ZBX-4555 .

Comment by Alexander Vladishev [ 2012 Jan 18 ]

Successfully tested! Please review my change in r24885 before merge.

Comment by dimir [ 2012 Jan 19 ]

Fixed in pre-1.9.9 r24893 .





[ZBX-4538] Zabbix uses __autoload, which is deprecated and conflicts with other autoloaders Created: 2012 Jan 12  Updated: 2017 May 30  Resolved: 2012 Jan 19

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 1.9.8 (beta)
Fix Version/s: 1.9.9 (beta)

Type: Incident report Priority: Trivial
Reporter: Timo A. Hummel Assignee: Unassigned
Resolution: Fixed Votes: 1
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: File zabbix-spl-autoloader.diff    

 Description   

When trying to use the Zabbix classes in another project which uses an autoloader, this fails because zabbix is overwriting any autoloaders by implementing __autoload.

Since __autoload is deprecated, I refactored the autoloader to use spl_autoload_register. See the attached patch.



 Comments   
Comment by Pavels Jelisejevs (Inactive) [ 2012 Jan 13 ]

We've recently discussed a possible implementation of a new autoloader that would use spl_autoload_register. Hopefully, it will be done in the near future, then we could use your patch.

By the way, thank's a lot about your feedback. We really need some perspectives on how to make the PHP code more extendable and reusable for other developers.

Comment by Timo A. Hummel [ 2012 Jan 16 ]

Updated autoloader which checks if the file exists prior attempting to load it. Improves compatibility with other autoloaders, as the zabbix autoloader doesn't throw an error; allowing other class loaders to catch up.

Comment by Timo A. Hummel [ 2012 Jan 16 ]

By the way, I'd need a pointer with SVN:

I simply do a svn diff which spits out a patch very nicely. However, as I can't commit to the zabbix SVN, how can I mark the patch as "done"? I.e. if I now do another change which would go to another area of zabbix, a svn diff would also include the contents of this patch, which is not exactly good.

With git, I simply could commit locally, and then create a new diff.

Comment by richlv [ 2012 Jan 16 ]

usually it's "handled manually".

so if there's a patch that depends on another patch and you wouldn't want to create a "monster patch", you would do a diff on two trees and just mention that this patch now depends on that one. "diff -u", of course

Comment by Pavels Jelisejevs (Inactive) [ 2012 Jan 17 ]

A new autoloader has been implemented in svn://svn.zabbix.com/branches/dev/ZBX-4538.

We've also introduced a new Z class to serve as a wrapper for the autoloader registration and some other stuff in the future.

RESOLVED.

Comment by Alexey Fukalov [ 2012 Jan 18 ]

(1) [GUI]
I have changed some things, we can discuss that

<pavels> Please review my changes in r24914.

<Vedmak> Please review mine in rev. 24929.

<pavels> CLOSED.

Comment by Timo A. Hummel [ 2012 Jan 18 ]

I haven't looked at the changes yet - is it possible to view the change on the web without svn checkout ?

Comment by richlv [ 2012 Jan 18 ]

there is no official web frontend for zabbix svn (yet)

Comment by Timo A. Hummel [ 2012 Jan 18 ]

I have looked at this now and I have a few questions:

There's ZBase (which seems to be the base class for the Zabbix application), but then there's the "Z" class. I'm not sure what's the reason behind this, but it looks a bit odd, as ZBase::getInstance() returns a new Z() instance. This looks a bit like an approach for 3rd-parties to include their own functionality, but would require people to overwrite the class.z.php with their own version. Did I get that right, or is there something I've missed?

I'm also not a very big fan of extremely short method names. I'd prefer "getInstance" instead of "i", because when you read "getInstance", it's obvious what it does, while "i" is not.

A picky one: Line 77 of class.zbase.php is longer than 120 characters

Overall the code looks good, I have nothing left to complain. I can also confirm that the auto loader works from ExtZabbix without modifications.

Comment by Pavels Jelisejevs (Inactive) [ 2012 Jan 19 ]

Yes, the Z class was introduced to provide an ability to extend the core Zabbix functionality. To do that you can either overwrite class.z.php, or insert your own class between Z and ZBase.

Comment by Timo A. Hummel [ 2012 Jan 20 ]

I don't think that providing an empty Z class is the right approach, and overwriting files from a distribution also isn't a good idea, because the class.z.php would probably get overwritten when updating.

A better approach would be to specify the class to use within a configuration file, and then return an instance of the configured class instead of returning an instance of ZBase.

Comment by Pavels Jelisejevs (Inactive) [ 2012 Jan 20 ]

Yes, this may not be the most correct approach. But if you're modifying something in Zabbix you'll probably set up your own repository and then all of the conflicts can be easily resolved.

Comment by Pavels Jelisejevs (Inactive) [ 2012 Jan 23 ]

Merged to trunk r24954.

CLOSED.





[ZBX-4535] zabbix - FTBFS with ld --as-needed Created: 2012 Jan 11  Updated: 2017 May 30  Resolved: 2012 Jan 28

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Agent (G), Server (S)
Affects Version/s: 1.8.9, 1.8.10
Fix Version/s: 1.8.11, 1.9.9 (beta)

Type: Incident report Priority: Blocker
Reporter: Leo Iannacone Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Ubuntu Dev Precise (12.04)


Attachments: File fix-ftbfs-ld-as-needed.patch    
Issue Links:
Duplicate
duplicates ZBX-494 Cannot compile with --as-needed linke... Closed
duplicates ZBX-3475 Compilation error --with-sqlite3 on F... Closed
is duplicated by ZBX-3898 Fails to build with "gold" binutils l... Closed

 Description   

Dear developers,

zabbix fail to build with flag "ld --as-needed" enabled (as set in Ubuntu), trying to add LDAP and POSTGRESQL LIBS during compilation in the wrong place.

Snippet from build fail about zabbix_agent and LDAP:
i686-linux-gnu-gcc -Wall -g -O2 -I/usr/include/postgresql -I/usr/local/include -I/usr/lib/perl/5.14/CORE -I. -I/usr/include -I/usr/include -I/usr/include -I/usr/include -rdynamic -Wl,-Bsymbolic-functions -Wl,-z,relro -o zabbix_agent -L/usr/lib -lldap -llber zabbix_agent.o stats.o cpustat.o diskdevices.o perfstat.o vmstats.o zbxconf.o ../../src/libs/zbxsysinfo/libzbxagentsysinfo.a ../../src/libs/zbxsysinfo/linux/libspecsysinfo.a ../../src/libs/zbxsysinfo/common/libcommonsysinfo.a ../../src/libs/zbxsysinfo/simple/libsimplesysinfo.a ../../src/libs/zbxlog/libzbxlog.a ../../src/libs/zbxalgo/libzbxalgo.a ../../src/libs/zbxsys/libzbxsys.a ../../src/libs/zbxnix/libzbxnix.a ../../src/libs/zbxcomms/libzbxcomms.a ../../src/libs/zbxconf/libzbxconf.a ../../src/libs/zbxcommon/libzbxcommon.a ../../src/libs/zbxcrypto/libzbxcrypto.a ../../src/libs/zbxjson/libzbxjson.a ../../src/libs/zbxexec/libzbxexec.a -lm -lresolv
../../src/libs/zbxsysinfo/simple/libsimplesysinfo.a(simple.o): In function `check_ldap':
/tmp/buildd/zabbix-1.8.9/debian/tmp-build-PGSQL/src/libs/zbxsysinfo/simple/simple.c:57: undefined reference to `ldap_init'
/tmp/buildd/zabbix-1.8.9/debian/tmp-build-PGSQL/src/libs/zbxsysinfo/simple/simple.c:63: undefined reference to `ldap_search_s'
...

Snippet from build fail about zabbix_server and POSTGRESQL:
x86_64-linux-gnu-gcc -Wall -g -O2 -I/usr/include/postgresql -I/usr/local/include -I/usr/lib/perl/5.14/CORE -I. -I/usr/include -I/usr/include -I/usr/include -I/usr/include -rdynamic -Wl,-Bsymbolic-functions -Wl,-z,relro -o zabbix_server -L/usr/lib -lpq -liksemel -L/usr/lib/x86_64-linux-gnu -lcurl -L/usr/lib -lnetsnmp -L/usr/lib -lnetsnmp -L/usr/lib -L/usr/lib -L/usr/lib zabbix_server-actions.o zabbix_server-operations.o zabbix_server-events.o zabbix_server-zlog.o zabbix_server-server.o alerter/libzbxalerter.a dbsyncer/libzbxdbsyncer.a dbconfig/libzbxdbconfig.a discoverer/libzbxdiscoverer.a pinger/libzbxpinger.a poller/libzbxpoller.a housekeeper/libzbxhousekeeper.a timer/libzbxtimer.a trapper/libzbxtrapper.a nodewatcher/libzbxnodewatcher.a utils/libzbxutils.a httppoller/libzbxhttppoller.a watchdog/libzbxwatchdog.a escalator/libzbxescalator.a proxypoller/libzbxproxypoller.a selfmon/libzbxselfmon.a ../../src/libs/zbxsysinfo/libzbxserversysinfo.a ../../src/libs/zbxsysinfo/linux/libspecsysinfo.a ../../src/libs/zbxsysinfo/common/libcommonsysinfo.a ../../src/libs/zbxsysinfo/simple/libsimplesysinfo.a ../../src/libs/zbxlog/libzbxlog.a ../../src/libs/zbxdbcache/libzbxdbcache.a ../../src/libs/zbxmemory/libzbxmemory.a ../../src/libs/zbxalgo/libzbxalgo.a ../../src/libs/zbxnix/libzbxnix.a ../../src/libs/zbxsys/libzbxsys.a ../../src/libs/zbxconf/libzbxconf.a ../../src/libs/zbxmedia/libzbxmedia.a ../../src/libs/zbxcommon/libzbxcommon.a ../../src/libs/zbxcrypto/libzbxcrypto.a ../../src/libs/zbxcomms/libzbxcomms.a ../../src/libs/zbxcommshigh/libzbxcommshigh.a ../../src/libs/zbxjson/libzbxjson.a ../../src/libs/zbxexec/libzbxexec.a ../../src/libs/zbxself/libzbxself.a ../../src/libs/zbxserver/libzbxserver.a ../../src/libs/zbxicmpping/libzbxicmpping.a ../../src/libs/zbxdbhigh/libzbxdbhigh.a ../../src/libs/zbxdb/libzbxdb.a -liksemel -lcurl -lnetsnmp -lssh2 -lOpenIPMI -lOpenIPMIposix -lm -lresolv
../../src/libs/zbxdb/libzbxdb.a(db.o): In function `zbx_db_close':
/tmp/buildd/zabbix-1.8.9/debian/tmp-build-PGSQL/src/libs/zbxdb/db.c:443: undefined reference to `PQfinish'
../../src/libs/zbxdb/libzbxdb.a(db.o): In function `zbx_db_vexecute':
/tmp/buildd/zabbix-1.8.9/debian/tmp-build-PGSQL/src/libs/zbxdb/db.c:815: undefined reference to `PQexec'

The attached patch fixes both problems, it moves '-lldap -llber' into LDAP_LIBS (exporting it and using in configure.in) and '-lpq' into POSTGRESQL_LIBS as well (already exported and defined into configure.in).

Can you kindly consider to apply this patch?

Thanks,

Leo.



 Comments   
Comment by Alexander Vladishev [ 2012 Jan 28 ]

Fixed in the development branch svn://svn.zabbix.com/branches/dev/ZBX-4535

Comment by Oleksii Zagorskyi [ 2012 Jan 29 ]

Just for record: as I see this dev branch already includes fix from ZBX-3475. Great!
So ZBX-3475 can be closed after this one.

Comment by dimir [ 2012 Jan 30 ]

Great fix! Even more order in our autoconfiguration process! Just tiny formatting change in r25079.

<Sasha> CLOSED

Comment by Alexander Vladishev [ 2012 Jan 30 ]

Fixed in versions pre-1.8.11 r25085 and pre-1.9.9 r25087.





[ZBX-4526] trigger checks only first 256 chars of item value Created: 2012 Jan 09  Updated: 2017 May 30  Resolved: 2012 Jan 12

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Documentation (D), Server (S)
Affects Version/s: 1.8.10
Fix Version/s: 1.8.11, 1.9.9 (beta)

Type: Incident report Priority: Critical
Reporter: Pavel Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: triggers
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Tested on Linux.


Attachments: JPEG File zbx-4526-item-screenshot.jpg    

 Description   

If I use trigger "

{hostname:web.get.page[site].str(substr)}

" then substring found only if it occurs in the first 256 (not sure) bytes of value including http header.
I did not found this limitation in documentation, and it works OK in zabbix 1.8.8.
Item "hostname:web.get.regex[site,,,substr]" works good on both versions, but sometimes it's useful to get full page content in alert (as value).
As workaround I use trigger like this:

{hostname:web.page.get[site].str("substr")}

<1&

{hostname:web.page.regexp[site,,,substr].count(#2,"substr","eq")}

<1
first part five value for alerter, second part set real condition.



 Comments   
Comment by richlv [ 2012 Jan 09 ]

might be another items.lastvalue manifestation (although i can't find the previous issues on this right now)

Comment by Alexander Vladishev [ 2012 Jan 11 ]

what database are you using?

Comment by Alexander Vladishev [ 2012 Jan 11 ]

Cannot reproduce with PostgreSQL.

Check a structure of a 'items' table. Size of fields 'lastvalue' and 'prevvalue' should be 255.

Comment by Pavel [ 2012 Jan 11 ]

Mysql.
Yes, lastvalue and prevvalue columns of items table have type "varchar(255)".

Comment by Pavel [ 2012 Jan 12 ]

Is it possible that it depends of 8-bit value?
In my case, triggers "

{happy.kiev.ua:web.page.get[fidonet.org.ua].str("sysopka",#2)}

<1" and "

{happy.kiev.ua:web.page.get[fidonet.org.ua].str("sysopka")}

<1" returns problem, but "

{happy.kiev.ua:web.page.get[fidonet.org.ua].str("DOCTYPE",#2)}

<1" returns OK.
I can open my zabbix_agentd for your server if it can help.

Comment by Alexander Vladishev [ 2012 Jan 12 ]

Please attach screenshot of "web.page.get[fidonet.org.ua]" item configuration.

Comment by Pavel [ 2012 Jan 12 ]

web.page.get[fidonet.org.ua] item configuration

Comment by Alexander Vladishev [ 2012 Jan 12 ]

Confirmed: The given problem happens if in the first 255 characters is present the CR (0х13) character.

Comment by Alexander Vladishev [ 2012 Jan 12 ]

Fixed in the development branch svn://svn.zabbix.com/branches/dev/ZBX-4526

Comment by Alexander Vladishev [ 2012 Jan 12 ]

The priority is changed to the "Critical".

Comment by dimir [ 2012 Jan 13 ]

Successfully tested. Please fix ChangeLog message, it contains typo.

Comment by Alexander Vladishev [ 2012 Jan 13 ]

Fixed in version pre-1.8.11, revision 24752.





[ZBX-4523] Impossible to correctly translate some parts of Zabbix Created: 2012 Jan 06  Updated: 2017 May 30  Resolved: 2012 Jan 18

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 1.8.10
Fix Version/s: 1.9.9 (beta)

Type: Incident report Priority: Major
Reporter: Sébastien Maccagnoni Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: internationalization, localization, translation
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Duplicate
duplicates ZBXNEXT-790 Clean up Zabbix front-end to make use... Closed

 Description   

I'm currently trying to improve the french translation, and I'm starting to understand why some strings are not correctly translatable. Zabbix front-end sentences are sometimes defined as "a (translatable) string and a space and another (translatable) string" etc.
For example :

S_IN.SPACE.S_MAINTENANCE => "In maintenance" in english, "En maintenance" in french => ok
S_IN.SPACE.S_GROUP => "In group" in english, "Dans le groupe" in french => impossible to translate
S_IN.SPACE.S_GROUPS => "In groups" in english, "Dans les groupes" in french => impossible to translate
S_HOSTS.SPACE.S_IN => "Hosts in" in english, "Contient les hôtes" in french => impossible to translate

The web frontend translation should be based on groupes of words and not single words. For example, replacing "S_IN.SPACE.S_MAINTENANCE" with a new "S_IN_MAINTENANCE" or "S_HOSTS.SPACE.S_IN" with "S_HOSTS_IN".



 Comments   
Comment by Oleksii Zagorskyi [ 2012 Jan 09 ]

Sébastien, welcome to the translation team !
Here is many similar issues with suggestions like your and I believe that they all will be fixed according to the ZBXNEXT-790 for Zabbix 2.0.[1-9]
Additionally I would like to let you know about issues ZBX-3271 and ZBX-4402 and see to a page http://www.zabbix.org/wiki/Translating_Zabbix

Regards,
Oleksiy

Comment by richlv [ 2012 Jan 11 ]

i'm not quite sure it's a good idea to fix it this way in 1.8 branch... this introduces lots of new translation strings - even if more correct, this will mean additional work to translators who might already have translated those partial strings (and who would not want to translate a bunch of new ones for 1.8 as they work on trunk already).

zalex, your opinion ?

Comment by Oleksii Zagorskyi [ 2012 Jan 11 ]

Of course, I'm agree with Richlv for 1000%

Three hours ago (when Sanja assigned the issue himself) I checked the source of dev branch copied from and it was .... 1.8. I wanted to ask - WHY?
Why to spend time for 1.8 branch?
But I decides to be silent -> maybe it's a case to training/solve a not hard task or so.

I'm agree that would be better to resolve this issue for the 2.0 only.

Comment by Alexander Sorokin (Inactive) [ 2012 Jan 11 ]

It introduces 57 new strings. May be few more will be added.

Comment by Alexander Sorokin (Inactive) [ 2012 Jan 11 ]

Fixed for 1.8 in development branch svn://svn.zabbix.com/branches/dev/ZBX-4523

Comment by Alexander Sorokin (Inactive) [ 2012 Jan 11 ]

Fixed for trunk in development branch svn://svn.zabbix.com/branches/dev/ZBX-4523-trunk

Comment by richlv [ 2012 Jan 11 ]

(1) that's at least 57 untranslated strings, introduced very lately in the branch lifecycle. based on zalex's opinion, i'd suggest not to do this for 1.8

<Sasha> Let's not do it in version 1.8. Too many untranslated new phrases. CLOSED

Comment by richlv [ 2012 Jan 11 ]

(2) trunk branch seems to add new S_ strings

I'm personally not sure worth to merge it to trunk as it is at the moment. Maybe would be better to discard these changes and to work only according to the ZBXNEXT-790 ?

<sanja> RESOLVED

Comment by Alexey Fukalov [ 2012 Jan 16 ]

(3) [GUI]
Please review my changes in rev. 24783.

I reviewed 1.8 branch, don't forget to remove it CLOSED

Comment by Alexey Fukalov [ 2012 Jan 17 ]

(4) [GUI]
Please review my changes in rev. 24819.

<sanja> CLOSED

Comment by Alexander Sorokin (Inactive) [ 2012 Jan 19 ]

Fixed in trunk, r24888





[ZBX-4520] trigger dependency from host to template can be created Created: 2012 Jan 05  Updated: 2017 May 30  Resolved: 2012 Jan 24

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: API (A)
Affects Version/s: None
Fix Version/s: 1.9.9 (beta)

Type: Incident report Priority: Blocker
Reporter: richlv Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: regression
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified


 Description   

trigger dependency from host to template can be created. shouldn't be possible.
when fixing and testing, please, verify that it can not be done by directly creating the dep, by copying a trigger or by any other means



 Comments   
Comment by richlv [ 2012 Jan 05 ]

interestingly, this was broken a long, long time ago in :

------------------------------------------------------------------------
r15624 | Vedmak | 2010-11-22 16:27:37 +0200 (Mon, 22 Nov 2010) | 2 lines

  • ZBX-2577 fixed template trigger update affects downstream triggers
    when fixing, please, add unittests
    <Slava>As i understand it's doesn't work in version 1.8.3 too ...
    <Slava> RESOVED r 24758
Comment by richlv [ 2012 Jan 13 ]

(1) unittests ?
<Slava>RESOLVED

Comment by richlv [ 2012 Jan 13 ]

(2) when adding dependencies to a host trigger, templates are still shown. is that intended ?
<Slava> RESOLVED in r 24776

<richlv> CLOSED

Comment by richlv [ 2012 Jan 13 ]

(3) in the dev branch, when creating a trigger :

reset() expects parameter 1 to be array, null given [api/classes/class.ctrigger.php:1635]
Created: Trigger "xxx" on "".
<Slava>This bug was created in ZBX-2737. RESOLVED in r 24776
<Sasha> CLOSED Fixed in r24780 in ZBX-2737

Comment by richlv [ 2012 Jan 16 ]

(4) create a new trigger, add a dependency on some template trigger. choose an item from a host afterwards. such a trigger can be saved. looks like api level check is only on trigger update, not on creation... there shouldn't be duplicate code to check this as well
<Slava>RESOLVED r 24861
<CLOSED>

Comment by richlv [ 2012 Jan 16 ]

(5) i believe the following might violate coding style :

+ $hostName=explode(':',$trigger['expression']);
+ info(_s('Created: Trigger "%1$s" on "%2$s".', $trigger['description'], str_replace('{','',reset($hostName))));

<Sasha> CLOSED Fixed with merge from a trunk r24805

Comment by Alexander Vladishev [ 2012 Jan 16 ]

(6) for what purposes we receive all fields from the "hosts" table?
frontends/php/api/classes/class.ctrigger.php:2211
<Slava>RESOLVED r 24861

<richlv> something rather fishy was done to this comment, REOPENED
<Slava>RESOLVED r 24875

<richlv> ...
i don't know what was resolved in svn, but the problem still there is with this comment...

<richlv> it should be doublechecked what was done in svn, as the second problem didn't involve code at all. comment is fixed now, original issue can be reviewed

<Sasha> REOPENED
Please review all options in this API call.

<Sasha> CLOSED

Comment by Alexander Vladishev [ 2012 Jan 16 ]

(7) one more SQL? We cannot use the existing?
<Slava>RESOLVED r 24861

<richlv> something rather fishy was done to this comment, REOPENED
<Slava>RESOLVED r 24875

<richlv> ...
i don't know what was resolved in svn, but the problem still there is with this comment...

<richlv> it should be doublechecked what was done in svn, as the second problem didn't involve code at all. comment is fixed now, original issue can be reviewed

<pavels> I've remade the fix, so last commit is irrelevant now.

<Sasha> CLOSED

Comment by Alexander Vladishev [ 2012 Jan 17 ]

(8) [GUI] rollback all changes in configuration.triggers.edit.php
<Slava> RESOLVED r24829
<Sasha> CLOSED please review a small change in r24866
<Slava>CLOSED

Comment by Pavels Jelisejevs (Inactive) [ 2012 Jan 24 ]

I've remade the fix. Please review.

RESOLVED.

Comment by Alexander Vladishev [ 2012 Jan 25 ]

Excellent! Successfully tested!

Comment by Pavels Jelisejevs (Inactive) [ 2012 Jan 26 ]

Merged to trunk r25026.

CLOSED.





[ZBX-4519] can't delete template : Unknown column 'h.name' Created: 2012 Jan 05  Updated: 2017 May 30  Resolved: 2012 Jan 18

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: API (A)
Affects Version/s: None
Fix Version/s: 1.9.9 (beta)

Type: Incident report Priority: Blocker
Reporter: richlv Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: regression
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified


 Description   

Error in query [SELECT DISTINCT t.triggerid,t.description,t.flags,t.expression,h.name as host FROM triggers t WHERE EXISTS ( SELECT ff.triggerid FROM functions ff,items ii WHERE ff.triggerid=t.templateid AND ii.itemid=ff.itemid AND (ii.hostid IN ('10299')) ) AND (t.flags IN ('0','1')) ] [Unknown column 'h.name' in 'field list']
mysql_fetch_assoc() expects parameter 1 to be resource, boolean given [include/db.inc.php:560]
mysql_free_result() expects parameter 1 to be resource, boolean given [include/db.inc.php:561]
Error in query [SELECT DISTINCT g.graphid,g.name,g.flags,h.name as host FROM graphs g WHERE EXISTS ( SELECT ggi.graphid FROM graphs_items ggi,items ii WHERE ggi.graphid=g.templateid AND ii.itemid=ggi.itemid AND (ii.hostid IN ('10299')) ) AND (g.flags IN ('0','1')) ] [Unknown column 'h.name' in 'field list']
mysql_fetch_assoc() expects parameter 1 to be resource, boolean given [include/db.inc.php:560]
mysql_free_result() expects parameter 1 to be resource, boolean given [include/db.inc.php:561]
Template [dep2] deleted.

seems to be broken by ZBX-2737



 Comments   
Comment by richlv [ 2012 Jan 05 ]

(1) while fixing this, please, also remove extra space in "WHERE EXISTS ( SELECT"

<sanja> RESOLVED

<pavels> CLOSED.

Comment by richlv [ 2012 Jan 05 ]

(2) additionally, even though there were these errors, frontend message was "Template [dep2] deleted." - shouldn't be

<pavels> This may be a bit tricky to fix now because we'll have to make changes to all of the SELECT queries on a global level. I suggest we leave it as is for now.

<sanja> "Template [dep2] deleted." changed to standart message.

<pavels> CLOSED.

Comment by Alexander Sorokin (Inactive) [ 2012 Jan 05 ]

Fixed in development branch svn://svn.zabbix.com/branches/dev/ZBX-4519

Comment by Pavels Jelisejevs (Inactive) [ 2012 Jan 05 ]

TESTED.

Comment by Alexander Vladishev [ 2012 Jan 12 ]

Changes from a development branch has been merged to a trunk incorrectly. Please fix it.

<sanja> RESOLVED

<Sasha> TESTED

Comment by Alexander Vladishev [ 2012 Jan 18 ]

(3) Message about a deleted template does not correspond Zabbix syntax and naming guidelines.
Message about a deleted host too.

<sanja> RESOLVED

<Sasha> CLOSED Please review my changes in r24878.

TESTED





[ZBX-4513] No-change valuemap update should not update data in table 'mappings' Created: 2012 Jan 04  Updated: 2017 May 30  Resolved: 2012 Jul 25

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 1.9.9 (beta)
Fix Version/s: 1.9.9 (beta)

Type: Incident report Priority: Major
Reporter: Igor Danoshaites (Inactive) Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Trunk (v1.9.9)



 Description   

No-change valuemap update should not update data in table 'mappings'



 Comments   
Comment by Alexander Vladishev [ 2012 Jan 11 ]

Closing duplicated issue.

Comment by Alexander Vladishev [ 2012 Jan 11 ]

Reopened incorrectly closed issue

Comment by Alexey Fukalov [ 2012 Jan 13 ]

dev branch: svn://svn.zabbix.com/branches/dev/ZBX-4513

Comment by Pavels Jelisejevs (Inactive) [ 2012 Jan 16 ]

(1) The new files should have svn:eol-style set to "native"

<Vedmak> RESOLVED

<pavels> CLOSED.

Comment by Pavels Jelisejevs (Inactive) [ 2012 Jan 16 ]

(2) You'll also need to replace the references to config.php in testFormAdministrationGeneralGUI.php and testFormAdministrationGeneralHousekeeper.php

<Vedmak> RESOLVED

<pavels> CLOSED.

Comment by Pavels Jelisejevs (Inactive) [ 2012 Jan 16 ]

(3) When validating the mapping value field it says "Only positive or negative number". Let's change it to "Only integers" because it also allows zeros. "

<richlv> what about "Only positive or negative numbers or zeroes" ? longish, but we won't have to make all our users learn what an integer is

<pavels> Maybe "Only numbers" or "Only whole numbers"?

<richlv> "Only whole numbers" sounds ok to me

<Vedmak> RESOLVED

<pavels> Since Rich didn't like the word "integer", I've also changed the placeholder to "Whole number" in r24813. Ok with you?

<Vedmak> Sure. CLOSED

Comment by Pavels Jelisejevs (Inactive) [ 2012 Jan 16 ]

(4) Let's leave the testing of the select menu in the *CheckLayout test to make sure it works correctly.

<Vedmak> RESOLVED

<pavels> CLOSED.

Comment by Pavels Jelisejevs (Inactive) [ 2012 Jan 17 ]

TESTED, but please close (3) before merging.

Comment by Alexey Fukalov [ 2012 Jan 17 ]

commit: svn://svn.zabbix.com/trunk 24814

Comment by richlv [ 2012 Jul 18 ]

this resulted in a regression : ZBX-5344

Comment by richlv [ 2012 Jul 25 ]

fix versions missing

Comment by richlv [ 2012 Jul 25 ]

i believe it was fixed in 1.9.9, please change if that's not correct





[ZBX-4507] Action not removing host from group "Discovered Hosts" Created: 2012 Jan 03  Updated: 2017 May 30  Resolved: 2012 Jan 25

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Server (S)
Affects Version/s: 1.8.8, 1.8.9, 1.8.10
Fix Version/s: 1.8.11, 1.9.9 (beta)

Type: Incident report Priority: Major
Reporter: Attilla de Groot Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: actions, discovery
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Linux, Debian


Attachments: PNG File Screen Shot 2012-01-03 at 3.50.13 PM.png     PNG File Screen Shot 2012-01-03 at 3.50.46 PM.png     PNG File Screen Shot 2012-01-03 at 4.04.38 PM.png    

 Description   

Hi,

I've created a discovery rule that discovers switches on our platform and attaches templates to the hosts based on the snmp result. I'm also adding a host to the appropriate host group based on the result of one of the snmp discovery rules.

This all works fine, except for the removal from the Discovered Hosts group. I'd like to keep this host group clear from already discovered hosts, but that seems to be impossible or simply not work. As you can see in the attached screenshot, I created a separate action to remove a host from the discovered hosts group, but that doesn't seem to work. I also tried to just add the removal operation to one of the three separate actions, but the also doesn't work.

There are no logs to debug, but I'm guessing that the delete action is being processed before the "add to hostgroup" action. This would result in a host being without a host group and probably not possible. I'm guessing this because the delete action is put in the list first when I'm adding the operation to one of the the separate actions.

It would be very helpful if this is solved.



 Comments   
Comment by Oleksii Zagorskyi [ 2012 Jan 04 ]

Discovery can work very slow for big IP addresses range with so big count of checks and many of unavailable hosts.
Maybe need to wait day or two ?

Comment by Attilla de Groot [ 2012 Jan 04 ]

I'm aware of that, but I have this configuration for about 6 months now. So I think that is more than enough waiting.

If you have a better way of configuring the discovery, please tell me.

Comment by Alexander Vladishev [ 2012 Jan 11 ]

Confirmed: We always add discovered host to group "Discovered hosts".

Comment by Attilla de Groot [ 2012 Jan 16 ]

That is a good thing. But I'd like to remove it again.

Because it also shows up as a host group with errors on the dashboard for example.

Comment by Alexander Vladishev [ 2012 Jan 18 ]

Fixed in the development branch svn://svn.zabbix.com/branches/dev/ZBX-4507

Comment by dimir [ 2012 Jan 20 ]

It's interesting how I finally managed to reproduce the problem only when I split "add host" and "remove from discovered hosts" operations into 2 different actions. Within one action I wasn't able to reproduce it. Yes, but it's true that server was adding the host back to group every time "add host" operation was executed.

Comment by dimir [ 2012 Jan 23 ]

Tested. Please review my changes in r24932, r24933.

<Sasha> CLOSED

Comment by Alexander Vladishev [ 2012 Jan 24 ]

Fixed in version pre-1.8.11, revision 24989.

Comment by Oleksii Zagorskyi [ 2012 Jan 25 ]

Just a note: Fixed in version pre-1.9.9, revision 24993 too.





[ZBX-4505] Globalmacroid should not be changed when updating global macro Created: 2012 Jan 03  Updated: 2017 May 30  Resolved: 2012 Jan 11

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 1.8.10, 1.9.9 (beta)
Fix Version/s: 1.9.9 (beta)

Type: Incident report Priority: Blocker
Reporter: Igor Danoshaites (Inactive) Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: macros
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Duplicate
duplicates ZBX-4083 When updating a global macro, GUI del... Closed

 Description   

Globalmacroid should not be changed when updating global macro



 Comments   
Comment by Pavels Jelisejevs (Inactive) [ 2012 Jan 03 ]

This will require some API updates, so I've started a specs draft https://zabbix.org/wiki/Docs/specs/ZBX-4503

Comment by Alexei Vladishev [ 2012 Jan 03 ]

See also ZBX-4083.

Comment by Pavels Jelisejevs (Inactive) [ 2012 Jan 04 ]

Additional notes from ZBX-4083

"1. The new macro shouldn't be added. The existing macro should be updated.
2. The unchanged macros shouldn't generate auditlog records and SQL statements."

Comment by Pavels Jelisejevs (Inactive) [ 2012 Jan 04 ]

RESOLVED for trunk in /branches/dev/ZBX-4505.

Comment by Alexey Fukalov [ 2012 Jan 09 ]

(1) [GUI]
In class.cusermacro.php:523 "$" is missing in message parameter reference.

<pavels> RESOLVED.

<Vedmak> CLOSED

Comment by Alexey Fukalov [ 2012 Jan 09 ]

(2) [GUI]
In deleteGlobal method we cannot expect only arrays as we usually support single entity as well..

<pavels> RESOLVED.

<Vedmak> CLOSED

Comment by Alexey Fukalov [ 2012 Jan 09 ]

(3) [GUI]
After DB class methods we should not check if it returned false, because all methods of this class throws exceptions on errors.

<pavels> RESOLVED.

<Vedmak> CLOSED

Comment by Alexey Fukalov [ 2012 Jan 09 ]

(4) [GUI]
In class.cusermacro.php:563 we try to interact with not defined variable "$dbGmacros".

<pavels> RESOLVED.

<Vedmak> CLOSED

Comment by Alexey Fukalov [ 2012 Jan 09 ]

(5) [GUI]
With usermacro.updateGlobal api call we can create two identical macros.

<pavels> RESOLVED.

<Vedmak> CLOSED

Comment by Alexey Fukalov [ 2012 Jan 10 ]

(6) [GUI]
Please review my changes in rev. 24642.

<pavels> CLOSED.

Comment by Pavels Jelisejevs (Inactive) [ 2012 Jan 11 ]

Merged to trunk r24661.

CLOSED.

Comment by Pavels Jelisejevs (Inactive) [ 2012 Jan 11 ]

(7) [DOCS]

Updated docs. Global macro update and delete calls are now executed by "globalmacroid" instead of "macro".
http://www.zabbix.com/documentation/2.0/manual/appendix/api/usermacro/deleteglobal
http://www.zabbix.com/documentation/2.0/manual/appendix/api/usermacro/updateglobal

<Vedmak> CLOSED





[ZBX-4502] missing space between "Group" and dropdown in host configuration page Created: 2012 Jan 03  Updated: 2017 May 30  Resolved: 2012 Jan 03

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: None
Fix Version/s: 1.9.9 (beta)

Type: Incident report Priority: Trivial
Reporter: richlv Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified


 Description   

there is a space missing between "Group" and dropdown in host configuration page. it is present in the template config page



 Comments   
Comment by richlv [ 2012 Jan 03 ]

fixed in svn://svn.zabbix.com/branches/dev/ZBX-4502 along with minor coding style fixes and using direct gettext string for template page

Comment by Pavels Jelisejevs (Inactive) [ 2012 Jan 03 ]

TESTED.

Comment by richlv [ 2012 Jan 03 ]

merged to trunk in rev 24496.





[ZBX-4484] greek locale should be added in the frontend list Created: 2011 Dec 23  Updated: 2017 May 30  Resolved: 2011 Dec 23

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: None
Fix Version/s: 1.9.9 (beta)

Type: Incident report Priority: Major
Reporter: richlv Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: localization
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified


 Description   

greek locale is available, but not added to the frontend dropdown list yet.
proper locale code seems to be el_GR



 Comments   
Comment by richlv [ 2011 Dec 23 ]

resolved in svn://svn.zabbix.com/branches/dev/ZBX-4484

Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 27 ]

TESTED.

Comment by richlv [ 2011 Dec 27 ]

merged to trunk in rev 24287.





[ZBX-4483] Icons are distorted in some places in the frontend Created: 2011 Dec 23  Updated: 2017 May 30  Resolved: 2011 Dec 29

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: None
Affects Version/s: 1.9.8 (beta)
Fix Version/s: 1.9.9 (beta)

Type: Incident report Priority: Blocker
Reporter: Pavels Jelisejevs (Inactive) Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: iconmapping
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: PNG File icon-mapping-skew.png    

 Description   

For instance, in the configuration of icon mapping



 Comments   
Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 27 ]

I've added a server-side icon resizing feature we use to properly scale icons.

RESOLVED.

Comment by Alexey Fukalov [ 2011 Dec 28 ]

(1) [GUI]
There are 3 places we do "imagealphablending($source, false); imagesavealpha($source, true);" for image, maybe we can do it in one place?

<pavels> I've implemented a separate function for it, but we have to do it even if we don't resize the image. RESOLVED.

<pavels> CLOSED.

Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 30 ]

There have been some conflicts when updating to the latest trunk, plus I've fixed another small bug. Please review.

REOPENED.

<Vedmak> CLOSED

Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 30 ]

Merged to trunk r24444.

CLOSED.





[ZBX-4479] it is possible to add a dependency from a template to a host Created: 2011 Dec 22  Updated: 2017 May 30  Resolved: 2012 Jan 05

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F), Server (S)
Affects Version/s: 1.9.8 (beta)
Fix Version/s: 1.9.9 (beta)

Type: Incident report Priority: Blocker
Reporter: richlv Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: dependencies, triggers
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Duplicate
is duplicated by ZBXNEXT-835 Allow Trigger Dependency from a Templ... Closed

 Description   

in current trunk it is possible to add dependency from template trigger to a host trigger. it is an accidental change, and it is not known whether server will operate properly this way. it should be decided whether this is allowed - if it is, it would solve ZBXNEXT-835 (and should be documented)

if not, this should be prevented.



 Comments   
Comment by richlv [ 2012 Jan 04 ]

(1) rev 24503 did :
+ for ($i = 1; $i <=2; $i++) {

is suspect this might not match the coding stye
<Slava> RESOLVED r 24511

  • for ($i = 1; $i <=2; $i++) {
    + for ($i = 1; $i <= 2; $i++) {

<richlv> CLOSED

Comment by Pavels Jelisejevs (Inactive) [ 2012 Jan 04 ]

Server side TESTED.

Comment by richlv [ 2012 Jan 05 ]

for the record, this is supposed to allow template triggers to depend on host triggers and should also fulfill ZBXNEXT-835

Comment by richlv [ 2012 Jan 05 ]

(2) this should be documented in the trigger dependency docs

http://www.zabbix.com/documentation/2.0/manual/config/triggers/dependencies

<Sasha> Rich, thanks! CLOSED

Comment by dimir [ 2012 Jan 05 ]

Tested, somebody should review my changes in r24536 and r24547 and then it can be merged into upstream.

<Sasha> CLOSED

Comment by Alexander Vladishev [ 2012 Jan 05 ]

Available in version pre-1.9.9, rev. 24570.

Comment by Oleksii Zagorskyi [ 2012 Jan 05 ]

Reopened to remove 2.0 from "Fix version"

Comment by Oleksii Zagorskyi [ 2012 Jan 05 ]

Closed again.





[ZBX-4477] Value of the "expressions.expressionid" field changes when saving regular expression Created: 2011 Dec 22  Updated: 2017 May 30  Resolved: 2012 Jan 09

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 1.9.8 (beta)
Fix Version/s: 1.9.9 (beta)

Type: Incident report Priority: Major
Reporter: Igor Danoshaites (Inactive) Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Duplicate
duplicates ZBX-4504 No-change regexp update should not up... Closed

 Description   

Value of the "expressions.expressionid" field changes when saving regular expression (even without performing any changes in the regexp conf, just saving old configuration).



 Comments   
Comment by Alexey Fukalov [ 2011 Dec 30 ]

dev branch: svn://svn.zabbix.com/branches/dev/ZBX-4477

Comment by Pavels Jelisejevs (Inactive) [ 2012 Jan 03 ]

(2) Please review my changes in r24487.

Please review my changes in r24611.

<pavels> CLOSED.

Comment by Pavels Jelisejevs (Inactive) [ 2012 Jan 09 ]

I've merged some changes from ZBX-4504, please review them in r24619 and r24618. If everything is ok, you can merge.

Comment by Alexey Fukalov [ 2012 Jan 11 ]

(3) [GUI]
Please review my changes in rev. 24659.

<pavels> Fixed a couple of typos in r24662. CLOSED.

Comment by Alexey Fukalov [ 2012 Jan 11 ]

Merged: svn://svn.zabbix.com/trunk 24681





[ZBX-4470] Can not open trunk frontend after converting trunk Mysql Zabbix DB to the DM setup Created: 2011 Dec 20  Updated: 2017 May 30  Resolved: 2011 Dec 23

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 1.9.9 (beta)
Fix Version/s: 1.9.9 (beta)

Type: Incident report Priority: Blocker
Reporter: Igor Danoshaites (Inactive) Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: dm
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

v1.9.9 (rev #24084)


Attachments: PNG File trunk_nodes_error.png    

 Description   

After converting trunk Mysql (v1.9.9, rev #24084) Zabbix DB to the DM setup (with "./zabbix_server -n 1" command) can not open frontend anymore, after opening index.php on the screen appears the following error:

Undefined index: type [include/nodes.inc.php:59]
Undefined index: userid [include/nodes.inc.php:67]
Error in query [SELECT DISTINCT n.nodeid,n.name,n.masterid FROM nodes n,groups hg,rights r,users_groups g WHERE r.id=hg.groupid AND r.groupid=g.usrgrpid AND g.userid= AND n.nodeid=(hg.groupid div 100000000000000)] [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND n.nodeid=(hg.groupid div 100000000000000)' at line 1]
mysql_fetch_assoc() expects parameter 1 to be resource, boolean given [include/db.inc.php:560]
mysql_free_result() expects parameter 1 to be resource, boolean given [include/db.inc.php:561]
Error in query [SELECT DISTINCT n.nodeid,n.name,n.masterid FROM nodes n,groups hg,rights r,users_groups g WHERE r.id=hg.groupid AND r.groupid=g.usrgrpid AND g.userid= AND n.nodeid=(hg.groupid div 100000000000000)] [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND n.nodeid=(hg.groupid div 100000000000000)' at line 1]
mysql_fetch_assoc() expects parameter 1 to be resource, boolean given [include/db.inc.php:560]
mysql_free_result() expects parameter 1 to be resource, boolean given [include/db.inc.php:561]
Undefined index: file [include/page_footer.php:42]
Undefined index: file [include/page_footer.php:43]
Error in query [SELECT * FROM profiles WHERE userid= AND profileid BETWEEN 100000000000000 AND 199999999999999 ORDER BY userid ASC, profileid ASC] [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND profileid BETWEEN 100000000000000 AND 199999999999999 ORDER BY userid ASC, p' at line 1]
mysql_fetch_assoc() expects parameter 1 to be resource, boolean given [include/db.inc.php:560]
mysql_free_result() expects parameter 1 to be resource, boolean given [include/db.inc.php:561]

Screenshot is also in the Attachment.

Before converting DB to DM setup Zabbix frontend was working fine with this DB.



 Comments   
Comment by Alexander Vladishev [ 2011 Dec 20 ]

Confirmed with PostgreSQL r24096.

Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 22 ]

Broken by ZBX-3104 r23677.

Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 23 ]

RESOLVED.

Comment by Alexander Vladishev [ 2011 Dec 23 ]

Successfully tested! Please review my changes in r24224.

<pavels> CLOSED.

Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 23 ]

Merged to trunk r24231.

CLOSED.





[ZBX-4468] There is possibility to create value mappings with the same name Created: 2011 Dec 20  Updated: 2017 May 30  Resolved: 2012 Jan 09

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 1.9.9 (beta)
Fix Version/s: 1.8.11, 1.9.9 (beta)

Type: Incident report Priority: Blocker
Reporter: Igor Danoshaites (Inactive) Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: valuemapping
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

1.9.9 (trunk), 1.8.x


Issue Links:
Duplicate
duplicates ZBX-4498 Not possible to create value map Closed

 Description   

There is possibility to create value mappings with the same name (field name in the Zabbix DB), the only difference between such mappings will be value of the "valuemapid" field.

In v1.8.x there is the same behaviour.



 Comments   
Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 27 ]

(1) Don't use concatenation in messages, use the _s() function instead.
<Slava>RESOLVED r 24281

<pavels> Not sprintf() but _s(). It's our standard gettext wrapper for strings with arguments.
<Slava> RESOLVED r 24506

<pavels> CLOSED.

Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 27 ]

(2) The input parameters that we use in SQL queries should always be escaped. Use the zbx_dbstr to escape the name in get_valuemap()
<SlaVa>RESOLVED r 24281

<pavels> CLOSED.

Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 27 ]

(3) We use upperCamelCase for function names. Plus, I suggest we rename the get_valuemap function to getValuemapByName($name) and make the $name parameter obligatory.
<SlaVa>RESOLVED r 24281

<pavels> One more thing, all the tables in SQL queries must use an alias. Even if there's only one table.
<Slava> RESOLVED r 24506

<pavels> CLOSED.

Comment by Alexander Vladishev [ 2011 Dec 28 ]

(4) [GUI] Please review my changes in r24304
<Slava>CLOSED

Comment by Alexander Vladishev [ 2011 Dec 28 ]

(5) [GUI] Cannot update value map
ERROR: Cannot add value map. Map with name "Service state" already exist
<Slava>RESOLVED r 24359

<pavels> Still not working. REOPENED.
<Slava> RESOLVED r24490

<pavels> I thing you've meant
isset($_REQUEST['valuemapid']) && bccomp($_REQUEST['valuemapid'], $prevMap['valuemapid']) == 0
intead of
isset($prevMap['valuemapid']) && bccomp($_REQUEST['valuemapid'], $prevMap['valuemapid']) == 0
<Slava>Resolved r 24498

<pavels> CLOSED.

Comment by richlv [ 2011 Dec 28 ]

(6) it should be "already exists"
<Slava>fixed
it should be also verified whether the message should have the trailing dot or not (according to the guidelines)
<SlaVa>https://zabbix.org/wiki/Docs/specs/syntax :
2 . Main status messages like "Host added" (displayed on green/red background at the top of the page) should never end with a dot.
RESOLVED

<pavels> CLOSED.

Comment by Igor Danoshaites (Inactive) [ 2012 Jan 03 ]

(5) [GUI] "Cannot add or update value map" -->For this on 30.12.2011 has been created separate issue ZBX-4498

<pavels> This fix hasn't been merged yet.
<Slava> fixed in r 24515

Comment by Pavels Jelisejevs (Inactive) [ 2012 Jan 04 ]

(6) Please review my changes in r24512.
<Slava>CLOSED

Comment by Pavels Jelisejevs (Inactive) [ 2012 Jan 04 ]

TESTED.

Please close (6) before merging. Also, after updating to the latest trunk, please, fix (5).

Comment by Vjacheslav Shipillo (Inactive) [ 2012 Jan 04 ]

<Slava> fixed in r 24515

Comment by richlv [ 2012 Jan 04 ]

(7) merge to trunk has lots of coding guideline violations and modifies several unrelated changelog entries. i would strongly suggest reverting it, reviewing all modified code for coding style and doublechecking what it does to the changelog

edit : ok, changelog probably was intentional. why wasn't it mentioned in the commit message ?
<Slava> Sorry. I must recommit this with detailed description ?

<richlv> well, this time i'd say that it would be enough to fix formatting for all modified lines - but in future, describing all changes in the commit message would be highly appreciated
<Slava> You are so kind. RESOLVED r 24542

<richlv> 24542 has a commit message "updated to latest trunk "...
<Slava>Formating error starts after conflict resolving in 'valuemap.inc.php' . Now i re-resolve this conflicts.

<pavels> CLOSED.

Comment by Vjacheslav Shipillo (Inactive) [ 2012 Jan 05 ]

<Slava> Pavel, please review my confict resolving in 24542 'valuemap.inc.php'

<pavels> CLOSED. Before merging to trunk, please review my changes in r24578 and r24579.
<Slava> CLOSED

Comment by Vjacheslav Shipillo (Inactive) [ 2012 Jan 06 ]

fixed in trunk in 24575

Comment by Pavels Jelisejevs (Inactive) [ 2012 Jan 06 ]

Fix for 1.8 is TESTED.

Please review my changes before merging.
<Slava> CLOSED

Comment by Vjacheslav Shipillo (Inactive) [ 2012 Jan 06 ]

fixed in 1.8 r 24593

Comment by Oleksii Zagorskyi [ 2012 Jan 09 ]

Reopened to replace 2.0 to 1.9.9 in the Fix version/s

Comment by Oleksii Zagorskyi [ 2012 Jan 09 ]

Closed again.





[ZBX-4467] Screen - Select Zoom "ALL" -> Warning. Time period max value: 63072000 (730 d) Created: 2011 Dec 19  Updated: 2017 May 30  Resolved: 2012 Mar 06

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 1.9.9 (beta)
Fix Version/s: 1.9.9 (beta), 2.0.0rc1

Type: Incident report Priority: Major
Reporter: Kenneth Palmertree Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: usability
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Zabbix-1.9.9-23907
CentOS 6.0
MySQL 5.5.19



 Description   

If a user selects "ALL" in zoom while viewing SCREENS, even if there is only a few weeks of data, the zoom goes out to 2 years and displays the following message: Warning. Time period max value: 63072000 (730 d).



 Comments   
Comment by Alexander Sorokin (Inactive) [ 2012 Jan 18 ]

Fixed in development branch svn://svn.zabbix.com/branches/dev/ZBX-4467

Comment by richlv [ 2012 Jan 18 ]

(2) as discussed with zalex, string change that only changed [] to "" should also be reflected in all translations that had those strings translated. it should be made so that these translations are not lost (both msgid and msgstr must be properly changed). it should not be changed for languages that didn't have those strings translated.
if in doubt, consult translation maintainers : https://zabbix.org/wiki/Translating_Zabbix

<pavels> But he didn't change only of those strings. Or am I missing something?

<richlv> this was my failure, commented on the wrong issue. added (30) to ZBX-2737 instead, CLOSED here

Comment by Pavels Jelisejevs (Inactive) [ 2012 Jan 19 ]

(3) Since we have a nice _n() function, let's use it in graphs.inc.php:378 and :382.
<sanja> RESOLVED

<pavels> CLOSED.

Comment by Pavels Jelisejevs (Inactive) [ 2012 Jan 25 ]

Merged to trunk r25017.

CLOSED.

Comment by richlv [ 2012 Feb 24 ]

(4) regression. set ZBX_MAX_PERIOD to 10 years, have 5 years worth of data. in a graph, click "all" - it goes to two years. try this in rev 25016 - it goes to whatever amount of data you have

<pavels> RESOLVED in /branches/dev/ZBX-4467.

<richlv> functionally seems to work as expected again, CLOSED

Comment by Eduards Samersovs (Inactive) [ 2012 Feb 29 ]

(5) Will be nice to crop slider till max period size in event when user make it bigger.

<pavels> I've talked to Alexander about that, and we've decided to fix this as a separate issue later. CLOSED.

Comment by Eduards Samersovs (Inactive) [ 2012 Mar 05 ]

Tested

Comment by Pavels Jelisejevs (Inactive) [ 2012 Mar 05 ]

The fix for the maximum period has been merged to trunk r25792.

CLOSED.

Comment by Oleksii Zagorskyi [ 2012 Mar 06 ]

In cases like this the "Fix version/s" should contain two values: 1.9.9 and 1.9.10 because both releases have changes related to this issue.
REOPENED

Comment by Oleksii Zagorskyi [ 2012 Mar 06 ]

closed again with two values





[ZBX-4458] Uncaught exception in js when save global macros Created: 2011 Dec 16  Updated: 2017 May 30  Resolved: 2011 Dec 23

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 1.9.8 (beta)
Fix Version/s: 1.9.9 (beta)

Type: Incident report Priority: Blocker
Reporter: Alexey Fukalov Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: macros
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified


 Description   

When update global macros, if js console is open it can be seen that right before page is reloaded there is uncaught exception "deleted_macro_cnt is not defined"



 Comments   
Comment by Alexey Fukalov [ 2011 Dec 21 ]

dev branch: svn://svn.zabbix.com/branches/dev/ZBX-4458

Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 22 ]

(1) Please review my commit r24162.

<Vedmak> CLOSED

Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 22 ]

Update to my commit 24163 and then you can merge.

TESTED.

Comment by Alexey Fukalov [ 2011 Dec 22 ]

MERGED: svn://svn.zabbix.com/trunk 24167

Comment by richlv [ 2011 Dec 22 ]

(2) i don't like the following :
return confirm('<?php echo _('Are you sure you want to delete'); ?> 'removedCount' <?php echo _('macro(s)') ?>?');

we are composing a message for translation from 2 strings, which makes it hard to translate for many languages.
if we can't use placeholders in js, we should use the S_ thingie, which should allow placeholders

<Vedmak> How S_ thingie can help with placeholders?
I think we can't do this without any js gettext implementations.

<richlv> right, got confused
CLOSED





[ZBX-4456] Error is shown below form in IT services configuration Created: 2011 Dec 16  Updated: 2017 May 30  Resolved: 2011 Dec 27

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 1.9.8 (beta)
Fix Version/s: 1.9.9 (beta)

Type: Incident report Priority: Blocker
Reporter: Alexey Fukalov Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: itservices
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: PNG File itservices.png    

 Description   

Try to add incorrect time period



 Comments   
Comment by Alexey Fukalov [ 2011 Dec 22 ]

dev branch: svn://svn.zabbix.com/branches/dev/ZBX-4456

Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 23 ]

(1) If an error occurred, then all of the values we've entered are lost. We should probably keep them in the form.

<Vedmak> RESOLVED

<pavels> CLOSED.

Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 23 ]

(2) If we leave the time field empty, the error message looks like this "Error adding service time ":". Should be from 00:00 to 24:00.". The ":" part is kind of ugly.

<Vedmak> RESOLVED

<pavels> CLOSED.

Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 23 ]

(3) Fixed a typo in r24212. Please review.

<Vedmak> CLOSED

Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 27 ]

Fixed a bracket in r24273 =)

TESTED.

Comment by Alexey Fukalov [ 2011 Dec 27 ]

merged: svn://svn.zabbix.com/trunk 24279





[ZBX-4455] Not escaped input in IT services configuration. Created: 2011 Dec 16  Updated: 2017 May 30  Resolved: 2011 Dec 20

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 1.8.9, 1.9.8 (beta)
Fix Version/s: 1.8.11, 1.9.9 (beta)

Type: Incident report Priority: Blocker
Reporter: Alexey Fukalov Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: itservices
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: PNG File itservices1.png    

 Description   

Sort order field seems not escaped.



 Comments   
Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 20 ]

Fixed for 1.8.

RESOLVED.

Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 21 ]

Merged to trunk r24126.

Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 28 ]

Merged to 1.8 r24315.

CLOSED.





[ZBX-4453] Global search is a bit misaligned Created: 2011 Dec 16  Updated: 2017 May 30  Resolved: 2012 Feb 02

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 1.9.8 (beta)
Fix Version/s: 1.9.9 (beta)

Type: Incident report Priority: Trivial
Reporter: Alexey Fukalov Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: trivial
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: PNG File search.png    

 Description   

Global search input is a bit misplaced, was more to the right in 1.8.



 Comments   
Comment by Alexei Vladishev [ 2012 Feb 02 ]

I believe it is no longer the case in latest trunk (rev 25169) . Can we close it?

Comment by Alexey Fukalov [ 2012 Feb 02 ]

Yep, seems it was fixed.





[ZBX-4449] Unexpected no permissions error in IT services Created: 2011 Dec 16  Updated: 2017 May 30  Resolved: 2011 Dec 21

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 1.9.8 (beta)
Fix Version/s: 1.9.9 (beta)

Type: Incident report Priority: Blocker
Reporter: Alexey Fukalov Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: itservices, permissions
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: PNG File itservices.png    

 Description   

1. Go to Monitoring.
2. Click on green bar to go to "Availability report".
3. Click on link to IT service in page header.



 Comments   
Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 21 ]

RESOLVED.

Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 22 ]

Merged to trunk revision 24165.

CLOSED.





[ZBX-4448] Not possible to create Passive proxy Created: 2011 Dec 15  Updated: 2017 May 30  Resolved: 2011 Dec 21

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 1.9.9 (beta), 2.0.0
Fix Version/s: 1.9.9 (beta)

Type: Incident report Priority: Blocker
Reporter: Igor Danoshaites (Inactive) Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: proxy, regression, trivial
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: PNG File passive_proxy_creation_error.png    

 Description   

When in the "Administration->DM->Proxies" report trying to create Passive proxy appears the following error:

ERROR: Cannot add proxy
Incorrect arguments passed to function [CProxy.create -> CHostInterface.create -> CHostInterface.checkInput]

Please see attached screen shot.

By the way, Active proxy can be created without any problems.



 Comments   
Comment by Igor Danoshaites (Inactive) [ 2011 Dec 15 ]

Trunk rev #24012.

Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 16 ]

RESOLVED.

Comment by Alexander Vladishev [ 2011 Dec 17 ]

(1) Cannot update a proxy (same error message)
Steps to reproduce:

  • create active proxy
  • open its and change a type to Passive
  • save

<pavels> RESOLVED in 24059.
<Sasha> REOPENED frontends/php/api/classes/class.cproxy.php:385 The interface can be only one. What for here 'foreach'?

<pavels> Right. Anyway, I think I'll fix it a bit differently.

<pavels> RESOLVED.

<Sasha> REOPENED frontends/php/api/classes/class.cproxy.php:403,451 It is necessary to remove and from these places 'foreach'.

<pavels> RESOLVED.
<Sasha> CLOSED

Comment by Alexander Vladishev [ 2011 Dec 19 ]

(2) The interface remains not deleted if we change type to "active"

After that we can't make it passive again:
Host cannot have more than one default interface of the same type. [CProxy.update -> CHostInterface.create ->
CHostInterface.checkMainInterfacesOnCreate -> CHostInterface.checkMainInterfaces]

<pavels> RESOLVED.
<Sasha> REOPENED the active proxy shouldn't have an interface

<pavels> RESOLVED.
<Sasha> CLOSED

Comment by Alexander Vladishev [ 2011 Dec 20 ]

(3) Formatting and coding style:
frontends/php/api/classes/class.chostinterface.php:866 the field 'status' is not used anywhere
frontends/php/include/views/administration.proxy.edit.php:32 unused variable $interfaces
frontends/php/include/views/administration.proxy.edit.php:77:80 formatting

<pavels> RESOLVED.
<Sasha> CLOSED

Comment by Alexander Vladishev [ 2011 Dec 20 ]

(4) The proxy should have a main interface

<pavels> RESOLVED.
<Sasha> CLOSED

Comment by Alexander Vladishev [ 2011 Dec 21 ]

(5) Formatting and coding style:
frontends/php/api/classes/class.cproxy.php:359 'main' not boolean variable; true -> INERFACE_PRIMARY
frontends/php/api/classes/class.cproxy.php:450 in such cases we should use API_OUTPUT_REFER

<pavels> CLOSED.

Comment by Alexander Vladishev [ 2011 Dec 21 ]

Tested successfully. Before merge please fix (5)

Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 21 ]

Merged to trunk r24139.

CLOSED.





[ZBX-4446] Incorrect event duration Created: 2011 Dec 15  Updated: 2017 May 30  Resolved: 2011 Dec 15

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 1.9.8 (beta)
Fix Version/s: 1.9.9 (beta)

Type: Incident report Priority: Blocker
Reporter: Pavels Jelisejevs (Inactive) Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: events
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: PNG File events.png    

 Description   

The highlighted trigger should have the same duration as the first one, not zero.



 Comments   
Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 15 ]

RESOLVED.

Comment by Oleksii Zagorskyi [ 2011 Dec 16 ]

May this fix help for ZBX-4412 ?

<pavels> No, it doesn't affect the "last changed" column, only the duration.

Comment by Alexander Vladishev [ 2011 Dec 16 ]

TESTED. Please review my changes in r24043.

Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 19 ]

Merged to trunk r24057.

CLOSED.





[ZBX-4427] Bad network map trigger higlight for host groups Created: 2011 Dec 08  Updated: 2017 May 30  Resolved: 2011 Dec 14

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 1.9.9 (beta)
Fix Version/s: 1.9.9 (beta)

Type: Incident report Priority: Blocker
Reporter: Sergey Syreskin Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: maps
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: PNG File hostgroup_map_bug.png    

 Comments   
Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 14 ]

Fixed in /branches/dev/ZBX-4427. RESOLVED.

Comment by Alexey Fukalov [ 2011 Dec 19 ]

(1)
I removed two .htaccess files, if it's ok, can be merged.

<pavels> OK. CLOSED.

Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 19 ]

Merged to trunk r24075. CLOSED.





[ZBX-4425] When update item interface is set to null Created: 2011 Dec 08  Updated: 2017 May 30  Resolved: 2012 Apr 10

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: API (A), Frontend (F)
Affects Version/s: 1.9.8 (beta)
Fix Version/s: 1.9.9 (beta)

Type: Incident report Priority: Blocker
Reporter: Alexey Fukalov Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: items, lld, trivial
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: JPEG File cannot_add_host.jpg    
Issue Links:
Duplicate
is duplicated by ZBX-4480 using "Interfaces" as Application nam... Closed

 Comments   
Comment by richlv [ 2011 Dec 08 ]

(1) i believe this is the 3rd time for the same bug... unittests

<pavels> I've added a simple create/retrieve/delete unit test for the item API, plus a special test for this case ). RESOLVED.

Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 13 ]

RESOLVED.

Comment by Alexey Fukalov [ 2011 Dec 14 ]

(2) [GUI]
Incorrect formatting of "if" statements, and some logic improvements we discussed.

<pavels> RESOLVED.

<Vedmak> we decided to have next line in long "ifs" to be indented with two tabs.

<pavels> RESOLVED.

<Vedmak> CLOSED

Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 16 ]

Merged to trunk r24033. CLOSED.

Comment by Alexander Vladishev [ 2011 Dec 20 ]

When full-cloning a host there is a following error:
"Item uses host interface from non-parent host."

https://support.zabbix.com/secure/attachment/17695/cannot_add_host.jpg

<pavels> RESOLVED in /branches/dev/ZBX-4425 r24121. This was actually broken in ZBX-3771.

<sasha> It do not agree! It's broken in r24033. In r23994 all work fine!

<pavels> Item prototype cloning never supported interfaces, Prior to r24033 it, probably, just haven't shown any errors =)

<pavels> CLOSED.

Comment by Alexander Vladishev [ 2011 Dec 21 ]

(1) frontends/php/api/classes/class.cdiscoveryrule.php:1080 In all places, except calculated item and trigger expressions, should be used 'Visible host name'

<pavels> RESOLVED.
<Sasha> TESTED Please review my changes in r24152. I have corrected some more messages.

<pavels> CLOSED.

Comment by Alexander Vladishev [ 2011 Dec 21 ]

(2) Please review my changes in r24136

<pavels> CLOSED.

Comment by Alexander Vladishev [ 2011 Dec 21 ]

Tested successfully! Please close point (1) before merge

<pavels> There have been some conflicts when I merged the changes from trunk. Please review my commit r24156.

<Sasha> RESOLVED I have corrected incorrectly merged changes. Please review them.

<pavels> Thanks. CLOSED.

Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 23 ]

Merged the prototype interface fix to the trunk in r24203.

CLOSED.

Comment by richlv [ 2012 Apr 10 ]

reopen to change labels





[ZBX-4424] Handling of the log of long Japanese Created: 2011 Dec 08  Updated: 2017 May 30  Resolved: 2011 Dec 11

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Agent (G), Server (S)
Affects Version/s: 1.8.8, 1.8.9
Fix Version/s: 1.8.10, 1.9.9 (beta), 2.0.0

Type: Incident report Priority: Blocker
Reporter: suzuka Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: items, localization
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

RHEL CentOS 5.6, 6.0 Postgresql-8.4.7



 Description   

I am monitoring Windows EventLog.

When Zabbix Server receives the log of 255 or more Japanese characters(512 bytes or more ?), an error is outputted and data is not registered.

This problem occurs in zabbix1.8.8 and 1.8.9 and it does not coour in 1.8.7 and 1.8.6.

I guess that there is a problem in handling of the Japanese character after 255 character in 1.8.8 or later.

The following is a log when I test.

1) Zabbix v1.8.8
Japanese char 254 -> correct

[pg_log]

2011-12-08 11:06:03 JST: 4352: LOG: duration: 0.480 ms statement: insert into alerts (alertid,actionid,eventid,userid,clock,mediatypeid,sendto,subject,message,status,alerttype,esc_step) values (4703,4,40420,3,1323309963,4,'sasaki@localhost','[????] Error is output to ApplicationLog on Windows2008: PROBLEM','?????????????

Error is output to ApplicationLog on Windows2008: PROBLEM
Last value: ????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????

',0,0,0)

[zabbix_server.log]

none

2) Zabbix v1.8.8
Japanese char 255 -> Not correct

[pg_log]

2011-12-08 11:10:32 JST: 4354: ERROR: invalid byte sequence for encoding "UTF8": 0xe32720
2011-12-08 11:10:32 JST: 4354: HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding".
2011-12-08 11:10:32 JST: 4354: ERROR: current transaction is aborted, commands ignored until end of transaction block
2011-12-08 11:10:32 JST: 4354: STATEMENT: insert into history_log (id,itemid,clock,timestamp,source,severity,value,logeventid) values (8,25109,1323310227,1323310148,'EventCreate',4,'???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????',1000);

2011-12-08 11:10:32 JST: 4354: ERROR: current transaction is aborted, commands ignored until end of transaction block

[zabbix_server.log]

3688:20111208:111032.678 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: invalid byte sequence for encoding "UTF8": 0xe32720
HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encodi
ng".
[update items set lastclock=1323310227,lastlogsize=15486,mtime=0,prevvalue=lastvalue,lastvalue='??????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????<E3>' where itemid=25109;
]
3688:20111208:111032.679 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: current transaction is aborted, commands ignored until end of tra
nsaction block
[insert into history_log (id,itemid,clock,timestamp,source,severity,value,logeventid) values (8,25109,1323310227,1323310148,'EventCreate',4,'?
??????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????',1000);
]
3688:20111208:111032.679 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: current transaction is aborted, commands ignored until end of tra
nsaction block
[select distinct t.triggerid,t.type,t.value,t.error,t.expression,f.itemid from triggers t,functions f,items i where t.triggerid=f.triggerid and
f.itemid=i.itemid and t.status=0 and f.itemid in (25109) order by t.triggerid]

3) Zabbix v1.8.7
Japanese char 254 -> correct

[pg_log]

2011-12-08 11:34:34 JST: 5504: LOG: duration: 0.747 ms statement: insert into alerts (alertid,actionid,eventid,userid,clock,mediatypeid,sendto,subject,message,status,alerttype,esc_step) values (4705,4,40681,3,1323311674,4,'sasaki@localhost','[????] Error is output to ApplicationLog on Windows2008: PROBLEM','?????????????

Error is output to ApplicationLog on Windows2008: PROBLEM
Last value: ??????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????

',0,0,0)

[zabbix_server.log]

none

4) Zabbix v1.8.7
Japanese char 255 -> correct

[pg_log]

2011-12-08 11:38:05 JST: 5504: LOG: duration: 0.764 ms statement: insert into alerts (alertid,actionid,eventid,userid,clock,mediatypeid,sendto,subject,message,status,alerttype,esc_step) values (4706,4,40682,3,1323311885,4,'sasaki@localhost','[????] Error is output to ApplicationLog on Windows2008: PROBLEM','?????????????

Error is output to ApplicationLog on Windows2008: PROBLEM
Last value: ???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????

',0,0,0)

[zabbix_server.log]

none



 Comments   
Comment by Alexander Vladishev [ 2011 Dec 11 ]

Fixed in the development branch svn://svn.zabbix.com/branches/dev/ZBX-4424

Comment by dimir [ 2011 Dec 12 ]

Please review my changes in r23928.

<Sasha> Great! CLOSED

Comment by Alexander Vladishev [ 2011 Dec 13 ]

Fixed in version pre-1.8.10, revision 23950.





[ZBX-4418] zabbix_server [98798]: ERROR [file:db.c,line:1464] Something impossible has just happened. Created: 2011 Dec 05  Updated: 2017 May 30  Resolved: 2011 Dec 09

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Server (S)
Affects Version/s: 1.9.8 (beta)
Fix Version/s: 1.9.9 (beta), 2.0.0

Type: Incident report Priority: Blocker
Reporter: Danilo Chilene Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: events, sql
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

FreeBSD srv-zabbix01.trendeiras 8.2-RELEASE-p4 FreeBSD 8.2-RELEASE-p4 #5: Mon Dec 5 07:57:08 BRST 2011 [email protected]:/usr/obj/usr/src/sys/TREND amd64

FreeBSD inside vmware, typical instalation.

(root@srv-zabbix01 - ~ @14:29:40)
1: pkg_info |grep mysql
mysql-client-5.5.17 Multithreaded SQL database (client)
mysql-server-5.5.17 Multithreaded SQL database (server)
php5-mysql-5.3.8 The mysql shared extension for php

./configure --prefix=/usr/local --sysconfdir=/usr/local/etc/zabbix --enable-server --enable-agent --with-mysql --with-libcurl --with-net-snmp --with-ssh2 --with-ldap --with-openipmi



 Description   

Strange behavior of log /tmp/zabbix_server.log
I always get strange network errors when running Zabbix on FreeBSD.

Below the error:

98798:20111205:143001.507 [Z3005] query failed: [1690] BIGINT UNSIGNED value is out of range in '(`zabbix`.`ids`.`nextid` + -(5256))' [update ids set nextid=nextid+-5256 where nodeid=0 and table_name='events' and field_name='eventid']
zabbix_server [98798]: ERROR file:db.c,line:1464 Something impossible has just happened.
98798:20111205:143031.469 [Z3005] query failed: [1690] BIGINT UNSIGNED value is out of range in '(`zabbix`.`ids`.`nextid` + -(5256))' [update ids set nextid=nextid+-5256 where nodeid=0 and table_name='events' and field_name='eventid']



 Comments   
Comment by Alexander Vladishev [ 2011 Dec 09 ]

Fixed in the development branch svn://svn.zabbix.com/branches/dev/ZBX-4418

Comment by dimir [ 2011 Dec 12 ]

Tested.

Comment by Alexander Vladishev [ 2011 Dec 12 ]

Fixed in version pre-1.9.9, revision 23920.





[ZBX-4417] Undef variable in history text items Created: 2011 Dec 05  Updated: 2017 May 30  Resolved: 2011 Dec 06

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 1.9.9 (beta)
Fix Version/s: 1.9.9 (beta)

Type: Incident report Priority: Major
Reporter: Alexey Pustovalov Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Duplicate
duplicates ZBX-3366 sorting changes what data is returned Closed

 Description   

https://zabbix.**/history.php?action=showvalues&period=3600&itemid=1075103
Undefined variable: sortorder [api/classes/class.chistory.php:228]

for text values.



 Comments   
Comment by Oleksii Zagorskyi [ 2011 Dec 06 ]

Maybe it has been already fixed in a dev branch here:
https://support.zabbix.com/browse/ZBX-3366?focusedCommentId=51208&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-51208

Comment by Alexander Vladishev [ 2011 Dec 06 ]

It will be fixed with ZBX-3366. I'm closing duplicated issue.





[ZBX-4411] Search doesn't work in 1.9.9.x-23609 Created: 2011 Nov 30  Updated: 2017 May 30  Resolved: 2011 Dec 05

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 1.9.9 (beta)
Fix Version/s: 1.9.9 (beta)

Type: Incident report Priority: Blocker
Reporter: Sergey Syreskin Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: search
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

PostgreSQL 8.4, RHEL 5.5-based OS, Firefox 3.0.19


Attachments: File mb_stripos.patch     PNG File search_fail.png     PNG File search_fail1.png     PNG File search_fail2.png    

 Description   

Frontend presents an empty page after search, see screenshot.



 Comments   
Comment by Alexander Sorokin (Inactive) [ 2011 Nov 30 ]

Trunk 23633 - search working.

Comment by Igor Danoshaites (Inactive) [ 2011 Nov 30 ]

Hi,

I can not reproduce the same problem in v1.9.9, rev #23645.

Can you please upgrade and try this revision ?

Comment by richlv [ 2011 Nov 30 ]

also - what theme is that ? does it work with english locale ? do you have any errors in the apache log ?

Comment by Sergey Syreskin [ 2011 Dec 01 ]

Rich, the theme is "Black & Blue". It doesn't work with English locale and default theme either. There are no any errors in the apache log.

I'll try http://www.zabbix.com/downloads/nightly/pre-zabbix-1.9.9.x-23657.tar.gz later today and post the result here.

Can this problem be related to Postgres? Some strange bugs are caused by Zabbix incompatibility with Postgres, for example, icons corruption after xml map import. Did anybody test search in trunk with Postgres backend?

Comment by Igor Danoshaites (Inactive) [ 2011 Dec 01 ]

Hi,

Just for the record:

For me search is working fine in v1.9.9 (rev #23645) when using PosgreSQL DB and using "Black & Blue" theme with English locale.

Need to debug this specific case more deeper.

Comment by Sergey Syreskin [ 2011 Dec 01 ]

Compilation of http://www.zabbix.com/downloads/nightly/pre-zabbix-1.9.9.x-23657.tar.gz fails.

<---cut--->
Making all in housekeeper
make[3]: Entering directory `/usr/src/zabbix_1.9.9/zabbix-1.9.9/src/zabbix_server/housekeeper'
x86_64-linux-gnu-gcc -DHAVE_CONFIG_H -I. -I../../../include -Wall -g -O2 -I/usr/include/postgresql -I/usr/include -I/usr/local/include -I/usr/lib/perl/5.10/CORE -I. -I/usr/include -I/usr/include -I/usr/include -I/usr/include -MT housekeeper.o -MD -MP -MF .deps/housekeeper.Tpo -c -o housekeeper.o housekeeper.c
housekeeper.c: In function ‘housekeeping_cleanup’:
housekeeper.c:135: error: ‘ids_alloc’ undeclared (first use in this function)
housekeeper.c:135: error: (Each undeclared identifier is reported only once
housekeeper.c:135: error: for each function it appears in.)
housekeeper.c:135: error: ‘ids_num’ undeclared (first use in this function)
housekeeper.c: In function ‘housekeeping_alerts’:
housekeeper.c:186: warning: ‘return’ with a value, in function returning void
housekeeper.c: In function ‘housekeeping_events’:
housekeeper.c:213: warning: ‘return’ with a value, in function returning void
housekeeper.c: In function ‘main_housekeeper_loop’:
housekeeper.c:328: error: void value not ignored as it ought to be
housekeeper.c:331: error: void value not ignored as it ought to be
make[3]: *** [housekeeper.o] Ошибка 1
make[3]: Leaving directory `/usr/src/zabbix_1.9.9/zabbix-1.9.9/src/zabbix_server/housekeeper'
make[2]: *** [all-recursive] Ошибка 1
make[2]: Leaving directory `/usr/src/zabbix_1.9.9/zabbix-1.9.9/src/zabbix_server'
make[1]: *** [all-recursive] Ошибка 1
make[1]: Leaving directory `/usr/src/zabbix_1.9.9/zabbix-1.9.9/src'
make: *** [all-recursive] Ошибка 1
<---cut--->

Comment by Sergey Syreskin [ 2011 Dec 01 ]

I have taken frontend and database data files from the above nightly build, and have the same bug, see new screenshot.
It is interesting that if nothing is found, Zabbix generates web page as expected.

Comment by Igor Danoshaites (Inactive) [ 2011 Dec 01 ]

Hi,

Compilation errors "error: void value not ignored as it ought to be" were fixed today in trunk branch, in rev #23663.
Compilation problems were fixed in ZBX-4298.

Concerning not working global search- please confirm the same behaviour (not working search) in the latest trunk revision.
As already told, I can not confirm the same in v1.9.9 (rev #23645) when using PosgreSQL DB and using "Black & Blue" theme with English locale.

Comment by Sergey Syreskin [ 2011 Dec 01 ]

Igor, I experience the same problem with search in 1.9.9. 23674, original light blue theme and English locale.

Comment by Alexei Vladishev [ 2011 Dec 02 ]

Sergey,

Do you have any relevant messages in the apache error log?

Comment by Sergey Syreskin [ 2011 Dec 02 ]

Ooops! I'm sorry, I have looked Apache logs on another virtual machine Yes, there actually is an error:
PHP Fatal error: Call to undefined function mb_stripos() in /usr/share/zabbix/include/func.inc.php on line 855

My PHP version is php-5.1.6-27.el5.x86_64.rpm. Apache is httpd-2.2.3-43.el5.centos.x86_64.rpm.

Comment by Igor Danoshaites (Inactive) [ 2011 Dec 02 ]

Sergey,

Seems that this error means that there are no "mbstring" module.

Can you please check that you have PHP "mbstring" module enabled ?

"Multibyte Support" should be enabled.

Please let us know about the results after that.

Comment by Sergey Syreskin [ 2011 Dec 02 ]

php-mbcstring-5.1.6-27.x86_64.rpm is installed.
mbstring.so in enabled in /etc/php.d/mbstring.ini
Zabbix installation wizard says that PHP mbstring is OK.

Comment by Alexei Vladishev [ 2011 Dec 02 ]

Please could you replace:

function mbstrings_available()

{ return (function_exists('mb_strlen') && function_exists('mb_strtoupper') && function_exists('mb_strpos') && function_exists('mb_substr')); }

by

function mbstrings_available()

{ return (function_exists('mb_strlen') && function_exists('mb_strtoupper') && function_exists('mb_strpos') && function_exists('mb_stripos') && function_exists('mb_substr')); }

in include/locales.inc.php and tell us if it works or not. Thanks!

It looks like you mbstring module has some functions missing.

Comment by Sergey Syreskin [ 2011 Dec 02 ]

According to Apache log my mbstring module lacks 'mb_stripos' function.

Comment by Sergey Syreskin [ 2011 Dec 02 ]

I have found the following workaround for this problem;

function zbx_stripos($haystack, $needle, $offset = 0) {
if (defined('ZBX_MBSTRINGS_ENABLED')) {

  • return mb_stripos($haystack, $needle, $offset);
    + return mb_strpos(mb_convert_case($haystack, MB_CASE_LOWER), mb_convert_case($needle, MB_CASE_LOWER), $offset);
Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 05 ]

The mb_stripos() function was implemented only in PHP 5.2. Maybe you have an older PHP installation. Anyway, since we support PHP 5.1.6, I've replaced it the way Sergey proposed.

<richlv> as per https://support.zabbix.com/browse/ZBX-4411?focusedCommentId=51255&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-51255 , that's indeed 5.1.6

<pavels> RESOLVED.

Comment by richlv [ 2011 Dec 05 ]

just a note - we don't seem to use mb_stripos in 1.8, so no fix needed for it - although we might have to be a bit more careful when relying on new functions

Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 07 ]

Merged to trunk r23828.

CLOSED.





[ZBX-4407] Cannot import 1.8 template to 1.9 Created: 2011 Nov 29  Updated: 2017 May 30  Resolved: 2012 Jun 13

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 1.9.8 (beta)
Fix Version/s: 1.9.9 (beta)

Type: Incident report Priority: Major
Reporter: Marcel Hecko Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: comma, import
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

apache2.2



 Description   

Error in item key: "Invalid item key format.". when importing template/host with item of type "simple", key "tcp,1520"
after changing the comma to another character, the import works fine



 Comments   
Comment by Alexander Sorokin (Inactive) [ 2011 Nov 30 ]

Version 1.9 has new key format. You need to change keys manually.

Comment by Igor Danoshaites (Inactive) [ 2011 Nov 30 ]

More info about these changes are available here: http://www.zabbix.com/documentation/2.0/manual/config/items/itemtypes/4_simple_checks

Comment by richlv [ 2011 Nov 30 ]

awwww. we just have to support 1.8 xml as an absolute minimum, otherwise most templates would be unusable.

db upgrade patch converts such keys - frontend xml legacy import code (for 1.8) must convert those keys in the exact same way

Comment by Alexander Sorokin (Inactive) [ 2011 Dec 08 ]

Fixed in development branch svn://svn.zabbix.com/branches/dev/ZBX-4407

Comment by richlv [ 2011 Dec 08 ]

(1) it changes (which is great) :
$host_db['profile_mode'] = isset($host_db['profile']) ? HOST_PROFILE_MANUAL : HOST_PROFILE_DISABLED;
$host_db['profile_mode'] = isset($host_db['profile']) ? HOST_INVENTORY_MANUAL : HOST_INVENTORY_DISABLED;

but maybe should also change profile_mode and "profile" ?

<pavels> I think $host_db['profile_mode'] should be changed to $host_db['inventory_mode'], but double check it please.

<sanja> RESOLVED

<richlv> i believe "isset($host_db['profile'])" should also be changed to 'inventory', but it should be doublechecked

<sanja> RESOLVED

<richlv>
// HOST PROFILES {{

{ ... // }

}} HOST PROFILES

<sanja> RESOLVED

<pavels> It's great that we fixed the notice, but profile data import doesn't work at all. Please, have a look.
<richlv> i split this out as (6)

<richlv> this is where i'd like to refer to DeepC presentation slides again
it would help us all if we all would try to understand what the issue is and fix it fully, properly and finally. in this case we did an issue pingpong for "profile_mode" and "profile" separately. then another round for "HOST PROFILES" - in this case it was even visible in the diff context for the two previous changes.

as such i would like to suggest using svn diff, and attempt to fix the issue so nobody could come and point at things missed (like i'm doing now )
i was ready to split out remaining renames in another issue, but as pavel noted that profile import doesn't work, let's do it here instead.

so instead of pointing at specific instances, let's just remove any reference to host profiles (except for 1.8 xml format, of course). please note that we shouldn't nuke user profiles in any way

<pavels> Yeah, that's I meant by "double check it please" =) I haven't tested the fix since then, so I've noticed the problem just now. Anyway, CLOSED.

<richlv> as discussed, let's be pedantic enough and clear this up completely
as in, no references to host profile should be anywhere in the code, they all should refer to "inventory" except 1.8 xml fields

<sanja> Can not find any references! Maybe You have found some before reopening this issue?

<richlv> there might be more that i missed, but here's one file with them :

./include/maps.inc.php: $hostsToGetProfiles = array();
./include/maps.inc.php: // if we have icon map applied, we need to get profiles for all hosts,
./include/maps.inc.php: $hostsToGetProfiles[] = $selement['elementid'];
./include/maps.inc.php: 'hostids' => $hostsToGetProfiles,
./include/maps.inc.php: $profiles = getHostInventories();

<sanja> Fixed that and 1 more.
RESOLVED

Comment by richlv [ 2011 Dec 08 ]

(2) function convertOldSimpleKey seems to be defined both in class.ctriggerexpression.php and export.inc.php - that scares me a bit... wouldn't it be better to define it only once ?

<pavels> Yes, that's very very wrong. Since this conversion is required only when importing, I suggest we move it into a protected method of zbxXML class and only perform the conversion there. Plus, it shouldn't be done when creating new triggers in the trunk, only when importing old ones.

<sanja> RESOLVED

<pavels> CLOSED.

Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 09 ]

(4) Regarding in class.ctriggerexpression.php:235. I know we sometimes use references in foreach loops, but mostly in simple loops where we just need to perform some modifications on the arrays, like unsetting some keys. In more complex loops like this one, it's best not to use references, as it may cause unexpected problems.

<sanja> RESOLVED

<pavels> CLOSED.

Comment by richlv [ 2011 Dec 21 ]

(5) "Converts Simle key"
i also believe "$keyWithotPerf" is a typo
export.inc.php has lost trailing newline

<sanja> RESOLVED

<richlv> CLOSED

Comment by richlv [ 2011 Dec 22 ]

(6) <pavels> It's great that we fixed the notice, but profile data import doesn't work at all. Please, have a look.

<sanja> RESOLVED

<pavels> The new line character should be "\r\n" to work properly on mac and windows. And there are no name conflicts between host profile fields, so we don't need to combine them there. I've corrected it, please review r24209 and r24210. Otherwise, good.

<sanja> CLOSED

Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 23 ]

TESTED.

Before merging, please close (6).

Comment by richlv [ 2011 Dec 23 ]

we got a workflow problem here

rev 24216 merged this dev branch to trunk already, but rev 24221 did changes in the dev branch after that. these changes will be lost.

dev branch should be deleted, recreated, changes from rev 24221 reapplied and problem (1) fully fixed

<sanja> RESOLVED

<Sasha> REOPENED
in a new recreated branch no changes from a deleted ' svn di svn://svn.zabbix.com/branches/dev/ZBX-4407@24225 -c24221 ' branch

<sanja> RESOLVED

<Sasha> CLOSED

Pavels, please retest its branch. There are some changes.

Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 30 ]

TESTED again. Everything ok.

Comment by richlv [ 2012 Feb 11 ]

reopen to set proper "fix version"





[ZBX-4404] MaxHousekeeperDelete max-value is wrong either in the default zabbix_server.conf or zabbix_server/server.c Created: 2011 Nov 29  Updated: 2017 May 30  Resolved: 2012 Jan 05

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Server (S)
Affects Version/s: 1.8.8
Fix Version/s: 1.8.11, 1.9.9 (beta)

Type: Incident report Priority: Minor
Reporter: René Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: trivial
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Centos


Issue Links:
Duplicate
is duplicated by ZBX-4405 MaxHousekeeperDelete max-value is wro... Closed

 Description   

In zabbix_server.conf the range-example for MaxHousekeeperDelete does not match with the max value set in zabbix_server.c

zabbix_server.conf

  1. Range: 0-1048576

vs

#zabbix_server/server.c

{"MaxHousekeeperDelete", &CONFIG_MAX_HOUSEKEEPER_DELETE, TYPE_INT, PARM_OPT, 0, 1000000}

,



 Comments   
Comment by Alexei Vladishev [ 2011 Nov 29 ]

Thanks for reporting this. It should be fixed.

Comment by Alexander Vladishev [ 2012 Jan 05 ]

Fixed the default zabbix_server.conf in version pre-1.8.11, r24572.





[ZBX-4403]  Low level discovery rules can not be created in zabbix 1.9.8 Created: 2011 Nov 29  Updated: 2017 May 30  Resolved: 2011 Nov 30

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 1.9.8 (beta)
Fix Version/s: 1.9.9 (beta)

Type: Incident report Priority: Blocker
Reporter: ennerr Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: lld
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Duplicate
is duplicated by ZBX-4409 Creating discovery rules fails Closed

 Description   

It is impossible to add Discovery rule. After filling in required details and clicking save, following error message is displayed:

ERROR: Cannot add discovery rule

Incorrect arguments passed to function

It seems that variable $item_db_fields in the api/classes/class.citemgeneral.php function checkInput is declared in such a way as to prevent creating items without declared value_type.

Workaround is to add line

'value_type' => '0',

after the line 231 ('filter' => $filter,) in file host_discovery.php.



 Comments   
Comment by Igor Danoshaites (Inactive) [ 2011 Nov 29 ]

Confirmed this problem. The same error "ERROR: Cannot add discovery rule. Incorrect arguments passed to function [CDiscoveryRule.create -> CDiscoveryRule.checkInput -> CItemGeneral.checkInput]" appears also in the latest trunk revision #23583.

This was NOT broken by fixing issue ZBX-3510 in rev #23147.

Comment by Pavels Jelisejevs (Inactive) [ 2011 Nov 29 ]

It was broken in ZBX-3625 r23438. RESOLVED.

Comment by Igor Danoshaites (Inactive) [ 2011 Nov 29 ]

<Igor> This dev branch tested using Mysql DB, it is working as desired.
<Igor> Dev branch ZBX-4403 tested also with PostgreSQL DB, it is working as desired.

Comment by Alexander Vladishev [ 2011 Nov 30 ]

(1) The value type of the discovery rule always should be ITEM_VALUE_TYPE_TEXT.

<pavels> RESOLVED
<sasha> CLOSED

Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 01 ]

Merged to trunk revision r23661.

CLOSED.





[ZBX-4391] suffixes not properly supported in trigger testing interface in frontend Created: 2011 Nov 24  Updated: 2017 May 30  Resolved: 2012 Jan 09

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: None
Fix Version/s: 1.8.10, 1.9.9 (beta)

Type: Incident report Priority: Major
Reporter: Oleksii Zagorskyi Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: suffixes, triggertesting
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Duplicate

 Description   

When trigger expression contains the suffixes in the trigger expression then tester always returns FALSE.
Example: "host:test.item.last(0)}<1G"

The last time It worked correctly in the 1.8.2.
In the 1.8.3 - 1.8.9 and current trunk it always return FALSE.



 Comments   
Comment by Vjacheslav Shipillo (Inactive) [ 2011 Nov 30 ]

Fixed in development branch svn://svn.zabbix.com/branches/dev/ZBX-4391

Comment by Alexey Fukalov [ 2011 Nov 30 ]

(1) [GUI]
Not all suffixes are working (http://www.zabbix.com/documentation/1.8/manual/config/suffixes)

<slava> RESOLVED

<Vedmak> as decided we need support up to Y suffix.
<SlaVa> RESOLVED
<Vedmak> CLOSED

Comment by Alexey Fukalov [ 2011 Nov 30 ]

(3) [GUI]
I think regular expression could be simplyfied to smth like: "/([0-9\.]+)[K|M|G]?/" also case is significant, as "K" is not the same as "k"
<slava> RESOLVED
<Vedmak> in fact regexp can be simplified even more: "/[0-9\.]+[KMG]?/"
<SlaVa> RESOLVED
<Vedmak> CLOSED

Comment by Vjacheslav Shipillo (Inactive) [ 2011 Nov 30 ]

"Fixed in development branch svn://svn.zabbix.com/branches/dev/ZBX-4391"

<zalex> dev branch tested. works as expected.

Comment by Alexander Vladishev [ 2011 Dec 15 ]

(0) is not solved

(4) a trigger expression parser on server side do not support suffixes P (Peta), E (Exa), Z (Zetta) and Y (Yotta). Please, rollback a support of these suffixes on GUI side in the trigger expressions.

<Slava> RESOLVED

sasha Has been fixed in ^/trunk r24449. CLOSED

Comment by Vjacheslav Shipillo (Inactive) [ 2011 Dec 21 ]

Fixed in 24150

Comment by Alexey Fukalov [ 2011 Dec 22 ]

(5) [GUI]
In function "convert" there is still code for converting to yotta etc.
<Slava>RESOLVED r 24185

<Vedmak> CLOSED

Comment by Alexey Fukalov [ 2011 Dec 22 ]

(6) [GUI]
Why do you use in test both "button_click" and "click" methods?
Also formatting in test file should be fixed.
<Slava>RESOLVED r 24198

<Vedmak> CLOSED

Comment by richlv [ 2011 Dec 23 ]

(7) new file, testTriggerExpressions.php, should have svn:eol-style svn property set to 'native'
<SlaVa>RESOLVED r 24236

<richlv> CLOSED

Comment by Alexey Fukalov [ 2011 Dec 27 ]

(8) [GUI]
In trunk branch all suffixes like Y, Z, etc. are still acceptable in trigger expressions, is it ok?
<SlaVa> No, it's not ok. RESOLVED r 24282

<Vedmak> CLOSED

Comment by Alexey Fukalov [ 2011 Dec 28 ]

(9) [GUI]
Suffixes are left in defines.inc.php and maybe somewhere else..
<Slava>RESOLVED

<Vedmak> CLOSED

Comment by Vjacheslav Shipillo (Inactive) [ 2011 Dec 30 ]

fixed in r 24449

Comment by Oleksii Zagorskyi [ 2011 Dec 30 ]

(10) Missing record for the trunk ChangeLog.
1.9.9 value is missing in the "Fix Version/s:"
Will be REOPENED.
<SlaVa>
Changes for 1.8.10rc1

..F....... ZBX-4391 fixed suffix support in trigger testing interface (slava)

<zalex> I've added the tag 1.9.9 to the "Fix Version/s:"
I'm closing it. ChangeLog processing will be discussed separately.
CLOSED

Comment by richlv [ 2012 Jan 08 ]

(12) added unittest has not been added to SeleniumTests.php

added unittest testTriggerExpressions.php defines it's class name as being "testPageHosts" ...
<Slava> RESOLVED in r 24608

sasha The trigger expression parser and tests to it were completely rewritten in r31649. CLOSED

Comment by richlv [ 2013 Aug 19 ]

still not closed : (4) and (12)

sasha Reviewed and CLOSED.





[ZBX-4377] compilation with --enable-static exits with "Curl library not found" Created: 2011 Nov 23  Updated: 2017 May 30  Resolved: 2011 Dec 28

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Installation (I)
Affects Version/s: 1.8.9
Fix Version/s: 1.8.10, 1.9.9 (beta)

Type: Incident report Priority: Minor
Reporter: Robert Jerzak Assignee: dimir
Resolution: Fixed Votes: 0
Labels: static
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Ubuntu 11.10 x86_64


Attachments: Text File config.log     Text File config.log    

 Description   

Compilation with --enable-static exits with:

checking whether libcurl is usable... no
configure: error: Curl library not found

Example:
./configure --prefix=/usr/local/ --bindir=/usr/local/sbin/ --with-mysql=/usr/bin/mysql_config --enable-server --enable-agent --with-net-snmp --with-libcurl --with-openipmi --enable-ipv6

finish with no errors.

./configure --prefix=/usr/local/ --bindir=/usr/local/sbin/ --with-mysql=/usr/bin/mysql_config --enable-server --enable-agent --with-net-snmp --with-libcurl --with-openipmi --enable-ipv6 --enable-static

[...]
checking whether libcurl is usable... no
configure: error: Curl library not found

The issue can be replicated every time on Ubuntu 11.10 x86_64.



 Comments   
Comment by Igor Danoshaites (Inactive) [ 2011 Nov 23 ]

Hi,

I can reproduce the same case on Ubuntu 10.04.3.

When compiling without "enable-static" parameter all is fine, but when using "--enable-static" parameter with the same configure command, appears the following error:

checking for curl-config... /usr/bin/curl-config
checking for the version of libcurl... 7.19.7
checking for libcurl >= version 7.13.1... yes
checking for main in -lcurl... yes
checking whether libcurl is usable... no
configure: error: Curl library not found

Comment by dimir [ 2011 Nov 23 ]

Basically the behavior must be correct here. The problem is the error message though. So what configure does in the "checking whether libcurl is usable" check it compiles simple program that uses libcurl and linkes it statically. libcurl requires bunch of other libraries, which, in turn, must be available in a static versions too. I believe this is the problem, not all the required static libraries are installed.

So the fix is probably to report a proper error in this case, that libcurl is not possible to link statically, instead "libary not found".

That would require some work as we currently just have one message if there are any problem with the library - "library not found". I think we should introduce another one here - "Xxx library is not available for static linking" or something. Which would mean the library itself or any other library it depends on.

Robert, would it be possible to attach config.log which is generated right after the error? Something tells me you are missing a lot of needed static libraries.

Comment by Robert Jerzak [ 2011 Nov 23 ]

config.log from failed enable-static compilation

Comment by dimir [ 2011 Nov 25 ]

Fixed in development branch svn://svn.zabbix.com/branches/dev/ZBX-4377

There was incorrect check for static linking of libcurl. Now the error message should clearly state which library is missing.

Comment by Igor Danoshaites (Inactive) [ 2011 Nov 25 ]

Tested that dev branch ZBX-4377, now in case of error appears correct error message: "error: static library gssapi_krb5 required for linking libcurl not found".

Now it is waiting for code review.

Comment by dimir [ 2011 Dec 06 ]

Fixed in pre-1.8.10 r23802, pre-1.9.9 r23803.

Comment by Robert Jerzak [ 2011 Dec 28 ]

I think there is not always correct error message, for example arch (we use it on production systems) linux:

checking for main in -lz ... (cached) yes
checking for main in -lcurl... yes
checking whether libcurl is usable... no
configure: error: libcurl is not available for static linking

Comment by Robert Jerzak [ 2011 Dec 28 ]

config.log from arch linux

Comment by Robert Jerzak [ 2011 Dec 28 ]

I tested it on zabbix 1.8.10.

Comment by dimir [ 2011 Dec 28 ]

I doubt it will be an easy task to compile Zabbix with all these options you chose for configure statically. You realize that in this case you have to have every external library that is needed in a static version? We can't go and check every library if it's available in a static version. The message states that it's not possible to compile a program with librucl (and other things you chose) statically and it is correct.

Compiling statically is not a trivial task. Expecially if you want to have every piece compiled statically. For example it's possible to compile a program linked with libcurl statically and the rest of the libs dynamically, that would be a much easier task but we do not have currently in Zabbix such a way to define which part is to be linked statically and which dynamically. You could do that yourself by playing with Makefiles and gcc options (the position of --static in parameters list to gcc).

Besides, in some cases static linking is not possible at all:

http://stackoverflow.com/questions/3430400/linux-static-linking-is-dead

I'm closing this issue, please re-open if you disagree.

Comment by Walter Heck [ 2012 Aug 14 ]

Would it make sense to reflect in the documentation and in ./configure --help that static linking is not recommended? That could have just saved me a ton of time

Comment by richlv [ 2012 Aug 22 ]

it would make sense, but please open a new issue about it

Comment by dimir [ 2012 Aug 22 ]

I agree on adding that note. Please mention the new issue number here.

Comment by dimir [ 2012 Aug 30 ]

Added a note here:

http://www.zabbix.com/documentation/2.0/manual/installation/install#configure_the_sources

Comment by Jason Markowitz [ 2013 Aug 21 ]

I was able to work around this issue by installing glibc-static packages.





[ZBX-4376] Quoted spec symbols in lld via proxy Created: 2011 Nov 22  Updated: 2017 May 30  Resolved: 2012 Feb 21

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Proxy (P), Server (S)
Affects Version/s: 1.9.8 (beta)
Fix Version/s: 1.8.10, 1.9.9 (beta)

Type: Incident report Priority: Blocker
Reporter: Alexey Pustovalov Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: trivial
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: PNG File item_prototypes.png     PNG File items.png    

 Description   

24917:20111122:233650.539 In DCmass_proxy_add_history()
24917:20111122:233650.539 query [txnlev:1]
....
"snmp.discovery":[
....
{
"

{#SNMPINDEX}":10110,
"{#SNMPVALUE}":"GigabitEthernet0
/10"},
{
"{#SNMPINDEX}

":10111,
"

{#SNMPVALUE}

":"GigabitEthernet0
/11"},
....

and we have incorrect item key in zabbix server. Ex.:
????????:?????? ?????? GigabitEthernet0\/16 ifInUcastPkts["GigabitEthernet0\/16"]



 Comments   
Comment by Alexander Vladishev [ 2011 Nov 30 ]

It's normal. All low level discovery data is stored and processed in JSON format. Slashes (/) in JSON strings should be escaped. (www.json.org)

Please attach a screenshot, if you have a problem with LLD.

Comment by Alexey Pustovalov [ 2011 Dec 01 ]

screenshots

Comment by Alexander Vladishev [ 2011 Dec 01 ]

What database you are using on server and proxy side?

Comment by Alexander Vladishev [ 2011 Dec 01 ]

Confirmed, when using mysql on proxy side.

Comment by Alexander Vladishev [ 2011 Dec 01 ]

Could repeat only once. After setting additional debug-information in the code and compilation of a proxy the problem hasn't repeated.

Try to recompile a proxy too using these commands:

./bootstrap.sh
./configure -enable-proxy --with<db> ...
make clean
make dbschema
make install

Comment by Alexey Pustovalov [ 2011 Dec 01 ]

problem remains with last trunk proxy on PostgreSQL.

Comment by Alexey Pustovalov [ 2011 Dec 01 ]

on debian with mysql the problem hasn't repeated.
problem on gentoo with postgresql only.

Comment by Alexander Vladishev [ 2011 Dec 01 ]

Fixed in the development branch svn://svn.zabbix.com/branches/dev/ZBX-4376

Comment by Alexey Pustovalov [ 2011 Dec 01 ]

working. Thanks

Comment by dimir [ 2011 Dec 01 ]

Do we really want to "set standard_conforming_strings to off;" ?

Comment by Alexander Vladishev [ 2011 Dec 01 ]

You are right! It is the bad idea. In version PostgreSQL 8.1 this variable only for reading. I re-open this problem for finishing.

Comment by Alexander Vladishev [ 2011 Dec 01 ]

Has been fixed by another way. Please retest r23707.

Comment by dimir [ 2011 Dec 02 ]

I like it!

Comment by Alexander Vladishev [ 2011 Dec 02 ]

Fixed in version pre-1.9.9, revision 23728. Backported to pre-1.8.10, revision 23729.

Comment by richlv [ 2014 Jan 30 ]

note that json standard does not require escaping of slashes (only doublequotes and backslashes). from http://www.ietf.org/rfc/rfc4627.txt :

"All Unicode characters may be placed within the quotation marks except for the characters that must be escaped: quotation mark, reverse solidus, and the control characters (U+0000 through U+001F)."

ZBX-5116 talks about similar topic in the frontend/api





[ZBX-4336] Error not cleared when changing item status to active in frontend. Created: 2011 Nov 09  Updated: 2017 May 30  Resolved: 2012 Apr 10

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 1.9.8 (beta)
Fix Version/s: 1.9.9 (beta), 2.0.0

Type: Incident report Priority: Blocker
Reporter: dimir Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: items, unsupported
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

MySQL 5.1, Debian GNU/Linux.



 Description   

2 ways of changing item status from "not supported" to "active" out of 4 are not working properly. Not working properly meaning here not clearing the error message so on the right of the item an "error" icon is left.

Not working ways:

  • changing status from item edit form
  • changing status using "Mass update" (and then "Status" -> "Active") from the drop-down in items list

Working ways

  • clicking status in items list
  • changing status using "Activate selected" from the drop-down in items list


 Comments   
Comment by Vjacheslav Shipillo (Inactive) [ 2011 Dec 01 ]

fixed problem with item status clearing when changing to active in front-end.

Comment by richlv [ 2011 Dec 01 ]

(1) i believe spacing at the end of line for this changed block does not conform to the coding style anymore :

+ $sql = 'SELECT itemid,interfaceid,name,key_,error, hostid,delay,history,status,type,' .
<Vedmak> ye, coding style is not correct at some places.
<SlaVa>RESOLVED

<Vedmak> btw, why this sql was changed? We should not allow user change 'error' field anyhow, it's done only by server.
<SlaVa>RESOLVED
<Vedmak> CLOSED

Comment by Alexey Fukalov [ 2011 Dec 02 ]

(2) [GUI]
Error should be reset only if we change item status from "Not supported". This also should work for item prototypes and discovery rules.
<SlaVa>RESOLVED

<Vedmak> CLOSED

Comment by Vjacheslav Shipillo (Inactive) [ 2011 Dec 02 ]

Fixed in development branch svn://svn.zabbix.com/branches/dev/ZBX-4336

Comment by Alexey Fukalov [ 2011 Dec 05 ]

(3) [GUI]
Code formatting should be corrected.
<SlaVa>RESOLVED

<Vedmak> still incorrect at some places.
<SlaVa>RESOLVED

<Vedmak> CLOSED

Comment by Alexey Fukalov [ 2011 Dec 05 ]

(4) [GUI]
If we try to call item.update method without "status", which is not required, we got "Undefined index: status [api/classes/class.citemgeneral.php:174]"
<SlaVa>RESOLVED

<Vedmak> try to update any item, error about undefined index status appears.
<Slava>RESOLVED

<Vedmak> CLOSED

Comment by Alexey Fukalov [ 2011 Dec 05 ]

(5) [GUI]
If statement in items.inc.php:238
if ($status == ITEM_STATUS_ACTIVE)

{ $sql = 'UPDATE items SET status='.$status.',error=\'\' WHERE itemid='.$item['itemid']; }
else { $sql = 'UPDATE items SET status='.$status.',error='' WHERE itemid='.$item['itemid']; }

If/else with same statement
<SlaVa> changed and RESOLVED

<Vedmak> CLOSED

Comment by Alexey Fukalov [ 2011 Dec 08 ]

(6)[GUI]
Please review my changes in rev. 23863
<SlaVa>CLOSED

Comment by Vjacheslav Shipillo (Inactive) [ 2011 Dec 12 ]

fixed in version pre 1.9.9, revision 23888

Comment by richlv [ 2012 Apr 10 ]

reopen to change labels





[ZBX-4334] do not hide disabled triggers and web scenarios by default Created: 2011 Nov 09  Updated: 2017 May 30  Resolved: 2011 Nov 30

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: None
Fix Version/s: 1.9.9 (beta)

Type: Incident report Priority: Major
Reporter: richlv Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified


 Description   

in trigger and web monitoring config, by default disabled entities are not shown. this is extremely confusing for new users, as they disable something... and it disappears without any way to bring it back. small link in the upper right corner to show them is not really something users expect to look for.

i'd call this a serious usability bug

<jerware> why does configuration say I have one trigger as in Triggers (1) under the triggers column then not list it when I click the triggers link ?
<jerware> There's a [ Hide disabled triggers ] in small print in the upper left corner. thanks.
<jerware> This is the most lousy, un userfriendly interface I have ever interfaced with.



 Comments   
Comment by Alexander Sorokin (Inactive) [ 2011 Nov 30 ]

Fixed in development branch svn://svn.zabbix.com/branches/dev/ZBX-4334

Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 01 ]

Everything ok.

TESTED.

Comment by Alexander Sorokin (Inactive) [ 2011 Dec 01 ]

Fixed in trunk.





[ZBX-4311] It's possible to create a graph prototype with the same name as a host graph Created: 2011 Nov 02  Updated: 2017 May 30  Resolved: 2011 Dec 02

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: None
Affects Version/s: 1.9.7 (beta)
Fix Version/s: 1.9.9 (beta)

Type: Incident report Priority: Blocker
Reporter: Pavels Jelisejevs (Inactive) Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: discovery, graphs, lld
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified


 Description   

1. Create a host graph;
2. Create a discovery rule and a graph prototype with the same name. An error should appear.



 Comments   
Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 02 ]

RESOLVED.

Comment by Alexey Fukalov [ 2011 Dec 02 ]

(1) [GUI[
Please review my changes in r23740. Can be merged after that.

Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 02 ]

Merged to trunk revision r23746.

CLOSED.





[ZBX-4302] Cannot add trigger with more than 255 symbols in the expression field Created: 2011 Nov 01  Updated: 2017 May 30  Resolved: 2011 Dec 09

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 1.9.8 (beta)
Fix Version/s: 1.9.9 (beta)

Type: Incident report Priority: Blocker
Reporter: Alexey Pustovalov Assignee: Unassigned
Resolution: Fixed Votes: 2
Labels: expressions, triggers, validation
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

latest trunk


Issue Links:
Duplicate
duplicates ZBXNEXT-905 Redesign Configuration->Triggers Closed

 Description   

Description field in the "triggers" table have limited length.
But checking by field triggers.expression not considering that the expression will be converted



 Comments   
Comment by Igor Danoshaites (Inactive) [ 2011 Nov 01 ]

Hi,

>Description field in the "triggers" table have limited length.

In the Zabbix DB column size for both "expression" and "description" fields is set to 255 characters.

When in trunk version (v1.9.8, rev #22836) trying to create trigger with description (name) longer than 255 characters (in the frontend can enter trigger name that will be longer than 555 characters, can enter 259 characters), then in the frontend got the following error:

Value "'...'" is too long for field "description" - 259 characters. Allowed length is 255 characters. [CTrigger.update -> CTrigger.updateReal -> DB.update -> DB.checkValueTypes]

When trying to create trigger with expression longer than 256 characters, user will be not allowed to enter the remaining symbols in the expression field.

Do you mean this difference ?

Do you want us to trim these excessive symbols in the "description" field ?

Or maybe you want us to increase this length for the "expression" field ?

Comment by richlv [ 2011 Nov 01 ]

i think "description" in the issue is a mistake and it refers to frontend checking expression length before collapsing functions. dotneft, is that correct ?

if so, seems pretty serious to me and should also be doublechecked in 1.8

also ZBX-3007 should be taken into account

Comment by Alexey Pustovalov [ 2011 Nov 01 ]

yes, rich, you're right

Comment by Oleksii Zagorskyi [ 2011 Nov 01 ]

> ... should also be doublechecked in 1.8

Seems the problem is reproducible only in the trunk.

1.8 branch works well in such cases.
Successfully test with the very long item key and with the very long parameter of trigger function.

Comment by Eduards Samersovs (Inactive) [ 2011 Dec 09 ]

Fixed in development branch svn://svn.zabbix.com/branches/dev/ZBXNEXT-905

Comment by Oleksii Zagorskyi [ 2011 Dec 09 ]

Reopen to remove 2.0 form "Fix Version/s:"

Comment by Oleksii Zagorskyi [ 2011 Dec 09 ]

Closed again

Comment by Simon Kowallik [ 2012 Mar 30 ]

zabbix-2.0.0rc3.x-26490/database/mysql# grep expression schema.sql
expression varchar(255) DEFAULT '' NOT NULL,
expression varchar(64) DEFAULT '' NOT NULL,
expression varchar(255) DEFAULT '' NOT NULL,

The mysql DB schema limits expressions to 255 chars by default?!

Thats to short I think.

Comment by Simon Kowallik [ 2012 Mar 30 ]

— frontends/php/include/schema.inc.php.orig 2012-03-30 14:38:32.096541376 +0200
+++ frontends/php/include/schema.inc.php 2012-03-30 14:38:08.566537692 +0200
@@ -2191,13 +2191,13 @@
'expression' => array(
'null' => false,
'type' => DB::FIELD_TYPE_CHAR,

  • 'length' => 255,
    + 'length' => 1024,
    'default' => '',
    ),
    'description' => array(
    'null' => false,
    'type' => DB::FIELD_TYPE_CHAR,
  • 'length' => 255,
    + 'length' => 1024,
    'default' => '',
    ),
    'url' => array(
    @@ -3682,7 +3682,7 @@
    'expression' => array(
    'null' => false,
    'type' => DB::FIELD_TYPE_CHAR,
  • 'length' => 255,
    + 'length' => 1024,
    'default' => '',
    ),
    'expression_type' => array(

— database/mysql/schema.sql.orig 2012-03-30 14:40:13.626523795 +0200
+++ database/mysql/schema.sql 2012-03-30 14:40:57.176529646 +0200
@@ -470,8 +470,8 @@
) ENGINE=InnoDB;
CREATE TABLE triggers (
triggerid bigint unsigned NOT NULL,

  • expression varchar(255) DEFAULT '' NOT NULL,
  • description varchar(255) DEFAULT '' NOT NULL,
    + expression varchar(1024) DEFAULT '' NOT NULL,
    + description varchar(1024) DEFAULT '' NOT NULL,
    url varchar(255) DEFAULT '' NOT NULL,
    status integer DEFAULT '0' NOT NULL,
    value integer DEFAULT '0' NOT NULL,
    @@ -816,7 +816,7 @@
    CREATE TABLE expressions (
    expressionid bigint unsigned NOT NULL,
    regexpid bigint unsigned NOT NULL,
  • expression varchar(255) DEFAULT '' NOT NULL,
    + expression varchar(1024) DEFAULT '' NOT NULL,
    expression_type integer DEFAULT '0' NOT NULL,
    exp_delimiter varchar(1) DEFAULT '' NOT NULL,
    case_sensitive integer DEFAULT '0' NOT NULL,
Comment by Volker Fröhlich [ 2012 Mar 30 ]

I agree with Simon, you could easily hit this limit:

Or with hysteresis or macros:

(

{TRIGGER.VALUE}=0 & {53249}>{$MAX_CURRENT_CONNECTIONS_ALARM}) | ({TRIGGER.VALUE}

=1 &

{53249}

>{$MAX_CURRENT_CONNECTIONS_RELIEF})

Or a complicated temporal constraint (which is ugly to define that way anyway):

{26061}

>90&

{26060}>050000&{26060}

<220000

I also can't see, why acknowledgement comments must be limited: https://support.zabbix.com/browse/ZBXNEXT-929

url and description on the triggers table aren't terribly large either.

Comment by Simon Kowallik [ 2012 Mar 30 ]

Does http://pastebin.com/XEx2099X work?

Comment by richlv [ 2012 Mar 30 ]

volker, your first example is 129 characters long, second is 41.
they should easily fit in 255 chars

Comment by Volker Fröhlich [ 2012 Mar 30 ]

That's right, and both of them are very simple. I just wanted to pinpoint some factors that can quickly produce a long trigger expression.

Comment by Simon Kowallik [ 2012 Mar 30 ]

{hostname.subdomain.example.com:Item_Name.2.3.12.1.2.["

{#SNMPINDEX}"].strlen(0)}<0|({hostname.subdomain.example.com:Item_Name.2.3.12.1.4.["{#SNMPINDEX}

"].str("Active",3600)}#1&{hostname.subdomain.example.com:Item_Name.2.3.12.1.4.["

{#SNMPINDEX}

"].str("Disconnected",3600)}#1)

for example. and this is also a very simple expression.

As Itemnames and Hostnames all count for the expression length, it is very easy to violate the 255 char limit with more complex expressions.
This is a major functionality limitation, in my opinion.

Comment by Simon Kowallik [ 2012 Mar 30 ]

Another example:
{hostname.subdomain.example.com:Item_Name.2.3.12.1.2.["

{#SNMPINDEX}"].strlen(0)}<0|{hostname.subdomain.example.com:Item_Name.2.3.12.1.4.["{#SNMPINDEX}

"].change(0)}=1&({hostname.subdomain.example.com:Item_Name.2.3.12.1.4.["

{#SNMPINDEX}"].str("Active")}=1|{hostname.subdomain.example.com:Item_Name.2.3.12.1.4.["{#SNMPINDEX}

"].str("Disconnected")}=1)

Comment by richlv [ 2012 Mar 30 ]

but these examples are not what is stored in the db, in the db functionids are used instead (like in volker's examples)
note that i'm not against longer expression field, just saying that it isn't such a huge of a problem

Comment by Simon Kowallik [ 2012 Mar 30 ]

richlv, ok.

But with 2.0.0rc3.x-26490 frontend I receive an error, when I try to assign a template with a trigger with this kind of expression.
The error is:
ERROR: Cannot update host
Value "'{hostname.subdomain.example.com:Item_Name.2.3.12.1.2.["

{#SNMPINDEX}"].strlen(0)}<0|{hostname.subdomain.example.com:Item_Name.2.3.12.1.4.["{#SNMPINDEX}

"].change(0)}=1&({hostname.subdomain.example.com:Item_Name.2.3.12.1.4.["

{#SNMPINDEX}"].str("Active")}=1|{hostname.subdomain.example.com:Item_Name.2.3.12.1.4.["{#SNMPINDEX}

"].str("Disconnected")}=1)'" is too long for field "expression" - 275 characters. Allowed length is 255 characters.

For me this is a huge problem.

Comment by Volker Fröhlich [ 2012 Jun 10 ]

Can we please re-open this?

Comment by richlv [ 2012 Jun 10 ]

looks like the latest example is actually about the trigger length, as actually recorded in the db, so a new zbxnext would probably be the best choice

Comment by Simon Kowallik [ 2012 Jun 11 ]

Hello Volker,

Maybe you can test the following Patch: https://gist.github.com/2908937
It is for 2.0.0 Stable, tested with MySQL and PostgreSQL backend.

Status: Works for me.

Comment by Arun Sasidhar [ 2012 Jul 03 ]

I have the same issue with latest Zabbix version.
I can't add trigger with more than 255 characters.

I have attached a screenshot of my error.

My Zabbix Version is : Zabbix server v2.0.1 (revision 28455) (27 June 2012)

and in MySQL schema file I can see

root@zabbix-serv6 mysql]# grep expression schema.sql
`expression` varchar(255) DEFAULT '' NOT NULL,
`expression` varchar(64) DEFAULT '' NOT NULL,
CREATE TABLE `expressions` (
`expressionid` bigint unsigned NOT NULL,
`expression` varchar(255) DEFAULT '' NOT NULL,
`expression_type` integer DEFAULT '0' NOT NULL,
PRIMARY KEY (expressionid)
CREATE INDEX `expressions_1` ON `expressions` (`regexpid`);
ALTER TABLE `expressions` ADD CONSTRAINT `c_expressions_1` FOREIGN KEY (`regexpid`) REFERENCES `regexps` (`regexpid`) ON DELETE CASCADE;





[ZBX-4298] No messages in the LEVEL_WARNING log about deleted values by housekeeper (table "housekeeper") Created: 2011 Oct 31  Updated: 2017 May 30  Resolved: 2011 Dec 19

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Server (S)
Affects Version/s: 1.8.8
Fix Version/s: 1.8.10, 1.8.11, 1.9.9 (beta)

Type: Incident report Priority: Minor
Reporter: Oleksii Zagorskyi Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: housekeeper
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

DebugLevel=3



 Description   

When zabbix_server works with the DebugLevel=3 it reports to the log this message:
"Deleted <NNN> records from history and trends"

But here are not included values deleted by housekeeper for the items already deleted from configuration (table "housekeeper").
1. This lack of information could confuse when troubleshooting of DB performance.
2. It's not consistent that the housekeeper is reporting count of the deleted outdated values but does not report count of values for items already deleted from configuration.

Try to imagine a situation when some user has performed "Unlink and clear" action with some big template linked to the several hosts and in the nearest hour he felt some problem with the DB performance and he thinks - what happened ?

Here is part of DebugLevel=4 (I added several EOL for better view):

15500:20111031:150250.029 End of housekeeping_history_and_trends():0

15500:20111031:150250.029 Deleted 0 records from history and trends

15500:20111031:150250.029 In housekeeping_process_log()
15500:20111031:150250.029 query [txnlev:0] [select housekeeperid,tablename,field,value from housekeeper order by table name]
15500:20111031:150250.029 query without transaction detected

15500:20111031:150250.029 query [txnlev:0] [delete from history where itemid=22578 limit 100]
15500:20111031:150250.044 deleted 100 records from table 'history'

15500:20111031:150250.044 query without transaction detected

15500:20111031:150250.044 query [txnlev:0] [delete from history_uint where itemid=22577 limit 100]
15500:20111031:150250.060 deleted 100 records from table 'history_uint'

15500:20111031:150250.060 End of housekeeping_process_log():SUCCEED
15500:20111031:150250.060 In housekeeping_events() now:1320062561
15500:20111031:150250.060 query [txnlev:0] [select event_history from config]
15500:20111031:150250.060 query [txnlev:0] [select eventid from events where clock<1288526561]
15500:20111031:150250.060 End of housekeeping_events():SUCCEED

15500:20111031:150250.060 In housekeeping_alerts() now:1320062561
15500:20111031:150250.060 query [txnlev:0] [select alert_history from config]
15500:20111031:150250.060 query without transaction detected
15500:20111031:150250.060 query [txnlev:0] [delete from alerts where clock<1288526561]
15500:20111031:150250.060 deleted 0 records from table 'alerts'
15500:20111031:150250.060 End of housekeeping_alerts():SUCCEED

15500:20111031:150250.060 In housekeeping_sessions() now:1320062561
15500:20111031:150250.060 query without transaction detected
15500:20111031:150250.060 query [txnlev:0] [delete from sessions where lastaccess<1288526561]
15500:20111031:150250.061 deleted 0 records from table 'sessions'
15500:20111031:150250.061 End of housekeeping_sessions():SUCCEED
15500:20111031:150250.061 sleeping for 3600 seconds

(in this example "MaxHousekeeperDelete=100")

As you see in the function "housekeeping_process_log()", where the values are deleted from the tables history, history_uint (and not only), no messages are added for the LOG_LEVEL_WARNING.

I ask to add these messages to log. Maybe individually per each table, maybe summarize history+trends, I don't know how is better.

If any such values were not deleted then needn't to report any messages.



 Comments   
Comment by Oleksii Zagorskyi [ 2011 Oct 31 ]

(1) By the way, the name of function "housekeeping_process_log()" seems is not optimal.

I suggest to change it to "housekeeping_process_deleted_items()" or similar.

<dimir> I chose housekeeping_cleanup(), RESOLVED in r23553

<zalex> Excellent ! CLOSED

Comment by dimir [ 2011 Nov 25 ]

Fixed in development branch svn://svn.zabbix.com/branches/dev/ZBX-4298

Comment by dimir [ 2011 Nov 25 ]

I've chosen "housekeeping_cleanup()", if nobody minds. So the report will look like this:

11921:20111125:180134.824 housekeeper deleted 0 records from history and trends, 28561 records of deleted items, 0 events, 0 alerts and 0 sessions

This will be logged on every housekeeper step even if nothing was removed. Agreed with sasha that this way there will will be no questions whether it actually was or not an attempt to delete the data.

Comment by Oleksii Zagorskyi [ 2011 Nov 27 ]

Dev branch tested. Works as expected. Single line for report is very-very good.

(2) I would suggest to write that line as:
housekeeper deleted: 0 records from history and trends, 28561 records of deleted items, 0 events, 0 alerts, 0 sessions
It seems for me it will be in more readable form.

<dimir> RESOLVED in r23560

<zalex> Many thanks. CLOSED.

Comment by dimir [ 2011 Nov 30 ]

Fixed in pre-1.8.10 r23632, pre-1.9.9 r23633.

Comment by Alexander Vladishev [ 2011 Nov 30 ]

(1) Broken compilation of the latest trunk.

housekeeper.c: In function ‘housekeeping_cleanup’:
housekeeper.c:135: error: ‘ids_alloc’ undeclared (first use in this function)
housekeeper.c:135: error: (Each undeclared identifier is reported only once
housekeeper.c:135: error: for each function it appears in.)
housekeeper.c:135: error: ‘ids_num’ undeclared (first use in this function)
housekeeper.c: In function ‘housekeeping_alerts’:
housekeeper.c:186: warning: ‘return’ with a value, in function returning void
housekeeper.c: In function ‘housekeeping_events’:
housekeeper.c:213: warning: ‘return’ with a value, in function returning void
housekeeper.c: In function ‘main_housekeeper_loop’:
housekeeper.c:328: error: void value not ignored as it ought to be
housekeeper.c:331: error: void value not ignored as it ought to be

<dimir> sorry for the broken trunk, RESOLVED in r23663 directly in trunk

<zalex> tested. trunk r23663 compiled ok and it works.

<sasha> CLOSED with small change in r23688.

Comment by richlv [ 2011 Nov 30 ]

(2) also :
what's the difference between "history and trends" and "records of deleted items" ? i assume the latter is not the amount of items, but the amount of history and trends values for those items ?

<dimir> "Old history and trends" is the outdated information (as configured in the item keep this and that), "records of deleted items" is all the data (basically what's in "housekeeper" table) related to removed item.

<zalex> maybe would be better to replace all words "records" to the "values"? It will be more clear.

<dimir> For me "deleted 2 values from history and trends" is not more clear than "deleted 2 records from hostory and trends". What I'd add is singular value support.

<dimir> if there are no objections, RESOLVED in r23681

<zalex> dev branch r23681 tested. it works (see 1 event):
"housekeeper deleted: 7056 records from history and trends, 0 records of deleted items, 1 event, 0 alerts, 0 sessions"
he-he, it's some "alternative" to gettext

<dimir> We decided to discard these changes as we don't have anything like it anywhere. CLOSED

Comment by dimir [ 2011 Dec 01 ]

Oleksiy, thank you for testing!

Comment by dimir [ 2011 Dec 01 ]

Fixed in trunk r23663.

Comment by richlv [ 2011 Dec 01 ]

(3) i suspect "d_clenup" is a typo

<dimir> Right, RESOLVED in pre-1.8.10 r23732, pre-1.9.9 r23733.
<sasha> CLOSED

Comment by Alexander Vladishev [ 2011 Dec 02 ]

Closing resolved issue

Comment by dimir [ 2011 Dec 02 ]

Reopening to assign to myself.

Comment by dimir [ 2011 Dec 02 ]

Closed.

Comment by richlv [ 2011 Dec 19 ]

48 deleted events reported as 1 in 1.8.10rc1

strace output :

event_strace.13938:write(6, "$\0\0\0\3delete from events where eventid=11", 40) = 40
event_strace.13938:write(6, "$\0\0\0\3delete from events where eventid=18", 40) = 40
event_strace.13938:write(6, "#\0\0\0\3delete from events where eventid=5", 39) = 39
event_strace.13938:write(6, "#\0\0\0\3delete from events where eventid=9", 39) = 39
event_strace.13938:write(6, "#\0\0\0\3delete from events where eventid=1", 39) = 39
event_strace.13938:write(6, "$\0\0\0\3delete from events where eventid=47", 40) = 40
event_strace.13938:write(6, "$\0\0\0\3delete from events where eventid=38", 40) = 40
event_strace.13938:write(6, "$\0\0\0\3delete from events where eventid=44", 40) = 40
event_strace.13938:write(6, "$\0\0\0\3delete from events where eventid=43", 40) = 40
event_strace.13938:write(6, "$\0\0\0\3delete from events where eventid=36", 40) = 40
event_strace.13938:write(6, "$\0\0\0\3delete from events where eventid=42", 40) = 40
event_strace.13938:write(6, "$\0\0\0\3delete from events where eventid=34", 40) = 40
event_strace.13938:write(6, "$\0\0\0\3delete from events where eventid=35", 40) = 40
event_strace.13938:write(6, "$\0\0\0\3delete from events where eventid=31", 40) = 40
event_strace.13938:write(6, "#\0\0\0\3delete from events where eventid=8", 39) = 39
event_strace.13938:write(6, "$\0\0\0\3delete from events where eventid=30", 40) = 40
event_strace.13938:write(6, "$\0\0\0\3delete from events where eventid=40", 40) = 40
event_strace.13938:write(6, "$\0\0\0\3delete from events where eventid=37", 40) = 40
event_strace.13938:write(6, "$\0\0\0\3delete from events where eventid=13", 40) = 40
event_strace.13938:write(6, "$\0\0\0\3delete from events where eventid=39", 40) = 40
event_strace.13938:write(6, "$\0\0\0\3delete from events where eventid=33", 40) = 40
event_strace.13938:write(6, "$\0\0\0\3delete from events where eventid=46", 40) = 40
event_strace.13938:write(6, "$\0\0\0\3delete from events where eventid=29", 40) = 40
event_strace.13938:write(6, "$\0\0\0\3delete from events where eventid=48", 40) = 40
event_strace.13938:write(6, "$\0\0\0\3delete from events where eventid=41", 40) = 40
event_strace.13938:write(6, "$\0\0\0\3delete from events where eventid=14", 40) = 40
event_strace.13938:write(6, "$\0\0\0\3delete from events where eventid=32", 40) = 40
event_strace.13938:write(6, "$\0\0\0\3delete from events where eventid=10", 40) = 40
event_strace.13938:write(6, "$\0\0\0\3delete from events where eventid=27", 40) = 40
event_strace.13938:write(6, "#\0\0\0\3delete from events where eventid=6", 39) = 39
event_strace.13938:write(6, "#\0\0\0\3delete from events where eventid=7", 39) = 39
event_strace.13938:write(6, "$\0\0\0\3delete from events where eventid=12", 40) = 40
event_strace.13938:write(6, "$\0\0\0\3delete from events where eventid=26", 40) = 40
event_strace.13938:write(6, "$\0\0\0\3delete from events where eventid=45", 40) = 40
event_strace.13938:write(6, "$\0\0\0\3delete from events where eventid=24", 40) = 40
event_strace.13938:write(6, "$\0\0\0\3delete from events where eventid=25", 40) = 40
event_strace.13938:write(6, "$\0\0\0\3delete from events where eventid=17", 40) = 40
event_strace.13938:write(6, "#\0\0\0\3delete from events where eventid=2", 39) = 39
event_strace.13938:write(6, "#\0\0\0\3delete from events where eventid=3", 39) = 39
event_strace.13938:write(6, "#\0\0\0\3delete from events where eventid=4", 39) = 39
event_strace.13938:write(6, "$\0\0\0\3delete from events where eventid=15", 40) = 40
event_strace.13938:write(6, "$\0\0\0\3delete from events where eventid=16", 40) = 40
event_strace.13938:write(6, "$\0\0\0\3delete from events where eventid=20", 40) = 40
event_strace.13938:write(6, "$\0\0\0\3delete from events where eventid=21", 40) = 40
event_strace.13938:write(6, "$\0\0\0\3delete from events where eventid=22", 40) = 40
event_strace.13938:write(6, "$\0\0\0\3delete from events where eventid=23", 40) = 40
event_strace.13938:write(6, "$\0\0\0\3delete from events where eventid=19", 40) = 40
event_strace.13938:write(6, "$\0\0\0\3delete from events where eventid=28", 40) = 40
event_strace.13938:write(7, " 13938:20111217:175347.261 housekeeper deleted: 0 records from history and trends, 0 records of deleted items, 1 events, 0 alerts, 0 sessions\n", 142) = 142

Comment by Alexander Vladishev [ 2011 Dec 19 ]

Fixed in the development branch svn://svn.zabbix.com/branches/dev/ZBX-4298

Comment by dimir [ 2011 Dec 19 ]

Tested successfully.

Comment by Alexander Vladishev [ 2011 Dec 28 ]

Available in version pre-1.8.11, r24309.





[ZBX-4281] Search group with templates Created: 2011 Oct 26  Updated: 2017 May 30  Resolved: 2012 Jul 10

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 1.9.7 (beta)
Fix Version/s: 1.9.9 (beta), 2.0.2rc1, 2.1.0

Type: Incident report Priority: Minor
Reporter: Alexey Pustovalov Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified


 Description   

if search group with templates only, link 'Edit hosts' go to edit hosts not edit templates.



 Comments   
Comment by Alexey Fukalov [ 2012 Jul 06 ]

dev branch: svn://svn.zabbix.com/branches/dev/ZBX-4281

Comment by Pavels Jelisejevs (Inactive) [ 2012 Jul 09 ]

TESTED.

Comment by Alexey Fukalov [ 2012 Jul 10 ]

Fixed in pre-2.0.2rc1 r28777, pre-2.1.0rc1 r28778

Comment by richlv [ 2012 Jul 13 ]

for the record, the fix was to split up host & template editing links





[ZBX-4277] First and another errors about snmp Created: 2011 Oct 26  Updated: 2018 Feb 09  Resolved: 2012 Jul 28

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Proxy (P), Server (S)
Affects Version/s: 1.9.7 (beta)
Fix Version/s: 1.9.9 (beta)

Type: Incident report Priority: Critical
Reporter: Alexey Pustovalov Assignee: Unassigned
Resolution: Won't fix Votes: 0
Labels: snmp
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

lastest rev 22669



 Description   

i have errors in log zabbix proxy and server:
dotneft # tail -f /var/log/zabbix/zabbix_proxy.log | grep c2r3ups01.test.ru
14513:20111026:152804.038 SNMP item [apc.BatteryTemperature] on host [c2r3ups01.test.ru] failed: another network error, wait for 15 seconds
14513:20111026:152824.153 temporarily disabling SNMP checks on host [c2r3ups01.test.ru]: host unavailable
14510:20111026:152924.166 enabling SNMP checks on host [c2r3ups01.test.ru]: host became available

but i don't see in tcpdump queries:
zabbix-trunk # tcpdump -np host 10.100.52.8
tcpdump: verbose output suppressed, use -v or -vv for full protocol decode
listening on eth0, link-type EN10MB (Ethernet), capture size 96 bytes
15:25:12.276711 IP 10.100.11.45.44628 > 10.100.52.8.161: C=public GetRequest(36) .1.3.6.1.4.1.318.1.1.10.2.3.2.1.4[|snmp]
15:25:12.325343 IP 10.100.52.8.161 > 10.100.11.45.44628: C=public GetResponse(41) .1.3.6.1.4.1.318[|snmp]
15:25:49.613001 arp who-has 10.100.52.1 tell 10.100.52.8
15:27:03.381601 IP 10.100.11.45.46681 > 10.100.52.8.161: C=public GetRequest(34) .1.3.6.1.4.1.318.1.1.1.4.2.4.0[|snmp]
15:27:03.416751 IP 10.100.52.8.161 > 10.100.11.45.46681: C=public GetResponse(39) .1.3.6.1.4.1.318[|snmp]
15:27:04.407535 IP 10.100.11.45.59624 > 10.100.52.8.161: C=public GetRequest(34) .1.3.6.1.4.1.318.1.1.1.7.2.6.0[|snmp]
15:27:04.445123 IP 10.100.52.8.161 > 10.100.11.45.59624: C=public GetResponse(39) .1.3.6.1.4.1.318[|snmp]
15:27:12.534674 IP 10.100.11.45.33600 > 10.100.52.8.161: C=public GetRequest(34) .1.3.6.1.4.1.318.1.1.1.2.2.8.0[|snmp]
15:27:12.572059 IP 10.100.52.8.161 > 10.100.11.45.33600: C=public GetResponse(39) .1.3.6.1.4.1.318[|snmp]
15:27:13.549699 IP 10.100.11.45.36081 > 10.100.52.8.161: C=public GetRequest(34) .1.3.6.1.4.1.318.1.1.1.2.2.1.0[|snmp]
15:27:13.582344 IP 10.100.52.8.161 > 10.100.11.45.36081: C=public GetResponse(39) .1.3.6.1.4.1.318[|snmp]
15:27:14.576940 IP 10.100.11.45.49594 > 10.100.52.8.161: C=public GetRequest(34) .1.3.6.1.4.1.318.1.1.1.2.2.3.0[|snmp]
15:27:14.610833 IP 10.100.52.8.161 > 10.100.11.45.49594: C=public GetResponse(41) .1.3.6.1.4.1.318[|snmp]
15:27:16.609383 IP 10.100.11.45.44065 > 10.100.52.8.161: C=public GetRequest(34) .1.3.6.1.4.1.318.1.1.1.3.2.4.0[|snmp]
15:27:16.643131 IP 10.100.52.8.161 > 10.100.11.45.44065: C=public GetResponse(39) .1.3.6.1.4.1.318[|snmp]
15:27:17.645861 IP 10.100.11.45.41856 > 10.100.52.8.161: C=public GetRequest(34) .1.3.6.1.4.1.318.1.1.1.3.2.1.0[|snmp]
15:27:17.681825 IP 10.100.52.8.161 > 10.100.11.45.41856: C=public GetResponse(40) .1.3.6.1.4.1.318[|snmp]
15:27:20.701552 IP 10.100.11.45.50608 > 10.100.52.8.161: C=public GetRequest(34) .1.3.6.1.4.1.318.1.1.1.4.1.1.0[|snmp]
15:27:20.739801 IP 10.100.52.8.161 > 10.100.11.45.50608: C=public GetResponse(39) .1.3.6.1.4.1.318[|snmp]
15:27:28.021190 IP 10.100.11.45 > 10.100.52.8: ICMP echo request, id 14907, seq 0, length 76
15:27:28.024483 IP 10.100.52.8 > 10.100.11.45: ICMP echo reply, id 14907, seq 0, length 76
15:27:29.023347 IP 10.100.11.45 > 10.100.52.8: ICMP echo request, id 14907, seq 1, length 76
15:27:29.026740 IP 10.100.52.8 > 10.100.11.45: ICMP echo reply, id 14907, seq 1, length 76
15:27:30.023728 IP 10.100.11.45 > 10.100.52.8: ICMP echo request, id 14907, seq 2, length 76
15:27:30.034321 IP 10.100.52.8 > 10.100.11.45: ICMP echo reply, id 14907, seq 2, length 76
15:29:24.123489 IP 10.100.11.45.36498 > 10.100.52.8.161: C=public GetRequest(34) .1.3.6.1.4.1.318.1.1.1.7.2.3.0[|snmp]
15:29:24.165822 IP 10.100.52.8.161 > 10.100.11.45.36498: C=public GetResponse(39) .1.3.6.1.4.1.318[|snmp]

apc.BatteryTemperature have oid .1.3.6.1.4.1.318.1.1.1.2.2.2.0



 Comments   
Comment by richlv [ 2011 Oct 26 ]

please, attach a screenshot of item configuration. also, you could try snmpget for the oid exactly as it's specified in the item configuration

Comment by Alexey Pustovalov [ 2011 Oct 26 ]

time snmpget -v2c -c public c2r3ups01.88.ru .1.3.6.1.4.1.318.1.1.1.2.2.2.0
SNMPv2-SMI::enterprises.318.1.1.1.2.2.2.0 = Gauge32: 21

real 0m0.051s
user 0m0.028s
sys 0m0.000s
dotneft ~ $ time snmpget -v2c -c public c2r3ups01.88.ru .1.3.6.1.4.1.318.1.1.1.2.2.2.0
SNMPv2-SMI::enterprises.318.1.1.1.2.2.2.0 = Gauge32: 21

real 0m0.050s
user 0m0.024s
sys 0m0.000s
dotneft ~ $ time snmpget -v2c -c public c2r3ups01.88.ru .1.3.6.1.4.1.318.1.1.1.2.2.2.0
SNMPv2-SMI::enterprises.318.1.1.1.2.2.2.0 = Gauge32: 21

real 0m0.051s
user 0m0.020s
sys 0m0.000s
dotneft ~ $ time snmpget -v2c -c public c2r3ups01.88.ru .1.3.6.1.4.1.318.1.1.1.2.2.2.0
SNMPv2-SMI::enterprises.318.1.1.1.2.2.2.0 = Gauge32: 21

real 0m0.050s
user 0m0.020s
sys 0m0.004s

Comment by Alexey Pustovalov [ 2011 Oct 26 ]

item settings

Comment by Alexey Pustovalov [ 2011 Oct 27 ]

we checking then the problem and found following relationships:
1. often troubles with snmp was with hosts (checking by ip) without/incorrect A or PTR DNS records.
2. after we resolve A and PTR DNS records, another and first errors disappeared from logs

But the problem remains, how affected by the availability of DNS records for hosts with check by ip?

Comment by Alexei Vladishev [ 2011 Nov 17 ]

Perhaps SNMP device relies on availability of DNS somehow, say for security checks, audits, something else?

Comment by Alexey Pustovalov [ 2011 Nov 17 ]

maybe. I think net-snmp have internal checks,audit... etc.
messages about errors missing from zabbix log after DNS records ordering.

Comment by Alexey Pustovalov [ 2012 Jul 28 ]

I think we can close the issue.





[ZBX-4262] can't select item prototypes for graph y axis min/max Created: 2011 Oct 21  Updated: 2017 May 30  Resolved: 2011 Dec 05

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F), Server (S)
Affects Version/s: None
Fix Version/s: 1.9.9 (beta), 2.0.0

Type: Incident report Priority: Blocker
Reporter: richlv Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: graphs, lld, trivial
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: Text File r23752-mysqldump.txt     File r23752-objdump.txt.gz     File r23752-zabbix-server.log    

 Description   

create a graph prototype on an lld rule. try to select an item prototype for y axis min/max - that is not available. this makes creating graphs like "used diskspace projected on a graph going from 0 to total diskspace" impossible



 Comments   
Comment by Pavels Jelisejevs (Inactive) [ 2011 Nov 21 ]

GUI RESOLVED.

Comment by dimir [ 2011 Dec 02 ]

(2) Crash in unreachable poller when processing discovery rule. Attached files:

r23752-mysqldump.txt
r23752-objdump.txt
r23752-zabbix-server.log

Steps to reproduce:
1) create template "lld" in a new group "lld"
2) create discovery rule "vfs.fs.discovery" in that template
3) create 2 item prototypes for the rule:
vfs.fs.size[

{#FSNAME},free]
vfs.fs.size[{#FSNAME}

,total]
4) create a graph prototype for the rule:

  • use "free" prototype as an item for the graph
  • use "total" prototype as "Y axis MAX value"
    5) link enabled host to "lld" template
    6) restart zabbix server and agent
    7) observe zabbix_server.log file for a crash

Frequency: 2/2 (the second time from clean database).

<sasha> Thanks for objdump! RESLOVED

<dimir> Perfect! CLOSED

Comment by dimir [ 2011 Dec 05 ]

Tested successfully.

Comment by Alexander Vladishev [ 2011 Dec 05 ]

Available in version pre 1.9.9, revision 23781.





[ZBX-4260] Query slow with large events table Created: 2011 Oct 20  Updated: 2017 May 30  Resolved: 2011 Dec 08

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 1.9.6 (beta)
Fix Version/s: 1.9.9 (beta)

Type: Incident report Priority: Blocker
Reporter: Corey Shaw Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: dashboard, database, performance
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

RHEL5
16 CPU
64 GB RAM

Number of hosts (monitored/not monitored/templates) 342 310 / 0 / 32
Number of items (monitored/disabled/not supported) 17793 16823 / 181 / 789
Number of triggers (enabled/disabled)[problem/unknown/ok] 5447 5375 / 72 [146 / 42 / 5187]



 Description   

I started noticing today that the zabbix dashboard was loading slowly. In particular, the system status section took 10+ seconds to finish loading. During the loading I did a "SHOW processlist" in MySQL and found that queries like this one were running:

SELECT e.* FROM EVENTS e
WHERE (e.objectid IN ('16007'))
AND ((e.objectid BETWEEN 000000000000000 AND 099999999999999))
AND (e.object-0)=0 AND ( (e.value IN ('1'))
AND (e.value_changed IN ('1')) )
ORDER BY e.clock DESC,e.ns DESC LIMIT 1 OFFSET 0

I then ran an explain on it and found that there was no index being used. My "events" table has 199.11k rows in it. Since the query had to do a table scan, it was very slow to run.

After creating an index on the "objectid" column with the query below, the queries were MUCH faster. The "system status" section now loads up in about 2-3 seconds.
ALTER TABLE `zabbix`.`events` ADD INDEX `events_3` (`objectid`);



 Comments   
Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 05 ]

RESOLVED in svn://svn.zabbix.com/branches/dev/ZBX-4260

Comment by Oleksii Zagorskyi [ 2011 Dec 07 ]

Interesting, could this improvement help for the ZBX-4357 too?

<zalex> ok, suggested index has not been added. No luck.
CLOSED

<pavels> Noup, this fix only improves queries that use sorting by the "clock" column. The events table can be considerably large and adding more indexes may not be a good idea. ZBX-4357 will require a different fix.

Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 08 ]

Merged to trunk r23867.

CLOSED.





[ZBX-4235] Graph axis labels incorrect in localized GUI Created: 2011 Oct 14  Updated: 2017 May 30  Resolved: 2011 Nov 25

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 1.8.9, 1.9.7 (beta)
Fix Version/s: 1.8.10, 1.9.9 (beta)

Type: Incident report Priority: Blocker
Reporter: Jens Berthold Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: graphs
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Debian 6, MySQL


Attachments: JPEG File latest-data-english.jpg     JPEG File latest-data-german.jpg     PNG File zabbix_english.png     PNG File zabbix_german.png    
Issue Links:
Duplicate
duplicates ZBX-2582 division by zero when browsing latest... Closed

 Description   

With german localization, axis labels show zero instead of numbers, or show too much decimals with percent values.
Please see attachments for comparison between correct english version and faulty german version. (No changes between screenshots ecxept for changing language)



 Comments   
Comment by Oleksii Zagorskyi [ 2011 Oct 14 ]

I can confirm the same in Ukrainian and Russian locales in the latest trunk rev 22380.

Comment by Alexey Fukalov [ 2011 Nov 15 ]

Cannot reproduce this problem with default graphs from "Linux template", does this problem occur on all graphs or only specific ones?

<pavels> Can't reproduce it too.

<zalex> Still can reproduce in the rev 23335. Any idea how to check the differences in our systems?

<richlv> php versions, gd versions ?
on the second thought, gd version shouldn't matter

Comment by richlv [ 2011 Nov 22 ]

for the record, can't reproduce in trunk rev 23404.
php 5.3.3 and 5.3.5
tried both simple & custom graphs with ukrainian and german locales.
tried custom graphs with multiple items on same axis, with two axis.

just a quick idea, have mo files been remade recently ?

Comment by Oleksii Zagorskyi [ 2011 Nov 22 ]

Reproducible as mentioned above:

  1. uname -a
    Linux it0 2.6.32-5-amd64 #1 SMP Mon Oct 3 03:59:20 UTC 2011 x86_64 GNU/Linux
  1. cat /etc/debian_version
    6.0.3
  1. dpkg -l | grep php
    ii libapache2-mod-php5 5.3.3-7+squeeze3 server-side, HTML-embedded scripting language (Apache 2 module)
    ii php5 5.3.3-7+squeeze3 server-side, HTML-embedded scripting language (metapackage)
    ii php5-cli 5.3.3-7+squeeze3 command-line interpreter for the php5 scripting language
    ii php5-common 5.3.3-7+squeeze3 Common files for packages built from the php5 source
    ii php5-gd 5.3.3-7+squeeze3 GD module for php5
    ii php5-mcrypt 5.3.3-7+squeeze3 MCrypt module for php5
    ii php5-mysql 5.3.3-7+squeeze3 MySQL module for php5
    ii php5-pgsql 5.3.3-7+squeeze3 PostgreSQL module for php5
    ii php5-suhosin 0.9.32.1-1 advanced protection module for php5
  1. locale
    LANG=en_GB.UTF-8
    LC_CTYPE="en_GB.UTF-8"
    LC_NUMERIC="en_GB.UTF-8"
    LC_TIME="en_GB.UTF-8"
    LC_COLLATE="en_GB.UTF-8"
    LC_MONETARY="en_GB.UTF-8"
    LC_MESSAGES="en_GB.UTF-8"
    LC_PAPER="en_GB.UTF-8"
    LC_NAME="en_GB.UTF-8"
    LC_ADDRESS="en_GB.UTF-8"
    LC_TELEPHONE="en_GB.UTF-8"
    LC_MEASUREMENT="en_GB.UTF-8"
    LC_IDENTIFICATION="en_GB.UTF-8"
    LC_ALL=
  1. locale -a
    C
    en_GB.utf8
    POSIX
    ru_RU.utf8
    uk_UA.utf8

The problem ***NOT*** reproducible on:

  1. uname -a
    FreeBSD 8.1-RELEASE FreeBSD 8.1-RELEASE #0: Mon Jul 19 02:55:53 UTC 2010
  1. pkg_info | grep php
    php5-5.3.6_1 PHP Scripting Language
    php5-bcmath-5.3.6_1 The bcmath shared extension for php
    php5-ctype-5.3.6_1 The ctype shared extension for php
    php5-dom-5.3.6_1 The dom shared extension for php
    php5-gd-5.3.6_1 The gd shared extension for php
    php5-gettext-5.3.6_1 The gettext shared extension for php
    php5-mbstring-5.3.6_1 The mbstring shared extension for php
    php5-mysql-5.3.6_1 The mysql shared extension for php
    php5-session-5.3.6_1 The session shared extension for php
    php5-snmp-5.3.6_1 The snmp shared extension for php
    php5-sockets-5.3.6_1 The sockets shared extension for php
    php5-xml-5.3.6_1 The xml shared extension for php
    php5-xmlreader-5.3.6_1 The xmlreader shared extension for php
    php5-xmlwriter-5.3.6_1 The xmlwriter shared extension for php
  1. locale
    LANG=uk_UA.UTF-8
    LC_CTYPE="uk_UA.UTF-8"
    LC_COLLATE="uk_UA.UTF-8"
    LC_TIME="uk_UA.UTF-8"
    LC_NUMERIC="uk_UA.UTF-8"
    LC_MONETARY="uk_UA.UTF-8"
    LC_MESSAGES="uk_UA.UTF-8"
    LC_ALL=
  1. locale -a | wc -l
    172
  1. locale -a | grep en_GB
    en_GB.ISO8859-1
    en_GB.ISO8859-15
    en_GB.US-ASCII
    en_GB.UTF-8
Comment by Jens Berthold [ 2011 Nov 22 ]

Could it have something to do with Suhosin patch?

Reproducible on:

  1. uname -a
    Linux sl04121 2.6.32-5-686 #1 SMP Fri Sep 9 20:51:05 UTC 2011 i686 GNU/Linux
  1. cat /etc/debian_version
    6.0.2
  1. dpkg -l | grep php
    ii libapache2-mod-php5 5.3.3-7+squeeze3 server-side, HTML-embedded scripting language (Apache 2 module)
    ii php5-cli 5.3.3-7+squeeze3 command-line interpreter for the php5 scripting language
    ii php5-common 5.3.3-7+squeeze3 Common files for packages built from the php5 source
    ii php5-gd 5.3.3-7+squeeze3 GD module for php5
    ii php5-mysql 5.3.3-7+squeeze3 MySQL module for php5
    ii php5-suhosin 0.9.32.1-1 advanced protection module for php5
  1. locale
    LANG=de_DE.UTF-8
    LC_CTYPE="de_DE.UTF-8"
    LC_NUMERIC="de_DE.UTF-8"
    LC_TIME="de_DE.UTF-8"
    LC_COLLATE="de_DE.UTF-8"
    LC_MONETARY="de_DE.UTF-8"
    LC_MESSAGES="de_DE.UTF-8"
    LC_PAPER="de_DE.UTF-8"
    LC_NAME="de_DE.UTF-8"
    LC_ADDRESS="de_DE.UTF-8"
    LC_TELEPHONE="de_DE.UTF-8"
    LC_MEASUREMENT="de_DE.UTF-8"
    LC_IDENTIFICATION="de_DE.UTF-8"
    LC_ALL=
  1. locale -a
    C
    de_DE.utf8
    en_GB.utf8
    POSIX
Comment by richlv [ 2011 Nov 22 ]

suhosin might be easy to test - uninstalling/disabling it & trying again should reveal that

Comment by Jens Berthold [ 2011 Nov 23 ]

Right
I tested it - no difference. So it's not related to suhosin.

Comment by Jens Berthold [ 2011 Nov 23 ]

Same error seems to be with latest data. I attached two more images with that view.
Maybe there is a hint where to look for the error (latest-data-german.jpg) - include/func.inc.php:499.

Comment by Oleksii Zagorskyi [ 2011 Nov 23 ]

I can confirm the same problems for latest data page as Jens mentioned.
But without php errors.

Comment by Oleksii Zagorskyi [ 2011 Nov 23 ]

Not reproducible (trunk r 23438):

  1. cat /etc/redhat-release
    CentOS release 5.5 (Final)
  1. rpm -qa | grep php
    php-mbstring-5.3.5-1.el5.remi.1
    php-cli-5.3.5-1.el5.remi.1
    php-xml-5.3.5-1.el5.remi.1
    php-pdo-5.3.5-1.el5.remi.1
    php-ldap-5.3.5-1.el5.remi.1
    php-mysql-5.3.5-1.el5.remi.1
    php-common-5.3.5-1.el5.remi.1
    php-sqlite-5.3.5-1.el5.remi.1
    php-snmp-5.3.5-1.el5.remi.1
    php-5.3.5-1.el5.remi.1
    php-gd-5.3.5-1.el5.remi.1
    php-mcrypt-5.3.5-1.el5.remi.1
    php-bcmath-5.3.5-1.el5.remi.1
  1. locale
    LANG=en_US.UTF-8
    LC_CTYPE="en_US.UTF-8"
    LC_NUMERIC="en_US.UTF-8"
    LC_TIME="en_US.UTF-8"
    LC_COLLATE="en_US.UTF-8"
    LC_MONETARY="en_US.UTF-8"
    LC_MESSAGES="en_US.UTF-8"
    LC_PAPER="en_US.UTF-8"
    LC_NAME="en_US.UTF-8"
    LC_ADDRESS="en_US.UTF-8"
    LC_TELEPHONE="en_US.UTF-8"
    LC_MEASUREMENT="en_US.UTF-8"
    LC_IDENTIFICATION="en_US.UTF-8"
    LC_ALL=
  1. locale -a | wc -l
    650
  1. locale -a | grep en_GB
    en_GB
    en_GB.iso88591
    en_GB.iso885915
    en_GB.utf8
Comment by Oleksii Zagorskyi [ 2011 Nov 23 ]

On Debian 6.0.3 (mentioned above) the problem is still reproducible after replacing "php5 5.3.3-7+squeeze3" to the "php5 5.3.8.0-1"

Comment by Alexey Fukalov [ 2011 Nov 23 ]

Does systems where error is reproducible has bcmath extensions for php? And are all required extensions installed (passed requirements test during installation)?

<zalex> On Debian 6.0.3 I have installed libapache2-mod-php5 ->
Description: The following extensions are built in: bcmath bz2 calendar Core ctype date dba dom ereg exif fileinfo filter ftp gettext hash iconv json libxml mbstring mhash openssl pcre Phar posix Reflection session shmop SimpleXML soap sockets SPL standard sysvmsg sysvsem sysvshm tokenizer wddx xml xmlreader xmlwriter zip zlib.
Of course during installation no any errors.

Comment by Aleksandrs Saveljevs [ 2011 Nov 24 ]

This looks similar to ZBX-2582, but I have not reproduced it so far using the scenario with Trac mentioned in that issue.

Comment by Pavels Jelisejevs (Inactive) [ 2011 Nov 24 ]

Zabbix uses the "en" locale for LC_NUMERIC, it seems it doesn't work on some of these machines. Is it possible that there is no "en" locale available? Could you run "locale -a"?

<zalex> output for all mentioned OS added. see comments above.

Comment by Oleksii Zagorskyi [ 2011 Nov 25 ]

What you say about these lines:

  1. grep -r LC_NUMERIC *
    include/views/administration.users.edit.php:setLocale(LC_NUMERIC, array('en', 'en_US', 'en_US.UTF-8', 'English_United States.1252')); // numeric Locale to default
    include/config.inc.php: setLocale(LC_NUMERIC, array('en', 'en_US', 'en_US.UTF-8', 'English_United States.1252'));
    jsLoader.php: setLocale(LC_NUMERIC, array('en', 'en_US', 'en_US.UTF-8', 'English_United States.1252'));

I'm and Jens we both had only "en_GB" locale installed but not the "en_US".
When I installed "en_US" locale the problem is gone!

In the Debian it's command "dpkg-reconfigure locales"
Apache has to be restarted to apply installed locales: service apache2 restart

Pavels, you know what to do next.
Thanks.

<pavels> Yeah, sorry, I forgot to mention, that we currently use en_US.

Comment by Pavels Jelisejevs (Inactive) [ 2011 Nov 25 ]

Please review the fix for 1.8 in branches/dev/ZBX-4235 and for the trunk in branches/dev/ZBX-4235-trunk.

RESOLVED.

Comment by Oleksii Zagorskyi [ 2011 Nov 25 ]

Note:
(1) If I removed both locales "en_GB" and "en_US" and restart apache, zabbix frontend still works correctly in English GUI.
But no any errors, warnings, etc to user that default locales are missing. Maybe it's ok and maybe not. It's up to you.
Tested Debian 6.0.3

<pavels> Then their default local must use periods as decimal points. I have an idea how to fix it without depending on locales, I'll give it a try Monday.

Comment by Oleksii Zagorskyi [ 2011 Nov 25 ]

Dev branch (for trunk) tester. Works as expected for non-english GUI with installed only one locale of "en_GB" or "en_US".
Thanks.

Comment by Pavels Jelisejevs (Inactive) [ 2011 Nov 28 ]

I've added the POSIX locale as an alternative LC_NUMERIC locale. It should be supported on all *nix systems and it also uses a dot as a decimal separator.

Comment by Pavels Jelisejevs (Inactive) [ 2011 Nov 30 ]

Merged to trunk revision r23618 and branches/1.8 revision r23615.

CLOSED.





[ZBX-4192] pre-zabbix-1.9.7.x-22074.tar.gz - compiling problems Created: 2011 Oct 01  Updated: 2017 May 30  Resolved: 2012 Feb 21

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Installation (I)
Affects Version/s: 1.9.7 (beta), 2.0.0
Fix Version/s: 1.9.9 (beta)

Type: Incident report Priority: Critical
Reporter: Eugene Istomin Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: building, rpm
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

build.opensuse.org



 Description   

http://www.zabbix.com/downloads/nightly/pre-zabbix-1.9.7.x-22074.tar.gz

/usr/lib64/gcc/x86_64-suse-linux/4.6/../../../../x86_64-suse-linux/bin/ld: ../../src/libs/zbxsysinfo/simple/libsimplesysinfo.a(simple.o): undefined reference to symbol 'ber_free'
/usr/lib64/gcc/x86_64-suse-linux/4.6/../../../../x86_64-suse-linux/bin/ld: note: 'ber_free' is defined in DSO /usr/lib64/gcc/x86_64-suse-linux/4.6/../../../../lib64/liblber.so so try adding it to the linker command line
/usr/lib64/gcc/x86_64-suse-linux/4.6/../../../../lib64/liblber.so: could not read symbols: Invalid operation
collect2: ld returned 1 exit status
make[2]: *** [zabbix_agent] Error 1
make[2]: *** Waiting for unfinished jobs....
mv -f .deps/zabbix_agentd-logfiles.Tpo .deps/zabbix_agentd-logfiles.Po

Full rpm make log:
https://build.opensuse.org/package/rawlog?arch=x86_64&package=zabbix2&project=home%3Aedssvirt&repository=openSUSE_Factory



 Comments   
Comment by richlv [ 2011 Oct 01 ]

might be related to ZBX-494

policy change (for fedora, though) :
https://fedoraproject.org/wiki/Features/ChangeInImplicitDSOLinking
https://fedoraproject.org/wiki/UnderstandingDSOLinkChange

Comment by Aleksandrs Saveljevs [ 2011 Nov 09 ]

Might be related to ZBX-3898 - the reported bug in Debian also mentions reference to 'ber_free' being undefined.

Comment by Seh Hui "Felix" Leong [ 2011 Nov 16 ]

The patch in ZBX-3898 does solve the compilation problem (after the patch is being adapted to the changes made in 1.9.*).

Comment by Alexei Vladishev [ 2012 Feb 18 ]

I believe it has been fixed in ZBX-4535 for pre-2.0. Please confirm.

Comment by Eugene Istomin [ 2012 Feb 21 ]

Yea, this issue has been fixed in last 1.9.9
Thanks

Comment by Eugene Istomin [ 2012 Feb 21 ]

Yea, this issue has been fixed in last 1.9.9
Thanks





[ZBX-4106] layout of "status of triggers" screen element broken Created: 2011 Sep 03  Updated: 2017 May 30  Resolved: 2012 Jan 30

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: None
Fix Version/s: 1.9.9 (beta)

Type: Incident report Priority: Blocker
Reporter: richlv Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: screens, trivial
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: PNG File status_of_triggers.png     PNG File status_of_triggers_narrow.png    

 Description   

see the screenshot. layout of screen elements "status of host/host group elements" is totally broken



 Comments   
Comment by Alexey Fukalov [ 2011 Sep 28 ]

svn://svn.zabbix.com/branches/dev/ZBX-4106

Comment by Alexey Fukalov [ 2011 Sep 29 ]

svn://svn.zabbix.com/trunk 22064

Comment by richlv [ 2012 Jan 27 ]

(2) turns out it's still not good - if a screen is wide enough and "status of triggers" ends up being narrow, we get ugly wrapping

https://support.zabbix.com/secure/attachment/17892/status_of_triggers_narrow.png

<Sasha> I confirm in IE9, Firefox and Opera. Chrome work fine.

Comment by Alexey Fukalov [ 2012 Jan 30 ]

dev branch: svn://svn.zabbix.com/branches/dev/ZBX-4106

Comment by Alexander Vladishev [ 2012 Jan 30 ]

Successfully tested!

Tested with Chrome, IE9, Opera and Firefox.

Comment by Alexey Fukalov [ 2012 Jan 30 ]

svn://svn.zabbix.com/trunk 25081





[ZBX-4073] proxy accepts parameters it does not use Created: 2011 Aug 25  Updated: 2017 May 30  Resolved: 2012 Jan 06

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Proxy (P)
Affects Version/s: 1.8.7rc1
Fix Version/s: 1.8.11, 1.9.9 (beta)

Type: Incident report Priority: Trivial
Reporter: richlv Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: proxy, usability
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified


 Description   

zabbix proxy seems to accept a few configuration parameters it does not use, notably TrendCacheSize and StartHTTPPollers
. there might be others, for example, i'm not fully sure about CacheUpdateFrequency

additionally, housekeeper/housekeeper.c in proxy claims that " * Purpose: remove outdated information from history and trends", which also seems to be slightly incorrect



 Comments   
Comment by Alexander Vladishev [ 2012 Jan 06 ]

Updated documentation:
http://www.zabbix.com/documentation/1.8/manual/processes/zabbix_proxy?&#configuration_file
http://www.zabbix.com/documentation/2.0/manual/appendix/config/zabbix_proxy

Comment by Alexander Vladishev [ 2012 Jan 06 ]

Fixed in the development branches:
svn://svn.zabbix.com/branches/dev/ZBX-4073
svn://svn.zabbix.com/branches/dev/ZBX-4073-TRUNK

Comment by dimir [ 2012 Jan 10 ]

Tested, please review my changes in r24630 and r24631. Feel free to argue about those.

Great! CLOSED

Comment by Alexander Vladishev [ 2012 Jan 11 ]

Fixed in version pre-1.8.11, revision 24666.





[ZBX-4024] SQL statements for database initialisation should be run in a transaction Created: 2011 Aug 08  Updated: 2017 May 30  Resolved: 2011 Nov 30

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Proxy (P), Server (S)
Affects Version/s: 1.8.6
Fix Version/s: 1.9.9 (beta)

Type: Incident report Priority: Blocker
Reporter: Christoph Haas Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: database, installation
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Debian GNU/Linux "testing". Linux kernel 2.6.38. 64 bit (aka "amd64"). SQLite version 3.7.7. Laptop with Core i7 system with 4 GB of RAM and 128 GB SSD.


Issue Links:
Duplicate
is duplicated by ZBX-2881 Wrong Item in AIX Template Closed
is duplicated by ZBX-2883 Wrong Item in AIX Template Closed
is duplicated by ZBX-2884 Wrong Item in AIX Template - Applicat... Closed
is duplicated by ZBX-4126 Wrong items in AIX Template Closed
is duplicated by ZBX-4127 Wrong items in HP-UX template Closed

 Description   

The SQL statements used to initialise the database should be encapsulated in a transaction. Current situation:

In create/schema/sqlite.sql you use a transaction:

BEGIN TRANSACTION;
...create schema...
COMMIT;

In create/data/data.sql you don't use a transaction:
INSERT INTO...
INSERT INTO...
INSERT INTO...
... (>12k lines of INSERTs)

When using SQLite3 this leads to an fsync() call after each INSERT statement. On a decent server with a non-decent file system (ext3 does not handle fsync() correctly) and a decent write-cache this may work. But on my development system I use ext4 with an SSD and populating the SQLite3 database takes over an hour! With ext3 it takes half an hour. When using strace I see that the system is stuck time and again on fsync() calls. Besides this has surely worn down my SSD a lot.

I investigated a little and it appears like SQLite is doing the right thing using fsync after each write action. In fact they recommend to use transactions so that only one fsync is happening after the transaction is committed. I changed the create/data/data.sql as follows:

BEGIN;
INSERT INTO...
INSERT INTO...
INSERT INTO...
... (>12k lines of INSERTs)
COMMIT;

This initialises the database within just one second.

I researched on MySQL and PostgreSQL and both understand BEGIN and COMMIT (but not "BEGIN TRANSACTION") so it should be safe to use. I cannot test for DB2 and Oracle though.

I flagged this issue an "improvement" but in fact it's a serious problem that wastes a lot of time during installation and damages disks. As you just have to add BEGIN and COMMIT this should be simple to fix.



 Comments   
Comment by dimir [ 2011 Aug 22 ]

The problem is basically Oracle. It doesn't have "BEGIN" thing. So if we want a transactioned data import in SQLite we would have to maintain separate data.sql files and we don't want that. Basically we see the only solution as to note somewhere in the instructions that SQLite users must wrap the data.sql around "BEGIN/COMMIT" manually.

<dimir> Here is our suggestion (thanks for an idea to sasha):

Here is the debian/rules section to create SQLite db:

cat create/schema/sqlite.sql create/data/data.sql create/data/images_sqlite3.sql > $(TMP_SERVER_SQLITE3)/usr/share/dbconfig-common/data/$(PKG_SERVER_SQLITE3)/install/sqlite3

How about just modifying it to:

(cat create/schema/sqlite.sql; echo 'BEGIN;'; cat create/data/data.sql create/data/images_sqlite3.sql; echo 'COMMIT;') > $(TMP_SERVER_SQLITE3)/usr/share/dbconfig-common/data/$(PKG_SERVER_SQLITE3)/install/sqlite3

?

<richlv> this will work, but you will probably see higher load from shell (should be ok in this case, but with larger datasets it can be a huge problem)

Comment by Christoph Haas [ 2011 Aug 22 ]

Your call. That would mean I'd have to permanently ship a patch with Debian packages. Without that fix an installation time of up to an hour will probably not be considered acceptable for the SQLite3 packages.

Comment by Alexei Vladishev [ 2011 Oct 26 ]

Fixed in development branch for Zabbix 2.0. Ready to test.

Comment by Aleksandrs Saveljevs [ 2011 Oct 28 ]

(1) Directory "database" is missing proper svn:ignore settings.

<alexei> RESOLVED.

<asaveljevs> CLOSED

Comment by Aleksandrs Saveljevs [ 2011 Oct 28 ]

(2) File "do" in the root directory is hopelessly outdated. Shall we remove it?

<asaveljevs> Let's clean up "go" script, too.

<alexei> removed both files. RESOLVED.

<asaveljevs> CLOSED

Comment by Aleksandrs Saveljevs [ 2011 Oct 28 ]

(3) Script gen_php.php does not work anymore:

$ php gen_php.php
File does not exist: "/home/asaveljevs/zabbix-svn/branches/dev/ZBX-4024/create/bin/schema.tmpl"

<alexei> RESOLVED

<asaveljevs> CLOSED

Comment by Aleksandrs Saveljevs [ 2011 Oct 28 ]

(4) Please review r22787 and r22791. The commits are mostly about fixing typos and style inconsistencies.

<asaveljevs> In particular, it fixes a typo in ChangeLog: "db data file uses transations now". However, I did not understand what kind of translations are meant. Could you please explain that? Perhaps it is something worth documenting.

<richlv> i'd guess it was supposed to be "transactions"... unless this was a clever sarcasm that i fell for, it shows the importance of (not having) typos

<alexei> it shows importance of having spell checker built-in vi editor. RESOLVED.

<asaveljevs> CLOSED

Comment by Aleksandrs Saveljevs [ 2011 Oct 28 ]

(5) Script export_data.sh can only be run from create/src, but it would be nice to be able to run it from any directory. Property svn:ignore would then have to be set up to ignore data.tmpl.new, wherever that is generated.

<alexei> Now data.tmpl.new is ignored under create/bin. RESOLVED

<asaveljevs> It is still not possible to run export_data.sh from any directory.

<asaveljevs> Also, if data.tmpl is located in create/src, why not place data.tmpl.new in that directory, too?

<alexei> The file will write data to stdout like other utilities do. Also added help string, proper exit code. It is possible to run it from any directory. RESOLVED

<asaveljevs> Still not possible to run from any directory:

$ create/bin/export_data.sh issue_zbx_4024 > /dev/null
grep: ../src/schema.tmpl: No such file or directory

<alexei> I wrongly tested it running from src, bad test. RESOLVED

<asaveljevs> Still not possible. For instance, from a directory that contains spaces:

$ ZBX\ 4024/create/bin/export_data.sh issue_zbx_4024 | head -10
dirname: extra operand `4024/create/bin/export_data.sh'
Try `dirname --help' for more information.
basedir: ''
schema: '/../src/schema.tmpl'

<alexei> now it works with spaces and hopefully with other special characters as well. RESOLVED

<asaveljevs> No, it does not:

$ ZBX\ 4024/create/bin/export_data.sh issue_zbx_4024 | head -10
dirname: extra operand `4024/create/bin/export_data.sh'
Try `dirname --help' for more information.
...
grep: /../src/schema.tmpl: No such file or directory

You have not fixed all the places.

<alexei> it's a shame! RESOLVED

<asaveljevs> Hurray! CLOSED.

Comment by Aleksandrs Saveljevs [ 2011 Oct 28 ]

(6) Pipe-delimited approach for data may fail if data itself contains pipes. For instance, this can happen with triggers that use OR in expressions or item keys that use regular expressions. Maybe not now, but in future we will have to take that into account.

<richlv> appliance templates already use this (to detect various possible apache or syslog process names) - i'd say that's pretty critical

<alexei> RESOLVED

<asaveljevs> The following code is wrong:

local $line = $_[0];
+ $line =~ s/&pipe;/|/;
@array = split(/|/, $line);
$first = 1;

Replacing of "&pipe;" should be done after splitting $line by pipe characters.

<alexei> :-0 RESOLVED

<asaveljevs> Looks good. Please review additional changes in r22883.

<asaveljevs> Please also take a look at r22893 - it fixes start of transactions in SQLite3. Statements for transactions in IBM DB2 and Oracle will remain empty.

<alexei> I like changes in the Perl code, SQLite3 fix is also great. CLOSED.

Comment by Alexei Vladishev [ 2011 Nov 01 ]

Fixed issues found during code review and testing. Ready to retest.

Comment by Aleksandrs Saveljevs [ 2011 Nov 02 ]

(7) I have updated instructions for Oracle at http://www.zabbix.com/documentation/2.0/manual/installation/install?&#zabbix_database . Since I do not know the current state of ZBXNEXT-675, I used "old_images" in the example. Please review.

<alexei> I found no issues, Oracle instructions look good to me. CLOSED

Comment by Aleksandrs Saveljevs [ 2011 Nov 15 ]

(8) Please review the list of tables that should be included by export_data.sh in data.tmpl.

<alexei> RESOLVED

<asaveljevs> After these changes (actually, before these changes, too), empty tables might appear in data.tmpl. Do we want that?

<asaveljevs> I have exported a database with a slide show in it. When trying to import it into a new database, I get the following error:

$ mysql -uroot issue_zbx_4024 < database/mysql/data.sql
ERROR 1452 (23000) at line 11: Cannot add or update a child row: a foreign key constraint fails (`issue_zbx_4024`.`slides`, CONSTRAINT `c_slides_2` FOREIGN KEY (`screenid`) REFERENCES `screens` (`screenid`) ON DELETE CASCADE)

<asaveljevs> Please also review changes in r23222 and r23223.

<alexei> The changes are ok to me. I ordered all tables so they match referential integrity constraints. Note that no handling of loop constraints (table1->table2->table1) and self-references (table1->table1) is implemented currently. Now empty tables do not appear in both data.tmpl and schema.tmpl. RESOLVED.

<asaveljevs> It would be nice to group tables in schema.tmpl more logically, so that semantically similar table are closer together. For instance, there is no need to keep "trigger_depends" table so far from "triggers" table and "maintenances_*" tables" are very far from "maintenances" table.

<alexei> Fixed trigger_depends & triggers. I am afraid of reviewing and moving other tables (look at maintenances*, there are so many constraints attached!), it may break something if not done very carefully. I would leave it as it is, it's really hard to come up with a single "placement principle", who is coming first, etc.

<asaveljevs> We have a comment in schema.tmpl that says "-- History tables". Tables "dhosts" and "dservices" are not in that section, although they might be considered history tables. Same for "autoreg_host" and "proxy_autoreg_host".

<alexei> RESOLVED

<asaveljevs> Also, table "ids" references table "nodes", but comes before it. Same for tables that reference "images" table.

<alexei> RESOLVED

<asaveljevs> OK, CLOSED for all.

<asaveljevs> Please review my changes in r23329.

<alexei> I like it. CLOSED.

Comment by Alexei Vladishev [ 2011 Nov 29 ]

Resolved in 23584.

Comment by richlv [ 2011 Nov 30 ]

reopen to set more precise "fix for" version

Comment by richlv [ 2011 Nov 30 ]

see ZBX-4408 for some issues with export_data.sh script

Comment by Aleksandrs Saveljevs [ 2012 Dec 04 ]

SQLite FAQ has a high-level explanation for the reason it took so long without transactions: http://www.sqlite.org/faq.html#q19 .





[ZBX-4015] Persistent Cross Site Scripting Vulnerabilities Created: 2011 Aug 04  Updated: 2020 Jul 16  Resolved: 2011 Dec 08

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 1.8.5
Fix Version/s: 1.8.10, 1.9.9 (beta)

Type: Defect (Security) Priority: Blocker
Reporter: Martina Matari Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: security
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Debian GNU/Linux 5.0.8 (Lenny)
Apache 2.2.16
PHP 5.3.3

Tested with:
Mozilla Firefox 5.0


Attachments: PNG File 1.png     PNG File 2.png     PNG File 3.png     PNG File 4.png     JPEG File link_indicator.jpg     JPEG File monitoring_dashboard.jpg     JPEG File monitoring_maps.jpg     JPEG File timeperiod.jpg     JPEG File triggers_items.jpg    
Issue Links:
Duplicate
is duplicated by ZBX-4413 nbsp in "event generation" dropdown Closed

 Description   

These URL's are vulnerable to persistent XSS attacks due to improper sanitation of gname variable when creating user and host groups.

URL:
hostgroups.php
usergrps.php

Vulnerable parameter:
gname

Method:
POST

Injected:
"</options><script>alert('XSS')</script>

Persists in:
http://test/zabbix/hostgroups.php
http://test/zabbix/users.php
http://test/zabbix/hosts.php?form=update&hostid=N (where N is a valid hostid)
http://test/zabbix/scripts.php?form=1&scriptid=N (where N is a valid scriptid)
http://test/zabbix/maintenance.php



 Comments   
Comment by Pavels Jelisejevs (Inactive) [ 2011 Nov 02 ]

RESOLVED.

Comment by Pavels Jelisejevs (Inactive) [ 2011 Nov 29 ]

Merged to /branches/1.8 revision r23578.

Comment by Pavels Jelisejevs (Inactive) [ 2011 Nov 29 ]

(4) Fixed another issue in /branches/dev/ZBX-4015 r23588. Please review.

<sasha> CLOSED

Comment by Pavels Jelisejevs (Inactive) [ 2011 Nov 29 ]

(5) Added a fix for the trunk to /branches/dev/ZBX-4015-trunk. Please review.

<sasha> CLOSED

Comment by richlv [ 2011 Dec 01 ]

(6) see ZBX-4413 for a regression, caused by this

<pavels> RESOLVED in branches/dev/ZBX-4015 r23697.

<richlv> wouldn't this change it functionally (remove those spaces, making it look worse ?), and i believe spacing at the end of the line has not been updated according to the guidelines

  • $type_select->additem(TRIGGER_MULT_EVENT_ENABLED,S_NORMAL.SPACE.'+'.SPACE.S_MULTIPLE_PROBLEM_EVENTS,(($type == TRIGGER_MULT_EVENT_ENABLED)? 'yes':'no'));
    + $type_select->additem(TRIGGER_MULT_EVENT_ENABLED,S_NORMAL.' + '.S_MULTIPLE_PROBLEM_EVENTS,(($type == TRIGGER_MULT_EVENT_ENABLED)? 'yes':'no'));

<pavels> It doesn't change anything, I just replaced the   character with a literal space. Fixed the spacing.
<sasha> CLOSED
<richlv> huh, sorry about that "functionality" part - lack of sleep did it's part. still CLOSED

Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 01 ]

(7) Fixed XSS in the profiler and some HTML entity issues in branches/dev/ZBX-4015-trunk. Please review.

<sasha> REOPENED
(7.1) Monitoring->Dashboard - hints
https://support.zabbix.com/secure/attachment/17578/monitoring_dashboard.jpg
(7.2) Monitoring->Maps - Element menu
https://support.zabbix.com/secure/attachment/17579/monitoring_maps.jpg

<pavels> RESOLVED.
<sasha> CLOSED

Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 02 ]

Merged to 1.8 revision r23754.

Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 06 ]

Merged to trunk revision 23800.

CLOSED.

Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 08 ]

(8) [GUI] Rich suggested, that using non ASCII characters in the code may cause problems, so I changed the HTML encoding strategy to ignore ampersands. This will allow us to use HTML encoded characters in the code.

Please review my commit to /branches/dev/ZBX-4015-trunk r23855.

REOPENED and RESOLVED.
<sasha> CLOSED

Comment by Alexander Vladishev [ 2011 Dec 08 ]

branches/dev/ZBX-4015 (1.8) Successfully TESTED

Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 08 ]

Updated trunk r23875 and 1.8 r23878.

CLOSED.

Comment by richlv [ 2012 Jan 03 ]

this resulted in a regression : ZBX-4506





[ZBX-4009] {HOSTNAME} and {IPADDRESS} macros are not resolved in custom labels on network maps in the edit mode Created: 2011 Aug 03  Updated: 2017 May 30  Resolved: 2011 Dec 27

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 1.9.5 (alpha)
Fix Version/s: 1.9.9 (beta)

Type: Incident report Priority: Blocker
Reporter: Sergey Syreskin Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: maps, regression, usability
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

RHEL 5 derivative, PostgreSQL 8.4, PHP 5.1.6



 Description   

I'm not sure whether this is a bug or feature.

To reproduce:
1) go to Configuration of network maps menu;
2) click the Edit link of a map;
3) set Host label type to Custom label;
4) in the below text area enter

{HOSTNAME} {IPADDRESS};
5) save;
6) open the map in the editor, see that host label is shown as "{HOSTNAME}

{IPADDRESS}";
6) go to network maps monitoring, open the map, see that {HOSTNAME} {IPADDRESS}

are substituted with the respective values as expected.



 Comments   
Comment by richlv [ 2011 Aug 03 ]

that was sort of a planned change, but it has regressions - most notably, makes map editing much harder as identifying map elements now is impossible without opening their properties individually. same goes for all other macros, as before it was possible to simply add a macro to reference item value and immediately see whether it was correct - not possible anymore.

possible solution would be a "resolve macros" mode - by default they would not be resolved (improves performance), but could be easily enabled.

this functionality was lost during development of ZBXNEXT-674

Comment by Alexei Vladishev [ 2011 Oct 12 ]

That's the difference between Monitoring and Configuration sections. In Configuration we tend to display configuration parameters as they are without substitution of macros. That's the general approach we applied to maps as well.

I agree that a special "Preview" button would be a nice touch though.

Comment by richlv [ 2011 Oct 12 ]

after some discussion this was decided to be a serious enough regression in the editing mode to warrant a blocker priority

Comment by richlv [ 2011 Dec 15 ]

rough initial specification at https://zabbix.org/wiki/Docs/specs/ZBX-4009

<pavels> I think it should affect everything in the map configuration, not just the map itself. Should we resolve all of the macros, or just some of them, e.g HOST.NAME or IPADDRESS? Someone also had a nice idea, that the resolved macros should be highlighted with some color to separate them from plain text.

Comment by Alexey Fukalov [ 2011 Dec 23 ]

dev branch: svn://svn.zabbix.com/branches/dev/ZBX-4009

Comment by Alexander Vladishev [ 2011 Dec 23 ]

Successfully tested!

Comment by Alexey Fukalov [ 2011 Dec 23 ]

MERGED: svn://svn.zabbix.com/trunk 24241

Comment by Oleksii Zagorskyi [ 2011 Dec 24 ]

Just for case - do not forget to update http://www.zabbix.com/documentation/2.0/manual/introduction/whatsnew200 with this feature.

Comment by Alexey Fukalov [ 2011 Dec 27 ]

Added note to What's new.





[ZBX-3988] Browser memory leak on some pages of zabbix web interface Created: 2011 Jul 28  Updated: 2017 May 30  Resolved: 2011 Dec 20

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 1.8.6, 1.9.6 (beta)
Fix Version/s: 1.8.9, 1.9.9 (beta)

Type: Incident report Priority: Blocker
Reporter: Oleksii Zagorskyi Assignee: Unassigned
Resolution: Fixed Votes: 1
Labels: memoryleak
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

WinXP32 SP3, Opera 11.50 build 1074.
latest trunk, ~ after r20500


Attachments: PNG File 3operas_memory leak.png     PNG File Opera_DEV-3988_memleak.png     PNG File firefox-memory-leak.png    

 Description   

Last time (~ last week) i have huge problem - my Opera periodically eats all RAM (4GB), it hangs and if i could not close it in time, even OS hangs and i have only one way - press reset button.
Finally i figured out when it happens.

I have opened several Zabbix GUI tabs on the Opera all time, and sometimes i leave opened Dashboard tab in the background and i don't select it for some time. After some short time my system becomes unstable and finally not responds - Opera ate all virtual memory.
It seems here is no this problem with other GUI pages.

When i switch to tab with Dashboard and move mouse over several widgets (without any click, only mouse over !!!) then Opera drops all memory leak.
I have even recorded video how i reproduce the problem

Speed of memory leak (only one tab with Dashboard opened) ~ 500 Mbytes/hour of virtual memory.

I have configured monitoring of revision changes for different components on the my dev-server and i can assume that problem can appears between revs 20500 and 20667.

So i think you should to take a look to this situation. And i feel that this situation related to the ZBX-3969.

Another browsers are not tested.



 Comments   
Comment by Oleksii Zagorskyi [ 2011 Jul 28 ]

Note: Pages Auto-updating is disabled in the profile (Refresh (in seconds)=0)

Comment by Oleksii Zagorskyi [ 2011 Jul 28 ]

Meh, just rebooted (by reset button). And I've had opened pages: items.php, trigger_prototypes.php, events.php, tr_status.php
It seems not only Dashboard involved. I continue an investigation.

Comment by Oleksii Zagorskyi [ 2011 Aug 11 ]

About the picture "3operas_memory leak.png"
Instance of Opera#2 has only one tab opened - Dashboard.

Other opera instances have ~40-60 tabs opened each.
As i said - problem reproducible not for all front-end pages, and reproducible not for Dashboard page only.

Checked on several different WinXP workstations with the same version of Opera.

Comment by Aleksandrs Saveljevs [ 2011 Aug 17 ]

Same happens in Firefox in Zabbix 1.8.6. See firefox-memory-leak.png. The only thing that computer is doing is showing a single slide show on the monitor.

Comment by richlv [ 2011 Aug 21 ]

note that slideshow one was reported some time ago already as ZBX-3878

Comment by Alexey Fukalov [ 2011 Oct 06 ]

dev branch: svn://svn.zabbix.com/branches/dev/ZBX-3988

Comment by Aleksandrs Saveljevs [ 2011 Oct 06 ]

Does not seem to leak in Safari, but leaks pretty fast in Internet Explorer 7 and Internet Explorer 9. Also seems to leak slowly in Opera (raised from 130 MB to 190 MB in approximately an hour) on Windows and Firefox and Google Chrome on Linux.

Comment by Oleksii Zagorskyi [ 2011 Oct 17 ]

Deep and long tests of this dev branch were made.

Memory leak reproducible only on the page "slides.php" (Opera under Linux & Windows).
Detailed report will be available soon.

Comment by Oleksii Zagorskyi [ 2011 Oct 17 ]

It seems that memory leaks on the page "slides.php" highly dependent on the screen's (used in the slides) content.
I need some additional time to test.

Comment by Oleksii Zagorskyi [ 2011 Oct 18 ]

the picture attached. sorry

Comment by Oleksii Zagorskyi [ 2011 Nov 02 ]

Maybe it's time to commit this changes to 1.8 branch & trunk ?
No more forces to wait

For slide shows we have separate issue ZBX-3878.

Comment by Alexey Fukalov [ 2011 Nov 02 ]

Resolved except slideshow leaks.

Comment by Aleksandrs Saveljevs [ 2011 Nov 02 ]

(1) You have added loading of menus.js for items.php and slides.php, but we do not have that JavaScript file in our repository.

<asaveljevs> Also, please review r22897.

<Vedmak> RESOLVED

<asaveljevs> CLOSED

Comment by Alexey Fukalov [ 2011 Nov 04 ]

svn://svn.zabbix.com/branches/1.8 22963
svn://svn.zabbix.com/trunk 22968

Comment by Oleksii Zagorskyi [ 2011 Nov 04 ]

Thank you for fixing !

Comment by Oleksii Zagorskyi [ 2011 Nov 23 ]

I feel that memory leaks are back. Not sure for 1.8 or trunk branch.

I need several days to be sure.

Comment by Oleksii Zagorskyi [ 2011 Nov 23 ]

Yeah, leaks definitely are back. Currently tested only Dashboard page, but after two days I feel that not only dashboard affected.
Tested opera for Linux & Windows.
Trunk rev 23335.

Related only to trunk branch, i.e. latest revision of 1.8 branch is ok.

According to revision changes monitoring (my very specific solution) I suppose the changes between revisions 23287 and 23335 but I'm not sure.
I'll try to figure out affecting revision.

<zalex>
Strange, I have memory leaks even in the revision 22968 (trunk) when this issue was fixed.
Note: I did not tested the fix in that time.

<Vedmak> Leaks are in Dashboard screen?

<zalex> yes, leaks are not only in th dashboard. In the triggers, events pages too. I think in other pages too.

<pavels> zalex, when you tested opera, did it leak continuously? I've tried to open about 20 trigger pages simultaneously and it ate up about 20 Mb per refresh, but when it reached 350 Mb the leak seamed to stop and stabilized. I tried it on a different page with just some content and auto refresh, and it seams opera does leak when refreshing a page, but always stabilizes at some point. The trigger page doesn't leak in Firefox or Chrome, the dashboard seems to leak a bit, but much slower.

<zalex> pavels, a dynamic of leak in the Opera for windows and linux is different. In windows need to wait ~ 5-10 minutes to see the leaking start. In windows it up every minute and constantly.
Last time (latest trunk revision) the leaks in Linux is different - need to wait 20-30 minutes to see BIG pieces of memory eating (200-300 MBytes if I recall correctly). If you will wait 1-2 hours you will see several such memory's jumps. If I recall correctly, earlier (2-3 months ago) the dynamic in linux was similar as in windows.

No need to open many tabs/pages, single page is enough.

I always have auto-refresh pages DISABLED, i.e. 0 seconds.
If you need fresh graphs I'll create them.

<pavels> Wait, you mean that the trigger and event pages leak even when auto refresh is disabled?

<zalex> Yes, definitely. All my life (on all zabbix installation, databases, etc) I have auto-refresh pages DISABLED, i.e. 0 seconds.
All current and previous tests have been performed with auto-refresh pages DISABLED, i.e. 0 seconds.
I have disabled it always because I'm not end user of Zabbix frontend and I do not need to have it enabled.
See my very first comment to this issue.

<pavels> Found were the leak is. Now all I need is to figure out how to fix it.

Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 20 ]

Well that was fun and interesting. RESOLVED in /branches/dev/ZBX-3988-trunk

Comment by Oleksii Zagorskyi [ 2011 Dec 20 ]

Fast test of dev branch shows that the leaks are missing at the events page (Opera for Windows and Linux).
A report of more deep testing and all pages will be ready in 1-2 days.

<zalex> Report of long testing is ready.
Tested Opera 10.52 for Windows and Linux. Tested for 4-5 hours with opened ~ 24 tabs (almost all "affected" pages) each time. Tested in both modes: auto-refresh pages disabled and enabled (30 seconds).
The page "slides.php" WAS NOT USED IN THE TESTS (will be done separately soon).

NO MORE MEMORY LEAKS !!! Thanks.

Comment by Alexei Vladishev [ 2011 Dec 22 ]

It is not about memory leaks, but please also test if blinking works fine without any visible problems in case of large number of visual elements, say, 1000 of triggers with some of them blinking. It is because the new algorithm is more CPU intensive.

<pavels> Tested it in firefox with about 700 events, all of them blinking. CPU usage does go up about 10 percentage points, but the page stayed responsive and I haven't noticed any slow downs at all.

<zalex> Tested Opera for Windows and Linux with blinking 1000 rows at the events and triggers pages.
I do not see|feel any difference under Windows + Core2Duo 2Ghz.
Under Linux +Corei5 2,86Ghz Opera process consumes +5% when tested page is opened. Per all CPU it's only ~ +(1-2)%

Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 27 ]

Merged the jqBlink fix to the trunk r24269.

CLOSED.

Comment by hamid sfandiari [ 2012 Mar 12 ]

I've same issue on Firefox and chrome .. it's occurs when I used a slide show which contains graph, but when I load a side show with map(s) the problem is not occurs

Comment by Oleksii Zagorskyi [ 2012 Mar 12 ]

Hamid, I'd suggest you to move this comment to the ZBX-3878.
Please do mention a version of zabbix frontend used, versions of your Browser ans describe as much details as possible.
Thanks.





[ZBX-3955] Database table names are not validated in popup windows Created: 2011 Jul 15  Updated: 2020 Jul 16  Resolved: 2012 Jan 30

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 1.8.5
Fix Version/s: 1.8.11, 1.9.9 (beta)

Type: Defect (Security) Priority: Critical
Reporter: Alexey Fukalov Assignee: Unassigned
Resolution: Fixed Votes: 2
Labels: gui, security, validation
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified


 Comments   
Comment by Aleksandrs Saveljevs [ 2011 Jul 15 ]

Reported by Damian Tommasino in https://support.zabbix.com/browse/ZBX-3840?focusedCommentId=43000&page=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel#action_43000.

Comment by Pavels Jelisejevs (Inactive) [ 2012 Jan 23 ]

(1) Please review my changes in r24957. If everything is ok, you can merge.
<Slava>CLOSED

Comment by Pavels Jelisejevs (Inactive) [ 2012 Jan 25 ]

I had another look and realized, that there is a better way to fix it.

REOPENED.

Comment by Pavels Jelisejevs (Inactive) [ 2012 Jan 25 ]

I've implemented a stricter parameter validation. Please review.

RESOLVED.

Comment by Alexey Fukalov [ 2012 Jan 30 ]

(2) [GUI]
Please review my changes in rev. 25068.

<pavels> Thanks, CLOSED.

Comment by Pavels Jelisejevs (Inactive) [ 2012 Jan 30 ]

Merged to 1.8 r25074.

Comment by Pavels Jelisejevs (Inactive) [ 2012 Jan 30 ]

The fix for the trunk is available in /branches/dev/ZBX-3955-trunk.

RESOLVED.

Comment by Pavels Jelisejevs (Inactive) [ 2012 Feb 01 ]

Merged to trunk r25132.

CLOSED.





[ZBX-3832] mysterios periods_cnt option Created: 2011 May 23  Updated: 2017 May 30  Resolved: 2011 Nov 30

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Documentation (D), Frontend (F), Installation (I), Server (S)
Affects Version/s: None
Fix Version/s: 1.9.9 (beta), 2.0.0

Type: Incident report Priority: Blocker
Reporter: richlv Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: codequality, graphs, trivial
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified


 Description   

for custom graph items, there's a periods_cnt db field/option. this option is not documented anywhere and nobody knows what it does.

it should either be nuked or properly documented/exposed.



 Comments   
Comment by Pavels Jelisejevs (Inactive) [ 2011 Nov 25 ]

It has been decided to remove aggregate graph items whatsoever.

Please review the update for the trunk GUI in /branches/dev/ZBX-3832. RESOLVED.

Comment by richlv [ 2011 Nov 25 ]

(1) doesn't server also need some updates for graphs it creates from network discovery, active agent auto-registration and low level discovery ?
edit: it must. server still refers to periods_cnt

<pavels> Ah, of course it does, sorry.
<sasha> RESOLVED

<dimir> CLOSED

Comment by richlv [ 2011 Nov 26 ]

(4) documentation must be updated :
http://www.zabbix.com/documentation/2.0/manual/appendix/api/graphitem
http://www.zabbix.com/documentation/2.0/manual/appendix/api/graph/create
http://www.zabbix.com/documentation/2.0/manual/appendix/api/graphitem/get
anywhere else ?

it should also be noted that this change will have to be reflected when transferring xml docs and possibly others

<pavels> RESOLVED.
<sasha> REOPENED http://www.zabbix.com/documentation/2.0/manual/config/visualisation/graphs/custom
<sasha> RESOLVED

<pavels> CLOSED.

Comment by Alexander Vladishev [ 2011 Nov 30 ]

Available in version pre1.9.9, r23639.





[ZBX-3518] popup clutter in overview by triggers Created: 2011 Feb 09  Updated: 2017 May 30  Resolved: 2012 Mar 10

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 1.8.4
Fix Version/s: 1.8.11, 1.9.9 (beta)

Type: Incident report Priority: Minor
Reporter: Aleksandrs Saveljevs Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: overview, popups, usability
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: PNG File many-popups-1.png     PNG File many-popups-2.png    

 Description   

Go to "Monitoring" -> "Overview" -> "Triggers". Click on a blue arrow. A popup with a list of trigger dependencies will appear. Then click in that popup. New blue popup windows will appear. These blue popup windows might come in different flavors (see many-popups-1.png and many-popups-2.png). The first problem is that these blue popups are hidden behind the trigger dependency popup. The second problem is that it is not entirely clear what these blue popups relate to. The third problem is that they do not go away automatically.



 Comments   
Comment by richlv [ 2011 Sep 05 ]

still there in trunk rev 21494.

Comment by Alexander Vladishev [ 2012 Mar 09 ]

Already fixed in version pre-1.8.11 r24338 and 1.9.9 r24346 with ZBX-3909.





[ZBX-3475] Compilation error --with-sqlite3 on FreeBSD Created: 2011 Jan 28  Updated: 2017 May 30  Resolved: 2012 Jan 30

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Server (S)
Affects Version/s: 1.9.2 (alpha)
Fix Version/s: 1.8.11, 1.9.9 (beta)

Type: Incident report Priority: Minor
Reporter: Oleksii Zagorskyi Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: freebsd
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

FreeBSD8.1
pkg_info | grep sqlite
php5-pdo_sqlite-5.3.5 The pdo_sqlite shared extension for php
php5-sqlite-5.3.5 The sqlite shared extension for php
py26-pysqlite-2.3.5 A DB-API v2 Python library for the SQLite 3 embedded SQL en
sqlite3-3.7.4 An SQL database engine in a C library


Attachments: File ax_lib_sqlite3.m4.diff    
Issue Links:
Duplicate
is duplicated by ZBX-4535 zabbix - FTBFS with ld --as-needed Closed

 Description   

If i configure --with-sqlite3 then:
checking for SQLite3 library >= 3.0.0... no
configure: error: SQLite3 library not found

If i configure --with-sqlite3=/usr/local then:
checking for SQLite3 library >= 3.0.0... yes
checking for function sqlite3_open_v2() in sqlite3.h... yes

It seems need to improve SQLite3 checking in the different OS.

p.s.zabbix_server (--with-sqlite3=/usr/local) starts and works normally with the sqlite3 db-backend.



 Comments   
Comment by Alexei Vladishev [ 2011 Jan 28 ]

Sorry, but I do not see any issues here. Why blocker?

Check for the SQLite3 library is done in exactly the same way as, for example, check for PostgreSQL library. We do not look at any OS specific directories.

I am closing it.

Comment by Oleksii Zagorskyi [ 2011 Jan 30 ]

he-he, the game is NOT over.
why blocker - because of compilation error .
Probably my knowledge is not great as your Alexei, but I'm single-minded and partially crazy .

I'm not agree that "/usr/local" is a specific directory. It's prefix-path, where installed all software under FreeBSD and maybe not only - i don't know.
And for example you're not right about <We do not look at any OS specific directories> - see to the "libssh2.m4". This macro try to check several paths and it authors are two Zabbix developers.

Okay enough talk, take my very simple patch "ax_lib_sqlite3.m4.diff"

A source info here:
http://git.savannah.gnu.org/gitweb/?p=autoconf-archive.git;a=commitdiff;h=cf19f0cc2e2b52c025063354c9cfd91ea0bf8fdf;hp=05f057531dfd0308c9892df4913c92101196ad18

Well, after figure out of the source code and manuals of auto**** stuff I see that static linking is not provided - and really I can't compile with --enable-static flag. Check it out and apparently it also should to be fixed.

Comment by Alexei Vladishev [ 2011 Jan 31 ]

All right, I agree that it shouldn't be closed. Let's keep it open, priority was changed to Minor.

Comment by Alexander Vladishev [ 2012 Jan 30 ]

Fixed in versions pre-1.8.11 r25085 and pre-1.9.9 r25087. See ZBX-4535 for more details.





[ZBX-3358] Possible to add circular trigger dependency Created: 2010 Dec 30  Updated: 2017 May 30  Resolved: 2012 Jan 31

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: API (A), Frontend (F)
Affects Version/s: None
Fix Version/s: 1.9.9 (beta)

Type: Incident report Priority: Blocker
Reporter: Konstantin Buravcov (Inactive) Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: dependencies, triggers
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: PNG File Screenshot-Configuration of triggers - Mozilla Firefox.png     PNG File bug_2.png     PNG File bug_3.png     PNG File bug_6.png    

 Description   

In trunk you can create a circular dependency for a trigger.

1. Create "Trigger A"
2. Update "Trigger A" setting dependency on "Trigger A" (on iteself)



 Comments   
Comment by Konstantin Buravcov (Inactive) [ 2010 Dec 30 ]

Fixed in dev branch ZBX-3358

Comment by Alexey Fukalov [ 2011 Jan 10 ]

Trigger dependencies in template are not preserved on linkage

Comment by Alexey Fukalov [ 2011 Jan 10 ]

have one template linked to a host.

if we try to add dependency in template trigger to another template trigger with updating expression, errors appear.

Comment by Konstantin Buravcov (Inactive) [ 2011 Feb 04 ]

All the other mentioned prtoblems seem to be solved in dev branch.

Also there as another one - it was possible to add a dependency on a trigger from template, that was not linked to the host where original template was linked, but only when changing trigger expression. This was also fixed.

Please test and review (especially class.ctrigger.php)

Comment by Konstantin Buravcov (Inactive) [ 2011 Feb 04 ]

Added unit test testFormTrigger_CircularDependency

Comment by Alexey Fukalov [ 2011 Feb 15 ]

(1)
For host trigger it's possible to add dependency for templated trigger, even if that template is not linked to host.
Let's add test for this situation too.

Fixed and added tests (KB)

Comment by Aleksandrs Saveljevs [ 2011 Feb 22 ]

(5) Create a templated trigger with dependencies. Go to a host that the template is linked to and remove the dependencies. Go to the templated trigger, do not change anything, click "Save". In 1.8, dependencies on a host trigger will not be recreated (there was a ZBX about it). In the development branch, they will be.

what's the expected behavior? (KB)

The expected behavior is that only changes in trigger configuration are propagated downwards. For instance, if only trigger comments have changed, then trigger comments should be updated in the linked hosts and templates. Other things like dependencies, event generation, severity, URL, enabled/disabled status should not be. Same holds for items. (asaveljevs)

See ZBX-2577 for the original issue. (asaveljevs)

Fixed (KB)

Comment by Oleksii Zagorskyi [ 2012 Jan 29 ]

Why this issue closed as Fixed (even with Fix version/s 2.0.0) without any comments?
As I see this dev branch has been not merged to sources.
(8) not answered !
Require clarification. REOPENED

Comment by Oleksii Zagorskyi [ 2012 Jan 31 ]

Summarize:
This dev branch has been not merged to sources.
In the trunk r25095 it's not possible to create such circular dependency.
Seems this issue has been fixed in the ZBXNEXT-835

Will be closed as fixed for version 1.9.9. See ZBXNEXT-835 for more details.





[ZBX-3286] Ability to automatically/manually delete discovered resources (low level discovery). Created: 2010 Dec 13  Updated: 2017 May 30  Resolved: 2011 Dec 21

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F), Server (S)
Affects Version/s: 1.9.1 (alpha)
Fix Version/s: 1.9.9 (beta)

Type: Incident report Priority: Blocker
Reporter: Oleksii Zagorskyi Assignee: Unassigned
Resolution: Fixed Votes: 13
Labels: discovery, lld
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

latest trunk


Attachments: Text File zabbix_server_demo_R23852.log    
Issue Links:
Duplicate
is duplicated by ZBX-4592 When using low level discovery in a t... Closed

 Description   

Now the auto-added resources (items, triggers) can not be deleted. Only graph can be manually deleted - i think tis is bug.

Need to come up with a mechanism for automatic/manual removal of obsolete resources.
By obsolete, I mean:
resources that belong to the prototype, but is no longer discovered (for example we delete VLAN);
resources that have ceased to pass through the filter of the macros (various examples).
This should be an option in the settings of the rule - whether to delete obsoleted resources automatically.

I do not have a clear vision of how it should look, but I think that should be able to manually remove these obsolete resources, for example they should be made available for manual deletion (not obsolete resources should stay unavailable for deletion). This is the case if automatic deletion is not enabled.

as discussed with Aleksandrs Saveljevs i mark this issue as "blocker"



 Comments   
Comment by Paxos [ 2011 Apr 27 ]

Having the same issue with 1.9.3.

I think the current logic of keeping auto-generated resources around after they disappear from discovery is the way to go.

However, these items must be able to be removed manually and not auto-removed.

Comment by Marcin Gapiński [ 2011 Oct 14 ]

It would be great if there was an option to choose what to do when discovered item is no longer present.

I can think of two possible scenarios: delete that item automatically or disable it and allow for manual removal. That would certainly decrease resources usage on rapidly changing monitoring environment.

Comment by Yoav Steinberg [ 2011 Nov 08 ]

I'd really like to see an option to auto remove discovered items. For things like file system or net interfaces this might not be critical, and we might want to continue seeing these items after we remove them. But other use cases like for monitoring instances of a process on a system that spawn new processes based on some external input (rapidly changing system) there should be an option to automatically delete the discovered items after they disappear.

Comment by Alexei Vladishev [ 2011 Nov 16 ]

A new global (Administration->General->???) configuration parameter will define life time of lost items. If an item exceeds the period, it will be removed and a new record for housekeeper will be added as well.

Comment by Alexey Pustovalov [ 2011 Nov 21 ]

maybe do better not global? host level or discovery?

Comment by richlv [ 2011 Nov 21 ]

lld rule level would seem to be most appropriate. for example, we might have a host which has network interfaces quite rapidly changed, thus we know that interface going down would allow us to mostly safely remove it after 3 days. on the other hand, disk volumes going away would be less frequent, and data would be more important in the long term, thus we would like to have those items only removed after 2 weeks have passed

Comment by Alexei Vladishev [ 2011 Nov 23 ]

Sure, it's better to keep it on lld level with support of user macros (template, host, global).

Comment by Alexey Fukalov [ 2011 Dec 05 ]

New field "lifetime varchar(64)" is added to "items" table. Allows usermacro or number in days.
New input field is added to discovery rule form before "status".

Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 06 ]

(1) GUI
I think we should replace the maximum (and, maybe, minimum) lifetime with constants in the CDiscoveryRule::checkSpecificFields() and CDiscoveryRule::validateLifetime() methods and try to avoid using literal constants in the future.

Same for validatePortNumber()

<Vedmak> RESOLVED

<pavels> CLOSED.

Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 06 ]

(2) GUI
Shouldn't the clearValues() method in CItemGeneral::checkInput() and CHostInterface::checkInput() be called before the validation is performed? What's the point of cleaning up values, if they are already OK?

<Vedmak> RESOLVED

<pavels> CLOSED.

Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 06 ]

(3) GUI
Please review my changes in r23788 and r23789.

<Vedmak> CLOSED

Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 06 ]

(4) DOC
The docs should also be udpated
http://www.zabbix.com/documentation/internal/database_2.0/items
http://www.zabbix.com/documentation/2.0/manual/discovery/low_level_discovery

<Vedmak> I'll update db and api docs, and put separate paper on the board for it.

<pavels> Db and API docs are ok. CLOSED.

Comment by Alexander Vladishev [ 2011 Dec 06 ]

(5) [DB] DB patches
upgrades/dbpatches/2.0/postgresql/patch/hosts.sql:64 - incorrect SQL statement delimiter
upgrades/dbpatches/2.0/oracle/patch/hosts.sql:64 - useless constraint 'NOT NULL'

<Vedmak> RESOLVED
<sasha> CLOSED

Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 06 ]

(6) GUI
When cloning a discovery rule or full cloning a host an error occurs:
"Discovery rule "lld22-2:lld2" has incorrect lifetime: "". (min: 0, max: 3650, user macro allowed)"

<Vedmak> RESOLVED

<pavels> CLOSED.

Comment by Alexander Vladishev [ 2011 Dec 06 ]

(7) [GUI] when creating/updating a discovery rule with 'Keep lost resources period (in days)' = 0 an error occurs:
Discovery rule "vfs.fs.discovery:vfs.fs.discovery" has incorrect lifetime: "". (min: 0, max: 3650, user macro allowed)

<Vedmak> RESOLVED

<pavels> CLOSED.

Comment by richlv [ 2011 Dec 06 ]

(8) api docs (to avoid overloading (4))
a) having http://www.zabbix.com/documentation/2.0/manual/appendix/api/discoveryrule is great, but to be consistent i guess there shouldn't be space in the page title (not sure about capitalisation)

b) also should be listed at http://www.zabbix.com/documentation/2.0/manual/appendix/api/changes_1.8_-_2.0

<Vedmak> RESOLVED

<richlv> do we have a rule on class naming ? because now we have "TemplateScreen" and "Discoveryrule" - would be nice to settle on either camelcase or something.
hmm, changes page actually says "DiscoveryRule" - which one is correct then ?

<zalex> last question moved to ZBXNEXT-1058
CLOSED

Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 07 ]

GUI is TESTED.

Comment by Alexander Vladishev [ 2011 Dec 07 ]

A server side is ready to test!

<dimir> Great! Please review my changes that allow it to work without graph prototypes in r23965 .

Comment by Oleksii Zagorskyi [ 2011 Dec 08 ]

I could not to not test the dev branch ASAP
Server side tested. Seems it works.
A part of the debuglog attached.

>>> 15557:20111208:010525.923 poller #1 spent 2.178640 seconds while updating 1 values
it's ok because tested SNMP device is partially slow:

  1. time snmpwalk -c scarysecret -v 1 10.20.0.5 IF-MIB::ifAlias
    .....~40 result records ....

real 0m1.965s
user 0m0.344s
sys 0m0.016s

Comment by Oleksii Zagorskyi [ 2011 Dec 08 ]

(9) An item, has been not passed through the filter but doesn't deleted yet, still continue to be monitored:

mysql> select i.lastclock, d.lastcheck from items i, item_discovery d where i.itemid=25905 and i.itemid=d.itemid;
----------------------+

lastclock lastcheck

----------------------+

1323302205 1323298285

----------------------+

Is it ok by design?

added:
For instance, how an user can understand that after he changed the Regexp previously discovered and added resources currently are not passing by filter?
So if a gathering the data will be stopped then it could be some "indicator" that the resources are not discovered anymore an they going to be deleted in N days.

How is else the user can understand that some resources are not discovered anymore?

<zalex> some part moved to the ZBXNEXT-1058, some to the ZBX-4475
CLOSED

Comment by Oleksii Zagorskyi [ 2011 Dec 08 ]

(11) I would suggest to change default value 0 days for "Keep lost resources period (in days)" to for instance 1 day when an user creates new discovery rule.
Try to imagine the case when the user creates discovery rule and forgot to change 0 to the value>=1.
Later he or someone else wrongly changes Regexp of discovery rule and all historical data can be unexpectedly lost in one moment (when discovery will be performed by the zabbix_server next time).

It's danger behavior. The user has to set 0 day only when he is understanding what he doing.

<zalex> moved to ZBXNEXT-1058
CLOSED

Comment by Ghozlane TOUMI [ 2011 Dec 09 ]

Hi.
the method I suggested in ZBXNEXT-925 could be an answer :
you could add a 'layer' between discovery and actual item creation, where user could see with some kind of status

  • the currently discovered ressources
  • the previously discovered ressources no longuer present, both with the date of last discovery
  • and eventualy the manualy added ressources.( wich was the main request for the ZBXNEXT-925)

That way the user can choose between automatic and manual creation / deletion,
see what's going on with the discovery, manage the ressources by disabling / removing ressources.

That could allow some nw use cases like :
deactivate after an initial run the discovery and keep it's ressources ,
use the lld structure with manualy entered ressources etc.

Comment by dimir [ 2011 Dec 14 ]

Note, until ZBX-4425 is merged into trunk the server side will not work in this development branch. Meanwhile you can apply this patch:

svn diff svn://svn.zabbix.com/branches/dev/ZBX-4425 -c r23945

in order to test it.

Comment by Alexey Fukalov [ 2011 Dec 21 ]

merged: svn://svn.zabbix.com/trunk 24129

Comment by Alexey Fukalov [ 2011 Dec 21 ]

Additional improvements will be implemented in ZBXNEXT-1058

Comment by Oleksii Zagorskyi [ 2011 Dec 21 ]

Reopened to close (move) some comments;
to remove 2.0 from Fixversion.

Comment by Oleksii Zagorskyi [ 2011 Dec 21 ]

Closed again.

Comment by Nelson Rotunno [ 2014 Jul 29 ]

I've been looking around on the forums and whatnot and it seems like there is still no way to manually delete discovered resources, it would be great to see that added.

At least in my case, many (nearly 30) unnecessary network interfaces are added via the discovery rule and even though it is possible to disable the new items as a whole, I find this rather "polluting" to my setting.

I see no reason to leave those items there and I can't just recreate the host since I want to keep its historical data. Besides, those items won't get scheduled for auto cleanup because they're still discovered, I simply don't want them around anymore.





[ZBX-3149] 'Server info' resource for Screen is not translatable Created: 2010 Oct 27  Updated: 2017 May 30  Resolved: 2012 Apr 27

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: None
Fix Version/s: 1.9.9 (beta)

Type: Incident report Priority: Minor
Reporter: Oleksii Zagorskyi Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: localization, trivial
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: PNG File 2.after_patch.png     File class.cserverinfo.php.diff     PNG File server_info_untranslated.png    

 Description   

I propose:
for 'Updated' use 'S_UPDATED'=> '?????????',
for 'Refreshed every' and 'refresh now' create new strings.
for 'Logged in as' use 'S_CONNECTED_AS'=> '????????? ???',
for 'Zabbix server is ???????' remake like in Dashboard. See picture.
And time stamp should be localized.



 Comments   
Comment by Oleksii Zagorskyi [ 2010 Oct 27 ]

And may be it better to use full words description for count of items, hosts, trigger. Like in Dashboard now.

Comment by Oleksii Zagorskyi [ 2010 Nov 10 ]

Patch attached. See the result on picture.

Comment by richlv [ 2010 Nov 24 ]

i'd say it is best to deal with translation issues for trunk now that gettext is merged - both because it is more longterm solution, and also to make 1.8 as stable as possible.

so in branches/dev/ZBX-3149 is the initial work on some translation improvements. from the suggestions :

first two implemented;
third added as a separate string;
no change for last two yet. as for zabbix server status, i'd argue dashboard should be changed to be like this element - it is easier to understand, as it does not mix text "Zabbix server is running" with "no". details for timestamp localisation should be agreed upon in general.

Comment by Oleksii Zagorskyi [ 2010 Nov 24 ]

ok, but keep in mind that the combination 'Zabbix server' as link + mandatory string 'is' are not translatable to Russian. I mean that the word 'is' are totally unnecessary in translation.
Maybe replace 'is' to 'state:' ?

Comment by richlv [ 2010 Dec 14 ]

3. given that it's better to move to directly gettextised strings, 'Logged in as' just made gettext translatable;
4. for now just made "Zabbix server" translatable;
5. allowed to translate the date format

both of 3&4 should be unified (with dashboard and footer), but that's somewhat out of scope, thus it would be better to handle later

also made "GETTEXT:" string work as a prefix for comments, directed at translators

Comment by richlv [ 2010 Dec 14 ]

please, review

Comment by Konstantin Buravcov (Inactive) [ 2010 Dec 14 ]

xgettext --add-comments looks correct

Comment by richlv [ 2010 Dec 14 ]

merged. for string unification, please file a new issue

Comment by Oleksii Zagorskyi [ 2010 Dec 15 ]

#. GETTEXT: r is date format string......
is wrongly latched on to:
msgid "Updated"
It seems need to better understand how to write a GETTEXT comment for single line with multiple strings.

'sec' in phrase "Refreshed every: 0 sec " - stay left untranslated
'is' - also
Do you like this in Russian "Zabbix server is запущен" ?
I proposed early - Maybe replace 'is' to 'state:' ?

Simply thing - maybe it better write something like GETTEXT_COMMENT instead of simply GETTEXT.
And why in several other projects developers use something like "l10n" or "i18n" ? Simply interesting.
He-he, answer:
http://en.wikipedia.org/wiki/Language_localisation
http://en.wikipedia.org/wiki/Internationalization_and_localization
Think about l10n.
in wordpress is used - translators:

Q:Richlv: zalex_ua, btw, any good examples when comments for translators would be very helpful ? (when translating without having frontend accessible, for example) ?
A:
1. no need to comment full sentences.
2. single "abstract" words should be commented always. For example: do, is, of, next, previous, first, last....... and others.
2.1 date time formats - always should be commented
3. word combinations with no end or beginning of sentence - nice to be commented.
4. ... not the end

For example in phpMyAdmin (were i'm also little translator ) for aprox. 2500 translation lines is exist about 50 comments. Normally IMHO.

and see wordpress .po files example - very gud example.

it seems in many places need to use 3.5.4. Disambiguation by context (see 2.0 documentation)
this strings can be commented separately or not?

Yes, when doing translation - I regularly have to spend, whether the place I translated what was assumed.
Therefore, the translation without having frontend accessible - it seems almost impossible, besides zabbix is a specific system - to translate without knowing the system is impossible.
It is assumed that the translator must be partly the developer and be able to manage frontend instances of what he wants.
With the introduction of gettext it will be harder because we are working with the .po file, which must still convert to .mo (not hard). That's just Pootle will be useful - it allows to upload locally edited .po file with flexible merge - it seems the best way for me. IMHO.

can be continued....

Comment by Oleksii Zagorskyi [ 2012 Apr 27 ]

Let's close it as fixed. All strings can be translated already.
Some minor issue will be resolved in the ZBX-4402
CLOSED





[ZBX-3104] Clock element with 'Host time' mode for templated screens. And other errors in screen. Created: 2010 Oct 16  Updated: 2017 May 30  Resolved: 2011 Nov 24

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 1.9.0 (alpha)
Fix Version/s: 1.8.10, 1.9.9 (beta)

Type: Incident report Priority: Blocker
Reporter: Oleksii Zagorskyi Assignee: Unassigned
Resolution: Fixed Votes: 1
Labels: screens, templates
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

from trunk rev 14910. [DEV-483] added templated screens.
my DB schema always correctly updated to corresponding revision.



 Description   

Generally this is very nice feature, thanks.
(3) But try set 'Host time' mode for Clock element for templated screens without selecting Parameter field and save. In bottom of page see error in editor and also in view mode (Monitoring -> Hosts -> Screens).
(1) I think for templated screens this Parameter should be hided.

(4) For not templated screens need to check user select this parameters or not before saving. Try to save without selected host now.
(5) And in pop-up window need filter to real hosts only without templates.

(6) And second serious new problem - now after save element is not updated on screen immediately. It need to click something and return back or refresh page to see changes. The same behavior for column, line add/remove.

(7) In Monitoring -> Hosts need to add single space symbol between Hostname and DNS-name.

(2) And not related only to trunk rev 14910 (something early revision):
In not templated screens "Hostname:" is not presented in Parameter field if you open elements (Simple graph, clock and maybe other). It presented for element Graph and maybe other (but only after save and open element settings again). Try to choose Graph, Simple graph then save and open again and you will understand me.
If you open pop-up window for host selection and try to change host group then you receive error "Warning. Field [submitParent] is not integer".

heh



 Comments   
Comment by Oleksii Zagorskyi [ 2010 Oct 16 ]

Correcting:
In Monitoring -> Hosts need to add single space symbol between IP and DNS-name.

Comment by Oleksii Zagorskyi [ 2010 Oct 16 ]

Templated screen added by "+" button is not presented on Dashboard in 'Favourite screens' widget. And templated screen cannot be added in this widget by using pop-up menu.
And may be templated screen should be available directly in Monitoring -> Screens with filter like an templated graph?

<zalex> answer in the ZBX-3129
CLOSED

Comment by Oleksii Zagorskyi [ 2010 Oct 26 ]

some parts from this is issue request now is resolved in ZBX-3129
and error about "Warning. Field [submitParent] is not integer" (last my sentence in this is issue Description) is not reproducible now.

Comment by Pavels Jelisejevs (Inactive) [ 2011 Nov 17 ]

(1) "I think for templated screens this Parameter should be hided. "
Why? What if I want to create a screen item that displays some data from an item in the same template?

<zalex> Hmm, how the Clock element is able to display some data?
Hard to recall currently what I meant when I created this issue. I guess to hide from the GUI all related to "select "Parameter"".

As you see any templated screen resources (Graph, Plain text, Simple graph) are limited to select "Parameter" only from the same template.
Why the Clock resource doesn't limited in the same way?
I don't have strong opinion in this case. Seems currently I even don't know what "Host time" mode should display

<pavels> The host time displays the local time on the monitored host. It receives data from some special item (can't recall the key), that's why it needs the parameter field. Guess that makes (1) CLOSED.

Regarding the limited choice of items, I posted a separate commend below.

<richlv> system.localtime, i guess

<asaveljevs> Item key is "system.localtime[local]", to be more precise.

<asaveljevs> CLOSED

Comment by Pavels Jelisejevs (Inactive) [ 2011 Nov 17 ]

(2) "If you open pop-up window for host selection and try to change host group then you receive error "Warning. Field [submitParent] is not integer". "
I'm guessing it's already fixed?

<zalex> seems is not reproducible in the Zabbix 1.9.8 r23287

<richlv> this was fixed as ZBX-3042; also, as can be seen in zalex's comment above, dated 2010 Oct 26, he noted that this is not reproducible anymore

CLOSED

Comment by Oleksii Zagorskyi [ 2011 Nov 17 ]

added numbering to description

Comment by Oleksii Zagorskyi [ 2011 Nov 17 ]

(6) and (7) seems are not reproducible in the Zabbix 1.9.8 r23287
CLOSED

Comment by Pavels Jelisejevs (Inactive) [ 2011 Nov 21 ]

(3, 4). I've added validation rules for all screen elements with the "parameter" field. It's now mandatory. RESOLVED.

<asaveljevs> CLOSED

Comment by Pavels Jelisejevs (Inactive) [ 2011 Nov 21 ]

(5) RESOLVED. Plus I've made, that the selection of items for a templated clock should be limited to the items from the template.

<asaveljevs> The popup for selecting an item for clock element shows template's technical name in the upper right corner. It should show the visible name instead.

<pavels> RESOLVED

<asaveljevs> CLOSED

Comment by Aleksandrs Saveljevs [ 2011 Nov 22 ]

(8) File include/screens.inc.php, line 603 puts technical host name into $caption. It should put visible host name instead.

<pavels> RESOLVED

<asaveljevs> OK, but after the item is chosen and the popup is closed, the "Parameter" field in "Screen cell configuration" contains host's technical name.

<pavels> Right. Fixed. RESOLVED.

<asaveljevs> CLOSED

Comment by Aleksandrs Saveljevs [ 2011 Nov 22 ]

(9) Clock element links to zabbix.com. It probably shouldn't.

<asaveljevs> If clock element with "Host time" is present in a templated screen, then on the host level it will try to show data from the item in the template. It should show data from host's item.

<asaveljevs> Also, the clock element shows technical host name. It should show visible host name.

<pavels> i've created a separate issue for these problems ZBX-4378. CLOSED for now.

Comment by Aleksandrs Saveljevs [ 2011 Nov 22 ]

(10) When selecting items for clock and plain text elements, item key column is not shown in the popup.

<pavels> It's never shown when the popup displays items from a single host. Should it be?

<asaveljevs> I think it should. As a server side developer, I don't care how my items are described - I do care about their keys. So when I search the popup, I search for the key, not description.

<pavels> My mistake, the "key" column is displayed for the clock popup, it was only missing in the plain text popup. Fixed it. RESOLVED.

<asaveljevs> CLOSED

Comment by Aleksandrs Saveljevs [ 2011 Nov 22 ]

(11) New file frontends/php/api/classes/class.cscreenitem.php does not have any properties set. It should have svn:eol-style property set to native.

<pavels> RESOLVED

<asaveljevs> CLOSED

Comment by Aleksandrs Saveljevs [ 2011 Nov 22 ]

(12) That new file has text indented with tabs in PHP doc comments. Is that our new convention?

<pavels> I think PHP doc wasn't mentioned in our coding style guidelines, but IMHO it's more readable that way.

<richlv> if something is missing in the conventions/guidelines, it must be added (preferably at https://zabbix.org/wiki/Docs/specs/coding_style)

<pavels> So which style do we choose? With aligned parameter description, or without?

<pavels> We discussed it yesterday and settled for aligned style. Added it to the docs https://zabbix.org/wiki/Docs/specs/coding_style#PHPDoc. RESOLVED.

<asaveljevs> Nice! CLOSED

Comment by Aleksandrs Saveljevs [ 2011 Nov 22 ]

(13) Class Screen uses "if(!is_null($options['countOutput']))" in method get(). However, class ScreenItem uses "if ($options['countOutput'])" directly. Is that OK?

<asaveljevs> Similarly, starting from line 424 and below the code uses different style for checking empty arrays: "if(!empty($hostgroups))" and "if ($hosts)".

<pavels> "is_null()" is not exactly the same as just "if()", but it seems weird, that if we pass, for instance, "countOutput = fallse", "!is_null" will return true, and the "countOption" will be executed.

"if(!empty($hostgroups))" and "if ($hosts)" is the same thing, as long as the $hosts variable is defined.

<asaveljevs> Oh, sure, but it would be nice to use the same style everywhere.

<pavels> I've replaced the API options checks for "is not null" to be consistent with other APIs, but I really see no reason to use the empty() and is_null() functions.

<richlv> ...and we should document in the guidelines which ones should be used

<asaveljevs> You have chosen to use "$var === null" style instead of "is_null($var)" style used elsewhere. Why?

$ grepphp options | grep null | grep -c is.null
1025
grepphp options | grep null | grep -vc is.null
24

<pavels> I, pesonally, think, that the === syntax is more readable, then is_null. E.g. if you check the return value of a function, foo() === null is much better then is_null(foo()) Plus, it's a bit faster then is_null: it doesn't have the overhead of calling a function.

<pavels> Added it to the style guidelines https://zabbix.org/wiki/Docs/specs/coding_style#PHP_conventions RESOLVED.

<asaveljevs> CLOSED

Comment by Aleksandrs Saveljevs [ 2011 Nov 23 ]

(14) Function checkInput() in class ScreenItem does not validate host group for "Data overview" element.

<pavels> RESOLVED.

<asaveljevs> CLOSED

Comment by Aleksandrs Saveljevs [ 2011 Nov 23 ]

(15) Please review my changes regarding formatting and typos in r23453.

<pavels> CLOSED.

Comment by Pavels Jelisejevs (Inactive) [ 2011 Nov 24 ]

Merged to trunk revision r23493.

Comment by Pavels Jelisejevs (Inactive) [ 2011 Nov 24 ]

I've backported the fix for 1.8. It's available at /branches/dev/ZBX-3104-18. Please review.

Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 01 ]

Merged to trunk r23677 and 1.8 r23675.

CLOSED.

Comment by richlv [ 2012 Jan 27 ]

turns out this resulted in a regression for "triggers info" screen element validation, filed as ZBX-4593





[ZBX-2843] slideshow refresh time popup menu too wide Created: 2010 Aug 09  Updated: 2017 May 30  Resolved: 2011 Dec 21

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: None
Fix Version/s: 1.8.10, 1.9.9 (beta)

Type: Incident report Priority: Trivial
Reporter: richlv Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: slideshows, usability
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: JPEG File dashboard.jpg     PNG File menu-trunk.png     PNG File slideshow_refresh.png    
Issue Links:
Duplicate
is duplicated by ZBX-3087 Need a more wide pop-up for 'Create L... Closed

 Description   

see the screenshot. this menu should be half as wide as it currently is



 Comments   
Comment by richlv [ 2011 Nov 16 ]

(2) unfortunately, refresh menu now completely fails in opera 11.52 :

Uncaught exception: TypeError: Cannot convert 'get_style(test_element, 'font-size')' to object
Error thrown at line 11966, column 1 in get_real_text_width(text) in jsLoader.php?ver=1.8.9rc1&lang=en_gb:
var font_size = parseInt(get_style(test_element, 'font-size').split('px')[0]);
called from line 11987, column 2 in show_popup_menu(e, content, width) in jsLoader.php?ver=1.8.9rc1&lang=en_gb:
tmp_width = get_real_text_width(content[i][0]);
called from line 11838, column 1 in create_page_menu(e, id) in jsLoader.php?ver=1.8.9rc1&lang=en_gb:
show_popup_menu(e, dbrd_menu);
called from line 1, column 12 in <anonymous function>(event):
create_page_menu(event,"hat_slides");

<sanja> RESOLVED

<richlv> not sure about mozilla referenced in commit, but works fine in opera now -> CLOSED

Comment by Alexander Sorokin (Inactive) [ 2011 Nov 16 ]

Fixed in development branch svn://svn.zabbix.com/branches/dev/ZBX-2843

Comment by richlv [ 2011 Nov 16 ]

for the record, dev branch rev 23266 works fine in konqueror 4.6 as well

Comment by Igor Danoshaites (Inactive) [ 2011 Nov 16 ]

Checked this change (from dev branch) for the v1.8 when using FF 7.0, IE 8.0, IE 9.0, Opera 11.01, Safari 5.0.3 and Chrome 15 browsers.

Comment by Alexander Sorokin (Inactive) [ 2011 Nov 23 ]

<sanja> Fixed in 1.8 and trunk

Comment by Alexander Vladishev [ 2011 Dec 06 ]

(3) Not all menus are correctly displayed
https://support.zabbix.com/secure/attachment/17592/dashboard.jpg

<sanja> RESOLVED

<pavels> If item names will be too long, the menu won't fit on the screen. We should probably truncate them to some reasonable size. REOPENED.

<sanja> RESOLVED

<pavels> Please review my last commit r23946. After that you can merge. TESTED.

Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 08 ]

(4) [GUI] The text in the menu in the trunk is truncated incorrectly.
https://support.zabbix.com/secure/attachment/17598/menu-trunk.png

<sanja> RESOLVED

<pavels> Merge to 1.8 and then, if there are no conflicts, to the trunk.

Comment by Pavels Jelisejevs (Inactive) [ 2011 Dec 13 ]

TESTED.

Comment by Alexander Sorokin (Inactive) [ 2011 Dec 14 ]

Merged to 1.8 and trunk

Comment by Alexander Vladishev [ 2011 Dec 19 ]

items.php: The menu of creation of trigger expressions isn't displayed

Comment by Alexey Fukalov [ 2011 Dec 20 ]

dev branch: svn://svn.zabbix.com/branches/dev/ZBX-2843

Comment by Alexander Vladishev [ 2011 Dec 20 ]

Tested successfully.

Comment by Alexey Fukalov [ 2011 Dec 20 ]

merged: svn://svn.zabbix.com/branches/1.8 24105

Comment by richlv [ 2011 Dec 21 ]

(5) changelog entry missing in trunk changelog
<Vedmak> thanks

Comment by Alexey Fukalov [ 2011 Dec 21 ]

merged: svn://svn.zabbix.com/trunk 24122





[ZBX-2806] Double notification messages (double-generated alert) Created: 2010 Aug 03  Updated: 2017 May 30  Resolved: 2011 Dec 19

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Server (S)
Affects Version/s: None
Fix Version/s: 1.9.9 (beta)

Type: Incident report Priority: Blocker
Reporter: Oleksii Zagorskyi Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: actions
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

last trunk revision 13781


Attachments: PNG File 1_double_message_#1.png     PNG File 2_double_message_#2.png     Text File 2action.log     PNG File 3_double_message_#3.png     File ZBX-2806-trunk.patch     PNG File rev24046_improvement+DB_usage.png     PNG File rev24046_improvement.png     File zabbix_server_patched.log.gz    

 Description   

See attached screen shot.
I can not understand when and why this happens (there is an assumption that it is connected with the moment when the server updates the cache configuration).
Server debuglog exists and if you want I can send directly to the developers.

My config (easy to understand that in the picture, the problem is not relevant):
DEBUG

{HOSTNAME}

:

{STATUS}

|

{ITEM.NAME}

| EVENT.ID:

{EVENT.ID}

| Server timestamp =

{DATE}

{TIME}

| TRIGGER.NAME:

{TRIGGER.NAME}

***************************************************
ITEM.VALUE1:

{ITEM.VALUE1}

ITEM.LOG.EVENTID1:

{ITEM.LOG.EVENTID1}

ITEM.LOG.SOURCE1:

{ITEM.LOG.SOURCE1}

ITEM.LOG.AGE1:

{ITEM.LOG.AGE1}

***************************************************
ITEM.LASTVALUE1:

{ITEM.LASTVALUE1}

 Comments   
Comment by Oleksii Zagorskyi [ 2010 Aug 19 ]

Sorry, further to the Russian, because a lot of logic and I can make a mistake with the translation

Теперь мне удается воспроизвести проблему боле четко, почти 100% воспроизведение.
Очень важно чтобы время на сервере и агенте было синхронизировано, тогда легко уверенно воспроизвести проблему.
Порядок действий:
Стартуем сервер где то на 55 секунде так чтобы он начал работать ровно на начале минуты!!! То есть чтобы процедура "DCsync_configuration" возникала ровно в начале минуты и мы на это будем ориентироваться.
Ждем ~57-58 секунды на заббикс агенте, стартуем скрипт, который быстро генерирует 100 событий в журнал событий. Агент настроен так что сразу же начинает отсылать события (буфер 1 сек.).
Сервер обрабатывает эскалации в интервале ~0-10 секунд в начале минуты. Где то в это период происходит "DCsync_configuration" или может быть другая процедура вызывает проблему - я точно не уверен.
В журнале аудита видим не 100, а 101 сообщение.

Предварительный итог таков: когда процедура "process_escalations" заканчивает свою работу после окончания процедуры "DCsync_configuration" тогда на последнее уже обработанное событие повторно ошибочно генерируется Алерт при следующем вызове процедуры "process_escalations". Извините если звучит сумбурно, но где то так.

Я подготовил куски лога где видно последовательность как возникает проблема. Там же даны описания между абзацев.
В примере лога (я подготовил его еще вчера) сервер стартовал НЕ начале минуты !!!, поэтому не обращайте внимание на штампы времени.

Comment by Daniel Poßmann [ 2011 Oct 14 ]

could this issue also apply to zabbix 1.8.5?
we have seen double activated actions and also double generated events (so far always 3s between those events). The last time it happened with a trigger that had 8 conditions (8 items, 4 host 2 items each) connected with a logical OR
As far as i understood the google translation of the first comment, it looks like the same issue

Comment by Oleksii Zagorskyi [ 2011 Oct 17 ]

Yes, i managed to reproduce it in the latest trunk rev:
Zabbix Server v1.9.7 (revision 22419) (9 September 2011)
Compilation time: Oct 14 2011 18:05:51

And I'm almost sure that this problem connected to the call of function DCsync_configuration()
New feature of "-R config_cache_reload" helps me a lot to reproduce this problem at the new much faster server than I used early.
I.e. I'm almost lost the hope to reproduce it, but "-R config_cache_reload" finally helped me

Let me some time to figure out some detail in the debuglog.

Comment by Oleksii Zagorskyi [ 2011 Oct 24 ]

How to reproduce:
When zabbix_server massively sends the alerts (values received by Active agent, but maybe it's nor so important), need to execute the configuration cache reloading.

1. Agent bulk sends 50 values to server (one item as "zabbix agent active")
2. I wait ~ 8-10 seconds and server starts to massively send alerts (50 mail).
3. I execute "config_cache_reload" many-many times (interval 200-400 miliseconds) in short time period of time (3-5 seconds)
4. Problem is reproduced -> i have 51 mails in the box.

Comment by dimir [ 2011 Nov 01 ]

Which database?

Comment by Oleksii Zagorskyi [ 2011 Nov 01 ]

> Which database?
My SQL 5.5.8 (FreeBSD), My SQL 5.1.49 (Debian).

Comment by dimir [ 2011 Nov 02 ]

This happens when alerts are created and put to DB, before they are handled. When we receive 50 values 51 alerts are spawned and 51 alert entries are put to DB. So step 2 and 3 can be skipped. I continue working on it.

Comment by dimir [ 2011 Nov 03 ]

This happens when escalations are handled. The conflict is between "escalator" and "history syncer" processes when they access "escalations" table. Continue investigating.

Comment by dimir [ 2011 Nov 03 ]

I have added some logging and here's the difference (both examples of handling escalation ID 2):

NO DUPLICATE EVENTS:
escalator#1:20111103:154956.268 process_escalations() escalid:2 eventid:8451 escstatus:0
escalator#1:20111103:154956.268 process_escalations() escalid:2 status:ACTIVE send mail
escalator#1:20111103:154956.275 process_escalations() escalid:2 status:0 FAILED, set nextcheck
histsyncr#1:20111103:154956.297 process_actions(eventid:8452) add escalation
histsyncr#1:20111103:154956.297 DBstart_escalation(remove older active escalations) actionid:3 and status not in (1,4,5)

DUPLICATE EVENTS:
escalator#1:20111103:123153.535 process_escalations() escalid:2 eventid:8195 escstatus:0
escalator#1:20111103:123153.535 process_escalations() escalid:2 status:ACTIVE send mail
histsyncr#3:20111103:123153.558 process_actions(eventid:8196) add escalation
histsyncr#3:20111103:123153.558 DBstart_escalation(remove older active escalations) actionid:3 and status not in (1,4,5)
escalator#1:20111103:123153.558 process_escalations() escalid:2 status:0 FAILED, set nextcheck

The problem happens when history syncer "intrudes" in while escalator is processing escalation.

Comment by dimir [ 2011 Nov 07 ]

So, the problem is that when escalator is selecting 51 escalations to process, from table containing 50 records. Here is how it happens:

  • [history syncer] is adding 50 escalations one by one, using steps:
    • change current ACTIVE escalations to SUPERSEDED_ACTIVE
    • insert new escalation with status ACTIVE
  • [escalator] selects escalations to process while history syncer is adding escalations, 51 rows are selected:
    • two records are returned with the same escalation ID and event ID:
      • one with status ACTIVE
      • another with status SUPERSEDED_ACTIVE

For the information, this happens also with just 1 dbsyncer, so no dbsyncers conflict.

Comment by dimir [ 2011 Nov 07 ]

From MySQL manual:

http://dev.mysql.com/doc/refman/5.0/en/set-transaction.html#isolevel_repeatable-read

The default isolation level of a transaction is REPEATABLE READ which causes the behavior. If I add the code to set transaction level to READ COMMITTED to only read what is commited:

SET TRANSACTION ISOLATION LEVEL READ COMMITTED

the problem goes away.

Comment by dimir [ 2011 Nov 07 ]

We decided to make our transactions more isolated, by disabling reading uncommitted data explicitly. Related documentation:

http://dev.mysql.com/doc/refman/5.0/en/set-transaction.html
http://www.postgresql.org/docs/9.0/static/transaction-iso.html
http://www.sqlite.org/sharedcache.html (Section "2.2.1 Read-Uncommitted Isolation Mode")

Comment by dimir [ 2011 Nov 07 ]

Fixed in development branch svn://svn.zabbix.com/branches/dev/ZBX-2806 .

How I tested it:

  • create Zabbix trapper item "test.garbage" (default values)
  • create a trigger that will fire when that item receives non-zero with event generation Normal + Multiple PROBLEM events
  • create action that will send e-mail when trigger value is PROBLEM

From console, feed the item with values (you can increase 50 to something bigger):

$ for ((i=0; i<50; i++)); do rnd=$[ $RANDOM % 100 + 1 ]; bin/zabbix_sender -z 127.0.0.1 -s "Zabbix server" -k test.garbage -o $rnd; done

You should be getting exactly 50 e-mails.

Comment by dimir [ 2011 Nov 07 ]

Patch for current trunk (r23016).

Comment by dimir [ 2011 Nov 07 ]

Oleksiy,

I have attached the patch for current trunk, would it be possible for you to test that and confirm that it fixes the problem?

Comment by Oleksii Zagorskyi [ 2011 Nov 08 ]

Vladimir,
unfortunately I have reproduced the bug even for patched version.
Please, let me some time to prepare detailed answer and attach debuglog.

Comment by Oleksii Zagorskyi [ 2011 Nov 08 ]

Currently I must to note that seems it's easier to reproduce the bug with DebugLevel=4 but not 3.
I recall this issue originally was reported and several times reproduced in the past with DebugLevel=4 only.

I tried patched version of latest trunk.
I used the command suggested by Vladimir (50 values sent).
I managed to reproduce the problem for ~30-60% attempts.
When I sent 200 values I was managed to reproduce for 99%.

But right now I tried my "old" method. And it works "even better"
I have little impression that it's easier to reproduce the bug using my method of send bulk values by active agent but not using zabbix_sender in the loop.

When I sent 200 values, I managed to reproduce the problem seems for 100% attempts (sometimes I have 202 alerts).

Huh, sorry for possible not clear comment, but I write it during last day and after several touches this issue.

See attached debuglog.
Duplicated alerts - eventID 671109.

Vladimir, why the issue is resolved?

Comment by dimir [ 2011 Nov 09 ]

Reopening based on comment https://support.zabbix.com/browse/ZBX-2806?focusedCommentId=50012&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-50012

Comment by dimir [ 2011 Nov 17 ]

Move escalations handling to escalator process.

RESOLVED in r23283

Comment by dimir [ 2011 Nov 17 ]

This is a fix for 1.8 so Oleksiy, please wait till it's reviewed, then I'll create a patch for trunk. Merging a fix into trunk produces conflicts, I don't want to resolve them multiple times.

<zalex> I can test any version, trunk or 1.8 branch. Currently I do not need the patch for trunk namely. If it makes sense to test 1.8 branch before code review, please let me know.

<dimir> It would be great if you could try reproducing the bug with current 1.8 branch. Because I couldn't do it. Despite I was hitting the bug in 90% of cases when I used trunk. It's weird, considering that I could not find any differences in escalations handling code in 1.8 and trunk.

Comment by Oleksii Zagorskyi [ 2011 Nov 21 ]

<zalex>
trunk branch:
Zabbix server v1.9.8 (revision 23322) (27 October 2011)
Compilation time: Nov 21 2011 02:56:07
Reproducible as usually.

--->>>> 1.8 branch:
Zabbix Server v1.8.9rc2 (revision 23324) (15 November 2011)
Compilation time: Nov 21 2011 01:36:57
Cannot reproduce for 2000 alerts.

Dev (this) branch:
Zabbix Server v1.8.9rc1 (revision 23283) (11 November 2011)
Compilation time: Nov 21 2011 01:01:30
Cannot reproduce for 2000 alerts.

Vladimir, as you see I cannot reproduce even for 1.8 branch.

Comment by dimir [ 2011 Nov 22 ]

(5) Fix triggerid and r_evnetid fields handling in process_escalations(). These fields are NULL by default in trunk.

<dimir> RESOLVED in r23428, r23431, please check
<sasha> CLOSED

Comment by dimir [ 2011 Nov 22 ]

Fixed in development branch svn://svn.zabbix.com/branches/dev/ZBX-2806-trunk

Comment by dimir [ 2011 Nov 22 ]

Because the fix requires changes in database and it's not reproducible in 1.8 anyway the fix will be only provided for trunk.

Oleksiy, it would be great if you could test svn://svn.zabbix.com/branches/dev/ZBX-2806-trunk .

<zalex>
Dev branch tested.
Debuglog:
21893:20111122:231849.864 In process_escalations()
21893:20111122:231849.864 query [txnlev:0] [select escalationid,actionid,triggerid,eventid,r_eventid,esc_step,status from escalations where (status=0 and nextcheck<=1321996729 or status=2 and r_eventid<>0) ·‡ order by actionid,triggerid,escalationid]
21893:20111122:231849.865 [Z3005] query failed: [1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '·‡ order by actionid,triggerid,escalationid' at line 1 [select escalationid,actionid,triggerid,eventid,r_eventid,esc_step,status from escalations where (status=0 and nextcheck<=1321996729 or status=2 and r_eventid<>0) ·‡ order by actionid,triggerid,escalationid]
21893:20111122:231849.865 End of process_escalations()

Yes, some characters seems are not UTF8. I don't know what is that.
A part in HEX:
00000100 30 29 20 B7 │ 87 8F 15 7F │ 20 6F 72 64 │ 65 72 20 62 0) .. order b

Need to fix and then I'll retest it again.

Comment by dimir [ 2011 Nov 23 ]

(6) As zalex noted, there was a bug in SQL query.

<dimir> RESOLVED in r23450, please retest.

<zalex> r 23450, still error:
1017:20111123:095534.861 In process_escalations()
1017:20111123:095534.861 query [txnlev:0] [select escalationid,actionid,triggerid,eventid,r_eventid,esc_step,status from escalations where (status=0 and nextcheck<=1322034934 or status=2 and r_eventid not null) and escalationid between 000000000000000 and 099999999999999 order by actionid,triggerid,escalationid]
1017:20111123:095534.861 [Z3005] query failed: [1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'null) and escalationid between 000000000000000 and 099999999999999 order by acti' at line 1 [select escalationid,actionid,triggerid,eventid,r_eventid,esc_step,status from escalations where (status=0 and nextcheck<=1322034934 or status=2 and r_eventid not null) and escalationid between 000000000000000 and 099999999999999 order by actionid,triggerid,escalationid]
1017:20111123:095534.862 End of process_escalations()
1017:20111123:095534.862 escalator #1 spent 0.000156 seconds while processing escalations

<dimir> RESOLVED in r23455, sorry, my bad, I should have tested it better.

<zalex> r23455. after 10 000 events the problem is NOT reproducible. Seems it's ready to test|review by developers.

<dimir> Thank you, zalex.
<sasha> CLOSED

Comment by Alexander Vladishev [ 2011 Dec 05 ]

(7) Escalation always is deleted after first step. Following steps will never be executed.

<dimir> That's right, fixed delete escalation condition. RESOLVED in r23813.
<sasha> CLOSED

Comment by Alexander Vladishev [ 2011 Dec 05 ]

(8) Please review my changes in rev 23773.

<dimir> Perfect! CLOSED.

Comment by Alexander Vladishev [ 2011 Dec 07 ]

(9) src/zabbix_server/escalator/escalator.c:1243
I don't like this SQL statement. When I have generated 950 events, notifications have appeared only at 511 of them.

<dimir> RESOLVED in r23905
<Sasha> CLOSED

Comment by Alexander Vladishev [ 2011 Dec 15 ]

(10) Statement "SET DEFINE OFF" doesn't need the line-terminator ';' or '/'. Please remove it from gen_data.pl and help_items.sql.

<dimir> RESOLVED in r24018
<Sasha> CLOSED

Comment by dimir [ 2011 Dec 16 ]

Just a summary of what was done.

Previously escalations were processed by both dbsyncer and escalator. The same records in escalations table were modified by both processes. This was causing a mess and this was not possible to fix without a locking mechanism which we don't have/use (in cases like these). So instead, now dbsyncer only inserts records, which are later modified/removed by escalator process.

This also reduces the workload of dbsyncer which was also an issue.

<richlv> thanks for the description. does http://www.zabbix.com/documentation/2.0/manual/introduction/whatsnew200?&#improved_history_db_syncer_performance summarise it correctly ?
this is something i'd love to test empirically...

<Sasha> Excellent! Thanks!

<zalex> See to the attached picture "rev24046_improvement.png". I suppose the mentioned documentation note has to be reviewed (it seems escalator's work (load) noticeable decreased but not increased) -> REOPENED

<richlv> updated manual according to the testing results (which imply that both escalator & history syncers are more efficient now)

<zalex> Reviewed. I like it, thanks. CLOSED

Comment by Alexander Vladishev [ 2011 Dec 16 ]

Available in version pre-1.9.9, r24046.

Comment by Oleksii Zagorskyi [ 2011 Dec 18 ]

Just for case the last revision of trunk has been tested with big count of alerts (40 000). ALL IS FINE with the server.

Reopened to remove 2.0 from Fix versions and add some interesting results of my experiments.
<zalex> CLOSED

Comment by Oleksii Zagorskyi [ 2011 Dec 19 ]

Reopened to add additional statistic requested by Sasha.
See attached "rev24046_improvement+DB_usage.png"





[ZBX-2701] empty value mappings Created: 2010 Jul 15  Updated: 2017 May 30  Resolved: 2012 Jan 10

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Installation (I)
Affects Version/s: 1.9.9 (beta)
Fix Version/s: 1.9.9 (beta)

Type: Incident report Priority: Blocker
Reporter: Aleksandrs Saveljevs Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified


 Description   

(1) During installation we add empty value mappings: "APC Battery Replacement Status", "APC Battery Status", "Dell Open Manage System Status", "HP Insight System Status".
(2) We cannot "Save" an empty value mapping. This means that had we wanted to change, e.g., name of "APC Battery Replacement Status", it would not be possible to do it. Then again, if we solve (1), then we probably do not need to worry about (2).



 Comments   
Comment by richlv [ 2010 Jul 15 ]

this is already solved in the appliance version - all empty mappings have been populated with proper values.
data.sql from the appliance is planned to be moved in place of the current one after the release of 1.8.3

Comment by Alexei Vladishev [ 2010 Dec 07 ]

Rich,

Can you fix existing data.sql as well?

Comment by richlv [ 2010 Dec 28 ]

maintaining two separate datasets is quite a time sink. while it probably would be possible to move data from appliance version to main data.sql, sql format used is different, so it's not a straightforwards change - it would be better to figure out a method to keep these more or less properly in sync

Comment by Alexei Vladishev [ 2010 Dec 28 ]

I am saying that we have to fix (1) and (2), that's it. No need to sync appliance data with data.sql!

Comment by Aleksandrs Saveljevs [ 2010 Dec 28 ]

Just a reminder that we have agreed earlier this year that we will not be making any significant changes to data.sql in 1.8 and we have even created ZBX-2886.

Comment by richlv [ 2010 Dec 28 ]

1. is a problem, but fixing it is... a twofold problem on it's own
1.1. it's not just copying over a block of text;
1.2. as noted, 1.8 data.sql was mostly frozen;
2. this one most likely isn't an issue - works as intended, does not allow to save empty valuemaps

Comment by Igor Danoshaites (Inactive) [ 2012 Jan 06 ]

we need to fix these empty value mappings in data.sql before releasing v2.0.

Comment by Alexander Vladishev [ 2012 Jan 10 ]

Fixed in the development branch svn://svn.zabbix.com/branches/dev/ZBX-2701

Comment by Alexander Vladishev [ 2012 Jan 11 ]

Fixed in version 1.8.11, revision 24671.





[ZBX-1609] dynamic indexes in SNMP don't work if searched values contain hex string Created: 2009 Dec 23  Updated: 2017 May 30  Resolved: 2012 Jan 16

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: None
Affects Version/s: 1.8
Fix Version/s: 1.8.11, 1.9.9 (beta)

Type: Incident report Priority: Major
Reporter: Vytautas Assignee: dimir
Resolution: Fixed Votes: 5
Labels: snmp, snmpdynamicindex
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

fedora12, zabbix1.8, net-snmp-5.4.2.1-19.fc12.i686


Issue Links:
Duplicate
is duplicated by ZBX-3084 Dynamical indexes only work with OID ... Closed

 Description   

This works:
IF-MIB::ifInOctets["index","IF-MIB::ifDescr","eth0.4"]

But this doesn't work:
IF-MIB::ifInOctets["index","IF-MIB::ifPhysAddress","0:d0:cf:6:3:77"]

1433:20091223:183623.215 Item [10.1.1.1:IF-MIB::ifInOctets["index","ifPhysAddress","0:d0:cf:6:3:77"]] error: Cannot find index [IF-MIB::ifPhysAddress] of the OID [IF-MIB::ifInOctets["index","IF-MIB::ifPhysAddress","0:d0:cf:6:3:77"]]: NOT FOUND: IF-MIB::ifPhysAddress[0:d0:cf:6:3:77]

[root@backup ~]# snmpwalk -v 2c -c aaa 10.1.1.1 IF-MIB::ifInOctets
IF-MIB::ifInOctets.1 = Counter32: 259247
IF-MIB::ifInOctets.2 = Counter32: 0
IF-MIB::ifInOctets.3 = Counter32: 0
IF-MIB::ifInOctets.4 = Counter32: 0
IF-MIB::ifInOctets.5 = Counter32: 0
IF-MIB::ifInOctets.6 = Counter32: 2489979454
IF-MIB::ifInOctets.7 = Counter32: 2557924516
IF-MIB::ifInOctets.8 = Counter32: 0
IF-MIB::ifInOctets.9 = Counter32: 0
IF-MIB::ifInOctets.10 = Counter32: 0
IF-MIB::ifInOctets.11 = Counter32: 3889132176
IF-MIB::ifInOctets.12 = Counter32: 18118273
IF-MIB::ifInOctets.13 = Counter32: 1768038893
IF-MIB::ifInOctets.14 = Counter32: 2109895140

[root@backup ~]# snmpwalk -v 2c -c aaa 10.1.1.1 IF-MIB::ifPhysAddress
IF-MIB::ifPhysAddress.1 = STRING:
IF-MIB::ifPhysAddress.2 = STRING:
IF-MIB::ifPhysAddress.3 = STRING:
IF-MIB::ifPhysAddress.4 = STRING:
IF-MIB::ifPhysAddress.5 = STRING:
IF-MIB::ifPhysAddress.6 = STRING: 0:d0:cf:6:3:73
IF-MIB::ifPhysAddress.7 = STRING: 0:d0:cf:6:3:74
IF-MIB::ifPhysAddress.8 = STRING:
IF-MIB::ifPhysAddress.9 = STRING:
IF-MIB::ifPhysAddress.10 = STRING:
IF-MIB::ifPhysAddress.11 = STRING: 0:d0:cf:6:3:73
IF-MIB::ifPhysAddress.12 = STRING: 0:d0:cf:6:3:77
IF-MIB::ifPhysAddress.13 = STRING: 0:d0:cf:6:3:75
IF-MIB::ifPhysAddress.14 = STRING: 0:d0:cf:6:3:76

[root@backup ~]# snmpwalk -v 2c -c aaa -O0 10.1.1.1 IF-MIB::ifDescr
IF-MIB::ifDescr.1 = STRING: lo
IF-MIB::ifDescr.2 = STRING: teql0
IF-MIB::ifDescr.3 = STRING: tunl0
IF-MIB::ifDescr.4 = STRING: gre0
IF-MIB::ifDescr.5 = STRING: sit0
IF-MIB::ifDescr.6 = STRING: eth0
IF-MIB::ifDescr.7 = STRING: eth1
IF-MIB::ifDescr.8 = STRING: ipsec0
IF-MIB::ifDescr.9 = STRING: ipsec1
IF-MIB::ifDescr.10 = STRING: mast0
IF-MIB::ifDescr.11 = STRING: eth0.1
IF-MIB::ifDescr.12 = STRING: eth0.4
IF-MIB::ifDescr.13 = STRING: eth0.2
IF-MIB::ifDescr.14 = STRING: eth0.3



 Comments   
Comment by Rene Babel [ 2011 Oct 07 ]

Is there any chance we get a fix in 1.8?
I have the same problem, when trying to monitor disk drives in a hp proliant server.

Environment
Debian Linux 6.0.2 (squeeze - current stable)
net-snmp 5.4.3
Zabbix 1.8.8 compiled from source using zabbix proxy

7435:20111007:114844.624 Item [myserver:cpqDrvStatus1] error: Cannot find index [.1.3.6.1.4.1.232.3.2.5.1.1.5.0] of the OID [.1.3.6.1.4.1.232.3.2.5.1.1.6.0["index",".1.3.6.1.4.1.232.3.2.5.1.1.5.0","1"]]: NOT FOUND: .1.3.6.1.4.1.232.3.2.5.1.1.5.0[1]

This command lists the slots, where drives are inserted
snmpwalk -c putyoursnmpcommunityhere -v 2c myserver .1.3.6.1.4.1.232.3.2.5.1.1.5.0
iso.3.6.1.4.1.232.3.2.5.1.1.5.0.0 = INTEGER: 1
iso.3.6.1.4.1.232.3.2.5.1.1.5.0.1 = INTEGER: 2
iso.3.6.1.4.1.232.3.2.5.1.1.5.0.2 = INTEGER: 3
iso.3.6.1.4.1.232.3.2.5.1.1.5.0.3 = INTEGER: 4

And this one lists the actual status of the drives
snmpwalk -c putyoursnmpcommunityhere -v 2c myserver .1.3.6.1.4.1.232.3.2.5.1.1.6.0
iso.3.6.1.4.1.232.3.2.5.1.1.6.0.0 = INTEGER: 2
iso.3.6.1.4.1.232.3.2.5.1.1.6.0.1 = INTEGER: 2
iso.3.6.1.4.1.232.3.2.5.1.1.6.0.2 = INTEGER: 2
iso.3.6.1.4.1.232.3.2.5.1.1.6.0.3 = INTEGER: 2

Comment by richlv [ 2011 Oct 17 ]

most development effort is focused on 2.0 now, so chances of any significant changes appearing in 1.8 are very small

Comment by dimir [ 2012 Jan 09 ]

Added support for non-string value types.

Fixed in development branch svn://svn.zabbix.com/branches/dev/ZBX-1609

Comment by dimir [ 2012 Jan 09 ]

Change "Fix Version/s".

Comment by Alexander Vladishev [ 2012 Jan 16 ]

Successfully tested!

Comment by dimir [ 2012 Jan 16 ]

Fixed in pre-1.8.11 r24798, pre-1.9.9 r24803.

Comment by dimir [ 2012 Jan 16 ]

Reopening to add 1.9.9 to "Fix Version/s".

Comment by dimir [ 2012 Jan 16 ]

Add 1.9.9 to "Fix Version/s".





[ZBX-399] don't show triggers that haven't changed state if expression is changed Created: 2008 Jul 17  Updated: 2017 May 30  Resolved: 2013 Feb 08

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: None
Fix Version/s: 1.9.9 (beta)

Type: Incident report Priority: Major
Reporter: richlv Assignee: Unassigned
Resolution: Won't fix Votes: 1
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

trunk revision 5831


Issue Links:
Duplicate
duplicates ZBXNEXT-1574 Removal of unknown events Closed

 Description   

if a trigger that has FALSE state has it's expression edited, it appears in he trigger list flashing.
it would be nice if such triggers didn't pop up in this list.
rationale :
in an extreme example, imagine some 100+ switches with 24-50 ports each. let's say there's some trigger for each port to watch something (maybe change from full duplex to half duplex, maybe something else ).
if the trigger is slightly tuned, suddenly triggers page is swarmed with flashing true triggers and helpdesk has a large, quite useless page to watch



 Comments   
Comment by richlv [ 2009 Mar 12 ]

another issue is newly added triggers pop up the same way. adding a host with many triggers makes trigger view unusable without frontend hacking :/

Comment by richlv [ 2009 Mar 12 ]

...and the original problem is still there in trunk, revision 6938

Comment by Mārcis Lielturks [ 2009 Nov 20 ]

Changing trigger name also creates flash storm in monitoring->triggers on zabbix 1.6.6

Comment by Alexei Vladishev [ 2010 Dec 28 ]

This is fixed in pre Zabbix 2.0 code (you may check one of 1.9.x already) so that the front-end does not react to unknown events. I am closing it for now.

Comment by richlv [ 2011 Jan 07 ]

unfortunately, this doesn't seem to be fully fixed. i just had lots of triggers have OK->UNKNOWN->OK even sequence, and all of them popped up in monitoring->triggers flashing there

Comment by Alexander Vladishev [ 2013 Feb 08 ]

It becomes not actual after implementation of ZBXNEXT-1574. I'm closing it.





Generated at Thu Apr 18 18:54:06 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.