You are viewing a plain text version of this content. The canonical link for it is here.
Posted to builds@beam.apache.org by Apache Jenkins Server <je...@builds.apache.org> on 2023/02/19 04:40:50 UTC

Build failed in Jenkins: beam_PreCommit_SQL_Java11_Cron #3982

See <https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/3982/display/redirect>

Changes:


------------------------------------------
[...truncated 304.61 KB...]
    java.lang.IllegalArgumentException at TextTableProviderTest.java:262

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testLines FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:205

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testJson FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:224

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testWriteCsv FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:282

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testWriteJson FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:301

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testExplicitCsv FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:152

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testExplicitCsvExcel FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:180

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testLegacyTdfCsv FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:127

715 tests completed, 455 failed, 8 skipped

> Task :sdks:java:extensions:sql:test FAILED

> Task :sdks:java:extensions:sql:runBasicExample
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-jdk14/1.7.30/d35953dd2fe54ebe39fdf18cfd82fe6eb35b25ed/slf4j-jdk14-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-reload4j/1.7.36/db708f7d959dee1857ac524636e85ecf2e1781c1/slf4j-reload4j-1.7.36.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-log4j12/1.7.30/c21f55139d8141d2231214fb1feaf50a1edca95e/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.JDK14LoggerFactory]
Feb 19, 2023 4:39:32 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `PCOLLECTION`.`c1`, `PCOLLECTION`.`c2`, `PCOLLECTION`.`c3`
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`
WHERE `PCOLLECTION`.`c1` > 1
Feb 19, 2023 4:39:32 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(c1=[$0], c2=[$1], c3=[$2])
  LogicalFilter(condition=[>($0, 1)])
    BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 19, 2023 4:39:33 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..2=[{inputs}], expr#3=[1], expr#4=[>($t0, $t3)], proj#0..2=[{exprs}], $condition=[$t4])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 19, 2023 4:39:33 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `CASE1_RESULT`.`c2`, SUM(`CASE1_RESULT`.`c3`)
FROM `beam`.`CASE1_RESULT` AS `CASE1_RESULT`
GROUP BY `CASE1_RESULT`.`c2`
Feb 19, 2023 4:39:33 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalAggregate(group=[{0}], EXPR$1=[SUM($1)])
  LogicalProject(c2=[$1], c3=[$2])
    BeamIOSourceRel(table=[[beam, CASE1_RESULT]])

Feb 19, 2023 4:39:33 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamAggregationRel(group=[{1}], EXPR$1=[SUM($2)])
  BeamIOSourceRel(table=[[beam, CASE1_RESULT]])

Feb 19, 2023 4:39:34 AM org.apache.beam.sdk.Pipeline validate
WARNING: The following transforms do not have stable unique names: log_result, SqlTransform
PCOLLECTION: [3, row, 3.0]
PCOLLECTION: [2, row, 2.0]
CASE1_RESULT: [row, 5.0]

> Task :sdks:java:extensions:sql:shell:distZip

> Task :sdks:java:extensions:sql:runPojoExample
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-jdk14/1.7.30/d35953dd2fe54ebe39fdf18cfd82fe6eb35b25ed/slf4j-jdk14-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-reload4j/1.7.36/db708f7d959dee1857ac524636e85ecf2e1781c1/slf4j-reload4j-1.7.36.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-log4j12/1.7.30/c21f55139d8141d2231214fb1feaf50a1edca95e/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.JDK14LoggerFactory]
Feb 19, 2023 4:39:41 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `PCOLLECTION`.`id`, `PCOLLECTION`.`name`
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`
WHERE `PCOLLECTION`.`countryOfResidence` = 'Wonderland'
Feb 19, 2023 4:39:42 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(id=[$1], name=[$0])
  LogicalFilter(condition=[=($2, 'Wonderland')])
    BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 19, 2023 4:39:42 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..2=[{inputs}], expr#3=['Wonderland':VARCHAR], expr#4=[=($t2, $t3)], id=[$t1], name=[$t0], $condition=[$t4])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 19, 2023 4:39:42 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT COUNT(`PCOLLECTION`.`id`)
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`
Feb 19, 2023 4:39:42 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalAggregate(group=[{}], EXPR$0=[COUNT()])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 19, 2023 4:39:42 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamAggregationRel(group=[{}], EXPR$0=[COUNT()])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 19, 2023 4:39:43 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `customers`.`name`, 'order id:' || CAST(`orders`.`id` AS VARCHAR)
FROM `beam`.`orders` AS `orders`
INNER JOIN `beam`.`customers` AS `customers` ON `orders`.`customerId` = `customers`.`id`
WHERE `customers`.`name` = 'Grault'
Feb 19, 2023 4:39:43 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(name=[$2], EXPR$1=[||('order id:', CAST($0):VARCHAR NOT NULL)])
  LogicalFilter(condition=[=($2, 'Grault')])
    LogicalJoin(condition=[=($1, $3)], joinType=[inner])
      BeamIOSourceRel(table=[[beam, orders]])
      BeamIOSourceRel(table=[[beam, customers]])

Feb 19, 2023 4:39:43 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..4=[{inputs}], expr#5=['order id:'], expr#6=[CAST($t0):VARCHAR NOT NULL], expr#7=[||($t5, $t6)], name=[$t2], EXPR$1=[$t7])
  BeamCoGBKJoinRel(condition=[=($1, $3)], joinType=[inner])
    BeamIOSourceRel(table=[[beam, orders]])
    BeamCalcRel(expr#0..2=[{inputs}], expr#3=['Grault':VARCHAR], expr#4=[=($t0, $t3)], proj#0..2=[{exprs}], $condition=[$t4])
      BeamIOSourceRel(table=[[beam, customers]])

Feb 19, 2023 4:39:43 AM org.apache.beam.sdk.Pipeline validate
WARNING: The following transforms do not have stable unique names: Create.Values, MapElements, SqlTransform
[3, Baz]: is from Wonderland
[1, Foo]: is from Wonderland
[4, Grault]: is from Wonderland
[3]: total customers in Wonderland
[Grault, order id:8]: ordered by 'Grault'
[Grault, order id:7]: ordered by 'Grault'

> Task :sdks:java:extensions:sql:shell:assemble
> Task :sdks:java:extensions:sql:shell:analyzeClassesDependencies FROM-CACHE
> Task :sdks:java:extensions:sql:shell:analyzeDependencies UP-TO-DATE
> Task :sdks:java:extensions:sql:shell:test NO-SOURCE
> Task :sdks:java:extensions:sql:shell:check UP-TO-DATE
> Task :sdks:java:extensions:sql:shell:build
> Task :sdks:java:extensions:sql:shell:buildDependents
> Task :runners:flink:1.12:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.13:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.14:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.15:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.12:job-server:startShadowScripts
> Task :runners:flink:1.12:job-server:shadowDistTar
> Task :runners:flink:1.13:job-server:startShadowScripts
> Task :runners:flink:1.13:job-server:shadowDistTar
> Task :runners:flink:1.14:job-server:startShadowScripts
> Task :runners:flink:1.15:job-server:startShadowScripts
> Task :runners:flink:1.14:job-server:shadowDistTar
> Task :runners:flink:1.15:job-server:shadowDistTar
> Task :runners:flink:1.12:job-server:shadowDistZip
> Task :runners:flink:1.12:job-server:assemble
> Task :runners:flink:1.12:job-server:test NO-SOURCE
> Task :runners:flink:1.12:job-server:check UP-TO-DATE
> Task :runners:flink:1.12:job-server:build
> Task :runners:flink:1.12:job-server:buildDependents
> Task :runners:flink:1.13:job-server:shadowDistZip
> Task :runners:flink:1.13:job-server:assemble
> Task :runners:flink:1.13:job-server:test NO-SOURCE
> Task :runners:flink:1.13:job-server:check UP-TO-DATE
> Task :runners:flink:1.13:job-server:build
> Task :runners:flink:1.13:job-server:buildDependents
> Task :runners:flink:1.14:job-server:shadowDistZip
> Task :runners:flink:1.15:job-server:shadowDistZip
> Task :runners:flink:1.14:job-server:assemble
> Task :runners:flink:1.14:job-server:test NO-SOURCE
> Task :runners:flink:1.14:job-server:check UP-TO-DATE
> Task :runners:flink:1.14:job-server:build
> Task :runners:flink:1.14:job-server:buildDependents
> Task :runners:flink:1.15:job-server:assemble
> Task :runners:flink:1.15:job-server:test NO-SOURCE
> Task :runners:flink:1.15:job-server:check UP-TO-DATE
> Task :runners:flink:1.15:job-server:build
> Task :runners:flink:1.15:job-server:buildDependents
> Task :sdks:java:extensions:sql:expansion-service:buildDependents

FAILURE: Build completed with 4 failures.

1: Task failed with an exception.
-----------
* What went wrong:
Execution failed for task ':sdks:java:extensions:sql:jdbc:test'.
> There were failing tests. See the report at: file://<https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/ws/src/sdks/java/extensions/sql/jdbc/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.
==============================================================================

2: Task failed with an exception.
-----------
* What went wrong:
Execution failed for task ':sdks:java:testing:nexmark:test'.
> There were failing tests. See the report at: file://<https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/ws/src/sdks/java/testing/nexmark/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.
==============================================================================

3: Task failed with an exception.
-----------
* What went wrong:
Execution failed for task ':sdks:java:extensions:sql:zetasql:test'.
> There were failing tests. See the report at: file://<https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/ws/src/sdks/java/extensions/sql/zetasql/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.
==============================================================================

4: Task failed with an exception.
-----------
* What went wrong:
Execution failed for task ':sdks:java:extensions:sql:test'.
> There were failing tests. See the report at: file://<https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/ws/src/sdks/java/extensions/sql/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.
==============================================================================

* 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.5.1/userguide/command_line_interface.html#sec:command_line_warnings

BUILD FAILED in 3m 14s
256 actionable tasks: 139 executed, 117 from cache

Publishing build scan...
https://gradle.com/s/ju6crelvgdb7o

Build step 'Invoke Gradle script' changed build result to FAILURE
Build step 'Invoke Gradle script' marked build as failure

---------------------------------------------------------------------
To unsubscribe, e-mail: builds-unsubscribe@beam.apache.org
For additional commands, e-mail: builds-help@beam.apache.org

Jenkins build is back to normal : beam_PreCommit_SQL_Java11_Cron #3993

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


---------------------------------------------------------------------
To unsubscribe, e-mail: builds-unsubscribe@beam.apache.org
For additional commands, e-mail: builds-help@beam.apache.org

Build failed in Jenkins: beam_PreCommit_SQL_Java11_Cron #3992

Posted by Apache Jenkins Server <je...@builds.apache.org>.
See <https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/3992/display/redirect>

Changes:


------------------------------------------
[...truncated 305.03 KB...]

> Task :runners:flink:1.15:job-server:distZip

> Task :sdks:java:extensions:sql:test FAILED

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testWriteCsv FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:282

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testWriteJson FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:301

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testExplicitCsv FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:152

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testExplicitCsvExcel FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:180

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testLegacyTdfCsv FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:127

715 tests completed, 455 failed, 8 skipped

> Task :sdks:java:extensions:sql:runBasicExample
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-jdk14/1.7.30/d35953dd2fe54ebe39fdf18cfd82fe6eb35b25ed/slf4j-jdk14-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-reload4j/1.7.36/db708f7d959dee1857ac524636e85ecf2e1781c1/slf4j-reload4j-1.7.36.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-log4j12/1.7.30/c21f55139d8141d2231214fb1feaf50a1edca95e/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.JDK14LoggerFactory]
Feb 21, 2023 4:40:02 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `PCOLLECTION`.`c1`, `PCOLLECTION`.`c2`, `PCOLLECTION`.`c3`
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`
WHERE `PCOLLECTION`.`c1` > 1
Feb 21, 2023 4:40:03 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(c1=[$0], c2=[$1], c3=[$2])
  LogicalFilter(condition=[>($0, 1)])
    BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 21, 2023 4:40:03 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..2=[{inputs}], expr#3=[1], expr#4=[>($t0, $t3)], proj#0..2=[{exprs}], $condition=[$t4])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 21, 2023 4:40:03 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `CASE1_RESULT`.`c2`, SUM(`CASE1_RESULT`.`c3`)
FROM `beam`.`CASE1_RESULT` AS `CASE1_RESULT`
GROUP BY `CASE1_RESULT`.`c2`
Feb 21, 2023 4:40:03 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalAggregate(group=[{0}], EXPR$1=[SUM($1)])
  LogicalProject(c2=[$1], c3=[$2])
    BeamIOSourceRel(table=[[beam, CASE1_RESULT]])

Feb 21, 2023 4:40:04 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamAggregationRel(group=[{1}], EXPR$1=[SUM($2)])
  BeamIOSourceRel(table=[[beam, CASE1_RESULT]])

Feb 21, 2023 4:40:04 PM org.apache.beam.sdk.Pipeline validate
WARNING: The following transforms do not have stable unique names: log_result, SqlTransform
PCOLLECTION: [2, row, 2.0]
PCOLLECTION: [3, row, 3.0]
CASE1_RESULT: [row, 5.0]

> Task :sdks:java:extensions:sql:runPojoExample
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-jdk14/1.7.30/d35953dd2fe54ebe39fdf18cfd82fe6eb35b25ed/slf4j-jdk14-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-reload4j/1.7.36/db708f7d959dee1857ac524636e85ecf2e1781c1/slf4j-reload4j-1.7.36.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-log4j12/1.7.30/c21f55139d8141d2231214fb1feaf50a1edca95e/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.JDK14LoggerFactory]

> Task :sdks:java:extensions:sql:shell:distZip

> Task :sdks:java:extensions:sql:runPojoExample
Feb 21, 2023 4:40:12 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `PCOLLECTION`.`id`, `PCOLLECTION`.`name`
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`
WHERE `PCOLLECTION`.`countryOfResidence` = 'Wonderland'
Feb 21, 2023 4:40:13 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(id=[$1], name=[$0])
  LogicalFilter(condition=[=($2, 'Wonderland')])
    BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 21, 2023 4:40:13 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..2=[{inputs}], expr#3=['Wonderland':VARCHAR], expr#4=[=($t2, $t3)], id=[$t1], name=[$t0], $condition=[$t4])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 21, 2023 4:40:13 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT COUNT(`PCOLLECTION`.`id`)
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`
Feb 21, 2023 4:40:13 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalAggregate(group=[{}], EXPR$0=[COUNT()])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 21, 2023 4:40:13 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamAggregationRel(group=[{}], EXPR$0=[COUNT()])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 21, 2023 4:40:13 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `customers`.`name`, 'order id:' || CAST(`orders`.`id` AS VARCHAR)
FROM `beam`.`orders` AS `orders`
INNER JOIN `beam`.`customers` AS `customers` ON `orders`.`customerId` = `customers`.`id`
WHERE `customers`.`name` = 'Grault'
Feb 21, 2023 4:40:14 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(name=[$2], EXPR$1=[||('order id:', CAST($0):VARCHAR NOT NULL)])
  LogicalFilter(condition=[=($2, 'Grault')])
    LogicalJoin(condition=[=($1, $3)], joinType=[inner])
      BeamIOSourceRel(table=[[beam, orders]])
      BeamIOSourceRel(table=[[beam, customers]])

