You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Guo Heng (JIRA)" <ji...@apache.org> on 2018/11/24 02:26:00 UTC
[jira] [Updated] (TRAFODION-3236) Create table failed due to an
exception of java IO from HBase
[ https://issues.apache.org/jira/browse/TRAFODION-3236?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Guo Heng updated TRAFODION-3236:
--------------------------------
Priority: Minor (was: Major)
> 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: Improvement
> Components: dtm
> Affects Versions: 2.2.0
> Reporter: Guo Heng
> Assignee: Guo Heng
> Priority: Minor
>
> 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)