der,2024年三月十日老梁博客宕機長達7個小時~
[重要通告]如您遇疑難雜癥,本站支持知識付費業務,掃右邊二維碼加博主微信,可節省您寶貴時間哦!
早上有各種事兒,也沒注意自己站是否可以打開,理論上站沒啥問題,估計昨天晚上進行數據備份的時候,數據庫沒有啟動成功,這可真是der,
到現在想寫篇文章才發現,期間還處理幾個客戶的事兒,都沒想著打開站點一下,最近被百度吃的,都沒心情打開了,哈哈~~~~
看了一下,主要還是服務器數據庫沒有正常啟動成功造成的~~~~
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號又微信號)右上方掃一掃可加博主微信
所寫所說,是心之所感,思之所悟,行之所得;文當無敷衍,落筆求簡潔。 以所舍,求所獲;有所依,方所成!
賞
支付寶贊助
微信贊助
免責聲明,若由于商用引起版權糾紛,一切責任均由使用者承擔。
您必須遵守我們的協議,如您下載該資源,行為將被視為對《免責聲明》全部內容的認可->聯系老梁投訴資源 LaoLiang.Net部分資源來自互聯網收集,僅供用于學習和交流,請勿用于商業用途。如有侵權、不妥之處,請聯系站長并出示版權證明以便刪除。
敬請諒解! 侵權刪帖/違法舉報/投稿等事物聯系郵箱:service@laoliang.net
意在交流學習,歡迎贊賞評論,如有謬誤,請聯系指正;轉載請注明出處: » der,2024年三月十日老梁博客宕機長達7個小時~