[
https://issues.apache.org/jira/browse/TRAFODION-3236?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Work on TRAFODION-3236 started by Guo Heng.
-------------------------------------------
> Create table failed due to an exception of java IO from HBase
> -------------------------------------------------------------
>
> Key: TRAFODION-3236
> URL: https://issues.apache.org/jira/browse/TRAFODION-3236
> Project: Apache Trafodion
> Issue Type: Bug
> Components: dtm
> Affects Versions: 2.2.0
> Reporter: Guo Heng
> Assignee: Guo Heng
> Priority: Major
>
> DDL statement:
> CREATE TABLE DW_UNIFORM_USER_INFO_MM_YYYYMM_TEST005
> (
> USER_ID VARCHAR(128 CHARS) CHARACTER SET UTF8 COLLATE DEFAULT NO
> DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED,
> CUST_ID VARCHAR(128 CHARS) CHARACTER SET UTF8 COLLATE DEFAULT
> DEFAULT NULL NOT SERIALIZED,
> PRODUCT_NO VARCHAR(128 CHARS) CHARACTER SET UTF8 COLLATE DEFAULT
> NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
> , COUNTY_ID VARCHAR(128 CHARS) CHARACTER SET UTF8 COLLATE DEFAULT
> NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
> , COUNTY_NAME VARCHAR(128 CHARS) CHARACTER SET UTF8 COLLATE DEFAULT
> NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
> , MONTH_ID VARCHAR(128 CHARS) CHARACTER SET UTF8 COLLATE DEFAULT NO
> DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
> , YYS VARCHAR(128 CHARS) CHARACTER SET UTF8 COLLATE DEFAULT NO
> DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
> , PRIMARY KEY (COUNTY_ID ASC, COUNTY_NAME ASC, PRODUCT_NO ASC,
> USER_ID ASC, YYS ASC, MONTH_ID ASC)
> )
> SALT USING 88 PARTITIONS on(COUNTY_ID, MONTH_ID, PRODUCT_NO,USER_ID);
> Execute this SQL in Trafci, and you can encounter the error:
> *** ERROR[29157] Server aborted abnormally or Connection
> timed out
> *** ERROR[29160] The message header was not long enough
> *** ERROR[29157] Server aborted abnormally or Connection
> timed out
> *** ERROR[29160] The message header was not long enough
> and error message in mxosrvr log:
> 2018-11-09 14:11:27,151, ERROR, SQL.HBase, Node Number: 0,
> CPU: 0, PIN: 31813, Process Name: $Z000QYY,,,Java exception in file
> ../executor/HBaseClient_JNI.cpp, line 600.
> 2018-11-09 14:11:27,151, ERROR, SQL.HBase, Node Number: 0,
> CPU: 0, PIN: 31813, Process Name: $Z000QYY,,,HBaseClient_JNI::create() error:
> java.io.IOException: createTable exception.
> Unable to create
> table TRAF_RSRVD_3:TRAFODION.SEABASE.DW_UNIFORM_USER_INFO_MM_YYYYMM_TEST005
> Reason: Create Table failed. Error is Unknown
>
> and error message in HBase log:
> 2018-10-29 23:05:32,030 INFO
> [NIOServerCxn.Factory:0.0.0.0/0.0.0.0:2181] server.NIOServerCnxnFactory:
> Accepted socket connection from /0:0:0:0:0:0:0:1:60268
> 2018-10-29 23:05:32,036 INFO
> [NIOServerCxn.Factory:0.0.0.0/0.0.0.0:2181] server.ZooKeeperServer: Client
> attempting to establish new session at /0:0:0:0:0:0:0:1:60268
> 2018-10-29 23:05:32,038 INFO [SyncThread:0]
> server.ZooKeeperServer: Established session 0x166c05abbc50009 with negotiated
> timeout 40000 for client /0:0:0:0:0:0:0:1:60268
> 2018-10-29 23:05:33,253 WARN
> [NIOServerCxn.Factory:0.0.0.0/0.0.0.0:2181] server.NIOServerCnxn: caught end
> of stream exception
> EndOfStreamException: Unable to read additional data from
> client sessionid 0x166c05abbc50009, likely client has closed socket
> at
> org.apache.zookeeper.server.NIOServerCnxn.doIO(NIOServerCnxn.java:220)
> at
> org.apache.zookeeper.server.NIOServerCnxnFactory.run(NIOServerCnxnFactory.java:208)
> at java.lang.Thread.run(Thread.java:745)
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
