在给Windows2016DataCenter服务器做性能诊断时，报错“数据收集器集或其相关项之一已在使用中，如下图所示：这样出的报告不符合要求，如下图：解决办法：在事件跟踪会话中把”NT Kernel Logger“服务停止掉，然后重新启动诊断即可正常生成报告。 ...继续阅读 (26)

在虚拟机上第一次运行Stable Diffusion时报错如下：Loading weights [cc6cb27103] from /data/stable-diffusion-webui/models/Stable-diffusion/v1-5-pruned-emaonly.ckpt Creating model from config: /data/stable-diffusion-webui/configs/v1-inference.yaml creating model quickly: OSError Traceback (most recent call last): File "/usr/lib/python3.11/threading.py", line 995, in _bootstrap self._bootstrap_inner() File "/usr/lib/python3.11/threading.py", line 1038, in _bootstrap_inner self.run() File "/home/ice/.local/share/virtualenvs/stable-diffusion-webui-bRNo03KA/lib/python3.11/site-packages/anyio/_backends/_a ...继续阅读 (22)

在Debian系统中，可通过配置apt工具来确保系统只安装安全更新补丁，而不进行完整的系统升级。以下是实现步骤：1、安装 unattended-upgrades 包sudo apt-get update sudo apt-get install unattended-upgrades2、修改apt配置文件sudo vi /etc/apt/apt.conf.d/50unattended-upgrades 注释掉这三行 "origin=Debian,codename=${distro_codename},label=Debian"; Unattended-Upgrade::Package-Blacklist { }; 只保留如下所示即可。 grep -v '//' /etc/apt/apt.conf.d/50unattended-upgrades Unattended-Upgrade::Origins-Pattern { "origin=Debian,codename=${distro_codename},label=Debian-Security"; "origin=Debian,codename=${distro_codename}-security,label=Debian-Security"; };3、更新并应用配置:su ...继续阅读 (28)

酷暑，本来计划去延安，无奈天公不作美连着大雨暴雨，就去了兰州。从西安出发，越往西北走越广阔荒凉，过了天水以后基本就是兰州特有的那种光秃秃的山了.兰州博物馆的几个掠影.从山顶上遥望黄河上游泄洪，黄河的水和洪水差不多一样的颜色基本都是这种广阔的峡谷，有的颜色深有的颜色浅·峡谷外面还是峡谷，山顶上风很大·准备开发的峡谷峡谷深处恐龙出没热气球平台不过因为安全没开放现场看还是挺有意思的，不过得带口罩^o^时间有限，甘肃又特别的长，越往西北越广阔。在当地吃烤羊肉串牛肉串牛羊杂等很正宗。 ...继续阅读 (36)

数据量超过10000+的时候重启服务会触发，报错如下：2024-07-12T00:08:33.773606Z 0 [System] [MY-015015] [Server] MySQL Server - start. 2024-07-12T00:08:34.118349Z 0 [Warning] [MY-011070] [Server] 'binlog_format' is deprecated and will be removed in a future release. 2024-07-12T00:08:34.118714Z 0 [System] [MY-010116] [Server] D:\ProgramFiles\mysql9\bin\mysqld (mysqld 9.0.0) starting as process 7760 2024-07-12T00:08:34.223215Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2024-07-12T00:08:35.018761Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2024-07-12T00:08:35.341833Z ...继续阅读 (46)

Rocky9.4默认的Python版本是Python 3.9.18，本文记录如何快速升级Python 3.9.18到Python 3.11.9步骤：1、查看系统版本[root@rocky94 ~]# cat /etc/redhat-release Rocky Linux release 9.4 (Blue Onyx)2、更新系统:[root@rocky94 ~]# dnf update -y3、安装依赖项:[root@rocky94 ~]# dnf install vim wget openssl-devel bzip2-devel libffi-devel -y [root@rocky94 ~]# dnf groupinstall "Development Tools" -y4、下载编译安装:[root@rocky94 ~]# wget https://www.python.org/ftp/python/3.11.9/Python-3.11.9.tgz [root@rocky94 ~]# tar xvf Python-3.11.9.tgz [root@rocky94 ~]# cd Python-3.11.9 [root@rocky94 ~]# ./configure --enable-optimizations [root@rocky94 ~]# make -j 2 [root@ ...继续阅读 (63)

