SQL errors seen in Windows application logs

Document ID : KB000006635
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

After upgrading Spectrum on Windows, SQL errors are seen in Windows application logs similar to the following:

Event 100, MySQL 
Native table 'performance_schema' has the wrong structure 

 

Environment:
Spectrum running on Windows OS
Cause:

Probable corruption in the database schema.

Resolution:

Reinstall the last major install of Spectrum and then any PTF or debug patches installed.

For example, if running Spectrum 10.2.1 with post PTF or debug patches installed, reinstall Spectrum 10.2.1 and then the post PTF or debug patches installed after Spectrum 10.2.1 previously.

Before reinstalling:

  1. Ensure ALL of the Spectrum processes and services, other than the SRAdmin, are shutdown. 
  2. Launch the Windows Task Manager and ensure there are no mysql processes running
  3. Ensure the ONLY mysql that is installed is the mysql for Spectrum