Error in 0.14 db schema

Bug #370631 reported by Phil Bayfield
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
cmon
Fix Committed
High
johan

Bug Description

I've just moved cmon to a different MySQL server, let it create it's tables automatically.
There seams to be some columns missing from the MySQL server stats.

I get the error:

Invalid query: Unknown column 'NDB_CLUSTER_NODE_ID' in 'field list'

There are actually no NDB stat columns at all in the new tables.

Are the columns for this tabled generated from the server variables themselves?
The new MySQL server for cmon does not have NDB storage engine, it's a standalone MySQL server.

Changed in cmon:
assignee: nobody → johan (johan-severalnines)
Revision history for this message
johan (johan-severalnines) wrote :

The table mysql_statistics was created dynamically- this was a problem when the cmon database was created in a vanilla mysql server. Now, the mysql_statistics table is created statically at startup.
You are recommended to drop the cmon database and restart again.

Changed in cmon:
importance: Undecided → High
status: New → Fix Committed
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.