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

发表回复

本站承接,网站推广(SEM,SEO);软件安装与调试;服务器或网络推荐及配置;APP开发与维护;网站开发修改及维护; 各财务软件安装调试及注册服务(金蝶,用友,管家婆,速达,星宇等);同时也有客户管理系统,人力资源,超市POS,医药管理等;

立即查看 了解详情