You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@calcite.apache.org by Apache Jenkins Server <je...@builds.apache.org> on 2022/02/01 09:11:53 UTC

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

See <https://ci-builds.apache.org/job/Calcite/job/Calcite-snapshots/60/display/redirect?page=changes>

Changes:

[Julian Hyde] [CALCITE-4994] SQL-to-RelNode conversion is slow if table contains hundreds of fields


------------------------------------------
[...truncated 307.94 KB...]
         10.4sec, org.apache.calcite.adapter.innodb.InnodbAdapterTest > testSelectBySkVarcharRangeQueryGtProjectSomeFieldsOrderByNonSkDesc()
         10.4sec, org.apache.calcite.adapter.innodb.InnodbAdapterTest > testSelectBySkVarcharRangeQueryGtProjectSomeFieldsOrderByNonSkAsc()
         10.4sec, org.apache.calcite.adapter.innodb.InnodbAdapterTest > testSelectBySkDateRangeQueryGtLteProjectSomeFields()
         10.5sec, org.apache.calcite.adapter.innodb.InnodbAdapterTest > testSelectBySkLimitedLengthVarcharConditionPushDown()
         10.5sec, org.apache.calcite.adapter.innodb.InnodbAdapterTest > testSelectBySkTimestampRangeQueryNothing()
         11.1sec, org.apache.calcite.adapter.innodb.InnodbAdapterTest > testSelectBySkTimestampRangeQueryGtLteProjectSomeFields()
          3.6sec, org.apache.calcite.adapter.innodb.InnodbAdapterTest > testSelectByPrimaryKeyRangeQueryGteLteEqualsProjectSomeFields()
          3.3sec, org.apache.calcite.adapter.innodb.InnodbAdapterTest > testSelectByPrimaryKey()
         16.4sec,   83 completed,   0 failed,   0 skipped, org.apache.calcite.adapter.innodb.InnodbAdapterTest
         20.1sec,   85 completed,   0 failed,   0 skipped, Gradle Test Run :innodb:test

> Task :piglet:test
         14.6sec,   22 completed,   0 failed,   0 skipped, org.apache.calcite.test.PigRelBuilderTest
         15.1sec, org.apache.calcite.test.PigletTest > testLimitExample()
          3.1sec, org.apache.calcite.test.PigRelExTest > testConstantString()
         18.1sec, org.apache.calcite.test.PigRelExTest > testIsNotNull()
         18.2sec, org.apache.calcite.test.PigRelExTest > testNotEqual()
         18.1sec, org.apache.calcite.test.PigRelExTest > testLessThan()
          4.5sec, org.apache.calcite.test.PigRelExTest > testEqual()
         18.2sec, org.apache.calcite.test.PigRelExTest > testMod()
         18.1sec, org.apache.calcite.test.PigRelExTest > testGreaterThanEqual()
         18.2sec, org.apache.calcite.test.PigRelExTest > testAdd()
         18.3sec, org.apache.calcite.test.PigRelExTest > testNegation()
         18.4sec, org.apache.calcite.test.PigRelExTest > testAnd()
         18.6sec, org.apache.calcite.test.PigRelExTest > testSubtract()
         18.7sec, org.apache.calcite.test.PigRelExTest > testNot()
         18.8sec, org.apache.calcite.test.PigRelOpTest > testLoadWithSchema()
WARNING  19.5sec,   19 completed,   0 failed,   1 skipped, org.apache.calcite.test.PigletTest
         20.0sec, org.apache.calcite.test.PigScriptTest > testReadScript()
          2.2sec, org.apache.calcite.test.PigRelExTest > testProjection()
         20.7sec,    1 completed,   0 failed,   0 skipped, org.apache.calcite.test.PigScriptTest
          2.4sec, org.apache.calcite.test.PigRelOpTest > testLoadWithoutSchema()
          2.2sec, org.apache.calcite.test.PigRelOpTest > testSimpleForEach1()
         20.7sec, org.apache.calcite.test.PigRelOpTest > testUdf()
         20.7sec, org.apache.calcite.test.PigRelOpTest > testUnionDifferentSchemas1()
         20.7sec, org.apache.calcite.test.PigRelOpTest > testAggregate2half()
          2.6sec, org.apache.calcite.test.PigRelOpTest > testFlattenStrSplit()
          7.5sec, org.apache.calcite.test.PigRelOpTest > testLimit()

> Task :mongodb:test
         11.5sec, org.apache.calcite.adapter.mongodb.MongoAdapterTest > testFilterPair()
WARNING  16.3sec,   31 completed,   0 failed,   6 skipped, org.apache.calcite.adapter.mongodb.MongoAdapterTest
WARNING  34.3sec,   31 completed,   0 failed,   6 skipped, Gradle Test Run :mongodb:test

