Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-6258

MariaDB 10.0 performance schema timestamps relative to epoch

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 10.0.11
    • 10.0.12
    • None
    • CentOS 6

    Description

      MariaDB 10.0 and MariaDB 10.1 both show this behavior:

      select first_seen, last_seen from performance_schema.events_statements_summary_by_digest;
      		 
      +---------------------+---------------------+
      		 
      | first_seen          | last_seen           |
      		 
      +---------------------+---------------------+
      		 
      | 1970-01-02 22:47:44 | 1970-01-02 22:47:44 |
      		 
      | 1970-01-02 22:47:44 | 1970-01-02 22:47:44 |
      		 
      | 1970-01-02 22:47:44 | 1970-01-02 22:47:44 |
      		 
      | 1970-01-02 22:47:44 | 1970-01-02 22:47:44 |
      		 
      | 1970-01-02 22:47:47 | 1970-01-02 22:47:47 |
      		 
      | 1970-01-02 22:47:47 | 1970-01-02 22:47:47 |
      		 
      | 1970-01-02 22:47:47 | 1970-01-02 22:47:48 |
      		 
      | 1970-01-02 22:47:56 | 1970-01-02 23:06:29 |
      		 
      | 1970-01-02 23:06:49 | 1970-01-02 23:06:49 |
      		 
      +---------------------+---------------------+
      		 
      9 rows in set (0.00 sec)

      This is not a problem in MariaDB 10.0.11 that I built on OS X.

      This also does not exist in MySQL 5.6.17.

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          kolbe Kolbe Kegel (Inactive) created issue -
          kolbe Kolbe Kegel (Inactive) made changes -
          Field Original Value New Value
          Description MariaDB 10.0 and MariaDB 10.1 both show this behavior:

          select first_seen, last_seen from performance_schema.events_statements_summary_by_digest;
          +---------------------+---------------------+
          | first_seen | last_seen |
          +---------------------+---------------------+
          | 1970-01-02 22:47:44 | 1970-01-02 22:47:44 |
          | 1970-01-02 22:47:44 | 1970-01-02 22:47:44 |
          | 1970-01-02 22:47:44 | 1970-01-02 22:47:44 |
          | 1970-01-02 22:47:44 | 1970-01-02 22:47:44 |
          | 1970-01-02 22:47:47 | 1970-01-02 22:47:47 |
          | 1970-01-02 22:47:47 | 1970-01-02 22:47:47 |
          | 1970-01-02 22:47:47 | 1970-01-02 22:47:48 |
          | 1970-01-02 22:47:56 | 1970-01-02 23:06:29 |
          | 1970-01-02 23:06:49 | 1970-01-02 23:06:49 |
          +---------------------+---------------------+
          9 rows in set (0.00 sec)


          This is *not* a problem in MariaDB 10.0.11 that I built on OS X.

          This also does not exist in MySQL 5.6.17.
          		 MariaDB 10.0 and MariaDB 10.1 both show this behavior:

          {noformat}
          select first_seen, last_seen from performance_schema.events_statements_summary_by_digest;
          +---------------------+---------------------+
          | first_seen | last_seen |
          +---------------------+---------------------+
          | 1970-01-02 22:47:44 | 1970-01-02 22:47:44 |
          | 1970-01-02 22:47:44 | 1970-01-02 22:47:44 |
          | 1970-01-02 22:47:44 | 1970-01-02 22:47:44 |
          | 1970-01-02 22:47:44 | 1970-01-02 22:47:44 |
          | 1970-01-02 22:47:47 | 1970-01-02 22:47:47 |
          | 1970-01-02 22:47:47 | 1970-01-02 22:47:47 |
          | 1970-01-02 22:47:47 | 1970-01-02 22:47:48 |
          | 1970-01-02 22:47:56 | 1970-01-02 23:06:29 |
          | 1970-01-02 23:06:49 | 1970-01-02 23:06:49 |
          +---------------------+---------------------+
          9 rows in set (0.00 sec)
          {noformat}

          This is *not* a problem in MariaDB 10.0.11 that I built on OS X.

          This also does not exist in MySQL 5.6.17.
          elenst Elena Stepanova made changes -
          Fix Version/s 10.0.12 [ 15201 ]
          Assignee Michael Widenius [ monty ]
          serg Sergei Golubchik made changes -
          Assignee Michael Widenius [ monty ] Sergei Golubchik [ serg ]
          serg Sergei Golubchik made changes -
          Priority Major [ 3 ] Critical [ 2 ]
          serg Sergei Golubchik made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          serg Sergei Golubchik made changes -
          Resolution Fixed [ 1 ]
          Status In Progress [ 3 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Workflow defaullt [ 40900 ] MariaDB v2 [ 44449 ]
          ratzpo Rasmus Johansson (Inactive) made changes -
          Workflow MariaDB v2 [ 44449 ] MariaDB v3 [ 63802 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 63802 ] MariaDB v4 [ 147903 ]

          People

            serg Sergei Golubchik
            kolbe Kolbe Kegel (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.