Bug #100115 Installtion fails
Submitted: 5 Jul 2020 12:22 Modified: 5 Aug 2020 15:26
Reporter: jyuj yjujuyjy Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Installing Severity:S3 (Non-critical)
Version:8.0.20 OS:Windows (Microsoft Windows [Version 10.0.18363.900])
Assigned to: MySQL Verification Team CPU Architecture:Any

[5 Jul 2020 12:22] jyuj yjujuyjy
Description:
I had a problem in my MySQL server, I couldn't open it or the workbench, after I was typing the password the command line client was closing.
So I tried to repair but when running the installer on repair mode I got a message saying I need to install c++ redistributable 2019. I tried to install it but the installer said it already installed, tried to uninstall and reinstall but nothing changed either with the server and the installer. So, I tried to uninstall MySQL but now when I try to reinstall it I get a message: "The configuration for MySQL server 8.0.20 has failed.

The log:

Beginning configuration step: Writing configuration file

Saving my.ini configuration file...
Saved my.ini configuration file.
Ended configuration step: Writing configuration file

Beginning configuration step: Updating Windows Firewall rules

Adding a Windows Firewall rule for MySQL80 on port 3306.
Attempting to add a Windows Firewall rule with command: netsh.exe advfirewall firewall add rule name="Port 3306" protocol=TCP localport=3306 dir=in action=allow
Ok.

Successfully added the Windows Firewall rule.
Adding a Windows Firewall rule for MySQL80 on port 33060.
Attempting to add a Windows Firewall rule with command: netsh.exe advfirewall firewall add rule name="Port 33060" protocol=TCP localport=33060 dir=in action=allow
Ok.

Successfully added the Windows Firewall rule.
Ended configuration step: Updating Windows Firewall rules

Beginning configuration step: Adjusting Windows service

Attempting to grant Network Service require filesystem permissions.
Granted permissions.
Adding new service
New service added
Ended configuration step: Adjusting Windows service

Beginning configuration step: Initializing database (may take a long time)

Deleting the data directory from a previous (failed) configuration...
Attempting to run MySQL Server with --initialize-insecure option...
Starting process for MySQL Server 8.0.20...
Starting process with command: C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe --defaults-file="C:\ProgramData\MySQL\MySQL Server 8.0\my.ini" --console --initialize-insecure=on --lower-case-table-names=1...
'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.20) initializing of server in progress as process 8800
InnoDB initialization has started.
Unable to create temporary file; errno: 0
Assertion failure: lock0lock.cc:315:lock_latest_err_file thread 10044
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
12:08:37 UTC - mysqld got exception 0x80000003 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
Thread pointer: 0x271ad9eaf80
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong... 😨
7ff62955de82    mysqld.exe!?my_errno@@YAHXZ()
7ffcbd2bcb7d    ucrtbase.dll!raise()
7ffcbd2bdb81    ucrtbase.dll!abort()
7ff62975fc60    mysqld.exe!?set_compression_level@Zstd_comp@compression@transaction@binary_log@@UEAAXI@Z()
7ff62972c1cc    mysqld.exe!?set_compression_level@Zstd_comp@compression@transaction@binary_log@@UEAAXI@Z()
7ff6296e3203    mysqld.exe!?set_compression_level@Zstd_comp@compression@transaction@binary_log@@UEAAXI@Z()
7ff629627541    mysqld.exe!?set_compression_level@Zstd_comp@compression@transaction@binary_log@@UEAAXI@Z()
7ff62962242b    mysqld.exe!?set_compression_level@Zstd_comp@compression@transaction@binary_log@@UEAAXI@Z()
7ff6294e57f2    mysqld.exe!?init@Rpl_info_values@@QEAA_NXZ()
7ff6294e8069    mysqld.exe!?init@Rpl_info_values@@QEAA_NXZ()
7ff62876422b    mysqld.exe!?run_bootstrap_thread@bootstrap@@YA_NPEBDPEAUMYSQL_FILE@@P6A_NPEAVTHD@@@ZW4enum_thread_type@@@Z()
7ff6299427b1    mysqld.exe!?set_compression_level@Zstd_comp@compression@transaction@binary_log@@UEAAXI@Z()
7ff62955de1c    mysqld.exe!?my_thread_join@@YAHPEAUmy_thread_handle@@PEAPEAX@Z()
7ffcbd270e82    ucrtbase.dll!_beginthreadex()
7ffcbf067bd4    KERNEL32.DLL!BaseThreadInitThunk()
7ffcbf48ce51    ntdll.dll!RtlUserThreadStart()
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0): 
Connection ID (thread ID): 1
Status: NOT_KILLED
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
Process for mysqld, with ID 8800, was run successfully and exited with code -2147483645.
Failed to start process for MySQL Server 8.0.20.
Database initialization failed.
Ended configuration step: Initializing database (may take a long time)

How to repeat:
idk
[5 Jul 2020 15:26] MySQL Verification Team
Thank you for the bug report. This install is an upgrade or fresh install. If you don`t have data to preserve, then uninstall, delete the data directory (usually on C:\ProgramData\MySQL\MySQL Server 8.0) and then try to re-install.
[6 Aug 2020 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".