> Task :plus:test
    2022-02-01 09:10:44,032 [ForkJoinPool-1-worker-4] INFO  - Checkpoint start
    2022-02-01 09:10:44,038 [ForkJoinPool-1-worker-4] INFO  - Checkpoint end - txts: 54
         10.9sec, org.apache.calcite.chinook.RemotePreparedStatementParametersTest > testParametersShouldWorkWithRaw()
         11.2sec, org.apache.calcite.adapter.os.OsAdapterTest > testStdinExplain()
         11.6sec, org.apache.calcite.adapter.os.OsAdapterTest > testVmstat()
         11.4sec, org.apache.calcite.adapter.os.OsAdapterTest > testPs()
         11.8sec, org.apache.calcite.adapter.os.OsAdapterTest > testDu()
         12.2sec, org.apache.calcite.adapter.os.OsAdapterTest > testStdin()
         12.3sec, org.apache.calcite.adapter.os.OsAdapterTest > testFiles()
         12.7sec, org.apache.calcite.chinook.RemotePreparedStatementParametersTest > testSimpleStringParameterShouldWorkWithCalcite()
         12.7sec, org.apache.calcite.adapter.os.OsAdapterTest > testJps()
         13.2sec, org.apache.calcite.chinook.RemotePreparedStatementParametersTest > testSeveralParametersShouldWorkWithCalcite()
         13.3sec,    3 completed,   0 failed,   0 skipped, org.apache.calcite.chinook.RemotePreparedStatementParametersTest
          2.5sec, org.apache.calcite.chinook.EndToEndTest > test(String)[1], [1] sql/cross-join-lateral.iq
WARNING  14.6sec,   13 completed,   0 failed,   2 skipped, org.apache.calcite.adapter.os.OsAdapterTest
         14.1sec, org.apache.calcite.chinook.EndToEndTest > test(String)[4], [4] sql/basic.iq
          5.1sec, org.apache.calcite.chinook.EndToEndTest > test(String)[2], [2] sql/preferred-for-specific-user.iq
         16.8sec,    4 completed,   0 failed,   0 skipped, test(String)
         16.8sec,    4 completed,   0 failed,   0 skipped, org.apache.calcite.chinook.EndToEndTest

> Task :geode:test

> Task :spark:test
         34.3sec, org.apache.calcite.test.SparkAdapterTest > testSelectDistinct()
         34.3sec, org.apache.calcite.test.SparkAdapterTest > testArithmeticDiv()
         34.4sec, org.apache.calcite.test.SparkAdapterTest > testFilterFalse()
         34.4sec, org.apache.calcite.test.SparkAdapterTest > testOrderByLimit()
         34.3sec, org.apache.calcite.test.SparkAdapterTest > testSortXAscYDescProjectY()
         34.3sec, org.apache.calcite.test.SparkAdapterTest > testSortXAscProjectY()
         34.3sec, org.apache.calcite.test.SparkAdapterTest > testUnionAll()
         34.3sec, org.apache.calcite.test.SparkAdapterTest > testFilterOr()
         34.4sec, org.apache.calcite.test.SparkAdapterTest > testLimit()
         34.4sec, org.apache.calcite.test.SparkAdapterTest > testSortXDescYAscProjectY()
         34.4sec, org.apache.calcite.test.SparkAdapterTest > testFilterIsNotNull()
         34.4sec, org.apache.calcite.test.SparkAdapterTest > testSortXDescYDescProjectY()
         34.3sec, org.apache.calcite.test.SparkAdapterTest > testFilterTrue()
         34.4sec, org.apache.calcite.test.SparkAdapterTest > testUnion()
         34.4sec, org.apache.calcite.test.SparkAdapterTest > testFilterIsNull()
         34.3sec, org.apache.calcite.test.SparkAdapterTest > testArithmeticPlus()
         34.4sec, org.apache.calcite.test.SparkAdapterTest > testArithmeticMul()
         34.4sec, org.apache.calcite.test.SparkAdapterTest > testJoinProjectAliasProject()
         34.3sec, org.apache.calcite.test.SparkAdapterTest > testJoinProject()
         34.4sec, org.apache.calcite.test.SparkAdapterTest > testGroupByOrderByAsc()
         34.4sec, org.apache.calcite.test.SparkAdapterTest > testUnionWithFiltersProject()
         35.4sec, org.apache.calcite.test.SparkAdapterTest > testGroupByMinMaxCountCountDistinctOrderByAsc()
         35.5sec, org.apache.calcite.test.SparkAdapterTest > testGroupBy()
         35.6sec, org.apache.calcite.test.SparkAdapterTest > testAggFuncNoGroupBy()
WARNING  35.7sec,   38 completed,   0 failed,   4 skipped, org.apache.calcite.test.SparkAdapterTest
WARNING  40.1sec,   38 completed,   0 failed,   4 skipped, Gradle Test Run :spark:test

