冬寂 发表于 2024-4-30 15:07:36

【已解决】mysql无法启动

本帖最后由 冬寂 于 2024-4-30 17:41 编辑

为了能快速了解并处理您的问题,请提供以下基础信息:面板、插件版本:8.0.5
系统版本:系统:Ubuntu 22
问题描述:mysql突然无法启动

相关截图(日志、错误):
root@hh:~# sudo /www/server/mysql/support-files/mysql.server startStarting MySQL... * The server quit without updating PID file (/www/server/data/hh.pid).
----
2024-04-30T07:12:54.272540Z 0 Binlog end2024-04-30T07:12:54.272770Z 0 Shutting down plugin 'ngram'2024-04-30T07:12:54.272781Z 0 Shutting down plugin 'partition'2024-04-30T07:12:54.272784Z 0 Shutting down plugin 'BLACKHOLE'2024-04-30T07:12:54.272788Z 0 Shutting down plugin 'ARCHIVE'2024-04-30T07:12:54.272790Z 0 Shutting down plugin 'PERFORMANCE_SCHEMA'2024-04-30T07:12:54.272829Z 0 Shutting down plugin 'MRG_MYISAM'2024-04-30T07:12:54.272832Z 0 Shutting down plugin 'MyISAM'2024-04-30T07:12:54.272843Z 0 Shutting down plugin 'INNODB_SYS_VIRTUAL'2024-04-30T07:12:54.272846Z 0 Shutting down plugin 'INNODB_SYS_DATAFILES'2024-04-30T07:12:54.272849Z 0 Shutting down plugin 'INNODB_SYS_TABLESPACES'2024-04-30T07:12:54.272852Z 0 Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'2024-04-30T07:12:54.272855Z 0 Shutting down plugin 'INNODB_SYS_FOREIGN'2024-04-30T07:12:54.272857Z 0 Shutting down plugin 'INNODB_SYS_FIELDS'2024-04-30T07:12:54.272860Z 0 Shutting down plugin 'INNODB_SYS_COLUMNS'2024-04-30T07:12:54.272870Z 0 Shutting down plugin 'INNODB_SYS_INDEXES'2024-04-30T07:12:54.272873Z 0 Shutting down plugin 'INNODB_SYS_TABLESTATS'2024-04-30T07:12:54.272875Z 0 Shutting down plugin 'INNODB_SYS_TABLES'2024-04-30T07:12:54.272878Z 0 Shutting down plugin 'INNODB_FT_INDEX_TABLE'2024-04-30T07:12:54.272881Z 0 Shutting down plugin 'INNODB_FT_INDEX_CACHE'2024-04-30T07:12:54.272883Z 0 Shutting down plugin 'INNODB_FT_CONFIG'2024-04-30T07:12:54.272886Z 0 Shutting down plugin 'INNODB_FT_BEING_DELETED'2024-04-30T07:12:54.272889Z 0 Shutting down plugin 'INNODB_FT_DELETED'2024-04-30T07:12:54.272891Z 0 Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'2024-04-30T07:12:54.272894Z 0 Shutting down plugin 'INNODB_METRICS'2024-04-30T07:12:54.272896Z 0 Shutting down plugin 'INNODB_TEMP_TABLE_INFO'2024-04-30T07:12:54.272899Z 0 Shutting down plugin 'INNODB_BUFFER_POOL_STATS'2024-04-30T07:12:54.272902Z 0 Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'2024-04-30T07:12:54.272904Z 0 Shutting down plugin 'INNODB_BUFFER_PAGE'2024-04-30T07:12:54.272907Z 0 Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'2024-04-30T07:12:54.272910Z 0 Shutting down plugin 'INNODB_CMP_PER_INDEX'2024-04-30T07:12:54.272912Z 0 Shutting down plugin 'INNODB_CMPMEM_RESET'2024-04-30T07:12:54.272915Z 0 Shutting down plugin 'INNODB_CMPMEM'2024-04-30T07:12:54.272917Z 0 Shutting down plugin 'INNODB_CMP_RESET'2024-04-30T07:12:54.272920Z 0 Shutting down plugin 'INNODB_CMP'2024-04-30T07:12:54.272923Z 0 Shutting down plugin 'INNODB_LOCK_WAITS'2024-04-30T07:12:54.272925Z 0 Shutting down plugin 'INNODB_LOCKS'2024-04-30T07:12:54.272928Z 0 Shutting down plugin 'INNODB_TRX'2024-04-30T07:12:54.272931Z 0 Shutting down plugin 'InnoDB'2024-04-30T07:12:54.272974Z 0 InnoDB: FTS optimize thread exiting.2024-04-30T07:12:54.273025Z 0 InnoDB: Starting shutdown...2024-04-30T07:12:54.373128Z 0 InnoDB: Dumping buffer pool(s) to /www/server/data/ib_buffer_pool2024-04-30T07:12:54.373405Z 0 InnoDB: Buffer pool(s) dump completed at 240430 15:12:542024-04-30T07:12:55.904370Z 0 InnoDB: Shutdown completed; log sequence number 563282439962024-04-30T07:12:55.906446Z 0 InnoDB: Removed temporary tablespace data file: "ibtmp1"2024-04-30T07:12:55.906458Z 0 Shutting down plugin 'MEMORY'2024-04-30T07:12:55.906464Z 0 Shutting down plugin 'CSV'2024-04-30T07:12:55.906468Z 0 Shutting down plugin 'sha256_password'2024-04-30T07:12:55.906471Z 0 Shutting down plugin 'mysql_native_password'2024-04-30T07:12:55.906603Z 0 Shutting down plugin 'binlog'2024-04-30T07:12:55.919356Z 0 /www/server/mysql/bin/mysqld: Shutdown complete

冬寂 发表于 2024-4-30 17:39:54

已解决

原因:以下文件为空导致的
解决:手动删除以下文件,重启mysql

/tmp/mysql.sock.lock   
页: [1]
查看完整版本: 【已解决】mysql无法启动