Re: Build failed in Jenkins: Calcite » Calcite-snapshots #13

2021-12-18 Thread Vladimir Sitnikov 
There are issues, and it does fail quite often. It is really frustrating.

I can disable the test if you think it would be better.

Based on past experience, we almost never revisit disabled tests, and it
would look as if "server" passes tests, however, it corrupts data.

Vladimir

Re: Build failed in Jenkins: Calcite » Calcite-snapshots #13

2021-12-18 Thread Stamatis Zampetakis 
Thanks for looking into this Vladimir.

One bug does not justify dropping one module completely.

Moreover, end-users rarely follow the dev list so asking if somebody is
using may not be representative.

Personally, I find it useful and I think it is helping people build and
test DDL/DML parsers.

Best,
Stamatis

On Wed, Dec 15, 2021 at 12:13 PM Vladimir Sitnikov <
sitnikov.vladi...@gmail.com> wrote:

> The failure is known as https://issues.apache.org/jira/browse/CALCITE-4824
>
> Does anybody use calcite-server?
> Does anybody have cycles to maintain/fix calcite-server?
> Can we just remove it?
>
> Vladimir
>

Re: Build failed in Jenkins: Calcite » Calcite-snapshots #13

2021-12-15 Thread Vladimir Sitnikov 
The failure is known as https://issues.apache.org/jira/browse/CALCITE-4824

Does anybody use calcite-server?
Does anybody have cycles to maintain/fix calcite-server?
Can we just remove it?

Vladimir

Re: Build failed in Jenkins: Calcite » Calcite-snapshots #13

2021-12-14 Thread Vladimir Sitnikov 
Julian>We don’t need any more noise on the dev list.

Julian at all, please consider ASF Jenkins failures as true failures rather
than "infrastructure noise".
The messages could probably be improved, however, I have not explored them.

Jenkins won't send mails in case everything is ok.

Jacques>if these are real failures or infra problems

I did very that Calcite-snapshots job can pass.
I did configure the job to remove ALL non-git files before each build,
I configured the job to run with --no-build-cache.

Technically speaking, the "workspace cleanup and --no-build-cache" are not
needed, however,
they imply that failures are likely caused by the bug in Calcite code
rather than "infrastructure".

-

In this case, :server:test failed, see "tests tab":
https://ci-builds.apache.org/blue/organizations/jenkins/Calcite%2FCalcite-snapshots/detail/Calcite-snapshots/13/tests?start=0

It looks like there's a concurrency issue in "server" (Calcite or Avatica)

> Caused by: org.apache.calcite.sql.validate.SqlValidatorException:
Number of INSERT target columns (3) does not equal number of source items
(2)
> at sun.reflect.GeneratedConstructorAccessor19.newInstance(Unknown
Source)
> at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
> at
org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:505)
> at org.apache.calcite.runtime.Resources$ExInst.ex(Resources.java:599)
> ... 66 more
44,49c191,195
< +---+---+
< | I | J |
< +---+---+
< | 1 | 2 |
< +---+---+
< (1 row)
---
> +---+---+---+
> | I | J | K |
> +---+---+---+
> +---+---+---+

Vladimir

Re: Build failed in Jenkins: Calcite » Calcite-snapshots #13

2021-12-14 Thread Jacques Nadeau 
FYI, This appears to be the job that Vladimir implemented on Jenkins, not
the pr I implemented on Github actions.

