Ad Widget

Collapse

Agent 2 Oracle plugin incorrect value after switching from summer time to winter time

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • 51m0n
    Junior Member
    • Oct 2022
    • 1

    #1

    Agent 2 Oracle plugin incorrect value after switching from summer time to winter time

    Hello
    we are using zabbix_agent2 oracle plugin to select an timestamp from oracle database in unix timestamp format.
    Since last time change from Sun 2022-10-30 02:59:59 CEST to Sun 2022-10-30 02:00:00 CET the value response was incorrect.
    It seems to be zabbix agent 2 is sending an incorrect value.
    After restarting the agent service the correct value was received by zabbix server.
    The timestamp changes every 30 minutes.
    Here is the cutout from zabbix item values (from newest to oldest/read from below up):

    Timestamp | Value
    2022-10-31 14:32:20 1667223140 | 1667223020 Mon Oct 31 14:30:20 CET 2022
    2022-10-31 14:02:20 1667221340 | 1667221247 Mon Oct 31 14:00:47 CET 2022
    2022-10-31 13:53:15 1667220795 | 1667219419 Mon Oct 31 13:30:19 CET 2022
    restart zabbix-agent2
    2022-10-31 13:52:20 1667220740 | 1667215819 Mon Oct 31 12:30:19 CET 2022
    .
    .
    .
    .
    .
    2022-10-30 04:02:20 1667098940 | 1667095272 Sun Oct 30 03:01:12 CET 2022
    2022-10-30 03:32:20 1667097140 | 1667093418 Sun Oct 30 02:30:18 CET 2022
    2022-10-30 03:07:20 1667095640 | 1667091660 Sun Oct 30 02:01:00 CET 2022
    time change Sun 2022-10-30 02:59:59
    2022-10-30 02:47:20 1667094440 | 1667088056 Sun Oct 30 02:00:56 CEST 2022

    Environment:
    zabbix_agent2 (Zabbix) 5.0.28
    Revision b2b8e2ce82d 19 September 2022, compilation time: Sep 19 2022 12:47:22
    zabbix_server (Zabbix) 5.0.28
    Revision b2b8e2ce82d 19 September 2022, compilation time: Sep 19 2022 09:47:43

    The restart resolved my problem. But perhaps you are interested​ in this topic.
    Kind regards
    Simon

    ​
Working...