[Bug] 编译distribute的polardb时候，大量变量重复定义的错误

[tigerzhangyz]

centos7.9下面编译 polardb 分布式版本 出错：
环境如下：
[polardb@hn2-test-dmo-1 PolarDB-for-PostgreSQL-distributed]$ uname -a
Linux hn2-test-dmo-1 3.10.0-1160.119.1.el7.x86_64 #1 SMP Tue Jun 4 14:43:51 UTC 2024 x86_64 x86_64 x86_64 GNU/Linux
[polardb@hn2-test-dmo-1 PolarDB-for-PostgreSQL-distributed]$ cat /etc/redhat-release
CentOS Linux release 7.9.2009 (Core)
[polardb@hn2-test-dmo-1 PolarDB-for-PostgreSQL-distributed]$ gcc --version
gcc (GCC) 10.2.0
Copyright (C) 2020 Free Software Foundation, Inc.
This is free software; see the source for copying conditions. There is NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

[polardb@hn2-test-dmo-1 PolarDB-for-PostgreSQL-distributed]$ ld --version
GNU ld version 2.27-44.base.el7_9.1
Copyright (C) 2016 Free Software Foundation, Inc.
This program is free software; you may redistribute it under the terms of
the GNU General Public License version 3 or (at your option) a later version.
This program has absolutely no warranty.
[polardb@hn2-test-dmo-1 PolarDB-for-PostgreSQL-distributed]$ cmake --version
cmake version 3.30.7

CMake suite maintained and supported by Kitware (kitware.com/cmake).
[polardb@hn2-test-dmo-1 PolarDB-for-PostgreSQL-distributed]$

还有 pgxc_ctl 那边也有大量报错， var_hash 重复定义， 到直接导致 pgxc_ctl 失败，不能部署多节点

请问如何解决，是我的环境变量还需要调整吗？

谢谢

executor/recvRemote.o: In function HandleDataRow': /home/polardb/PolarDB-for-PostgreSQL_X/PolarDB-for-PostgreSQL-distributed/contrib/polarx/executor/recvRemote.c:426: multiple definition of sql_prepared_attributes'
./polarx_init.o:/home/polardb/PolarDB-for-PostgreSQL_X/PolarDB-for-PostgreSQL-distributed/contrib/polarx/polarx_init.c:757: first defined here
deparse/deparse_fqs.o:(.bss+0x4): multiple definition of sql_prepared_attributes' ./polarx_init.o:/home/polardb/PolarDB-for-PostgreSQL_X/PolarDB-for-PostgreSQL-distributed/contrib/polarx/polarx_init.c:757: first defined here utils/fdwplanner_utils.o:(.bss+0x0): multiple definition of PolarxNodeTagNames'
./polarx_init.o:/home/polardb/PolarDB-for-PostgreSQL_X/PolarDB-for-PostgreSQL-distributed/contrib/polarx/polarx_init.c:757: first defined here
utils/fdwplanner_utils.o: In function ExtractRelationRangeTableList': /home/polardb/PolarDB-for-PostgreSQL_X/PolarDB-for-PostgreSQL-distributed/contrib/polarx/utils/fdwplanner_utils.c:249: multiple definition of sql_prepared_attributes'
./polarx_init.o:/home/polardb/PolarDB-for-PostgreSQL_X/PolarDB-for-PostgreSQL-distributed/contrib/polarx/polarx_init.c:757: first defined here
nodes/polarx_copyfuncs.o:(.bss+0x0): multiple definition of sql_prepared_attributes' ./polarx_init.o:/home/polardb/PolarDB-for-PostgreSQL_X/PolarDB-for-PostgreSQL-distributed/contrib/polarx/polarx_init.c:757: first defined here nodes/polarx_copyfuncs.o: In function CopyRemoteQuery':
/home/polardb/PolarDB-for-PostgreSQL_X/PolarDB-for-PostgreSQL-distributed/contrib/polarx/nodes/polarx_copyfuncs.c:102: multiple definition of PolarxNodeTagNames' ./polarx_init.o:/home/polardb/PolarDB-for-PostgreSQL_X/PolarDB-for-PostgreSQL-distributed/contrib/polarx/polarx_init.c:757: first defined here nodes/polarx_nodesdef.o:(.bss+0x8): multiple definition of sql_prepared_attributes'

[polardb-bot]

Hi @tigerzhangyz ~ Thanks for opening this issue! 🎉

Please make sure you have provided enough information for subsequent discussion.

We will get back to you as soon as possible. ❤️

[tigerzhangyz]

上面的问题是我至今 unzip 包的结果。 如果用git下载，就是不同的报错，连pg都编译不过：
-- Up-to-date: /home/polardb/PolarDB-for-PostgreSQL/src/backend/polar_dma/include/easy/easy_atomic.h
optimizer/geqo/geqo_recombination.o: In function init_tour': geqo_recombination.c:(.text+0x58): undefined reference to geqo_randint'
regex/regerror.o: In function pg_regerror': regerror.c:(.text+0xfb): undefined reference to pg_sprintf'
regerror.c:(.text+0x13d): undefined reference to pg_sprintf' regerror.c:(.text+0x15d): undefined reference to pg_sprintf'
collect2: error: ld returned 1 exit status
make[2]: *** [postgres] Error 1
make[1]: *** [all-backend-recurse] Error 2
make: *** [all-src-recurse] Error 2
[polardb@hn2-test-dmo-1 PolarDB-for-PostgreSQL]$ git branch
POLARDB_15_STABLE

• remotes/origin/distributed
  [polardb@hn2-test-dmo-1 PolarDB-for-PostgreSQL]$ ./onekey.sh build

[tigerzhangyz]

还是环境变量的问题： unset LD_LIBRARYPATH 就行了， 确保gcc的版本是 4.8.X, 不要太高的gcc和llvm5.0 即可. centos7.9 默认的都行，但是这个如果跟随着pg升级，就麻烦了