首页 > 数据库 >哪个大神能看出mysql容器shutdown的原因吗?下面是日志信息,总是无缘无故shutdown

哪个大神能看出mysql容器shutdown的原因吗?下面是日志信息,总是无缘无故shutdown

时间:2022-11-14 23:24:31浏览次数:47  
标签:11 2022 communication Note shutdown mysql Got 日志 reading

2022-11-10T11:52:51.058698Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2022-11-10T11:52:51.061576Z 0 [Note] mysqld (mysqld 5.7.25) starting as process 1 ...
2022-11-10T11:52:51.065303Z 0 [Note] InnoDB: PUNCH HOLE support available
2022-11-10T11:52:51.065356Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2022-11-10T11:52:51.065364Z 0 [Note] InnoDB: Uses event mutexes
2022-11-10T11:52:51.065368Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2022-11-10T11:52:51.065372Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-11-10T11:52:51.065397Z 0 [Note] InnoDB: Using Linux native AIO
2022-11-10T11:52:51.065765Z 0 [Note] InnoDB: Number of pools: 1
2022-11-10T11:52:51.065920Z 0 [Note] InnoDB: Using CPU crc32 instructions
2022-11-10T11:52:51.068717Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2022-11-10T11:52:51.079830Z 0 [Note] InnoDB: Completed initialization of buffer pool
2022-11-10T11:52:51.083770Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2022-11-10T11:52:51.100337Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2022-11-10T11:52:51.118499Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-11-10T11:52:51.118580Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-11-10T11:52:51.152371Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-11-10T11:52:51.153289Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2022-11-10T11:52:51.153322Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2022-11-10T11:52:51.153871Z 0 [Note] InnoDB: Waiting for purge to start
2022-11-10T11:52:51.204075Z 0 [Note] InnoDB: 5.7.25 started; log sequence number 12533883
2022-11-10T11:52:51.204602Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2022-11-10T11:52:51.204611Z 0 [Note] Plugin 'FEDERATED' is disabled.
2022-11-10T11:52:51.213512Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2022-11-10T11:52:51.213911Z 0 [Warning] CA certificate ca.pem is self signed.
2022-11-10T11:52:51.215877Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2022-11-10T11:52:51.215922Z 0 [Note] IPv6 is available.
2022-11-10T11:52:51.215933Z 0 [Note] - '::' resolves to '::';
2022-11-10T11:52:51.215970Z 0 [Note] Server socket created on IP: '::'.
2022-11-10T11:52:51.218173Z 0 [Warning] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
2022-11-10T11:52:51.220110Z 0 [Note] InnoDB: Buffer pool(s) load completed at 221110 19:52:51
2022-11-10T11:52:51.229118Z 0 [Note] Failed to start slave threads for channel ''
2022-11-10T11:52:51.256807Z 0 [Note] mysqld: ready for connections.
Version: '5.7.25' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL)
2022-11-10T12:30:00.588742Z 26 [Note] Got an error reading communication packets
2022-11-10T13:07:35.604200Z 37 [Note] Got an error reading communication packets
2022-11-10T13:07:35.636569Z 38 [Note] Got packets out of order
2022-11-10T13:07:35.696288Z 39 [Note] Got packets out of order
2022-11-10T14:04:29.017471Z 12 [Note] Aborted connection 12 to db: 'unconnected' user: 'root' host: '' (Got timeout reading communication packets)
2022-11-10T14:04:29.017500Z 13 [Note] Aborted connection 13 to db: 'mysql' user: 'root' host: '' (Got timeout reading communication packets)
2022-11-10T14:07:12.857570Z 14 [Note] Aborted connection 14 to db: 'life-helper' user: 'root' host: '' (Got timeout reading communication packets)
2022-11-10T14:07:30.777515Z 15 [Note] Aborted connection 15 to db: 'life-helper' user: 'root' host: '' (Got timeout reading communication packets)
2022-11-10T14:14:49.227720Z 60 [Note] Got an error reading communication packets
2022-11-10T14:22:23.500426Z 71 [Note] Got an error reading communication packets
2022-11-10T14:22:35.723709Z 72 [Note] Got an error reading communication packets
2022-11-10T14:36:01.264631Z 74 [Note] Got an error reading communication packets
2022-11-10T15:51:40.747146Z 105 [Note] Got timeout reading communication packets
2022-11-10T16:33:13.166367Z 116 [Note] Got packets out of order
2022-11-10T17:04:37.923562Z 127 [Note] Got packets out of order
2022-11-10T17:04:44.382783Z 128 [Note] Got packets out of order
2022-11-10T17:04:44.532759Z 129 [Note] Got packets out of order
2022-11-10T17:11:46.490182Z 130 [Note] Got an error reading communication packets
2022-11-10T19:58:00.208755Z 192 [Note] Got an error reading communication packets
2022-11-10T19:58:15.360281Z 193 [Note] Got packets out of order
2022-11-10T19:58:26.760872Z 194 [Note] Got packets out of order
2022-11-10T21:42:39.333032Z 225 [Note] Got timeout reading communication packets
2022-11-10T21:43:22.366156Z 226 [Note] Got packets out of order
2022-11-10T21:56:34.879197Z 237 [Note] Got timeout reading communication packets
2022-11-10T21:58:39.711999Z 238 [Note] Aborted connection 238 to db: 'unconnected' user: 'root' host: '' (Got an error reading communication packets)
2022-11-10T23:05:25.790093Z 262 [Note] Got packets out of order
2022-11-10T23:46:41.047544Z 283 [Note] Got packets out of order
2022-11-11T02:42:03.573101Z 338 [Note] Got packets out of order
2022-11-11T02:42:10.836848Z 339 [Note] Got an error reading communication packets
2022-11-11T02:42:23.431791Z 342 [Note] Got packets out of order
2022-11-11T03:19:53.279052Z 357 [Note] Got an error reading communication packets
2022-11-11T03:48:47.952865Z 368 [Note] Got packets out of order
2022-11-11T03:48:56.089019Z 369 [Note] Got an error reading communication packets
2022-11-11T03:49:03.476523Z 370 [Note] Got packets out of order
2022-11-11T03:53:45.438570Z 371 [Note] Got an error reading communication packets
2022-11-11T04:51:31.924549Z 393 [Note] Got an error reading communication packets
2022-11-11T05:32:17.782037Z 404 [Note] Got packets out of order
2022-11-11T08:15:12.010641Z 465 [Note] Got an error reading communication packets
2022-11-11T08:17:18.202560Z 466 [Note] Got packets out of order
2022-11-11T10:05:15.864758Z 499 [Note] Got packets out of order
2022-11-11T10:06:25.187356Z 502 [Note] Got an error reading communication packets
2022-11-11T11:28:03.283719Z 529 [Note] Got an error reading communication packets
2022-11-11T12:08:28.397692Z 550 [Note] Got an error reading communication packets
2022-11-11T13:08:13.835065Z 572 [Note] Got packets out of order
2022-11-11T14:16:55.762258Z 593 [Note] Got an error reading communication packets
2022-11-11T15:09:36.283798Z 615 [Note] Got an error reading communication packets
2022-11-11T16:35:26.020802Z 646 [Note] Got timeout reading communication packets
2022-11-11T16:45:18.596605Z 647 [Note] Got an error reading communication packets
2022-11-11T16:52:36.215870Z 648 [Note] Got an error reading communication packets
2022-11-11T17:35:09.676318Z 669 [Note] Got packets out of order
2022-11-11T17:35:36.811494Z 670 [Note] Got an error reading communication packets
2022-11-11T17:35:41.083281Z 671 [Note] Got packets out of order
2022-11-11T20:36:52.184197Z 732 [Note] Got an error reading communication packets
2022-11-11T21:05:45.427316Z 743 [Note] Got packets out of order
2022-11-11T21:06:24.957551Z 744 [Note] Got packets out of order
2022-11-11T21:07:09.060457Z 745 [Note] Got an error reading communication packets
2022-11-11T21:39:24.536266Z 756 [Note] Got an error reading communication packets
2022-11-11T21:49:17.078731Z 757 [Note] Got packets out of order
2022-11-11T22:18:51.845023Z 768 [Note] Got packets out of order
2022-11-11T22:18:58.737772Z 769 [Note] Got an error reading communication packets
2022-11-11T22:53:59.418548Z 782 [Note] Got packets out of order
2022-11-11T22:56:03.739971Z 784 [Note] Got an error reading communication packets
2022-11-11T22:56:03.877978Z 785 [Note] Bad handshake
2022-11-11T23:31:58.916878Z 803 [Note] Got an error reading communication packets
2022-11-12T00:03:05.112340Z 814 [Note] Got packets out of order
2022-11-12T00:03:13.133484Z 815 [Note] Got packets out of order
2022-11-12T00:03:14.365455Z 816 [Note] Got an error reading communication packets
2022-11-12T01:00:02.506356Z 837 [Note] Got packets out of order
2022-11-12T02:28:06.373886Z 868 [Note] Got an error reading communication packets
2022-11-12T03:07:53.555707Z 879 [Note] Got packets out of order
2022-11-12T03:31:36.733425Z 890 [Note] Got packets out of order
2022-11-12T03:39:11.910436Z 891 [Note] Got timeout reading communication packets
2022-11-12T03:39:13.773780Z 892 [Note] Aborted connection 892 to db: 'unconnected' user: 'root' host: '' (Got an error reading communication packets)
2022-11-12T06:42:39.313494Z 955 [Note] Got packets out of order
2022-11-12T07:10:50.554261Z 966 [Note] Got an error reading communication packets
2022-11-12T07:31:19.825457Z 977 [Note] Got an error reading communication packets
2022-11-12T08:27:51.341477Z 998 [Note] Got packets out of order
2022-11-12T08:27:54.345102Z 999 [Note] Got packets out of order
2022-11-12T08:27:59.211515Z 1000 [Note] Got an error reading communication packets
2022-11-12T09:18:03.379181Z 1014 [Note] Got packets out of order
2022-11-12T09:18:06.683176Z 1015 [Note] Got an error reading communication packets
2022-11-12T10:04:34.604873Z 1025 [Note] Aborted connection 1025 to db: 'life-helper' user: 'root' host: '' (Got an error reading communication packets)
2022-11-12T10:04:34.604950Z 1023 [Note] Aborted connection 1023 to db: 'life-helper' user: 'root' host: '' (Got an error reading communication packets)
2022-11-12T10:04:34.604874Z 1032 [Note] Aborted connection 1032 to db: 'life-helper' user: 'root' host: '' (Got an error reading communication packets)
2022-11-12T10:04:34.604900Z 1028 [Note] Aborted connection 1028 to db: 'life-helper' user: 'root' host: '' (Got an error reading communication packets)
2022-11-12T10:04:34.604908Z 1027 [Note] Aborted connection 1027 to db: 'life-helper' user: 'root' host: '' (Got an error reading communication packets)
2022-11-12T10:04:34.604917Z 1026 [Note] Aborted connection 1026 to db: 'life-helper' user: 'root' host: '' (Got an error reading communication packets)
2022-11-12T10:04:34.604925Z 1024 [Note] Aborted connection 1024 to db: 'life-helper' user: 'root' host: '' (Got an error reading communication packets)
2022-11-12T10:04:34.604928Z 1031 [Note] Aborted connection 1031 to db: 'life-helper' user: 'root' host: '' (Got an error reading communication packets)
2022-11-12T10:04:34.604937Z 1029 [Note] Aborted connection 1029 to db: 'life-helper' user: 'root' host: '' (Got an error reading communication packets)
2022-11-12T10:04:34.604943Z 1030 [Note] Aborted connection 1030 to db: 'life-helper' user: 'root' host: '' (Got an error reading communication packets)
2022-11-12T10:56:15.754964Z 1053 [Note] Got an error reading communication packets
2022-11-12T10:58:00.348826Z 1055 [Note] Got an error reading communication packets
2022-11-12T12:15:07.155454Z 1086 [Note] Got an error reading communication packets
2022-11-12T12:16:21.830025Z 1077 [Note] Aborted connection 1077 to db: 'life-helper' user: 'root' host: '' (Got an error reading communication packets)
2022-11-12T12:16:21.830182Z 1076 [Note] Aborted connection 1076 to db: 'life-helper' user: 'root' host: '' (Got an error reading communication packets)
2022-11-12T12:16:21.830292Z 1085 [Note] Aborted connection 1085 to db: 'life-helper' user: 'root' host: '' (Got an error reading communication packets)
2022-11-12T12:16:21.830451Z 1079 [Note] Aborted connection 1079 to db: 'life-helper' user: 'root' host: '' (Got an error reading communication packets)
2022-11-12T12:16:21.830488Z 1083 [Note] Aborted connection 1083 to db: 'life-helper' user: 'root' host: '' (Got an error reading communication packets)
2022-11-12T12:16:21.830649Z 1081 [Note] Aborted connection 1081 to db: 'life-helper' user: 'root' host: '' (Got an error reading communication packets)
2022-11-12T12:16:21.830757Z 1078 [Note] Aborted connection 1078 to db: 'life-helper' user: 'root' host: '' (Got an error reading communication packets)
2022-11-12T12:16:21.830881Z 1082 [Note] Aborted connection 1082 to db: 'life-helper' user: 'root' host: '' (Got an error reading communication packets)
2022-11-12T12:16:21.830947Z 1084 [Note] Aborted connection 1084 to db: 'life-helper' user: 'root' host: '' (Got an error reading communication packets)
2022-11-12T12:16:21.831076Z 1080 [Note] Aborted connection 1080 to db: 'life-helper' user: 'root' host: '' (Got an error reading communication packets)
2022-11-12T12:37:39.032751Z 1097 [Note] Got an error reading communication packets
2022-11-12T12:40:57.975118Z 0 [Note] Giving 10 client threads a chance to die gracefully
2022-11-12T12:40:57.975304Z 0 [Note] Shutting down slave threads
2022-11-12T12:40:59.975504Z 0 [Note] Forcefully disconnecting 10 remaining clients
2022-11-12T12:40:59.975552Z 0 [Warning] mysqld: Forcing close of thread 1089 user: 'root'

