search

cloudera / hue

Open source SQL Query Assistant service for Databases/Warehouses
https://cloudera.com
Apache License 2.0
1.16k stars 364 forks source link

Hue issue in CDH4.6.0 ('ssl handshake failure') #102

Closed ambuj-kumar closed 10 years ago

ambuj-kumar commented 10 years ago

We are getting below errors in hue using CDH 4.6.0. Is this issue indicates to CDH 4 known issue i.e. HUE-1749 [core] thrift ssl support. Please confirm.

/var/log/hue/error.log

[22/Jul/2014 01:04:20 +0000] wsgiserver ERROR WSGI (<WorkerThread(CP WSGIServer Thread-6, started 140729529480960)>) error: [('SSL routines', 'SSL23_WRITE', 'ssl handshake failure')] Traceback (most recent call last): File "/usr/share/hue/desktop/core/src/desktop/lib/wsgiserver.py", line 1296, in run conn.communicate() File "/usr/share/hue/desktop/core/src/desktop/lib/wsgiserver.py", line 1206, in communicate req.simple_response("408 Request Timeout") File "/usr/share/hue/desktop/core/src/desktop/lib/wsgiserver.py", line 618, in simple_response self.wfile.sendall("".join(buf)) File "/usr/share/hue/desktop/core/src/desktop/lib/wsgiserver.py", line 1131, in sendall return self._safe_call(False, super(SSL_fileobject, self).sendall, _args, _kwargs) File "/usr/share/hue/desktop/core/src/desktop/lib/wsgiserver.py", line 1083, in _safe_call return call(_args, _kwargs) File "/usr/share/hue/desktop/core/src/desktop/lib/wsgiserver.py", line 753, in sendall bytes_sent = self.send(data) File "/usr/share/hue/desktop/core/src/desktop/lib/wsgiserver.py", line 1134, in send return self._safe_call(False, super(SSL_fileobject, self).send, _args, _kwargs) File "/usr/share/hue/desktop/core/src/desktop/lib/wsgiserver.py", line 1113, in _safe_call raise FatalSSLAlert(e.args)

FatalSSLAlert: [('SSL routines', 'SSL23_WRITE', 'ssl handshake failure')]

/var/log/hue/beeswax_server.out

14/08/01 11:54:06 WARN avro.AvroSerdeUtils: Encountered AvroSerdeException determining schema. Returning signal schema to indicate problem org.apache.hadoop.hive.serde2.avro.AvroSerdeException: Neither avro.schema.literal nor avro.schema.url specified, can't determine table schema at org.apache.hadoop.hive.serde2.avro.AvroSerdeUtils.determineSchemaOrThrowException(AvroSerdeUtils.java:66) at org.apache.hadoop.hive.serde2.avro.AvroSerdeUtils.determineSchemaOrReturnErrorSchema(AvroSerdeUtils.java:87) at org.apache.hadoop.hive.serde2.avro.AvroSerDe.initialize(AvroSerDe.java:59) at org.apache.hadoop.hive.metastore.MetaStoreUtils.getDeserializer(MetaStoreUtils.java:250) at org.apache.hadoop.hive.ql.metadata.Partition.getDeserializer(Partition.java:251) at org.apache.hadoop.hive.ql.metadata.Partition.initialize(Partition.java:217) at org.apache.hadoop.hive.ql.metadata.Partition.(Partition.java:107) at org.apache.hadoop.hive.ql.metadata.Hive.getPartitionsByNames(Hive.java:1720) at org.apache.hadoop.hive.ql.optimizer.ppr.PartitionPruner.pruneBySequentialScan(PartitionPruner.java:364) at org.apache.hadoop.hive.ql.optimizer.ppr.PartitionPruner.prune(PartitionPruner.java:219) at org.apache.hadoop.hive.ql.optimizer.pcr.PcrOpProcFactory$FilterPCR.process(PcrOpProcFactory.java:112) at org.apache.hadoop.hive.ql.lib.DefaultRuleDispatcher.dispatch(DefaultRuleDispatcher.java:89) at org.apache.hadoop.hive.ql.lib.DefaultGraphWalker.dispatch(DefaultGraphWalker.java:87) at org.apache.hadoop.hive.ql.lib.DefaultGraphWalker.walk(DefaultGraphWalker.java:124) at org.apache.hadoop.hive.ql.lib.DefaultGraphWalker.startWalking(DefaultGraphWalker.java:101) at org.apache.hadoop.hive.ql.optimizer.pcr.PartitionConditionRemover.transform(PartitionConditionRemover.java:86) at org.apache.hadoop.hive.ql.optimizer.Optimizer.optimize(Optimizer.java:102) at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:8261) at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:258) at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:459) at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:349) at com.cloudera.beeswax.BeeswaxServiceImpl$RunningQueryState.checkedCompile(BeeswaxServiceImpl.java:247) at com.cloudera.beeswax.BeeswaxServiceImpl$RunningQueryState.compile(BeeswaxServiceImpl.java:200) at com.cloudera.beeswax.BeeswaxServiceImpl$2.run(BeeswaxServiceImpl.java:830) at com.cloudera.beeswax.BeeswaxServiceImpl$2.run(BeeswaxServiceImpl.java:823) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:396) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1438) at com.cloudera.beeswax.BeeswaxServiceImpl.doWithState(BeeswaxServiceImpl.java:772) at com.cloudera.beeswax.BeeswaxServiceImpl.query(BeeswaxServiceImpl.java:822) at com.cloudera.beeswax.api.BeeswaxService$Processor$query.getResult(BeeswaxService.java:915) at com.cloudera.beeswax.api.BeeswaxService$Processor$query.getResult(BeeswaxService.java:899) at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39) at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39) at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:244) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)