I haven't looked how this is configured and what will trigger emails. I'm
also curious if these are real failures or infra problems. I would be
pretty surprised if we broke master twice in the last few days (I think
I've seen at least two of these messages).

On Tue, Dec 14, 2021, 3:46 PM Julian Hyde  wrote:

> I hope this isn’t going to be typical now we’ve enabled snapshots. We
> don’t need any more noise on the dev list.
>
> > On Dec 14, 2021, at 2:25 PM, Apache Jenkins Server <
> jenk...@builds.apache.org> wrote:
> >
> > See <
> https://ci-builds.apache.org/job/Calcite/job/Calcite-snapshots/13/display/redirect?page=changes
> >
> >
> > Changes:
> >
> > [nobigogle] [CALCITE-4906] Wrong result for scalar subquery from empty
> input
> >
> >
> > --
> > [...truncated 345.78 KB...]
> >docker[redis:2.8.19] 2021-12-14 22:23:49,508
> [docker-java-stream-796534722] INFO  - Pulling image layers:  0 pending,  9
> downloaded,  9 extracted, (46 MB/46 MB)
> >docker[redis:2.8.19] 2021-12-14 22:23:50,861
> [docker-java-stream-796534722] INFO  - Pull complete. 9 layers, pulled in
> 22s (downloaded 46 MB at 2 MB/s)
> >docker[redis:2.8.19] 2021-12-14 22:23:50,904
> [ForkJoinPool-1-worker-25] INFO  - Creating container for image:
> redis:2.8.19
> >docker[redis:2.8.19] 2021-12-14 22:23:53,555
> [ForkJoinPool-1-worker-25] INFO  - Starting container with ID:
> 03de1b4b0a3effe35a45bb86dc8e6707fa99e6d3623bd36dbe4f3ba3eb3dca46
> >docker[redis:2.8.19] 2021-12-14 22:23:54,965
> [ForkJoinPool-1-worker-25] INFO  - Container redis:2.8.19 is starting:
> 03de1b4b0a3effe35a45bb86dc8e6707fa99e6d3623bd36dbe4f3ba3eb3dca46
> >docker[redis:2.8.19] 2021-12-14 22:23:55,168
> [ForkJoinPool-1-worker-25] INFO  - Container redis:2.8.19 started in
> PT28.124S
> > [0;1m  3.2sec [0m, org.apache.calcite.adapter.redis.
> [0;1mRedisAdapterCaseBase [0m >  [0;1mtestSqlWithJoin() [0m
> > 55.2sec,2 completed,   0 failed,   0 skipped,
> org.apache.calcite.adapter.redis.RedisAdapterCaseBase
> >  [0;34;1mWARNING [0m  58.7sec,3 completed,   0 failed,  [0;34;1m  1
> [0m skipped,  [0;34;1mGradle Test Run :redis:test [0m
> >
> >> Task :plus:test
> > [0;1m 39.3sec [0m, org.apache.calcite.adapter.tpch.
> [0;1mTpchTest [0m >  [0;1mtestQuery02() [0m
> > [0;1m 14.2sec [0m, org.apache.calcite.adapter.tpch.
> [0;1mTpchTest [0m >  [0;1mtestQuery22() [0m
> > [0;1m 40.2sec [0m, org.apache.calcite.adapter.tpch.
> [0;1mTpchTest [0m >  [0;1mtestQuery06() [0m
> > [0;1m 23.8sec [0m, org.apache.calcite.adapter.tpch.
> [0;1mTpchTest [0m >  [0;1mtestQuery14() [0m
> > [0;1m 20.9sec [0m, org.apache.calcite.adapter.tpch.
> [0;1mTpchTest [0m >  [0;1mtestQuery20() [0m
> > [0;1m 24.5sec [0m, org.apache.calcite.adapter.tpch.
> [0;1mTpchTest [0m >  [0;1mtestQuery10() [0m
> > [0;1m 40.4sec [0m, org.apache.calcite.adapter.tpch.
> [0;1mTpchTest [0m >  [0;1mtestQuery01() [0m
> > [0;1m 24.2sec [0m, org.apache.calcite.adapter.tpch.
> [0;1mTpchTest [0m >  [0;1mtestQuery13() [0m
> > [0;1m 24.4sec [0m, org.apache.calcite.adapter.tpch.
> [0;1mTpchTest [0m >  [0;1mtestQuery12() [0m
> > [0;1m 40.5sec [0m, org.apache.calcite.adapter.tpch.
> [0;1mTpchTest [0m >  [0;1mtestQuery03() [0m
> > [0;1m 23.9sec [0m, org.apache.calcite.adapter.tpch.
> [0;1mTpchTest [0m >  [0;1mtestQuery15() [0m
> > [0;1m 40.9sec [0m, org.apache.calcite.adapter.tpch.
> [0;1mTpchTest [0m >  [0;1mtestQuery04() [0m
> > [0;1m 25.9sec [0m, org.apache.calcite.adapter.tpch.
> [0;1mTpchTest [0m >  [0;1mtestQuery08() [0m
> > [0;1m 23.4sec [0m, org.apache.calcite.adapter.tpch.
> [0;1mTpchTest [0m >  [0;1mtestQuery17() [0m
> > [0;1m 25.5sec [0m, org.apache.calcite.adapter.tpch.
> [0;1mTpchTest [0m >  [0;1mtestQuery09() [0m
> > [0;1m 22.6sec [0m, org.apache.calcite.adapter.tpch.
> [0;1mTpchTest [0m >  [0;1mtestQuery18() [0m
> > [0;1m 22.6sec [0m, org.apache.calcite.adapter.tpch.
> [0;1mTpchTest [0m >  [0;1mtestQuery21() [0m
> > [0;1m 45.3sec [0m, org.apache.calcite.adapter.tpch.
> [0;1mTpchTest [0m >  [0;1mtestQuery05() [0m
> >
> >> Task :elasticsearch:test
> > [0;1m  3.2sec [0m, org.apache.calcite.adapter.elasticsearch.
> [0;1mAggregationTest [0m >  [0;1mcat1Cat3() [0m
> > [0;1m  3.2sec [0m, org.apache.calcite.adapter.elasticsearch.
> [0;1mAggregationTest [0m >  [0;1mintegerCat() [0m
> > [0;1m  3.2sec [0m, org.apache.calcite.adapter.elasticsearch.
> [0;1mAggregationTest [0m >  [0;1mdateCat() [0m
> > [0;1m  3.2sec [0m, org.apache.calcite.adapter.elasticsearch.
> [0;1mAggregationTest [0m >  [0;1mcat1Cat2Cat3() [0m
> > [0;1m  3.3sec [0m, org.apache.calcite.adapter.elasticsearch.
> [0;1mAggregationTest [0m >  [0;1maggregationWithCast() [0m
> > [0;1m  3.4sec

Re: Build failed in Jenkins: Calcite » Calcite-snapshots #13

2021-12-14 Thread Julian Hyde 
I hope this isn’t going to be typical now we’ve enabled snapshots. We don’t 
need any more noise on the dev list.

> On Dec 14, 2021, at 2:25 PM, Apache Jenkins Server 
>  wrote:
> 
> See 
> 
> 
> Changes:
> 
> [nobigogle] [CALCITE-4906] Wrong result for scalar subquery from empty input
> 
> 
> --
> [...truncated 345.78 KB...]
>docker[redis:2.8.19] 2021-12-14 22:23:49,508 
> [docker-java-stream-796534722] INFO  - Pulling image layers:  0 pending,  9 
> downloaded,  9 extracted, (46 MB/46 MB)
>docker[redis:2.8.19] 2021-12-14 22:23:50,861 
> [docker-java-stream-796534722] INFO  - Pull complete. 9 layers, pulled in 22s 
> (downloaded 46 MB at 2 MB/s)
>docker[redis:2.8.19] 2021-12-14 22:23:50,904 [ForkJoinPool-1-worker-25] 
> INFO  - Creating container for image: redis:2.8.19
>docker[redis:2.8.19] 2021-12-14 22:23:53,555 [ForkJoinPool-1-worker-25] 
> INFO  - Starting container with ID: 
> 03de1b4b0a3effe35a45bb86dc8e6707fa99e6d3623bd36dbe4f3ba3eb3dca46
>docker[redis:2.8.19] 2021-12-14 22:23:54,965 [ForkJoinPool-1-worker-25] 
> INFO  - Container redis:2.8.19 is starting: 
> 03de1b4b0a3effe35a45bb86dc8e6707fa99e6d3623bd36dbe4f3ba3eb3dca46
>docker[redis:2.8.19] 2021-12-14 22:23:55,168 [ForkJoinPool-1-worker-25] 
> INFO  - Container redis:2.8.19 started in PT28.124S
>  3.2sec, 
> org.apache.calcite.adapter.redis.RedisAdapterCaseBase > 
> testSqlWithJoin()
> 55.2sec,2 completed,   0 failed,   0 skipped, 
> org.apache.calcite.adapter.redis.RedisAdapterCaseBase
> WARNING  58.7sec,3 completed,   0 failed,   1 
> skipped, Gradle Test Run :redis:test
> 
>> Task :plus:test
> 39.3sec, org.apache.calcite.adapter.tpch.TpchTest 
> > testQuery02()
> 14.2sec, org.apache.calcite.adapter.tpch.TpchTest 
> > testQuery22()
> 40.2sec, org.apache.calcite.adapter.tpch.TpchTest 
> > testQuery06()
> 23.8sec, org.apache.calcite.adapter.tpch.TpchTest 
> > testQuery14()
> 20.9sec, org.apache.calcite.adapter.tpch.TpchTest 
> > testQuery20()
> 24.5sec, org.apache.calcite.adapter.tpch.TpchTest 
> > testQuery10()
> 40.4sec, org.apache.calcite.adapter.tpch.TpchTest 
> > testQuery01()
> 24.2sec, org.apache.calcite.adapter.tpch.TpchTest 
> > testQuery13()
> 24.4sec, org.apache.calcite.adapter.tpch.TpchTest 
> > testQuery12()
> 40.5sec, org.apache.calcite.adapter.tpch.TpchTest 
> > testQuery03()
> 23.9sec, org.apache.calcite.adapter.tpch.TpchTest 
> > testQuery15()
> 40.9sec, org.apache.calcite.adapter.tpch.TpchTest 
> > testQuery04()
> 25.9sec, org.apache.calcite.adapter.tpch.TpchTest 
> > testQuery08()
> 23.4sec, org.apache.calcite.adapter.tpch.TpchTest 
> > testQuery17()
> 25.5sec, org.apache.calcite.adapter.tpch.TpchTest 
> > testQuery09()
> 22.6sec, org.apache.calcite.adapter.tpch.TpchTest 
> > testQuery18()
> 22.6sec, org.apache.calcite.adapter.tpch.TpchTest 
> > testQuery21()
> 45.3sec, org.apache.calcite.adapter.tpch.TpchTest 
> > testQuery05()
> 
>> Task :elasticsearch:test
>  3.2sec, 
> org.apache.calcite.adapter.elasticsearch.AggregationTest > 
> cat1Cat3()
>  3.2sec, 
> org.apache.calcite.adapter.elasticsearch.AggregationTest > 
> integerCat()
>  3.2sec, 
> org.apache.calcite.adapter.elasticsearch.AggregationTest > 
> dateCat()
>  3.2sec, 
> org.apache.calcite.adapter.elasticsearch.AggregationTest > 
> cat1Cat2Cat3()
>  3.3sec, 
> org.apache.calcite.adapter.elasticsearch.AggregationTest > 
> aggregationWithCast()
>  3.4sec, 
> org.apache.calcite.adapter.elasticsearch.AggregationTest > 
> cat1Cat2()
>  3.5sec, 
> org.apache.calcite.adapter.elasticsearch.AggregationTest > 
> anyValue()
>  3.5sec, 
> org.apache.calcite.adapter.elasticsearch.AggregationTest > 
> cat2()
>  3.5sec, 
> org.apache.calcite.adapter.elasticsearch.AggregationTest > 
> anyValueWithOtherAgg()
>

Build failed in Jenkins: Calcite » Calcite-snapshots #13

2021-12-14 Thread Apache Jenkins Server 
See 


Changes:

[nobigogle] [CALCITE-4906] Wrong result for scalar subquery from empty input


--
[...truncated 345.78 KB...]
docker[redis:2.8.19] 2021-12-14 22:23:49,508 [docker-java-stream-796534722] 
INFO  - Pulling image layers:  0 pending,  9 downloaded,  9 extracted, (46 
MB/46 MB)
docker[redis:2.8.19] 2021-12-14 22:23:50,861 [docker-java-stream-796534722] 
INFO  - Pull complete. 9 layers, pulled in 22s (downloaded 46 MB at 2 MB/s)
docker[redis:2.8.19] 2021-12-14 22:23:50,904 [ForkJoinPool-1-worker-25] 
INFO  - Creating container for image: redis:2.8.19
docker[redis:2.8.19] 2021-12-14 22:23:53,555 [ForkJoinPool-1-worker-25] 
INFO  - Starting container with ID: 
03de1b4b0a3effe35a45bb86dc8e6707fa99e6d3623bd36dbe4f3ba3eb3dca46
docker[redis:2.8.19] 2021-12-14 22:23:54,965 [ForkJoinPool-1-worker-25] 
INFO  - Container redis:2.8.19 is starting: 
03de1b4b0a3effe35a45bb86dc8e6707fa99e6d3623bd36dbe4f3ba3eb3dca46
docker[redis:2.8.19] 2021-12-14 22:23:55,168 [ForkJoinPool-1-worker-25] 
INFO  - Container redis:2.8.19 started in PT28.124S
  3.2sec, 
org.apache.calcite.adapter.redis.RedisAdapterCaseBase > 
testSqlWithJoin()
 55.2sec,2 completed,   0 failed,   0 skipped, 
org.apache.calcite.adapter.redis.RedisAdapterCaseBase
WARNING  58.7sec,3 completed,   0 failed,   1 
skipped, Gradle Test Run :redis:test

> Task :plus:test
 39.3sec, org.apache.calcite.adapter.tpch.TpchTest 
> testQuery02()
 14.2sec, org.apache.calcite.adapter.tpch.TpchTest 
> testQuery22()
 40.2sec, org.apache.calcite.adapter.tpch.TpchTest 
> testQuery06()
 23.8sec, org.apache.calcite.adapter.tpch.TpchTest 
> testQuery14()
 20.9sec, org.apache.calcite.adapter.tpch.TpchTest 
> testQuery20()
 24.5sec, org.apache.calcite.adapter.tpch.TpchTest 
> testQuery10()
 40.4sec, org.apache.calcite.adapter.tpch.TpchTest 
> testQuery01()
 24.2sec, org.apache.calcite.adapter.tpch.TpchTest 
> testQuery13()
 24.4sec, org.apache.calcite.adapter.tpch.TpchTest 
> testQuery12()
 40.5sec, org.apache.calcite.adapter.tpch.TpchTest 
> testQuery03()
 23.9sec, org.apache.calcite.adapter.tpch.TpchTest 
> testQuery15()
 40.9sec, org.apache.calcite.adapter.tpch.TpchTest 
> testQuery04()
 25.9sec, org.apache.calcite.adapter.tpch.TpchTest 
> testQuery08()
 23.4sec, org.apache.calcite.adapter.tpch.TpchTest 
> testQuery17()
 25.5sec, org.apache.calcite.adapter.tpch.TpchTest 
> testQuery09()
 22.6sec, org.apache.calcite.adapter.tpch.TpchTest 
> testQuery18()
 22.6sec, org.apache.calcite.adapter.tpch.TpchTest 
> testQuery21()
 45.3sec, org.apache.calcite.adapter.tpch.TpchTest 
> testQuery05()

> Task :elasticsearch:test
  3.2sec, 
org.apache.calcite.adapter.elasticsearch.AggregationTest > 
cat1Cat3()
  3.2sec, 
org.apache.calcite.adapter.elasticsearch.AggregationTest > 
integerCat()
  3.2sec, 
org.apache.calcite.adapter.elasticsearch.AggregationTest > 
dateCat()
  3.2sec, 
org.apache.calcite.adapter.elasticsearch.AggregationTest > 
cat1Cat2Cat3()
  3.3sec, 
org.apache.calcite.adapter.elasticsearch.AggregationTest > 
aggregationWithCast()
  3.4sec, 
org.apache.calcite.adapter.elasticsearch.AggregationTest > 
cat1Cat2()
  3.5sec, 
org.apache.calcite.adapter.elasticsearch.AggregationTest > 
anyValue()
  3.5sec, 
org.apache.calcite.adapter.elasticsearch.AggregationTest > 
cat2()
  3.5sec, 
org.apache.calcite.adapter.elasticsearch.AggregationTest > 
anyValueWithOtherAgg()
  3.5sec, 
org.apache.calcite.adapter.elasticsearch.AggregationTest > 
cat1()
  3.6sec, 
org.apache.calcite.adapter.elasticsearch.AggregationTest > 
all()
  3.7sec, 
org.apache.calcite.adapter.elasticsearch.AggregationTest >