You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@trafodion.apache.org by Eric Owhadi <er...@esgyn.com> on 2016/01/15 19:00:43 UTC

on PR 255 jenkins arrors out on CORE/TESTRTS

Not sure how to handle this.

Core/TESTRTS works fine on my build, but Jenkins is giving an error with
following DIFF:

Is it a known problem? BTW, a previews run worked OK…

Thanks in advance for the help,
Eric





3420,3637d3419

< 1c1,2

< < >>get statistics for qid current;

< ---

< > >>obey STATS_CMD_QID;

< > >>get statistics for qid @QID@;

< 21c22

< < Number of Cpus @numberofcpus@

< ---

< > Number of Cpus @numberofcpus@

< 34a36,48

< > Table Name

< > Records Accessed Records Used HBase/Hive HBase/Hive HBase/Hive IO
HBase/Hive IO

< > Estimated/Actual Estimated/Actual IOs IO MBytes Sum Time Max Time

< > #CAT.#SCH.TSTATI pertableStats> 0 100

< > 0 0 0 0 0 0

< > #CAT.#SCH.TSTATI

< > 0 100

< > 0 0 0 0 0 0

< > #CAT.#SCH.TSTATI pertableStats> 0 100

< > 0 0 0 0 0 0

< >

< >>

< >>

< >>control query default detailed_statistics 'PERTABLE' ;

<

< --- SQL operation complete.

< >>obey TESTRTS(compare_current_qid);

< >>prepare s1 from select count(*) from

< +>tstat A, tstat B, tstat C, tstat D;

<

< --- SQL command prepared.

< >>

< >>execute s1;

<

< (EXPR)

< ----------

<

<  256

<

< --- 1 row(s) selected.

< >>

< >>log;

< >>sh grep "^QID is " QID_TEMP | cut -c 8- | sed "s/^/get statistics for
qid /g" | sed "s/$/;/g" > STATS_CMD_QID;

< >>log;

< 1c1,2

< < >>get statistics for qid current;

< ---

< > >>obey STATS_CMD_QID;

< > >>get statistics for qid @QID@;

< 21c22

< < Number of Cpus @numberofcpus@

< ---

< > Number of Cpus @numberofcpus@

< >>

< >>

< >>control query default detailed_statistics 'system' ;

<

< --- SQL operation complete.

< >>obey TESTRTS(compare_current_qid);

< >>prepare s1 from select count(*) from

< +>tstat A, tstat B, tstat C, tstat D;

<

< --- SQL command prepared.

< >>

< >>execute s1;

<

< (EXPR)

< ----------

<

<  256

<

< --- 1 row(s) selected.

< >>

< >>log;

< >>sh grep "^QID is " QID_TEMP | cut -c 8- | sed "s/^/get statistics for
qid /g" | sed "s/$/;/g" > STATS_CMD_QID;

< >>log;

< 1c1,2

< < >>get statistics for qid current;

< ---

< > >>obey STATS_CMD_QID;

< > >>get statistics for qid @QID@;

< 21c22

< < Number of Cpus @numberofcpus@

< ---

< > Number of Cpus @numberofcpus@

< >>

< >>

< >>obey TESTRTS(exeindp2_stats);

<

< *** ERROR[15014] Section exeindp2_stats was not found in file TESTRTS.

<

< >>--Negative tests using STATISTICS stored procedure

< >>select * from table (statistics(null, 'QID='));

<

< --- 0 row(s) selected.

< >>select * from table (statistics(null, 'QID=mxid'));

<

< *** ERROR[8919] Unable to retrieve Runtime Statistics for invalid Query
Id mxid.

<

< --- 0 row(s) selected.

< >>select * from table (statistics(null, 'QID=MXID01001'));

<

< *** ERROR[8919] Unable to retrieve Runtime Statistics for invalid Query
Id @QID@.

<

< --- 0 row(s) selected.

< >>select * from table (statistics(null, 'CPU='));

