A fully green run! Total duration: 49m 46s

https://github.com/edespino/cloudberry/actions/runs/11948311269

Thank you 杨江华!

-=e

On Wed, Nov 20, 2024 at 11:27 PM 杨江华 <yjhj...@gmail.com> wrote:

> Hi , Ed
> This setting just make explain test happy.
> You can try it.
>
>
> Ed Espino <esp...@apache.org> 于2024年11月21日周四 15:22写道:
>
> > Thank you for sharing this. I am familiar with the previous Cloudberry
> > workflow file and the use of it for "icw-orca-test".
> >
> > Again, I thought the default optimizer setting is "on". In this case, is
> > there a need to even set it?
> >
> > Notice after creating the demo cluster, the optimizer is set to "on".
> >
> >
> https://github.com/edespino/cloudberry/actions/runs/11944371481/job/33295504090#step:14:247
> >
> > -=e
> >
> > On Wed, Nov 20, 2024 at 11:15 PM 杨江华 <yjhj...@gmail.com> wrote:
> >
> > > Hi, Ed
> > > refer to cloudberry :
> > >
> >
> https://github.com/apache/cloudberry/blob/1.5.4/.github/workflows/build.yml
> > > ```c++
> > > icw-orca-test:
> > >     needs: build
> > >     runs-on: [self-hosted, example]
> > >     env:
> > >       MAKE_TEST_COMMAND: "-k PGOPTIONS='-c optimizer=on'
> > > installcheck-world"
> > >       TEST_OS: "centos"
> > >       DUMP_DB: "true"
> > > ```
> > > Here explicitly set PGOPTIONS='-c optimizer=on'.
> > >
> > >
> > > Ed Espino <eesp...@gmail.com> 于2024年11月21日周四 15:00写道:
> > >
> > > > Please: you can call me Ed (艾德)
> > > >
> > > > I thought Orca (optimizer) was enabled by default. Is that not the
> case
> > > > with Cloudberry?
> > > >
> > > > -=e
> > > >
> > > >
> > > >
> > > > On Wed, Nov 20, 2024 at 10:51 PM 杨江华 <yjhj...@gmail.com> wrote:
> > > >
> > > > > Dear Espino,
> > > > >
> > > > > I found that ic-good-opt-on pipeline failed to explain. You can set
> > > > > PGOPTIONS='-c
> > > > > optimizer=on' explicitly. Hope to solve this.
> > > > >
> > > > > Thank you for your time and support.
> > > > >
> > > > >
> > > > > Ed Espino <esp...@apache.org> 于2024年11月21日周四 12:40写道:
> > > > >
> > > > > > I've identified a solution for running our previously disabled
> test
> > > > > suites
> > > > > > (
> > > > > > cbdb_parallel and instr_in_shmem_verify) in the GitHub Actions CI
> > > > > > environment. By increasing the container shared memory using the
> > > > > > --shm-size=2gb parameter, these test suites are now passing
> > > > consistently.
> > > > > >
> > > > > > I'm currently conducting additional testing to verify the
> stability
> > > of
> > > > > this
> > > > > > solution. You can review the test results here:
> > > > > >
> > > > > >    -
> > https://github.com/edespino/cloudberry/actions/runs/11944371481
> > > > > >    -
> > https://github.com/edespino/cloudberry/actions/runs/11943779438
> > > > > >    -
> > https://github.com/edespino/cloudberry/actions/runs/11943000112
> > > > > >
> > > > > > However, I've noticed some inconsistencies in other test suites
> > > during
> > > > > this
> > > > > > investigation. I would appreciate if you all could review these
> > > results
> > > > > and
> > > > > > provide feedback on the increased shared memory solution and any
> > > > insights
> > > > > > into the inconsistent test results observed in other suites.
> > > > > > Thank you,
> > > > > > -=e
> > > > > > --
> > > > > > Ed Espino
> > > > > > Apache Cloudberry (incubating) & MADlib
> > > > > >
> > > > >
> > > >
> > > >
> > > > --
> > > > Ed Espino
> > > >
> > >
> >
> >
> > --
> > Ed Espino
> > Apache Cloudberry (incubating) & MADlib
> >
>


-- 
Ed Espino
Apache Cloudberry (incubating) & MADlib

Reply via email to