> Task :piglet:test
          2.4sec, org.apache.calcite.test.PigRelOpTest > testSample()
          6.9sec, org.apache.calcite.test.PigRelOpTest > testSplit()
          2.1sec, org.apache.calcite.test.PigRelOpTest > testSimpleForEach3()
         21.5sec, org.apache.calcite.test.PigRelOpTest > testUnionDifferentSchemas2()
          2.4sec, org.apache.calcite.test.PigRelOpTest > testSimpleForEach2()
          3.7sec, org.apache.calcite.test.PigRelOpTest > testGroupby()
         21.9sec, org.apache.calcite.test.PigRelOpTest > testOrderBy()
          3.9sec, org.apache.calcite.test.PigRelOpTest > testMultipleStores()
         22.2sec, org.apache.calcite.test.PigRelOpTest > testCross()
          2.1sec, org.apache.calcite.test.PigRelOpTest > testAggregate2()
          2.0sec, org.apache.calcite.test.PigRelOpTest > testAggregate()
          5.3sec, org.apache.calcite.test.PigRelOpTest > testJoin2Rels()
          2.0sec, org.apache.calcite.test.PigRelOpTest > testUnionSameSchema()
          5.4sec, org.apache.calcite.test.PigRelOpTest > testRank()
          5.4sec, org.apache.calcite.test.PigRelOpTest > testJoin3Rels()
          2.8sec, org.apache.calcite.test.PigRelOpTest > testCoGroup()
          5.3sec, org.apache.calcite.test.PigRelExTest > testCast()
WARNING  24.0sec,   29 completed,   0 failed,   1 skipped, org.apache.calcite.test.PigRelExTest
          3.0sec, org.apache.calcite.test.PigRelOpTest > testCubeCube()
          2.7sec, org.apache.calcite.test.PigRelOpTest > testCubeRollup()
          2.5sec, org.apache.calcite.test.PigRelOpTest > testMultisetProjection()
          3.8sec, org.apache.calcite.test.PigRelOpTest > testAggregate3()
          3.6sec, org.apache.calcite.test.PigRelOpTest > testForEachNested()
         25.0sec,   35 completed,   0 failed,   0 skipped, org.apache.calcite.test.PigRelOpTest
WARNING  31.4sec,  106 completed,   0 failed,   2 skipped, Gradle Test Run :piglet:test

> Task :plus:test
         20.7sec, org.apache.calcite.adapter.tpch.TpchTest > testQuery02Conversion()
         11.9sec, org.apache.calcite.adapter.tpch.TpchTest > testQuery11()
         10.5sec, org.apache.calcite.adapter.tpch.TpchTest > testQuery16()
         23.6sec, org.apache.calcite.adapter.tpch.TpchTest > testQuery02()
          7.8sec, org.apache.calcite.adapter.tpch.TpchTest > testQuery22()
         24.6sec, org.apache.calcite.adapter.tpch.TpchTest > testQuery06()
         11.7sec, org.apache.calcite.adapter.tpch.TpchTest > testQuery14()
         12.9sec, org.apache.calcite.adapter.tpch.TpchTest > testQuery13()
         10.8sec, org.apache.calcite.adapter.tpch.TpchTest > testQuery20()
         25.1sec, org.apache.calcite.adapter.tpch.TpchTest > testQuery01()
         13.2sec, org.apache.calcite.adapter.tpch.TpchTest > testQuery12()
         25.3sec, org.apache.calcite.adapter.tpch.TpchTest > testQuery03()
         25.3sec, org.apache.calcite.adapter.tpch.TpchTest > testQuery10()
         25.5sec, org.apache.calcite.adapter.tpch.TpchTest > testQuery04()
         12.7sec, org.apache.calcite.adapter.tpch.TpchTest > testQuery15()
         25.6sec, org.apache.calcite.adapter.tpch.TpchTest > testQuery08()
         12.0sec, org.apache.calcite.adapter.tpch.TpchTest > testQuery18()
         25.9sec, org.apache.calcite.adapter.tpch.TpchTest > testQuery09()
         12.6sec, org.apache.calcite.adapter.tpch.TpchTest > testQuery17()

> Task :redis:test

Gradle Test Executor 12 STANDARD_OUT
    docker[redis:2.8.19] 2022-02-01 09:10:59,075 [ForkJoinPool-1-worker-25] INFO  - Pulling docker image: redis:2.8.19. Please be patient; this may take some time but only needs to be done once.
    docker[redis:2.8.19] 2022-02-01 09:11:00,618 [docker-java-stream--1133810895] INFO  - Starting to pull image
    docker[redis:2.8.19] 2022-02-01 09:11:00,620 [docker-java-stream--1133810895] INFO  - Pulling image layers:  0 pending,  0 downloaded,  0 extracted, (0 bytes/0 bytes)
    docker[redis:2.8.19] 2022-02-01 09:11:01,003 [docker-java-stream--1133810895] INFO  - Pulling image layers:  8 pending,  1 downloaded,  0 extracted, (32 bytes/? MB)
    docker[redis:2.8.19] 2022-02-01 09:11:01,159 [docker-java-stream--1133810895] INFO  - Pulling image layers:  7 pending,  2 downloaded,  0 extracted, (1 KB/? MB)
    docker[redis:2.8.19] 2022-02-01 09:11:01,658 [docker-java-stream--1133810895] INFO  - Pulling image layers:  6 pending,  3 downloaded,  0 extracted, (15 MB/? MB)
    docker[redis:2.8.19] 2022-02-01 09:11:01,744 [docker-java-stream--1133810895] INFO  - Pulling image layers:  5 pending,  4 downloaded,  0 extracted, (17 MB/? MB)
    docker[redis:2.8.19] 2022-02-01 09:11:02,141 [docker-java-stream--1133810895] INFO  - Pulling image layers:  4 pending,  5 downloaded,  0 extracted, (37 MB/? MB)
    docker[redis:2.8.19] 2022-02-01 09:11:02,147 [docker-java-stream--1133810895] INFO  - Pulling image layers:  3 pending,  6 downloaded,  0 extracted, (38 MB/? MB)
    docker[redis:2.8.19] 2022-02-01 09:11:02,498 [docker-java-stream--1133810895] INFO  - Pulling image layers:  2 pending,  7 downloaded,  0 extracted, (38 MB/? MB)
    docker[redis:2.8.19] 2022-02-01 09:11:02,583 [docker-java-stream--1133810895] INFO  - Pulling image layers:  1 pending,  8 downloaded,  0 extracted, (38 MB/? MB)
    docker[redis:2.8.19] 2022-02-01 09:11:02,699 [docker-java-stream--1133810895] INFO  - Pulling image layers:  0 pending,  9 downloaded,  0 extracted, (39 MB/46 MB)

