Uploaded image for project: 'Data Management'
  1. Data Management
  2. DM-7726

Fix MySQL Incorrect date time value warning in ctrl_stats

    Details

    • Type: Story
    • Status: Done
    • Resolution: Done
    • Fix Version/s: None
    • Component/s: ctrl_stats
    • Labels:
      None

      Description

      in Mysql 5.7, the warning

      /home/srp/lsstsw27/lsstsw/stack/Linux64/cat/12.1.rc1-3-g00b8a9c+1/python/lsst/cat/MySQLBase.py:158: Warning: Incorrect datetime value: '0000-00-00 00:00:00' for column 'executionStartTime' at row 1

      is emitted.

      This is because of a change in MySQL 5.7 about how '0000-00-00 00:00:00" dates are handled.

        Attachments

          Activity

            People

            • Assignee:
              spietrowicz Steve Pietrowicz
              Reporter:
              spietrowicz Steve Pietrowicz
              Reviewers:
              Hsin-Fang Chiang
              Watchers:
              Hsin-Fang Chiang, Steve Pietrowicz
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Summary Panel