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

Warning if timezone not specified in Oracle godror client lib

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Unresolved
    • Icon: Trivial Trivial
    • None
    • 7.0.18rc1, 7.4.2rc1, 8.0.0alpha1 (master)
    • Agent2 (G)
    • 1

      Steps to reproduce:

      1. Run Zabbix agent 2
      2. Run zabbix_get with any Oracle key, e.g.:
      zabbix_get -s localhost -p 10050 -k oracle.ping[localhost:1521,ZABBIX_MON,zabbix,xe] 

      Result:
      In the agent's console the warning appears:

      godror WARNING: discrepancy between SESSIONTIMEZONE ("+03:00"=300) and SYSTIMESTAMP ("+00:00"=0) - set connection timezone, see https://github.com/godror/godror/blob/master/doc/timezone.md

      Expected:

      No warning is expected to appear.

      Note:

      1. The same appears if run the agent with Oracle test key:

      {zabbix_agent2 -c /home/leo/zbx/testconf/zabbix_agent2.conf -t oracle.ping[localhost,ZABBIX_MON,zabbix,xe]}

      In this case (bacause of the warning) result is not JSON anymore, e,g, <agent with testkey oracle.tes.stats>| jq returns:

      jq: parse error: Invalid numeric literal at line 1, column 16

       2. The issue was introduced with the ticket ZBX-22374 where Oracle plugin's library github.com/godror/godror was upgraded to v0.48.0.

       

       

            opucka Oskars Pucka
            lsurvilo Leonards Survilo
            Team INT
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - Not Specified
                Not Specified
                Logged:
                Time Spent - 1h
                1h