> Task :geode:test
          5.2sec, org.apache.calcite.adapter.geode.rel.GeodeBookstoreTest > testSqlDistinctSort()
          5.5sec, org.apache.calcite.adapter.geode.rel.GeodeAllDataTypesTest > testSqlMultipleDateWhereFilter()
          5.5sec, org.apache.calcite.adapter.geode.rel.GeodeAllDataTypesTest > testSqlBooleanColumnFilter()
          5.6sec, org.apache.calcite.adapter.geode.rel.GeodeAllDataTypesTest > testSqlMultipleBooleanWhereFilter()
          5.6sec, org.apache.calcite.adapter.geode.rel.GeodeAllDataTypesTest > testSqlSingleBooleanWhereFilter()
          5.5sec, org.apache.calcite.adapter.geode.rel.GeodeAllDataTypesTest > testSqlBooleanColumnNotFilter()
          5.6sec, org.apache.calcite.adapter.geode.rel.GeodeAllDataTypesTest > testSqlWhereWithMultipleOrForLiteralFields()
          5.5sec, org.apache.calcite.adapter.geode.rel.GeodeAllDataTypesTest > testSqlMultipleTimeWhereFilter()
          5.4sec, org.apache.calcite.adapter.geode.rel.GeodeBookstoreTest > testSqlSimple()
          5.7sec, org.apache.calcite.adapter.geode.rel.GeodeAllDataTypesTest > testSqlMultipleTimestampWhereFilter()
          5.8sec, org.apache.calcite.adapter.geode.rel.GeodeAllDataTypesTest > testSqlWhereWithMultipleOrForAllFields()
          5.7sec, org.apache.calcite.adapter.geode.rel.GeodeBookstoreTest > testSortWithProjection()
          5.7sec, org.apache.calcite.adapter.geode.rel.GeodeBookstoreTest > testAddMissingGroupByColumnToProjectedFields()
          5.7sec, org.apache.calcite.adapter.geode.rel.GeodeBookstoreTest > testMissingProjectRelationOnGroupByColumnMatchingProjectedFields()
          5.7sec, org.apache.calcite.adapter.geode.rel.GeodeBookstoreTest > testSortWithProjectionAndLimit()
          5.7sec, org.apache.calcite.adapter.geode.rel.GeodeBookstoreTest > testInSetFilterWithNestedStringField()
          5.7sec, org.apache.calcite.adapter.geode.rel.GeodeZipsTest > testMaxRaw()
          5.9sec, org.apache.calcite.adapter.geode.rel.GeodeBookstoreTest > testWhereWithOr()
          5.9sec, org.apache.calcite.adapter.geode.rel.GeodeBookstoreTest > testFilterWithNestedField()
          6.1sec, org.apache.calcite.adapter.geode.rel.GeodeBookstoreTest > testCount()
          6.3sec, org.apache.calcite.adapter.geode.rel.GeodeAllDataTypesTest > testSqlSingleTimestampWhereFilter()
          6.5sec, org.apache.calcite.adapter.geode.rel.GeodeAllDataTypesTest > testSqlSingleTimeWhereFilter()
          6.7sec, org.apache.calcite.adapter.geode.rel.GeodeAllDataTypesTest > testSqlSingleDateWhereFilter()
         23.7sec,   12 completed,   0 failed,   0 skipped, org.apache.calcite.adapter.geode.rel.GeodeAllDataTypesTest
          2.0sec, org.apache.calcite.adapter.geode.rel.GeodeZipsTest > testWhereWithOrForLargeValueList()
         24.8sec,   36 completed,   0 failed,   0 skipped, org.apache.calcite.adapter.geode.rel.GeodeBookstoreTest
          2.2sec, org.apache.calcite.adapter.geode.rel.GeodeZipsTest > testItemPredicate()
WARNING  25.0sec,   14 completed,   0 failed,   3 skipped, org.apache.calcite.adapter.geode.rel.GeodeZipsTest
WARNING  37.6sec,   62 completed,   0 failed,   3 skipped, Gradle Test Run :geode:test

> Task :plus:test
         14.0sec, org.apache.calcite.adapter.tpch.TpchTest > testQuery21()
         31.9sec, org.apache.calcite.adapter.tpch.TpchTest > testQuery05()