Feb 21, 2023 4:40:14 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..4=[{inputs}], expr#5=['order id:'], expr#6=[CAST($t0):VARCHAR NOT NULL], expr#7=[||($t5, $t6)], name=[$t2], EXPR$1=[$t7])
  BeamCoGBKJoinRel(condition=[=($1, $3)], joinType=[inner])
    BeamIOSourceRel(table=[[beam, orders]])
    BeamCalcRel(expr#0..2=[{inputs}], expr#3=['Grault':VARCHAR], expr#4=[=($t0, $t3)], proj#0..2=[{exprs}], $condition=[$t4])
      BeamIOSourceRel(table=[[beam, customers]])

Feb 21, 2023 4:40:14 PM org.apache.beam.sdk.Pipeline validate
WARNING: The following transforms do not have stable unique names: Create.Values, MapElements, SqlTransform
[1, Foo]: is from Wonderland
[4, Grault]: is from Wonderland
[3, Baz]: is from Wonderland
[3]: total customers in Wonderland
[Grault, order id:8]: ordered by 'Grault'
[Grault, order id:7]: ordered by 'Grault'

> Task :sdks:java:extensions:sql:shell:assemble
> Task :sdks:java:extensions:sql:shell:analyzeClassesDependencies FROM-CACHE
> Task :sdks:java:extensions:sql:shell:analyzeDependencies UP-TO-DATE
> Task :sdks:java:extensions:sql:shell:test NO-SOURCE
> Task :sdks:java:extensions:sql:shell:check UP-TO-DATE
> Task :sdks:java:extensions:sql:shell:build
> Task :sdks:java:extensions:sql:shell:buildDependents
> Task :runners:flink:1.12:job-server:shadowJar
> Task :runners:flink:1.12:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.13:job-server:shadowJar
> Task :runners:flink:1.13:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.14:job-server:shadowJar
> Task :runners:flink:1.15:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.14:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.12:job-server:startShadowScripts
> Task :runners:flink:1.12:job-server:shadowDistTar
> Task :runners:flink:1.13:job-server:startShadowScripts
> Task :runners:flink:1.13:job-server:shadowDistTar
> Task :runners:flink:1.15:job-server:startShadowScripts
> Task :runners:flink:1.14:job-server:startShadowScripts
> Task :runners:flink:1.15:job-server:shadowDistTar
> Task :runners:flink:1.14:job-server:shadowDistTar
> Task :runners:flink:1.12:job-server:shadowDistZip
> Task :runners:flink:1.12:job-server:assemble
> Task :runners:flink:1.12:job-server:test NO-SOURCE
> Task :runners:flink:1.12:job-server:check UP-TO-DATE
> Task :runners:flink:1.12:job-server:build
> Task :runners:flink:1.12:job-server:buildDependents
> Task :runners:flink:1.13:job-server:shadowDistZip
> Task :runners:flink:1.13:job-server:assemble
> Task :runners:flink:1.13:job-server:test NO-SOURCE
> Task :runners:flink:1.13:job-server:check UP-TO-DATE
> Task :runners:flink:1.13:job-server:build
> Task :runners:flink:1.13:job-server:buildDependents
> Task :runners:flink:1.15:job-server:shadowDistZip
> Task :runners:flink:1.14:job-server:shadowDistZip
> Task :runners:flink:1.15:job-server:assemble
> Task :runners:flink:1.15:job-server:test NO-SOURCE
> Task :runners:flink:1.15:job-server:check UP-TO-DATE
> Task :runners:flink:1.15:job-server:build
> Task :runners:flink:1.15:job-server:buildDependents
> Task :runners:flink:1.14:job-server:assemble
> Task :runners:flink:1.14:job-server:test NO-SOURCE
> Task :runners:flink:1.14:job-server:check UP-TO-DATE
> Task :runners:flink:1.14:job-server:build
> Task :runners:flink:1.14:job-server:buildDependents
> Task :sdks:java:extensions:sql:expansion-service:buildDependents

FAILURE: Build completed with 4 failures.

1: Task failed with an exception.
-----------
* What went wrong:
Execution failed for task ':sdks:java:extensions:sql:jdbc:test'.
> There were failing tests. See the report at: file://<https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/ws/src/sdks/java/extensions/sql/jdbc/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.
==============================================================================

2: Task failed with an exception.
-----------
* What went wrong:
Execution failed for task ':sdks:java:extensions:sql:zetasql:test'.
> There were failing tests. See the report at: file://<https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/ws/src/sdks/java/extensions/sql/zetasql/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.
==============================================================================

3: Task failed with an exception.
-----------
* What went wrong:
Execution failed for task ':sdks:java:testing:nexmark:test'.
> There were failing tests. See the report at: file://<https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/ws/src/sdks/java/testing/nexmark/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.
==============================================================================

4: Task failed with an exception.
-----------
* What went wrong:
Execution failed for task ':sdks:java:extensions:sql:test'.
> There were failing tests. See the report at: file://<https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/ws/src/sdks/java/extensions/sql/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.
==============================================================================

* 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.5.1/userguide/command_line_interface.html#sec:command_line_warnings

BUILD FAILED in 4m 6s
256 actionable tasks: 139 executed, 117 from cache

Publishing build scan...
https://gradle.com/s/2a5ot5ib7udg2

Build step 'Invoke Gradle script' changed build result to FAILURE
Build step 'Invoke Gradle script' marked build as failure

---------------------------------------------------------------------
To unsubscribe, e-mail: builds-unsubscribe@beam.apache.org
For additional commands, e-mail: builds-help@beam.apache.org

Build failed in Jenkins: beam_PreCommit_SQL_Java11_Cron #3991

Posted by Apache Jenkins Server <je...@builds.apache.org>.
See <https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/3991/display/redirect>

Changes:


------------------------------------------
[...truncated 304.31 KB...]

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testLines FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:205

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testJson FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:224

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testWriteCsv FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:282

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testWriteJson FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:301

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testExplicitCsv FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:152

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testExplicitCsvExcel FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:180

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testLegacyTdfCsv FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:127

715 tests completed, 455 failed, 8 skipped

> Task :sdks:java:extensions:sql:runBasicExample
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-jdk14/1.7.30/d35953dd2fe54ebe39fdf18cfd82fe6eb35b25ed/slf4j-jdk14-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-reload4j/1.7.36/db708f7d959dee1857ac524636e85ecf2e1781c1/slf4j-reload4j-1.7.36.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-log4j12/1.7.30/c21f55139d8141d2231214fb1feaf50a1edca95e/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.JDK14LoggerFactory]

> Task :runners:flink:1.15:job-server:distZip