2022-11-12T12:40:59.975695Z 0 [Warning] mysqld: Forcing close of thread 1094 user: 'root'

2022-11-12T12:40:59.975729Z 0 [Warning] mysqld: Forcing close of thread 1093 user: 'root'

2022-11-12T12:40:59.975751Z 0 [Warning] mysqld: Forcing close of thread 1092 user: 'root'

2022-11-12T12:40:59.975771Z 0 [Warning] mysqld: Forcing close of thread 1088 user: 'root'

2022-11-12T12:40:59.975793Z 0 [Warning] mysqld: Forcing close of thread 1087 user: 'root'

2022-11-12T12:40:59.975815Z 0 [Warning] mysqld: Forcing close of thread 1096 user: 'root'

2022-11-12T12:40:59.975837Z 0 [Warning] mysqld: Forcing close of thread 1095 user: 'root'

2022-11-12T12:40:59.975876Z 0 [Warning] mysqld: Forcing close of thread 1090 user: 'root'

2022-11-12T12:40:59.975899Z 0 [Warning] mysqld: Forcing close of thread 1091 user: 'root'

2022-11-12T12:40:59.976847Z 0 [Note] Binlog end
2022-11-12T12:40:59.978487Z 0 [Note] Shutting down plugin 'ngram'
2022-11-12T12:40:59.978517Z 0 [Note] Shutting down plugin 'partition'
2022-11-12T12:40:59.978521Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2022-11-12T12:40:59.978526Z 0 [Note] Shutting down plugin 'ARCHIVE'
2022-11-12T12:40:59.978528Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2022-11-12T12:40:59.978567Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2022-11-12T12:40:59.978576Z 0 [Note] Shutting down plugin 'MyISAM'
2022-11-12T12:40:59.978599Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2022-11-12T12:40:59.978605Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2022-11-12T12:40:59.978607Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2022-11-12T12:40:59.978609Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2022-11-12T12:40:59.978611Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2022-11-12T12:40:59.978613Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2022-11-12T12:40:59.978615Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2022-11-12T12:40:59.978617Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2022-11-12T12:40:59.978619Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2022-11-12T12:40:59.978622Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2022-11-12T12:40:59.978624Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2022-11-12T12:40:59.978625Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2022-11-12T12:40:59.978627Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2022-11-12T12:40:59.978629Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2022-11-12T12:40:59.978631Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2022-11-12T12:40:59.978633Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2022-11-12T12:40:59.978635Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2022-11-12T12:40:59.978637Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2022-11-12T12:40:59.978639Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2022-11-12T12:40:59.978641Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2022-11-12T12:40:59.978643Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2022-11-12T12:40:59.978645Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2022-11-12T12:40:59.978647Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2022-11-12T12:40:59.978649Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2022-11-12T12:40:59.978651Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2022-11-12T12:40:59.978653Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2022-11-12T12:40:59.978655Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2022-11-12T12:40:59.978657Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2022-11-12T12:40:59.978658Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2022-11-12T12:40:59.978660Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2022-11-12T12:40:59.978662Z 0 [Note] Shutting down plugin 'InnoDB'
2022-11-12T12:40:59.978764Z 0 [Note] InnoDB: FTS optimize thread exiting.
2022-11-12T12:40:59.978943Z 0 [Note] InnoDB: Starting shutdown...
2022-11-12T12:41:00.081428Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2022-11-12T12:41:00.085964Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 221112 20:41:00
2022-11-12T12:41:01.294778Z 0 [Note] InnoDB: Shutdown completed; log sequence number 12543513
2022-11-12T12:41:01.295502Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-11-12T12:41:01.295530Z 0 [Note] Shutting down plugin 'MEMORY'
2022-11-12T12:41:01.295540Z 0 [Note] Shutting down plugin 'CSV'
2022-11-12T12:41:01.295546Z 0 [Note] Shutting down plugin 'sha256_password'
2022-11-12T12:41:01.295548Z 0 [Note] Shutting down plugin 'mysql_native_password'
2022-11-12T12:41:01.295769Z 0 [Note] Shutting down plugin 'binlog'
2022-11-12T12:41:01.298866Z 0 [Note] mysqld: Shutdown complete

