全球主机交流论坛

标题: 求教，mysql无法启动，报错，请问如何解决啊 [打印本页]

作者: dqlb123 时间: 2021-1-3 16:42
标题: 求教，mysql无法启动，报错，请问如何解决啊
求教，mysql无法启动，报错，请问如何解决啊

2021-01-03 16:39:33 25990 [Warning] You need to use --log-bin to make --log-slave-updates work.
2021-01-03 16:39:33 25990 [Note] Plugin 'FEDERATED' is disabled.
2021-01-03 16:39:33 25990 [Note] InnoDB: Using atomics to ref count buffer pool pages
2021-01-03 16:39:33 25990 [Note] InnoDB: The InnoDB memory heap is disabled
2021-01-03 16:39:33 25990 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-01-03 16:39:33 25990 [Note] InnoDB: Memory barrier is not used
2021-01-03 16:39:33 25990 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-01-03 16:39:33 25990 [Note] InnoDB: Using Linux native AIO
2021-01-03 16:39:33 25990 [Note] InnoDB: Using CPU crc32 instructions
2021-01-03 16:39:33 25990 [Note] InnoDB: Initializing buffer pool, size = 512.0M
2021-01-03 16:39:33 25990 [Note] InnoDB: Completed initialization of buffer pool
2021-01-03 16:39:33 25990 [Note] InnoDB: Highest supported file format is Barracuda.
2021-01-03 16:39:33 25990 [Note] InnoDB: 128 rollback segment(s) are active.
2021-01-03 16:39:33 25990 [Note] InnoDB: Waiting for purge to start
2021-01-03 16:39:33 25990 [Note] InnoDB: 5.6.50 started; log sequence number 1600684
2021-01-03 16:39:33 25990 [ERROR] --gtid-mode=ON or UPGRADE_STEP_1 or UPGRADE_STEP_2 requires --log-bin and --log-slave-updates
2021-01-03 16:39:33 25990 [ERROR] Aborting

2021-01-03 16:39:33 25990 [Note] Binlog end
2021-01-03 16:39:33 25990 [Note] Shutting down plugin 'partition'
2021-01-03 16:39:33 25990 [Note] Shutting down plugin 'BLACKHOLE'
2021-01-03 16:39:33 25990 [Note] Shutting down plugin 'ARCHIVE'
2021-01-03 16:39:33 25990 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2021-01-03 16:39:33 25990 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2021-01-03 16:39:33 25990 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2021-01-03 16:39:33 25990 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2021-01-03 16:39:33 25990 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2021-01-03 16:39:33 25990 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2021-01-03 16:39:33 25990 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2021-01-03 16:39:33 25990 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2021-01-03 16:39:33 25990 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2021-01-03 16:39:33 25990 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2021-01-03 16:39:33 25990 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2021-01-03 16:39:33 25990 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2021-01-03 16:39:33 25990 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2021-01-03 16:39:33 25990 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2021-01-03 16:39:33 25990 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2021-01-03 16:39:33 25990 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2021-01-03 16:39:33 25990 [Note] Shutting down plugin 'INNODB_METRICS'
2021-01-03 16:39:33 25990 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2021-01-03 16:39:33 25990 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2021-01-03 16:39:33 25990 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2021-01-03 16:39:33 25990 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2021-01-03 16:39:33 25990 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2021-01-03 16:39:33 25990 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2021-01-03 16:39:33 25990 [Note] Shutting down plugin 'INNODB_CMPMEM'
2021-01-03 16:39:33 25990 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2021-01-03 16:39:33 25990 [Note] Shutting down plugin 'INNODB_CMP'
2021-01-03 16:39:33 25990 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2021-01-03 16:39:33 25990 [Note] Shutting down plugin 'INNODB_LOCKS'
2021-01-03 16:39:33 25990 [Note] Shutting down plugin 'INNODB_TRX'
2021-01-03 16:39:33 25990 [Note] Shutting down plugin 'InnoDB'
2021-01-03 16:39:33 25990 [Note] InnoDB: FTS optimize thread exiting.
2021-01-03 16:39:33 25990 [Note] InnoDB: Starting shutdown...
2021-01-03 16:39:35 25990 [Note] InnoDB: Shutdown completed; log sequence number 1600694
2021-01-03 16:39:35 25990 [Note] Shutting down plugin 'CSV'
2021-01-03 16:39:35 25990 [Note] Shutting down plugin 'MyISAM'
2021-01-03 16:39:35 25990 [Note] Shutting down plugin 'MRG_MYISAM'
2021-01-03 16:39:35 25990 [Note] Shutting down plugin 'MEMORY'
2021-01-03 16:39:35 25990 [Note] Shutting down plugin 'sha256_password'
2021-01-03 16:39:35 25990 [Note] Shutting down plugin 'mysql_old_password'
2021-01-03 16:39:35 25990 [Note] Shutting down plugin 'mysql_native_password'
2021-01-03 16:39:35 25990 [Note] Shutting down plugin 'binlog'
2021-01-03 16:39:35 25990 [Note] /www/server/mysql/bin/mysqld: Shutdown complete

作者: citywar 时间: 2021-1-3 16:58
--gtid-mode=ON or UPGRADE_STEP_1 or UPGRADE_STEP_2 requires --log-bin and --log-slave-updates

作者: dqlb123 时间: 2021-1-3 17:00

citywar 发表于 2021-1-3 16:58
--gtid-mode=ON or UPGRADE_STEP_1 or UPGRADE_STEP_2 requires --log-bin and --log-slave-updates

请教大佬，如何解决啊？

作者: beixiaoqian 时间: 2021-1-3 17:24

dqlb123 发表于 2021-1-3 17:00
请教大佬，如何解决啊？

复制他给你的提示，直接百度，不就有了。

作者: dvbhack 时间: 2021-1-3 17:28
禁用 gtid 或者配置 log-bin 选项

欢迎光临全球主机交流论坛 (https://hostloc-workers.ikyomon.com/)