Cherry-pick commits from GPDB

gfphoenix78 commented 3 weeks ago

cherry-pick commits:

d201e905f8 Add tests for GUC of PGC_STRING type value rollback
65e84f86da Replace usages of InterruptPending to the flag of query cancellation (#13148)
88a30c6dc2 Add check for appendonly materialized view to pg_upgrade (#11820)
ca336ea6e7 Wiped out fake "Failed to kill processes for segment" message on gpstop command (#13231)
aaa3dbf805 gpstate -e : Display ongoing recovery progress
ff2a09da83 Fix flaky unit test in buildMirrorSegments
c26c1963a9 Including PGOPTIONS="-c gp_role=utility" to use utility mode when inv… (#13066)
43849c5d64 Prevent gp_tablespace_segment_location() from executing on entrydb QE (#13075)
edd24181c0 Direct looking for AppendRelInfos by relid in the append_rel_array (#13197)
18071c5b64 Fix spelling errors in binaries
5b4a7b0161 run ALTER TABLE EXPAND PARTITION PREPARE in separate transactions (#13152)
0a05017c02 Fix typos in temp regression test
9bde369fbb Fix regression about PREPARE TRANSACTION in utility-mode connections
fd87fcc7b5 Fix flaky fts_unblock_primary isolation2 test
df78a777c1 Resolve GPDB_12_MERGE_FIXMEs: TOAST for AO_ROW Table
4237f656ec Resolve a MERGE 12 FIXME in nodeModifyTable.c.
1d3061c64e Remove obsolete header file 'optimizer/var.h'. (#13187)
68804d9298 Introduce PG_TEST_TIMEOUT_DEFAULT for TAP suite non-elapsing timeouts.
41b3b7b2ad PR pipeline: Use dedicated worker (icw-centos7).
e603bdaf71 Run rhel8 ICW jobs in specific workers
e09dc9a999 gpmovemirrors: close connection for tablespace information
575fa04d4b recoverseg/addmirrors/movemirrors: Add behave and unit tests
87ab5c062c recoverseg/addmirrors/movemirrors: Revert catalog update for failures
f3ab1b9092 recoverseg/addmirrors/movemirrors: Improve error reporting
16e54a7724 recoverseg/addmirrors/movemirrors: Update catalog before recovery
454b6460e1 recoverseg/addmirrors/movemirrors: Don't stop unreachable failed mirrors
1d82f3a05f recoverseg/addmirrors/movemirrors: Start each mirror independently
2cfdc99055 Fix bug in gpconfigurenewsegment
456e378e92 make clean ${CMOCKERY_DIR} and ${MOCK_DIR} (#13181)
345b39865c make ALTER TABLE EXPAND PARTITION PREPARE reentrant (#13115)
81afd238a8 Enable faultinject point 'fault_in_background_writer_main' in builds without assertion. (#13175)
1ba31ce7d2 Refactor code around encoding clauses and resolve related FIXMEs
ea0ac4590a Fix gpfdist loads partial records if the data file is gz compressed (#13161)
cb2a5bc399 add testcase for master_shared_snapshot_collision_fix
466bbd49d7 Fix flaky brin testcase (#13138)
91136c6b19 Enhance GPDEMO output to indicate MIRRORED configuration status.
fba0b9be7e Behave: Pass WITH_MIRRORS env variable from CI task.
a7483ac47b Pass WITH_MIRRORS env variable from CI task to create-demo-cluster.
a52804c64e Remove most msys special processing in TAP tests
5cb8ddd77f Add isolation test for pg_basebackup. Test pg_basebackup with database oid larger than int32 for https://github.com/postgres/postgres/commit/259bbe177808986e5d226ea7ce5a1ebb74657791.

Contributor's Checklist

Here are some reminders and checklists before/when submitting your pull request, please check them:

[ ] Make sure your Pull Request has a clear title and commit message. You can take git-commit template as a reference.
[ ] Sign the Contributor License Agreement as prompted for your first-time contribution(One-time setup).
[ ] Learn the coding contribution guide, including our code conventions, workflow and more.
[ ] List your communication in the GitHub Issues or Discussions (if has or needed).
[ ] Document changes.
[ ] Add tests for the change
[ ] Pass make installcheck
[ ] Pass make -C src/test installcheck-cbdb-parallel
[ ] Feel free to request cloudberrydb/dev team for review and approval when your PR is ready🥳

CLAassistant commented 3 weeks ago

Thank you for your submission! We really appreciate it. Like many open source projects, we ask that you all sign our Contributor License Agreement before we can accept your contribution.
1 out of 17 committers have signed the CLA.

:white_check_mark: gfphoenix78
:x: adunstan
:x: dgkimura
:x: kaknikhil
:x: SmartKeyerror
:x: divyeshddv
:x: kainwen
:x: nmisch
:x: BaiShaoqi
:x: jmcatamney
:x: huansong
:x: pobbatihari
:x: fairyfar
:x: yaowangm
:x: Annu149
:x: haolinw
:x: seryozhasmirnov
_{You have signed the CLA already but the status is still pending? Let us recheck it.}

gfphoenix78 commented 3 weeks ago

only TRANACTION -> TRANSACTION? LGTM

Has merged all changes about TRANACTION -> TRANSACTION in one commit.

apache / cloudberry

Cherry-pick commits from GPDB #687

Contributor's Checklist