2022-11-12T13:02:01.568899Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2022-11-12T13:02:01.571757Z 0 [Note] mysqld (mysqld 5.7.25) starting as process 1 ...
2022-11-12T13:02:01.575543Z 0 [Note] InnoDB: PUNCH HOLE support available
2022-11-12T13:02:01.575586Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2022-11-12T13:02:01.575590Z 0 [Note] InnoDB: Uses event mutexes
2022-11-12T13:02:01.575593Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2022-11-12T13:02:01.575596Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-11-12T13:02:01.575598Z 0 [Note] InnoDB: Using Linux native AIO
2022-11-12T13:02:01.575920Z 0 [Note] InnoDB: Number of pools: 1
2022-11-12T13:02:01.577220Z 0 [Note] InnoDB: Using CPU crc32 instructions
2022-11-12T13:02:01.579941Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2022-11-12T13:02:01.590916Z 0 [Note] InnoDB: Completed initialization of buffer pool
2022-11-12T13:02:01.594775Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2022-11-12T13:02:01.613086Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2022-11-12T13:02:01.640169Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-11-12T13:02:01.640255Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-11-12T13:02:01.676087Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-11-12T13:02:01.677375Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2022-11-12T13:02:01.677515Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2022-11-12T13:02:01.678525Z 0 [Note] InnoDB: 5.7.25 started; log sequence number 12543513
2022-11-12T13:02:01.679051Z 0 [Note] Plugin 'FEDERATED' is disabled.
2022-11-12T13:02:01.680210Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2022-11-12T13:02:01.689713Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2022-11-12T13:02:01.691116Z 0 [Warning] CA certificate ca.pem is self signed.
2022-11-12T13:02:01.693499Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2022-11-12T13:02:01.693558Z 0 [Note] IPv6 is available.
2022-11-12T13:02:01.693573Z 0 [Note] - '::' resolves to '::';
2022-11-12T13:02:01.693633Z 0 [Note] Server socket created on IP: '::'.
2022-11-12T13:02:01.696612Z 0 [Warning] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
2022-11-12T13:02:01.702252Z 0 [Note] InnoDB: Buffer pool(s) load completed at 221112 21:02:01
2022-11-12T13:02:01.712568Z 0 [Note] Failed to start slave threads for channel ''
2022-11-12T13:02:01.738780Z 0 [Note] mysqld: ready for connections.
Version: '5.7.25' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL)
2022-11-12T13:10:14.982097Z 12 [Note] Got an error reading communication packets
2022-11-12T13:59:22.333938Z 24 [Note] Got an error reading communication packets
2022-11-12T16:13:12.280253Z 76 [Note] Got timeout reading communication packets
2022-11-12T16:53:16.322485Z 87 [Note] Got an error reading communication packets
2022-11-12T16:55:33.028918Z 88 [Note] Got an error reading communication packets
2022-11-12T17:04:11.429469Z 99 [Note] Got an error reading communication packets
2022-11-12T17:26:58.944102Z 101 [Note] Got packets out of order
2022-11-12T17:42:33.448963Z 112 [Note] Got an error reading communication packets
2022-11-12T17:48:37.884678Z 114 [Note] Got packets out of order
2022-11-12T17:48:46.060046Z 116 [Note] Got packets out of order
2022-11-12T17:48:46.086243Z 115 [Note] Got an error reading communication packets
2022-11-12T18:37:52.659427Z 137 [Note] Got packets out of order
2022-11-12T18:38:03.162588Z 138 [Note] Got packets out of order
2022-11-12T18:38:27.633291Z 139 [Note] Got an error reading communication packets
2022-11-12T20:17:19.760711Z 170 [Note] Got an error reading communication packets
2022-11-12T20:30:47.045707Z 182 [Note] Got packets out of order
2022-11-12T20:54:40.011540Z 183 [Note] Got packets out of order
2022-11-12T22:01:29.913163Z 214 [Note] Got an error reading communication packets
2022-11-12T23:51:22.675355Z 246 [Note] Got an error reading communication packets
2022-11-13T00:01:32.801503Z 258 [Note] Got packets out of order
2022-11-13T00:01:33.332243Z 259 [Note] Got packets out of order
2022-11-13T00:01:34.939148Z 260 [Note] Aborted connection 260 to db: 'information_schema' user: 'root' host: '' (Got an error reading communication packets)
2022-11-13T00:01:36.290700Z 261 [Note] Aborted connection 261 to db: 'information_schema' user: 'root' host: '' (Got an error reading communication packets)
2022-11-13T00:13:47.130130Z 263 [Note] Got packets out of order
2022-11-13T01:47:30.439945Z 294 [Note] Got packets out of order
2022-11-13T03:04:38.174163Z 325 [Note] Got an error reading communication packets
2022-11-13T03:04:39.859622Z 326 [Note] Got packets out of order
2022-11-13T03:05:14.535713Z 327 [Note] Got packets out of order
2022-11-13T03:59:44.960368Z 348 [Note] Got packets out of order
2022-11-13T05:56:36.797745Z 389 [Note] Got an error reading communication packets
2022-11-13T05:59:54.037543Z 390 [Note] Got an error reading communication packets
2022-11-13T06:20:07.345810Z 392 [Note] Got timeout reading communication packets
2022-11-13T06:29:39.961047Z 402 [Note] Got packets out of order
2022-11-13T06:34:13.028004Z 403 [Note] Got an error reading communication packets
2022-11-13T06:53:09.521782Z 414 [Note] Got packets out of order
2022-11-13T07:33:57.749861Z 426 [Note] Got packets out of order
2022-11-13T10:17:42.098354Z 482 [Note] Got packets out of order
2022-11-13T11:57:11.630824Z 518 [Note] Got an error reading communication packets
2022-11-13T12:00:23.142073Z 519 [Note] Got an error reading communication packets
2022-11-13T14:19:01.560990Z 569 [Note] Got packets out of order
2022-11-13T14:19:12.019218Z 570 [Note] Got an error reading communication packets
2022-11-13T14:19:12.477429Z 571 [Note] Got packets out of order
2022-11-13T14:32:40.971775Z 573 [Note] Got packets out of order
2022-11-13T16:30:33.935738Z 614 [Note] Got an error reading communication packets
2022-11-13T17:23:45.544595Z 635 [Note] Got timeout reading communication packets
2022-11-13T17:32:57.749477Z 0 [Note] Giving 0 client threads a chance to die gracefully
2022-11-13T17:32:57.749537Z 0 [Note] Shutting down slave threads
2022-11-13T17:32:57.749551Z 0 [Note] Forcefully disconnecting 0 remaining clients
2022-11-13T17:32:57.749707Z 0 [Note] Binlog end
2022-11-13T17:32:57.752482Z 0 [Note] Shutting down plugin 'ngram'
2022-11-13T17:32:57.752516Z 0 [Note] Shutting down plugin 'partition'
2022-11-13T17:32:57.752522Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2022-11-13T17:32:57.752527Z 0 [Note] Shutting down plugin 'ARCHIVE'
2022-11-13T17:32:57.752530Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2022-11-13T17:32:57.752574Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2022-11-13T17:32:57.752580Z 0 [Note] Shutting down plugin 'MyISAM'
2022-11-13T17:32:57.752595Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2022-11-13T17:32:57.752598Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2022-11-13T17:32:57.752600Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2022-11-13T17:32:57.752602Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2022-11-13T17:32:57.752604Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2022-11-13T17:32:57.752606Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2022-11-13T17:32:57.752608Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2022-11-13T17:32:57.752610Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2022-11-13T17:32:57.752612Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2022-11-13T17:32:57.752614Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2022-11-13T17:32:57.752616Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2022-11-13T17:32:57.752619Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2022-11-13T17:32:57.752621Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2022-11-13T17:32:57.752623Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2022-11-13T17:32:57.752625Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2022-11-13T17:32:57.752626Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2022-11-13T17:32:57.752628Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2022-11-13T17:32:57.752630Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2022-11-13T17:32:57.752632Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2022-11-13T17:32:57.752634Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2022-11-13T17:32:57.752636Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2022-11-13T17:32:57.752638Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2022-11-13T17:32:57.752640Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2022-11-13T17:32:57.752642Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2022-11-13T17:32:57.752644Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2022-11-13T17:32:57.752646Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2022-11-13T17:32:57.752648Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2022-11-13T17:32:57.752650Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2022-11-13T17:32:57.752652Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2022-11-13T17:32:57.752654Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2022-11-13T17:32:57.752656Z 0 [Note] Shutting down plugin 'InnoDB'
2022-11-13T17:32:57.752766Z 0 [Note] InnoDB: FTS optimize thread exiting.
2022-11-13T17:32:57.753105Z 0 [Note] InnoDB: Starting shutdown...
2022-11-13T17:32:57.853305Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2022-11-13T17:32:57.854003Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 221114 1:32:57
2022-11-13T17:32:59.066584Z 0 [Note] InnoDB: Shutdown completed; log sequence number 12553545
2022-11-13T17:32:59.067304Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-11-13T17:32:59.067327Z 0 [Note] Shutting down plugin 'MEMORY'
2022-11-13T17:32:59.067334Z 0 [Note] Shutting down plugin 'CSV'
2022-11-13T17:32:59.067340Z 0 [Note] Shutting down plugin 'sha256_password'
2022-11-13T17:32:59.067344Z 0 [Note] Shutting down plugin 'mysql_native_password'
2022-11-13T17:32:59.067522Z 0 [Note] Shutting down plugin 'binlog'
2022-11-13T17:32:59.070321Z 0 [Note] mysqld: Shutdown complete