at java.lang.Thread.run(Thread.java:662)

/var/log/hue/runcpserver.log

[22/Jul/2014 01:04:20 +0000] wsgiserver ERROR WSGI (<WorkerThread(CP WSGIServer Thread-6, started 140729529480960)>) error: [('SSL routines', 'SSL23_WRITE', 'ssl handshake failure')] Traceback (most recent call last): File "/usr/share/hue/desktop/core/src/desktop/lib/wsgiserver.py", line 1296, in run conn.communicate() File "/usr/share/hue/desktop/core/src/desktop/lib/wsgiserver.py", line 1206, in communicate req.simple_response("408 Request Timeout") File "/usr/share/hue/desktop/core/src/desktop/lib/wsgiserver.py", line 618, in simple_response self.wfile.sendall("".join(buf)) File "/usr/share/hue/desktop/core/src/desktop/lib/wsgiserver.py", line 1131, in sendall return self._safe_call(False, super(SSL_fileobject, self).sendall, _args, _kwargs) File "/usr/share/hue/desktop/core/src/desktop/lib/wsgiserver.py", line 1083, in _safe_call return call(_args, _kwargs) File "/usr/share/hue/desktop/core/src/desktop/lib/wsgiserver.py", line 753, in sendall bytes_sent = self.send(data) File "/usr/share/hue/desktop/core/src/desktop/lib/wsgiserver.py", line 1134, in send return self._safe_call(False, super(SSL_fileobject, self).send, _args, _kwargs) File "/usr/share/hue/desktop/core/src/desktop/lib/wsgiserver.py", line 1113, in _safe_call raise FatalSSLAlert(e.args) FatalSSLAlert: [('SSL routines', 'SSL23_WRITE', 'ssl handshake failure')]

romainr commented 10 years ago

Do you mean HTTPS or SSL encryption while taking to HiveServer2? (the later only comes in Hue 3 / CDH5)

Could we followup on http://groups.google.com/a/cloudera.org/group/hue-user that way everybody can participate?

ambuj-kumar commented 10 years ago

Thanks Romain for the reply. Can you please let me know the HUE-1749 [core] thrift ssl support issue a kind of intermittent?

romainr commented 10 years ago

This patch is unrelated to Web HTTPS, let's continue on https://groups.google.com/a/cloudera.org/forum/#!topic/hue-user/k7Ghv5sAtkI