<

< --- 0 row(s) selected.

< >>select * from table (statistics(null, 'PID='));

<

< *** ERROR[8920] Invalid CPU or PID passed in. Unable to retrieve Runtime
Statistics.

<

< --- 0 row(s) selected.

< >>select * from table (statistics(null, 'SYSTEM='));

<

< --- 0 row(s) selected.

< >>select * from table (statistics(null, 'MERGE=2'));

<

< --- 0 row(s) selected.

< >>

< >>--Negative tests using GET STATISTICS command

< >>get statistics for qid ;

<

< *** ERROR[15001] A syntax error occurred at or before:

< get statistics for qid ;

<  ^ (zzz characters from start of SQL statement)

<

< *** ERROR[8822] The statement was not prepared.

<

< >>get statistics for qid mxid ;

<

< *** ERROR[8919] Unable to retrieve Runtime Statistics for invalid Query
Id @QID@.

<

< --- SQL operation failed with errors.

< >>get statistics for qid "mxid" ;

<

< *** ERROR[8919] Unable to retrieve Runtime Statistics for invalid Query
Id mxid.

<

< --- SQL operation failed with errors.

< >>get statistics for qid mxid01001 ;

<

< *** ERROR[8919] Unable to retrieve Runtime Statistics for invalid Query
Id @QID@.

<

< --- SQL operation failed with errors.

< >>get statistics for qid mxid0100202 ;

<

< *** ERROR[8919] Unable to retrieve Runtime Statistics for invalid Query
Id @QID@.

<

< --- SQL operation failed with errors.

< >>get statistics for qid mxid010010A0788 ;

<

< *** ERROR[8919] Unable to retrieve Runtime Statistics for invalid Query
Id @QID@.

<

< --- SQL operation failed with errors.

< >>get statistics for qid mxid01002020880 ;

<

< *** ERROR[8919] Unable to retrieve Runtime Statistics for invalid Query
Id @QID@.

<

< --- SQL operation failed with errors.

< >>get statistics for cpu ;

<

< *** ERROR[15001] A syntax error occurred at or before:

< get statistics for cpu ;

<  ^ (zzz characters from start of SQL statement)

<

< *** ERROR[8822] The statement was not prepared.

<

< >>get statistics for cpu a;

<

< *** ERROR[15001] A syntax error occurred at or before:

< get statistics for cpu a;

<  ^ (zzz characters from start of SQL statement)

<

< *** ERROR[8822] The statement was not prepared.

<

< >>get statistics for cpu "A";

<

< *** ERROR[15001] A syntax error occurred at or before:

< get statistics for cpu "A";

<  ^ (zzz characters from start of SQL statement)

<

< *** ERROR[8822] The statement was not prepared.

<

< >>get statistics for pid ;

<

< *** ERROR[15001] A syntax error occurred at or before:

< get statistics for pid ;

<  ^ (zzz characters from start of SQL statement)

<

< *** ERROR[8822] The statement was not prepared.

<

< >>get statistics for pid a,a ;

<

< *** ERROR[15001] A syntax error occurred at or before:

< get statistics for pid a,a ;

<  ^ (zzz characters from start of SQL statement)

<

< *** ERROR[8822] The statement was not prepared.

<

< >>get statistics for pid a;

<

< *** ERROR[15001] A syntax error occurred at or before:

< get statistics for pid a;

<  ^ (zzz characters from start of SQL statement)

<

< *** ERROR[8822] The statement was not prepared.

<

< >>

< >>-- Test to determine if invalid token is taken as stmt name

< >>select * from table (statistics(null, 'AAA='));

<

< --- 0 row(s) selected.

< >>obey TESTRTS(clean_up);

< >>drop table tstat;

<

< --- SQL operation complete.

< >>

< >>log;

RE: on PR 255 jenkins arrors out on CORE/TESTRTS

Posted by Dave Birdsall <da...@esgyn.com>.

Looks like some stuff is missing from the end of the test run. Can't tell
why. Maybe environmental? Could try a retest.

-----Original Message-----
From: Eric Owhadi [mailto:eric.owhadi@esgyn.com]
Sent: Friday, January 15, 2016 10:01 AM
To: dev@trafodion.incubator.apache.org
Subject: on PR 255 jenkins arrors out on CORE/TESTRTS

Not sure how to handle this.

Core/TESTRTS works fine on my build, but Jenkins is giving an error with
following DIFF:

Is it a known problem? BTW, a previews run worked OK…

Thanks in advance for the help,
Eric





3420,3637d3419

< 1c1,2

< < >>get statistics for qid current;

< ---

< > >>obey STATS_CMD_QID;

< > >>get statistics for qid @QID@;

< 21c22

< < Number of Cpus @numberofcpus@

< ---

< > Number of Cpus @numberofcpus@

< 34a36,48

< > Table Name

< > Records Accessed Records Used HBase/Hive HBase/Hive HBase/Hive IO
HBase/Hive IO

< > Estimated/Actual Estimated/Actual IOs IO MBytes Sum Time Max Time

< > #CAT.#SCH.TSTATI pertableStats> 0 100

< > 0 0 0 0 0 0

< > #CAT.#SCH.TSTATI

< > 0 100

< > 0 0 0 0 0 0

< > #CAT.#SCH.TSTATI pertableStats> 0 100

< > 0 0 0 0 0 0

< >

< >>

< >>

< >>control query default detailed_statistics 'PERTABLE' ;

<

< --- SQL operation complete.

< >>obey TESTRTS(compare_current_qid);

< >>prepare s1 from select count(*) from

< +>tstat A, tstat B, tstat C, tstat D;

<

< --- SQL command prepared.

< >>

< >>execute s1;

<

< (EXPR)

< ----------

<

<  256

<

< --- 1 row(s) selected.

< >>

< >>log;

< >>sh grep "^QID is " QID_TEMP | cut -c 8- | sed "s/^/get statistics for
qid /g" | sed "s/$/;/g" > STATS_CMD_QID;

< >>log;

< 1c1,2

< < >>get statistics for qid current;

< ---

< > >>obey STATS_CMD_QID;

< > >>get statistics for qid @QID@;

< 21c22

< < Number of Cpus @numberofcpus@

< ---

< > Number of Cpus @numberofcpus@

< >>

< >>

< >>control query default detailed_statistics 'system' ;

<

< --- SQL operation complete.

< >>obey TESTRTS(compare_current_qid);

< >>prepare s1 from select count(*) from

< +>tstat A, tstat B, tstat C, tstat D;

<

< --- SQL command prepared.

< >>

< >>execute s1;

<

< (EXPR)

< ----------

<

<  256

<

< --- 1 row(s) selected.

< >>

< >>log;

< >>sh grep "^QID is " QID_TEMP | cut -c 8- | sed "s/^/get statistics for
qid /g" | sed "s/$/;/g" > STATS_CMD_QID;

< >>log;

< 1c1,2

< < >>get statistics for qid current;

< ---

< > >>obey STATS_CMD_QID;

< > >>get statistics for qid @QID@;

< 21c22

< < Number of Cpus @numberofcpus@

< ---

< > Number of Cpus @numberofcpus@

< >>

< >>

< >>obey TESTRTS(exeindp2_stats);

<

< *** ERROR[15014] Section exeindp2_stats was not found in file TESTRTS.

<

< >>--Negative tests using STATISTICS stored procedure

< >>select * from table (statistics(null, 'QID='));

<

< --- 0 row(s) selected.

< >>select * from table (statistics(null, 'QID=mxid'));

<

< *** ERROR[8919] Unable to retrieve Runtime Statistics for invalid Query Id
mxid.

<

< --- 0 row(s) selected.

< >>select * from table (statistics(null, 'QID=MXID01001'));

<

< *** ERROR[8919] Unable to retrieve Runtime Statistics for invalid Query Id
@QID@.

<

< --- 0 row(s) selected.

< >>select * from table (statistics(null, 'CPU='));

<

< --- 0 row(s) selected.

< >>select * from table (statistics(null, 'PID='));

<

< *** ERROR[8920] Invalid CPU or PID passed in. Unable to retrieve Runtime
Statistics.

<

< --- 0 row(s) selected.

< >>select * from table (statistics(null, 'SYSTEM='));

<

< --- 0 row(s) selected.

< >>select * from table (statistics(null, 'MERGE=2'));

<

< --- 0 row(s) selected.

< >>

< >>--Negative tests using GET STATISTICS command

< >>get statistics for qid ;

<

< *** ERROR[15001] A syntax error occurred at or before:

< get statistics for qid ;

<  ^ (zzz characters from start of SQL statement)

<

< *** ERROR[8822] The statement was not prepared.

<

< >>get statistics for qid mxid ;

<

< *** ERROR[8919] Unable to retrieve Runtime Statistics for invalid Query Id
@QID@.

<

< --- SQL operation failed with errors.

< >>get statistics for qid "mxid" ;

<

< *** ERROR[8919] Unable to retrieve Runtime Statistics for invalid Query Id
mxid.

<

< --- SQL operation failed with errors.

< >>get statistics for qid mxid01001 ;

<

< *** ERROR[8919] Unable to retrieve Runtime Statistics for invalid Query Id
@QID@.

<

< --- SQL operation failed with errors.

< >>get statistics for qid mxid0100202 ;

<

< *** ERROR[8919] Unable to retrieve Runtime Statistics for invalid Query Id
@QID@.

<

< --- SQL operation failed with errors.

< >>get statistics for qid mxid010010A0788 ;

<

< *** ERROR[8919] Unable to retrieve Runtime Statistics for invalid Query Id
@QID@.

<

< --- SQL operation failed with errors.

< >>get statistics for qid mxid01002020880 ;

<

< *** ERROR[8919] Unable to retrieve Runtime Statistics for invalid Query Id
@QID@.

<

< --- SQL operation failed with errors.

< >>get statistics for cpu ;

<

< *** ERROR[15001] A syntax error occurred at or before:

< get statistics for cpu ;

<  ^ (zzz characters from start of SQL statement)

<

< *** ERROR[8822] The statement was not prepared.

<

< >>get statistics for cpu a;

<

< *** ERROR[15001] A syntax error occurred at or before:

< get statistics for cpu a;

<  ^ (zzz characters from start of SQL statement)

<

< *** ERROR[8822] The statement was not prepared.

<

< >>get statistics for cpu "A";

<

< *** ERROR[15001] A syntax error occurred at or before:

< get statistics for cpu "A";

<  ^ (zzz characters from start of SQL statement)

<

< *** ERROR[8822] The statement was not prepared.

<

< >>get statistics for pid ;

<

< *** ERROR[15001] A syntax error occurred at or before:

< get statistics for pid ;

<  ^ (zzz characters from start of SQL statement)

<

< *** ERROR[8822] The statement was not prepared.

<

< >>get statistics for pid a,a ;

<

< *** ERROR[15001] A syntax error occurred at or before:

< get statistics for pid a,a ;

<  ^ (zzz characters from start of SQL statement)

<

< *** ERROR[8822] The statement was not prepared.

<

< >>get statistics for pid a;

<

< *** ERROR[15001] A syntax error occurred at or before:

< get statistics for pid a;

<  ^ (zzz characters from start of SQL statement)

<

< *** ERROR[8822] The statement was not prepared.

<

< >>

< >>-- Test to determine if invalid token is taken as stmt name

< >>select * from table (statistics(null, 'AAA='));

<

< --- 0 row(s) selected.

< >>obey TESTRTS(clean_up);

< >>drop table tstat;

<

< --- SQL operation complete.

< >>

< >>log;