Digoal.zhou

免费云起实验室地址: - https://developer.aliyun.com/adc/scenario/exp/f55dbfac77c0467a9d3cd95ff6697a31 内置PolarDB-X, PolarDB-PG, PostgreSQL容器镜像: ``` [root@iZuf6g6afqwaglx4kxuskxZ ~]# docker images REPOSITORY TAG IMAGE ID CREATED SIZE registry.cn-hangzhou.aliyuncs.com/digoal/opensource_database pg14_with_exts 1b9d30ed2910 5 days ago 5.25GB polardbx/polardb-x latest f4da3f72d974 3 months ago...

武汉大学数据库课程实验仓库: https://gitee.com/polardb/whudb-course

``` In file included from imgsmlr_idx.c:18: imgsmlr_idx.c: In function ‘signature_compress’: imgsmlr_idx.c:67:23: error: ‘FALSE’ undeclared (first use in this function) 67 | entry->offset, FALSE); | ^~~~~ /usr/include/postgresql/15/server/access/gist.h:246:37: note: in definition of...

``` postgres=# SELECT duckdb_execute('duckdb_server', 'install parquet'); DEBUG: 00000: PX Failed: param polar_enable_px is off LOCATION: should_px_planner, planner.c:7859 DEBUG: 00000: duckdb_fdw : duckdb_execute install parquet LOCATION: duckdb_execute, duckdb_fdw.c:5511 DEBUG: 00000: starting...

``` [root@iZbp135pwcjjoxqgfpw9k1Z ~]# pstack 41065 #0 0x00007f5441b9ae43 in __epoll_wait_nocancel () from /lib64/libc.so.6 #1 0x000000000075888e in WaitEventSetWait () #2 0x0000000000758ce9 in WaitLatchOrSocket () #3 0x00000000007701df in ProcSleep () #4 0x0000000000764cef in...

thank you, this commit i used: https://github.com/greenplum-db/postgres/commit/7b24beac75de36c0968459764fc0558e60304811 environment is aliyun's ECS CentOS 7.7 x64

docs: https://github.com/polardb/polardbx-sql/tree/main/docs https://github.com/ApsaraDB/PolarDB-for-PostgreSQL/tree/POLARDB_11_STABLE/docs Effect Area: https://github.com/polardb/polardbx-sql https://github.com/ApsaraDB/PolarDB-for-PostgreSQL Repost URL:  

> @digoal Please shorten the description a bit and mention it's in chinese language. Ty Fixed, thank you.

可能9.4版本就已经存在这个问题, 只不过是在升级后触发了. 可能是比较难触发的bug, 我在8.4的版本也遇到过. 不太好排查, 你担心的话可以使用SQL, 关闭索引扫描, 看一看count distinct PK有没有异常记录, 先人为处理一下数据, 重建唯一索引