<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[book_1992的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/book_1992</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; book_1992]]></copyright><item><title><![CDATA[sqlchemy stmt实现: 批量更新；若A字段值大于新值，则不更新A字段值（其他字段正常更新）]]></title><link>https://blog.youkuaiyun.com/book_1992/article/details/134325203</link><guid>https://blog.youkuaiyun.com/book_1992/article/details/134325203</guid><author>book_1992</author><pubDate>Fri, 10 Nov 2023 09:24:15 +0800</pubDate><description><![CDATA[stmt的解释：根据id批量更新SearchContentDocTask表对应行数据，更新时比较next_sync_time的值，若新值大于原表值，则next_sync_time为新值，其他字段正常更新。]]></description><category></category></item><item><title><![CDATA[cenos7安装wkhtmltopdf]]></title><link>https://blog.youkuaiyun.com/book_1992/article/details/131643527</link><guid>https://blog.youkuaiyun.com/book_1992/article/details/131643527</guid><author>book_1992</author><pubDate>Mon, 10 Jul 2023 17:09:22 +0800</pubDate><description><![CDATA[4. 测试：wkhtmltopdf.sh www.baidu.com 2.pdf。]]></description><category></category></item><item><title><![CDATA[postgre容器一直处于restarting状态，无法启动的问题]]></title><link>https://blog.youkuaiyun.com/book_1992/article/details/131308333</link><guid>https://blog.youkuaiyun.com/book_1992/article/details/131308333</guid><author>book_1992</author><pubDate>Tue, 20 Jun 2023 15:41:07 +0800</pubDate><description><![CDATA[5. 在这个文件夹里面找到上面日志的pg_hba.conf文件，根据日志显示是92行有问题，那直接编辑该文件的第92行，把该行直接注销掉，然后wq保存退出。1. 通过指令：docker logs 容器名称；2. 通过指令: docker inspect 容器名称；查看容器基本详情信息。6. 保存退出文件后，容器即正常启动。]]></description><category></category></item><item><title><![CDATA[arrow：墨西哥时区转化异常，转成了GMT-5]]></title><link>https://blog.youkuaiyun.com/book_1992/article/details/130834663</link><guid>https://blog.youkuaiyun.com/book_1992/article/details/130834663</guid><author>book_1992</author><pubDate>Tue, 23 May 2023 20:23:15 +0800</pubDate><description><![CDATA[arrow用的是系统文件usr/share/zoneinfo，其取墨西哥的时区信息的路径为：/usr/share/zoneinfo/America/Mexico_City。墨西哥2022-10的时候废弃了夏令时，现在只有GMT-6。]]></description><category></category></item><item><title><![CDATA[aiokafka：Heartbeat failed: local member_id was not recognized； resetting and re-joining group]]></title><link>https://blog.youkuaiyun.com/book_1992/article/details/127412270</link><guid>https://blog.youkuaiyun.com/book_1992/article/details/127412270</guid><author>book_1992</author><pubDate>Wed, 19 Oct 2022 17:38:26 +0800</pubDate><description><![CDATA[1.修改了很多消费组的配置，诸如session_timeout_ms、max_poll_interval_ms，最终都没有什么效果；2. 最终只有了一个治标的方法：在耗时并且只能同步执行的代码处加入0.1睡眠时间，这0.1秒的睡眠时间可以让消费组去发送心跳。再次查看错误信息，怀疑是消费组心跳没有发送/发送心跳超市导致服务端认为消费组已经死亡，从而当消费组发起心跳后会出现异常。根据错误信息的提示是max_poll_interval_ms设置太小，但经过修改后发现并不是这个原因；]]></description><category></category></item><item><title><![CDATA[sqlchemy: ‘Lost connection to MySQL server during query]]></title><link>https://blog.youkuaiyun.com/book_1992/article/details/126618984</link><guid>https://blog.youkuaiyun.com/book_1992/article/details/126618984</guid><author>book_1992</author><pubDate>Wed, 31 Aug 2022 10:36:35 +0800</pubDate><description><![CDATA[db连接丢失，sql执行失败]]></description><category></category></item><item><title><![CDATA[aiokafka: Unexpected error during batch delivery KafkaError]]></title><link>https://blog.youkuaiyun.com/book_1992/article/details/122204414</link><guid>https://blog.youkuaiyun.com/book_1992/article/details/122204414</guid><author>book_1992</author><pubDate>Tue, 28 Dec 2021 22:32:15 +0800</pubDate><description><![CDATA[现象：协程往topic推送数据时候抛出异常:Unexpected error during batch delivery KafkaError ;最终导致消息推送失败;



原因：仅多个协程同时使用同一个生产者执行start函数，导致启动异常



