chore: Pinning submodules to commit SHA #1006

Job	Run time
check-skip	3s
Build Apache Cloudberry	19m 0s
prepare-test-matrix	1s
RPM Install Test Apache Cloudberry	42s
ic-cbdb-parallel	42m 25s
Generate Apache Cloudberry Build Report	1s
	1h 2m 12s

Provide feedback