> Task :redis:test
    docker[redis:2.8.19] 2022-02-01 09:11:06,426 [docker-java-stream--1133810895] INFO  - Pulling image layers:  0 pending,  9 downloaded,  1 extracted, (42 MB/46 MB)
    docker[redis:2.8.19] 2022-02-01 09:11:07,918 [docker-java-stream--1133810895] INFO  - Pulling image layers:  0 pending,  9 downloaded,  2 extracted, (42 MB/46 MB)
    docker[redis:2.8.19] 2022-02-01 09:11:08,470 [docker-java-stream--1133810895] INFO  - Pulling image layers:  0 pending,  9 downloaded,  3 extracted, (42 MB/46 MB)
    docker[redis:2.8.19] 2022-02-01 09:11:09,400 [docker-java-stream--1133810895] INFO  - Pulling image layers:  0 pending,  9 downloaded,  4 extracted, (44 MB/46 MB)
    docker[redis:2.8.19] 2022-02-01 09:11:10,094 [docker-java-stream--1133810895] INFO  - Pulling image layers:  0 pending,  9 downloaded,  5 extracted, (44 MB/46 MB)
    docker[redis:2.8.19] 2022-02-01 09:11:10,648 [docker-java-stream--1133810895] INFO  - Pulling image layers:  0 pending,  9 downloaded,  6 extracted, (44 MB/46 MB)
    docker[redis:2.8.19] 2022-02-01 09:11:14,987 [docker-java-stream--1133810895] INFO  - Pulling image layers:  0 pending,  9 downloaded,  7 extracted, (46 MB/46 MB)
    docker[redis:2.8.19] 2022-02-01 09:11:15,489 [docker-java-stream--1133810895] INFO  - Pulling image layers:  0 pending,  9 downloaded,  8 extracted, (46 MB/46 MB)
    docker[redis:2.8.19] 2022-02-01 09:11:16,757 [docker-java-stream--1133810895] INFO  - Pulling image layers:  0 pending,  9 downloaded,  9 extracted, (46 MB/46 MB)
    docker[redis:2.8.19] 2022-02-01 09:11:18,501 [docker-java-stream--1133810895] INFO  - Pull complete. 9 layers, pulled in 17s (downloaded 46 MB at 2 MB/s)
    docker[redis:2.8.19] 2022-02-01 09:11:18,541 [ForkJoinPool-1-worker-25] INFO  - Creating container for image: redis:2.8.19
    docker[redis:2.8.19] 2022-02-01 09:11:20,938 [ForkJoinPool-1-worker-25] INFO  - Starting container with ID: a21e1a3aa53689a0d1ac14a87b63b46a569a3451eaa16111b7da7707e5e3b9ae
    docker[redis:2.8.19] 2022-02-01 09:11:22,129 [ForkJoinPool-1-worker-25] INFO  - Container redis:2.8.19 is starting: a21e1a3aa53689a0d1ac14a87b63b46a569a3451eaa16111b7da7707e5e3b9ae
    docker[redis:2.8.19] 2022-02-01 09:11:22,295 [ForkJoinPool-1-worker-25] INFO  - Container redis:2.8.19 started in PT23.383S
          3.5sec, org.apache.calcite.adapter.redis.RedisAdapterCaseBase > testSqlWithJoin()
         57.2sec,    2 completed,   0 failed,   0 skipped, org.apache.calcite.adapter.redis.RedisAdapterCaseBase
WARNING  63.2sec,    3 completed,   0 failed,   1 skipped, Gradle Test Run :redis:test

> Task :plus:test
         71.5sec, org.apache.calcite.adapter.tpch.TpchTest > testQuery07()
WARNING  72.0sec,   29 completed,   0 failed,   7 skipped, org.apache.calcite.adapter.tpch.TpchTest
WARNING  76.6sec,   51 completed,   0 failed,  11 skipped, Gradle Test Run :plus:test

FAILURE: Build failed with an exception.

* What went wrong:
Execution failed for task ':server:test'.
> There were failing tests. See the report at: file://<https://ci-builds.apache.org/job/Calcite/job/Calcite-snapshots/ws/server/build/reports/tests/test/index.html>

* Try:
> Run with --stacktrace option to get the stack trace.
> Run with --info or --debug option to get more log output.
> Run with --scan to get full insights.

* Get more help at https://help.gradle.org

Deprecated Gradle features were used in this build, making it incompatible with Gradle 8.0.

You can use '--warning-mode all' to show the individual deprecation warnings and determine if they come from your own scripts or plugins.

See https://docs.gradle.org/7.3/userguide/command_line_interface.html#sec:command_line_warnings

BUILD FAILED in 4m 36s
434 actionable tasks: 434 executed

See the profiling report at: file://<https://ci-builds.apache.org/job/Calcite/job/Calcite-snapshots/ws/build/reports/profile/profile-2022-02-01-09-07-19.html>
A fine-grained performance profile is available: use the --scan option.

See the profiling report at: file://<https://ci-builds.apache.org/job/Calcite/job/Calcite-snapshots/ws/buildSrc/build/reports/profile/profile-2022-02-01-09-07-26.html>
A fine-grained performance profile is available: use the --scan option.
Build step 'Invoke Gradle script' changed build result to FAILURE
Build step 'Invoke Gradle script' marked build as failure
Recording test results
[Checks API] No suitable checks publisher found.

