MySQL keeps crashing, I read the error log, understood it, but don’t know where to start the troubleshooting

  Kiến thức lập trình

Here is the error log. I know it complains about a few things, but what makes it crash? Also, how can I prevent it from happening over and over again?
Tried with AI, but it does not give me any sort of instruction or anything. I am a bit lost in this topic, so hope someone here will be able to point me to the right direction.

Thank you in advance.

2024-04-03T07:50:43.034105Z 74657 [Note] Aborted connection 74657 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2024-04-03T07:50:43.049631Z 74658 [Note] Aborted connection 74658 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2024-04-04T04:14:03.177587Z 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2024-04-04T04:14:03.178255Z 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.
2024-04-04T04:14:03.178260Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2024-04-04T04:14:03.178282Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2024-04-04T04:14:03.178463Z 0 [Note] /www/server/mysql/bin/mysqld (mysqld 5.7.43-log) starting as process 2062679 ...
2024-04-04T04:14:03.224561Z 0 [Note] InnoDB: PUNCH HOLE support available
2024-04-04T04:14:03.224631Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2024-04-04T04:14:03.224636Z 0 [Note] InnoDB: Uses event mutexes
2024-04-04T04:14:03.224639Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2024-04-04T04:14:03.224642Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
2024-04-04T04:14:03.225259Z 0 [Note] InnoDB: Number of pools: 1
2024-04-04T04:14:03.226151Z 0 [Note] InnoDB: Using CPU crc32 instructions
2024-04-04T04:14:03.226962Z 0 [Note] InnoDB: Initializing buffer pool, total size = 512M, instances = 1, chunk size = 128M
2024-04-04T04:14:03.253055Z 0 [Note] InnoDB: Completed initialization of buffer pool
2024-04-04T04:14:03.257892Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2024-04-04T04:14:03.270615Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2024-04-04T04:14:03.276966Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 5615004869
2024-04-04T04:14:03.277014Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 5615005386
2024-04-04T04:14:03.277963Z 0 [Note] InnoDB: Database was not shutdown normally!
2024-04-04T04:14:03.277990Z 0 [Note] InnoDB: Starting crash recovery.
2024-04-04T04:14:03.321037Z 0 [Note] InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percent: 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 
2024-04-04T04:14:03.331598Z 0 [Note] InnoDB: Apply batch completed
2024-04-04T04:14:03.331623Z 0 [Note] InnoDB: Last MySQL binlog file position 0 478210639, file name mysql-bin.000031
2024-04-04T04:14:03.603415Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2024-04-04T04:14:03.603443Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-04-04T04:14:03.603479Z 0 [Note] InnoDB: Setting file '/www/server/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-04-04T04:14:03.621181Z 0 [Note] InnoDB: File '/www/server/data/ibtmp1' size is now 12 MB.
2024-04-04T04:14:03.621684Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2024-04-04T04:14:03.621702Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2024-04-04T04:14:03.626768Z 0 [Note] InnoDB: 5.7.43 started; log sequence number 5615005386
2024-04-04T04:14:03.627139Z 0 [Note] InnoDB: Loading buffer pool(s) from /www/server/data/ib_buffer_pool
2024-04-04T04:14:03.627199Z 0 [Note] Plugin 'FEDERATED' is disabled.
2024-04-04T04:14:03.629469Z 0 [Note] Recovering after a crash using mysql-bin
2024-04-04T04:14:03.975940Z 0 [Note] InnoDB: Buffer pool(s) load completed at 240404  4:14:03
2024-04-04T04:14:04.448260Z 0 [Note] Starting crash recovery...
2024-04-04T04:14:04.448346Z 0 [Note] Crash recovery finished.
2024-04-04T04:14:04.971078Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2024-04-04T04:14:04.971095Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2024-04-04T04:14:04.971263Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
2024-04-04T04:14:04.971269Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
2024-04-04T04:14:04.972453Z 0 [Warning] CA certificate ca.pem is self signed.
2024-04-04T04:14:04.972777Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2024-04-04T04:14:04.973082Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2024-04-04T04:14:04.973109Z 0 [Note] IPv6 is available.
2024-04-04T04:14:04.973113Z 0 [Note]   - '::' resolves to '::';
2024-04-04T04:14:04.973125Z 0 [Note] Server socket created on IP: '::'.
2024-04-04T04:14:04.987603Z 0 [Note] Failed to start slave threads for channel ''
2024-04-04T04:14:05.004135Z 0 [Note] Event Scheduler: Loaded 0 events
2024-04-04T04:14:05.004336Z 0 [Note] /www/server/mysql/bin/mysqld: ready for connections.
Version: '5.7.43-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
2024-04-04T04:14:06.630888Z 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2024-04-04T04:14:06.633210Z 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.
2024-04-04T04:14:06.633221Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2024-04-04T04:14:06.633367Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2024-04-04T04:14:06.633563Z 0 [Note] /www/server/mysql/bin/mysqld (mysqld 5.7.43-log) starting as process 2062787 ...
2024-04-04T04:14:06.676889Z 0 [Note] InnoDB: PUNCH HOLE support available
2024-04-04T04:14:06.676919Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2024-04-04T04:14:06.676923Z 0 [Note] InnoDB: Uses event mutexes
2024-04-04T04:14:06.676926Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2024-04-04T04:14:06.676929Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
2024-04-04T04:14:06.677489Z 0 [Note] InnoDB: Number of pools: 1
2024-04-04T04:14:06.678272Z 0 [Note] InnoDB: Using CPU crc32 instructions
2024-04-04T04:14:06.679100Z 0 [Note] InnoDB: Initializing buffer pool, total size = 512M, instances = 1, chunk size = 128M
2024-04-04T04:14:06.709088Z 0 [Note] InnoDB: Completed initialization of buffer pool
2024-04-04T04:14:06.718600Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2024-04-04T04:14:06.737135Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2024-04-04T04:14:06.778560Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 5615004869
2024-04-04T04:14:06.778593Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 5615006341
2024-04-04T04:14:06.793019Z 0 [Note] InnoDB: Database was not shutdown normally!
2024-04-04T04:14:06.793040Z 0 [Note] InnoDB: Starting crash recovery.
2024-04-04T04:14:06.840863Z 0 [Note] InnoDB: Transaction 2361356 was in the XA prepared state.
2024-04-04T04:14:06.845893Z 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 0 row operations to undo
2024-04-04T04:14:06.845910Z 0 [Note] InnoDB: Trx id counter is 2361856
2024-04-04T04:14:06.850550Z 0 [Note] InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percent: 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 
2024-04-04T04:14:07.372559Z 0 [Note] InnoDB: Apply batch completed
2024-04-04T04:14:07.400006Z 0 [Note] InnoDB: Last MySQL binlog file position 0 535, file name mysql-bin.000032
-- ````

LEAVE A COMMENT