You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Kevin Risden (JIRA)" <ji...@apache.org> on 2018/11/07 21:43:00 UTC
[jira] [Comment Edited] (CALCITE-2660) OsAdapterTest should check
if required commands are available
[ https://issues.apache.org/jira/browse/CALCITE-2660?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16678816#comment-16678816 ]
Kevin Risden edited comment on CALCITE-2660 at 11/7/18 9:42 PM:
----------------------------------------------------------------
For reference the failures from [https://travis-ci.org/apache/calcite/jobs/452098457:]
{code:java}
[[1;34mINFO[m] Running org.apache.calcite.adapter.os.[1mOsAdapterTest[m
SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
[[1;31mERROR[m] [1;31mTests [0;1mrun: [0;1m12[m, [1;31mFailures: [0;1;31m1[m, [1;31mErrors: [0;1;31m4[m, Skipped: 0, Time elapsed: 5.697 s[1;31m <<< FAILURE![m - in org.apache.calcite.adapter.os.[1mOsAdapterTest[m
[[1;31mERROR[m] testGitCommits(org.apache.calcite.adapter.os.OsAdapterTest) Time elapsed: 2.617 s <<< ERROR!
java.lang.RuntimeException: exception while executing [select count(*) from git_commits]
at org.apache.calcite.adapter.os.OsAdapterTest.testGitCommits(OsAdapterTest.java:167)
Caused by: java.lang.RuntimeException: With materializationsEnabled=false, limit=0
at org.apache.calcite.adapter.os.OsAdapterTest.testGitCommits(OsAdapterTest.java:167)
Caused by: java.sql.SQLException: Error while executing SQL "select count(*) from git_commits": while creating process: [git, log, --pretty=raw]
at org.apache.calcite.adapter.os.OsAdapterTest.testGitCommits(OsAdapterTest.java:167)
Caused by: java.lang.RuntimeException: while creating process: [git, log, --pretty=raw]
at org.apache.calcite.adapter.os.OsAdapterTest.testGitCommits(OsAdapterTest.java:167)
Caused by: java.io.IOException: Cannot run program "git": error=2, No such file or directory
at org.apache.calcite.adapter.os.OsAdapterTest.testGitCommits(OsAdapterTest.java:167)
Caused by: java.io.IOException: error=2, No such file or directory
at org.apache.calcite.adapter.os.OsAdapterTest.testGitCommits(OsAdapterTest.java:167)
[[1;31mERROR[m] testGitCommitsTop(org.apache.calcite.adapter.os.OsAdapterTest) Time elapsed: 0.481 s <<< ERROR!
java.lang.RuntimeException:
exception while executing [select author from git_commits
group by 1 order by count(*) desc limit 2]
at org.apache.calcite.adapter.os.OsAdapterTest.testGitCommitsTop(OsAdapterTest.java:182)
Caused by: java.lang.RuntimeException: With materializationsEnabled=false, limit=0
at org.apache.calcite.adapter.os.OsAdapterTest.testGitCommitsTop(OsAdapterTest.java:182)
Caused by: java.sql.SQLException:
Error while executing SQL "select author from git_commits
group by 1 order by count(*) desc limit 2": while creating process: [git, log, --pretty=raw]
at org.apache.calcite.adapter.os.OsAdapterTest.testGitCommitsTop(OsAdapterTest.java:182)
Caused by: java.lang.RuntimeException: while creating process: [git, log, --pretty=raw]
at org.apache.calcite.adapter.os.OsAdapterTest.testGitCommitsTop(OsAdapterTest.java:182)
Caused by: java.io.IOException: Cannot run program "git": error=2, No such file or directory
at org.apache.calcite.adapter.os.OsAdapterTest.testGitCommitsTop(OsAdapterTest.java:182)
Caused by: java.io.IOException: error=2, No such file or directory
at org.apache.calcite.adapter.os.OsAdapterTest.testGitCommitsTop(OsAdapterTest.java:182)
[[1;31mERROR[m] testPs(org.apache.calcite.adapter.os.OsAdapterTest) Time elapsed: 0.305 s <<< ERROR!
java.lang.RuntimeException: exception while executing [select * from ps]
at org.apache.calcite.adapter.os.OsAdapterTest.testPs(OsAdapterTest.java:133)
Caused by: java.lang.RuntimeException: With materializationsEnabled=false, limit=0
at org.apache.calcite.adapter.os.OsAdapterTest.testPs(OsAdapterTest.java:133)
Caused by: java.sql.SQLException: Error while executing SQL "select * from ps": while creating process: [ps, --no-headers, axo, ppid,pid,pgrp,tpgid,stat,user,pcpu,pmem,vsz,rss,tty,start_time,time,euid,ruid,sess,comm]
at org.apache.calcite.adapter.os.OsAdapterTest.testPs(OsAdapterTest.java:133)
Caused by: java.lang.RuntimeException: while creating process: [ps, --no-headers, axo, ppid,pid,pgrp,tpgid,stat,user,pcpu,pmem,vsz,rss,tty,start_time,time,euid,ruid,sess,comm]
at org.apache.calcite.adapter.os.OsAdapterTest.testPs(OsAdapterTest.java:133)
Caused by: java.io.IOException: Cannot run program "ps": error=2, No such file or directory
at org.apache.calcite.adapter.os.OsAdapterTest.testPs(OsAdapterTest.java:133)
Caused by: java.io.IOException: error=2, No such file or directory
at org.apache.calcite.adapter.os.OsAdapterTest.testPs(OsAdapterTest.java:133)
[[1;31mERROR[m] testPsDistinct(org.apache.calcite.adapter.os.OsAdapterTest) Time elapsed: 0.061 s <<< ERROR!
java.lang.RuntimeException: exception while executing [select distinct `user` from ps]
at org.apache.calcite.adapter.os.OsAdapterTest.testPsDistinct(OsAdapterTest.java:153)
Caused by: java.lang.RuntimeException: With materializationsEnabled=false, limit=0
at org.apache.calcite.adapter.os.OsAdapterTest.testPsDistinct(OsAdapterTest.java:153)
Caused by: java.sql.SQLException: Error while executing SQL "select distinct `user` from ps": while creating process: [ps, --no-headers, axo, ppid,pid,pgrp,tpgid,stat,user,pcpu,pmem,vsz,rss,tty,start_time,time,euid,ruid,sess,comm]
at org.apache.calcite.adapter.os.OsAdapterTest.testPsDistinct(OsAdapterTest.java:153)
Caused by: java.lang.RuntimeException: while creating process: [ps, --no-headers, axo, ppid,pid,pgrp,tpgid,stat,user,pcpu,pmem,vsz,rss,tty,start_time,time,euid,ruid,sess,comm]
at org.apache.calcite.adapter.os.OsAdapterTest.testPsDistinct(OsAdapterTest.java:153)
Caused by: java.io.IOException: Cannot run program "ps": error=2, No such file or directory
at org.apache.calcite.adapter.os.OsAdapterTest.testPsDistinct(OsAdapterTest.java:153)
Caused by: java.io.IOException: error=2, No such file or directory
at org.apache.calcite.adapter.os.OsAdapterTest.testPsDistinct(OsAdapterTest.java:153)
[[1;31mERROR[m] testVmstat(org.apache.calcite.adapter.os.OsAdapterTest) Time elapsed: 0.164 s <<< FAILURE!
java.lang.AssertionError:
Expected: is <true>
but: was <false>
at org.apache.calcite.adapter.os.OsAdapterTest.lambda$testVmstat$6(OsAdapterTest.java:192)
at org.apache.calcite.adapter.os.OsAdapterTest.testVmstat(OsAdapterTest.java:190)
[[1;34mINFO[m] Running org.apache.calcite.chinook.[1mEndToEndTest[m
Nov 07, 2018 5:17:20 PM org.hsqldb.persist.Logger logInfoEvent
INFO: open start - state modified
Nov 07, 2018 5:17:21 PM org.hsqldb.persist.Logger logInfoEvent
INFO: Checkpoint start
Nov 07, 2018 5:17:21 PM org.hsqldb.persist.Logger logInfoEvent
INFO: Checkpoint end - txts: 54
[[1;34mINFO[m] [1;32mTests run: [0;1;32m4[m, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 4.683 s - in org.apache.calcite.chinook.[1mEndToEndTest[m
[[1;34mINFO[m]
[[1;34mINFO[m] Results:
[[1;34mINFO[m]
[[1;31mERROR[m] [1;31mFailures: [m
[[1;31mERROR[m] [1;31m OsAdapterTest.testVmstat:190->lambda$testVmstat$6:192
Expected: is <true>
but: was <false>[m
[[1;31mERROR[m] [1;31mErrors: [m
[[1;31mERROR[m] [1;31m OsAdapterTest.testGitCommits:167 ? Runtime exception while executing [select c...[m
[[1;31mERROR[m] [1;31m OsAdapterTest.testGitCommitsTop:182 ? Runtime exception while executing [selec...[m
[[1;31mERROR[m] [1;31m OsAdapterTest.testPs:133 ? Runtime exception while executing [select * from ps...[m
[[1;31mERROR[m] [1;31m OsAdapterTest.testPsDistinct:153 ? Runtime exception while executing [select d...[m
[[1;34mINFO[m]
[[1;31mERROR[m] [1;31mTests run: 56, Failures: 1, Errors: 4, Skipped: 21[m{code}
was (Author: risdenk):
For reference the failures from https://travis-ci.org/apache/calcite/jobs/452098457:
{code:java}
[[1;34mINFO[m] -------------------------------------------------------
[[1;34mINFO[m] T E S T S
[[1;34mINFO[m] -------------------------------------------------------
[[1;34mINFO[m] Running org.apache.calcite.adapter.tpcds.[1mTpcdsTest[m
LogicalSort(sort0=[$1], sort1=[$0], dir0=[ASC], dir1=[ASC], fetch=[100])
LogicalAggregate(group=[{84, 90}], AGG1=[AVG($10)], AGG2=[AVG($12)], AGG3=[AVG($19)], AGG4=[AVG($13)])
LogicalFilter(condition=[AND(=($0, $32), =($2, $89), =($7, $60), =($4, $23), =($24, 'M'), =($25, 'S'), =($26, 'HIGH SCHOOL'), =($38, 1998), IN($84, ARRAY('CA', 'OR', 'WA', 'TX', 'OK', 'MD')))])
LogicalJoin(condition=[true], joinType=[inner])
LogicalTableScan(table=[[TPCDS, STORE_SALES]])
LogicalJoin(condition=[true], joinType=[inner])
LogicalTableScan(table=[[TPCDS, CUSTOMER_DEMOGRAPHICS]])
LogicalJoin(condition=[true], joinType=[inner])
LogicalTableScan(table=[[TPCDS, DATE_DIM]])
LogicalJoin(condition=[true], joinType=[inner])
LogicalTableScan(table=[[TPCDS, STORE]])
LogicalTableScan(table=[[TPCDS, ITEM]])
[[1;33mWARNING[m] [1;33mTests [0;1mrun: [0;1m11[m, Failures: 0, Errors: 0, [1;33mSkipped: [0;1;33m7[m, Time elapsed: 0.3 s - in org.apache.calcite.adapter.tpcds.[1mTpcdsTest[m
[[1;34mINFO[m] Running org.apache.calcite.adapter.tpch.[1mTpchTest[m
[[1;33mWARNING[m] [1;33mTests [0;1mrun: [0;1m29[m, Failures: 0, Errors: 0, [1;33mSkipped: [0;1;33m14[m, Time elapsed: 0.016 s - in org.apache.calcite.adapter.tpch.[1mTpchTest[m
[[1;34mINFO[m] Running org.apache.calcite.adapter.os.[1mOsAdapterTest[m
SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
[[1;31mERROR[m] [1;31mTests [0;1mrun: [0;1m12[m, [1;31mFailures: [0;1;31m1[m, [1;31mErrors: [0;1;31m4[m, Skipped: 0, Time elapsed: 5.697 s[1;31m <<< FAILURE![m - in org.apache.calcite.adapter.os.[1mOsAdapterTest[m
[[1;31mERROR[m] testGitCommits(org.apache.calcite.adapter.os.OsAdapterTest) Time elapsed: 2.617 s <<< ERROR!
java.lang.RuntimeException: exception while executing [select count(*) from git_commits]
at org.apache.calcite.adapter.os.OsAdapterTest.testGitCommits(OsAdapterTest.java:167)
Caused by: java.lang.RuntimeException: With materializationsEnabled=false, limit=0
at org.apache.calcite.adapter.os.OsAdapterTest.testGitCommits(OsAdapterTest.java:167)
Caused by: java.sql.SQLException: Error while executing SQL "select count(*) from git_commits": while creating process: [git, log, --pretty=raw]
at org.apache.calcite.adapter.os.OsAdapterTest.testGitCommits(OsAdapterTest.java:167)
Caused by: java.lang.RuntimeException: while creating process: [git, log, --pretty=raw]
at org.apache.calcite.adapter.os.OsAdapterTest.testGitCommits(OsAdapterTest.java:167)
Caused by: java.io.IOException: Cannot run program "git": error=2, No such file or directory
at org.apache.calcite.adapter.os.OsAdapterTest.testGitCommits(OsAdapterTest.java:167)
Caused by: java.io.IOException: error=2, No such file or directory
at org.apache.calcite.adapter.os.OsAdapterTest.testGitCommits(OsAdapterTest.java:167)
[[1;31mERROR[m] testGitCommitsTop(org.apache.calcite.adapter.os.OsAdapterTest) Time elapsed: 0.481 s <<< ERROR!
java.lang.RuntimeException:
exception while executing [select author from git_commits
group by 1 order by count(*) desc limit 2]
at org.apache.calcite.adapter.os.OsAdapterTest.testGitCommitsTop(OsAdapterTest.java:182)
Caused by: java.lang.RuntimeException: With materializationsEnabled=false, limit=0
at org.apache.calcite.adapter.os.OsAdapterTest.testGitCommitsTop(OsAdapterTest.java:182)
Caused by: java.sql.SQLException:
Error while executing SQL "select author from git_commits
group by 1 order by count(*) desc limit 2": while creating process: [git, log, --pretty=raw]
at org.apache.calcite.adapter.os.OsAdapterTest.testGitCommitsTop(OsAdapterTest.java:182)
Caused by: java.lang.RuntimeException: while creating process: [git, log, --pretty=raw]
at org.apache.calcite.adapter.os.OsAdapterTest.testGitCommitsTop(OsAdapterTest.java:182)
Caused by: java.io.IOException: Cannot run program "git": error=2, No such file or directory
at org.apache.calcite.adapter.os.OsAdapterTest.testGitCommitsTop(OsAdapterTest.java:182)
Caused by: java.io.IOException: error=2, No such file or directory
at org.apache.calcite.adapter.os.OsAdapterTest.testGitCommitsTop(OsAdapterTest.java:182)
[[1;31mERROR[m] testPs(org.apache.calcite.adapter.os.OsAdapterTest) Time elapsed: 0.305 s <<< ERROR!
java.lang.RuntimeException: exception while executing [select * from ps]
at org.apache.calcite.adapter.os.OsAdapterTest.testPs(OsAdapterTest.java:133)
Caused by: java.lang.RuntimeException: With materializationsEnabled=false, limit=0
at org.apache.calcite.adapter.os.OsAdapterTest.testPs(OsAdapterTest.java:133)
Caused by: java.sql.SQLException: Error while executing SQL "select * from ps": while creating process: [ps, --no-headers, axo, ppid,pid,pgrp,tpgid,stat,user,pcpu,pmem,vsz,rss,tty,start_time,time,euid,ruid,sess,comm]
at org.apache.calcite.adapter.os.OsAdapterTest.testPs(OsAdapterTest.java:133)
Caused by: java.lang.RuntimeException: while creating process: [ps, --no-headers, axo, ppid,pid,pgrp,tpgid,stat,user,pcpu,pmem,vsz,rss,tty,start_time,time,euid,ruid,sess,comm]
at org.apache.calcite.adapter.os.OsAdapterTest.testPs(OsAdapterTest.java:133)
Caused by: java.io.IOException: Cannot run program "ps": error=2, No such file or directory
at org.apache.calcite.adapter.os.OsAdapterTest.testPs(OsAdapterTest.java:133)
Caused by: java.io.IOException: error=2, No such file or directory
at org.apache.calcite.adapter.os.OsAdapterTest.testPs(OsAdapterTest.java:133)
[[1;31mERROR[m] testPsDistinct(org.apache.calcite.adapter.os.OsAdapterTest) Time elapsed: 0.061 s <<< ERROR!
java.lang.RuntimeException: exception while executing [select distinct `user` from ps]
at org.apache.calcite.adapter.os.OsAdapterTest.testPsDistinct(OsAdapterTest.java:153)
Caused by: java.lang.RuntimeException: With materializationsEnabled=false, limit=0
at org.apache.calcite.adapter.os.OsAdapterTest.testPsDistinct(OsAdapterTest.java:153)
Caused by: java.sql.SQLException: Error while executing SQL "select distinct `user` from ps": while creating process: [ps, --no-headers, axo, ppid,pid,pgrp,tpgid,stat,user,pcpu,pmem,vsz,rss,tty,start_time,time,euid,ruid,sess,comm]
at org.apache.calcite.adapter.os.OsAdapterTest.testPsDistinct(OsAdapterTest.java:153)
Caused by: java.lang.RuntimeException: while creating process: [ps, --no-headers, axo, ppid,pid,pgrp,tpgid,stat,user,pcpu,pmem,vsz,rss,tty,start_time,time,euid,ruid,sess,comm]
at org.apache.calcite.adapter.os.OsAdapterTest.testPsDistinct(OsAdapterTest.java:153)
Caused by: java.io.IOException: Cannot run program "ps": error=2, No such file or directory
at org.apache.calcite.adapter.os.OsAdapterTest.testPsDistinct(OsAdapterTest.java:153)
Caused by: java.io.IOException: error=2, No such file or directory
at org.apache.calcite.adapter.os.OsAdapterTest.testPsDistinct(OsAdapterTest.java:153)
[[1;31mERROR[m] testVmstat(org.apache.calcite.adapter.os.OsAdapterTest) Time elapsed: 0.164 s <<< FAILURE!
java.lang.AssertionError:
Expected: is <true>
but: was <false>
at org.apache.calcite.adapter.os.OsAdapterTest.lambda$testVmstat$6(OsAdapterTest.java:192)
at org.apache.calcite.adapter.os.OsAdapterTest.testVmstat(OsAdapterTest.java:190)
[[1;34mINFO[m] Running org.apache.calcite.chinook.[1mEndToEndTest[m
Nov 07, 2018 5:17:20 PM org.hsqldb.persist.Logger logInfoEvent
INFO: open start - state modified
Nov 07, 2018 5:17:21 PM org.hsqldb.persist.Logger logInfoEvent
INFO: Checkpoint start
Nov 07, 2018 5:17:21 PM org.hsqldb.persist.Logger logInfoEvent
INFO: Checkpoint end - txts: 54
[[1;34mINFO[m] [1;32mTests run: [0;1;32m4[m, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 4.683 s - in org.apache.calcite.chinook.[1mEndToEndTest[m
[[1;34mINFO[m]
[[1;34mINFO[m] Results:
[[1;34mINFO[m]
[[1;31mERROR[m] [1;31mFailures: [m
[[1;31mERROR[m] [1;31m OsAdapterTest.testVmstat:190->lambda$testVmstat$6:192
Expected: is <true>
but: was <false>[m
[[1;31mERROR[m] [1;31mErrors: [m
[[1;31mERROR[m] [1;31m OsAdapterTest.testGitCommits:167 ? Runtime exception while executing [select c...[m
[[1;31mERROR[m] [1;31m OsAdapterTest.testGitCommitsTop:182 ? Runtime exception while executing [selec...[m
[[1;31mERROR[m] [1;31m OsAdapterTest.testPs:133 ? Runtime exception while executing [select * from ps...[m
[[1;31mERROR[m] [1;31m OsAdapterTest.testPsDistinct:153 ? Runtime exception while executing [select d...[m
[[1;34mINFO[m]
[[1;31mERROR[m] [1;31mTests run: 56, Failures: 1, Errors: 4, Skipped: 21[m{code}
> OsAdapterTest should check if required commands are available
> -------------------------------------------------------------
>
> Key: CALCITE-2660
> URL: https://issues.apache.org/jira/browse/CALCITE-2660
> Project: Calcite
> Issue Type: Improvement
> Reporter: Kevin Risden
> Assignee: Julian Hyde
> Priority: Minor
> Fix For: 1.18.0
>
>
> Found via CALCITE-2655, OsAdapterTest assumes that ps and git are installed. This should be checked. Once OsAdapterTest is fixed, allow_failures should be removed from .travis.yml for jdk 12.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)