Error Record
各种各样的bug解决方案
PerpetualLearner
这个作者很懒,什么都没留下…
展开
-
(20210412Solved)Grafana一张图只能显示26
Overview向Grafana某个panel中添加超过26条线之后,后续的线显示不出来。用英语表述maybe:How to display more than 26 sqls in Grafana ?SolutionYou can manually edit the JSON file and replace the letters with numbers in refId.Grafana默认添加line后期refId是依据Alphabeta递增的,超过26个英文字母之后,ref..原创 2021-04-24 14:28:45 · 1399 阅读 · 0 评论 -
(20210317Solved) Catch the IntegrityError about PostgreSQL in Python
Overview通过python api向postgresql存入数据出现重复数据,会报错IntegrityError,如何捕捉?Solution通过sqlalchemy使用Python API。The sqlalchemy wraps the psycopg2 exception to its own exception.from sqlalchemy.exc import IntegrityErrortry: ...except IntegrityError as e: ..原创 2021-03-29 10:30:26 · 175 阅读 · 0 评论 -
(20210316已解决)docker-compose创建postgresql容器exited with code 1
Overview通过docker-compose创建postgresql容器总是失败,log显示为containerName exited with code 1Exit Code 1: Indicates failure due to application errorSolutiondocker-compose.yaml文件中添加environment变量:environment: POSTGRES_USER: example POSTGRES_PASSWORD: ..原创 2021-03-27 10:42:29 · 1730 阅读 · 0 评论 -
(20210316已解决)postgresql cannot execute CREATE TABLE in a read-only transation
Overview如题,在一个postgresql 的docker container里创建数据库出现上述错误。SolutionNormally the most plausible reasons for this kinde of error are:trying create statements on a read-only replica (the entire instance is read-only)<username> has default_transact..原创 2021-03-27 10:39:51 · 4052 阅读 · 0 评论 -
(20210302已解决)WARNING: Found orphan containers for this project.
Overview通过docker-compose up启动容器,出现下述warnning:WARNING: Found orphan containers (name1, name2) for this project. If you removed or renamed this service in your compose file, you can run this command with the --remove-orphans flag to clean it up.Anal..原创 2021-03-06 10:26:50 · 10480 阅读 · 1 评论 -
(20210302已解决)docker启动clickhouse:Include not found: clickhouse_remote_servers
Overview如题,用docker-compose up启动clickhouse出现上述问题:Include not found: clickhouse_remote_serversAnalysisFrom Alexey, these messages are just notices.Corresponding includes are mentioned in server’s config.xml and user.xml and are optional AFAIK.To b..原创 2021-03-06 10:24:57 · 2475 阅读 · 2 评论 -
(20210302已解决)clickhouse docker, as it does not belong to the default network
Overview通过client容器连接server容器出现如下问题:docker: Error response from daemon: Cannot link to /clickhouse_20.8.13.15, as it does not belong to the default networkclickhouse_20.8.13.15是我自定义的clickhouse server容器。Analysis理解Creating network “projectName_def..原创 2021-03-06 10:23:27 · 1691 阅读 · 0 评论 -
(20210301未解决)error: chmod on /path/.git/config.lock failed: Operation not permitted
Overview如题error: chmod on /path/.git/config.lock failed: Operation not permitted问题分析From R1, the reason is :The linux command chmod is not supported by NTFS.Solution which it suggest is :mkdir -p /home/user/.gitconfigs/myrepoln -s /home/user/...原创 2021-03-06 10:21:46 · 4672 阅读 · 1 评论 -
(20210223已解决)Grafana经常出现Bad Gateway
Overview在一个dashboard中放置了多个表,总是会有几个出现Bad Gateway数据库网络问题,非Grafana层面问题。ReferencesHTTP Error Bad Gateway when using prometheus原创 2021-03-06 09:59:41 · 8676 阅读 · 2 评论 -
(20210221已解决)如何将本地已有文件夹push到github并新建仓库
OverviewIn english, maybe this question:How to push local directory to github, and create a new repository?SolutionsGithub: Create a new repository on Github, get the https URL创建时保证是空的,不要添加Readme或.gitignore, 避免出现 master had recent pushes Compa..原创 2021-03-07 12:32:04 · 930 阅读 · 0 评论 -
(202100219已解决)pandas删除全为0值的列
Overviewdf.loc[:, (df != 0).any(axis=0)]ReferenceHow do I delete a column that contains only zeros in Pandas?原创 2021-02-21 10:08:52 · 4805 阅读 · 0 评论 -
(20210219已解决)Pandas禁止科学计数法
Overviewpd.set_option('display.float_format',lambda x : '%.3f' % x)Referencespandas禁用科学计数法、输出时显示全部行原创 2021-02-21 10:07:12 · 3120 阅读 · 0 评论 -
(20210219已解决)git使用中出现Please make sure you have the correct access rights and the repository exists.
Overviewssh: Could not resolve hostname git_address: Name or service not knownfatal: Could not read from remote repository.Please make sure you have the correct access rightsand the repository exists出现上述问题是因为本地环境无法通过ssh连接到目标git仓库,本质是ssh层面的问题,需要设置本..原创 2021-02-21 10:06:07 · 414 阅读 · 0 评论 -
(20210216未解决)VSCode如何设置自动刷新文件夹
Overview目前似乎还没有办法实现ReferencesVisual Studio Code: Auto-refresh file changesvs code 左侧资源管理器如何配置自动刷新?原创 2021-02-21 10:02:23 · 3039 阅读 · 2 评论 -
(20210130已解决)WSL重置密码
OverviewWSL重置密码解决方案进入powershell:wsl -u root重置特定用户密码:passwd useridReferencesReset WSL password原创 2021-01-30 23:04:05 · 585 阅读 · 0 评论 -
(20210129已解决)SyntaxError: Non-ASCII character ‘\xe6‘ in file filename.py , but no encoding decla
Overview如题,运行程序出现上述提示。原因解析这个问题经常是出现在crontab设置运行python时。同样的程序,在IDE中直接运行是正常的。The reason why it works differently in console and in the IDE is, likely, because of different default encoding set. You can check it by running:Limport sysprint(sys.getd..原创 2021-01-29 20:28:51 · 658 阅读 · 1 评论 -
(20210116已解决)Windows下的CTF加载程序是什么?
OverviewWindows电脑卡顿,查看任务管理器,有一个CTF加载程序占用CPU35%。CTF加载程序 ctfmon.exectfmon.exe 是与输入法有关的进程,如果禁用,可能无法正常使用切换输入法。解决方案通过R1中微软官方给出的方案:Win+R输入:msconfig 打开系统配置点击”服务”标签卡,勾选”隐藏所有的 Microsoft 服务”,然后点击全部禁用(若您启用了指纹识别功能,请不要关闭相关服务)点击”启动”标签卡, 点击”打开任务管理器”,然后禁用全部..原创 2021-01-29 20:22:59 · 57751 阅读 · 0 评论 -
(20201222已解决)config file (“filebeat.yml“) must be owned by the user identifier (uid=0) or root
问题描述在Filebeat 容器内运行:./filebeat modules list出现错误:Error initializing beat: error loading config file: config file (“filebeat.yml”) must be owned by the user identifier (uid=0) or root解决方案ll查看filebeat.yml权限为配置文件中的登录用户。From Config File Ownership ..原创 2020-12-25 21:42:39 · 6278 阅读 · 1 评论 -
(20201218已解决)Kibana server is not ready yet||如何登录Kibana
问题描述Elasticsearch 设置密码保护之后就出现如题错误,Kibana server is not ready yet.网上有些解决方案说修改Kibana.yml里的elasticsearch.hosts: [ "http://elasticsearch:9200" ],此方案只对于ElasticSearch尚未设置密码保护的情况会起作用。本例中无效。解决方案From Configure Kibana doc, If your Elasticsearch is protected ..原创 2020-12-19 19:43:09 · 1140 阅读 · 1 评论 -
(20201214已解决)elasticsearch下载curl: (7) Failed to connect to raw.githubusercontent.com port 443: Conn
问题描述curl请求某个文件出错:curl -L -O https://raw.githubusercontent.com/elastic/beats/7.10/deploy/docker/filebeat.docker.ymlcurl: (7) Failed to connect to raw.githubusercontent.com port 443: Connection refused解决方案网上提到的关于这个问题大多是因为安装homebrew时出现的.本例中,直接在浏览..原创 2020-12-19 19:41:49 · 243 阅读 · 1 评论 -
理解IntelliCode Python support requires you to use the Microsoft Python Language Server (preview)
起源打开VSCode出现IntelliCode Python support requires you to use the Microsoft Python Language Server (preview)解决方案卸载Visual Studio IntelliCode 插件后续研究ReferenceVisual Studio Code | 问题解决Problems with Visual Studio IntelliCode - Preview & Pytho..原创 2020-12-04 22:14:29 · 952 阅读 · 0 评论 -
wsl启动程序异常-bash: /usr/lib/command-not-found: /usr/bin/python3: bad interpreter: No such file or direc
问题描述通过VS Code在window上wsl界面运行程序,出现上述错误.-bash: /usr/lib/command-not-found: /usr/bin/python3: bad interpreter: No such file or directory解决方案两种解决方案:如果/usr/bin/python3存在,将/usr/bin加入PATH如果/usr/bin/python3不存在,创建软链接...原创 2020-11-29 21:58:04 · 1148 阅读 · 0 评论 -
(20201126已解决)WSL运行virtualenv venv创建虚拟环境出错
问题描述如题,在VS Code+WSL中运行virtualenv venv出现下属错误:FileNotFoundError: [Errno 2] No such file or directory: 'c:\\users\\name\\anaconda3\\Lib\\venv\\scripts\\nt\\python.exe'平台是window,上述路径下确实没有Python.exe.解决方案主要原因是WSL调用了安装在window上的Anaconda。如果要在wsl中使用python..原创 2020-11-29 21:39:28 · 2064 阅读 · 0 评论 -
(20201126已解决)wind接口出错No such file WindPy.pth
问题描述如图,运行wind接口出现上述错误.解决方案将C:\Users\anaconda3\Lib\site-packages下面的WindPy.pth复制到上述路径,问题得到解决,但是不确定是否会有副作用.原创 2020-11-29 21:34:40 · 1466 阅读 · 0 评论 -
Alpine做基础的Grafana docker容器安装Dolphindb遇到的各种问题
起源grafana官方推荐docker版本是基于Alpine做的,因为其Small, Simple, Secure.正是因为太Small了,很多utilities都没有就遇到各种问题.Dolohindb插件用Grafana连接接DolphinDB需要安装Dolphindb自己开发的插件,然后重启grafana服务,在Window或Linux上都不复杂,但是在docker容器内相对麻烦.使用流程及所遇问题插件安装grafana官方推荐Alpine版本的image.通过doc..原创 2020-11-22 10:33:40 · 1184 阅读 · 0 评论 -
(20201105Solved)docker-compose yaml映射进去的文件无法访问
问题描述宿主机映射路径到容器内部,在容器内部却无法访问,显示permission denied.解决方案原因是,宿主机上对应的文件夹权限不足原创 2020-11-22 10:31:56 · 525 阅读 · 0 评论 -
(20201114Solved)docker-compose出错standard_init_linux.go:211: exec user process caused “no such file
问题描述docker-compose up创建容器出现问题:standard_init_linux.go:211: exec user process caused "no such file or directory"comtainer exited with code 1容器创建后显示STATUS为exited,并且无法start。原因解析网络调查下来,大概有两个原因:1.entrypoint启动脚本格式yum install dos2unixdos2unix *.shdo..原创 2020-11-14 16:21:34 · 527 阅读 · 0 评论 -
(20201029 Solved)rsync卡住timeout after 60 seconds -- exiting
Overviewr1中提到这种错误可能是timeout问题,加上timeout确实可以让程序失败后自动退出,但是不解决问题.此处问题可能是因为rsync使用了z,即压缩传输.但是传输是很多小体量的文件,加上z反而速度慢了,因为瓶颈从网络io转移到了CPU计算,通过top可以看到rsync占用大量cpu,因为cpu性能不够所以卡死.此处去掉,问题解决Referencesrsync文件同步失败问题排查记录Bug 645236 - with big file, rsync times ..原创 2020-11-01 12:30:07 · 2746 阅读 · 0 评论 -
(20201029Solved)pip install ERROR: Could not find a version that satisfies the requirement
问题描述如题所述,安装某些包时候,总是说找不到.方案一pip install pip --upgrade无效更新pip3可行,但是找不到本例原因就本ID所遇情况,是因为所装的anaconda3是32位的,改成64位之后问题解决Referencepip Install Error: don’t could find version that satisfies the requirement tensorflow...原创 2020-11-01 12:19:56 · 277 阅读 · 0 评论 -
(20201026Solved)TypeError: ufunc ‘isnan‘ not supported for the input types, and the inputs could no
问题描述Traceback (most recent call last): File "<string>", line 1, in <module>TypeError: ufunc 'isnan' not supported for the input types, and the inputs could not be safely coerced to any supported types according to the casting rule ''safe'..原创 2020-11-01 12:11:34 · 617 阅读 · 0 评论 -
(20201024Solved)vsCode debug出现no such file or directory:‘/home/user/.local/lib‘
问题描述python file.py可以正常运行,对其进行debug就出现如题问题:no such file or directory: '/home/user/.local/lib'看运行路径,应该是python在进行os路径检查.思路梳理关键字debug一个文件的实际内容之前,vscode会先进行检查,出问题的函数是:home/user/anaconda3/lib/python3.8/posixpath.py中# This will always return fals..原创 2020-10-25 18:46:23 · 1962 阅读 · 1 评论 -
(20200915Solved)Vscode出现Unable to open ‘hashtable_class_helper.pxi‘
问题描述Unable to open ‘hashtable_class_helper.pxi’: Unable to read file ‘vscode-remote://ssh-remote+data1/home/data/anaconda3/lib/python3.7/site-packages/pandas/_libs/hashtable_class_helper.pxi’ (Error: Unable to resolve non-existing file ‘vscode-remote:/..原创 2020-10-18 21:54:38 · 1150 阅读 · 0 评论 -
VSCode Debug Failure: -bash: C:/Anaconda3/Scripts/activate: No such file or directory||conda: comman
问题描述在Windows使用VSCode进行debug出现如题错误。解决方案windows中安装了WSL。因为VScode Terminal中使用的default shell 是wsl,而wsl中并没有安装Anaconda,Anaconda是安装在windows中的。将terminal中default shell设置为cmd.exe,问题解决...原创 2020-08-15 08:49:11 · 631 阅读 · 0 评论 -
(20200720已解决)UnicodeDecodeError: ‘utf-8‘ codec can‘t decode byte 0x80 in position 7: invalid start b
问题描述如题解决方案因为pickle文件写入是binary格式,因此读取的时候也需要用binary格式。return = open("picklefile", 'rb')出现另外一个问题:_pickle.UnpicklingError: A load persistent id instruction was encountered,but no persistent_load function was specified.参见《(20200720已解决)_pickle.Unpi..原创 2020-08-14 20:10:23 · 1068 阅读 · 0 评论 -
(20200720已解决)_pickle.UnpicklingError: A load persistent id instruction was encountered,
but no persistent_load function was specified.问题描述如题,提取pickle数据解决方案直接解释是因为生成pickle文件的过程中使用了persistent_load,但是读取过程中没有提供。本例中的具体原因是,读取的pickle文件并非pickle格式,只是用pickle这个词表示这是一个规范压缩的数据文件,改用合适的read_*()函数就可以了...原创 2020-08-13 21:04:38 · 19329 阅读 · 19 评论 -
Python如何解决sqlite3.DatabaseError: database disk image is malformed
SQLiteSQLite is a C-language library that implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine.SQLite is an embedded SQL database engine. Unlike most other SQL databases, SQLite does not have a seprate server p..原创 2020-06-06 17:15:27 · 4162 阅读 · 0 评论 -
(已解决)Sanic websocket concurrent.futures._base.CancelledError
问题描述websocket方式连接Sanic服务器,经常断开连接。解决方案aiohttp throws CancelledError into coroutine if http connection was disconnected.1这个问题本源在于websocket连接断开了,在本例中因为websocket server是每隔几分钟推送有一次数据,时间间隔太长导致连接断开。进而导致如下错误:websockets.exceptions.ConnectionClosedError: co..原创 2020-05-31 15:12:36 · 4544 阅读 · 2 评论 -
(20200422已解决)RuntimeWarning: coroutine 'WebSocketCommonProtocol.send' was never awaited
问题描述websocket 服务端爆出如上问题。解决方案问题的出现是由于在async def定义的函数内部使用了loop=asyncio.get_event_loop(),需要将事件循环提取到async def函数外面ReferencesLearning asyncio: “coroutine was never awaited” warning errorCommo...原创 2020-04-26 22:27:26 · 17970 阅读 · 2 评论 -
(20200423已解决)Sanic.websocket出现RuntimeError: this event loop is already running.
问题描述运行Sanic WebSocket服务器,出现如题错误。解决方案原因是在app.websockt('/')下的async def内又一次调用了loop=asyncio.get_event_loop().而Sanic的app.run()其实内部已经起了一个event_loop.将async def内的loop=asyncio.get_event_loop()取消,改用awa...原创 2020-04-26 22:14:15 · 1076 阅读 · 0 评论 -
UnicodeEncodeError: 'latin-1' codec can't encode characters in position 61-65: Body ('异常') is not va
问题描述使用request.post发送使用unicode编码的文字出现上述问题。UnicodeEncodeError: 'latin-1' codec can't encode characters in position 61-65: Body ('异常') is not valid Latin-1. Use body.encode('utf-8') if you want to se...原创 2020-04-20 22:10:14 · 1318 阅读 · 0 评论