Submitted by ryan.grace on February 1, 2023 - 10:41pm
Overview:
Not possible to install XPERTrak due to the "mySQL is still in use" error
Solution Steps:
SOMETHING (user, service, background process, etc.) has a lock on one of the MySQL executables.Hopefully one of the following tools may help to identify the culprit:https://docs.microsoft.com/en-us/sysinternals/downloads/process-explorerhttps://helpcenter.gsx.com/hc/en-us/articles/115015880627-How-to-Identify-which-Windows-Process-is-Locking-a-File-or-FolderSearch for something using one of these files: mysqld.exe, mysql.exe, mysqladmin.exe, mysqldump.exeIf you still can’t find the culprit, then try this drastic step:
- Run the installer, wait for it to create the backup and display the “MySQL is still in use” error message, then quit the installer.
- Stop the XPERTrak services (xpt-tomcat, xpt-mysql).
- Navigate to the folder: C:\Program Files\VIAVI Solutions\XPERTrak 2.1\mysql
- Delete the sub-folder: bin
- Re-boot the server
- Run the installer
- Ignore the warning that it could not create a backup (we have already created the backup in step 1 above)
- Ignore the warning that it completed the backup but some errors occurred
- Start the XPERTrak services (xpt-mysql, xpt-tomcat)
- File/folder already exists
- File/folder is a file
- File/folder is in-use