> Task :sdks:java:extensions:sql:runBasicExample
Feb 21, 2023 10:39:18 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `PCOLLECTION`.`c1`, `PCOLLECTION`.`c2`, `PCOLLECTION`.`c3`
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`
WHERE `PCOLLECTION`.`c1` > 1
Feb 21, 2023 10:39:18 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(c1=[$0], c2=[$1], c3=[$2])
  LogicalFilter(condition=[>($0, 1)])
    BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 21, 2023 10:39:19 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..2=[{inputs}], expr#3=[1], expr#4=[>($t0, $t3)], proj#0..2=[{exprs}], $condition=[$t4])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 21, 2023 10:39:19 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `CASE1_RESULT`.`c2`, SUM(`CASE1_RESULT`.`c3`)
FROM `beam`.`CASE1_RESULT` AS `CASE1_RESULT`
GROUP BY `CASE1_RESULT`.`c2`
Feb 21, 2023 10:39:19 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalAggregate(group=[{0}], EXPR$1=[SUM($1)])
  LogicalProject(c2=[$1], c3=[$2])
    BeamIOSourceRel(table=[[beam, CASE1_RESULT]])

Feb 21, 2023 10:39:19 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamAggregationRel(group=[{1}], EXPR$1=[SUM($2)])
  BeamIOSourceRel(table=[[beam, CASE1_RESULT]])

Feb 21, 2023 10:39:19 AM org.apache.beam.sdk.Pipeline validate
WARNING: The following transforms do not have stable unique names: log_result, SqlTransform
PCOLLECTION: [3, row, 3.0]
PCOLLECTION: [2, row, 2.0]
CASE1_RESULT: [row, 5.0]

> Task :sdks:java:extensions:sql:runPojoExample
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-jdk14/1.7.30/d35953dd2fe54ebe39fdf18cfd82fe6eb35b25ed/slf4j-jdk14-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-reload4j/1.7.36/db708f7d959dee1857ac524636e85ecf2e1781c1/slf4j-reload4j-1.7.36.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-log4j12/1.7.30/c21f55139d8141d2231214fb1feaf50a1edca95e/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.JDK14LoggerFactory]
Feb 21, 2023 10:39:26 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `PCOLLECTION`.`id`, `PCOLLECTION`.`name`
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`
WHERE `PCOLLECTION`.`countryOfResidence` = 'Wonderland'
Feb 21, 2023 10:39:27 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(id=[$1], name=[$0])
  LogicalFilter(condition=[=($2, 'Wonderland')])
    BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 21, 2023 10:39:27 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..2=[{inputs}], expr#3=['Wonderland':VARCHAR], expr#4=[=($t2, $t3)], id=[$t1], name=[$t0], $condition=[$t4])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 21, 2023 10:39:27 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT COUNT(`PCOLLECTION`.`id`)
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`
Feb 21, 2023 10:39:27 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalAggregate(group=[{}], EXPR$0=[COUNT()])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 21, 2023 10:39:27 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamAggregationRel(group=[{}], EXPR$0=[COUNT()])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 21, 2023 10:39:27 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `customers`.`name`, 'order id:' || CAST(`orders`.`id` AS VARCHAR)
FROM `beam`.`orders` AS `orders`
INNER JOIN `beam`.`customers` AS `customers` ON `orders`.`customerId` = `customers`.`id`
WHERE `customers`.`name` = 'Grault'
Feb 21, 2023 10:39:27 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(name=[$2], EXPR$1=[||('order id:', CAST($0):VARCHAR NOT NULL)])
  LogicalFilter(condition=[=($2, 'Grault')])
    LogicalJoin(condition=[=($1, $3)], joinType=[inner])
      BeamIOSourceRel(table=[[beam, orders]])
      BeamIOSourceRel(table=[[beam, customers]])

Feb 21, 2023 10:39:28 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..4=[{inputs}], expr#5=['order id:'], expr#6=[CAST($t0):VARCHAR NOT NULL], expr#7=[||($t5, $t6)], name=[$t2], EXPR$1=[$t7])
  BeamCoGBKJoinRel(condition=[=($1, $3)], joinType=[inner])
    BeamIOSourceRel(table=[[beam, orders]])
    BeamCalcRel(expr#0..2=[{inputs}], expr#3=['Grault':VARCHAR], expr#4=[=($t0, $t3)], proj#0..2=[{exprs}], $condition=[$t4])
      BeamIOSourceRel(table=[[beam, customers]])

Feb 21, 2023 10:39:28 AM org.apache.beam.sdk.Pipeline validate
WARNING: The following transforms do not have stable unique names: Create.Values, MapElements, SqlTransform
[1, Foo]: is from Wonderland
[4, Grault]: is from Wonderland
[3, Baz]: is from Wonderland
[3]: total customers in Wonderland
[Grault, order id:7]: ordered by 'Grault'
[Grault, order id:8]: ordered by 'Grault'

> Task :sdks:java:extensions:sql:shell:distZip
> Task :sdks:java:extensions:sql:shell:assemble
> Task :sdks:java:extensions:sql:shell:analyzeClassesDependencies FROM-CACHE
> Task :sdks:java:extensions:sql:shell:analyzeDependencies UP-TO-DATE
> Task :sdks:java:extensions:sql:shell:test NO-SOURCE
> Task :sdks:java:extensions:sql:shell:check UP-TO-DATE
> Task :sdks:java:extensions:sql:shell:build
> Task :sdks:java:extensions:sql:shell:buildDependents
> Task :runners:flink:1.13:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.12:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.14:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.15:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.13:job-server:startShadowScripts
> Task :runners:flink:1.12:job-server:startShadowScripts
> Task :runners:flink:1.13:job-server:shadowDistTar
> Task :runners:flink:1.12:job-server:shadowDistTar
> Task :runners:flink:1.14:job-server:startShadowScripts
> Task :runners:flink:1.15:job-server:startShadowScripts
> Task :runners:flink:1.14:job-server:shadowDistTar
> Task :runners:flink:1.15:job-server:shadowDistTar
> Task :runners:flink:1.13:job-server:shadowDistZip
> Task :runners:flink:1.13:job-server:assemble
> Task :runners:flink:1.13:job-server:test NO-SOURCE
> Task :runners:flink:1.13:job-server:check UP-TO-DATE
> Task :runners:flink:1.13:job-server:build
> Task :runners:flink:1.13:job-server:buildDependents
> Task :runners:flink:1.12:job-server:shadowDistZip
> Task :runners:flink:1.12:job-server:assemble
> Task :runners:flink:1.12:job-server:test NO-SOURCE
> Task :runners:flink:1.12:job-server:check UP-TO-DATE
> Task :runners:flink:1.12:job-server:build
> Task :runners:flink:1.12:job-server:buildDependents
> Task :runners:flink:1.14:job-server:shadowDistZip
> Task :runners:flink:1.15:job-server:shadowDistZip
> Task :runners:flink:1.15:job-server:assemble
> Task :runners:flink:1.15:job-server:test NO-SOURCE
> Task :runners:flink:1.15:job-server:check UP-TO-DATE
> Task :runners:flink:1.15:job-server:build
> Task :runners:flink:1.15:job-server:buildDependents
> Task :runners:flink:1.14:job-server:assemble
> Task :runners:flink:1.14:job-server:test NO-SOURCE
> Task :runners:flink:1.14:job-server:check UP-TO-DATE
> Task :runners:flink:1.14:job-server:build
> Task :runners:flink:1.14:job-server:buildDependents
> Task :sdks:java:extensions:sql:expansion-service:buildDependents

FAILURE: Build completed with 4 failures.

1: Task failed with an exception.
-----------
* What went wrong:
Execution failed for task ':sdks:java:extensions:sql:jdbc:test'.
> There were failing tests. See the report at: file://<https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/ws/src/sdks/java/extensions/sql/jdbc/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.
==============================================================================

2: Task failed with an exception.
-----------
* What went wrong:
Execution failed for task ':sdks:java:testing:nexmark:test'.
> There were failing tests. See the report at: file://<https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/ws/src/sdks/java/testing/nexmark/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.
==============================================================================

3: Task failed with an exception.
-----------
* What went wrong:
Execution failed for task ':sdks:java:extensions:sql:zetasql:test'.
> There were failing tests. See the report at: file://<https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/ws/src/sdks/java/extensions/sql/zetasql/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.
==============================================================================

4: Task failed with an exception.
-----------
* What went wrong:
Execution failed for task ':sdks:java:extensions:sql:test'.
> There were failing tests. See the report at: file://<https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/ws/src/sdks/java/extensions/sql/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.
==============================================================================

* 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.5.1/userguide/command_line_interface.html#sec:command_line_warnings

BUILD FAILED in 3m 2s
256 actionable tasks: 139 executed, 117 from cache

Publishing build scan...
https://gradle.com/s/5i4iwe3ccdeam

Build step 'Invoke Gradle script' changed build result to FAILURE
Build step 'Invoke Gradle script' marked build as failure

---------------------------------------------------------------------
To unsubscribe, e-mail: builds-unsubscribe@beam.apache.org
For additional commands, e-mail: builds-help@beam.apache.org

Build failed in Jenkins: beam_PreCommit_SQL_Java11_Cron #3990

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

Changes:

[noreply] [prism] Add in element manager (#25565)


------------------------------------------
[...truncated 304.19 KB...]
    java.lang.IllegalArgumentException at TestTableProviderWithFilterAndProjectPushDown.java:261

org.apache.beam.sdk.extensions.sql.meta.provider.test.TestTableProviderWithFilterPushDown > testIOSourceRel_withSupportedFilter_selectInRandomOrder FAILED
    java.lang.IllegalArgumentException at TestTableProviderWithFilterPushDown.java:144

org.apache.beam.sdk.extensions.sql.meta.provider.test.TestTableProviderWithFilterPushDown > testIOSourceRel_selectAll_withSupportedFilter_shouldDropCalc FAILED
    java.lang.IllegalArgumentException at TestTableProviderWithFilterPushDown.java:123

org.apache.beam.sdk.extensions.sql.meta.provider.test.TestTableProviderWithFilterPushDown > testIOSourceRel_withFilter_shouldProjectAllFields FAILED
    java.lang.IllegalArgumentException at TestTableProviderWithFilterPushDown.java:101

org.apache.beam.sdk.extensions.sql.meta.provider.test.TestTableProviderWithFilterPushDown > testIOSourceRel_selectAllFieldsInRandomOrder_shouldPushDownSupportedFilter FAILED
    java.lang.IllegalArgumentException at TestTableProviderWithFilterPushDown.java:194

org.apache.beam.sdk.extensions.sql.meta.provider.test.TestTableProviderWithFilterPushDown > testIOSourceRel_selectOneFieldsMoreThanOnce_withSupportedPredicate FAILED
    java.lang.IllegalArgumentException at TestTableProviderWithFilterPushDown.java:261

org.apache.beam.sdk.extensions.sql.meta.provider.test.TestTableProviderWithFilterPushDown > testIOSourceRel_selectOneFieldsMoreThanOnce FAILED
    java.lang.IllegalArgumentException at TestTableProviderWithFilterPushDown.java:226

org.apache.beam.sdk.extensions.sql.meta.provider.test.TestTableProviderWithFilterPushDown > testIOSourceRel_withUnsupportedFilter_calcPreservesCondition FAILED
    java.lang.IllegalArgumentException at TestTableProviderWithFilterPushDown.java:172

org.apache.beam.sdk.extensions.sql.meta.provider.test.TestTableProviderWithProjectPushDown > testIOSourceRel_withPredicate FAILED
    java.lang.IllegalArgumentException at TestTableProviderWithProjectPushDown.java:134

org.apache.beam.sdk.extensions.sql.meta.provider.test.TestTableProviderWithProjectPushDown > testIOSourceRel_withNoPredicate FAILED
    java.lang.IllegalArgumentException at TestTableProviderWithProjectPushDown.java:97

org.apache.beam.sdk.extensions.sql.meta.provider.test.TestTableProviderWithProjectPushDown > testIOSourceRel_withPredicate_withRename FAILED
    java.lang.IllegalArgumentException at TestTableProviderWithProjectPushDown.java:152

org.apache.beam.sdk.extensions.sql.meta.provider.test.TestTableProviderWithProjectPushDown > testIOSourceRel_AllFields FAILED
    java.lang.IllegalArgumentException at TestTableProviderWithProjectPushDown.java:171

org.apache.beam.sdk.extensions.sql.meta.provider.test.TestTableProviderWithProjectPushDown > testIOSourceRel_withNoPredicate_withRename FAILED
    java.lang.IllegalArgumentException at TestTableProviderWithProjectPushDown.java:115

org.apache.beam.sdk.extensions.sql.meta.provider.test.TestTableProviderWithProjectPushDown > testIOSourceRel_selectOneFieldsMoreThanOnce_withSupportedPredicate FAILED
    java.lang.IllegalArgumentException at TestTableProviderWithProjectPushDown.java:224

org.apache.beam.sdk.extensions.sql.meta.provider.test.TestTableProviderWithProjectPushDown > testIOSourceRel_selectOneFieldsMoreThanOnce FAILED
    java.lang.IllegalArgumentException at TestTableProviderWithProjectPushDown.java:193

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testLegacyDefaultCsv FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:94

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testWriteLines FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:262

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testLines FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:205

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testJson FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:224

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testWriteCsv FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:282

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testWriteJson FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:301

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testExplicitCsv FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:152

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testExplicitCsvExcel FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:180

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testLegacyTdfCsv FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:127

715 tests completed, 455 failed, 8 skipped

> Task :sdks:java:extensions:sql:runPojoExample
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-jdk14/1.7.30/d35953dd2fe54ebe39fdf18cfd82fe6eb35b25ed/slf4j-jdk14-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-reload4j/1.7.36/db708f7d959dee1857ac524636e85ecf2e1781c1/slf4j-reload4j-1.7.36.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-log4j12/1.7.30/c21f55139d8141d2231214fb1feaf50a1edca95e/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.JDK14LoggerFactory]
Feb 21, 2023 4:39:20 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `PCOLLECTION`.`id`, `PCOLLECTION`.`name`
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`
WHERE `PCOLLECTION`.`countryOfResidence` = 'Wonderland'
Feb 21, 2023 4:39:20 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(id=[$1], name=[$0])
  LogicalFilter(condition=[=($2, 'Wonderland')])
    BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 21, 2023 4:39:21 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..2=[{inputs}], expr#3=['Wonderland':VARCHAR], expr#4=[=($t2, $t3)], id=[$t1], name=[$t0], $condition=[$t4])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 21, 2023 4:39:21 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT COUNT(`PCOLLECTION`.`id`)
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`
Feb 21, 2023 4:39:21 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalAggregate(group=[{}], EXPR$0=[COUNT()])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 21, 2023 4:39:21 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamAggregationRel(group=[{}], EXPR$0=[COUNT()])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 21, 2023 4:39:21 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `customers`.`name`, 'order id:' || CAST(`orders`.`id` AS VARCHAR)
FROM `beam`.`orders` AS `orders`
INNER JOIN `beam`.`customers` AS `customers` ON `orders`.`customerId` = `customers`.`id`
WHERE `customers`.`name` = 'Grault'
Feb 21, 2023 4:39:21 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(name=[$2], EXPR$1=[||('order id:', CAST($0):VARCHAR NOT NULL)])
  LogicalFilter(condition=[=($2, 'Grault')])
    LogicalJoin(condition=[=($1, $3)], joinType=[inner])
      BeamIOSourceRel(table=[[beam, orders]])
      BeamIOSourceRel(table=[[beam, customers]])

Feb 21, 2023 4:39:22 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..4=[{inputs}], expr#5=['order id:'], expr#6=[CAST($t0):VARCHAR NOT NULL], expr#7=[||($t5, $t6)], name=[$t2], EXPR$1=[$t7])
  BeamCoGBKJoinRel(condition=[=($1, $3)], joinType=[inner])
    BeamIOSourceRel(table=[[beam, orders]])
    BeamCalcRel(expr#0..2=[{inputs}], expr#3=['Grault':VARCHAR], expr#4=[=($t0, $t3)], proj#0..2=[{exprs}], $condition=[$t4])
      BeamIOSourceRel(table=[[beam, customers]])

Feb 21, 2023 4:39:22 AM org.apache.beam.sdk.Pipeline validate
WARNING: The following transforms do not have stable unique names: Create.Values, MapElements, SqlTransform
[4, Grault]: is from Wonderland
[3, Baz]: is from Wonderland
[1, Foo]: is from Wonderland
[3]: total customers in Wonderland
[Grault, order id:7]: ordered by 'Grault'
[Grault, order id:8]: ordered by 'Grault'

> Task :sdks:java:extensions:sql:shell:distZip
> Task :sdks:java:extensions:sql:shell:assemble
> Task :sdks:java:extensions:sql:shell:analyzeClassesDependencies FROM-CACHE
> Task :sdks:java:extensions:sql:shell:analyzeDependencies UP-TO-DATE
> Task :sdks:java:extensions:sql:shell:test NO-SOURCE
> Task :sdks:java:extensions:sql:shell:check UP-TO-DATE
> Task :sdks:java:extensions:sql:shell:build
> Task :sdks:java:extensions:sql:shell:buildDependents
> Task :runners:flink:1.12:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.13:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.14:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.15:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.12:job-server:startShadowScripts
> Task :runners:flink:1.13:job-server:startShadowScripts
> Task :runners:flink:1.12:job-server:shadowDistTar
> Task :runners:flink:1.13:job-server:shadowDistTar
> Task :runners:flink:1.14:job-server:startShadowScripts
> Task :runners:flink:1.15:job-server:startShadowScripts
> Task :runners:flink:1.14:job-server:shadowDistTar
> Task :runners:flink:1.15:job-server:shadowDistTar
> Task :runners:flink:1.12:job-server:shadowDistZip
> Task :runners:flink:1.12:job-server:assemble
> Task :runners:flink:1.12:job-server:test NO-SOURCE
> Task :runners:flink:1.12:job-server:check UP-TO-DATE
> Task :runners:flink:1.12:job-server:build
> Task :runners:flink:1.12:job-server:buildDependents
> Task :runners:flink:1.13:job-server:shadowDistZip
> Task :runners:flink:1.13:job-server:assemble
> Task :runners:flink:1.13:job-server:test NO-SOURCE
> Task :runners:flink:1.13:job-server:check UP-TO-DATE
> Task :runners:flink:1.13:job-server:build
> Task :runners:flink:1.13:job-server:buildDependents
> Task :runners:flink:1.14:job-server:shadowDistZip
> Task :runners:flink:1.14:job-server:assemble
> Task :runners:flink:1.14:job-server:test NO-SOURCE
> Task :runners:flink:1.14:job-server:check UP-TO-DATE
> Task :runners:flink:1.14:job-server:build
> Task :runners:flink:1.14:job-server:buildDependents
> Task :runners:flink:1.15:job-server:shadowDistZip
> Task :runners:flink:1.15:job-server:assemble
> Task :runners:flink:1.15:job-server:test NO-SOURCE
> Task :runners:flink:1.15:job-server:check UP-TO-DATE
> Task :runners:flink:1.15:job-server:build
> Task :runners:flink:1.15:job-server:buildDependents
> Task :sdks:java:extensions:sql:expansion-service:buildDependents

FAILURE: Build completed with 4 failures.

1: Task failed with an exception.
-----------
* What went wrong:
Execution failed for task ':sdks:java:extensions:sql:jdbc:test'.
> There were failing tests. See the report at: file://<https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/ws/src/sdks/java/extensions/sql/jdbc/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.
==============================================================================

2: Task failed with an exception.
-----------
* What went wrong:
Execution failed for task ':sdks:java:extensions:sql:zetasql:test'.
> There were failing tests. See the report at: file://<https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/ws/src/sdks/java/extensions/sql/zetasql/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.
==============================================================================

3: Task failed with an exception.
-----------
* What went wrong:
Execution failed for task ':sdks:java:testing:nexmark:test'.
> There were failing tests. See the report at: file://<https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/ws/src/sdks/java/testing/nexmark/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.
==============================================================================

4: Task failed with an exception.
-----------
* What went wrong:
Execution failed for task ':sdks:java:extensions:sql:test'.
> There were failing tests. See the report at: file://<https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/ws/src/sdks/java/extensions/sql/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.
==============================================================================

* 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.5.1/userguide/command_line_interface.html#sec:command_line_warnings

BUILD FAILED in 3m
256 actionable tasks: 139 executed, 117 from cache

Publishing build scan...
https://gradle.com/s/alnl4rpx4hmxu

Build step 'Invoke Gradle script' changed build result to FAILURE
Build step 'Invoke Gradle script' marked build as failure

---------------------------------------------------------------------
To unsubscribe, e-mail: builds-unsubscribe@beam.apache.org
For additional commands, e-mail: builds-help@beam.apache.org

Build failed in Jenkins: beam_PreCommit_SQL_Java11_Cron #3989

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

Changes:

[noreply] [#24789][prism] Add testdofns for later (#25557)

[noreply] [#24789][prism] Minimum required jobservices (#25556)

[noreply] [#24789][prism] Handlers for combine, ParDo, GBK, Flatten  (#25558)

[noreply] [prism] Tiny lint fixes (#25564)

[noreply] minor error handling fixes (#25555)


------------------------------------------
[...truncated 304.47 KB...]

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testLines FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:205

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testJson FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:224

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testWriteCsv FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:282

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testWriteJson FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:301

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testExplicitCsv FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:152

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testExplicitCsvExcel FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:180

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testLegacyTdfCsv FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:127

715 tests completed, 455 failed, 8 skipped

> Task :sdks:java:extensions:sql:runBasicExample
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-jdk14/1.7.30/d35953dd2fe54ebe39fdf18cfd82fe6eb35b25ed/slf4j-jdk14-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-reload4j/1.7.36/db708f7d959dee1857ac524636e85ecf2e1781c1/slf4j-reload4j-1.7.36.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-log4j12/1.7.30/c21f55139d8141d2231214fb1feaf50a1edca95e/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.JDK14LoggerFactory]

> Task :runners:flink:1.15:job-server:distZip

> Task :sdks:java:extensions:sql:runBasicExample
Feb 20, 2023 10:39:12 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `PCOLLECTION`.`c1`, `PCOLLECTION`.`c2`, `PCOLLECTION`.`c3`
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`
WHERE `PCOLLECTION`.`c1` > 1
Feb 20, 2023 10:39:12 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(c1=[$0], c2=[$1], c3=[$2])
  LogicalFilter(condition=[>($0, 1)])
    BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 20, 2023 10:39:12 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..2=[{inputs}], expr#3=[1], expr#4=[>($t0, $t3)], proj#0..2=[{exprs}], $condition=[$t4])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 20, 2023 10:39:13 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `CASE1_RESULT`.`c2`, SUM(`CASE1_RESULT`.`c3`)
