[Bug] 10 of 305 tests failed -- make installcheck-world

[wtx20074587]

Apache Cloudberry version

current latest, commit id is: 853596b8b1

What happened

Some test cases were failed.

What you think should happen instead

All test cases should pass.

How to reproduce

1. clone the project: git clone [email protected]:apache/cloudberry.git git submodule update --init --recursive
2. build the project: ./configure --with-perl --with-python --with-libxml --with-gssapi --prefix=/usr/local/cloudberry make -j8 make -j8 install
3. run cbdb tests: make installcheck-world

Operating System

Ubuntu 22.04.5

Anything else

Every Time.

Are you willing to submit PR?

• [x] Yes, I am willing to submit a PR!

Code of Conduct

• [x] I agree to follow this project's Code of Conduct.

[github-actions[bot]]

Hi, @wtx20074587 welcome!🎊 Thanks for taking the time to point this out.🙌

[tuhaihe]

Hi @wtx20074587 could you help list the details in the file src/test/regress/regression.diffs?

For the Cluster validation failed, I guess you did not create the gpdemo successfully.

You also built Cloudberry without --with-pythonsrc-ext option, so please install the related Python modules first:

python3 -m pip install  psutil==5.7.0 
python3 -m pip install pygresql==5.2 
python3 -m pip install  pyyaml==5.3.1

Then, you can try the following command to create the gpdemo cluster:

source /usr/local/cloudberry/greenplum_path.sh
make create-demo-cluster -C ~/cloudberry
source ~/cloudberry/gpAux/gpdemo/gpdemo-env.sh
gpstate # to see if any output, if any, is successful

Lastly, you can run Cloudberry tests again.

[tuhaihe]

We will update the related build docs on Ubuntu later.

[wtx20074587]

1. regression.diffs:

It looks like that the latest version of cbdb changed the hint msg when dropping column.

2. I do built Cloudberry without --with-pythonsrc-ext option, I'll try it later.Thanks.

[wtx20074587]

@tuhaihe # Hi, I redo the those steps :

1. build cloudberry: ./configure --with-perl --with-python --with-libxml --with-gssapi --with-pythonsrc-ext --prefix=/usr/local/cloudberry make -j8 make -j8 install
2. create demo culster: (1)copy files: cp -arf ./cloudberry /home/gpadmin/ chown gpadmin:gpadmin -R /home/gpadmin/ su - gpadmin cd cloudberry/ (2)create demo cluster: make create-demo-cluster (3)cluster info: postgres=# select version(); version

---

PostgreSQL 14.4 (Apache Cloudberry 1.0.0+ build dev) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 10.5.0-1ubuntu1~22.04) 10.5.0, 64-bit compiled on May 22 2025 11:48:24 (1 row)

postgres=# select * from gp_segment_configuration; dbid | content | role | preferred_role | mode | status | port | hostname | address | datadir | warehouseid ------+---------+------+----------------+------+--------+------+----------+---------+----------------------------------------------------------------------------+------------- 1 | -1 | p | p | n | u | 7000 | server | server | /home/gpadmin/cloudberry/gpAux/gpdemo/datadirs/qddir/demoDataDir-1 | 0 8 | -1 | m | m | s | u | 7001 | server | server | /home/gpadmin/cloudberry/gpAux/gpdemo/datadirs/standby | 0 3 | 1 | p | p | s | u | 7003 | server | server | /home/gpadmin/cloudberry/gpAux/gpdemo/datadirs/dbfast2/demoDataDir1 | 0 6 | 1 | m | m | s | u | 7006 | server | server | /home/gpadmin/cloudberry/gpAux/gpdemo/datadirs/dbfast_mirror2/demoDataDir1 | 0 4 | 2 | p | p | s | u | 7004 | server | server | /home/gpadmin/cloudberry/gpAux/gpdemo/datadirs/dbfast3/demoDataDir2 | 0 7 | 2 | m | m | s | u | 7007 | server | server | /home/gpadmin/cloudberry/gpAux/gpdemo/datadirs/dbfast_mirror3/demoDataDir2 | 0 2 | 0 | p | p | s | u | 7002 | server | server | /home/gpadmin/cloudberry/gpAux/gpdemo/datadirs/dbfast1/demoDataDir0 | 0 5 | 0 | m | m | s | u | 7005 | server | server | /home/gpadmin/cloudberry/gpAux/gpdemo/datadirs/dbfast_mirror1/demoDataDir0 | 0 (8 rows) 3. start test: (1)configure: ./configure --with-perl --with-python --with-libxml --with-gssapi --with-pythonsrc-ext --prefix=/usr/local/cloudberry (2)make installcheck-world：

4. details： (1)regression.out:

regression.out.txt

(2)regression.diffs:

regression.diffs.txt

[avamingli]

2. (3)cluster info: postgres=# select version(); version

PostgreSQL 14.4 (Apache Cloudberry 1.0.0+ build dev) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 10.5.0-1ubuntu1~22.04) 10.5.0, 64-bit compiled on May 22 2025 11:48:24 (1 row)

Hi, @wtx20074587

At your commit:

current latest, commit id is: 853596b

the version should be Apache Cloudberry 1.6.0+dev.xxx, not Apache Cloudberry 1.0.0+ build dev

I built on latest commit: fb8685159a116939bc43fd3ff9c3cb242b15a80e

postgres=# select version();

           version

-----------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------
-----------------------------
 PostgreSQL 14.4 (Apache Cloudberry 1.6.0+dev.1956.gfb8685159a1 build dev) on x86_64-pc-linux-g
nu, compiled by gcc (Ubuntu 11.3.0-1ubuntu1~22.04.1) 11.3.0, 64-bit compiled on May 26 2025 12:
45:44 (with assert checking)
(1 row)

I guess there may be something like env switch problems on your machine with multi-version CBDB.

[avamingli]

I guess there may be something like env switch problems on your machine with multi-version CBDB.

Hi, @wtx20074587 I got a similar issue, see #1139

Could you try 'cat VERSION" to see the version string under your src dir?