Uploaded image for project: 'camunda BPM'
  1. camunda BPM
  2. CAM-9498

Cannot store dates / timestamps after 2038 in MariaDB/MySQL

    Details

    • Type: Bug Report
    • Status: Closed
    • Priority: L3 - Default
    • Resolution: Fixed
    • Affects Version/s: 7.9.0
    • Fix Version/s: 7.11.0, 7.11.0-alpha1
    • Component/s: engine
    • Labels:

      Description

      Currently, we use two different types to store a date value in a MariaDB/MySQL database: TIMESTAMP and DATETIME. The type TIMESTAMP has the limitation that it only works until 2038.

      AT:

      • replace the type TIMESTAMP to allow dates after 2038
      • use one type for all dates in the database

      References:

        Issue Links

          Activity

          philipp.ossler Philipp Ossler created issue -
          philipp.ossler Philipp Ossler made changes -
          Field Original Value New Value
          Affects Version/s 7.9.0 [ 15096 ]
          philipp.ossler Philipp Ossler made changes -
          Link This issue is depended on by SUPPORT-5013 [ SUPPORT-5013 ]
          thorben.lindhauer Thorben Lindhauer made changes -
          Link This issue is related to CAM-9505 [ CAM-9505 ]
          roman.smirnov Smirnov Roman made changes -
          Fix Version/s 7.11.0 [ 15343 ]
          nikola.koevski Nikola Koevski made changes -
          Assignee Nikola Koevski [ nikola.koevski ]
          nikola.koevski Nikola Koevski made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          nikola.koevski Nikola Koevski made changes -
          Status In Progress [ 3 ] Open [ 1 ]
          nikola.koevski Nikola Koevski made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          tassilo.weidner Tassilo Weidner made changes -
          Link This issue is depended on by CAM-9636 [ CAM-9636 ]
          nikola.koevski Nikola Koevski made changes -
          Status In Progress [ 3 ] Resolved [ 5 ]
          Original Estimate 0 minutes [ 0 ]
          Remaining Estimate 0 minutes [ 0 ]
          Assignee Nikola Koevski [ nikola.koevski ] Thorben Lindhauer [ thorben.lindhauer ]
          Resolution Fixed [ 1 ]
          thorben.lindhauer Thorben Lindhauer made changes -
          Resolution Fixed [ 1 ]
          Status Resolved [ 5 ] Reopened [ 4 ]
          Assignee Thorben Lindhauer [ thorben.lindhauer ] Nikola Koevski [ nikola.koevski ]
          nikola.koevski Nikola Koevski made changes -
          Status Reopened [ 4 ] In Progress [ 3 ]
          thorben.lindhauer Thorben Lindhauer made changes -
          Link This issue is duplicated by CAM-9379 [ CAM-9379 ]
          nikola.koevski Nikola Koevski made changes -
          Status In Progress [ 3 ] Resolved [ 5 ]
          Resolution Fixed [ 1 ]
          nikola.koevski Nikola Koevski made changes -
          Assignee Nikola Koevski [ nikola.koevski ] Thorben Lindhauer [ thorben.lindhauer ]
          thorben.lindhauer Thorben Lindhauer made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          thorben.lindhauer Thorben Lindhauer made changes -
          Fix Version/s 7.11.0-alpha1 [ 15370 ]
          thorben.lindhauer Thorben Lindhauer made changes -
          Workflow camunda BPM [ 53668 ] Backup_camunda BPM [ 64128 ]

            People

            • Assignee:
              thorben.lindhauer Thorben Lindhauer
              Reporter:
              philipp.ossler Philipp Ossler
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development