Uploaded image for project: 'Apache Trafodion (Retired)'
  1. Apache Trafodion (Retired)
  2. TRAFODION-2144

Trafodion should use the same time zone for timestamps in all component log files

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 1.3-incubating, 2.0-incubating
    • None
    • dtm
    • None

    Description

      Trafodion has various log files from different components. Currently, different components don't seem to always use the same time zone for timestamps in their log files. For example, as far as I can tell, DTM log file trafodion.dtm.log seems to be using UTC for its timestamps, while SQL log files such as master_exec_xxx.log seem to be using the local time set on the machine.

      In such an example, if the machine time is set to PDT, the timestamps in master_exec_xxx.log would be in PDT and trafodion.dtm.log would be in UTC. This makes it harder to correlate the messages and reestablish the timeline between different components. I imagine eventually this will also make it so much harder to analyze customer's log files.

      We should really make an effort for all components to use the same time zone in the log files across the board.

      To Reproduce:
      Set the machine time zone to something other than UTC. Check trafodion.dtm.log and master_exec_xxx.log in $MY_SQROOT/logs to see their time difference.

      Attachments

        Activity

          People

            Unassigned Unassigned
            atanumishra Atanu Mishra
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: