Support Questions
Find answers, ask questions, and share your expertise

Hue 3.7 500 Error on Home Page

Hue 3.7 500 Error on Home Page

Contributor

Hi,

 

I have a cluster with CDH 5.4.0 with Kerberos Enabled and Hue works with LDAP for using the Active Directory Credentials.

 

When I log in on Hue Home page I have this error:

 

hue_error.png

 

As "More Info" I have:

 

File Name	Line Number	Function Name
/opt/cloudera/parcels/CDH-5.4.0-1.cdh5.4.0.p0.27/lib/hue/build/env/lib/python2.6/site-packages/Django-1.6.10-py2.6.egg/django/core/handlers/base.py	112	get_response
/opt/cloudera/parcels/CDH-5.4.0-1.cdh5.4.0.p0.27/lib/hue/build/env/lib/python2.6/site-packages/Django-1.6.10-py2.6.egg/django/db/transaction.py	371	inner
/opt/cloudera/parcels/CDH-5.4.0-1.cdh5.4.0.p0.27/lib/hue/desktop/core/src/desktop/views.py	62	home
/opt/cloudera/parcels/CDH-5.4.0-1.cdh5.4.0.p0.27/lib/hue/desktop/core/src/desktop/api.py	55	_get_docs
/opt/cloudera/parcels/CDH-5.4.0-1.cdh5.4.0.p0.27/lib/hue/build/env/lib/python2.6/site-packages/Django-1.6.10-py2.6.egg/django/db/models/query.py	96	__iter__
/opt/cloudera/parcels/CDH-5.4.0-1.cdh5.4.0.p0.27/lib/hue/build/env/lib/python2.6/site-packages/Django-1.6.10-py2.6.egg/django/db/models/query.py	857	_fetch_all
/opt/cloudera/parcels/CDH-5.4.0-1.cdh5.4.0.p0.27/lib/hue/build/env/lib/python2.6/site-packages/Django-1.6.10-py2.6.egg/django/db/models/query.py	219	iterator
/opt/cloudera/parcels/CDH-5.4.0-1.cdh5.4.0.p0.27/lib/hue/build/env/lib/python2.6/site-packages/Django-1.6.10-py2.6.egg/django/db/models/query.py	1241	get_klass_info
/opt/cloudera/parcels/CDH-5.4.0-1.cdh5.4.0.p0.27/lib/hue/build/env/lib/python2.6/site-packages/Django-1.6.10-py2.6.egg/django/db/models/query_utils.py	173	select_related_descend

How can I solve this problem ? 

 

Thanks

Alessio

 

12 REPLIES 12

Re: Hue 3.7 500 Error on Home Page

Expert Contributor
Did you upgrade to 5.4 or is this a fresh install? Can you go to other pages, like "/useradmin"?

Re: Hue 3.7 500 Error on Home Page

Contributor

Hi,

 

I upgraded to 5.4 (from 5.1.2) and this is the only page where I have problems

 

Thanks

Alessio

Re: Hue 3.7 500 Error on Home Page

Expert Contributor
Three thoughts:

1. Are you using Oracle as the backend? I don't think so or the error would be different.
2. Try logging into the Hue server as root, then doing:

export HUE_CONF_DIR="/var/run/cloudera-scm-agent/process/`ls -1 /var/run/cloudera-scm-agent/process | grep HUE | sort -n | tail -1 `"
/opt/cloudera/parcels/CDH/lib/hue/build/env/bin/hue migrate --merge

3. If none of the above are the case, then go into the Hue DB and run:

use hue;
update oozie_node set data='{}' where data='';
update oozie_job set data='{}' where data='';



Re: Hue 3.7 500 Error on Home Page

Contributor

Hi, 

 

1. Yes I'm using Oracle as backend 

 

2. I tried to define the HUE_CONF_DIR variable and follow your instructions but it doesn't work

 

