Uploaded image for project: 'Apache Trafodion'
  1. Apache Trafodion
  2. TRAFODION-1135

LP Bug: 1440941 - T2 Phoenix tests creating cores at CliStatement::doOltExecute

    XMLWordPrintableJSON

    Details

      Description

      These T2 phoenix tests are dumping core from 3/29 build. Stack trace is below.

      ProductMetricsTest
      QueryExecTest
      VariableLengthPKTest

      We are also seeing errors such as this from other tests (which are not coring), which are also date/time related:

      java.sql.SQLException: *** ERROR[8415] The provided DATE, TIME, or TIMESTAMP is not valid and cannot be converted.
      at org.trafodion.jdbc.t2.SQLMXPreparedStatement.execute(Native Method)
      at org.trafodion.jdbc.t2.SQLMXPreparedStatement.execute(SQLMXPreparedStatement.java:523)
      at test.java.com.hp.phoenix.end2end.ToNumberFunctionTest.initTable(ToNumberFunctionTest.java:141)
      at test.java.com.hp.phoenix.end2end.ToNumberFunctionTest.testTimeFilterWithoutPattern(ToNumberFunctionTest.java:350)
      test.java.com.hp.phoenix.end2end.ToNumberFunctionTest

          • ERROR[20123] A user-defined transaction has been started. This DDL operation cannot be performed.
            Invalid Statement/Connection handle

      Stack:
      #0 0x00007ffff703f625 in raise () from /lib64/libc.so.6
      #1 0x00007ffff7040d8d in abort () from /lib64/libc.so.6
      #2 0x00007ffff6222c55 in os::abort(bool) ()
      from /usr/java/jdk1.7.0_75/jre/lib/amd64/server/libjvm.so
      #3 0x00007ffff63a4cd7 in VMError::report_and_die() ()
      from /usr/java/jdk1.7.0_75/jre/lib/amd64/server/libjvm.so
      #4 0x00007ffff6227b6f in JVM_handle_linux_signal ()
      from /usr/java/jdk1.7.0_75/jre/lib/amd64/server/libjvm.so
      #5 <signal handler called>
      #6 ExpDatetime::convAsciiToDatetime (this=0x7ffff7fd6380,
      srcData=0x7b4800 "\027", srcLen=808583191, dstData=0x7fff9d5e7c67 "",
      dstLen=11, heap=0x7fff9d584258, diagsArea=0x7ffff7fd6900, flags=0)
      at ../exp/exp_datetime.cpp:1916
      #7 0x00007ffface10ba2 in convAsciiToDatetime (target=0x7fff9d5e7c67 "",
      targetLen=11, code=REC_DTCODE_TIMESTAMP,
      fractionPrecision=<optimized out>, source=0x7b4800 "\027",
      sourceLen=<optimized out>, heap=0x7fff9d584258, diagsArea=0x7ffff7fd6900,
      flags=0) at ../exp/exp_conv.cpp:1362
      #8 0x00007ffface147b1 in convDoIt (source=0x7b4800 "\027",
      sourceLen=808583191, sourceType=64, sourcePrecision=0, sourceScale=1,
      target=0x7fff9d5e7c67 "", targetLen=11, targetType=192, targetPrecision=3,
      targetScale=6, varCharLen=0x0, varCharLenSize=0, heap=0x7fff9d584258,
      diagsArea=0x7ffff7fd6900, index=CONV_ASCII_DATETIME,
      --Type <return> to continue, or q <return> to quit--
      dataConversionErrorFlag=0x0, flags=0) at ../exp/exp_conv.cpp:9161
      #9 0x00007fffae36e935 in InputOutputExpr::inputValues (this=0x7fff9d5ac8a0,
      atp=<optimized out>, inputDesc_=<optimized out>, tolerateNonFatalError=0,
      heap=0x7fff9d584258, flags=<optimized out>)
      at ../cli/CliExpExchange.cpp:4202
      #10 0x00007fffaea05881 in ex_root_tcb::oltExecute (this=0x7fff9d5e7a20, glob=
      0x7fff9d5a8ed8, input_desc=0x7fff9d585638, output_desc=0x0, diagsArea=
      @0x7ffff7fd6af0: 0x0) at ../executor/ex_root.cpp:2114
      #11 0x00007fffae3aec65 in CliStatement::doOltExecute (this=0x7fff9d584198,
      cliGlobals=<optimized out>, input_desc=0x7fff9d585638, output_desc=0x0,
      diagsArea=..., doNormalExecute=@0x7ffff7fd6c0c: 0,
      reExecute=@0x7ffff7fd6c08: 0) at ../cli/Statement.cpp:5537
      #12 0x00007fffae35baeb in SQLCLI_PerformTasks(CliGlobals *, ULng32, SQLSTMT_ID *, SQLDESC_ID *, SQLDESC_ID *, Lng32, Lng32, typedef __va_list_tag __va_list_tag *, SQLCLI_PTR_PAIRS *, SQLCLI_PTR_PAIRS *) (cliGlobals=0x180a090, tasks=8063,
      statement_id=0xe98770, input_descriptor=0xe987a0, output_descriptor=0x0,
      num_input_ptr_pairs=0, num_output_ptr_pairs=0, ap=0x7ffff7fd6c90,
      input_ptr_pairs=0x0, output_ptr_pairs=0x0) at ../cli/Cli.cpp:3245
      #13 0x00007fffae3c1599 in SQL_EXEC_ClearExecFetchClose (statement_id=0xe98770,
      input_descriptor=0xe987a0, output_descriptor=0x0, num_input_ptr_pairs=0,
      num_output_ptr_pairs=0, num_total_ptr_pairs=0) at ../cli/CliExtern.cpp:2627
      #14 0x00007fffb0471cdc in EXECUTE (pSrvrStmt=0xe98160)
      at native/SqlInterface.cpp:1126
      --Type <return> to continue, or q <return> to quit--
      #15 0x00007fffb046cf2e in SRVR_STMT_HDL::Execute (this=0xe98160,
      inCursorName=0x0, totalRowCount=<optimized out>, inSqlStmtType=0,
      inValueList=0x7ffff7fd7130, inSqlAsyncEnable=<optimized out>,
      inQueryTimeout=0, outValueList=0x7ffff7fd7140) at native/CSrvrStmt.cpp:238
      #16 0x00007fffb04828bc in odbc_SQLSvc_ExecuteN_sme_ (objtag_=<optimized out>,
      call_id_=<optimized out>, exception_=0x7ffff7fd7100,
      dialogueId=<optimized out>, stmtId=<optimized out>, cursorName=0x0,
      sqlStmtType=0, totalRowCount=1, inputValueList=0x7ffff7fd7130,
      sqlAsyncEnable=0, queryTimeout=0, outputValueList=0x7ffff7fd7140,
      sqlWarning=0x7ffff7fd7150) at native/SrvrOthers.cpp:302
      #17 0x00007fffb047b7ac in Java_org_trafodion_jdbc_t2_SQLMXPreparedStatement_execute (jenv=<optimized out>, jobj=0x7ffff7fd7340, server=<optimized out>,
      dialogueId=17711088, txid=0, autoCommit=1 '\001', txnMode=2,
      stmtId=15303008, cursorName=0x0, isSelect=0 '\000', paramRowCount=1,
      paramCount=9, paramValues=0x7ffff7fd72d8, queryTimeout=0,
      isAnyLob=0 '\000', iso88591Encoding=0x0, resultSet=0x0,
      contBatchOnError=0 '\000') at native/SQLMXPreparedStatement.cpp:362
      #18 0x00007ffff21b37f8 in ?? ()
      #19 0x0000000000000002 in ?? ()
      #20 0x0000000000e98160 in ?? ()
      #21 0x0000000000000000 in ?? ()
      (gdb)

        Attachments

          Activity

            People

            • Assignee:
              weiqxu Weiqing Xu
              Reporter:
              saruna Aruna Sadashiva
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: