叶落-秋风凉-CSDN博客

原创 Go常见问题： command-line-arguments [no test files]

执行 go test -v assettest.go报错command-line-arguments [no test files]go测试文件命名改为 asset_test.go执行 go test -v asset_test.go 即可

2022-04-27 15:05:39 1675

原创 dgraph 中文名字查询不准确或查不到数据问题

dgraph 中文名字查询不准确或查不到数据问题使用eq查询，中文查询，无返回值{ q(func: eq(td.attribute.type, "person"))@filter(eq(td.attribute.name@zh,"可乐")){ uid expand(_all_) }}英文查询有返回值{ q(func: eq(td.attribute.type, "person"))@f...

2021-03-16 11:38:45 193

原创 postgres11.2非常好用的ip范围查询函数

创建函数create or replace function inet_aton(ip text) returns int8 as $$declarev int;res int8 := 0;i int := 3;beginforeach v in array string_to_array(ip, ‘.’) loopres := res+v*(256^i);i := i-1;e...

2020-04-24 10:54:23 837

原创 sys_ctl start启动报错

sys_ctl start启动报错2018-04-08 16:39:23 CST FATAL: data directory "/opt/Kingbase/ES/V8/data" has group or world access2018-04-08 16:39:23 CST DETAIL: Permissions should be u=rwx (0700).由于/opt/Kingba...

2020-04-23 16:42:32 1505

原创 libkci.so.5: cannot open shared object file: No such file or directory

人大金仓数据库执行./sys_ctl命令报错error while loading shared libraries: libkci.so.5: cannot open shared object file: No such file or directory由于libkci.so.5库未加载修改/etc/ld.so.conf 配置文件增加/opt/Kingbase/ES/V8/Server/li...

2018-03-09 14:54:51 2399

原创 no sys_hba.conf entry for host "192.168.16.28"

人大金仓数据库连接问题FATAL: no sys_hba.conf entry for host "192.168.16.28"修改 /opt/Kingbase/ES/V8/data/sys_hba.conf增加 host all all 192.168.16.28/24 trust执行 ./sys_ctl reload -D /opt/Kingbase/ES/V8/data/sys_...

2018-03-08 17:54:44 1437

原创 SQL 错误 [XX000]: ERROR: unrecognized object type: 29

人大金仓数据库创建存储过程时先执行删除再创建，执行删除时DROP procedure IF EXISTS PROCEDURE UPDATE_USER_DEPID;报以下错误：SQL 错误 [XX000]: ERROR: unrecognized object type: 29 com.kingbase8.util.KSQLException: ERROR: unrecognized objec...

2018-03-08 17:27:08 7344