Can I launch the same queries of your point 3 even if I'm using Oracle ?

 

Thanks

Alessio

Re: Hue 3.7 500 Error on Home Page

Expert Contributor
What happens when you run:

2. Try logging into the Hue server as root, then doing:

export HUE_CONF_DIR="/var/run/cloudera-scm-agent/process/`ls -1 /var/run/cloudera-scm-agent/process | grep HUE | sort -n | tail -1 `"
/opt/cloudera/parcels/CDH/lib/hue/build/env/bin/hue migrate --merge

You can run those queries if you're using Oracle, you may need to have an Oracle DBA do it.

Re: Hue 3.7 500 Error on Home Page

Contributor

Hi,

 

For point 2:

 

I export the HUE_CONF_DIR as:

 

export HUE_CONF_DIR="/var/run/cloudera-scm-agent/process/`ls -1 /var/run/cloudera-scm-agent/process | grep HUE | sort -n | tail -1 `"

so 

echo $HUE_CONF_DIR
/var/run/cloudera-scm-agent/process/6513-hue-HUE_SERVER

and this is the output of /opt/cloudera/parcels/CDH/lib/hue/build/env/bin/hue migrate --merge command 

 

Running migrations for django_extensions:
- Nothing to migrate.
 - Loading initial data for django_extensions.
Installed 0 object(s) from 0 fixture(s)
Running migrations for desktop:
- Nothing to migrate.
 - Loading initial data for desktop.
Installed 0 object(s) from 0 fixture(s)
Running migrations for beeswax:
- Nothing to migrate.
 - Loading initial data for beeswax.
Installed 0 object(s) from 0 fixture(s)
Running migrations for hbase:
- Nothing to migrate.
 - Loading initial data for hbase.
Installed 0 object(s) from 0 fixture(s)
Running migrations for jobsub:
- Nothing to migrate.
 - Loading initial data for jobsub.
Installed 0 object(s) from 0 fixture(s)
Running migrations for oozie:
- Nothing to migrate.
 - Loading initial data for oozie.
Installed 0 object(s) from 0 fixture(s)
Running migrations for pig:
- Nothing to migrate.
 - Loading initial data for pig.
Installed 0 object(s) from 0 fixture(s)
Running migrations for search:
- Nothing to migrate.
 - Loading initial data for search.
Installed 0 object(s) from 0 fixture(s)
? You have no migrations for the 'security' app. You might want some.
Running migrations for sqoop:
- Nothing to migrate.
 - Loading initial data for sqoop.
Installed 0 object(s) from 0 fixture(s)
Running migrations for useradmin:
- Nothing to migrate.
 - Loading initial data for useradmin.
Installed 0 object(s) from 0 fixture(s)

I'll try to launch the queries from Oracle DB

 

Thanks

Alessio

 

Re: Hue 3.7 500 Error on Home Page

Are you on the very latest CDH?

We added some fix for Oracle to make the Home page work with Oracle

Re: Hue 3.7 500 Error on Home Page

I am using CDH 5.3.2 and facing the same issue.

If I restart Hue and impala then issue gets resolved.

It is not permanent though.

 

I am not using Oracle.

I am using mySQL.

Re: Hue 3.7 500 Error on Home Page

Later I saw below error on Hive.

I had to restart hue, hive and Impala. But, I know that it is not going to fix the issue permanently.

 

File "/opt/cloudera/parcels/CDH-5.3.2-1.cdh5.3.2.p0.10/lib/hue/apps/beeswax/src/beeswax/server/hive_server2_lib.py", line 438, in call

    res = fn(req)

  File "/opt/cloudera/parcels/CDH-5.3.2-1.cdh5.3.2.p0.10/lib/hue/desktop/core/src/desktop/lib/thrift_util.py", line 335, in wrapper

    raise StructuredException('THRIFTSOCKET', str(e), data=None, error_code=502)

StructuredException: timed out (code THRIFTSOCKET): None