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个小时~