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

mysql_install_db hangs for ~45 minutes

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Cannot Reproduce
    • 10.5.8
    • N/A
    • Microsoft Windows Server 2019 Datacenter
      10.5.8-MariaDB for Win64 on AMD64 (mariadb.org binary distribution)

    Description

      Steps to reproduce
      Initializing the MariaDB data directory

      C:\Users\Administrator>C:\mariadb-10.5.8-winx64\bin\mysql_install_db.exe --datadir=C:\db
      Running bootstrap
      2020-11-17 11:39:15 0 [Note] C:\mariadb-10.5.8-winx64\bin\mysqld.exe (mysqld 10.5.8-MariaDB) starting as process 2504 ...
      

      Actual Result
      The process hangs for ~ 45 minutes.

      In the log file:

      InnoDB: using atomic writes.
      2020-11-17 11:39:16 0 [Note] InnoDB: The first innodb_system data file 'ibdata1' did not exist. A new tablespace will be created!
      2020-11-17 11:39:16 0 [Note] InnoDB: Uses event mutexes
      2020-11-17 11:39:16 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
      2020-11-17 11:39:16 0 [Note] InnoDB: Number of pools: 1
      2020-11-17 11:39:16 0 [Note] InnoDB: Using SSE4.2 crc32 instructions
      2020-11-17 11:39:16 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
      2020-11-17 11:39:16 0 [Note] InnoDB: Completed initialization of buffer pool
      2020-11-17 11:39:16 0 [Note] InnoDB: Setting file '.\ibdata1' size to 12 MB. Physically writing the file full; Please wait ...
      2020-11-17 11:39:16 0 [Note] InnoDB: File '.\ibdata1' size is now 12 MB.
      2020-11-17 11:39:16 0 [Note] InnoDB: Setting log file .\ib_logfile101 size to 100663296 bytes
      2020-11-17 12:14:23 0 [Note] InnoDB: Renaming log file .\ib_logfile101 to .\ib_logfile0
      2020-11-17 12:14:23 0 [Note] InnoDB: New log file created, LSN=1204865
      2020-11-17 12:14:23 0 [Note] InnoDB: Doublewrite buffer not found: creating new
      2020-11-17 12:14:24 0 [Note] InnoDB: Doublewrite buffer created
      2020-11-17 12:14:24 0 [Note] InnoDB: 128 rollback segments are active.
      2020-11-17 12:14:24 0 [Note] InnoDB: Creating foreign key constraint system tables.
      2020-11-17 12:14:24 0 [Note] InnoDB: Creating tablespace and datafile system tables.
      2020-11-17 12:14:24 0 [Note] InnoDB: Creating sys_virtual system tables.
      2020-11-17 12:14:24 0 [Note] InnoDB: Creating shared tablespace for temporary tables
      2020-11-17 12:14:24 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
      2020-11-17 12:14:24 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
      2020-11-17 12:14:24 0 [Note] InnoDB: 10.5.8 started; log sequence number 0; transaction id 7
      2020-11-17 12:14:24 0 [Note] Plugin 'FEEDBACK' is disabled.
      

      Attachments

        1. mysqld_procmon_events.png
          mysqld_procmon_events.png
          113 kB
        2. WriteFile.CSV
          5 kB
        3. FlushBuffersFile.CSV
          4 kB
        4. stacktraces.txt
          5 kB

        Issue Links

          Activity

            People

              Unassigned Unassigned
              skvoboo Anton Serbulov
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.