Cloudera Manager管理的集群中hdfs报错不良 : 群集中有 1 个 丢失块 块。群集中共有 6,956 个块。百分比 丢失块: 0.01%。 临界阈值：任意。看来是有文件损坏了，解决方法：1、检查缺失块:[root@devnode01 ~]# hdfs fsck / Connecting to namenode via http://devnode02:9870/fsck?ugi=root&path;=%2F FSCK started by root (auth:SIMPLE) from /10.23.74.196 for path / at Thu Jun 06 13:11:54 CST 2024 Status: CORRUPT Number of data-nodes: 3 Number of racks: 1 Total dirs: 3969 Total symlinks: 0 Replicated Blocks: Total size: 8730303943 B Total files: 6953 Total blocks (validated): 6962 (avg. block size 1253993 B) **** ...继续阅读 (54)

Win11系统在本地启动项目后页面元素不能正常显示，js未能正常加载，报错如下：Refused to execute script from '' because its MIME type ('text/plain') is not executable, and strict MIME type checking is enabled. 127.0.0.1/:1 Refused to execute script from 'http://127.0.0.1:8000/static/admin/simpleui-x/js/vue.min.js?_=2022.7.29' because its MIME type ('text/plain') is not executable, and strict MIME type checking is enabled. 127.0.0.1/:1 Refused to execute script from 'http://127.0.0.1:8000/static/admin/simpleui-x/elementui/index.js?_=2022.7.29' because its MIME type ('text/plain ...继续阅读 (67)

Win11系统在本地启动项目后页面元素不能正常显示，js未能正常加载，报错如下：Refused to execute script from '' because its MIME type ('text/plain') is not executable, and strict MIME type checking is enabled. 127.0.0.1/:1 Refused to execute script from 'http://127.0.0.1:8000/static/admin/simpleui-x/js/vue.min.js?_=2022.7.29' because its MIME type ('text/plain') is not executable, and strict MIME type checking is enabled. 127.0.0.1/:1 Refused to execute script from 'http://127.0.0.1:8000/static/admin/simpleui-x/elementui/index.js?_=2022.7.29' because its MIME type ('text/plain ...继续阅读 (47)

第三天去了白马寺，就是小学课本中的那个白马寺；没有想象中那么好，人山人海人挤人。老街热闹，小吃一条街，各大热门旅游城市好像都有小吃一条街，洛阳这边各种“汤”吃不习惯。“洛阳牡丹甲天下，丽景城楼世无双”，实地看起来也就那样，晚上带小朋友看了暑假正热播的《长安三万里》挺开心。白马寺外面的石白马怀旧老铺子的壁画中原第一门 ...继续阅读 (54)

第三天去了白马寺，就是小学课本中的那个白马寺；没有想象中那么好，人山人海人挤人。老街热闹，小吃一条街，各大热门旅游城市好像都有小吃一条街，洛阳这边各种“汤”吃不习惯。“洛阳牡丹甲天下，丽景城楼世无双”，实地看起来也就那样，晚上带小朋友看了暑假正热播的《长安三万里》挺开心。白马寺外面的石白马怀旧老铺子的壁画中原第一门 ...继续阅读 (42)

第三天去了白马寺，就是小学课本中的那个白马寺；没有想象中那么好，人山人海人挤人。老街热闹，小吃一条街，各大热门旅游城市好像都有小吃一条街，洛阳这边各种“汤”吃不习惯。“洛阳牡丹甲天下，丽景城楼世无双”，实地看起来也就那样，晚上带小朋友看了暑假正热播的《长安三万里》挺开心。白马寺外面的石白马怀旧老铺子的壁画中原第一门 ...继续阅读 (45)

现在看到的都是新洛阳博物馆，旧馆在关林庙；还是比较壮观的，假期人多;正门壁画牡丹艺术展国色天香黄牡丹北魏洛阳永宁寺永宁寺木塔唐三彩三彩骆驼中国第一龙兽面纹方鼎白玉杯文武俑集灵台三彩马古墓三彩杯文化因素三彩牡丹纹枕文化墙于会见壁画仪仗陶俑群客家人象化石 ...继续阅读 (64)

现在看到的都是新洛阳博物馆，旧馆在关林庙；还是比较壮观的，假期人多;正门壁画牡丹艺术展国色天香黄牡丹北魏洛阳永宁寺永宁寺木塔唐三彩三彩骆驼中国第一龙兽面纹方鼎白玉杯文武俑集灵台三彩马古墓三彩杯文化因素三彩牡丹纹枕文化墙于会见壁画仪仗陶俑群客家人象化石 ...继续阅读 (45)

今夏小朋友放暑假了，一家人去洛阳玩了三天，酷暑炎热.白居易故居白居易石像琵琶峰牡丹石梅花玉伊河龙门石窟介绍文物展小水池指示牌龙门石窟大佛潜溪寺各种佛像宾阳中洞伊阙佛龛之碑指示牌站在东山石窟对面看过去各种神态各异的佛像，颇为壮观。人为的盗凿破坏十分严重，不少成了残缺。 ...继续阅读 (72)

今夏小朋友放暑假了，一家人去洛阳玩了三天，酷暑炎热.白居易故居白居易石像琵琶峰牡丹石梅花玉伊河龙门石窟介绍文物展小水池指示牌龙门石窟大佛潜溪寺各种佛像宾阳中洞伊阙佛龛之碑指示牌站在东山石窟对面看过去各种神态各异的佛像，颇为壮观。人为的盗凿破坏十分严重，不少成了残缺。 ...继续阅读 (51)

hadoop某集群节点宕机以后，集群不能远程ssh，查看log报错信息：sshd:fatal:Access deniedfor user hadoopAdmin by PAM account configuration [preauth]其他信息省略，如下图处理过程：查看账号登录失败统计：pam_tally2 -u root Login Failures Latest failure From root 0 pam_tally2 -u hadoopAdmin Login Failures Latest failure From hadoopAdmin 0根据报错判断是否为PAM授权引起：查看/etc/pam.d/sshd文件cat /etc/pam.d/sshd结果为空，也就是文件存在，但是没内容；处理方法：将/etc/pam.d/sshd文件改名备份，复制其他正常机器的/etc/pam.d/sshd到故障机器，重启sshd服务:systemctl restart sshdssh登录恢复正常，由于该机器是其他人员维护不确定宕机重启前做了哪些操作，该记录仅为记录如何恢复sshd不能登录的问题。 ...继续阅读 (75)

hadoop某集群节点宕机以后，集群不能远程ssh，查看log报错信息：sshd:fatal:Access deniedfor user hadoopAdmin by PAM account configuration [preauth]其他信息省略，如下图处理过程：查看账号登录失败统计：pam_tally2 -u root Login Failures Latest failure From root 0 pam_tally2 -u hadoopAdmin Login Failures Latest failure From hadoopAdmin 0根据报错判断是否为PAM授权引起：查看/etc/pam.d/sshd文件cat /etc/pam.d/sshd结果为空，也就是文件存在，但是没内容；处理方法：将/etc/pam.d/sshd文件改名备份，复制其他正常机器的/etc/pam.d/sshd到故障机器，重启sshd服务:systemctl restart sshdssh登录恢复正常，由于该机器是其他人员维护不确定宕机重启前做了哪些操作，该记录仅为记录如何恢复sshd不能登录的问题。 ...继续阅读 (52)

在一测试机器给SQLServer2019安装补丁时报错Error: 15151, Severity: 16, State: 1.，具体报错如下：2024-01-18 20:48:05.61 spid9s 2024-01-18 20:48:05.62 spid9s2024-01-18 20:48:05.63 spid9s2024-01-18 20:48:05.79 spid9s2024-01-18 20:48:05.79 spid9s2024-01-18 20:48:05.80 spid9s Grant permission to Modulesigne Permission control of the stored procedure Error: 15151, Severity: 16, State: 1. Cannot find the login "##MS SSISServerCleanuploblogin#, because it does not exist or you do not have permission The failed batch of t-sql statements : GRANT VIEW SERVER STATE TO ##MS SSISServerCleanupJobLogin## 2024-01-18 20:48:05.80 5pid9 ...继续阅读 (61)

在一测试机器给SQLServer2019安装补丁时报错Error: 15151, Severity: 16, State: 1.，具体报错如下：2024-01-18 20:48:05.61 spid9s 2024-01-18 20:48:05.62 spid9s2024-01-18 20:48:05.63 spid9s2024-01-18 20:48:05.79 spid9s2024-01-18 20:48:05.79 spid9s2024-01-18 20:48:05.80 spid9s Grant permission to Modulesigne Permission control of the stored procedure Error: 15151, Severity: 16, State: 1. Cannot find the login "##MS SSISServerCleanuploblogin#, because it does not exist or you do not have permission The failed batch of t-sql statements : GRANT VIEW SERVER STATE TO ##MS SSISServerCleanupJobLogin## 2024-01-18 20:48:05.80 5pid9 ...继续阅读 (65)

原始查询SQL:SELECT * FROM abc.Supplier WHERE SupplierFullName like N'%北京美时洁保洁服务有限公司%' AND ValidStatus = 1SupplierFullName字段已有非聚集索引，但是条件是like N'%北京美时洁保洁服务有限公司%'，会造成索引扫描。优化思路：如果查询条件可以为 like N'北京美时洁保洁服务有限公司%'可以走索引，需要系统开始设计时就需设计合理。如若不能可以使用Charindex代替like:SELECT * FROM dbo.abc WHERE Charindex('北京美时洁保洁服务有限公司',SupplierFullName)>0 AND ValidStatus = 1在1千万+的表里面，使用Charindex约能节约1/3的时间，可用下面的SQL测试下实际执行速度declare @Charindex datetime set @Charindex = getdate() SELECT * FROM dbo.abc WHERE Charindex('北京美时洁保洁服务有限公司',SupplierFullName)>0 AND ValidStatus = 1 select [Charindex执行花费时间(毫秒)]=dat ...继续阅读 (69)

原始查询SQL:SELECT * FROM abc.Supplier WHERE SupplierFullName like N'%北京美时洁保洁服务有限公司%' AND ValidStatus = 1SupplierFullName字段已有非聚集索引，但是条件是like N'%北京美时洁保洁服务有限公司%'，会造成索引扫描。优化思路：如果查询条件可以为 like N'北京美时洁保洁服务有限公司%'可以走索引，需要系统开始设计时就需设计合理。如若不能可以使用Charindex代替like:SELECT * FROM dbo.abc WHERE Charindex('北京美时洁保洁服务有限公司',SupplierFullName)>0 AND ValidStatus = 1在1千万+的表里面，使用Charindex约能节约1/3的时间，可用下面的SQL测试下实际执行速度declare @Charindex datetime set @Charindex = getdate() SELECT * FROM dbo.abc WHERE Charindex('北京美时洁保洁服务有限公司',SupplierFullName)>0 AND ValidStatus = 1 select [Charindex执行花费时间(毫秒)]=dat ...继续阅读 (54)

CentOS7.9升级pip时报错：pip install --upgrade pip Collecting pip Using cached https://files.pythonhosted.org/packages/1f/7f/4da15e07ccd11c84c1ccc8f6e24288d5e76c99441bf80e315b33542db951/pip-23.3.1.tar.gz Complete output from command python setup.py egg_info: Traceback (most recent call last): File "", line 1, inFile "/tmp/pip-build-8ikW7F/pip/setup.py", line 7 def read(rel_path: str) -> str: ^ SyntaxError: invalid syntax ---------------------------------------- Command "python setup.py egg_info" failed with error code 1 in /tmp/pip-build-8ikW7 ...继续阅读 (61)

CentOS7.9升级pip时报错：pip install --upgrade pip Collecting pip Using cached https://files.pythonhosted.org/packages/1f/7f/4da15e07ccd11c84c1ccc8f6e24288d5e76c99441bf80e315b33542db951/pip-23.3.1.tar.gz Complete output from command python setup.py egg_info: Traceback (most recent call last): File "", line 1, inFile "/tmp/pip-build-8ikW7F/pip/setup.py", line 7 def read(rel_path: str) -> str: ^ SyntaxError: invalid syntax ---------------------------------------- Command "python setup.py egg_info" failed with error code 1 in /tmp/pip-build-8ikW7 ...继续阅读 (57)

LNMP安装完毕后，MySQL启动时报错，log如下：This crash occured while the server was calling initgroups(). This is often due to the use of a mysqld that is statically linked against glibc and configured to use LDAP in /etc/nsswitch.conf. You will need to either upgrade to a version of glibc that does not have this problem (2.3.4 or later when used with nscd), disable LDAP in your nsswitch.conf, or use a mysqld that is not statically linked. 231108 12:33:01 mysqld_safe mysqld from pid file /usr/local/mysql/var/xadns.pid ended something is definitely wrong and this may fail. key_buffer_size=0 read_buffer_size= ...继续阅读 (72)

LNMP安装完毕后，MySQL启动时报错，log如下：This crash occured while the server was calling initgroups(). This is often due to the use of a mysqld that is statically linked against glibc and configured to use LDAP in /etc/nsswitch.conf. You will need to either upgrade to a version of glibc that does not have this problem (2.3.4 or later when used with nscd), disable LDAP in your nsswitch.conf, or use a mysqld that is not statically linked. 231108 12:33:01 mysqld_safe mysqld from pid file /usr/local/mysql/var/xadns.pid ended something is definitely wrong and this may fail. key_buffer_size=0 read_buffer_size= ...继续阅读 (43)

Debian10系统在启动ss服务时报错，其他日志省略... "/lib/x86_64-linux-gnu/libcrypto.so.1.1: undefined symbol: EVP_CIPHER_CTX_cleanup"查看openssl版本：openssl version OpenSSL 1.1.1n 15 Mar 2022报错的原因：在openssl1.1.0及以后的版本中，废弃了EVP_CIPHER_CTX_cleanup函数。解决办法：找到shadowsocks/crypto/中的openssl.py，如：vim /usr/local/lib/python2.7/dist-packages/shadowsocks/crypto/openssl.py将该文件中所有的EVP_CIPHER_CTX_cleanup替换为EVP_CIPHER_CTX_reset保存即可。:%s/EVP_CIPHER_CTX_cleanup/EVP_CIPHER_CTX_reset :wq ...继续阅读 (69)

Debian10系统在启动ss服务时报错，其他日志省略... "/lib/x86_64-linux-gnu/libcrypto.so.1.1: undefined symbol: EVP_CIPHER_CTX_cleanup"查看openssl版本：openssl version OpenSSL 1.1.1n 15 Mar 2022报错的原因：在openssl1.1.0及以后的版本中，废弃了EVP_CIPHER_CTX_cleanup函数。解决办法：找到shadowsocks/crypto/中的openssl.py，如：vim /usr/local/lib/python2.7/dist-packages/shadowsocks/crypto/openssl.py将该文件中所有的EVP_CIPHER_CTX_cleanup替换为EVP_CIPHER_CTX_reset保存即可。:%s/EVP_CIPHER_CTX_cleanup/EVP_CIPHER_CTX_reset :wq ...继续阅读 (52)

Debian 10和Debian 9一样，没有rc.local文件，导致我们有一些脚本无法设置开机启动，查看默认状态：systemctl status rc-local rc-local.service - /etc/rc.local Compatibility Loaded: loaded (/lib/systemd/system/rc-local.service; static; vendor preset: enabled) Drop-In: /usr/lib/systemd/system/rc-local.service.d └─debian.conf Active: inactive (dead) Docs: man:systemd-rc-local-generator(8)手工创建：touch /etc/rc.local添加如下内容：#!/bin/sh -e # # rc.local # # This script is executed at the end of each multiuser runlevel. # Make sure that the script will "exit 0" on success or any other # value on error. # # In order to enab ...继续阅读 (57)

巡检的时候发现同步报错：SHOW SLAVE STATUS\G Last_IO_Errno: 1236 Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'Client requested master to start replication from position > file size'原因：节点宕机或其他各种原因导致二进制日志文件已经被清理，导致复制进程出错。解决：先使用SHOW SLAVE STATUS\G查找 Relay_Log_Pos 和 Relay_Master_Log_File 字段，确保它们指向正确的二进制日志文件和位置，在重新重置复制进程即可。STOP SLAVE; RESET SLAVE; CHANGE MASTER TO MASTER_LOG_FILE='log_file_name', MASTER_LOG_POS=log_position; START SLAVE; ...继续阅读 (66)