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

mysqld process hangs when stopped after executing mysql_upgrade

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 10.5.12
    • Fix Version/s: 10.5.13, 10.6.5
    • Component/s: Server
    • Labels:
    • Environment:
      Windows

      Description

      Steps to reproduce

      1. Initializing the MariaDB data directory

        C:\Users\Administrator>C:\mariadb-10.5.12-winx64\bin\mysql_install_db.exe --datadir=C:\db --service=MyDB --password=secret
        Running bootstrap
        2021-08-09 17:56:17 0 [Note] C:\mariadb-10.5.12-winx64\bin\mysqld.exe (mysqld 10.5.12-MariaDB) starting as process 1212 ...
        Removing default user
        Setting root password
        Creating my.ini file
        Registering service 'MyDB'
        Creation of the database was successful
        

      2. Upload the C:\db\my.ini file

        [mysqld]
        datadir=C:/db
        skip-grant-tables
        skip-networking
        enable-named-pipe
        [client]
        plugin-dir=C:/mariadb-10.5.12-winx64/lib/plugin
        

      3. Start service

        C:\Users\Administrator>sc start MyDB
        

      4. Start mysql_upgrade

        C:\Users\Administrator>C:\mariadb-10.5.12-winx64\bin\mysql_upgrade.exe --force --host=. --protocol=pipe
        Phase 1/7: Checking and upgrading mysql database
        Processing databases
        mysql
        mysql.column_stats                                 OK
        mysql.columns_priv                                 OK
        mysql.db                                           OK
        mysql.event                                        OK
        mysql.func                                         OK
        mysql.global_priv                                  OK
        mysql.gtid_slave_pos                               OK
        mysql.help_category                                OK
        mysql.help_keyword                                 OK
        mysql.help_relation                                OK
        mysql.help_topic                                   OK
        mysql.index_stats                                  OK
        mysql.innodb_index_stats                           OK
        mysql.innodb_table_stats                           OK
        mysql.plugin                                       OK
        mysql.proc                                         OK
        mysql.procs_priv                                   OK
        mysql.proxies_priv                                 OK
        mysql.roles_mapping                                OK
        mysql.servers                                      OK
        mysql.table_stats                                  OK
        mysql.tables_priv                                  OK
        mysql.time_zone                                    OK
        mysql.time_zone_leap_second                        OK
        mysql.time_zone_name                               OK
        mysql.time_zone_transition                         OK
        mysql.time_zone_transition_type                    OK
        mysql.transaction_registry                         OK
        Phase 2/7: Installing used storage engines... Skipped
        Phase 3/7: Fixing views
        mysql.user                                         OK
        Phase 4/7: Running 'mysql_fix_privilege_tables'
        Phase 5/7: Fixing table and database names
        Phase 6/7: Checking and upgrading tables
        Processing databases
        information_schema
        performance_schema
        test
        Phase 7/7: Running 'FLUSH PRIVILEGES'
        OK
        

      5. Stop service

        C:\Users\Administrator>sc stop MyDB
        

      Actual result
      mysqld process hands.
      In the log file:

      2021-08-09 17:56:17 0 [Note] InnoDB: The first innodb_system data file 'ibdata1' did not exist. A new tablespace will be created!
      2021-08-09 17:56:17 0 [Note] InnoDB: Uses event mutexes
      2021-08-09 17:56:17 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
      2021-08-09 17:56:17 0 [Note] InnoDB: Number of pools: 1
      2021-08-09 17:56:17 0 [Note] InnoDB: Using generic crc32 instructions
      2021-08-09 17:56:17 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
      2021-08-09 17:56:17 0 [Note] InnoDB: Completed initialization of buffer pool
      2021-08-09 17:56:17 0 [Note] InnoDB: Setting file '.\ibdata1' size to 12 MB. Physically writing the file full; Please wait ...
      2021-08-09 17:56:17 0 [Note] InnoDB: File '.\ibdata1' size is now 12 MB.
      2021-08-09 17:56:17 0 [Note] InnoDB: Setting log file .\ib_logfile101 size to 100663296 bytes
      2021-08-09 17:56:18 0 [Note] InnoDB: Renaming log file .\ib_logfile101 to .\ib_logfile0
      2021-08-09 17:56:18 0 [Note] InnoDB: New log file created, LSN=10317
      2021-08-09 17:56:18 0 [Note] InnoDB: Doublewrite buffer not found: creating new
      2021-08-09 17:56:18 0 [Note] InnoDB: Doublewrite buffer created
      2021-08-09 17:56:18 0 [Note] InnoDB: 128 rollback segments are active.
      2021-08-09 17:56:18 0 [Note] InnoDB: Creating foreign key constraint system tables.
      2021-08-09 17:56:18 0 [Note] InnoDB: Creating tablespace and datafile system tables.
      2021-08-09 17:56:18 0 [Note] InnoDB: Creating sys_virtual system tables.
      2021-08-09 17:56:18 0 [Note] InnoDB: Creating shared tablespace for temporary tables
      2021-08-09 17:56:18 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
      2021-08-09 17:56:18 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
      2021-08-09 17:56:18 0 [Note] InnoDB: 10.5.12 started; log sequence number 0; transaction id 7
      2021-08-09 17:56:18 0 [Note] Plugin 'FEEDBACK' is disabled.
      2021-08-09 18:00:41 0 [Note] InnoDB: Uses event mutexes
      2021-08-09 18:00:41 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
      2021-08-09 18:00:41 0 [Note] InnoDB: Number of pools: 1
      2021-08-09 18:00:41 0 [Note] InnoDB: Using generic crc32 instructions
      2021-08-09 18:00:41 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
      2021-08-09 18:00:41 0 [Note] InnoDB: Completed initialization of buffer pool
      2021-08-09 18:00:41 0 [Note] InnoDB: 128 rollback segments are active.
      2021-08-09 18:00:41 0 [Note] InnoDB: Creating shared tablespace for temporary tables
      2021-08-09 18:00:41 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
      2021-08-09 18:00:41 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
      2021-08-09 18:00:41 0 [Note] InnoDB: 10.5.12 started; log sequence number 45094; transaction id 20
      2021-08-09 18:00:41 0 [Note] Plugin 'FEEDBACK' is disabled.
      2021-08-09 18:00:41 0 [Note] Reading of all Master_info entries succeeded
      2021-08-09 18:00:41 0 [Note] Added new Master_info '' to hash table
      2021-08-09 18:00:41 0 [Note] C:\mariadb-10.5.12-winx64\bin\mysqld.exe: ready for connections.
      Version: '10.5.12-MariaDB'  socket: ''  port: 0  mariadb.org binary distribution
      2021-08-09 18:00:41 0 [Note] InnoDB: Loading buffer pool(s) from C:\db\ib_buffer_pool
      2021-08-09 18:00:41 0 [Note] InnoDB: Buffer pool(s) load completed at 210809 18:00:41
      2021-08-09 18:02:13 15 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
      2021-08-09 18:04:09 0 [Note] C:\mariadb-10.5.12-winx64\bin\mysqld.exe (initiated by: unknown): Normal shutdown
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              wlad Vladislav Vaintroub
              Reporter:
              skvoboo Anton Serbulov
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration