trafodion-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Eric Owhadi <eric.owh...@esgyn.com>
Subject on PR 255 jenkins arrors out on CORE/TESTRTS
Date Fri, 15 Jan 2016 18:00:43 GMT
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;

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message