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

Extra logging when innodb_log_archive=ON ( [Note] InnoDB: Read redo log up to LSN=...)

Details

    Description

      A healthy running server prints the following messages, approximately every 16MB of redo log:

      2017-09-10 13:56:21 140493990914816 [Note] InnoDB: Read redo log up to LSN=139157068288
      2017-09-10 14:46:42 140496077253376 [Note] InnoDB: Read redo log up to LSN=139173845504
      2017-09-10 14:57:45 140496085437184 [Note] InnoDB: Read redo log up to LSN=139190622720
      2017-09-10 15:36:40 140496110553856 [Note] InnoDB: Read redo log up to LSN=139207399936
      2017-09-10 15:39:12 140496496207616 [Note] InnoDB: Read redo log up to LSN=139224177152
      2017-09-10 15:59:44 140496504600320 [Note] InnoDB: Read redo log up to LSN=139240954368
      2017-09-10 16:27:30 140493987277568 [Note] InnoDB: Read redo log up to LSN=139257731584
      2017-09-10 16:40:22 140496496207616 [Note] InnoDB: Read redo log up to LSN=139274508800
      2017-09-10 16:55:52 140496335579904 [Note] InnoDB: Read redo log up to LSN=139291286016
      2017-09-10 17:45:49 140496336186112 [Note] InnoDB: Read redo log up to LSN=139308063232
      2017-09-10 18:25:37 140496496207616 [Note] InnoDB: Read redo log up to LSN=139316947456
      2017-09-10 18:51:12 140496496207616 [Note] InnoDB: Read redo log up to LSN=139341617664

      No recovery is in progress, the server is receiving connections and properly working.

      innodb_log_archive=ON
      log_warnings=2

      Attachments

        Issue Links

          is caused by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11027 InnoDB log recovery is too noisy

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14174 crash on start with innodb-track-changed-pages

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            claudio.nanni Claudio Nanni created issue -
            marko Marko Mäkelä made changes -
            Field Original Value New Value
            marko Marko Mäkelä made changes -
            Component/s Storage Engine - XtraDB [ 10135 ]
            Component/s Storage Engine - InnoDB [ 10129 ]
            marko Marko Mäkelä made changes -
            Affects Version/s 10.1.22 [ 22502 ]
            Affects Version/s 10.0.30 [ 22313 ]
            Affects Version/s 5.5.55 [ 22311 ]
            Affects Version/s 10.1.25 [ 22542 ]
            marko Marko Mäkelä made changes -
            Status Open [ 1 ] Confirmed [ 10101 ]
            marko Marko Mäkelä made changes -
            Assignee Marko Mäkelä [ marko ]
            marko Marko Mäkelä made changes -
            Fix Version/s 5.5 [ 15800 ]
            marko Marko Mäkelä made changes -
            Affects Version/s 5.5.55 [ 22311 ]
            marko Marko Mäkelä made changes -
            Fix Version/s 10.0 [ 16000 ]
            Fix Version/s 5.5 [ 15800 ]
            marko Marko Mäkelä made changes -
            Fix Version/s 10.0.33 [ 22552 ]
            Fix Version/s 10.1.27 [ 22609 ]
            Fix Version/s 10.0 [ 16000 ]
            Resolution Fixed [ 1 ]
            Status Confirmed [ 10101 ] Closed [ 6 ]
            marko Marko Mäkelä made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 82601 ] MariaDB v4 [ 152829 ]
            mariadb-jira-automation Jira Automation (IT) made changes -
            Zendesk Related Tickets 125750

            People

              marko Marko Mäkelä
              claudio.nanni Claudio Nanni
              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.