Error in 0.14 db schema

Bug #370631 reported by Phil Bayfield on 2009-05-02
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
cmon
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)
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  Edit
Everyone can see this information.

Other bug subscribers