Jenkins build is back to normal : Calcite » Calcite-snapshots #62

Posted by Apache Jenkins Server <je...@builds.apache.org>.
See <https://ci-builds.apache.org/job/Calcite/job/Calcite-snapshots/62/display/redirect?page=changes>


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

Posted by Apache Jenkins Server <je...@builds.apache.org>.
See <https://ci-builds.apache.org/job/Calcite/job/Calcite-snapshots/61/display/redirect?page=changes>

Changes:

[Stamatis Zampetakis] [CALCITE-4702] Error when executing query with GROUP BY constant via JDBC adapter


------------------------------------------
[...truncated 427.48 KB...]
    > 	at org.apache.calcite.runtime.Resources$ExInst.ex(Resources.java:599)
    > 	... 72 more
    > java.sql.SQLException: Error while executing SQL "select * from dept where deptno < 15": From line 1, column 15 to line 1, column 18: Object 'DEPT' not found
    > 	at org.apache.calcite.avatica.Helper.createException(Helper.java:56)
    > 	at org.apache.calcite.avatica.Helper.createException(Helper.java:41)
    > 	at org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:163)
    > 	at org.apache.calcite.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:227)
    > 	at net.hydromatic.quidem.Quidem.checkResult(Quidem.java:325)
    > 	at net.hydromatic.quidem.Quidem.access$2800(Quidem.java:54)
    > 	at net.hydromatic.quidem.Quidem$ContextImpl.checkResult(Quidem.java:1748)
    > 	at net.hydromatic.quidem.Quidem$CheckResultCommand.execute(Quidem.java:1079)
    > 	at net.hydromatic.quidem.Quidem$CompositeCommand.execute(Quidem.java:1549)
    > 	at net.hydromatic.quidem.Quidem.execute(Quidem.java:216)
    > 	at org.apache.calcite.test.QuidemTest.checkRun(QuidemTest.java:171)
    > 	at org.apache.calcite.test.QuidemTest.test(QuidemTest.java:222)
    > 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    > 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    > 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    > 	at java.lang.reflect.Method.invoke(Method.java:498)
    > 	at org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:725)
    > 	at org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60)
    > 	at org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:131)
    > 	at org.junit.jupiter.engine.extension.TimeoutInvocation.proceed(TimeoutInvocation.java:46)
    > 	at org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:149)
    > 	at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:140)
    > 	at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestTemplateMethod(TimeoutExtension.java:92)
    > 	at org.junit.jupiter.engine.execution.ExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(ExecutableInvoker.java:115)
    > 	at org.junit.jupiter.engine.execution.ExecutableInvoker.lambda$invoke$0(ExecutableInvoker.java:105)
    > 	at org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:106)
    > 	at org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:64)
    > 	at org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:45)
    > 	at org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:37)
    > 	at org.junit.jupiter.engine.execution.ExecutableInvoker.invoke(ExecutableInvoker.java:104)
    > 	at org.junit.jupiter.engine.execution.ExecutableInvoker.invoke(ExecutableInvoker.java:98)
    > 	at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$7(TestMethodTestDescriptor.java:214)
    > 	at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
    > 	at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.invokeTestMethod(TestMethodTestDescriptor.java:210)
    > 	at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:135)
    > 	at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:66)
    > 	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$6(NodeTestTask.java:151)
    > 	at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
    > 	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:141)
    > 	at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:137)
    > 	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$9(NodeTestTask.java:139)
    > 	at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
    > 	at org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:138)
    > 	at org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:95)
    > 	at org.junit.platform.engine.support.hierarchical.ForkJoinPoolHierarchicalTestExecutorService$ExclusiveTask.compute(ForkJoinPoolHierarchicalTestExecutorService.java:185)
    > 	at java.util.concurrent.RecursiveAction.exec(RecursiveAction.java:189)
    > 	at java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:289)
    > 	at java.util.concurrent.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1067)
    > 	at java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1703)
    > 	at java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:172)
    > Caused by: org.apache.calcite.runtime.CalciteContextException: From line 1, column 15 to line 1, column 18: Object 'DEPT' not found
    > 	at sun.reflect.GeneratedConstructorAccessor18.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.sql.SqlUtil.newContextException(SqlUtil.java:932)
    > 	at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:917)
    > 	at org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:5266)
    > 	at org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl(IdentifierNamespace.java:183)
    > 	at org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:188)
    > 	at org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:89)
    > 	at org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1100)
    > 	at org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1071)
    > 	at org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3375)
    > 	at org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3357)
    > 	at org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:3639)
    > 	at org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:64)
    > 	at org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:89)
    > 	at org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1100)
    > 	at org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1071)
    > 	at org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:247)
    > 	at org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:1046)
    > 	at org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:752)
    > 	at org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:586)
    > 	at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:257)
    > 	at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:220)
    > 	at org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:648)
    > 	at org.apache.calcite.prepare.CalcitePrepareImpl.prepare_(CalcitePrepareImpl.java:514)
    > 	at org.apache.calcite.prepare.CalcitePrepareImpl.prepareSql(CalcitePrepareImpl.java:484)
    > 	at org.apache.calcite.jdbc.CalciteConnectionImpl.parseQuery(CalciteConnectionImpl.java:234)
    > 	at org.apache.calcite.jdbc.CalciteMetaImpl.prepareAndExecute(CalciteMetaImpl.java:623)
    > 	at org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:674)
    > 	at org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:156)
    > 	... 47 more
    > Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Object 'DEPT' not found
    > 	at sun.reflect.GeneratedConstructorAccessor21.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)
    > 	... 75 more
    
        at org.junit.jupiter.api.AssertionUtils.fail(AssertionUtils.java:39)
        at org.junit.jupiter.api.Assertions.fail(Assertions.java:134)
        at org.apache.calcite.test.QuidemTest.checkRun(QuidemTest.java:175)
        at org.apache.calcite.test.QuidemTest.test(QuidemTest.java:222)
        at org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:725)
        at org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60)
        at org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:131)
        at org.junit.jupiter.engine.extension.TimeoutInvocation.proceed(TimeoutInvocation.java:46)
        at org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:149)
        at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:140)
        at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestTemplateMethod(TimeoutExtension.java:92)
        at org.junit.jupiter.engine.execution.ExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(ExecutableInvoker.java:115)
        at org.junit.jupiter.engine.execution.ExecutableInvoker.lambda$invoke$0(ExecutableInvoker.java:105)
        at org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:106)
        at org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:64)
        at org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:45)
        at org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:37)
        at org.junit.jupiter.engine.execution.ExecutableInvoker.invoke(ExecutableInvoker.java:104)
        at org.junit.jupiter.engine.execution.ExecutableInvoker.invoke(ExecutableInvoker.java:98)
        at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$7(TestMethodTestDescriptor.java:214)
        at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
        at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.invokeTestMethod(TestMethodTestDescriptor.java:210)
        at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:135)
        at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:66)
        at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$6(NodeTestTask.java:151)
        at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
        at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:141)
        at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:137)
        at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$9(NodeTestTask.java:139)
        at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
        at org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:138)
        at org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:95)

          4.9sec, org.apache.calcite.test.ServerTest > testInsertCastedValueOfCompositeUdt()

