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"

    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

              • Assignee:
                Unassigned
                Reporter:
                Marappa Ganesan
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: