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

mysql_install_db hangs for ~45 minutes

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. FlushBuffersFile.CSV
          4 kB
        2. mysqld_procmon_events.png
          mysqld_procmon_events.png
          113 kB
        3. stacktraces.txt
          5 kB
        4. WriteFile.CSV
          5 kB

        Issue Links

          Activity

            skvoboo Anton Serbulov added a comment - - edited

            The issue is still persists on our environment.

            skvoboo Anton Serbulov added a comment - - edited The issue is still persists on our environment.

            skvoboo,

            So, if you have verified that the issue is specific to your environment, can you provide the details of the environment which cause it, so that wlad would be able to reproduce it elsewhere?

            elenst Elena Stepanova added a comment - skvoboo , So, if you have verified that the issue is specific to your environment, can you provide the details of the environment which cause it, so that wlad would be able to reproduce it elsewhere?

            Our environment: Parallels Cloud Server 6.0

            skvoboo Anton Serbulov added a comment - Our environment: Parallels Cloud Server 6.0

            skvoboo, if the issue persists in your environment, and nowhere else, perhaps, you like to talk to Parallels Cloud Server people about it.

            wlad Vladislav Vaintroub added a comment - skvoboo , if the issue persists in your environment, and nowhere else, perhaps, you like to talk to Parallels Cloud Server people about it.

            Seems to be not our bug, but related to exotic environment. No storage related system call should take 45 minutes.

            wlad Vladislav Vaintroub added a comment - Seems to be not our bug, but related to exotic environment. No storage related system call should take 45 minutes.

            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.