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

MariaDB 10.1.19 - Error log - every 4 seconds error message "clustered index of the table and create temporary files"

    XMLWordPrintable

Details

    Description

      Every 4 seconds following errors logged in to error log.
      I tried setting Global Variable

      log_warnings=2
      and tried
      log_warnings=3

      and tried
      log_warnings=0

      irrespective of setting above , the below error message continues
      =======================================================================================

      2017-03-21 14:42:20 12860 [Note] InnoDB: Online DDL : Start
      2017-03-21 14:42:20 12860 [Note] InnoDB: Online DDL : Start reading clustered index of the table and create temporary files
      2017-03-21 14:42:20 12860 [Note] InnoDB: Online DDL : End of reading clustered index of the table and create temporary files
      2017-03-21 14:42:20 12860 [Note] InnoDB: Online DDL : Start merge-sorting index `id`-temporary- (1 / 1), estimated cost : 20.0000
      2017-03-21 14:42:20 12860 [Note] InnoDB: Online DDL : End of merge-sorting index `id`-temporary- (1 / 1)
      2017-03-21 14:42:20 12860 [Note] InnoDB: Online DDL : Start building index `id`-temporary- (1 / 1), estimated cost : 30.0000
      2017-03-21 14:42:20 12860 [Note] InnoDB: Online DDL : End of building index `id`-temporary- (1 / 1)
      2017-03-21 14:42:20 12860 [Note] InnoDB: Online DDL : Start applying row log
      2017-03-21 14:42:20 12860 [Note] InnoDB: Online DDL : End of applying row log
      2017-03-21 14:42:20 12860 [Note] InnoDB: Online DDL : Completed

      =======================================================================================

      Following statement is inside a stored procedure and the procedure is called in
      scheduled event that repeats every on minute.
      do you think following statement may be the reason for the above messages continuously in the error log

      CREATE TEMPORARY TABLE tableau_reporting.temp310
      SELECT id,
      (SELECT rh FROM v1dm10_temp_hum_90days b WHERE b.id = a.id - 1) AS RH1,
      (SELECT rh FROM v1dm10_temp_hum_90days b WHERE b.id = a.id - 2) AS RH2,
      (SELECT rh FROM v1dm10_temp_hum_90days b WHERE b.id = a.id - 3) AS RH3,
      (SELECT rh FROM v1dm10_temp_hum_90days b WHERE b.id = a.id - 4) AS RH4,
      (SELECT RH_Zero_Counter FROM v1dm10_temp_hum_90days b WHERE b.id = a.id - 1) AS Sum1,
      (SELECT RH_Zero_Counter FROM v1dm10_temp_hum_90days b WHERE b.id = a.id - 2) AS Sum2,
      (SELECT RH_Zero_Counter FROM v1dm10_temp_hum_90days b WHERE b.id = a.id - 3) AS Sum3,
      (SELECT RH_Zero_Counter FROM v1dm10_temp_hum_90days b WHERE b.id = a.id - 4) AS Sum4
      FROM v1dm10_temp_hum_90days a
      WHERE RH_Zero_Counter = 1 ;

      CREATE INDEX id
      ON tableau_reporting.temp310(id);

      =======================================================================================

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              Marappa Ganesan
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.