提问前请务必仔细阅读如何排查故障和常见问题。
问题描述:
论坛无法登录和注册
报错内容:

Mysql日志:`
2021-01-28T15:47:18.277511Z 29 [Note] Aborted connection 29 to db: ‘sstbbs’ user: ‘sstbbs’ host: ‘localhost’ (Got an error reading communication packets)
2021-01-28T15:47:22.954035Z 38 [Note] Aborted connection 38 to db: ‘sstbbs’ user: ‘sstbbs’ host: ‘localhost’ (Got an error reading communication packets)
2021-01-28T15:48:20.690653Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4784ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2021-01-28T15:49:13.751434Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4137ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2021-01-28T15:49:17.221007Z 30 [Note] Aborted connection 30 to db: ‘sstbbs’ user: ‘sstbbs’ host: ‘localhost’ (Got an error reading communication packets)
2021-01-28T15:49:17.372246Z 87 [Note] Aborted connection 87 to db: ‘sstbbs’ user: ‘sstbbs’ host: ‘localhost’ (Got an error reading communication packets)
2021-01-28T15:49:17.372675Z 96 [Note] Aborted connection 96 to db: ‘sstbbs’ user: ‘sstbbs’ host: ‘localhost’ (Got an error reading communication packets)
2021-01-28T15:49:17.372776Z 92 [Note] Aborted connection 92 to db: ‘sstbbs’ user: ‘sstbbs’ host: ‘localhost’ (Got an error reading communication packets)
2021-01-28T15:49:17.372839Z 90 [Note] Aborted connection 90 to db: ‘sstbbs’ user: ‘sstbbs’ host: ‘localhost’ (Got an error reading communication packets)
2021-01-28T15:49:17.372892Z 94 [Note] Aborted connection 94 to db: ‘sstbbs’ user: ‘sstbbs’ host: ‘localhost’ (Got an error reading communication packets)
2021-01-28T15:49:17.373279Z 93 [Note] Aborted connection 93 to db: ‘sstbbs’ user: ‘sstbbs’ host: ‘localhost’ (Got an error reading communication packets)
2021-01-28T15:49:17.374240Z 91 [Note] Aborted connection 91 to db: ‘sstbbs’ user: ‘sstbbs’ host: ‘localhost’ (Got an error reading communication packets)
2021-01-28T15:49:17.375635Z 69 [Note] Aborted connection 69 to db: ‘sstbbs’ user: ‘sstbbs’ host: ‘localhost’ (Got an error reading communication packets)
2021-01-28T15:49:17.377593Z 89 [Note] Aborted connection 89 to db: ‘sstbbs’ user: ‘sstbbs’ host: ‘localhost’ (Got an error reading communication packets)
2021-01-28T15:49:17.377665Z 68 [Note] Aborted connection 68 to db: ‘sstbbs’ user: ‘sstbbs’ host: ‘localhost’ (Got an error reading communication packets)
2021-01-28T15:49:17.381262Z 70 [Note] Aborted connection 70 to db: ‘sstbbs’ user: ‘sstbbs’ host: ‘localhost’ (Got an error reading communication packets)
2021-01-28T15:49:17.381361Z 66 [Note] Aborted connection 66 to db: ‘sstbbs’ user: ‘sstbbs’ host: ‘localhost’ (Got an error reading communication packets)
2021-01-28T15:49:17.382885Z 76 [Note] Aborted connection 76 to db: ‘sstbbs’ user: ‘sstbbs’ host: ‘localhost’ (Got an error reading communication packets)
2021-01-28T15:49:17.384401Z 64 [Note] Aborted connection 64 to db: ‘sstbbs’ user: ‘sstbbs’ host: ‘localhost’ (Got an error reading communication packets)
2021-01-28T15:49:17.385566Z 83 [Note] Aborted connection 83 to db: ‘sstbbs’ user: ‘sstbbs’ host: ‘localhost’ (Got an error reading communication packets)
2021-01-28T15:49:17.386183Z 86 [Note] Aborted connection 86 to db: ‘sstbbs’ user: ‘sstbbs’ host: ‘localhost’ (Got an error reading communication packets)
2021-01-28T15:49:17.386334Z 57 [Note] Aborted connection 57 to db: ‘sstbbs’ user: ‘sstbbs’ host: ‘localhost’ (Got an error reading communication packets)
2021-01-28T15:49:17.386484Z 81 [Note] Aborted connection 81 to db: ‘sstbbs’ user: ‘sstbbs’ host: ‘localhost’ (Got an error reading communication packets)
2021-01-28T15:49:17.387349Z 84 [Note] Aborted connection 84 to db: ‘sstbbs’ user: ‘sstbbs’ host: ‘localhost’ (Got an error reading communication packets)
2021-01-28T15:49:17.387751Z 95 [Note] Aborted connection 95 to db: ‘sstbbs’ user: ‘sstbbs’ host: ‘localhost’ (Got an error reading communication packets)
2021-01-28T15:49:17.387766Z 85 [Note] Aborted connection 85 to db: ‘sstbbs’ user: ‘sstbbs’ host: ‘localhost’ (Got an error reading communication packets)
2021-01-28T15:49:17.404264Z 55 [Note] Aborted connection 55 to db: ‘sstbbs’ user: ‘sstbbs’ host: ‘localhost’ (Got an error reading communication packets)
2021-01-28T15:49:17.404398Z 54 [Note] Aborted connection 54 to db: ‘sstbbs’ user: ‘sstbbs’ host: ‘localhost’ (Got an error reading communication packets)
2021-01-28T15:49:17.405683Z 56 [Note] Aborted connection 56 to db: ‘sstbbs’ user: ‘sstbbs’ host: ‘localhost’ (Got an error reading communication packets)
2021-01-28T15:49:17.408292Z 61 [Note] Aborted connection 61 to db: ‘sstbbs’ user: ‘sstbbs’ host: ‘localhost’ (Got an error reading communication packets)
2021-01-28T15:49:17.408386Z 88 [Note] Aborted connection 88 to db: ‘sstbbs’ user: ‘sstbbs’ host: ‘localhost’ (Got an error reading communication packets)
2021-01-28T15:49:17.409102Z 62 [Note] Aborted connection 62 to db: ‘sstbbs’ user: ‘sstbbs’ host: ‘localhost’ (Got an error reading communication packets)
2021-01-28T15:49:17.410938Z 58 [Note] Aborted connection 58 to db: ‘sstbbs’ user: ‘sstbbs’ host: ‘localhost’ (Got an error reading communication packets)
2021-01-28T15:49:17.411006Z 59 [Note] Aborted connection 59 to db: ‘sstbbs’ user: ‘sstbbs’ host: ‘localhost’ (Got an error reading communication packets)
2021-01-28T15:49:17.411419Z 60 [Note] Aborted connection 60 to db: ‘sstbbs’ user: ‘sstbbs’ host: ‘localhost’ (Got an error reading communication packets)
2021-01-28T15:49:17.416115Z 46 [Note] Aborted connection 46 to db: ‘sstbbs’ user: ‘sstbbs’ host: ‘localhost’ (Got an error reading communication packets)
2021-01-28T15:49:17.416605Z 33 [Note] Aborted connection 33 to db: ‘sstbbs’ user: ‘sstbbs’ host: ‘localhost’ (Got an error reading communication packets)
2021-01-28T15:49:17.421515Z 44 [Note] Aborted connection 44 to db: ‘sstbbs’ user: ‘sstbbs’ host: ‘localhost’ (Got an error reading communication packets)
2021-01-28T15:49:17.421628Z 41 [Note] Aborted connection 41 to db: ‘sstbbs’ user: ‘sstbbs’ host: ‘localhost’ (Got an error reading communication packets)
2021-01-28T15:49:17.421675Z 40 [Note] Aborted connection 40 to db: ‘sstbbs’ user: ‘sstbbs’ host: ‘localhost’ (Got an error reading communication packets)
2021-01-28T15:49:17.421712Z 39 [Note] Aborted connection 39 to db: ‘sstbbs’ user: ‘sstbbs’ host: ‘localhost’ (Got an error reading communication packets)
2021-01-28T15:49:17.421895Z 42 [Note] Aborted connection 42 to db: ‘sstbbs’ user: ‘sstbbs’ host: ‘localhost’ (Got an error reading communication packets)
2021-01-28T15:49:17.421941Z 34 [Note] Aborted connection 34 to db: ‘sstbbs’ user: ‘sstbbs’ host: ‘localhost’ (Got an error reading communication packets)
2021-01-28T15:49:17.425270Z 25 [Note] Aborted connection 25 to db: ‘sstbbs’ user: ‘sstbbs’ host: ‘localhost’ (Got an error reading communication packets)
2021-01-28T15:49:17.425357Z 28 [Note] Aborted connection 28 to db: ‘sstbbs’ user: ‘sstbbs’ host: ‘localhost’ (Got an error reading communication packets)
2021-01-28T15:49:17.425429Z 32 [Note] Aborted connection 32 to db: ‘sstbbs’ user: ‘sstbbs’ host: ‘localhost’ (Got an error reading communication packets)
2021-01-28T15:49:17.444746Z 97 [Note] Aborted connection 97 to db: ‘sstbbs’ user: ‘sstbbs’ host: ‘localhost’ (Got an error reading communication packets)
2021-01-28T15:49:17.444927Z 27 [Note] Aborted connection 27 to db: ‘sstbbs’ user: ‘sstbbs’ host: ‘localhost’ (Got an error reading communication packets)
2021-01-28T15:49:17.447339Z 35 [Note] Aborted connection 35 to db: ‘sstbbs’ user: ‘sstbbs’ host: ‘localhost’ (Got an error reading communication packets)
2021-01-28T15:49:17.465697Z 82 [Note] Aborted connection 82 to db: ‘sstbbs’ user: ‘sstbbs’ host: ‘localhost’ (Got an error reading communication packets)
2021-01-28T15:49:17.466344Z 79 [Note] Aborted connection 79 to db: ‘sstbbs’ user: ‘sstbbs’ host: ‘localhost’ (Got an error reading communication packets)
2021-01-28T15:49:17.467526Z 78 [Note] Aborted connection 78 to db: ‘sstbbs’ user: ‘sstbbs’ host: ‘localhost’ (Got an error reading communication packets)
2021-01-28T15:49:17.468286Z 80 [Note] Aborted connection 80 to db: ‘sstbbs’ user: ‘sstbbs’ host: ‘localhost’ (Got an error reading communication packets)
2021-01-28T15:49:39.846457Z 0 [Warning] option ‘max_allowed_packet’: unsigned value 107374182400 adjusted to 1073741824
2021-01-28T15:49:39.846575Z 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.
2021-01-28T15:49:39.846578Z 0 [Warning] ‘NO_AUTO_CREATE_USER’ sql mode was not set.
2021-01-28T15:49:39.846599Z 0 [Note] –secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2021-01-28T15:49:39.846628Z 0 [Note] /www/server/mysql/bin/mysqld (mysqld 5.7.32-log) starting as process 8953 …
2021-01-28T15:49:39.928243Z 0 [Note] InnoDB: PUNCH HOLE support available
2021-01-28T15:49:39.928289Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-01-28T15:49:39.928293Z 0 [Note] InnoDB: Uses event mutexes
2021-01-28T15:49:39.928297Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2021-01-28T15:49:39.928300Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-01-28T15:49:39.928304Z 0 [Note] InnoDB: Using Linux native AIO
2021-01-28T15:49:39.928631Z 0 [Note] InnoDB: Number of pools: 1
2021-01-28T15:49:39.928752Z 0 [Note] InnoDB: Using CPU crc32 instructions
2021-01-28T15:49:39.932240Z 0 [Note] InnoDB: Initializing buffer pool, total size = 512M, instances = 1, chunk size = 128M
2021-01-28T15:49:39.977450Z 0 [Note] InnoDB: Completed initialization of buffer pool
2021-01-28T15:49:39.983118Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2021-01-28T15:49:40.040857Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2021-01-28T15:49:40.130525Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 20372704
2021-01-28T15:49:40.130586Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 20372713
2021-01-28T15:49:40.130596Z 0 [Note] InnoDB: Database was not shutdown normally!
2021-01-28T15:49:40.130599Z 0 [Note] InnoDB: Starting crash recovery.
2021-01-28T15:49:40.481431Z 0 [Note] InnoDB: Last MySQL binlog file position 0 2642, file name mysql-bin.000020
2021-01-28T15:49:40.894685Z 0 [Note] InnoDB: Removed temporary tablespace data file: “ibtmp1”
2021-01-28T15:49:40.894711Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-01-28T15:49:40.894810Z 0 [Note] InnoDB: Setting file ‘/www/server/data/ibtmp1’ size to 12 MB. Physically writing the file full; Please wait …
2021-01-28T15:49:40.988037Z 0 [Note] InnoDB: File ‘/www/server/data/ibtmp1’ size is now 12 MB.
2021-01-28T15:49:40.988651Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2021-01-28T15:49:40.988672Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2021-01-28T15:49:40.989042Z 0 [Note] InnoDB: Waiting for purge to start
2021-01-28T15:49:41.039257Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 20372713
2021-01-28T15:49:41.039855Z 0 [Note] InnoDB: Loading buffer pool(s) from /www/server/data/ib_buffer_pool
2021-01-28T15:49:41.040195Z 0 [Note] Plugin ‘FEDERATED’ is disabled.
2021-01-28T15:49:41.044194Z 0 [Note] Recovering after a crash using mysql-bin
2021-01-28T15:49:41.044251Z 0 [Note] Starting crash recovery…
2021-01-28T15:49:41.044281Z 0 [Note] Crash recovery finished.
2021-01-28T15:49:41.062919Z 0 [Note] InnoDB: Buffer pool(s) load completed at 210128 23:49:41
2021-01-28T15:49:41.067248Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2021-01-28T15:49:41.067270Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2021-01-28T15:49:41.068666Z 0 [Warning] CA certificate ca.pem is self signed.
2021-01-28T15:49:41.068704Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2021-01-28T15:49:41.069012Z 0 [Note] Server hostname (bind-address): ‘’; port: 3306
2021-01-28T15:49:41.069046Z 0 [Note] IPv6 is available.
2021-01-28T15:49:41.069058Z 0 [Note] - ‘::’ resolves to ‘::’;
2021-01-28T15:49:41.069075Z 0 [Note] Server socket created on IP: ‘::’.
2021-01-28T15:49:41.079328Z 0 [Note] Failed to start slave threads for channel ''
2021-01-28T15:49:41.104584Z 0 [Note] Event Scheduler: Loaded 0 events
2021-01-28T15:49:41.104995Z 0 [Note] /www/server/mysql/bin/mysqld: ready for connections.
Version: ‘5.7.32-log’ socket: ‘/tmp/mysql.sock’ port: 3306 Source distribution
2021-02-05T12:10:33.241254Z 0 [Warning] option ‘max_allowed_packet’: unsigned value 107374182400 adjusted to 1073741824
2021-02-05T12:10:33.241446Z 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.
2021-02-05T12:10:33.241457Z 0 [Warning] ‘NO_AUTO_CREATE_USER’ sql mode was not set.
2021-02-05T12:10:33.241498Z 0 [Note] –secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2021-02-05T12:10:33.241539Z 0 [Note] /www/server/mysql/bin/mysqld (mysqld 5.7.32-log) starting as process 807179 …
2021-02-05T12:10:34.065316Z 0 [Note] InnoDB: PUNCH HOLE support available
2021-02-05T12:10:34.065398Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-02-05T12:10:34.065403Z 0 [Note] InnoDB: Uses event mutexes
2021-02-05T12:10:34.065406Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2021-02-05T12:10:34.065408Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-02-05T12:10:34.065411Z 0 [Note] InnoDB: Using Linux native AIO
2021-02-05T12:10:34.065863Z 0 [Note] InnoDB: Number of pools: 1
2021-02-05T12:10:34.066045Z 0 [Note] InnoDB: Using CPU crc32 instructions
2021-02-05T12:10:34.081309Z 0 [Note] InnoDB: Initializing buffer pool, total size = 512M, instances = 1, chunk size = 128M
2021-02-05T12:10:34.486464Z 0 [Note] InnoDB: Completed initialization of buffer pool
2021-02-05T12:10:34.594680Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2021-02-05T12:10:34.654846Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2021-02-05T12:10:34.750495Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 28392044
2021-02-05T12:10:34.750535Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 28392053
2021-02-05T12:10:34.750540Z 0 [Note] InnoDB: Database was not shutdown normally!
2021-02-05T12:10:34.750543Z 0 [Note] InnoDB: Starting crash recovery.
2021-02-05T12:10:35.200985Z 0 [Note] InnoDB: Last MySQL binlog file position 0 5422975, file name mysql-bin.000021
2021-02-05T12:10:36.053653Z 0 [Note] InnoDB: Removed temporary tablespace data file: “ibtmp1”
2021-02-05T12:10:36.053691Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-02-05T12:10:36.053751Z 0 [Note] InnoDB: Setting file ‘/www/server/data/ibtmp1’ size to 12 MB. Physically writing the file full; Please wait …
2021-02-05T12:10:36.166448Z 0 [Note] InnoDB: File ‘/www/server/data/ibtmp1’ size is now 12 MB.
2021-02-05T12:10:36.167191Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2021-02-05T12:10:36.167218Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2021-02-05T12:10:36.167718Z 0 [Note] InnoDB: Waiting for purge to start
2021-02-05T12:10:36.222569Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 28392053
2021-02-05T12:10:36.224294Z 0 [Note] Plugin ‘FEDERATED’ is disabled.
2021-02-05T12:10:36.270486Z 0 [Note] Recovering after a crash using mysql-bin
2021-02-05T12:10:36.276780Z 0 [Note] InnoDB: Loading buffer pool(s) from /www/server/data/ib_buffer_pool
2021-02-05T12:10:36.357579Z 0 [Note] InnoDB: Buffer pool(s) load completed at 210205 20:10:36
2021-02-05T12:10:36.357574Z 0 [Note] Starting crash recovery…
2021-02-05T12:10:36.368555Z 0 [Note] Crash recovery finished.
2021-02-05T12:10:36.646852Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2021-02-05T12:10:36.646902Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2021-02-05T12:10:36.649231Z 0 [Warning] CA certificate ca.pem is self signed.
2021-02-05T12:10:36.649286Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2021-02-05T12:10:36.649605Z 0 [Note] Server hostname (bind-address): ‘’; port: 3306
2021-02-05T12:10:36.649658Z 0 [Note] IPv6 is available.
2021-02-05T12:10:36.649665Z 0 [Note] - ‘::’ resolves to ‘::’;
2021-02-05T12:10:36.649694Z 0 [Note] Server socket created on IP: ‘::’.
2021-02-05T12:10:36.733959Z 0 [Note] Failed to start slave threads for channel ''
2021-02-05T12:10:37.252927Z 0 [Note] Event Scheduler: Loaded 0 events
2021-02-05T12:10:37.275803Z 0 [Note] /www/server/mysql/bin/mysqld: ready for connections.
Version: ‘5.7.32-log’ socket: ‘/tmp/mysql.sock’ port: 3306 Source distribution
2021-02-14T01:59:36.059545Z 0 [Note] Giving 0 client threads a chance to die gracefully
2021-02-14T01:59:36.091772Z 0 [Note] Shutting down slave threads
2021-02-14T01:59:36.091858Z 0 [Note] Forcefully disconnecting 0 remaining clients
2021-02-14T01:59:36.091879Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2021-02-14T01:59:36.096974Z 0 [Note] Binlog end
2021-02-14T01:59:36.106633Z 0 [Note] Shutting down plugin ‘ngram’
2021-02-14T01:59:36.106682Z 0 [Note] Shutting down plugin ‘partition’
2021-02-14T01:59:36.106686Z 0 [Note] Shutting down plugin ‘BLACKHOLE’
2021-02-14T01:59:36.106692Z 0 [Note] Shutting down plugin ‘ARCHIVE’
2021-02-14T01:59:36.106694Z 0 [Note] Shutting down plugin ‘PERFORMANCE_SCHEMA’
2021-02-14T01:59:36.106756Z 0 [Note] Shutting down plugin ‘MRG_MYISAM’
2021-02-14T01:59:36.106763Z 0 [Note] Shutting down plugin ‘MyISAM’
2021-02-14T01:59:36.106792Z 0 [Note] Shutting down plugin ‘INNODB_SYS_VIRTUAL’
2021-02-14T01:59:36.106800Z 0 [Note] Shutting down plugin ‘INNODB_SYS_DATAFILES’
2021-02-14T01:59:36.106803Z 0 [Note] Shutting down plugin ‘INNODB_SYS_TABLESPACES’
2021-02-14T01:59:36.106805Z 0 [Note] Shutting down plugin ‘INNODB_SYS_FOREIGN_COLS’
2021-02-14T01:59:36.106807Z 0 [Note] Shutting down plugin ‘INNODB_SYS_FOREIGN’
2021-02-14T01:59:36.106808Z 0 [Note] Shutting down plugin ‘INNODB_SYS_FIELDS’
2021-02-14T01:59:36.106810Z 0 [Note] Shutting down plugin ‘INNODB_SYS_COLUMNS’
2021-02-14T01:59:36.106812Z 0 [Note] Shutting down plugin ‘INNODB_SYS_INDEXES’
2021-02-14T01:59:36.106813Z 0 [Note] Shutting down plugin ‘INNODB_SYS_TABLESTATS’
2021-02-14T01:59:36.106815Z 0 [Note] Shutting down plugin ‘INNODB_SYS_TABLES’
2021-02-14T01:59:36.106816Z 0 [Note] Shutting down plugin ‘INNODB_FT_INDEX_TABLE’
2021-02-14T01:59:36.106817Z 0 [Note] Shutting down plugin ‘INNODB_FT_INDEX_CACHE’
2021-02-14T01:59:36.106818Z 0 [Note] Shutting down plugin ‘INNODB_FT_CONFIG’
2021-02-14T01:59:36.106820Z 0 [Note] Shutting down plugin ‘INNODB_FT_BEING_DELETED’
2021-02-14T01:59:36.106821Z 0 [Note] Shutting down plugin ‘INNODB_FT_DELETED’
2021-02-14T01:59:36.106822Z 0 [Note] Shutting down plugin ‘INNODB_FT_DEFAULT_STOPWORD’
2021-02-14T01:59:36.106823Z 0 [Note] Shutting down plugin ‘INNODB_METRICS’
2021-02-14T01:59:36.106825Z 0 [Note] Shutting down plugin ‘INNODB_TEMP_TABLE_INFO’
2021-02-14T01:59:36.106826Z 0 [Note] Shutting down plugin ‘INNODB_BUFFER_POOL_STATS’
2021-02-14T01:59:36.106827Z 0 [Note] Shutting down plugin ‘INNODB_BUFFER_PAGE_LRU’
2021-02-14T01:59:36.106828Z 0 [Note] Shutting down plugin ‘INNODB_BUFFER_PAGE’
2021-02-14T01:59:36.106830Z 0 [Note] Shutting down plugin ‘INNODB_CMP_PER_INDEX_RESET’
2021-02-14T01:59:36.106832Z 0 [Note] Shutting down plugin ‘INNODB_CMP_PER_INDEX’
2021-02-14T01:59:36.106833Z 0 [Note] Shutting down plugin ‘INNODB_CMPMEM_RESET’
2021-02-14T01:59:36.106834Z 0 [Note] Shutting down plugin ‘INNODB_CMPMEM’
2021-02-14T01:59:36.106836Z 0 [Note] Shutting down plugin ‘INNODB_CMP_RESET’
2021-02-14T01:59:36.106838Z 0 [Note] Shutting down plugin ‘INNODB_CMP’
2021-02-14T01:59:36.106840Z 0 [Note] Shutting down plugin ‘INNODB_LOCK_WAITS’
2021-02-14T01:59:36.106843Z 0 [Note] Shutting down plugin ‘INNODB_LOCKS’
2021-02-14T01:59:36.106860Z 0 [Note] Shutting down plugin ‘INNODB_TRX’
2021-02-14T01:59:36.106862Z 0 [Note] Shutting down plugin ‘InnoDB’
2021-02-14T01:59:36.202853Z 0 [Note] InnoDB: FTS optimize thread exiting.
2021-02-14T01:59:36.203215Z 0 [Note] InnoDB: Starting shutdown…
2021-02-14T01:59:36.303759Z 0 [Note] InnoDB: Dumping buffer pool(s) to /www/server/data/ib_buffer_pool
2021-02-14T01:59:36.304023Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 210214 9:59:36
2021-02-14T01:59:37.921064Z 0 [Note] InnoDB: Shutdown completed; log sequence number 31422096
2021-02-14T01:59:37.921449Z 0 [Note] InnoDB: Removed temporary tablespace data file: “ibtmp1”
2021-02-14T01:59:37.921493Z 0 [Note] Shutting down plugin ‘MEMORY’
2021-02-14T01:59:37.921504Z 0 [Note] Shutting down plugin ‘CSV’
2021-02-14T01:59:37.921509Z 0 [Note] Shutting down plugin ‘sha256_password’
2021-02-14T01:59:37.921511Z 0 [Note] Shutting down plugin ‘mysql_native_password’
2021-02-14T01:59:37.921690Z 0 [Note] Shutting down plugin ‘binlog’
2021-02-14T01:59:37.922565Z 0 [Note] /www/server/mysql/bin/mysqld: Shutdown complete
2021-02-14T02:00:24.432258Z 0 [Warning] option ‘max_allowed_packet’: unsigned value 107374182400 adjusted to 1073741824
2021-02-14T02:00:24.432447Z 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.
2021-02-14T02:00:24.432454Z 0 [Warning] ‘NO_AUTO_CREATE_USER’ sql mode was not set.
2021-02-14T02:00:24.432483Z 0 [Note] –secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2021-02-14T02:00:24.432558Z 0 [Note] /www/server/mysql/bin/mysqld (mysqld 5.7.33-log) starting as process 1833785 …
2021-02-14T02:00:24.519661Z 0 [Note] InnoDB: PUNCH HOLE support available
2021-02-14T02:00:24.519715Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-02-14T02:00:24.519718Z 0 [Note] InnoDB: Uses event mutexes
2021-02-14T02:00:24.519720Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2021-02-14T02:00:24.519722Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-02-14T02:00:24.519730Z 0 [Note] InnoDB: Using Linux native AIO
2021-02-14T02:00:24.520099Z 0 [Note] InnoDB: Number of pools: 1
2021-02-14T02:00:24.520252Z 0 [Note] InnoDB: Using CPU crc32 instructions
2021-02-14T02:00:24.523646Z 0 [Note] InnoDB: Initializing buffer pool, total size = 512M, instances = 1, chunk size = 128M
2021-02-14T02:00:24.557449Z 0 [Note] InnoDB: Completed initialization of buffer pool
2021-02-14T02:00:24.565522Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2021-02-14T02:00:24.600500Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2021-02-14T02:00:24.688305Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-02-14T02:00:24.688407Z 0 [Note] InnoDB: Setting file ‘/www/server/data/ibtmp1’ size to 12 MB. Physically writing the file full; Please wait …
2021-02-14T02:00:24.892362Z 0 [Note] InnoDB: File ‘/www/server/data/ibtmp1’ size is now 12 MB.
2021-02-14T02:00:24.893325Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2021-02-14T02:00:24.893352Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2021-02-14T02:00:24.893872Z 0 [Note] InnoDB: Waiting for purge to start
2021-02-14T02:00:24.944226Z 0 [Note] InnoDB: 5.7.33 started; log sequence number 31422096
2021-02-14T02:00:24.944645Z 0 [Note] InnoDB: Loading buffer pool(s) from /www/server/data/ib_buffer_pool
2021-02-14T02:00:24.944865Z 0 [Note] Plugin ‘FEDERATED’ is disabled.
2021-02-14T02:00:25.017239Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2021-02-14T02:00:25.017287Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2021-02-14T02:00:25.021355Z 0 [Warning] CA certificate ca.pem is self signed.
2021-02-14T02:00:25.021436Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2021-02-14T02:00:25.023765Z 0 [Note] Server hostname (bind-address): ‘*’; port: 3306
2021-02-14T02:00:25.023843Z 0 [Note] IPv6 is available.
2021-02-14T02:00:25.023854Z 0 [Note] - ‘::’ resolves to ‘::’;
2021-02-14T02:00:25.023873Z 0 [Note] Server socket created on IP: ‘::’.
2021-02-14T02:00:25.042464Z 0 [Note] InnoDB: Buffer pool(s) load completed at 210214 10:00:25
2021-02-14T02:00:25.052955Z 0 [Note] Failed to start slave threads for channel ''
2021-02-14T02:00:25.078212Z 0 [Note] Event Scheduler: Loaded 0 events
2021-02-14T02:00:25.078644Z 0 [Note] /www/server/mysql/bin/mysqld: ready for connections.
Version: ‘5.7.33-log’ socket: ‘/tmp/mysql.sock’ port: 3306 Source distribution`
调试模式报错内容:
null
已尝试的解决办法:
更新sql版本
更新php
网址:bbs.sstown.world