trafodion-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Eric Owhadi <eric.owh...@esgyn.com>
Subject udr test002 failing?
Date Wed, 23 Dec 2015 16:09:29 GMT
Hi All,

Happy holidays J.

Was wondering if you also experience failure in udr test002. I am sure this
has nothing to do with my code changes, but I don t like it when I don’t
get a clean pass all the way J.

Here is my diff:

6521a6522,6523

> *** ERROR[11252] Error 2 on opening directory
/mnt/owhadi/workspace/TRAFODION/incubator-TRAFODION/core/sqf/sql/local_hadoop/dcs-2.0.0/logs
(SQLSTATE 38002)

>

6537a6540,6541

> *** ERROR[11252] Error 2 on opening directory
/mnt/owhadi/workspace/TRAFODION/incubator-TRAFODION/core/sqf/sql/local_hadoop/dcs-2.0.0/logs
(SQLSTATE 38002)

>

6542,6543c6546

< (EXPR)

< ----------

---

> *** ERROR[11252] Error 2 on opening directory
/mnt/owhadi/workspace/TRAFODION/incubator-TRAFODION/core/sqf/sql/local_hadoop/dcs-2.0.0/logs
(SQLSTATE 38002)

6545,6547c6548

<  0

<

< --- 1 row(s) selected.

---

> --- 0 row(s) selected.

6560,6563c6561

< NUM_EVENTS NUM_LINES NUM_QUERY_IDS NUM_PARSE_ERRORS

< ----------

<

<  22 33 13 3

---

> *** ERROR[11252] Error 2 on opening directory
/mnt/owhadi/workspace/TRAFODION/incubator-TRAFODION/core/sqf/sql/local_hadoop/dcs-2.0.0/logs
(SQLSTATE 38002)

6565c6563

< --- 1 row(s) selected.

---

> --- 0 row(s) selected.

6573c6571

< LOG_TS SEVERITY COMPONENT NODE_NUMBER CPU PIN PROCESS_NAME SQL_CODE
QUERY_ID MESSAGE LOG_FILE_NODE LOG_FILE_NAME LOG_FILE_LINE PARSE_STATUS

---

> *** ERROR[11252] Error 2 on opening directory
/mnt/owhadi/workspace/TRAFODION/incubator-TRAFODION/core/sqf/sql/local_hadoop/dcs-2.0.0/logs
(SQLSTATE 38002)

6575,6584c6573

< 2015-02-03 00:08:03.480000 INFO SQL.EXE 0 0 25816 @volume@ ? ? An
executor process is launched. 0 master_exec_regr_999_99999.log 1

< 2015-02-03 00:08:11.037000 INFO SQL.COMP 0 0 25952 @volume@ ? ? A
compiler process is launched. 0 master_exec_regr_999_99999.log 3

< 2015-02-03 00:08:31.884000 ERROR SQL.EXE 0 0 25816 @volume@ 11252
MXID11000025816212289682083477587000000000206U3333300_1438___SQLCI_DML_LAST__
*** ERROR[11252] Column not found (SQLSTATE 38900) 0
master_exec_regr_999_99999.log 8

< 2015-02-03 00:08:33.418000 ERROR SQL.EXE 0 0 25816 @volume@ 11246
MXID11000025816212289682083477587000000000206U3333300_1593___SQLCI_DML_LAST__
*** ERROR[11246] An error occurred locating function
'SESSIONIZE_NON_EXISTENT' in library
'/opt/home/zellerh/TRAFODION/core/sqf/rundir/udr/TEST001.dll'. 2015-02-03
00:this is a bad timestamp and should be appended to the previous message 0
master_exec_regr_999_99999.log 16

< 2015-02-03 00:08:33.500000 ERROR ? ? ? ? ? ? ? this should produce a
parse error with this message 0 master_exec_regr_999_99999.log 20 E

< 2015-02-03 00:08:34.114000 ERROR SQL.EXE 0 0 25816 @volume@ 15001
MXID11000025816212289682083477587000000000206U3333300_1710___SQLCI_DML_LAST__
*** ERROR[15001] A syntax error occurred at or before: select * from
udf(sessionize_dynamic(TABLE(SELECT userid, JULIANTIMESTAMP(ts) a s TS FROM
clicks PARTITION BY userid ORDER BY ts), TABLE(SELECT userid,
JULIANTIMESTAMP(ts) as TS FROM clicks PARTITION BY userid ORDER BY ts),
cast('TS' as char(2)), 'USERID', 60000000)) XOX; ^ (409 characters from
start of SQL statement) 0 master_exec_regr_999_99999.log 23

< 2015-02-03 00:08:34.461000 ERROR SQL.EXE 0 0 25816 @volume@ 11252
MXID11000025816212289682083477587000000000206U3333300_1711___SQLCI_DML_LAST__
Some Chinese UTF8 characters: ??????????? and invalid UTF-8 characters:
??hould see replacement characters to the left 0
master_exec_regr_999_99999.log 30 C

< 2015-02-03 00:08:34.461000 ERROR SQL.EXE 0 0 25816 @volume@ 11252
MXID11000025816212289682083477587000000000206U3333300_1711___SQLCI_DML_LAST__
Parse error in continuation line: Invalid UTF-8 characters: ??hould see
replacement characters to the left 0 master_exec_regr_999_99999.log 31 C

<

< --- 8 row(s) selected.

---

> --- 0 row(s) selected.

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