Hue is failing for some users after HDP 2.6 upgrade.

[Anandha Loganathan]

I have an issue going on for some users in HUE. 

We have upgraded to HDP 2.6 and hue the 3.11 version. 

Half the users are able to access the Hue service without any issue and another half users 

 having a problem.

 

People who have problem,

1) Login is successful 

2) On the home page or hive editor, left navigation doesn't display any databases and folders. 

3) They are unable to run the query. 

4) There is red color pop up display on the right corner. 

 

We don't know where the problem is happening and no error message is throwing. 

Sometimes it throws this error but not always. It says services exited abnormally.

[12/Oct/2017 01:27:28 ] supervisor   ERROR    Process /root/hue_3_11_install/hue/build/env/bin/hue runcpserver exited abnormally. Restarting it.

[11/Oct/2017 18:30:10 -0700] decorators   ERROR    Error running <function cancel_statement at 0x7ffe0cdafb90>

Traceback (most recent call last):

  File "/root/hue_3_11_install/hue/desktop/libs/notebook/src/notebook/decorators.py", line 81, in decorator

    return func(*args, **kwargs)

  File "/root/hue_3_11_install/hue/desktop/libs/notebook/src/notebook/api.py", line 253, in cancel_statement

    response['result'] = get_api(request, snippet).cancel(notebook, snippet)

  File "/root/hue_3_11_install/hue/desktop/libs/notebook/src/notebook/connectors/hiveserver2.py", line 68, in decorator

    return func(*args, **kwargs)

  File "/root/hue_3_11_install/hue/desktop/libs/notebook/src/notebook/connectors/hiveserver2.py", line 291, in cancel

    handle = self._get_handle(snippet)

  File "/root/hue_3_11_install/hue/desktop/libs/notebook/src/notebook/connectors/hiveserver2.py", line 594, in _get_handle

    snippet['result']['handle']['secret'], snippet['result']['handle']['guid'] = HiveServerQueryHandle.get_decoded(snippet['result']['handle']['secret'], snippet['result']['handle']['guid'])

KeyError: 'secret'

Any pointers is to look into the problem is highly appreciated.

[Anandha Loganathan]

A user got deleted and got added back recently and he is getting this error on the UI.

(1452, 'Cannot add or update a child row: a foreign key constraint fails (`huepr`.`beeswax_session`, CONSTRAINT `owner_id_refs_id_0417c1ac` FOREIGN KEY (`owner_id`) REFERENCES `auth_user` (`id`))')

(1452, 'Cannot add or update a child row: a foreign key constraint fails (`huepr`.`beeswax_session`, CONSTRAINT `owner_id_refs_id_0417c1ac` FOREIGN KEY (`owner_id`) REFERENCES `auth_user` (`id`))')

[Romain Rigaux]

You could delete all the session records with this user id, or change the user id to be the same as before.

In general it is recommend to never delete a user, but to disable it.

--
You received this message because you are subscribed to the Google Groups "Hue-Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to hue-user+u...@cloudera.org.

[AnandaLoganathan]

Thanks Romain for the update.

1) Could you tell why the users are getting  "error loading database"?  My original email thread.

2) Do you know how to delete the session records for that user id? Do you have any reference document or DML query ?

Thanks
Anand

To unsubscribe from this group and stop receiving emails from it, send an email to hue-user+unsubscribe@cloudera.org.

[AnandaLoganathan]

It is also trying to connect to HBase when there is no Hbase config is defined.  can we ignore this error?

[11/Oct/2017 21:46:59 -0700] conf         ERROR    The application won't work without a running HBase Thrift Server v1.

Traceback (most recent call last):

  File "/root/hue_3_11_install/hue/apps/hbase/src/hbase/conf.py", line 81, in config_validator

    api.getTableList(cluster_name)

  File "/root/hue_3_11_install/hue/apps/hbase/src/hbase/api.py", line 140, in getTableList

    return [{'name': name, 'enabled': client.isTableEnabled(name, doas=self.user.username)} for name in client.getTableNames(doas=self.user.username)]

  File "/root/hue_3_11_install/hue/desktop/core/src/desktop/lib/thrift_util.py", line 379, in wrapper

    raise StructuredThriftTransportException(e, error_code=502)

StructuredThriftTransportException: Could not connect to localhost:9090 (code THRIFTTRANSPORT): TTransportException('Could not connect to localhost:9090',)

[11/Oct/2017 21:46:59 -0700] conf         ERROR    No available Impalad to send queries to.

Traceback (most recent call last):

  File "/root/hue_3_11_install/hue/apps/impala/src/impala/conf.py", line 193, in config_validator

    raise ex

StructuredThriftTransportException: Could not connect to localhost:21050 (code THRIFTTRANSPORT): TTransportException('Could not connect to localhost:21050',)

[Anandha Loganathan]

I found a solution after adding hive.server2.parallel.ops.in.session=true in hive-site.xml

There was a discussion here to set the default to TRUE but they decided not to do.

https://issues.apache.org/jira/browse/HIVE-11402?focusedCommentId=15357330&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-15357330 

It caused a lot of problem on our side. 

Thanks
Anand

[Romain Rigaux]

Yes, this is a famous issue with HDP. We documented it here http://gethue.com/hadoop-hue-3-on-hdp-installation-tutorial/