FROM `beam`.`CASE1_RESULT` AS `CASE1_RESULT`
GROUP BY `CASE1_RESULT`.`c2`
Feb 20, 2023 10:39:13 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalAggregate(group=[{0}], EXPR$1=[SUM($1)])
  LogicalProject(c2=[$1], c3=[$2])
    BeamIOSourceRel(table=[[beam, CASE1_RESULT]])

Feb 20, 2023 10:39:13 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamAggregationRel(group=[{1}], EXPR$1=[SUM($2)])
  BeamIOSourceRel(table=[[beam, CASE1_RESULT]])

Feb 20, 2023 10:39:13 PM org.apache.beam.sdk.Pipeline validate
WARNING: The following transforms do not have stable unique names: log_result, SqlTransform
PCOLLECTION: [2, row, 2.0]
PCOLLECTION: [3, row, 3.0]
CASE1_RESULT: [row, 5.0]

> Task :sdks:java:extensions:sql:runPojoExample
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-jdk14/1.7.30/d35953dd2fe54ebe39fdf18cfd82fe6eb35b25ed/slf4j-jdk14-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-reload4j/1.7.36/db708f7d959dee1857ac524636e85ecf2e1781c1/slf4j-reload4j-1.7.36.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-log4j12/1.7.30/c21f55139d8141d2231214fb1feaf50a1edca95e/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.JDK14LoggerFactory]
Feb 20, 2023 10:39:20 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `PCOLLECTION`.`id`, `PCOLLECTION`.`name`
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`
WHERE `PCOLLECTION`.`countryOfResidence` = 'Wonderland'
Feb 20, 2023 10:39:21 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(id=[$1], name=[$0])
  LogicalFilter(condition=[=($2, 'Wonderland')])
    BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 20, 2023 10:39:21 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..2=[{inputs}], expr#3=['Wonderland':VARCHAR], expr#4=[=($t2, $t3)], id=[$t1], name=[$t0], $condition=[$t4])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 20, 2023 10:39:21 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT COUNT(`PCOLLECTION`.`id`)
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`
Feb 20, 2023 10:39:21 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalAggregate(group=[{}], EXPR$0=[COUNT()])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 20, 2023 10:39:21 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamAggregationRel(group=[{}], EXPR$0=[COUNT()])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 20, 2023 10:39:21 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `customers`.`name`, 'order id:' || CAST(`orders`.`id` AS VARCHAR)
FROM `beam`.`orders` AS `orders`
INNER JOIN `beam`.`customers` AS `customers` ON `orders`.`customerId` = `customers`.`id`
WHERE `customers`.`name` = 'Grault'
Feb 20, 2023 10:39:21 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(name=[$2], EXPR$1=[||('order id:', CAST($0):VARCHAR NOT NULL)])
  LogicalFilter(condition=[=($2, 'Grault')])
    LogicalJoin(condition=[=($1, $3)], joinType=[inner])
      BeamIOSourceRel(table=[[beam, orders]])
      BeamIOSourceRel(table=[[beam, customers]])

Feb 20, 2023 10:39:22 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..4=[{inputs}], expr#5=['order id:'], expr#6=[CAST($t0):VARCHAR NOT NULL], expr#7=[||($t5, $t6)], name=[$t2], EXPR$1=[$t7])
  BeamCoGBKJoinRel(condition=[=($1, $3)], joinType=[inner])
    BeamIOSourceRel(table=[[beam, orders]])
    BeamCalcRel(expr#0..2=[{inputs}], expr#3=['Grault':VARCHAR], expr#4=[=($t0, $t3)], proj#0..2=[{exprs}], $condition=[$t4])
      BeamIOSourceRel(table=[[beam, customers]])

Feb 20, 2023 10:39:22 PM org.apache.beam.sdk.Pipeline validate
WARNING: The following transforms do not have stable unique names: Create.Values, MapElements, SqlTransform
[1, Foo]: is from Wonderland
[3, Baz]: is from Wonderland
[4, Grault]: is from Wonderland
[3]: total customers in Wonderland
[Grault, order id:7]: ordered by 'Grault'
[Grault, order id:8]: ordered by 'Grault'

> Task :sdks:java:extensions:sql:shell:distZip
> Task :sdks:java:extensions:sql:shell:assemble
> Task :sdks:java:extensions:sql:shell:analyzeClassesDependencies FROM-CACHE
> Task :sdks:java:extensions:sql:shell:analyzeDependencies UP-TO-DATE
> Task :sdks:java:extensions:sql:shell:test NO-SOURCE
> Task :sdks:java:extensions:sql:shell:check UP-TO-DATE
> Task :sdks:java:extensions:sql:shell:build
> Task :sdks:java:extensions:sql:shell:buildDependents
> Task :runners:flink:1.13:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.12:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.14:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.15:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.13:job-server:startShadowScripts
> Task :runners:flink:1.12:job-server:startShadowScripts
> Task :runners:flink:1.13:job-server:shadowDistTar
> Task :runners:flink:1.12:job-server:shadowDistTar
> Task :runners:flink:1.14:job-server:startShadowScripts
> Task :runners:flink:1.15:job-server:startShadowScripts
> Task :runners:flink:1.14:job-server:shadowDistTar
> Task :runners:flink:1.15:job-server:shadowDistTar
> Task :runners:flink:1.13:job-server:shadowDistZip
> Task :runners:flink:1.13:job-server:assemble
> Task :runners:flink:1.13:job-server:test NO-SOURCE
> Task :runners:flink:1.13:job-server:check UP-TO-DATE
> Task :runners:flink:1.13:job-server:build
> Task :runners:flink:1.13:job-server:buildDependents
> Task :runners:flink:1.12:job-server:shadowDistZip
> Task :runners:flink:1.12:job-server:assemble
> Task :runners:flink:1.12:job-server:test NO-SOURCE
> Task :runners:flink:1.12:job-server:check UP-TO-DATE
> Task :runners:flink:1.12:job-server:build
> Task :runners:flink:1.12:job-server:buildDependents
> Task :runners:flink:1.15:job-server:shadowDistZip
> Task :runners:flink:1.15:job-server:assemble
> Task :runners:flink:1.15:job-server:test NO-SOURCE
> Task :runners:flink:1.15:job-server:check UP-TO-DATE
> Task :runners:flink:1.15:job-server:build
> Task :runners:flink:1.15:job-server:buildDependents
> Task :runners:flink:1.14:job-server:shadowDistZip
> Task :runners:flink:1.14:job-server:assemble
> Task :runners:flink:1.14:job-server:test NO-SOURCE
> Task :runners:flink:1.14:job-server:check UP-TO-DATE
> Task :runners:flink:1.14:job-server:build
> Task :runners:flink:1.14:job-server:buildDependents
> Task :sdks:java:extensions:sql:expansion-service:buildDependents

FAILURE: Build completed with 4 failures.

1: Task failed with an exception.
-----------
* What went wrong:
Execution failed for task ':sdks:java:extensions:sql:jdbc:test'.
> There were failing tests. See the report at: file://<https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/ws/src/sdks/java/extensions/sql/jdbc/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.
==============================================================================

2: Task failed with an exception.
-----------
* What went wrong:
Execution failed for task ':sdks:java:extensions:sql:zetasql:test'.
> There were failing tests. See the report at: file://<https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/ws/src/sdks/java/extensions/sql/zetasql/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.
==============================================================================

3: Task failed with an exception.
-----------
* What went wrong:
Execution failed for task ':sdks:java:testing:nexmark:test'.
> There were failing tests. See the report at: file://<https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/ws/src/sdks/java/testing/nexmark/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.
==============================================================================

4: Task failed with an exception.
-----------
* What went wrong:
Execution failed for task ':sdks:java:extensions:sql:test'.
> There were failing tests. See the report at: file://<https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/ws/src/sdks/java/extensions/sql/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.
==============================================================================

* 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.5.1/userguide/command_line_interface.html#sec:command_line_warnings

BUILD FAILED in 3m
256 actionable tasks: 139 executed, 117 from cache

Publishing build scan...
https://gradle.com/s/ccwbmhktgnyzc

Build step 'Invoke Gradle script' changed build result to FAILURE
Build step 'Invoke Gradle script' marked build as failure

---------------------------------------------------------------------
To unsubscribe, e-mail: builds-unsubscribe@beam.apache.org
For additional commands, e-mail: builds-help@beam.apache.org

Build failed in Jenkins: beam_PreCommit_SQL_Java11_Cron #3988

Posted by Apache Jenkins Server <je...@builds.apache.org>.
See <https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/3988/display/redirect>

Changes:


------------------------------------------
[...truncated 303.92 KB...]

org.apache.beam.sdk.extensions.sql.meta.provider.test.TestTableProviderWithFilterPushDown > testIOSourceRel_withFilter_shouldProjectAllFields FAILED
    java.lang.IllegalArgumentException at TestTableProviderWithFilterPushDown.java:101

org.apache.beam.sdk.extensions.sql.meta.provider.test.TestTableProviderWithFilterPushDown > testIOSourceRel_selectAllFieldsInRandomOrder_shouldPushDownSupportedFilter FAILED
    java.lang.IllegalArgumentException at TestTableProviderWithFilterPushDown.java:194

org.apache.beam.sdk.extensions.sql.meta.provider.test.TestTableProviderWithFilterPushDown > testIOSourceRel_selectOneFieldsMoreThanOnce_withSupportedPredicate FAILED
    java.lang.IllegalArgumentException at TestTableProviderWithFilterPushDown.java:261

org.apache.beam.sdk.extensions.sql.meta.provider.test.TestTableProviderWithFilterPushDown > testIOSourceRel_selectOneFieldsMoreThanOnce FAILED
    java.lang.IllegalArgumentException at TestTableProviderWithFilterPushDown.java:226

org.apache.beam.sdk.extensions.sql.meta.provider.test.TestTableProviderWithFilterPushDown > testIOSourceRel_withUnsupportedFilter_calcPreservesCondition FAILED
    java.lang.IllegalArgumentException at TestTableProviderWithFilterPushDown.java:172

org.apache.beam.sdk.extensions.sql.meta.provider.test.TestTableProviderWithProjectPushDown > testIOSourceRel_withPredicate FAILED
    java.lang.IllegalArgumentException at TestTableProviderWithProjectPushDown.java:134

org.apache.beam.sdk.extensions.sql.meta.provider.test.TestTableProviderWithProjectPushDown > testIOSourceRel_withNoPredicate FAILED
    java.lang.IllegalArgumentException at TestTableProviderWithProjectPushDown.java:97

org.apache.beam.sdk.extensions.sql.meta.provider.test.TestTableProviderWithProjectPushDown > testIOSourceRel_withPredicate_withRename FAILED
    java.lang.IllegalArgumentException at TestTableProviderWithProjectPushDown.java:152

org.apache.beam.sdk.extensions.sql.meta.provider.test.TestTableProviderWithProjectPushDown > testIOSourceRel_AllFields FAILED
    java.lang.IllegalArgumentException at TestTableProviderWithProjectPushDown.java:171

org.apache.beam.sdk.extensions.sql.meta.provider.test.TestTableProviderWithProjectPushDown > testIOSourceRel_withNoPredicate_withRename FAILED
    java.lang.IllegalArgumentException at TestTableProviderWithProjectPushDown.java:115

org.apache.beam.sdk.extensions.sql.meta.provider.test.TestTableProviderWithProjectPushDown > testIOSourceRel_selectOneFieldsMoreThanOnce_withSupportedPredicate FAILED
    java.lang.IllegalArgumentException at TestTableProviderWithProjectPushDown.java:224

org.apache.beam.sdk.extensions.sql.meta.provider.test.TestTableProviderWithProjectPushDown > testIOSourceRel_selectOneFieldsMoreThanOnce FAILED
    java.lang.IllegalArgumentException at TestTableProviderWithProjectPushDown.java:193

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testLegacyDefaultCsv FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:94

> Task :runners:flink:1.12:job-server:distZip
> Task :runners:flink:1.13:job-server:distZip
> Task :runners:flink:1.15:job-server:distZip
> Task :runners:flink:1.14:job-server:distZip

> Task :sdks:java:extensions:sql:test FAILED

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testWriteLines FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:262

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testLines FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:205

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testJson FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:224

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testWriteCsv FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:282

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testWriteJson FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:301

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testExplicitCsv FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:152

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testExplicitCsvExcel FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:180

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testLegacyTdfCsv FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:127

715 tests completed, 455 failed, 8 skipped

> Task :sdks:java:extensions:sql:runPojoExample
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-jdk14/1.7.30/d35953dd2fe54ebe39fdf18cfd82fe6eb35b25ed/slf4j-jdk14-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-reload4j/1.7.36/db708f7d959dee1857ac524636e85ecf2e1781c1/slf4j-reload4j-1.7.36.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-log4j12/1.7.30/c21f55139d8141d2231214fb1feaf50a1edca95e/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.JDK14LoggerFactory]
Feb 20, 2023 4:39:58 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `PCOLLECTION`.`id`, `PCOLLECTION`.`name`
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`
WHERE `PCOLLECTION`.`countryOfResidence` = 'Wonderland'
Feb 20, 2023 4:39:58 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(id=[$2], name=[$1])
  LogicalFilter(condition=[=($0, 'Wonderland')])
    BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 20, 2023 4:39:58 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..2=[{inputs}], expr#3=['Wonderland':VARCHAR], expr#4=[=($t0, $t3)], id=[$t2], name=[$t1], $condition=[$t4])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 20, 2023 4:39:59 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT COUNT(`PCOLLECTION`.`id`)
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`
Feb 20, 2023 4:39:59 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalAggregate(group=[{}], EXPR$0=[COUNT()])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 20, 2023 4:39:59 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamAggregationRel(group=[{}], EXPR$0=[COUNT()])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 20, 2023 4:39:59 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `customers`.`name`, 'order id:' || CAST(`orders`.`id` AS VARCHAR)
FROM `beam`.`orders` AS `orders`
INNER JOIN `beam`.`customers` AS `customers` ON `orders`.`customerId` = `customers`.`id`
WHERE `customers`.`name` = 'Grault'
Feb 20, 2023 4:39:59 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(name=[$3], EXPR$1=[||('order id:', CAST($1):VARCHAR NOT NULL)])
  LogicalFilter(condition=[=($3, 'Grault')])
    LogicalJoin(condition=[=($0, $4)], joinType=[inner])
      BeamIOSourceRel(table=[[beam, orders]])
      BeamIOSourceRel(table=[[beam, customers]])

Feb 20, 2023 4:39:59 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..4=[{inputs}], expr#5=['order id:'], expr#6=[CAST($t1):VARCHAR NOT NULL], expr#7=[||($t5, $t6)], name=[$t3], EXPR$1=[$t7])
  BeamCoGBKJoinRel(condition=[=($0, $4)], joinType=[inner])
    BeamIOSourceRel(table=[[beam, orders]])
    BeamCalcRel(expr#0..2=[{inputs}], expr#3=['Grault':VARCHAR], expr#4=[=($t1, $t3)], proj#0..2=[{exprs}], $condition=[$t4])
      BeamIOSourceRel(table=[[beam, customers]])

Feb 20, 2023 4:40:00 PM org.apache.beam.sdk.Pipeline validate
WARNING: The following transforms do not have stable unique names: Create.Values, MapElements, SqlTransform
[4, Grault]: is from Wonderland
[1, Foo]: is from Wonderland
[3, Baz]: is from Wonderland
[3]: total customers in Wonderland
[Grault, order id:8]: ordered by 'Grault'
[Grault, order id:7]: ordered by 'Grault'

> Task :sdks:java:extensions:sql:shell:distZip
> Task :sdks:java:extensions:sql:shell:assemble
> Task :sdks:java:extensions:sql:shell:analyzeClassesDependencies FROM-CACHE
> Task :sdks:java:extensions:sql:shell:analyzeDependencies UP-TO-DATE
> Task :sdks:java:extensions:sql:shell:test NO-SOURCE
> Task :sdks:java:extensions:sql:shell:check UP-TO-DATE
> Task :sdks:java:extensions:sql:shell:build
> Task :sdks:java:extensions:sql:shell:buildDependents
> Task :runners:flink:1.12:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.13:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.15:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.14:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.12:job-server:startShadowScripts
> Task :runners:flink:1.13:job-server:startShadowScripts
> Task :runners:flink:1.12:job-server:shadowDistTar
> Task :runners:flink:1.13:job-server:shadowDistTar
> Task :runners:flink:1.15:job-server:startShadowScripts
> Task :runners:flink:1.14:job-server:startShadowScripts
> Task :runners:flink:1.15:job-server:shadowDistTar
> Task :runners:flink:1.14:job-server:shadowDistTar
> Task :runners:flink:1.12:job-server:shadowDistZip
> Task :runners:flink:1.12:job-server:assemble
> Task :runners:flink:1.12:job-server:test NO-SOURCE
> Task :runners:flink:1.12:job-server:check UP-TO-DATE
> Task :runners:flink:1.12:job-server:build
> Task :runners:flink:1.12:job-server:buildDependents
> Task :runners:flink:1.13:job-server:shadowDistZip
> Task :runners:flink:1.13:job-server:assemble
> Task :runners:flink:1.13:job-server:test NO-SOURCE
> Task :runners:flink:1.13:job-server:check UP-TO-DATE
> Task :runners:flink:1.13:job-server:build
> Task :runners:flink:1.13:job-server:buildDependents
> Task :runners:flink:1.15:job-server:shadowDistZip
> Task :runners:flink:1.15:job-server:assemble
> Task :runners:flink:1.15:job-server:test NO-SOURCE
> Task :runners:flink:1.15:job-server:check UP-TO-DATE
> Task :runners:flink:1.15:job-server:build
> Task :runners:flink:1.15:job-server:buildDependents
> Task :runners:flink:1.14:job-server:shadowDistZip
> Task :runners:flink:1.14:job-server:assemble
> Task :runners:flink:1.14:job-server:test NO-SOURCE
> Task :runners:flink:1.14:job-server:check UP-TO-DATE
> Task :runners:flink:1.14:job-server:build
> Task :runners:flink:1.14:job-server:buildDependents
> Task :sdks:java:extensions:sql:expansion-service:buildDependents

FAILURE: Build completed with 4 failures.

1: Task failed with an exception.
-----------
* What went wrong:
Execution failed for task ':sdks:java:extensions:sql:jdbc:test'.
> There were failing tests. See the report at: file://<https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/ws/src/sdks/java/extensions/sql/jdbc/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.
==============================================================================

2: Task failed with an exception.
-----------
* What went wrong:
Execution failed for task ':sdks:java:extensions:sql:zetasql:test'.
> There were failing tests. See the report at: file://<https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/ws/src/sdks/java/extensions/sql/zetasql/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.
==============================================================================

3: Task failed with an exception.
-----------
* What went wrong:
Execution failed for task ':sdks:java:testing:nexmark:test'.
> There were failing tests. See the report at: file://<https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/ws/src/sdks/java/testing/nexmark/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.
==============================================================================

4: Task failed with an exception.
-----------
* What went wrong:
Execution failed for task ':sdks:java:extensions:sql:test'.
> There were failing tests. See the report at: file://<https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/ws/src/sdks/java/extensions/sql/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.
==============================================================================

* 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.5.1/userguide/command_line_interface.html#sec:command_line_warnings

BUILD FAILED in 3m 59s
256 actionable tasks: 139 executed, 117 from cache

Publishing build scan...
https://gradle.com/s/opgqvcjaqzsr2

Build step 'Invoke Gradle script' changed build result to FAILURE
Build step 'Invoke Gradle script' marked build as failure

---------------------------------------------------------------------
To unsubscribe, e-mail: builds-unsubscribe@beam.apache.org
For additional commands, e-mail: builds-help@beam.apache.org

Build failed in Jenkins: beam_PreCommit_SQL_Java11_Cron #3987

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

Changes:

[noreply] Bump github.com/tetratelabs/wazero from 1.0.0-pre.7 to 1.0.0-pre.9 in


------------------------------------------
[...truncated 305.95 KB...]

org.apache.beam.sdk.extensions.sql.zetasql.ZetaSqlTimeFunctionsTest > testDateFromYearMonthDay FAILED
    java.lang.IllegalArgumentException at ZetaSqlTimeFunctionsTest.java:199

org.apache.beam.sdk.extensions.sql.zetasql.ZetaSqlTimeFunctionsTest > testDateTimeColumn FAILED
    java.lang.IllegalArgumentException at ZetaSqlTimeFunctionsTest.java:817

org.apache.beam.sdk.extensions.sql.zetasql.ZetaSqlTimeFunctionsTest > testDateTrunc FAILED
    java.lang.IllegalArgumentException at ZetaSqlTimeFunctionsTest.java:384

org.apache.beam.sdk.extensions.sql.zetasql.ZetaSqlTimeFunctionsTest > testDateTimeDiffNegativeResult FAILED
    java.lang.IllegalArgumentException at ZetaSqlTimeFunctionsTest.java:1149

org.apache.beam.sdk.extensions.sql.zetasql.ZetaSqlTimeFunctionsTest > testFormatDateTime FAILED
    java.lang.IllegalArgumentException at ZetaSqlTimeFunctionsTest.java:1184

org.apache.beam.sdk.extensions.sql.zetasql.ZetaSqlTimeFunctionsTest > testTimeDiffNegativeResult FAILED
    java.lang.IllegalArgumentException at ZetaSqlTimeFunctionsTest.java:731

org.apache.beam.sdk.extensions.sql.zetasql.ZetaSqlTimeFunctionsTest > testExtractTimeFromTimestamp FAILED
    java.lang.IllegalArgumentException at ZetaSqlTimeFunctionsTest.java:1366

org.apache.beam.sdk.extensions.sql.zetasql.ZetaSqlTimeFunctionsTest > testTimeTrunc FAILED
    java.lang.IllegalArgumentException at ZetaSqlTimeFunctionsTest.java:747

org.apache.beam.sdk.extensions.sql.zetasql.ZetaSqlTimeFunctionsTest > testDateLiteral FAILED
    java.lang.IllegalArgumentException at ZetaSqlTimeFunctionsTest.java:72

org.apache.beam.sdk.extensions.sql.zetasql.ZetaSqlTimeFunctionsTest > testExtractFromTimestampAtTimeZone FAILED
    java.lang.IllegalArgumentException at ZetaSqlTimeFunctionsTest.java:1407

> Task :sdks:java:extensions:sql:runPojoExample
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-jdk14/1.7.30/d35953dd2fe54ebe39fdf18cfd82fe6eb35b25ed/slf4j-jdk14-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-reload4j/1.7.36/db708f7d959dee1857ac524636e85ecf2e1781c1/slf4j-reload4j-1.7.36.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-log4j12/1.7.30/c21f55139d8141d2231214fb1feaf50a1edca95e/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.JDK14LoggerFactory]
Feb 20, 2023 10:42:59 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `PCOLLECTION`.`id`, `PCOLLECTION`.`name`
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`
WHERE `PCOLLECTION`.`countryOfResidence` = 'Wonderland'
Feb 20, 2023 10:43:00 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(id=[$2], name=[$1])
  LogicalFilter(condition=[=($0, 'Wonderland')])
    BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 20, 2023 10:43:00 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..2=[{inputs}], expr#3=['Wonderland':VARCHAR], expr#4=[=($t0, $t3)], id=[$t2], name=[$t1], $condition=[$t4])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 20, 2023 10:43:00 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT COUNT(`PCOLLECTION`.`id`)
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`
Feb 20, 2023 10:43:00 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalAggregate(group=[{}], EXPR$0=[COUNT()])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 20, 2023 10:43:01 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamAggregationRel(group=[{}], EXPR$0=[COUNT()])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 20, 2023 10:43:01 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `customers`.`name`, 'order id:' || CAST(`orders`.`id` AS VARCHAR)
FROM `beam`.`orders` AS `orders`
INNER JOIN `beam`.`customers` AS `customers` ON `orders`.`customerId` = `customers`.`id`
WHERE `customers`.`name` = 'Grault'
Feb 20, 2023 10:43:01 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(name=[$3], EXPR$1=[||('order id:', CAST($1):VARCHAR NOT NULL)])
  LogicalFilter(condition=[=($3, 'Grault')])
    LogicalJoin(condition=[=($0, $4)], joinType=[inner])
      BeamIOSourceRel(table=[[beam, orders]])
      BeamIOSourceRel(table=[[beam, customers]])

Feb 20, 2023 10:43:01 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..4=[{inputs}], expr#5=['order id:'], expr#6=[CAST($t1):VARCHAR NOT NULL], expr#7=[||($t5, $t6)], name=[$t3], EXPR$1=[$t7])
  BeamCoGBKJoinRel(condition=[=($0, $4)], joinType=[inner])
    BeamIOSourceRel(table=[[beam, orders]])
    BeamCalcRel(expr#0..2=[{inputs}], expr#3=['Grault':VARCHAR], expr#4=[=($t1, $t3)], proj#0..2=[{exprs}], $condition=[$t4])
      BeamIOSourceRel(table=[[beam, customers]])

Feb 20, 2023 10:43:01 AM org.apache.beam.sdk.Pipeline validate
WARNING: The following transforms do not have stable unique names: Create.Values, MapElements, SqlTransform
[4, Grault]: is from Wonderland
[1, Foo]: is from Wonderland
[3, Baz]: is from Wonderland
[3]: total customers in Wonderland
[Grault, order id:7]: ordered by 'Grault'
[Grault, order id:8]: ordered by 'Grault'

> Task :sdks:java:extensions:sql:zetasql:test

org.apache.beam.sdk.extensions.sql.zetasql.ZetaSqlTimeFunctionsTest > testTimestampToUnixInt64 FAILED
    java.lang.IllegalArgumentException at ZetaSqlTimeFunctionsTest.java:1741

org.apache.beam.sdk.extensions.sql.zetasql.ZetaSqlTimeFunctionsTest > testDateTimeFromDate FAILED
    java.lang.IllegalArgumentException at ZetaSqlTimeFunctionsTest.java:965

org.apache.beam.sdk.extensions.sql.zetasql.ZetaSqlTimeFunctionsTest > testTimestampFromString FAILED
    java.lang.IllegalArgumentException at ZetaSqlTimeFunctionsTest.java:1446

org.apache.beam.sdk.extensions.sql.zetasql.ZetaSqlTimeFunctionsTest > testDateAdd FAILED
    java.lang.IllegalArgumentException at ZetaSqlTimeFunctionsTest.java:251

org.apache.beam.sdk.extensions.sql.zetasql.ZetaSqlTimeFunctionsTest > testDateSub FAILED
    java.lang.IllegalArgumentException at ZetaSqlTimeFunctionsTest.java:328

org.apache.beam.sdk.extensions.sql.zetasql.ZetaSqlTimeFunctionsTest > testExtractFromDateTime FAILED
    java.lang.IllegalArgumentException at ZetaSqlTimeFunctionsTest.java:900

org.apache.beam.sdk.extensions.sql.zetasql.ZetaSqlTimeFunctionsTest > testDateFromDateTime FAILED
    java.lang.IllegalArgumentException at ZetaSqlTimeFunctionsTest.java:231

org.apache.beam.sdk.extensions.sql.zetasql.ZetaSqlTimeFunctionsTest > testGroupByDateTime FAILED
    java.lang.IllegalArgumentException at ZetaSqlTimeFunctionsTest.java:836

org.apache.beam.sdk.extensions.sql.zetasql.ZetaSqlTimeFunctionsTest > testDateTimeLiteral FAILED
    java.lang.IllegalArgumentException at ZetaSqlTimeFunctionsTest.java:800

org.apache.beam.sdk.extensions.sql.zetasql.ZetaSqlTimeFunctionsTest > testDateTimeDiff FAILED
    java.lang.IllegalArgumentException at ZetaSqlTimeFunctionsTest.java:1132

org.apache.beam.sdk.extensions.sql.zetasql.ZetaSqlTimeFunctionsTest > testDateAddWithParameter FAILED
    java.lang.IllegalArgumentException at ZetaSqlTimeFunctionsTest.java:295

org.apache.beam.sdk.extensions.sql.zetasql.ZetaSqlTimeFunctionsTest > testTimestampAddWithParameter1 FAILED
    java.lang.IllegalArgumentException at ZetaSqlTimeFunctionsTest.java:1569

org.apache.beam.sdk.extensions.sql.zetasql.ZetaSqlTimeFunctionsTest > testTimestampAddWithParameter2 FAILED
    java.lang.IllegalArgumentException at ZetaSqlTimeFunctionsTest.java:1590

org.apache.beam.sdk.extensions.sql.zetasql.ZetaSqlTimeFunctionsTest > testTimestampFromInt64 FAILED
    java.lang.IllegalArgumentException at ZetaSqlTimeFunctionsTest.java:1716

org.apache.beam.sdk.extensions.sql.zetasql.ZetaSqlTimeFunctionsTest > testTimestampTrunc FAILED
    java.lang.IllegalArgumentException at ZetaSqlTimeFunctionsTest.java:1668

492 tests completed, 426 failed, 13 skipped

> Task :sdks:java:extensions:sql:zetasql:test FAILED
> Task :runners:flink:1.12:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.13:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.14:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.15:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.12:job-server:startShadowScripts
> Task :runners:flink:1.13:job-server:startShadowScripts
> Task :runners:flink:1.12:job-server:shadowDistTar
> Task :runners:flink:1.13:job-server:shadowDistTar
> Task :runners:flink:1.14:job-server:startShadowScripts
> Task :runners:flink:1.15:job-server:startShadowScripts
> Task :runners:flink:1.14:job-server:shadowDistTar
> Task :runners:flink:1.15:job-server:shadowDistTar
> Task :runners:flink:1.12:job-server:shadowDistZip
> Task :runners:flink:1.13:job-server:shadowDistZip
> Task :runners:flink:1.14:job-server:shadowDistZip
> Task :runners:flink:1.13:job-server:assemble
> Task :runners:flink:1.13:job-server:test NO-SOURCE
> Task :runners:flink:1.13:job-server:check
> Task :runners:flink:1.13:job-server:build
> Task :runners:flink:1.13:job-server:buildDependents
> Task :runners:flink:1.12:job-server:assemble
> Task :runners:flink:1.12:job-server:test NO-SOURCE
> Task :runners:flink:1.12:job-server:check
> Task :runners:flink:1.12:job-server:build
> Task :runners:flink:1.12:job-server:buildDependents
> Task :runners:flink:1.15:job-server:shadowDistZip
> Task :runners:flink:1.14:job-server:assemble
> Task :runners:flink:1.14:job-server:test NO-SOURCE
> Task :runners:flink:1.14:job-server:check
> Task :runners:flink:1.14:job-server:build
> Task :runners:flink:1.14:job-server:buildDependents
> Task :runners:flink:1.15:job-server:assemble
> Task :runners:flink:1.15:job-server:test NO-SOURCE
> Task :runners:flink:1.15:job-server:check
> Task :runners:flink:1.15:job-server:build
> Task :runners:flink:1.15:job-server:buildDependents
> Task :sdks:java:extensions:sql:expansion-service:buildDependents

FAILURE: Build completed with 4 failures.

1: Task failed with an exception.
-----------
* What went wrong:
Execution failed for task ':sdks:java:extensions:sql:jdbc:test'.
> There were failing tests. See the report at: file://<https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/ws/src/sdks/java/extensions/sql/jdbc/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.
==============================================================================

2: Task failed with an exception.
-----------
* What went wrong:
Execution failed for task ':sdks:java:testing:nexmark:test'.
> There were failing tests. See the report at: file://<https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/ws/src/sdks/java/testing/nexmark/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.
==============================================================================

3: Task failed with an exception.
-----------
* What went wrong:
Execution failed for task ':sdks:java:extensions:sql:test'.
> There were failing tests. See the report at: file://<https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/ws/src/sdks/java/extensions/sql/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.
==============================================================================

4: Task failed with an exception.
-----------
* What went wrong:
Execution failed for task ':sdks:java:extensions:sql:zetasql:test'.
> There were failing tests. See the report at: file://<https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/ws/src/sdks/java/extensions/sql/zetasql/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.
==============================================================================

* 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.5.1/userguide/command_line_interface.html#sec:command_line_warnings

BUILD FAILED in 3m 48s
256 actionable tasks: 154 executed, 102 from cache

Publishing build scan...
https://gradle.com/s/6chjmq4huowp6

Build step 'Invoke Gradle script' changed build result to FAILURE
Build step 'Invoke Gradle script' marked build as failure

---------------------------------------------------------------------
To unsubscribe, e-mail: builds-unsubscribe@beam.apache.org
For additional commands, e-mail: builds-help@beam.apache.org

Build failed in Jenkins: beam_PreCommit_SQL_Java11_Cron #3986

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

Changes:

[noreply] [#24789][prism] internal/worker + tentative data (#25478)

[noreply] [#24789][prism] add preprocessor and test (#25520)


------------------------------------------
[...truncated 305.09 KB...]
org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testWriteLines FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:262

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testLines FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:205

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testJson FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:224

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testWriteCsv FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:282

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testWriteJson FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:301

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testExplicitCsv FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:152

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testExplicitCsvExcel FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:180

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testLegacyTdfCsv FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:127

715 tests completed, 455 failed, 8 skipped

> Task :sdks:java:extensions:sql:test FAILED

> Task :sdks:java:extensions:sql:runBasicExample
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-jdk14/1.7.30/d35953dd2fe54ebe39fdf18cfd82fe6eb35b25ed/slf4j-jdk14-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-reload4j/1.7.36/db708f7d959dee1857ac524636e85ecf2e1781c1/slf4j-reload4j-1.7.36.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-log4j12/1.7.30/c21f55139d8141d2231214fb1feaf50a1edca95e/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.JDK14LoggerFactory]
Feb 20, 2023 4:39:30 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `PCOLLECTION`.`c1`, `PCOLLECTION`.`c2`, `PCOLLECTION`.`c3`
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`
WHERE `PCOLLECTION`.`c1` > 1
Feb 20, 2023 4:39:30 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(c1=[$0], c2=[$1], c3=[$2])
  LogicalFilter(condition=[>($0, 1)])
    BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 20, 2023 4:39:31 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..2=[{inputs}], expr#3=[1], expr#4=[>($t0, $t3)], proj#0..2=[{exprs}], $condition=[$t4])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 20, 2023 4:39:31 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `CASE1_RESULT`.`c2`, SUM(`CASE1_RESULT`.`c3`)
FROM `beam`.`CASE1_RESULT` AS `CASE1_RESULT`
GROUP BY `CASE1_RESULT`.`c2`
Feb 20, 2023 4:39:31 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalAggregate(group=[{0}], EXPR$1=[SUM($1)])
  LogicalProject(c2=[$1], c3=[$2])
    BeamIOSourceRel(table=[[beam, CASE1_RESULT]])

Feb 20, 2023 4:39:31 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamAggregationRel(group=[{1}], EXPR$1=[SUM($2)])
  BeamIOSourceRel(table=[[beam, CASE1_RESULT]])

Feb 20, 2023 4:39:31 AM org.apache.beam.sdk.Pipeline validate
WARNING: The following transforms do not have stable unique names: log_result, SqlTransform
PCOLLECTION: [3, row, 3.0]
PCOLLECTION: [2, row, 2.0]
CASE1_RESULT: [row, 5.0]

> Task :sdks:java:extensions:sql:runPojoExample
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-jdk14/1.7.30/d35953dd2fe54ebe39fdf18cfd82fe6eb35b25ed/slf4j-jdk14-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-reload4j/1.7.36/db708f7d959dee1857ac524636e85ecf2e1781c1/slf4j-reload4j-1.7.36.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-log4j12/1.7.30/c21f55139d8141d2231214fb1feaf50a1edca95e/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.JDK14LoggerFactory]
Feb 20, 2023 4:39:38 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `PCOLLECTION`.`id`, `PCOLLECTION`.`name`
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`
WHERE `PCOLLECTION`.`countryOfResidence` = 'Wonderland'
Feb 20, 2023 4:39:38 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(id=[$1], name=[$0])
  LogicalFilter(condition=[=($2, 'Wonderland')])
    BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 20, 2023 4:39:38 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..2=[{inputs}], expr#3=['Wonderland':VARCHAR], expr#4=[=($t2, $t3)], id=[$t1], name=[$t0], $condition=[$t4])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 20, 2023 4:39:39 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT COUNT(`PCOLLECTION`.`id`)
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`
Feb 20, 2023 4:39:39 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalAggregate(group=[{}], EXPR$0=[COUNT()])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 20, 2023 4:39:39 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamAggregationRel(group=[{}], EXPR$0=[COUNT()])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 20, 2023 4:39:39 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `customers`.`name`, 'order id:' || CAST(`orders`.`id` AS VARCHAR)
FROM `beam`.`orders` AS `orders`
INNER JOIN `beam`.`customers` AS `customers` ON `orders`.`customerId` = `customers`.`id`
WHERE `customers`.`name` = 'Grault'
Feb 20, 2023 4:39:39 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(name=[$2], EXPR$1=[||('order id:', CAST($0):VARCHAR NOT NULL)])
  LogicalFilter(condition=[=($2, 'Grault')])
    LogicalJoin(condition=[=($1, $3)], joinType=[inner])
      BeamIOSourceRel(table=[[beam, orders]])
      BeamIOSourceRel(table=[[beam, customers]])

Feb 20, 2023 4:39:39 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..4=[{inputs}], expr#5=['order id:'], expr#6=[CAST($t0):VARCHAR NOT NULL], expr#7=[||($t5, $t6)], name=[$t2], EXPR$1=[$t7])
  BeamCoGBKJoinRel(condition=[=($1, $3)], joinType=[inner])
    BeamIOSourceRel(table=[[beam, orders]])
    BeamCalcRel(expr#0..2=[{inputs}], expr#3=['Grault':VARCHAR], expr#4=[=($t0, $t3)], proj#0..2=[{exprs}], $condition=[$t4])
      BeamIOSourceRel(table=[[beam, customers]])

Feb 20, 2023 4:39:40 AM org.apache.beam.sdk.Pipeline validate
WARNING: The following transforms do not have stable unique names: Create.Values, MapElements, SqlTransform
[3, Baz]: is from Wonderland
[4, Grault]: is from Wonderland
[1, Foo]: is from Wonderland
[3]: total customers in Wonderland
[Grault, order id:7]: ordered by 'Grault'
[Grault, order id:8]: ordered by 'Grault'

> Task :sdks:java:extensions:sql:shell:distZip
> Task :sdks:java:extensions:sql:shell:assemble
> Task :sdks:java:extensions:sql:shell:analyzeClassesDependencies FROM-CACHE
> Task :sdks:java:extensions:sql:shell:analyzeDependencies UP-TO-DATE
> Task :sdks:java:extensions:sql:shell:test NO-SOURCE
> Task :sdks:java:extensions:sql:shell:check UP-TO-DATE
> Task :sdks:java:extensions:sql:shell:build
> Task :sdks:java:extensions:sql:shell:buildDependents
> Task :runners:flink:1.13:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.12:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.14:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.15:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.13:job-server:startShadowScripts
> Task :runners:flink:1.12:job-server:startShadowScripts
> Task :runners:flink:1.13:job-server:shadowDistTar
> Task :runners:flink:1.12:job-server:shadowDistTar
> Task :runners:flink:1.14:job-server:startShadowScripts
> Task :runners:flink:1.14:job-server:shadowDistTar
> Task :runners:flink:1.15:job-server:startShadowScripts
> Task :runners:flink:1.15:job-server:shadowDistTar
> Task :runners:flink:1.13:job-server:shadowDistZip
> Task :runners:flink:1.13:job-server:assemble
> Task :runners:flink:1.12:job-server:shadowDistZip
> Task :runners:flink:1.12:job-server:assemble
> Task :runners:flink:1.13:job-server:test NO-SOURCE
> Task :runners:flink:1.12:job-server:test NO-SOURCE
> Task :runners:flink:1.12:job-server:check UP-TO-DATE
> Task :runners:flink:1.12:job-server:build
> Task :runners:flink:1.13:job-server:check UP-TO-DATE
> Task :runners:flink:1.13:job-server:build
> Task :runners:flink:1.12:job-server:buildDependents
> Task :runners:flink:1.13:job-server:buildDependents
> Task :runners:flink:1.14:job-server:shadowDistZip
> Task :runners:flink:1.15:job-server:shadowDistZip
> Task :runners:flink:1.14:job-server:assemble
> Task :runners:flink:1.14:job-server:test NO-SOURCE
> Task :runners:flink:1.14:job-server:check UP-TO-DATE
> Task :runners:flink:1.14:job-server:build
> Task :runners:flink:1.14:job-server:buildDependents
> Task :runners:flink:1.15:job-server:assemble
> Task :runners:flink:1.15:job-server:test NO-SOURCE
> Task :runners:flink:1.15:job-server:check UP-TO-DATE
> Task :runners:flink:1.15:job-server:build
> Task :runners:flink:1.15:job-server:buildDependents
> Task :sdks:java:extensions:sql:expansion-service:buildDependents

FAILURE: Build completed with 4 failures.

1: Task failed with an exception.
-----------
* What went wrong:
Execution failed for task ':sdks:java:extensions:sql:jdbc:test'.
> There were failing tests. See the report at: file://<https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/ws/src/sdks/java/extensions/sql/jdbc/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.
==============================================================================

2: Task failed with an exception.
-----------
* What went wrong:
Execution failed for task ':sdks:java:extensions:sql:zetasql:test'.
> There were failing tests. See the report at: file://<https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/ws/src/sdks/java/extensions/sql/zetasql/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.
==============================================================================

3: Task failed with an exception.
-----------
* What went wrong:
Execution failed for task ':sdks:java:testing:nexmark:test'.
> There were failing tests. See the report at: file://<https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/ws/src/sdks/java/testing/nexmark/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.
==============================================================================

4: Task failed with an exception.
-----------
* What went wrong:
Execution failed for task ':sdks:java:extensions:sql:test'.
> There were failing tests. See the report at: file://<https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/ws/src/sdks/java/extensions/sql/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.
==============================================================================

* 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.5.1/userguide/command_line_interface.html#sec:command_line_warnings

BUILD FAILED in 3m 11s
256 actionable tasks: 139 executed, 117 from cache

Publishing build scan...
https://gradle.com/s/pf4sg7ixqmakc

Build step 'Invoke Gradle script' changed build result to FAILURE
Build step 'Invoke Gradle script' marked build as failure

---------------------------------------------------------------------
To unsubscribe, e-mail: builds-unsubscribe@beam.apache.org
For additional commands, e-mail: builds-help@beam.apache.org

Build failed in Jenkins: beam_PreCommit_SQL_Java11_Cron #3985

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

Changes:

[noreply] Fix Tensorflow intergration test model path (#25553)

[noreply] [Go SDK]: Retrieve file size in CreateInitialRestriction in textio.Read


------------------------------------------
[...truncated 303.90 KB...]

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testWriteCsv FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:282

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testWriteJson FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:301

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testExplicitCsv FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:152

> Task :runners:flink:1.13:job-server:distZip
> Task :runners:flink:1.12:job-server:distZip
> Task :runners:flink:1.14:job-server:distZip

> Task :sdks:java:extensions:sql:test FAILED

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testExplicitCsvExcel FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:180

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testLegacyTdfCsv FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:127

715 tests completed, 455 failed, 8 skipped

> Task :sdks:java:extensions:sql:runBasicExample
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-jdk14/1.7.30/d35953dd2fe54ebe39fdf18cfd82fe6eb35b25ed/slf4j-jdk14-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-reload4j/1.7.36/db708f7d959dee1857ac524636e85ecf2e1781c1/slf4j-reload4j-1.7.36.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-log4j12/1.7.30/c21f55139d8141d2231214fb1feaf50a1edca95e/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.JDK14LoggerFactory]
Feb 19, 2023 10:39:14 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `PCOLLECTION`.`c1`, `PCOLLECTION`.`c2`, `PCOLLECTION`.`c3`
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`
WHERE `PCOLLECTION`.`c1` > 1
Feb 19, 2023 10:39:15 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(c1=[$0], c2=[$1], c3=[$2])
  LogicalFilter(condition=[>($0, 1)])
    BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 19, 2023 10:39:15 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..2=[{inputs}], expr#3=[1], expr#4=[>($t0, $t3)], proj#0..2=[{exprs}], $condition=[$t4])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 19, 2023 10:39:15 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `CASE1_RESULT`.`c2`, SUM(`CASE1_RESULT`.`c3`)
FROM `beam`.`CASE1_RESULT` AS `CASE1_RESULT`
GROUP BY `CASE1_RESULT`.`c2`
Feb 19, 2023 10:39:15 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalAggregate(group=[{0}], EXPR$1=[SUM($1)])
  LogicalProject(c2=[$1], c3=[$2])
    BeamIOSourceRel(table=[[beam, CASE1_RESULT]])


> Task :runners:flink:1.15:job-server:distZip

> Task :sdks:java:extensions:sql:runBasicExample
Feb 19, 2023 10:39:15 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamAggregationRel(group=[{1}], EXPR$1=[SUM($2)])
  BeamIOSourceRel(table=[[beam, CASE1_RESULT]])

Feb 19, 2023 10:39:16 PM org.apache.beam.sdk.Pipeline validate
WARNING: The following transforms do not have stable unique names: log_result, SqlTransform
PCOLLECTION: [3, row, 3.0]
PCOLLECTION: [2, row, 2.0]
CASE1_RESULT: [row, 5.0]

> Task :sdks:java:extensions:sql:runPojoExample
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-jdk14/1.7.30/d35953dd2fe54ebe39fdf18cfd82fe6eb35b25ed/slf4j-jdk14-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-reload4j/1.7.36/db708f7d959dee1857ac524636e85ecf2e1781c1/slf4j-reload4j-1.7.36.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-log4j12/1.7.30/c21f55139d8141d2231214fb1feaf50a1edca95e/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.JDK14LoggerFactory]
Feb 19, 2023 10:39:23 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `PCOLLECTION`.`id`, `PCOLLECTION`.`name`
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`
WHERE `PCOLLECTION`.`countryOfResidence` = 'Wonderland'
Feb 19, 2023 10:39:23 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(id=[$2], name=[$1])
  LogicalFilter(condition=[=($0, 'Wonderland')])
    BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 19, 2023 10:39:23 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..2=[{inputs}], expr#3=['Wonderland':VARCHAR], expr#4=[=($t0, $t3)], id=[$t2], name=[$t1], $condition=[$t4])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 19, 2023 10:39:24 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT COUNT(`PCOLLECTION`.`id`)
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`
Feb 19, 2023 10:39:24 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalAggregate(group=[{}], EXPR$0=[COUNT()])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 19, 2023 10:39:24 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamAggregationRel(group=[{}], EXPR$0=[COUNT()])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 19, 2023 10:39:24 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `customers`.`name`, 'order id:' || CAST(`orders`.`id` AS VARCHAR)
FROM `beam`.`orders` AS `orders`
INNER JOIN `beam`.`customers` AS `customers` ON `orders`.`customerId` = `customers`.`id`
WHERE `customers`.`name` = 'Grault'
Feb 19, 2023 10:39:24 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(name=[$3], EXPR$1=[||('order id:', CAST($1):VARCHAR NOT NULL)])
  LogicalFilter(condition=[=($3, 'Grault')])
    LogicalJoin(condition=[=($0, $4)], joinType=[inner])
      BeamIOSourceRel(table=[[beam, orders]])
      BeamIOSourceRel(table=[[beam, customers]])

Feb 19, 2023 10:39:24 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..4=[{inputs}], expr#5=['order id:'], expr#6=[CAST($t1):VARCHAR NOT NULL], expr#7=[||($t5, $t6)], name=[$t3], EXPR$1=[$t7])
  BeamCoGBKJoinRel(condition=[=($0, $4)], joinType=[inner])
    BeamIOSourceRel(table=[[beam, orders]])
    BeamCalcRel(expr#0..2=[{inputs}], expr#3=['Grault':VARCHAR], expr#4=[=($t1, $t3)], proj#0..2=[{exprs}], $condition=[$t4])
      BeamIOSourceRel(table=[[beam, customers]])

Feb 19, 2023 10:39:24 PM org.apache.beam.sdk.Pipeline validate
WARNING: The following transforms do not have stable unique names: Create.Values, MapElements, SqlTransform
[1, Foo]: is from Wonderland
[3, Baz]: is from Wonderland
[4, Grault]: is from Wonderland
[3]: total customers in Wonderland
[Grault, order id:8]: ordered by 'Grault'
[Grault, order id:7]: ordered by 'Grault'

> Task :sdks:java:extensions:sql:shell:distZip
> Task :sdks:java:extensions:sql:shell:assemble
> Task :sdks:java:extensions:sql:shell:analyzeClassesDependencies FROM-CACHE
> Task :sdks:java:extensions:sql:shell:analyzeDependencies UP-TO-DATE
> Task :sdks:java:extensions:sql:shell:test NO-SOURCE
> Task :sdks:java:extensions:sql:shell:check UP-TO-DATE
> Task :sdks:java:extensions:sql:shell:build
> Task :sdks:java:extensions:sql:shell:buildDependents
> Task :runners:flink:1.13:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.12:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.14:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.15:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.13:job-server:startShadowScripts
> Task :runners:flink:1.13:job-server:shadowDistTar
> Task :runners:flink:1.12:job-server:startShadowScripts
> Task :runners:flink:1.12:job-server:shadowDistTar
> Task :runners:flink:1.14:job-server:startShadowScripts
> Task :runners:flink:1.15:job-server:startShadowScripts
> Task :runners:flink:1.14:job-server:shadowDistTar
> Task :runners:flink:1.15:job-server:shadowDistTar
> Task :runners:flink:1.13:job-server:shadowDistZip
> Task :runners:flink:1.13:job-server:assemble
> Task :runners:flink:1.13:job-server:test NO-SOURCE
> Task :runners:flink:1.13:job-server:check UP-TO-DATE
> Task :runners:flink:1.13:job-server:build
> Task :runners:flink:1.13:job-server:buildDependents
> Task :runners:flink:1.12:job-server:shadowDistZip
> Task :runners:flink:1.12:job-server:assemble
> Task :runners:flink:1.12:job-server:test NO-SOURCE
> Task :runners:flink:1.12:job-server:check UP-TO-DATE
> Task :runners:flink:1.12:job-server:build
> Task :runners:flink:1.12:job-server:buildDependents
> Task :runners:flink:1.14:job-server:shadowDistZip
> Task :runners:flink:1.15:job-server:shadowDistZip
> Task :runners:flink:1.15:job-server:assemble
> Task :runners:flink:1.15:job-server:test NO-SOURCE
> Task :runners:flink:1.15:job-server:check UP-TO-DATE
> Task :runners:flink:1.15:job-server:build
> Task :runners:flink:1.15:job-server:buildDependents
> Task :runners:flink:1.14:job-server:assemble
> Task :runners:flink:1.14:job-server:test NO-SOURCE
> Task :runners:flink:1.14:job-server:check UP-TO-DATE
> Task :runners:flink:1.14:job-server:build
> Task :runners:flink:1.14:job-server:buildDependents
> Task :sdks:java:extensions:sql:expansion-service:buildDependents

FAILURE: Build completed with 4 failures.

1: Task failed with an exception.
-----------
* What went wrong:
Execution failed for task ':sdks:java:extensions:sql:jdbc:test'.
> There were failing tests. See the report at: file://<https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/ws/src/sdks/java/extensions/sql/jdbc/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.
==============================================================================

2: Task failed with an exception.
-----------
* What went wrong:
Execution failed for task ':sdks:java:extensions:sql:zetasql:test'.
> There were failing tests. See the report at: file://<https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/ws/src/sdks/java/extensions/sql/zetasql/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.
==============================================================================

3: Task failed with an exception.
-----------
* What went wrong:
Execution failed for task ':sdks:java:testing:nexmark:test'.
> There were failing tests. See the report at: file://<https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/ws/src/sdks/java/testing/nexmark/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.
==============================================================================

4: Task failed with an exception.
-----------
* What went wrong:
Execution failed for task ':sdks:java:extensions:sql:test'.
> There were failing tests. See the report at: file://<https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/ws/src/sdks/java/extensions/sql/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.
==============================================================================

* 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.5.1/userguide/command_line_interface.html#sec:command_line_warnings

BUILD FAILED in 3m 5s
256 actionable tasks: 139 executed, 117 from cache

Publishing build scan...
https://gradle.com/s/pigrsl56stutc

Build step 'Invoke Gradle script' changed build result to FAILURE
Build step 'Invoke Gradle script' marked build as failure

---------------------------------------------------------------------
To unsubscribe, e-mail: builds-unsubscribe@beam.apache.org
For additional commands, e-mail: builds-help@beam.apache.org

Build failed in Jenkins: beam_PreCommit_SQL_Java11_Cron #3984

Posted by Apache Jenkins Server <je...@builds.apache.org>.
See <https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/3984/display/redirect>

Changes:


------------------------------------------
[...truncated 332.56 KB...]

> Task :sdks:java:testing:nexmark:test FAILED
> Task :runners:flink:1.12:job-server:distTar
> Task :runners:flink:1.15:job-server:distTar
> Task :runners:flink:1.13:job-server:distTar
> Task :runners:flink:1.14:job-server:distTar

> Task :sdks:java:extensions:sql:runBasicExample
Feb 19, 2023 4:44:49 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `PCOLLECTION`.`c1`, `PCOLLECTION`.`c2`, `PCOLLECTION`.`c3`
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`
WHERE `PCOLLECTION`.`c1` > 1
Feb 19, 2023 4:44:50 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(c1=[$0], c2=[$1], c3=[$2])
  LogicalFilter(condition=[>($0, 1)])
    BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 19, 2023 4:44:51 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..2=[{inputs}], expr#3=[1], expr#4=[>($t0, $t3)], proj#0..2=[{exprs}], $condition=[$t4])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 19, 2023 4:44:52 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `CASE1_RESULT`.`c2`, SUM(`CASE1_RESULT`.`c3`)
FROM `beam`.`CASE1_RESULT` AS `CASE1_RESULT`
GROUP BY `CASE1_RESULT`.`c2`
Feb 19, 2023 4:44:52 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalAggregate(group=[{0}], EXPR$1=[SUM($1)])
  LogicalProject(c2=[$1], c3=[$2])
    BeamIOSourceRel(table=[[beam, CASE1_RESULT]])

Feb 19, 2023 4:44:53 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamAggregationRel(group=[{1}], EXPR$1=[SUM($2)])
  BeamIOSourceRel(table=[[beam, CASE1_RESULT]])

Feb 19, 2023 4:44:54 PM org.apache.beam.sdk.Pipeline validate
WARNING: The following transforms do not have stable unique names: log_result, SqlTransform
PCOLLECTION: [2, row, 2.0]
PCOLLECTION: [3, row, 3.0]
CASE1_RESULT: [row, 5.0]

> Task :sdks:java:extensions:sql:runPojoExample
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-jdk14/1.7.30/d35953dd2fe54ebe39fdf18cfd82fe6eb35b25ed/slf4j-jdk14-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-reload4j/1.7.36/db708f7d959dee1857ac524636e85ecf2e1781c1/slf4j-reload4j-1.7.36.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-log4j12/1.7.30/c21f55139d8141d2231214fb1feaf50a1edca95e/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.JDK14LoggerFactory]

> Task :runners:flink:1.12:job-server:distZip
> Task :runners:flink:1.15:job-server:distZip
> Task :runners:flink:1.13:job-server:distZip
> Task :runners:flink:1.14:job-server:distZip

> Task :sdks:java:extensions:sql:runPojoExample
Feb 19, 2023 4:45:17 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `PCOLLECTION`.`id`, `PCOLLECTION`.`name`
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`
WHERE `PCOLLECTION`.`countryOfResidence` = 'Wonderland'
Feb 19, 2023 4:45:18 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(id=[$1], name=[$0])
  LogicalFilter(condition=[=($2, 'Wonderland')])
    BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 19, 2023 4:45:19 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..2=[{inputs}], expr#3=['Wonderland':VARCHAR], expr#4=[=($t2, $t3)], id=[$t1], name=[$t0], $condition=[$t4])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 19, 2023 4:45:20 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT COUNT(`PCOLLECTION`.`id`)
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`
Feb 19, 2023 4:45:20 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalAggregate(group=[{}], EXPR$0=[COUNT()])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 19, 2023 4:45:21 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamAggregationRel(group=[{}], EXPR$0=[COUNT()])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 19, 2023 4:45:21 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `customers`.`name`, 'order id:' || CAST(`orders`.`id` AS VARCHAR)
FROM `beam`.`orders` AS `orders`
INNER JOIN `beam`.`customers` AS `customers` ON `orders`.`customerId` = `customers`.`id`
WHERE `customers`.`name` = 'Grault'
Feb 19, 2023 4:45:21 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(name=[$2], EXPR$1=[||('order id:', CAST($0):VARCHAR NOT NULL)])
  LogicalFilter(condition=[=($2, 'Grault')])
    LogicalJoin(condition=[=($1, $3)], joinType=[inner])
      BeamIOSourceRel(table=[[beam, orders]])
      BeamIOSourceRel(table=[[beam, customers]])

Feb 19, 2023 4:45:22 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..4=[{inputs}], expr#5=['order id:'], expr#6=[CAST($t0):VARCHAR NOT NULL], expr#7=[||($t5, $t6)], name=[$t2], EXPR$1=[$t7])
  BeamCoGBKJoinRel(condition=[=($1, $3)], joinType=[inner])
    BeamIOSourceRel(table=[[beam, orders]])
    BeamCalcRel(expr#0..2=[{inputs}], expr#3=['Grault':VARCHAR], expr#4=[=($t0, $t3)], proj#0..2=[{exprs}], $condition=[$t4])
      BeamIOSourceRel(table=[[beam, customers]])

Feb 19, 2023 4:45:23 PM org.apache.beam.sdk.Pipeline validate
WARNING: The following transforms do not have stable unique names: Create.Values, MapElements, SqlTransform
[1, Foo]: is from Wonderland
[3, Baz]: is from Wonderland
[4, Grault]: is from Wonderland
[3]: total customers in Wonderland
[Grault, order id:8]: ordered by 'Grault'
[Grault, order id:7]: ordered by 'Grault'

> Task :sdks:java:extensions:sql:jdbc:test
> Task :runners:flink:1.12:job-server:shadowJar
> Task :runners:flink:1.13:job-server:shadowJar

> Task :sdks:java:extensions:sql:jdbc:test FAILED

org.apache.beam.sdk.extensions.sql.jdbc.BeamSqlLineTest > testSqlLine_slidingWindow FAILED
    java.lang.AssertionError at BeamSqlLineTest.java:191

org.apache.beam.sdk.extensions.sql.jdbc.BeamSqlLineTest > testSqlLine_fixedWindow FAILED
    java.lang.AssertionError at BeamSqlLineTest.java:169

org.apache.beam.sdk.extensions.sql.jdbc.BeamSqlLineTest > testSqlLine_selectFromTable FAILED
    java.lang.AssertionError at BeamSqlLineTest.java:114

org.apache.beam.sdk.extensions.sql.jdbc.BeamSqlLineTest > testSqlLine_select FAILED
    java.lang.AssertionError at BeamSqlLineTest.java:96

org.apache.beam.sdk.extensions.sql.jdbc.BeamSqlLineTest > testSqlLine_insertSelect FAILED
    java.lang.AssertionError at BeamSqlLineTest.java:133

org.apache.beam.sdk.extensions.sql.jdbc.BeamSqlLineTest > testSqlLine_GroupBy FAILED
    java.lang.AssertionError at BeamSqlLineTest.java:150

org.apache.beam.sdk.extensions.sql.jdbc.JdbcJarTest > classLoader_parse FAILED
    java.sql.SQLException at JdbcJarTest.java:67
        Caused by: java.lang.IllegalArgumentException at JdbcJarTest.java:67

16 tests completed, 7 failed

> Task :runners:flink:1.15:job-server:shadowJar
> Task :runners:flink:1.14:job-server:shadowJar
> Task :runners:flink:1.12:job-server:startShadowScripts
> Task :runners:flink:1.12:job-server:shadowDistTar
> Task :runners:flink:1.13:job-server:startShadowScripts
> Task :runners:flink:1.13:job-server:shadowDistTar
> Task :runners:flink:1.15:job-server:startShadowScripts
> Task :runners:flink:1.15:job-server:shadowDistTar
> Task :runners:flink:1.14:job-server:startShadowScripts
> Task :runners:flink:1.14:job-server:shadowDistTar
> Task :runners:flink:1.12:job-server:shadowDistZip
> Task :runners:flink:1.12:job-server:assemble
> Task :runners:flink:1.12:job-server:test NO-SOURCE
> Task :runners:flink:1.12:job-server:check
> Task :runners:flink:1.12:job-server:build
> Task :runners:flink:1.12:job-server:buildDependents
> Task :runners:flink:1.13:job-server:shadowDistZip
> Task :runners:flink:1.13:job-server:assemble
> Task :runners:flink:1.13:job-server:test NO-SOURCE
> Task :runners:flink:1.13:job-server:check
> Task :runners:flink:1.13:job-server:build
> Task :runners:flink:1.13:job-server:buildDependents
> Task :runners:flink:1.15:job-server:shadowDistZip
> Task :runners:flink:1.15:job-server:assemble
> Task :runners:flink:1.15:job-server:test NO-SOURCE
> Task :runners:flink:1.15:job-server:check
> Task :runners:flink:1.15:job-server:build
> Task :runners:flink:1.15:job-server:buildDependents
> Task :runners:flink:1.14:job-server:shadowDistZip
> Task :runners:flink:1.14:job-server:assemble
> Task :runners:flink:1.14:job-server:test NO-SOURCE
> Task :runners:flink:1.14:job-server:check
> Task :runners:flink:1.14:job-server:build
> Task :runners:flink:1.14:job-server:buildDependents
> Task :sdks:java:extensions:sql:expansion-service:buildDependents

FAILURE: Build completed with 4 failures.

1: Task failed with an exception.
-----------
* What went wrong:
Execution failed for task ':sdks:java:extensions:sql:zetasql:test'.
> There were failing tests. See the report at: file://<https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/ws/src/sdks/java/extensions/sql/zetasql/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.
==============================================================================

2: Task failed with an exception.
-----------
* What went wrong:
Execution failed for task ':sdks:java:extensions:sql:test'.
> There were failing tests. See the report at: file://<https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/ws/src/sdks/java/extensions/sql/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.
==============================================================================

3: Task failed with an exception.
-----------
* What went wrong:
Execution failed for task ':sdks:java:testing:nexmark:test'.
> There were failing tests. See the report at: file://<https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/ws/src/sdks/java/testing/nexmark/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.
==============================================================================

4: Task failed with an exception.
-----------
* What went wrong:
Execution failed for task ':sdks:java:extensions:sql:jdbc:test'.
> There were failing tests. See the report at: file://<https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/ws/src/sdks/java/extensions/sql/jdbc/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.
==============================================================================

* 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.5.1/userguide/command_line_interface.html#sec:command_line_warnings

BUILD FAILED in 11m 43s
256 actionable tasks: 240 executed, 16 from cache

Publishing build scan...
https://gradle.com/s/ihgqcem54jtsm

Build step 'Invoke Gradle script' changed build result to FAILURE
Build step 'Invoke Gradle script' marked build as failure

---------------------------------------------------------------------
To unsubscribe, e-mail: builds-unsubscribe@beam.apache.org
For additional commands, e-mail: builds-help@beam.apache.org

Build failed in Jenkins: beam_PreCommit_SQL_Java11_Cron #3983

Posted by Apache Jenkins Server <je...@builds.apache.org>.
See <https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/3983/display/redirect>

Changes:


------------------------------------------
[...truncated 304.30 KB...]
    java.lang.IllegalArgumentException at TextTableProviderTest.java:205

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testJson FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:224

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testWriteCsv FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:282

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testWriteJson FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:301

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testExplicitCsv FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:152

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testExplicitCsvExcel FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:180

org.apache.beam.sdk.extensions.sql.meta.provider.text.TextTableProviderTest > testLegacyTdfCsv FAILED
    java.lang.IllegalArgumentException at TextTableProviderTest.java:127

715 tests completed, 455 failed, 8 skipped

> Task :sdks:java:extensions:sql:test FAILED
> Task :runners:flink:1.15:job-server:distZip

> Task :sdks:java:extensions:sql:runBasicExample
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-jdk14/1.7.30/d35953dd2fe54ebe39fdf18cfd82fe6eb35b25ed/slf4j-jdk14-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-reload4j/1.7.36/db708f7d959dee1857ac524636e85ecf2e1781c1/slf4j-reload4j-1.7.36.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-log4j12/1.7.30/c21f55139d8141d2231214fb1feaf50a1edca95e/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.JDK14LoggerFactory]
Feb 19, 2023 10:39:17 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `PCOLLECTION`.`c1`, `PCOLLECTION`.`c2`, `PCOLLECTION`.`c3`
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`
WHERE `PCOLLECTION`.`c1` > 1
Feb 19, 2023 10:39:17 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(c1=[$0], c2=[$1], c3=[$2])
  LogicalFilter(condition=[>($0, 1)])
    BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 19, 2023 10:39:17 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..2=[{inputs}], expr#3=[1], expr#4=[>($t0, $t3)], proj#0..2=[{exprs}], $condition=[$t4])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 19, 2023 10:39:18 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `CASE1_RESULT`.`c2`, SUM(`CASE1_RESULT`.`c3`)
FROM `beam`.`CASE1_RESULT` AS `CASE1_RESULT`
GROUP BY `CASE1_RESULT`.`c2`
Feb 19, 2023 10:39:18 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalAggregate(group=[{0}], EXPR$1=[SUM($1)])
  LogicalProject(c2=[$1], c3=[$2])
    BeamIOSourceRel(table=[[beam, CASE1_RESULT]])

Feb 19, 2023 10:39:18 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamAggregationRel(group=[{1}], EXPR$1=[SUM($2)])
  BeamIOSourceRel(table=[[beam, CASE1_RESULT]])

Feb 19, 2023 10:39:18 AM org.apache.beam.sdk.Pipeline validate
WARNING: The following transforms do not have stable unique names: log_result, SqlTransform
PCOLLECTION: [3, row, 3.0]
PCOLLECTION: [2, row, 2.0]
CASE1_RESULT: [row, 5.0]

> Task :sdks:java:extensions:sql:runPojoExample
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-jdk14/1.7.30/d35953dd2fe54ebe39fdf18cfd82fe6eb35b25ed/slf4j-jdk14-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-reload4j/1.7.36/db708f7d959dee1857ac524636e85ecf2e1781c1/slf4j-reload4j-1.7.36.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-log4j12/1.7.30/c21f55139d8141d2231214fb1feaf50a1edca95e/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.JDK14LoggerFactory]
Feb 19, 2023 10:39:25 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `PCOLLECTION`.`id`, `PCOLLECTION`.`name`
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`
WHERE `PCOLLECTION`.`countryOfResidence` = 'Wonderland'
Feb 19, 2023 10:39:26 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(id=[$1], name=[$0])
  LogicalFilter(condition=[=($2, 'Wonderland')])
    BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 19, 2023 10:39:26 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..2=[{inputs}], expr#3=['Wonderland':VARCHAR], expr#4=[=($t2, $t3)], id=[$t1], name=[$t0], $condition=[$t4])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 19, 2023 10:39:26 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT COUNT(`PCOLLECTION`.`id`)
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`
Feb 19, 2023 10:39:26 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalAggregate(group=[{}], EXPR$0=[COUNT()])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 19, 2023 10:39:27 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamAggregationRel(group=[{}], EXPR$0=[COUNT()])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

Feb 19, 2023 10:39:27 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `customers`.`name`, 'order id:' || CAST(`orders`.`id` AS VARCHAR)
FROM `beam`.`orders` AS `orders`
INNER JOIN `beam`.`customers` AS `customers` ON `orders`.`customerId` = `customers`.`id`
WHERE `customers`.`name` = 'Grault'
Feb 19, 2023 10:39:27 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(name=[$2], EXPR$1=[||('order id:', CAST($0):VARCHAR NOT NULL)])
  LogicalFilter(condition=[=($2, 'Grault')])
    LogicalJoin(condition=[=($1, $3)], joinType=[inner])
      BeamIOSourceRel(table=[[beam, orders]])
      BeamIOSourceRel(table=[[beam, customers]])


> Task :sdks:java:extensions:sql:shell:distZip

> Task :sdks:java:extensions:sql:runPojoExample
Feb 19, 2023 10:39:27 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..4=[{inputs}], expr#5=['order id:'], expr#6=[CAST($t0):VARCHAR NOT NULL], expr#7=[||($t5, $t6)], name=[$t2], EXPR$1=[$t7])
  BeamCoGBKJoinRel(condition=[=($1, $3)], joinType=[inner])
    BeamIOSourceRel(table=[[beam, orders]])
    BeamCalcRel(expr#0..2=[{inputs}], expr#3=['Grault':VARCHAR], expr#4=[=($t0, $t3)], proj#0..2=[{exprs}], $condition=[$t4])
      BeamIOSourceRel(table=[[beam, customers]])

Feb 19, 2023 10:39:27 AM org.apache.beam.sdk.Pipeline validate
WARNING: The following transforms do not have stable unique names: Create.Values, MapElements, SqlTransform
[1, Foo]: is from Wonderland
[3, Baz]: is from Wonderland
[4, Grault]: is from Wonderland
[3]: total customers in Wonderland
[Grault, order id:8]: ordered by 'Grault'
[Grault, order id:7]: ordered by 'Grault'

> Task :sdks:java:extensions:sql:shell:assemble
> Task :sdks:java:extensions:sql:shell:analyzeClassesDependencies FROM-CACHE
> Task :sdks:java:extensions:sql:shell:analyzeDependencies UP-TO-DATE
> Task :sdks:java:extensions:sql:shell:test NO-SOURCE
> Task :sdks:java:extensions:sql:shell:check UP-TO-DATE
> Task :sdks:java:extensions:sql:shell:build
> Task :sdks:java:extensions:sql:shell:buildDependents
> Task :runners:flink:1.13:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.12:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.14:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.15:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.13:job-server:startShadowScripts
> Task :runners:flink:1.12:job-server:startShadowScripts
> Task :runners:flink:1.13:job-server:shadowDistTar
> Task :runners:flink:1.12:job-server:shadowDistTar
> Task :runners:flink:1.14:job-server:startShadowScripts
> Task :runners:flink:1.15:job-server:startShadowScripts
> Task :runners:flink:1.14:job-server:shadowDistTar
> Task :runners:flink:1.15:job-server:shadowDistTar
> Task :runners:flink:1.13:job-server:shadowDistZip
> Task :runners:flink:1.13:job-server:assemble
> Task :runners:flink:1.13:job-server:test NO-SOURCE
> Task :runners:flink:1.13:job-server:check UP-TO-DATE
> Task :runners:flink:1.13:job-server:build
> Task :runners:flink:1.13:job-server:buildDependents
> Task :runners:flink:1.12:job-server:shadowDistZip
> Task :runners:flink:1.12:job-server:assemble
> Task :runners:flink:1.12:job-server:test NO-SOURCE
> Task :runners:flink:1.12:job-server:check UP-TO-DATE
> Task :runners:flink:1.12:job-server:build
> Task :runners:flink:1.12:job-server:buildDependents
> Task :runners:flink:1.14:job-server:shadowDistZip
> Task :runners:flink:1.14:job-server:assemble
> Task :runners:flink:1.14:job-server:test NO-SOURCE
> Task :runners:flink:1.14:job-server:check UP-TO-DATE
> Task :runners:flink:1.14:job-server:build
> Task :runners:flink:1.14:job-server:buildDependents
> Task :runners:flink:1.15:job-server:shadowDistZip
> Task :runners:flink:1.15:job-server:assemble
> Task :runners:flink:1.15:job-server:test NO-SOURCE
> Task :runners:flink:1.15:job-server:check UP-TO-DATE
> Task :runners:flink:1.15:job-server:build
> Task :runners:flink:1.15:job-server:buildDependents
> Task :sdks:java:extensions:sql:expansion-service:buildDependents

FAILURE: Build completed with 4 failures.

1: Task failed with an exception.
-----------
* What went wrong:
Execution failed for task ':sdks:java:extensions:sql:jdbc:test'.
> There were failing tests. See the report at: file://<https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/ws/src/sdks/java/extensions/sql/jdbc/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.
==============================================================================

2: Task failed with an exception.
-----------
* What went wrong:
Execution failed for task ':sdks:java:extensions:sql:zetasql:test'.
> There were failing tests. See the report at: file://<https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/ws/src/sdks/java/extensions/sql/zetasql/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.
==============================================================================

3: Task failed with an exception.
-----------
* What went wrong:
Execution failed for task ':sdks:java:testing:nexmark:test'.
> There were failing tests. See the report at: file://<https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/ws/src/sdks/java/testing/nexmark/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.
==============================================================================

4: Task failed with an exception.
-----------
* What went wrong:
Execution failed for task ':sdks:java:extensions:sql:test'.
> There were failing tests. See the report at: file://<https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/ws/src/sdks/java/extensions/sql/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.
==============================================================================

* 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.5.1/userguide/command_line_interface.html#sec:command_line_warnings

BUILD FAILED in 3m 3s
256 actionable tasks: 139 executed, 117 from cache

Publishing build scan...
https://gradle.com/s/3npvnq2waaue4

Build step 'Invoke Gradle script' changed build result to FAILURE
Build step 'Invoke Gradle script' marked build as failure

---------------------------------------------------------------------
To unsubscribe, e-mail: builds-unsubscribe@beam.apache.org
For additional commands, e-mail: builds-help@beam.apache.org