解决：让生产者start后才让协程推送数据.
...]]></description><category></category></item><item><title><![CDATA[git:进行push的时候没有反应]]></title><link>https://blog.youkuaiyun.com/book_1992/article/details/120800577</link><guid>https://blog.youkuaiyun.com/book_1992/article/details/120800577</guid><author>book_1992</author><pubDate>Mon, 18 Oct 2021 15:04:36 +0800</pubDate><description><![CDATA[使用gitpush指令的时候没任何反应，过一段时候后输出：


ssh: connect to host 10.48.8.10 port 22: Connection timed out
fatal: Could not read from remote repository.

解决方式：

1.vim/root/.ssh/config

2.输入以下内容：


host gitlab.com
  Hostname altssh.gitlab.com
  User git
  Port 443
 ...]]></description><category></category></item><item><title><![CDATA[pandas：执行merge后，发现填充列的数据精度丢失（数据不准确）]]></title><link>https://blog.youkuaiyun.com/book_1992/article/details/120700323</link><guid>https://blog.youkuaiyun.com/book_1992/article/details/120700323</guid><author>book_1992</author><pubDate>Mon, 11 Oct 2021 12:01:05 +0800</pubDate><description><![CDATA[现象：

两个df对象：A和B（A对象无id列，B对象有，int64类型）；

通过merge得到df对象C（其中on为['type']），发现C的id列数据精度丢失了（数据不准确了）

原因：

当merge时，部分行的id为nan，此时pandas会将id列的类型转成float；

当id的数值太大是（超过12位），此时转换成float后得到的id将不准确。

ps：

如果merge时，不存在行的id为nan，则pandas不会进行转换，此时id列的数据函数准确的（还是int64）。

测试示例：
.]]></description><category></category></item><item><title><![CDATA[sqlalchemy:在执行更新操作时，一直等待着（没报错）]]></title><link>https://blog.youkuaiyun.com/book_1992/article/details/118551677</link><guid>https://blog.youkuaiyun.com/book_1992/article/details/118551677</guid><author>book_1992</author><pubDate>Wed, 07 Jul 2021 16:49:20 +0800</pubDate><description><![CDATA[错误情况：

一直卡在execute，没有跑错，但也没有成功跑过去。

实例代码：


stmt = update(XXXTable).where(XXXTable.id == record['id']).values(update_value)
awaitasync_session.execute(stmt)

原因：

个人推测是，插入的值（dict）其中的key和table的栏位字段不完全匹配。

解决方式：

将插入值的和表的字段匹配起来


# record是一个dict
update_col..]]></description><category></category></item><item><title><![CDATA[JS：Buffer转 array， array 转Buffer； int8array转Buffer； array转 int8Array]]></title><link>https://blog.youkuaiyun.com/book_1992/article/details/115735091</link><guid>https://blog.youkuaiyun.com/book_1992/article/details/115735091</guid><author>book_1992</author><pubDate>Thu, 15 Apr 2021 19:14:58 +0800</pubDate><description><![CDATA[array 转 int8array
let array = [];
for (let i = 0; i &lt; 10 ; i++ {
	array[i] = i
}
let array_int8 = Uint8Array.from(array)

Buffer转array
let array = [];
let buffer = new Buffer.from(xx);
for (let i = 0; i &lt; buffer.length ; i++ {
	array[i] = buffer[i];
]]></description><category></category></item><item><title><![CDATA[request: 设置重连次数]]></title><link>https://blog.youkuaiyun.com/book_1992/article/details/115521547</link><guid>https://blog.youkuaiyun.com/book_1992/article/details/115521547</guid><author>book_1992</author><pubDate>Thu, 08 Apr 2021 15:21:18 +0800</pubDate><description><![CDATA[#设置重连次数
requests.adapters.DEFAULT_RETRIES = 15
# 设置连接活跃状态为False
s = requests.session()
s.keep_alive = False
]]></description><category></category></item><item><title><![CDATA[airflow ：运行/执行 单个tasks 指令]]></title><link>https://blog.youkuaiyun.com/book_1992/article/details/115492400</link><guid>https://blog.youkuaiyun.com/book_1992/article/details/115492400</guid><author>book_1992</author><pubDate>Wed, 07 Apr 2021 18:22:40 +0800</pubDate><description><![CDATA[指令：airflow tasks test dag_id task_id date
eg： airflow tasks test my_demo word_example  20200101

]]></description><category></category></item><item><title><![CDATA[airflow: 单独使用指令测试task可以成功运行，但是通过ui跑整个dag则失败]]></title><link>https://blog.youkuaiyun.com/book_1992/article/details/115484403</link><guid>https://blog.youkuaiyun.com/book_1992/article/details/115484403</guid><author>book_1992</author><pubDate>Wed, 07 Apr 2021 14:13:14 +0800</pubDate><description><![CDATA[失败信息：
INFO - Task exited with return code Negsignal.SIGABRT

