weixin_43674800 2022-12-24 16:40 采纳率: 89.6%
浏览 42
已结题

mysql无缘无故自动就shutdown了,以下代码是mysqld.log里的日志

问题遇到的现象和发生背景

mysql无缘无故自动就shutdown了,以下代码是mysqld.log里的日志,麻烦帮忙给你分析下

遇到的现象和发生背景,请写出第一个错误信息

mysql无缘无故自动就shutdown了,以下代码是mysqld.log里的日志,麻烦帮忙给你分析下

用代码块功能插入代码,请勿粘贴截图。 不用代码块回答率下降 50%

2022-12-24T08:12:32.230493Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp serve documentation for more details).
2022-12-24T08:12:32.230583Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with stricwill be merged with strict mode in a future release.
2022-12-24T08:12:32.230588Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2022-12-24T08:12:32.230618Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2022-12-24T08:12:32.230662Z 0 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.7.34) starting as process 29979 ...
2022-12-24T08:12:32.262034Z 0 [Note] InnoDB: PUNCH HOLE support available
2022-12-24T08:12:32.262066Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2022-12-24T08:12:32.262071Z 0 [Note] InnoDB: Uses event mutexes
2022-12-24T08:12:32.262075Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2022-12-24T08:12:32.262081Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-12-24T08:12:32.262446Z 0 [Note] InnoDB: Number of pools: 1
2022-12-24T08:12:32.262580Z 0 [Note] InnoDB: Using CPU crc32 instructions
2022-12-24T08:12:32.264421Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2022-12-24T08:12:32.274655Z 0 [Note] InnoDB: Completed initialization of buffer pool
2022-12-24T08:12:32.280168Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the etpriority().
2022-12-24T08:12:32.292754Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2022-12-24T08:12:32.307614Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-12-24T08:12:32.307677Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-12-24T08:12:32.443830Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-12-24T08:12:32.445291Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2022-12-24T08:12:32.445311Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2022-12-24T08:12:32.446835Z 0 [Note] InnoDB: 5.7.34 started; log sequence number 1650461085
2022-12-24T08:12:32.447107Z 0 [Note] InnoDB: Loading buffer pool(s) from /usr/local/mysql/data/ib_buffer_pool
2022-12-24T08:12:32.447452Z 0 [Note] Plugin 'FEDERATED' is disabled.
2022-12-24T08:12:32.452740Z 0 [Note] InnoDB: Buffer pool(s) load completed at 221224 16:12:32
2022-12-24T08:12:32.460743Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using th
2022-12-24T08:12:32.460764Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2022-12-24T08:12:32.470476Z 0 [Warning] CA certificate ca.pem is self signed.
2022-12-24T08:12:32.470558Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2022-12-24T08:12:32.470968Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2022-12-24T08:12:32.471015Z 0 [Note] IPv6 is available.
2022-12-24T08:12:32.471029Z 0 [Note]   - '::' resolves to '::';
2022-12-24T08:12:32.471047Z 0 [Note] Server socket created on IP: '::'.
2022-12-24T08:12:32.484005Z 0 [Note] Event Scheduler: Loaded 0 events
2022-12-24T08:12:32.485079Z 0 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.7.34'  socket: '/usr/local/mysql/tmp/mysql.sock'  port: 3306  Source distribution
2022-12-24T08:19:16.473465Z 39 [Note] Aborted connection 39 to db: 'db_mail_server' user: 'root' host: '10.5.0.6' (Got an error reading communts)
2022-12-24T08:19:16.473571Z 0 [Note] Giving 45 client threads a chance to die gracefully
2022-12-24T08:19:16.473658Z 0 [Note] Shutting down slave threads
2022-12-24T08:19:18.473753Z 0 [Note] Forcefully disconnecting 0 remaining clients
2022-12-24T08:19:18.473794Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2022-12-24T08:19:18.473877Z 0 [Note] Binlog end
2022-12-24T08:19:18.476648Z 0 [Note] Shutting down plugin 'ngram'
2022-12-24T08:19:18.476669Z 0 [Note] Shutting down plugin 'partition'
2022-12-24T08:19:18.476675Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2022-12-24T08:19:18.476681Z 0 [Note] Shutting down plugin 'ARCHIVE'
2022-12-24T08:19:18.476685Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2022-12-24T08:19:18.476746Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2022-12-24T08:19:18.476751Z 0 [Note] Shutting down plugin 'MyISAM'
2022-12-24T08:19:18.476764Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2022-12-24T08:19:18.476769Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2022-12-24T08:19:18.476773Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2022-12-24T08:19:18.476776Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2022-12-24T08:19:18.476780Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2022-12-24T08:19:18.476784Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2022-12-24T08:19:18.476788Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2022-12-24T08:19:18.476792Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2022-12-24T08:19:18.476796Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2022-12-24T08:19:18.476799Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2022-12-24T08:19:18.476803Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2022-12-24T08:19:18.476825Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2022-12-24T08:19:18.476830Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2022-12-24T08:19:18.476833Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2022-12-24T08:19:18.476837Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2022-12-24T08:19:18.476841Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2022-12-24T08:19:18.476844Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2022-12-24T08:19:18.476848Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2022-12-24T08:19:18.476852Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2022-12-24T08:19:18.476856Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2022-12-24T08:19:18.476859Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2022-12-24T08:19:18.476863Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2022-12-24T08:19:18.476867Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2022-12-24T08:19:18.476870Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2022-12-24T08:19:18.476874Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2022-12-24T08:19:18.476878Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2022-12-24T08:19:18.476881Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2022-12-24T08:19:18.476885Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2022-12-24T08:19:18.476889Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2022-12-24T08:19:18.476893Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2022-12-24T08:19:18.476896Z 0 [Note] Shutting down plugin 'InnoDB'
2022-12-24T08:19:18.476991Z 0 [Note] InnoDB: FTS optimize thread exiting.
2022-12-24T08:19:18.477162Z 0 [Note] InnoDB: Starting shutdown...
2022-12-24T08:19:18.577325Z 0 [Note] InnoDB: Dumping buffer pool(s) to /usr/local/mysql/data/ib_buffer_pool
2022-12-24T08:19:18.578094Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 221224 16:19:18
2022-12-24T08:19:19.689364Z 0 [Note] InnoDB: Shutdown completed; log sequence number 1650530156
2022-12-24T08:19:19.692617Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-12-24T08:19:19.692640Z 0 [Note] Shutting down plugin 'MEMORY'
2022-12-24T08:19:19.692649Z 0 [Note] Shutting down plugin 'CSV'
2022-12-24T08:19:19.692655Z 0 [Note] Shutting down plugin 'sha256_password'
2022-12-24T08:19:19.692659Z 0 [Note] Shutting down plugin 'mysql_native_password'
2022-12-24T08:19:19.692909Z 0 [Note] Shutting down plugin 'binlog'
2022-12-24T08:19:19.694437Z 0 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

