Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

when I debug mysqld,but the mysqld failed #81

Open
XUZHOUWANG opened this issue Feb 11, 2018 · 1 comment
Open

when I debug mysqld,but the mysqld failed #81

XUZHOUWANG opened this issue Feb 11, 2018 · 1 comment

Comments

@XUZHOUWANG
Copy link

2018-02-10 18:45:32 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-02-10 18:45:32 0 [Note] /home/abc/c/mariadb/alisql/AliSQL-AliSQL-5.6.32-8/sql/mysqld (mysqld 5.6.32-debug) starting as process 80896 ...
2018-02-10 18:45:32 80896 [Warning] Buffered warning: Changed limits: max_open_files: 4096 (requested 5000)

2018-02-10 18:45:32 80896 [Warning] Buffered warning: Changed limits: table_open_cache: 1967 (requested 2000)

2018-02-10 18:45:32 80896 [Note] Plugin 'FEDERATED' is disabled.
/home/abc/c/mariadb/alisql/AliSQL-AliSQL-5.6.32-8/sql/mysqld: Table 'mysql.plugin' doesn't exist
2018-02-10 18:45:32 80896 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
Transparent huge pages are enabled, according to /sys/kernel/mm/transparent_hugepage/enabled
2018-02-10 18:45:32 80896 [ERROR] TokuDB: Huge pages are enabled, disable them before continuing

