Reply
Explorer
Posts: 6
Registered: ‎08-08-2014

Hue 3.10.0 is not stable, occasionally will not be able to use

Hi,all:
    We use the version of Hue is 3.10.0,is not stable, occasionally will not be able to use.In addition we also use the sentry1.6.0 hive1.1.0,hadoop-2.6.0(apache), MariaDB - 10.0.22.
    This phenomenon is can't query the metastore information, that is,can not query table information through the hue until timeout.
    There are two strange phenomenon:
    1、netstat -aln|grep 10000
     There are many closed_wait connection
     2、when query avro table through the hue so many sentry logs print and very crazy,as following:
     INFO DataNucleus.Query: Reading in results for query "SELECT FROM org.apache.sentry.provider.db.service.model.MSentryPrivilege WHERE roles.contains(role) && (role.roleName == "") && serverName == "" && ((dbName == "") || (dbName == "__NULL__")) && (URI == "__NULL__") && ((tableName == "") || (tableName == "__NULL__")) && (URI == "__NULL__") && ((columnName == "") || (columnName == "__NULL__")) && (URI == "__NULL__") VARIABLES org.apache.sentry.provider.db.service.model.MSentryRole role" since the connection used is closing
   INFO DataNucleus.Query: Reading in results for query "SELECT FROM org.apache.sentry.provider.db.service.model.MSentryPrivilege WHERE roles.contains(role) && (role.roleName == "") && serverName == "" && ((dbName == "") || (dbName == "__NULL__")) && (URI == "__NULL__") && ((tableName == "") || (tableName == "__NULL__")) && (URI == "__NULL__") && ((columnName == "") || (columnName == "__NULL__")) && (URI == "__NULL__") VARIABLES org.apache.sentry.provider.db.service.model.MSentryRole role" since the connection used is closing
   INFO DataNucleus.Query: Reading in results for query "SELECT FROM org.apache.sentry.provider.db.service.model.MSentryPrivilege WHERE roles.contains(role) && (role.roleName == "") && serverName == "" && ((dbName == "") || (dbName == "__NULL__")) && (URI == "__NULL__") && ((tableName == "") || (tableName == "__NULL__")) && (URI == "__NULL__") && ((columnName == "") || (columnName == "__NULL__")) && (URI == "__NULL__") VARIABLES org.apache.sentry.provider.db.service.model.MSentryRole role" since the connection used is closing
 
 
When this happens, restart the hiveserver2 service just fine.The thing puzzled me for a long time.Have you encountered this kind of situation?If so how did you resolve it ?Thanks !!!
 
Cloudera Employee
Posts: 723
Registered: ‎07-30-2013

Re: Hue 3.10.0 is not stable, occasionally will not be able to use

This is more a Sentry/HS2 issue or internal environment issue than Hue
itself right?