ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

mysql upgrade fails during Spectrum upgrade.

book

Article ID: 41278

calendar_today

Updated On:

Products

CA Spectrum

Issue/Introduction

mysql upgrade fatal error on Spectrum upgrade, shows no errors in the post install log but the following fatal error is in the mysql log.

Error: Server version (x.x.x-enterprise-commercial-advanced) does not match with the version of the server (x.x.x) with which this program was built/distributed. You can use --skip-version-check to skip this check. 

FATAL ERROR: Upgrade failed 

Cause

This error can be caused for many reasons and is usually environmental such AV running and holding the file in question, or a lag in the OS.

e.g. here the procmon log file shows a problem when deleting/overwriting the $SPECROOT/mysql/bin/mysql.exe file. 

We see the DELETE PENDING in the procmon, therefore when the cp command tries to copy the file, the Permission denied error occurs and the new copy of mysql.exe is not written to the bin directory. 

Environment

Release: Any version of Spectrum running on Windows
Component:

Resolution

Reinstall the current version of Spectrum on top of the current install, after removing the old mysql as follows:

  •  Stop all Spectrum services (processd, tomcat, spectroSERVER) 
  •  Delete the ./mysql/bin directory
  •  Uninstill the spectrum mysql service 
  •  Reboot the server
  •  Re-run the current install of Spectrum