2018-02-10 18:45:32 80896 [ERROR] ************************************************************
2018-02-10 18:45:32 80896 [ERROR]
2018-02-10 18:45:32 80896 [ERROR] @@@@@@@@@@@
2018-02-10 18:45:32 80896 [ERROR] @@' '@@
2018-02-10 18:45:32 80896 [ERROR] @@ _ _ @@
2018-02-10 18:45:32 80896 [ERROR] | (.) (.) |
2018-02-10 18:45:32 80896 [ERROR] | ` |
2018-02-10 18:45:32 80896 [ERROR] | > ' |
2018-02-10 18:45:32 80896 [ERROR] | .----. |
2018-02-10 18:45:32 80896 [ERROR] .. |.----.| ..
2018-02-10 18:45:32 80896 [ERROR] .. ' ' ..
2018-02-10 18:45:32 80896 [ERROR] .._______,.
2018-02-10 18:45:32 80896 [ERROR]
2018-02-10 18:45:32 80896 [ERROR] TokuDB will not run with transparent huge pages enabled.
2018-02-10 18:45:32 80896 [ERROR] Please disable them to continue.
2018-02-10 18:45:32 80896 [ERROR] (echo never > /sys/kernel/mm/transparent_hugepage/enabled)
2018-02-10 18:45:32 80896 [ERROR]
2018-02-10 18:45:32 80896 [ERROR] ************************************************************
2018-02-10 18:45:32 80896 [ERROR] Plugin 'TokuDB' init function returned error.
2018-02-10 18:45:32 80896 [ERROR] Plugin 'TokuDB' registration as a STORAGE ENGINE failed.
2018-02-10 18:45:32 80896 [Note] InnoDB: Using atomics to ref count buffer pool pages
2018-02-10 18:45:32 7f3a7251b840 InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!
2018-02-10 18:45:32 7f3a7251b840 InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!!
2018-02-10 18:45:32 80896 [Note] InnoDB: The InnoDB memory heap is disabled
2018-02-10 18:45:32 80896 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-02-10 18:45:32 80896 [Note] InnoDB: Memory barrier is not used
2018-02-10 18:45:32 80896 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-02-10 18:45:32 80896 [Note] InnoDB: Using Linux native AIO
2018-02-10 18:45:32 80896 [Note] InnoDB: Using CPU crc32 instructions
2018-02-10 18:45:32 80896 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2018-02-10 18:45:32 80896 [Note] InnoDB: Completed initialization of buffer pool
2018-02-10 18:45:32 80896 [Note] InnoDB: Highest supported file format is Barracuda.
2018-02-10 18:45:33 80896 [Note] InnoDB: 128 rollback segment(s) are active.
2018-02-10 18:45:33 80896 [Note] InnoDB: Waiting for purge to start
2018-02-10 18:45:33 80896 [Note] InnoDB: 5.6.32 started; log sequence number 1600607
2018-02-10 18:45:33 80896 [ERROR] Failed to initialize plugins.
2018-02-10 18:45:33 80896 [ERROR] Aborting

2018-02-10 18:45:33 80896 [Note] Binlog end
2018-02-10 18:45:33 80896 [Note] Shutting down plugin 'partition'
2018-02-10 18:45:33 80896 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2018-02-10 18:45:33 80896 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2018-02-10 18:45:33 80896 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2018-02-10 18:45:33 80896 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2018-02-10 18:45:33 80896 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2018-02-10 18:45:33 80896 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2018-02-10 18:45:33 80896 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2018-02-10 18:45:33 80896 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2018-02-10 18:45:33 80896 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2018-02-10 18:45:33 80896 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2018-02-10 18:45:33 80896 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2018-02-10 18:45:33 80896 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2018-02-10 18:45:33 80896 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2018-02-10 18:45:33 80896 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2018-02-10 18:45:33 80896 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2018-02-10 18:45:33 80896 [Note] Shutting down plugin 'INNODB_METRICS'
2018-02-10 18:45:33 80896 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2018-02-10 18:45:33 80896 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2018-02-10 18:45:33 80896 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2018-02-10 18:45:33 80896 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2018-02-10 18:45:33 80896 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2018-02-10 18:45:33 80896 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2018-02-10 18:45:33 80896 [Note] Shutting down plugin 'INNODB_CMPMEM'
2018-02-10 18:45:33 80896 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2018-02-10 18:45:33 80896 [Note] Shutting down plugin 'INNODB_CMP'
2018-02-10 18:45:33 80896 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2018-02-10 18:45:33 80896 [Note] Shutting down plugin 'INNODB_LOCKS'
2018-02-10 18:45:33 80896 [Note] Shutting down plugin 'INNODB_TRX'
2018-02-10 18:45:33 80896 [Note] Shutting down plugin 'INNODB_RSEG'
2018-02-10 18:45:33 80896 [Note] Shutting down plugin 'InnoDB'
2018-02-10 18:45:33 80896 [Note] InnoDB: FTS optimize thread exiting.
2018-02-10 18:45:33 80896 [Note] InnoDB: Starting shutdown...
2018-02-10 18:45:35 80896 [Note] InnoDB: Shutdown completed; log sequence number 1600617
2018-02-10 18:45:35 80896 [Note] Shutting down plugin 'BLACKHOLE'
2018-02-10 18:45:35 80896 [Note] Shutting down plugin 'ARCHIVE'
2018-02-10 18:45:35 80896 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2018-02-10 18:45:35 80896 [Note] Shutting down plugin 'sequence'
2018-02-10 18:45:35 80896 [Note] Shutting down plugin 'MRG_MYISAM'
2018-02-10 18:45:35 80896 [Note] Shutting down plugin 'CSV'
2018-02-10 18:45:35 80896 [Note] Shutting down plugin 'MEMORY'
2018-02-10 18:45:35 80896 [Note] Shutting down plugin 'TokuDB_fractal_tree_block_map'
2018-02-10 18:45:35 80896 [Note] Shutting down plugin 'TokuDB_fractal_tree_info'
2018-02-10 18:45:35 80896 [Note] Shutting down plugin 'TokuDB_file_map'
2018-02-10 18:45:35 80896 [Note] Shutting down plugin 'TokuDB_locks'
2018-02-10 18:45:35 80896 [Note] Shutting down plugin 'TokuDB_lock_waits'
2018-02-10 18:45:35 80896 [Note] Shutting down plugin 'TokuDB_trx'
2018-02-10 18:45:35 80896 [Note] Shutting down plugin 'sha256_password'
2018-02-10 18:45:35 80896 [Note] Shutting down plugin 'mysql_old_password'
2018-02-10 18:45:35 80896 [Note] Shutting down plugin 'mysql_native_password'
2018-02-10 18:45:35 80896 [Note] Shutting down plugin 'binlog'
2018-02-10 18:45:35 80896 [Note] Shutting down plugin 'MyISAM'
2018-02-10 18:45:35 80896 [Note] /home/abc/c/mariadb/alisql/AliSQL-AliSQL-5.6.32-8/sql/mysqld: Shutdown complete

RUN FINISHED; exit value 1; real time: 4s; user: 1s; system: 270ms

i don't know how to resolve the problem "/home/abc/c/mariadb/alisql/AliSQL-AliSQL-5.6.32-8/sql/mysqld: Table 'mysql.plugin' doesn't exist
2018-02-10 18:45:32 80896 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it."

@zhangxiaojian
Copy link
Collaborator

Hi, @XUZHOUWANG , Please check if the file "plugin.frm" exists in DATADIR/mysql . If not, you can try to use mysql_upgrad to reinstall or use mysql_install_db to initial your DATADIR.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants