[
https://issues.apache.org/jira/browse/DRILL-7975?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17385779#comment-17385779
]
ASF GitHub Bot commented on DRILL-7975:
---------------------------------------
vdiravka opened a new pull request #2278:
URL: https://github.com/apache/drill/pull/2278
# [DRILL-7975](https://issues.apache.org/jira/browse/DRILL-7975): Connection
to Splunk Drill Storage Plugin fails intermittently
## Description
Introduces the new filed in Plugin config, which allows to specify the
number of retries of connections to data source. Actually works only for Splunk
and can be easily extended for other data sources.
## Documentation
`reconnectRetries` - the plugin config property. Determines the number of
retries of connections to data source in case the previous ones were
unsuccessful.
## Testing
Covered with Unit test
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
> Connection to Splunk Drill Storage Plugin fails intermittently
> --------------------------------------------------------------
>
> Key: DRILL-7975
> URL: https://issues.apache.org/jira/browse/DRILL-7975
> Project: Apache Drill
> Issue Type: Bug
> Components: splunk
> Affects Versions: 1.19.0
> Reporter: Vitalii Diravka
> Assignee: Vitalii Diravka
> Priority: Major
> Fix For: 1.20.0
>
>
> This query:
> {code:java}
> SELECT * FROM splunk.data LIMIT 1000{code}
> fails sometimes with the following error:
> {code:java}
> VALIDATION ERROR: HTTP 401 -- call not properly authenticated
> (com.splunk.HttpException) HTTP 401 -- call not properly authenticated
> com.splunk.HttpException.create():8{code}
> {code:java}
> {
> "id": {
> "part1": 2268975635403754500,
> "part2": -3379215825344213000
> },
> "type": 1,
> "start": 1619196589746,
> "end": 1619196589763,
> "query": "SELECT * FROM splunk.ddr LIMIT 1000",
> "foreman": {
> "address": "eadd7105aa7a",
> "userPort": 31010,
> "controlPort": 31011,
> "dataPort": 31012,
> "version": "1.19.0-SNAPSHOT",
> "state": 0
> },
> "state": 4,
> "totalFragments": 0,
> "finishedFragments": 0,
> "user": "anonymous",
> "error": "VALIDATION ERROR: HTTP 401 -- call not properly
> authenticated\n\n",
> "verboseError": "VALIDATION ERROR: HTTP 401 -- call not properly
> authenticated\n\n\n\n (com.splunk.HttpException) HTTP 401 -- call not
> properly authenticated\n com.splunk.HttpException.create():84\n
> com.splunk.HttpService.send():500\n com.splunk.Service.send():1295\n
> com.splunk.HttpService.get():169\n
> com.splunk.ResourceCollection.list():288\n
> com.splunk.ResourceCollection.refresh():331\n
> com.splunk.ResourceCollection.refresh():29\n
> com.splunk.Resource.validate():186\n
> com.splunk.ResourceCollection.validate():356\n
> com.splunk.ResourceCollection.keySet():279\n
> org.apache.drill.exec.store.splunk.SplunkSchemaFactory$SplunkSchema.registerIndexes():114\n
>
> org.apache.drill.exec.store.splunk.SplunkSchemaFactory$SplunkSchema.<init>():72\n
>
> org.apache.drill.exec.store.splunk.SplunkSchemaFactory.registerSchemas():60\n
>
> org.apache.drill.exec.store.splunk.SplunkStoragePlugin.registerSchemas():60\n
> org.apache.calcite.jdbc.DynamicRootSchema.loadSchemaFactory():87\n
> org.apache.calcite.jdbc.DynamicRootSchema.getImplicitSubSchema():72\n
> org.apache.calcite.jdbc.CalciteSchema.getSubSchema():265\n
> org.apache.calcite.sql.validate.SqlValidatorUtil.getSchema():1050\n
> org.apache.drill.exec.planner.sql.conversion.DrillCalciteCatalogReader.isValidSchema():171\n
>
> org.apache.drill.exec.planner.sql.conversion.DrillValidator.validateFrom():55\n
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect():3383\n
> org.apache.calcite.sql.validate.SelectNamespace.validateImpl():60\n
> org.apache.calcite.sql.validate.AbstractNamespace.validate():84\n
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace():1009\n
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery():969\n
> org.apache.calcite.sql.SqlSelect.validate():216\n
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression():944\n
> org.apache.calcite.sql.validate.SqlValidatorImpl.validate():651\n
> org.apache.drill.exec.planner.sql.conversion.SqlConverter.validate():189\n
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateNode():641\n
>
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateAndConvert():195\n
>
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan():169\n
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getQueryPlan():283\n
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPhysicalPlan():163\n
> org.apache.drill.exec.planner.sql.DrillSqlWorker.convertPlan():128\n
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan():93\n
> org.apache.drill.exec.work.foreman.Foreman.runSQL():592\n
> org.apache.drill.exec.work.foreman.Foreman.run():273\n
> java.util.concurrent.ThreadPoolExecutor.runWorker():1149\n
> java.util.concurrent.ThreadPoolExecutor$Worker.run():624\n
> java.lang.Thread.run():748\n",
> "errorId": "ff2561d4-b71f-445d-98ea-ccc93b8ede8e",
> "optionsJson": "[ {\n \"kind\" : \"LONG\",\n \"accessibleScopes\" :
> \"ALL\",\n \"name\" : \"exec.query.max_rows\",\n \"num_val\" : 0,\n
> \"scope\" : \"QUERY\"\n} ]",
> "planEnd": 1619196589760,
> "queueWaitEnd": 0,
> "totalCost": 0,
> "queueName": "-",
> "queryId": "1f7d0551-a041-cbe0-d11a-9d1c56facfcf"
> }
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