> Task :splunk:jandexTest
> Task :splunk:jandex
> Task :pig:classes
> Task :pig:jandexMain
> Task :pig:processJandexIndex NO-SOURCE
> Task :pig:jar
> Task :pig:sourcesJar
> Task :pig:assemble
> Task :testkit:sourcesJar
> Task :testkit:assemble

> Task :server:test FAILED
          4.0sec, org.apache.calcite.test.ServerQuidemTest > test(String)[5], [5] sql/table.iq
          4.0sec, org.apache.calcite.test.ServerQuidemTest > test(String)[4], [4] sql/view.iq
          5.3sec, org.apache.calcite.test.ServerTest > testStoredGeneratedColumn()
WARNING   5.4sec,   15 completed,   0 failed,   1 skipped, org.apache.calcite.test.ServerTest
          4.4sec, org.apache.calcite.test.ServerQuidemTest > test(String)[3], [3] sql/table_as.iq
          5.8sec, org.apache.calcite.test.ServerQuidemTest > test(String)[6], [6] sql/schema.iq
FAILURE   5.9sec,    6 completed,   1 failed,   0 skipped, test(String)
FAILURE   6.0sec,    6 completed,   1 failed,   0 skipped, org.apache.calcite.test.ServerQuidemTest
FAILURE   8.2sec,  907 completed,   1 failed,  12 skipped, Gradle Test Run :server:test

907 tests completed, 1 failed, 12 skipped

> Task :testkit:forbiddenApisMain

> Task :druid:test
WARNING   0.2sec,  235 completed,   0 failed, 235 skipped, org.apache.calcite.test.DruidAdapterIT
WARNING   0.2sec,  210 completed,   0 failed, 210 skipped, org.apache.calcite.test.DruidAdapter2IT

> Task :pig:forbiddenApisMain

> Task :splunk:test
WARNING   1.0sec,    7 completed,   0 failed,   1 skipped, org.apache.calcite.test.SplunkAdapterTest
WARNING   2.9sec,    7 completed,   0 failed,   1 skipped, Gradle Test Run :splunk:test

> Task :druid:test
          1.8sec,    2 completed,   0 failed,   0 skipped, org.apache.calcite.adapter.druid.DruidQueryFilterTest
          2.8sec, org.apache.calcite.test.DruidDateRangeRulesTest > testFilterWithCast()
          2.8sec, org.apache.calcite.test.DruidDateRangeRulesTest > testExtractYearMonthDayFromTimestampColumn()
          2.8sec, org.apache.calcite.test.DruidDateRangeRulesTest > testRangeCalc()
          2.8sec, org.apache.calcite.test.DruidDateRangeRulesTest > testExtractYearAndMonthFromDateColumn()
          2.8sec, org.apache.calcite.test.DruidDateRangeRulesTest > testExtractYearMonthDayFromDateColumn()
          2.8sec, org.apache.calcite.test.DruidDateRangeRulesTest > testExtractYearAndDayFromDateColumn()
          2.9sec,    6 completed,   0 failed,   0 skipped, org.apache.calcite.test.DruidDateRangeRulesTest