解决方法:
在控制台中输入：export OBJC_DISABLE_INITIALIZE_FORK_SAFETY=YES
参考：https://airflow.apache.org/blog/airflow-1.10.10/#running-airflow-on-macos
https://github.com/apache/airflow/issues/12808

...]]></description><category></category></item><item><title><![CDATA[airflow: 新建的dag没有显示在web ui 上]]></title><link>https://blog.youkuaiyun.com/book_1992/article/details/115447462</link><guid>https://blog.youkuaiyun.com/book_1992/article/details/115447462</guid><author>book_1992</author><pubDate>Mon, 05 Apr 2021 20:26:54 +0800</pubDate><description><![CDATA[问题 在 dags文件夹中创建了一个 demo_dag.py 后，没有正常显示在 web ui 上
原因


demo_dag.py文件内的代码有问题，此时在web ui上的首页可以看到有错误提示


没有重启 webserver，具体原因不明，在google上看到的解决方案就是把webserver和scheduler都关掉，然后重启


其他发现

发现airflow的数据库写入失败，此时执行 airflow dags list 可以看到 自定义的dag ，其pause值为none，而其他正常的dag的p]]></description><category></category></item><item><title><![CDATA[安装swoole， php.h不存在：Big Sur 安装php扩展报错]]></title><link>https://blog.youkuaiyun.com/book_1992/article/details/114257036</link><guid>https://blog.youkuaiyun.com/book_1992/article/details/114257036</guid><author>book_1992</author><pubDate>Mon, 01 Mar 2021 10:47:12 +0800</pubDate><description><![CDATA[参考：https://profilingviewer.com/installing-xdebug-on-bigsur.html#build

中文参考：https://l1905.github.io/php/2020/02/28/macos-pecl-xdebug-mongodb/
]]></description><category></category></item><item><title><![CDATA[Xcode：无法打开Xcode，一直循环显示install additional required components]]></title><link>https://blog.youkuaiyun.com/book_1992/article/details/113766469</link><guid>https://blog.youkuaiyun.com/book_1992/article/details/113766469</guid><author>book_1992</author><pubDate>Tue, 09 Feb 2021 09:51:08 +0800</pubDate><description><![CDATA[现象
点击Xcode，弹出显示框 『install additional required components』。
点击安装后提示输入账户密码。
输入完毕之后开始安装。
安装完毕后又重新弹出install additional required components。
一直这样循环，无法打开xcode
解决
在google了各种解决办法后都无法解决。
包括重装Xcode（下载重装和 App store重装）都试过，没用。
最终在react-native项目中打开命令行，输入：yarn react-nati]]></description><category></category></item><item><title><![CDATA[RN：android设备启动后立即闪退（连启动画面都没有进去）]]></title><link>https://blog.youkuaiyun.com/book_1992/article/details/113661808</link><guid>https://blog.youkuaiyun.com/book_1992/article/details/113661808</guid><author>book_1992</author><pubDate>Thu, 04 Feb 2021 18:20:22 +0800</pubDate><description><![CDATA[ios设备运行RN项目没有问题，当android设备运行时发现会立即闪退，经过排查后有两种原因造成：


权限问题，没有获取到对应权限，即调用了一些权限代码（读取联系人）等。


编译问题。


解决方法：


直接在设置里面设置应用权限后即可，但实际上应从代码逻辑上添加权限询问机制（逻辑）。


移出build目录下的所有内容，build路径：项目名/android/app/build



...]]></description><category></category></item><item><title><![CDATA[RN：自定义Toask]]></title><link>https://blog.youkuaiyun.com/book_1992/article/details/112967042</link><guid>https://blog.youkuaiyun.com/book_1992/article/details/112967042</guid><author>book_1992</author><pubDate>Thu, 21 Jan 2021 17:02:22 +0800</pubDate><description><![CDATA[新建js文件：
import React, { Component } from 'react';
import { StyleSheet, Animated, Text, View, Modal, Easing } from 'react-native';
import UiUtils from '../UiUtils';
let utils = new UiUtils();
utils.setHeightCalculateEnable(2224);
const getDeviceValue = util]]></description><category></category></item><item><title><![CDATA[RN: iOS工程pod install realm 失败（realm-sync-cocoa无法下载）]]></title><link>https://blog.youkuaiyun.com/book_1992/article/details/112708029</link><guid>https://blog.youkuaiyun.com/book_1992/article/details/112708029</guid><author>book_1992</author><pubDate>Sat, 16 Jan 2021 15:03:15 +0800</pubDate><description><![CDATA[在react-native项目总添加 realm时，发现在iOS工程中无法下载realm-sync-cocoa，一直卡在：
Installing RealmJS (10.1.3)
 &gt; Running prepare command
   $ /bin/bash -c  set -e ./scripts/xcode-download-realm.sh ./scripts
   Resolved requirements: {
     SYNC_SERVER_FOLDER: 'sync',
     ]]></description><category></category></item></channel></rss>