Missing create table mysql_statistics in schema.h
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
cmon |
Fix Committed
|
Undecided
|
Unassigned |
Bug Description
The following table definition is missing from schema.h in the 0.13 version
CREATE TABLE IF NOT EXISTS `mysql_statistics` (
mysqlid integer not null,
ABORTED_CLIENTS VARCHAR(255) NOT NULL DEFAULT '0',
ABORTED_CONNECTS VARCHAR(255) NOT NULL DEFAULT '0',
BINLOG_
BINLOG_CACHE_USE VARCHAR(255) NOT NULL DEFAULT '0',
BYTES_RECEIVED VARCHAR(255) NOT NULL DEFAULT '0',
BYTES_SENT VARCHAR(255) NOT NULL DEFAULT '0',
COMPRESSION VARCHAR(255) NOT NULL DEFAULT '0',
COM_ADMIN_COMMANDS VARCHAR(255) NOT NULL DEFAULT '0',
COM_ALTER_DB VARCHAR(255) NOT NULL DEFAULT '0',
COM_ALTER_
COM_ALTER_EVENT VARCHAR(255) NOT NULL DEFAULT '0',
COM_ALTER_FUNCTION VARCHAR(255) NOT NULL DEFAULT '0',
COM_ALTER_PROCEDURE VARCHAR(255) NOT NULL DEFAULT '0',
COM_ALTER_SERVER VARCHAR(255) NOT NULL DEFAULT '0',
COM_ALTER_TABLE VARCHAR(255) NOT NULL DEFAULT '0',
COM_ALTER_
COM_ANALYZE VARCHAR(255) NOT NULL DEFAULT '0',
COM_ASSIGN_
COM_BACKUP_TABLE VARCHAR(255) NOT NULL DEFAULT '0',
COM_BEGIN VARCHAR(255) NOT NULL DEFAULT '0',
COM_BINLOG VARCHAR(255) NOT NULL DEFAULT '0',
COM_CALL_PROCEDURE VARCHAR(255) NOT NULL DEFAULT '0',
COM_CHANGE_DB VARCHAR(255) NOT NULL DEFAULT '0',
COM_CHANGE_MASTER VARCHAR(255) NOT NULL DEFAULT '0',
COM_CHECK VARCHAR(255) NOT NULL DEFAULT '0',
COM_CHECKSUM VARCHAR(255) NOT NULL DEFAULT '0',
COM_COMMIT VARCHAR(255) NOT NULL DEFAULT '0',
COM_CREATE_DB VARCHAR(255) NOT NULL DEFAULT '0',
COM_CREATE_EVENT VARCHAR(255) NOT NULL DEFAULT '0',
COM_CREATE_FUNCTION VARCHAR(255) NOT NULL DEFAULT '0',
COM_CREATE_INDEX VARCHAR(255) NOT NULL DEFAULT '0',
COM_CREATE_
COM_CREATE_SERVER VARCHAR(255) NOT NULL DEFAULT '0',
COM_CREATE_TABLE VARCHAR(255) NOT NULL DEFAULT '0',
COM_CREATE_TRIGGER VARCHAR(255) NOT NULL DEFAULT '0',
COM_CREATE_UDF VARCHAR(255) NOT NULL DEFAULT '0',
COM_CREATE_USER VARCHAR(255) NOT NULL DEFAULT '0',
COM_CREATE_VIEW VARCHAR(255) NOT NULL DEFAULT '0',
COM_DEALLOC_SQL VARCHAR(255) NOT NULL DEFAULT '0',
COM_DELETE VARCHAR(255) NOT NULL DEFAULT '0',
COM_DELETE_MULTI VARCHAR(255) NOT NULL DEFAULT '0',
COM_DO VARCHAR(255) NOT NULL DEFAULT '0',
COM_DROP_DB VARCHAR(255) NOT NULL DEFAULT '0',
COM_DROP_EVENT VARCHAR(255) NOT NULL DEFAULT '0',
COM_DROP_FUNCTION VARCHAR(255) NOT NULL DEFAULT '0',
COM_DROP_INDEX VARCHAR(255) NOT NULL DEFAULT '0',
COM_DROP_PROCEDURE VARCHAR(255) NOT NULL DEFAULT '0',
COM_DROP_SERVER VARCHAR(255) NOT NULL DEFAULT '0',
COM_DROP_TABLE VARCHAR(255) NOT NULL DEFAULT '0',
COM_DROP_TRIGGER VARCHAR(255) NOT NULL DEFAULT '0',
COM_DROP_USER VARCHAR(255) NOT NULL DEFAULT '0',
COM_DROP_VIEW VARCHAR(255) NOT NULL DEFAULT '0',
COM_EMPTY_QUERY VARCHAR(255) NOT NULL DEFAULT '0',
COM_EXECUTE_SQL VARCHAR(255) NOT NULL DEFAULT '0',
COM_FLUSH VARCHAR(255) NOT NULL DEFAULT '0',
COM_GRANT VARCHAR(255) NOT NULL DEFAULT '0',
COM_HA_CLOSE VARCHAR(255) NOT NULL DEFAULT '0',
COM_HA_OPEN VARCHAR(255) NOT NULL DEFAULT '0',
COM_HA_READ VARCHAR(255) NOT NULL DEFAULT '0',
COM_HELP VARCHAR(255) NOT NULL DEFAULT '0',
COM_INSERT VARCHAR(255) NOT NULL DEFAULT '0',
COM_INSERT_SELECT VARCHAR(255) NOT NULL DEFAULT '0',
COM_INSTALL_PLUGIN VARCHAR(255) NOT NULL DEFAULT '0',
COM_KILL VARCHAR(255) NOT NULL DEFAULT '0',
COM_LOAD VARCHAR(255) NOT NULL DEFAULT '0',
COM_LOAD_
COM_LOAD_
COM_LOCK_TABLES VARCHAR(255) NOT NULL DEFAULT '0',
COM_OPTIMIZE VARCHAR(255) NOT NULL DEFAULT '0',
COM_PRELOAD_KEYS VARCHAR(255) NOT NULL DEFAULT '0',
COM_PREPARE_SQL VARCHAR(255) NOT NULL DEFAULT '0',
COM_PURGE VARCHAR(255) NOT NULL DEFAULT '0',
COM_PURGE_
COM_RELEASE_
COM_RENAME_TABLE VARCHAR(255) NOT NULL DEFAULT '0',
COM_RENAME_USER VARCHAR(255) NOT NULL DEFAULT '0',
COM_REPAIR VARCHAR(255) NOT NULL DEFAULT '0',
COM_REPLACE VARCHAR(255) NOT NULL DEFAULT '0',
COM_REPLACE_SELECT VARCHAR(255) NOT NULL DEFAULT '0',
COM_RESET VARCHAR(255) NOT NULL DEFAULT '0',
COM_RESTORE_TABLE VARCHAR(255) NOT NULL DEFAULT '0',
COM_REVOKE VARCHAR(255) NOT NULL DEFAULT '0',
COM_REVOKE_ALL VARCHAR(255) NOT NULL DEFAULT '0',
COM_ROLLBACK VARCHAR(255) NOT NULL DEFAULT '0',
COM_ROLLBACK_
COM_SAVEPOINT VARCHAR(255) NOT NULL DEFAULT '0',
COM_SELECT VARCHAR(255) NOT NULL DEFAULT '0',
COM_SET_OPTION VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_AUTHORS VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_BINLOGS VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_
COM_SHOW_CHARSETS VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_COLLATIONS VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_
COM_SHOW_
COM_SHOW_CREATE_DB VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_
COM_SHOW_
COM_SHOW_
COM_SHOW_
COM_SHOW_
COM_SHOW_DATABASES VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_
COM_SHOW_
COM_SHOW_
COM_SHOW_ERRORS VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_EVENTS VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_FIELDS VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_
COM_SHOW_GRANTS VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_KEYS VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_
COM_SHOW_NEW_MASTER VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_
COM_SHOW_PLUGINS VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_PRIVILEGES VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_
COM_SHOW_
COM_SHOW_PROFILE VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_PROFILES VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_
COM_SHOW_
COM_SHOW_STATUS VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_
COM_SHOW_TABLES VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_
COM_SHOW_TRIGGERS VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_VARIABLES VARCHAR(255) NOT NULL DEFAULT '0',
COM_SHOW_WARNINGS VARCHAR(255) NOT NULL DEFAULT '0',
COM_SLAVE_START VARCHAR(255) NOT NULL DEFAULT '0',
COM_SLAVE_STOP VARCHAR(255) NOT NULL DEFAULT '0',
COM_STMT_CLOSE VARCHAR(255) NOT NULL DEFAULT '0',
COM_STMT_EXECUTE VARCHAR(255) NOT NULL DEFAULT '0',
COM_STMT_FETCH VARCHAR(255) NOT NULL DEFAULT '0',
COM_STMT_PREPARE VARCHAR(255) NOT NULL DEFAULT '0',
COM_STMT_RESET VARCHAR(255) NOT NULL DEFAULT '0',
COM_STMT_
COM_TRUNCATE VARCHAR(255) NOT NULL DEFAULT '0',
COM_UNINSTALL_
COM_UNLOCK_TABLES VARCHAR(255) NOT NULL DEFAULT '0',
COM_UPDATE VARCHAR(255) NOT NULL DEFAULT '0',
COM_UPDATE_MULTI VARCHAR(255) NOT NULL DEFAULT '0',
COM_XA_COMMIT VARCHAR(255) NOT NULL DEFAULT '0',
COM_XA_END VARCHAR(255) NOT NULL DEFAULT '0',
COM_XA_PREPARE VARCHAR(255) NOT NULL DEFAULT '0',
COM_XA_RECOVER VARCHAR(255) NOT NULL DEFAULT '0',
COM_XA_ROLLBACK VARCHAR(255) NOT NULL DEFAULT '0',
COM_XA_START VARCHAR(255) NOT NULL DEFAULT '0',
CONNECTIONS VARCHAR(255) NOT NULL DEFAULT '0',
CREATED_
CREATED_TMP_FILES VARCHAR(255) NOT NULL DEFAULT '0',
CREATED_TMP_TABLES VARCHAR(255) NOT NULL DEFAULT '0',
DELAYED_ERRORS VARCHAR(255) NOT NULL DEFAULT '0',
DELAYED_
DELAYED_WRITES VARCHAR(255) NOT NULL DEFAULT '0',
FLUSH_COMMANDS VARCHAR(255) NOT NULL DEFAULT '0',
HANDLER_COMMIT VARCHAR(255) NOT NULL DEFAULT '0',
HANDLER_DELETE VARCHAR(255) NOT NULL DEFAULT '0',
HANDLER_DISCOVER VARCHAR(255) NOT NULL DEFAULT '0',
HANDLER_PREPARE VARCHAR(255) NOT NULL DEFAULT '0',
HANDLER_READ_FIRST VARCHAR(255) NOT NULL DEFAULT '0',
HANDLER_READ_KEY VARCHAR(255) NOT NULL DEFAULT '0',
HANDLER_READ_NEXT VARCHAR(255) NOT NULL DEFAULT '0',
HANDLER_READ_PREV VARCHAR(255) NOT NULL DEFAULT '0',
HANDLER_READ_RND VARCHAR(255) NOT NULL DEFAULT '0',
HANDLER_
HANDLER_ROLLBACK VARCHAR(255) NOT NULL DEFAULT '0',
HANDLER_SAVEPOINT VARCHAR(255) NOT NULL DEFAULT '0',
HANDLER_
HANDLER_UPDATE VARCHAR(255) NOT NULL DEFAULT '0',
HANDLER_WRITE VARCHAR(255) NOT NULL DEFAULT '0',
KEY_BLOCKS_
KEY_BLOCKS_UNUSED VARCHAR(255) NOT NULL DEFAULT '0',
KEY_BLOCKS_USED VARCHAR(255) NOT NULL DEFAULT '0',
KEY_READS VARCHAR(255) NOT NULL DEFAULT '0',
KEY_READ_REQUESTS VARCHAR(255) NOT NULL DEFAULT '0',
KEY_WRITES VARCHAR(255) NOT NULL DEFAULT '0',
KEY_WRITE_REQUESTS VARCHAR(255) NOT NULL DEFAULT '0',
LAST_QUERY_COST VARCHAR(255) NOT NULL DEFAULT '0',
MAX_USED_
NDB_CLUSTER_
NDB_CLUSTER_NODE_ID VARCHAR(255) NOT NULL DEFAULT '0',
NDB_CONFIG_
NDB_CONFIG_
NDB_CONFLICT_FN_MAX VARCHAR(255) NOT NULL DEFAULT '0',
NDB_CONFLICT_FN_OLD VARCHAR(255) NOT NULL DEFAULT '0',
NDB_CONNECT_COUNT VARCHAR(255) NOT NULL DEFAULT '0',
NDB_EXECUTE_COUNT VARCHAR(255) NOT NULL DEFAULT '0',
NDB_NUMBER_
NDB_NUMBER_
NOT_FLUSHED_
OPENED_FILES VARCHAR(255) NOT NULL DEFAULT '0',
OPENED_TABLES VARCHAR(255) NOT NULL DEFAULT '0',
OPENED_
OPEN_FILES VARCHAR(255) NOT NULL DEFAULT '0',
OPEN_STREAMS VARCHAR(255) NOT NULL DEFAULT '0',
OPEN_TABLES VARCHAR(255) NOT NULL DEFAULT '0',
OPEN_TABLE_
PREPARED_STMT_COUNT VARCHAR(255) NOT NULL DEFAULT '0',
QCACHE_FREE_BLOCKS VARCHAR(255) NOT NULL DEFAULT '0',
QCACHE_FREE_MEMORY VARCHAR(255) NOT NULL DEFAULT '0',
QCACHE_HITS VARCHAR(255) NOT NULL DEFAULT '0',
QCACHE_INSERTS VARCHAR(255) NOT NULL DEFAULT '0',
QCACHE_
QCACHE_NOT_CACHED VARCHAR(255) NOT NULL DEFAULT '0',
QCACHE_
QCACHE_TOTAL_BLOCKS VARCHAR(255) NOT NULL DEFAULT '0',
QUESTIONS VARCHAR(255) NOT NULL DEFAULT '0',
RPL_STATUS VARCHAR(255) NOT NULL DEFAULT '0',
SELECT_FULL_JOIN VARCHAR(255) NOT NULL DEFAULT '0',
SELECT_
SELECT_RANGE VARCHAR(255) NOT NULL DEFAULT '0',
SELECT_RANGE_CHECK VARCHAR(255) NOT NULL DEFAULT '0',
SELECT_SCAN VARCHAR(255) NOT NULL DEFAULT '0',
SLAVE_HEARTBEAT
SLAVE_OPEN_
SLAVE_RECEIVED_
SLAVE_RETRIED_
SLAVE_RUNNING VARCHAR(255) NOT NULL DEFAULT '0',
SLOW_LAUNCH_THREADS VARCHAR(255) NOT NULL DEFAULT '0',
SLOW_QUERIES VARCHAR(255) NOT NULL DEFAULT '0',
SORT_MERGE_PASSES VARCHAR(255) NOT NULL DEFAULT '0',
SORT_RANGE VARCHAR(255) NOT NULL DEFAULT '0',
SORT_ROWS VARCHAR(255) NOT NULL DEFAULT '0',
SORT_SCAN VARCHAR(255) NOT NULL DEFAULT '0',
TABLE_LOCKS_
TABLE_LOCKS_WAITED VARCHAR(255) NOT NULL DEFAULT '0',
TC_LOG_
TC_LOG_PAGE_SIZE VARCHAR(255) NOT NULL DEFAULT '0',
TC_LOG_PAGE_WAITS VARCHAR(255) NOT NULL DEFAULT '0',
THREADS_CACHED VARCHAR(255) NOT NULL DEFAULT '0',
THREADS_CONNECTED VARCHAR(255) NOT NULL DEFAULT '0',
THREADS_CREATED VARCHAR(255) NOT NULL DEFAULT '0',
THREADS_RUNNING VARCHAR(255) NOT NULL DEFAULT '0',
UPTIME VARCHAR(255) NOT NULL DEFAULT '0',
report_ts timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
KEY(mysqlid),
KEY(report_ts)
) engine=myisam
When starting cmon the following occurs.
Jan 26 02:00:52 api1 cmon[18427]: Starting cmon version 0.12 with the following parameters: --mysqldatabase
Jan 26 02:00:52 api1 cmon[18427]: If that doesn't look correct, kill cmon and restart with -? for help on the parameters, or change the params in /etc/init.d/cmon
Jan 26 02:00:52 api1 cmon[18427]: connected to mysqld
Jan 26 02:00:52 api1 cmon[18427]: Table 'backup' exists
Jan 26 02:00:52 api1 cmon[18427]: Table 'backup_log' exists
Jan 26 02:00:52 api1 cmon[18427]: Table 'restore' exists
Jan 26 02:00:52 api1 cmon[18427]: Table 'restore_log' exists
Jan 26 02:00:52 api1 cmon[18427]: Table 'cluster_log' exists
Jan 26 02:00:52 api1 cmon[18427]: Table 'cluster_state' exists
Jan 26 02:00:52 api1 cmon[18427]: Table 'node_state' exists
Jan 26 02:00:52 api1 cmon[18427]: Table 'node_statistics' exists
Jan 26 02:00:52 api1 cmon[18427]: Table 'cluster_
Jan 26 02:00:52 api1 cmon[18427]: Table 'memory_usage' exists
Jan 26 02:00:52 api1 cmon[18427]: Table 'mysql_server' exists
Jan 26 02:00:52 api1 cmon[18427]: Table 'mysql_statistics' did not exist. Schema incomplete. Going to recreate missing tables.
Jan 26 02:00:52 api1 cmon[18427]: Recreating missing tables
schema.h does not appear to have this table defined and the process fails.
description: | updated |
Hello,
Thank you for your bug report and sorry for the inconvenience.
This bug is fixed in cmon-0.13
BR
johan
fortxun wrote: ,`variable_ name`), CACHE_DISK_ USE VARCHAR(255) NOT NULL DEFAULT '0', DB_UPGRADE VARCHAR(255) NOT NULL DEFAULT '0', TABLESPACE VARCHAR(255) NOT NULL DEFAULT '0', TO_KEYCACHE VARCHAR(255) NOT NULL DEFAULT '0', PROCEDURE VARCHAR(255) NOT NULL DEFAULT '0',
> ** Description changed:
>
> The following table definition is missing from schema.h in the 0.13
> version
>
> CREATE TABLE IF NOT EXISTS `mysql_statistics` (
> - `mysqlid` int(11),
> - `variable_name` varchar(255) NOT NULL,
> - `variable_value` varchar(255),
> - `report_ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
> - PRIMARY KEY (`mysqlid`
> - KEY `report_ts` (`report_ts`)
> - ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
> + mysqlid integer not null,
> + ABORTED_CLIENTS VARCHAR(255) NOT NULL DEFAULT '0',
> + ABORTED_CONNECTS VARCHAR(255) NOT NULL DEFAULT '0',
> + BINLOG_
> + BINLOG_CACHE_USE VARCHAR(255) NOT NULL DEFAULT '0',
> + BYTES_RECEIVED VARCHAR(255) NOT NULL DEFAULT '0',
> + BYTES_SENT VARCHAR(255) NOT NULL DEFAULT '0',
> + COMPRESSION VARCHAR(255) NOT NULL DEFAULT '0',
> + COM_ADMIN_COMMANDS VARCHAR(255) NOT NULL DEFAULT '0',
> + COM_ALTER_DB VARCHAR(255) NOT NULL DEFAULT '0',
> + COM_ALTER_
> + COM_ALTER_EVENT VARCHAR(255) NOT NULL DEFAULT '0',
> + COM_ALTER_FUNCTION VARCHAR(255) NOT NULL DEFAULT '0',
> + COM_ALTER_PROCEDURE VARCHAR(255) NOT NULL DEFAULT '0',
> + COM_ALTER_SERVER VARCHAR(255) NOT NULL DEFAULT '0',
> + COM_ALTER_TABLE VARCHAR(255) NOT NULL DEFAULT '0',
> + COM_ALTER_
> + COM_ANALYZE VARCHAR(255) NOT NULL DEFAULT '0',
> + COM_ASSIGN_
> + COM_BACKUP_TABLE VARCHAR(255) NOT NULL DEFAULT '0',
> + COM_BEGIN VARCHAR(255) NOT NULL DEFAULT '0',
> + COM_BINLOG VARCHAR(255) NOT NULL DEFAULT '0',
> + COM_CALL_PROCEDURE VARCHAR(255) NOT NULL DEFAULT '0',
> + COM_CHANGE_DB VARCHAR(255) NOT NULL DEFAULT '0',
> + COM_CHANGE_MASTER VARCHAR(255) NOT NULL DEFAULT '0',
> + COM_CHECK VARCHAR(255) NOT NULL DEFAULT '0',
> + COM_CHECKSUM VARCHAR(255) NOT NULL DEFAULT '0',
> + COM_COMMIT VARCHAR(255) NOT NULL DEFAULT '0',
> + COM_CREATE_DB VARCHAR(255) NOT NULL DEFAULT '0',
> + COM_CREATE_EVENT VARCHAR(255) NOT NULL DEFAULT '0',
> + COM_CREATE_FUNCTION VARCHAR(255) NOT NULL DEFAULT '0',
> + COM_CREATE_INDEX VARCHAR(255) NOT NULL DEFAULT '0',
> + COM_CREATE_
> + COM_CREATE_SERVER VARCHAR(255) NOT NULL DEFAULT '0',
> + COM_CREATE_TABLE VARCHAR(255) NOT NULL DEFAULT '0',
> + COM_CREATE_TRIGGER VARCHAR(255) NOT NULL DEFAULT '0',
> + COM_CREATE_UDF VARCHAR(255) NOT NULL DEFAULT '0',
> + COM_CREATE_USER VARCHAR(255) NOT NULL DEFAULT '0',
>...