[root@vvt6 logs]# date
2022年 12月 24日 星期六 16:28:10 CST
[root@vvt6 logs]# tail -100 mysqld.log 
2022-12-23T11:07:25.821764Z 0 [Note] Shutting down plugin 'MEMORY'
2022-12-23T11:07:25.821771Z 0 [Note] Shutting down plugin 'CSV'
2022-12-23T11:07:25.821777Z 0 [Note] Shutting down plugin 'sha256_password'
2022-12-23T11:07:25.821781Z 0 [Note] Shutting down plugin 'mysql_native_password'
2022-12-23T11:07:25.822047Z 0 [Note] Shutting down plugin 'binlog'
2022-12-23T11:07:25.824207Z 0 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

2022-12-24T08:12:32.230493Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp serve documentation for more details).
2022-12-24T08:12:32.230583Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with stricwill be merged with strict mode in a future release.
2022-12-24T08:12:32.230588Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2022-12-24T08:12:32.230618Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2022-12-24T08:12:32.230662Z 0 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.7.34) starting as process 29979 ...
2022-12-24T08:12:32.262034Z 0 [Note] InnoDB: PUNCH HOLE support available
2022-12-24T08:12:32.262066Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2022-12-24T08:12:32.262071Z 0 [Note] InnoDB: Uses event mutexes
2022-12-24T08:12:32.262075Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2022-12-24T08:12:32.262081Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-12-24T08:12:32.262446Z 0 [Note] InnoDB: Number of pools: 1
2022-12-24T08:12:32.262580Z 0 [Note] InnoDB: Using CPU crc32 instructions
2022-12-24T08:12:32.264421Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2022-12-24T08:12:32.274655Z 0 [Note] InnoDB: Completed initialization of buffer pool
2022-12-24T08:12:32.280168Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the etpriority().
2022-12-24T08:12:32.292754Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2022-12-24T08:12:32.307614Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-12-24T08:12:32.307677Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-12-24T08:12:32.443830Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-12-24T08:12:32.445291Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2022-12-24T08:12:32.445311Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2022-12-24T08:12:32.446835Z 0 [Note] InnoDB: 5.7.34 started; log sequence number 1650461085
2022-12-24T08:12:32.447107Z 0 [Note] InnoDB: Loading buffer pool(s) from /usr/local/mysql/data/ib_buffer_pool
2022-12-24T08:12:32.447452Z 0 [Note] Plugin 'FEDERATED' is disabled.
2022-12-24T08:12:32.452740Z 0 [Note] InnoDB: Buffer pool(s) load completed at 221224 16:12:32
2022-12-24T08:12:32.460743Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using th
2022-12-24T08:12:32.460764Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2022-12-24T08:12:32.470476Z 0 [Warning] CA certificate ca.pem is self signed.
2022-12-24T08:12:32.470558Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2022-12-24T08:12:32.470968Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2022-12-24T08:12:32.471015Z 0 [Note] IPv6 is available.
2022-12-24T08:12:32.471029Z 0 [Note]   - '::' resolves to '::';
2022-12-24T08:12:32.471047Z 0 [Note] Server socket created on IP: '::'.
2022-12-24T08:12:32.484005Z 0 [Note] Event Scheduler: Loaded 0 events
2022-12-24T08:12:32.485079Z 0 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.7.34'  socket: '/usr/local/mysql/tmp/mysql.sock'  port: 3306  Source distribution
2022-12-24T08:19:16.473465Z 39 [Note] Aborted connection 39 to db: 'db_mail_server' user: 'root' host: '10.5.0.6' (Got an error reading communts)
2022-12-24T08:19:16.473571Z 0 [Note] Giving 45 client threads a chance to die gracefully
2022-12-24T08:19:16.473658Z 0 [Note] Shutting down slave threads
2022-12-24T08:19:18.473753Z 0 [Note] Forcefully disconnecting 0 remaining clients
2022-12-24T08:19:18.473794Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2022-12-24T08:19:18.473877Z 0 [Note] Binlog end
2022-12-24T08:19:18.476648Z 0 [Note] Shutting down plugin 'ngram'
2022-12-24T08:19:18.476669Z 0 [Note] Shutting down plugin 'partition'
2022-12-24T08:19:18.476675Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2022-12-24T08:19:18.476681Z 0 [Note] Shutting down plugin 'ARCHIVE'
2022-12-24T08:19:18.476685Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2022-12-24T08:19:18.476746Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2022-12-24T08:19:18.476751Z 0 [Note] Shutting down plugin 'MyISAM'
2022-12-24T08:19:18.476764Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2022-12-24T08:19:18.476769Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2022-12-24T08:19:18.476773Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2022-12-24T08:19:18.476776Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2022-12-24T08:19:18.476780Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2022-12-24T08:19:18.476784Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2022-12-24T08:19:18.476788Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2022-12-24T08:19:18.476792Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2022-12-24T08:19:18.476796Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2022-12-24T08:19:18.476799Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2022-12-24T08:19:18.476803Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2022-12-24T08:19:18.476825Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2022-12-24T08:19:18.476830Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2022-12-24T08:19:18.476833Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2022-12-24T08:19:18.476837Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2022-12-24T08:19:18.476841Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2022-12-24T08:19:18.476844Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2022-12-24T08:19:18.476848Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2022-12-24T08:19:18.476852Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2022-12-24T08:19:18.476856Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2022-12-24T08:19:18.476859Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2022-12-24T08:19:18.476863Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2022-12-24T08:19:18.476867Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2022-12-24T08:19:18.476870Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2022-12-24T08:19:18.476874Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2022-12-24T08:19:18.476878Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2022-12-24T08:19:18.476881Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2022-12-24T08:19:18.476885Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2022-12-24T08:19:18.476889Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2022-12-24T08:19:18.476893Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2022-12-24T08:19:18.476896Z 0 [Note] Shutting down plugin 'InnoDB'
2022-12-24T08:19:18.476991Z 0 [Note] InnoDB: FTS optimize thread exiting.
2022-12-24T08:19:18.477162Z 0 [Note] InnoDB: Starting shutdown...
2022-12-24T08:19:18.577325Z 0 [Note] InnoDB: Dumping buffer pool(s) to /usr/local/mysql/data/ib_buffer_pool
2022-12-24T08:19:18.578094Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 221224 16:19:18
2022-12-24T08:19:19.689364Z 0 [Note] InnoDB: Shutdown completed; log sequence number 1650530156
2022-12-24T08:19:19.692617Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-12-24T08:19:19.692640Z 0 [Note] Shutting down plugin 'MEMORY'
2022-12-24T08:19:19.692649Z 0 [Note] Shutting down plugin 'CSV'
2022-12-24T08:19:19.692655Z 0 [Note] Shutting down plugin 'sha256_password'
2022-12-24T08:19:19.692659Z 0 [Note] Shutting down plugin 'mysql_native_password'
2022-12-24T08:19:19.692909Z 0 [Note] Shutting down plugin 'binlog'
2022-12-24T08:19:19.694437Z 0 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete


运行结果及详细报错内容
我的解答思路和尝试过的方法,不写自己思路的,回答率下降 60%
我想要达到的结果,如果你需要快速回答,请尝试 “付费悬赏”
  • 写回答

1条回答 默认 最新

  • 1902_1 2022-12-24 22:10
    关注

    这不是数据库崩溃吧,只是客户端连接记录。

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

问题事件

  • 系统已结题 1月8日
  • 已采纳回答 12月31日
  • 创建了问题 12月24日

悬赏问题

  • ¥15 streamingtool
  • ¥15 MATLAB图像问题
  • ¥20 树莓派5做人脸情感识别与反馈系统
  • ¥15 selenium 控制 chrome-for-testing 在 Linux 环境下报错 SessionNotCreatedException
  • ¥15 使用pyodbc操作SQL数据库
  • ¥15 MATLAB实现下列
  • ¥30 mininet可视化打不开.mn文件
  • ¥50 C# 全屏打开Edge浏览器
  • ¥80 WEBPACK性能优化
  • ¥30 python拟合回归分析