Forward port gh-138491 tests to main and 3.14

[yihong0618]

as discuss in 140103

we can chore the test_exec_set_nomemory_hang to main and branch 3.14
for avoid future regression

Linked PRs

• gh-140193: Forward port test_exec_set_nomemory_hang from 3.13 #140187
• [3.14] gh-140193: Forward port test_exec_set_nomemory_hang from 3.13 (GH-140187) #141420

[gpshead]

thanks for following up on this!