Closed Laxman-SM closed 7 years ago
nishantmonu51
commented
7 years ago @Laxman-SM: make sure your druid broker is configure correctly in superset. If its already configured correctly, are you able to run the same query against druid broker via command line ?
Laxman-SM
commented
7 years ago Hi Nishant,
On my POC environment,
Druid broker and coordinator configured properly on superset. as per troubleshooting figure out broker node unable to resolve historical node ec2 private ip address than replaced private ip address with hostname. on broker node logs historical node still showing same errror. that time i suspect DNS issue may be causing this problem. for verification historical node private ip address mapped on broker node hosts file and restarted service on both node historical and broker node.
historical node
druid.host=historical (planning to use DNS name for all node through ansible) druid.service=/druid/historical druid.port=8083
Broker node druid.host=ec2-xx-xx-xx-xxx.compute-1.amazonaws.com (EIP) druid.service=druid/broker druid.port=8082 druid.startup.logging.logProperties=true druid.selectors.indexing.serviceName=druid:overlord druid.selectors.coordinator.serviceName=druid:coordinator
/etc/hosts entry 10.x.x.10 historical
after adding my issue resolved. now i am able to query all my data source. i am still working on scaling of my entire configuration through (terrform/ansible). thanks for your valuable responce.
Regards, Laxman Singh
From: Nishant Bangarwa notifications@github.com Sent: Saturday, February 25, 2017 6:21:23 PM To: airbnb/superset Cc: Laxman Singh; Mention Subject: Re: [airbnb/superset] druid' HTTP Error 500: Internal Server Error Druid Error: Unknown exception Query is: (#2208)
@Laxman-SMhttps://github.com/Laxman-SM: make sure your druid broker is configure correctly in superset. If its already configured correctly, are you able to run the same query against druid broker via command line ?
— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHubhttps://github.com/airbnb/superset/issues/2208#issuecomment-282482061, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AKHFnnixe_mP2cksR3BUzWZqynfUNOgKks5rgCPLgaJpZM4MHw3a.
Hi, Today compiled superset 0.16.0 on ubuntu 14.10 system and successfully configured mysql with superset. followed step mentioned on site listed below.
Create an admin user (you will be prompted to set username, first and last name before setting a password)
fabmanager create-admin --app superset
Initialize the database
superset db upgrade
Load some data to play with
superset load_examples
Create default roles and permissions
superset init
Start the web server on port 8088, use -p to bind to another port
nohup superset runserver -p 8088 &
i'm able to succesfully login on UI. added
tail -f nohup.out
2017-02-21 14:06:46,352:DEBUG:requests.packages.urllib3.connectionpool:"GET /druid/coordinator/v1/metadata/datasources HTTP/1.1" 200 None 2017-02-21 14:06:46,353:INFO:root:Syncing Druid datasource [dsp_traffic] 2017-02-21 14:06:46,373:ERROR:root:HTTP Error 500: Internal Server Error Druid Error: Unknown exception Query is: { "queryType": "timeBoundary", "dataSource": "dsp_traffic" } Traceback (most recent call last): File "/usr/local/lib/python2.7/dist-packages/superset-0.16.0-py2.7.egg/superset/views.py", line 2746, in refresh_datasources cluster.refresh_datasources() File "/usr/local/lib/python2.7/dist-packages/superset-0.16.0-py2.7.egg/superset/models.py", line 1662, in refresh_datasources DruidDatasource.sync_to_db(datasource, self, merge_flag) File "/usr/local/lib/python2.7/dist-packages/superset-0.16.0-py2.7.egg/superset/models.py", line 2191, in sync_to_db cols = datasource.latest_metadata() File "/usr/local/lib/python2.7/dist-packages/superset-0.16.0-py2.7.egg/superset/models.py", line 2056, in latest_metadata results = client.time_boundary(datasource=self.datasource_name) File "build/bdist.linux-x86_64/egg/pydruid/client.py", line 258, in time_boundary return self._post(query) File "build/bdist.linux-x86_64/egg/pydruid/client.py", line 409, in _post e, err, json.dumps(query.query_dict, indent=4))) IOError: HTTP Error 500: Internal Server Error Druid Error: Unknown exception Query is: { "queryType": "timeBoundary", "dataSource": "dsp_traffic" } /usr/local/lib/python2.7/dist-packages/Flask_AppBuilder-1.8.1-py2.7.egg/flask_appbuilder/forms.py:245: FlaskWTFDeprecationWarning: "flask_wtf.Form" has been renamed to "FlaskForm" and will be removed in 1.0.
able to reproduce issue. (followed step drop and recreated database; but still getting same error)
Error while processing cluster 'druid' HTTP Error 500: Internal Server Error Druid Error: Unknown exception Query is: { "queryType": "timeBoundary", "dataSource": "dsp_traffic" }
Superset version
0.16.0 (self compiled from source)
Steps to reproduce
followed step drop and recreated database and restarted all service; but still getting same error