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

Introduce debug option innodb_change_buffer_dump

Details

    Description

      To diagnose a hang in slow shutdown (innodb_fast_shutdown=0), let us introduce a Boolean startup option in debug builds that will cause the contents of the InnoDB change buffer to be dumped to the server error log at startup, like this:

      2019-10-19 15:13:40 139865652927488 [Note] InnoDB: Dumping the change buffer
      PHYSICAL RECORD: n_fields 6; 1-byte offsets; info bits 0
       0: len 4; hex 00000004; asc     ;;
       1: len 1; hex 00; asc  ;;
       2: len 4; hex 00000010; asc     ;;
       3: len 16; hex 0000000102fe00010008860300048000; asc                 ;;
       4: len 1; hex 78; asc x;;
       5: len 4; hex 800017c3; asc     ;;
      PHYSICAL RECORD: n_fields 6; 1-byte offsets; info bits 0
       0: len 4; hex 00000004; asc     ;;
       1: len 1; hex 00; asc  ;;
       2: len 4; hex 00000010; asc     ;;
       3: len 16; hex 0031000102fe00010008860300048000; asc  1              ;;
       4: len 1; hex 78; asc x;;
       5: len 4; hex 800017f4; asc     ;;
      2019-10-19 15:13:40 139865652927488 [Note] InnoDB: Dumped the change buffer
      

      Attachments

        Issue Links

          Activity

            marko Marko Mäkelä created issue -
            marko Marko Mäkelä made changes -
            Field Original Value New Value
            issue.field.resolutiondate 2019-10-19 12:24:01.0 2019-10-19 12:24:01.075
            marko Marko Mäkelä made changes -
            Resolution Fixed [ 1 ]
            Status Open [ 1 ] Closed [ 6 ]
            marko Marko Mäkelä made changes -
            julien.fritsch Julien Fritsch made changes -
            Fixing Priority 250
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 100530 ] MariaDB v4 [ 134118 ]
            mariadb-jira-automation Jira Automation (IT) made changes -
            Zendesk Related Tickets 185092

            People

              marko Marko Mäkelä
              marko Marko Mäkelä
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.