[ZBX-3113] nanoseconds are ignored for trigger functions in trunk Created: 2010 Oct 19  Updated: 2017 May 30  Resolved: 2011 Nov 04

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

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


 Description   

In particular, they do not use nanoseconds when querying history tables.



 Comments   
Comment by Oleksii Zagorskyi [ 2010 Oct 19 ]

I am very interested in nanoseconds what exactly is ignored?
i use function logseverity() and macro

{ITEM.VALUE}

. as result the macro resolved with NS precision in e-mails

Comment by Aleksandrs Saveljevs [ 2010 Oct 20 ]

Good question. The cases you mentioned indeed use nanoseconds. The cases I was referring to are functions last(), prev(), diff(), change(), abschange() - the functions we have fixed recently in ZBX-1038.

Comment by Oleksii Zagorskyi [ 2010 Oct 20 ]

frankly, I can hardly imagine how these functions should or can use a nanosecond. If you can, please describe in a few words, I'll be one of the first beta testers who will test it

Comment by Aleksandrs Saveljevs [ 2010 Oct 20 ]

In the current trunk, history tables have both "clock" and "ns" fields. Function last(#10,1d), for instance, would query a history table to find the 10th last value one day ago, so it has to sort by both clock and nanoseconds.

Comment by Aleksandrs Saveljevs [ 2011 Oct 31 ]

Seems that the problem has already been solved when we implemented the single point of entry for historical data (i.e., function DBget_history()).

Stylistic changes are available in development branch svn://svn.zabbix.com/branches/dev/ZBX-3113 . Please review.

<sasha> REVIEWED Excellent! Please review my small change in r22815.

<asaveljevs> CLOSED

Comment by Aleksandrs Saveljevs [ 2011 Oct 31 ]

We are going to make nanoseconds patch mandatory under this issue.

Comment by Aleksandrs Saveljevs [ 2011 Nov 04 ]

Available in development branch svn://svn.zabbix.com/branches/dev/ZBX-3113 .

Comment by Aleksandrs Saveljevs [ 2011 Nov 08 ]

Available in pre-1.9.8 in r23035.

Generated at Thu May 09 02:44:40 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.