der,2024年三月十日老梁博客宕機長達7個小時~

[重要通告]如您遇疑難雜癥,本站支持知識付費業(yè)務,掃右邊二維碼加博主微信,可節(jié)省您寶貴時間哦!

早上有各種事兒，也沒注意自己站是否可以打開，理論上站沒啥問題，估計昨天晚上進行數(shù)據(jù)備份的時候，數(shù)據(jù)庫沒有啟動成功，這可真是der，

到現(xiàn)在想寫篇文章才發(fā)現(xiàn)，期間還處理幾個客戶的事兒，都沒想著打開站點一下，最近被百度吃的，都沒心情打開了，哈哈~~~~

看了一下，主要還是服務器數(shù)據(jù)庫沒有正常啟動成功造成的~~~~

2024-03-10T03:39:46.233209Z 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2024-03-10T03:39:46.233337Z 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-03-10T03:39:46.233343Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2024-03-10T03:39:46.233369Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2024-03-10T03:39:46.233417Z 0 [Note] /www/server/mysql/bin/mysqld (mysqld 5.7.40-log) starting as process 30204 ...
2024-03-10T03:39:46.300811Z 0 [Note] InnoDB: PUNCH HOLE support available
2024-03-10T03:39:46.300891Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2024-03-10T03:39:46.300899Z 0 [Note] InnoDB: Uses event mutexes
2024-03-10T03:39:46.300905Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2024-03-10T03:39:46.300911Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2024-03-10T03:39:46.300916Z 0 [Note] InnoDB: Using Linux native AIO
2024-03-10T03:39:46.301322Z 0 [Note] InnoDB: Number of pools: 1
2024-03-10T03:39:46.301489Z 0 [Note] InnoDB: Using CPU crc32 instructions
2024-03-10T03:39:46.303293Z 0 [Note] InnoDB: Initializing buffer pool, total size = 384M, instances = 1, chunk size = 128M
2024-03-10T03:39:46.338555Z 0 [Note] InnoDB: Completed initialization of buffer pool
2024-03-10T03:39:46.345497Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2024-03-10T03:39:46.366943Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2024-03-10T03:39:46.373323Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 2011896543
2024-03-10T03:39:46.373342Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 2011898221
2024-03-10T03:39:46.376000Z 0 [Note] InnoDB: Database was not shutdown normally!
2024-03-10T03:39:46.376015Z 0 [Note] InnoDB: Starting crash recovery.
2024-03-10T03:39:46.421457Z 0 [Note] InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percent: 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 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-03-10T03:39:46.935036Z 0 [Note] InnoDB: Apply batch completed
2024-03-10T03:39:46.935075Z 0 [Note] InnoDB: Last MySQL binlog file position 0 1654, file name mysql-bin.000262
2024-03-10T03:39:47.134696Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2024-03-10T03:39:47.134720Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-03-10T03:39:47.134758Z 0 [Note] InnoDB: Setting file '/www/server/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-03-10T03:39:47.163060Z 0 [Note] InnoDB: File '/www/server/data/ibtmp1' size is now 12 MB.
2024-03-10T03:39:47.163879Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2024-03-10T03:39:47.163892Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2024-03-10T03:39:47.164326Z 0 [Note] InnoDB: Waiting for purge to start
2024-03-10T03:39:47.214517Z 0 [Note] InnoDB: 5.7.40 started; log sequence number 2011898221
2024-03-10T03:39:47.214871Z 0 [Note] InnoDB: Loading buffer pool(s) from /www/server/data/ib_buffer_pool
2024-03-10T03:39:47.214951Z 0 [Note] Plugin 'FEDERATED' is disabled.
2024-03-10T03:39:47.219019Z 0 [Note] Recovering after a crash using mysql-bin
2024-03-10T03:39:47.219071Z 0 [Note] Starting crash recovery...
2024-03-10T03:39:47.219105Z 0 [Note] Crash recovery finished.
2024-03-10T03:39:47.234728Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2024-03-10T03:39:47.234751Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2024-03-10T03:39:47.234756Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
2024-03-10T03:39:47.234759Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
2024-03-10T03:39:47.236483Z 0 [Warning] CA certificate ca.pem is self signed.
2024-03-10T03:39:47.236534Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2024-03-10T03:39:47.237294Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2024-03-10T03:39:47.237337Z 0 [Note] IPv6 is available.
2024-03-10T03:39:47.237348Z 0 [Note] - '::' resolves to '::';
2024-03-10T03:39:47.237366Z 0 [Note] Server socket created on IP: '::'.
2024-03-10T03:39:47.262702Z 0 [Note] Failed to start slave threads for channel ''
2024-03-10T03:39:47.313565Z 0 [Note] Event Scheduler: Loaded 0 events
2024-03-10T03:39:47.313737Z 0 [Note] /www/server/mysql/bin/mysqld: ready for connections.
Version: '5.7.40-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
2024-03-10T03:39:48.411849Z 0 [Note] InnoDB: Buffer pool(s) load completed at 240310 11:39:48

僅此做個記錄吧~~~悲傷辣么大！

問題未解決？付費解決問題加Q或微信 2589053300 (即Q號又微信號)右上方掃一掃可加博主微信

所寫所說，是心之所感，思之所悟，行之所得；文當無敷衍，落筆求簡潔。 以所舍，求所獲；有所依，方所成！