标签:11,2022,communication,Note,shutdown,mysql,Got,日志,reading
From: https://www.cnblogs.com/lichengming/p/16890904.html

相关文章

  • MySQL---InnoDB数据存储结构
    InnoDB数据存储结构数据库的存储结构:页磁盘与内存交互的基本单位:页  页结构概述页的大小 页的上层结构页的内部结构......
  • django的日志管理-logging
    django的日志使用python的logging模块logging的四个模块---logger-记录器:日志系统的入口,每个logger都是bucket,可以向这个bucket写入需要处理的信息,logger根据消息的日志......
  • Mysql-分页查询
    --从0开始查询,查询3条数据;SELECT*fromstuLIMIT0,3;--每页显示3条数据,查询第1页的数据;SELECT*fromstuLIMIT0,3;--每页显示3条数据,查询第2页的数据;SELECT......
  • 第14章——MySQL数据库系统
    第14章——MySQL数据库系统摘要MySQL关系数据库系统;在Linux机器上安装和运行MySQL;使用MySQL在命令模式和批处理模式下使用SQL脚本创建和管理数据库;将MySQL与C编......
  • MySQL数据库
    1、初识MySQLJavaEE:企业级Java开发Web前端 (页面:展示,数据!)后台 (连接点:连接数据库JDBC,连接前端(控制,控制跳转和给前端传递数据))数据库(存数据,Text,Excel,Word)只会写代码,学好......
  • linux清空日志文件内容的几种常用方法
    1.使用cp/cat/dd命令及dev/null设备来清空文件内容(1)通过cp复制/dev/null内容到指定文件cp/dev/nullfilename.out(2)通过cat命令显示/dev/null内容,重定向到指定文件cat/......
  • Asterisk realtime 之SIP用户动态写入mysql 数据库(2)
    提供通信服务器和客户端解决方案,包括视频电话,调度系统,会议系统等VOIP行业资讯和技术趋势请参考:www.voip123.cn接上一篇文章,SIP用户写入mysql数据库,asterisk自动查找数......
  • Ubuntu20.04离线安装mysql8.0
    参考网址#1.官网下载对应的文件并解压tar-xfmysql-server_8.0.31-1ubuntu20.04_amd64.deb-bundle.tar#2.下载所需的依赖wgethttp://archive.ubuntu.com/ubuntu/pool......
  • MySQL该使用哪种CPU架构服务器?
    1.摘要近期,阿里云推出基于ARM架构的RDSMySQL和RDSPostgreSQL实例,现处于邀测阶段,阿里云宣传ARM架构的亮点是:在价格下降13%的基础上,平均性能ARM架构比X86架......
  • mysql8创建组合索引
    https://wenku.baidu.com/view/63898d1d0a12a21614791711cc7931b764ce7b40.html?wkts=1668415162513&bdQuery=mysql8+%E7%BB%84%E5%90%88%E7%B4%A2%E5%BC%95https://www.c......