WARNING   5.5sec,  453 completed,   0 failed, 445 skipped, Gradle Test Run :druid:test

> Task :redis:compileTestJava

> Task :mongodb:test
          3.7sec, org.apache.calcite.adapter.mongodb.MongoAdapterTest > testCountViaInt()
          3.8sec, org.apache.calcite.adapter.mongodb.MongoAdapterTest > testDate()
          3.8sec, org.apache.calcite.adapter.mongodb.MongoAdapterTest > testZips()
          3.8sec, org.apache.calcite.adapter.mongodb.MongoAdapterTest > testFilterSortDesc()
          3.9sec, org.apache.calcite.adapter.mongodb.MongoAdapterTest > testFilterRedundant()
          3.8sec, org.apache.calcite.adapter.mongodb.MongoAdapterTest > testFilter()
          3.9sec, org.apache.calcite.adapter.mongodb.MongoAdapterTest > testInPlan()
          3.9sec, org.apache.calcite.adapter.mongodb.MongoAdapterTest > testOffsetLimit()
          4.0sec, org.apache.calcite.adapter.mongodb.MongoAdapterTest > testLimit()
          3.9sec, org.apache.calcite.adapter.mongodb.MongoAdapterTest > testCountGroupByEmptyMultiplyBy2()
          4.0sec, org.apache.calcite.adapter.mongodb.MongoAdapterTest > testSort()
          3.9sec, org.apache.calcite.adapter.mongodb.MongoAdapterTest > testGroupByOneColumnNotProjected()
          4.0sec, org.apache.calcite.adapter.mongodb.MongoAdapterTest > testSortLimit()
          4.0sec, org.apache.calcite.adapter.mongodb.MongoAdapterTest > testGroupByOneColumnReversed()
          4.0sec, org.apache.calcite.adapter.mongodb.MongoAdapterTest > testFilterReversed()
          4.0sec, org.apache.calcite.adapter.mongodb.MongoAdapterTest > testSelectWhere()
          4.0sec, org.apache.calcite.adapter.mongodb.MongoAdapterTest > testGroupByHaving()
          4.0sec, org.apache.calcite.adapter.mongodb.MongoAdapterTest > testCountGroupByEmpty()
          4.0sec, org.apache.calcite.adapter.mongodb.MongoAdapterTest > testGroupByMinMaxSum()
          4.0sec, org.apache.calcite.adapter.mongodb.MongoAdapterTest > testGroupByAvg()
          4.0sec, org.apache.calcite.adapter.mongodb.MongoAdapterTest > testGroupComposite()
          4.0sec, org.apache.calcite.adapter.mongodb.MongoAdapterTest > testDistinctCountOrderBy()
          4.0sec, org.apache.calcite.adapter.mongodb.MongoAdapterTest > testGroupByAvgSumCount()
          5.1sec, org.apache.calcite.adapter.mongodb.MongoAdapterTest > testFilterPair()
WARNING   6.2sec,   31 completed,   0 failed,   6 skipped, org.apache.calcite.adapter.mongodb.MongoAdapterTest
WARNING  11.4sec,   31 completed,   0 failed,   6 skipped, Gradle Test Run :mongodb:test

> Task :cassandra:compileTestJava

> Task :core:compileTestJava
Note: Some input files use unchecked or unsafe operations.
Note: Recompile with -Xlint:unchecked for details.

> Task :plus:test
         60.9sec, org.apache.calcite.adapter.tpch.TpchTest > testQuery07()
WARNING  61.2sec,   29 completed,   0 failed,   7 skipped, org.apache.calcite.adapter.tpch.TpchTest
WARNING  63.8sec,   51 completed,   0 failed,  11 skipped, Gradle Test Run :plus:test

FAILURE: Build failed with an exception.

* What went wrong:
Execution failed for task ':server:test'.
> There were failing tests. See the report at: file://<https://ci-builds.apache.org/job/Calcite/job/Calcite-snapshots/ws/server/build/reports/tests/test/index.html>

* Try:
> Run with --stacktrace option to get the stack trace.
> Run with --info or --debug option to get more log output.
> Run with --scan to get full insights.

* Get more help at https://help.gradle.org

Deprecated Gradle features were used in this build, making it incompatible with Gradle 8.0.

You can use '--warning-mode all' to show the individual deprecation warnings and determine if they come from your own scripts or plugins.

See https://docs.gradle.org/7.3/userguide/command_line_interface.html#sec:command_line_warnings

BUILD FAILED in 9m 51s
393 actionable tasks: 393 executed

See the profiling report at: file://<https://ci-builds.apache.org/job/Calcite/job/Calcite-snapshots/ws/build/reports/profile/profile-2022-02-03-12-38-17.html>
A fine-grained performance profile is available: use the --scan option.

See the profiling report at: file://<https://ci-builds.apache.org/job/Calcite/job/Calcite-snapshots/ws/buildSrc/build/reports/profile/profile-2022-02-03-12-40-24.html>
A fine-grained performance profile is available: use the --scan option.
Build step 'Invoke Gradle script' changed build result to FAILURE
Build step 'Invoke Gradle script' marked build as failure
Recording test results
[Checks API] No suitable checks publisher found.