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

          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.