Skip to content

Instantly share code, notes, and snippets.

@TimDorand
Created June 2, 2017 08:41
Show Gist options
  • Save TimDorand/8de9cede571cbe2c02e9164765b1c0bb to your computer and use it in GitHub Desktop.
Save TimDorand/8de9cede571cbe2c02e9164765b1c0bb to your computer and use it in GitHub Desktop.
Detailed error MYSQL, cannot open mysql.plugin
mysql_1 | 2017-06-02T08:32:52.623401Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
mysql_1 | 2017-06-02T08:32:52.623440Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
mysql_1 | 2017-06-02T08:32:52.624430Z 0 [Note] mysqld (mysqld 5.7.18) starting as process 8 ...
mysql_1 | 2017-06-02T08:32:52.626653Z 0 [Note] InnoDB: PUNCH HOLE support available
mysql_1 | 2017-06-02T08:32:52.626668Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
mysql_1 | 2017-06-02T08:32:52.626670Z 0 [Note] InnoDB: Uses event mutexes
mysql_1 | 2017-06-02T08:32:52.626672Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
mysql_1 | 2017-06-02T08:32:52.626675Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
mysql_1 | 2017-06-02T08:32:52.626679Z 0 [Note] InnoDB: Using Linux native AIO
mysql_1 | 2017-06-02T08:32:52.626840Z 0 [Note] InnoDB: Number of pools: 1
mysql_1 | 2017-06-02T08:32:52.626916Z 0 [Note] InnoDB: Using CPU crc32 instructions
mysql_1 | 2017-06-02T08:32:52.627925Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
mysql_1 | 2017-06-02T08:32:52.632872Z 0 [Note] InnoDB: Completed initialization of buffer pool
mysql_1 | 2017-06-02T08:32:52.634011Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
mysql_1 | 2017-06-02T08:32:52.644124Z 0 [Note] InnoDB: The first innodb_system data file 'ibdata1' did not exist. A new tablespace will be created!
mysql_1 | 2017-06-02T08:32:52.644547Z 0 [Note] InnoDB: Setting file './ibdata1' size to 12 MB. Physically writing the file full; Please wait ...
mysql_1 | 2017-06-02T08:32:52.681608Z 0 [Note] InnoDB: File './ibdata1' size is now 12 MB.
mysql_1 | 2017-06-02T08:32:52.681920Z 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
mysql_1 | 2017-06-02T08:32:52.858576Z 0 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
mysql_1 | 2017-06-02T08:32:53.036087Z 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
mysql_1 | 2017-06-02T08:32:53.036306Z 0 [Warning] InnoDB: New log files created, LSN=45790
mysql_1 | 2017-06-02T08:32:53.036374Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
mysql_1 | 2017-06-02T08:32:53.036536Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
mysql_1 | 2017-06-02T08:32:53.137090Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
mysql_1 | 2017-06-02T08:32:53.137721Z 0 [Note] InnoDB: Doublewrite buffer not found: creating new
mysql_1 | 2017-06-02T08:32:53.168623Z 0 [Note] InnoDB: Doublewrite buffer created
mysql_1 | 2017-06-02T08:32:53.186808Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
mysql_1 | 2017-06-02T08:32:53.186842Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
mysql_1 | 2017-06-02T08:32:53.187306Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
mysql_1 | 2017-06-02T08:32:53.194769Z 0 [Note] InnoDB: Foreign key constraint system tables created
mysql_1 | 2017-06-02T08:32:53.194832Z 0 [Note] InnoDB: Creating tablespace and datafile system tables.
mysql_1 | 2017-06-02T08:32:53.196788Z 0 [Note] InnoDB: Tablespace and datafile system tables created.
mysql_1 | 2017-06-02T08:32:53.196819Z 0 [Note] InnoDB: Creating sys_virtual system tables.
mysql_1 | 2017-06-02T08:32:53.197643Z 0 [Note] InnoDB: sys_virtual table created
mysql_1 | 2017-06-02T08:32:53.197819Z 0 [Note] InnoDB: Waiting for purge to start
mysql_1 | 2017-06-02T08:32:53.248078Z 0 [Note] InnoDB: 5.7.18 started; log sequence number 0
mysql_1 | 2017-06-02T08:32:53.248820Z 0 [Note] Plugin 'FEDERATED' is disabled.
mysql_1 | mysqld: Table 'mysql.plugin' doesn't exist
mysql_1 | 2017-06-02T08:32:53.249018Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
mysql_1 | 2017-06-02T08:32:53.249562Z 0 [Note] Salting uuid generator variables, current_pid: 8, server_start_time: 1496392372, bytes_sent: 0,
mysql_1 | 2017-06-02T08:32:53.249633Z 0 [Note] Generated uuid: '1206bfb2-476e-11e7-ab68-0242ac120002', server_start_time: 2251801310077628, bytes_sent: 62433424
mysql_1 | 2017-06-02T08:32:53.249651Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 1206bfb2-476e-11e7-ab68-0242ac120002.
mysql_1 | 2017-06-02T08:32:53.251324Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
mysql_1 | 2017-06-02T08:32:53.251403Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
mysql_1 | 2017-06-02T08:32:53.251892Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
mysql_1 | 2017-06-02T08:32:53.251921Z 0 [Note] IPv6 is available.
mysql_1 | 2017-06-02T08:32:53.251932Z 0 [Note] - '::' resolves to '::';
mysql_1 | 2017-06-02T08:32:53.251991Z 0 [Note] Server socket created on IP: '::'.
mysql_1 | 2017-06-02T08:32:53.253929Z 0 [Warning] Failed to open optimizer cost constant tables
mysql_1 |
mysql_1 | 2017-06-02T08:32:53.254142Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
mysql_1 | 2017-06-02T08:32:53.254256Z 0 [ERROR] Aborting
mysql_1 |
mysql_1 | 2017-06-02T08:32:53.254309Z 0 [Note] Binlog end
mysql_1 | 2017-06-02T08:32:53.254368Z 0 [Note] Shutting down plugin 'ngram'
mysql_1 | 2017-06-02T08:32:53.254376Z 0 [Note] Shutting down plugin 'BLACKHOLE'
mysql_1 | 2017-06-02T08:32:53.254382Z 0 [Note] Shutting down plugin 'partition'
mysql_1 | 2017-06-02T08:32:53.254386Z 0 [Note] Shutting down plugin 'ARCHIVE'
mysql_1 | 2017-06-02T08:32:53.254391Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
mysql_1 | 2017-06-02T08:32:53.254398Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
mysql_1 | 2017-06-02T08:32:53.254406Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
mysql_1 | 2017-06-02T08:32:53.254410Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
mysql_1 | 2017-06-02T08:32:53.254418Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
mysql_1 | 2017-06-02T08:32:53.254424Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
mysql_1 | 2017-06-02T08:32:53.254429Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
mysql_1 | 2017-06-02T08:32:53.254435Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
mysql_1 | 2017-06-02T08:32:53.254442Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
mysql_1 | 2017-06-02T08:32:53.254446Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
mysql_1 | 2017-06-02T08:32:53.254451Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
mysql_1 | 2017-06-02T08:32:53.254478Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
mysql_1 | 2017-06-02T08:32:53.254484Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
mysql_1 | 2017-06-02T08:32:53.254489Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
mysql_1 | 2017-06-02T08:32:53.254493Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
mysql_1 | 2017-06-02T08:32:53.254514Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
mysql_1 | 2017-06-02T08:32:53.254534Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
mysql_1 | 2017-06-02T08:32:53.254552Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
mysql_1 | 2017-06-02T08:32:53.254558Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
mysql_1 | 2017-06-02T08:32:53.254562Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
mysql_1 | 2017-06-02T08:32:53.254567Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
mysql_1 | 2017-06-02T08:32:53.254583Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
mysql_1 | 2017-06-02T08:32:53.254589Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
mysql_1 | 2017-06-02T08:32:53.254593Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
mysql_1 | 2017-06-02T08:32:53.254598Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
mysql_1 | 2017-06-02T08:32:53.254616Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
mysql_1 | 2017-06-02T08:32:53.254632Z 0 [Note] Shutting down plugin 'INNODB_CMP'
mysql_1 | 2017-06-02T08:32:53.254639Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
mysql_1 | 2017-06-02T08:32:53.254644Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
mysql_1 | 2017-06-02T08:32:53.254648Z 0 [Note] Shutting down plugin 'INNODB_TRX'
mysql_1 | 2017-06-02T08:32:53.254665Z 0 [Note] Shutting down plugin 'InnoDB'
mysql_1 | 2017-06-02T08:32:53.255132Z 0 [Note] InnoDB: FTS optimize thread exiting.
mysql_1 | 2017-06-02T08:32:53.255445Z 0 [Note] InnoDB: Starting shutdown...
mysql_1 | 2017-06-02T08:32:53.356014Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
mysql_1 | 2017-06-02T08:32:53.357232Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 170602 8:32:53
mysql_1 | 2017-06-02T08:32:54.876013Z 0 [Note] InnoDB: Shutdown completed; log sequence number 1209961
mysql_1 | 2017-06-02T08:32:54.883808Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
mysql_1 | 2017-06-02T08:32:54.883837Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
mysql_1 | 2017-06-02T08:32:54.883845Z 0 [Note] Shutting down plugin 'MyISAM'
mysql_1 | 2017-06-02T08:32:54.883874Z 0 [Note] Shutting down plugin 'CSV'
mysql_1 | 2017-06-02T08:32:54.883891Z 0 [Note] Shutting down plugin 'MEMORY'
mysql_1 | 2017-06-02T08:32:54.883900Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
mysql_1 | 2017-06-02T08:32:54.884033Z 0 [Note] Shutting down plugin 'sha256_password'
mysql_1 | 2017-06-02T08:32:54.884048Z 0 [Note] Shutting down plugin 'mysql_native_password'
mysql_1 | 2017-06-02T08:32:54.884366Z 0 [Note] Shutting down plugin 'binlog'
mysql_1 | 2017-06-02T08:32:54.884953Z 0 [Note] mysqld: Shutdown complete
mysql_1 |
cloud_mysql_1 exited with code 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment