You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2016/10/03 17:18:20 UTC
[jira] [Commented] (TRAFODION-2255) Regression test
compGeneral/TEST023 failure
[ https://issues.apache.org/jira/browse/TRAFODION-2255?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15542900#comment-15542900 ]
ASF GitHub Bot commented on TRAFODION-2255:
-------------------------------------------
GitHub user DaveBirdsall opened a pull request:
https://github.com/apache/incubator-trafodion/pull/738
[TRAFODION-2255] Fix off-by-one error in incremental update stats
This change fixes a problem that caused regression test compGeneral/TEST023 to fail. It turns out to be an example of both an off-by-one bug and a time-bomb bug. The bug only appears in October. If I had been fortunate enough to have added this test last October or before we would have seen this bug a year ago.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/DaveBirdsall/incubator-trafodion Trafodion2255
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafodion/pull/738.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #738
----
commit 8e65504e79e503ba14a5e626dcd2c6ac61360568
Author: Dave Birdsall <db...@apache.org>
Date: 2016-10-03T17:16:10Z
[TRAFODION-2255] Fix off-by-one error in incremental update stats
----
> Regression test compGeneral/TEST023 failure
> -------------------------------------------
>
> Key: TRAFODION-2255
> URL: https://issues.apache.org/jira/browse/TRAFODION-2255
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-cmp
> Affects Versions: 2.1-incubating
> Environment: All
> Reporter: David Wayne Birdsall
> Assignee: David Wayne Birdsall
>
> Regression test compGeneral/TEST023 has started failing with the following differences:
> 313c313,321
> < --- SQL operation complete.
> ---
> > *** ERROR[9200] UPDATE STATISTICS for table
> > TRAFODION.COMPGENERAL_TEST023.STEST encountered an error (3047) from
> > statement .
> >
> > *** ERROR[3047] The timestamp '2016-010-01 08:21:54' is not valid.
> >
> > *** ERROR[8822] The statement was not prepared.
> >
> > *** ERROR[9200] UPDATE STATISTICS for table
> > TRAFODION.COMPGENERAL_TEST023.STEST encountered an error from
> > statement updIUSUpdateInfo.
> >
> > --- SQL operation failed with errors.
> 320c328
> < STEST TRAFODION.COMPGENERAL_TEST023.TRAF_SAMPLE_nn_nnnnnnnnnn_nnnnnn I c1
> >= 100000
> ---
> > STEST TRAFODION.COMPGENERAL_TEST023.TRAF_SAMPLE_nn_nnnnnnnnnn_nnnnnn I
> 364c372,380
> < --- SQL operation complete.
> ---
> > *** ERROR[9200] UPDATE STATISTICS for table
> > TRAFODION.COMPGENERAL_TEST023.STESTC encountered an error (3047) from
> > statement .
> >
> > *** ERROR[3047] The timestamp '2016-010-01 08:22:04' is not valid.
> >
> > *** ERROR[8822] The statement was not prepared.
> >
> > *** ERROR[9200] UPDATE STATISTICS for table
> > TRAFODION.COMPGENERAL_TEST023.STESTC encountered an error from
> > statement updIUSUpdateInfo.
> >
> > --- SQL operation failed with errors.
> 387c403
> < STESTC TRAFODION.COMPGENERAL_TEST023.TRAF_SAMPLE_nn_nnnnnnnnnn_nnnnnn I c1
> >= 'naaaa'
> ---
> > STESTC TRAFODION.COMPGENERAL_TEST023.TRAF_SAMPLE_nn_nnnnnnnnnn_nnnnnn
> > I
> 476c492
> < *** ERROR[9200] UPDATE STATISTICS for table
> TRAFODION.COMPGENERAL_TEST023.STEST encountered an error (15001) from
> statement HSCursor::prepareRowsetInternal().
> ---
> > *** ERROR[9200] UPDATE STATISTICS for table
> > TRAFODION.COMPGENERAL_TEST023.STEST encountered an error (3047) from
> > statement .
> 478,481c494
> < *** ERROR[15001] A syntax error occurred at or before:
> < SELECT "C1", "C2", "C3", "_SALT_" FROM
> TRAFODION.COMPGENERAL_TEST023.TRAF_SAMPL
> < E_nn_nnnnnnnnnn_nnnnnn WHERE 1 FOR READ UNCOMMITTED ACCESS; < ^ (zzz
> characters from start of SQL statement)
> ---
> > *** ERROR[3047] The timestamp '2016-010-01 08:22:19' is not valid.
> 485,492c498
> < *** ERROR[9200] UPDATE STATISTICS for table
> TRAFODION.COMPGENERAL_TEST023.STEST encountered an error (15001) from
> statement POPULATE_FROM_QUERY.
> <
> < *** ERROR[15001] A syntax error occurred at or before:
> < SELECT "C1", "C2", "C3", "_SALT_" FROM
> TRAFODION.COMPGENERAL_TEST023.TRAF_SAMPL
> < E_nn_nnnnnnnnnn_nnnnnn WHERE 1 FOR READ UNCOMMITTED ACCESS; < ^ (zzz
> characters from start of SQL statement) < < *** ERROR[8822] The statement
> was not prepared.
> ---
> > *** ERROR[9200] UPDATE STATISTICS for table
> > TRAFODION.COMPGENERAL_TEST023.STEST encountered an error from
> > statement updIUSUpdateInfo.
> First suspicion is that it is a bug in formatting a timestamp literal. Note that we just transitioned into October, a two-digit month.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)