Hi,
I am trying to connect to my tables using presto and I got the following exception: Datomic Client Exception. I had previously deleted the database and created it again later. I assume this error is related, but its not clear to me how I should proceed.
Thanks!
The complete stack trace:
{
"queryId": "20191101_130106_00030_5hszw",
"session": {
"queryId": "20191101_130106_00030_5hszw",
"transactionId": "91462164-3227-4f2d-8787-da1f9332ca8f",
"clientTransactionSupport": true,
"user": "wand",
"source": "presto-cli",
"catalog": "secland",
"schema": "secland",
"path": {},
"timeZoneKey": 1875,
"locale": "en_US",
"remoteUserAddress": "127.0.0.1",
"userAgent": "StatementClientV1/316",
"clientTags": [],
"clientCapabilities": [
"PATH"
],
"resourceEstimates": {},
"startTime": 1572613266823,
"systemProperties": {},
"catalogProperties": {},
"unprocessedCatalogProperties": {},
"roles": {},
"preparedStatements": {}
},
"state": "FAILED",
"memoryPool": "general",
"scheduled": false,
"self": "http://10.213.13.60:8989/v1/query/20191101_130106_00030_5hszw",
"fieldNames": [],
"query": "show tables",
"queryStats": {
"createTime": "2019-11-01T13:01:06.823Z",
"executionStartTime": "2019-11-01T13:01:06.919Z",
"lastHeartbeat": "2019-11-01T13:01:07.012Z",
"endTime": "2019-11-01T13:01:07.011Z",
"elapsedTime": "188.66ms",
"queuedTime": "2.39ms",
"resourceWaitingTime": "94.35ms",
"dispatchingTime": "95.67us",
"executionTime": "91.83ms",
"analysisTime": "13.83s",
"distributedPlanningTime": "0.00ms",
"totalPlanningTime": "91.83ms",
"finishingTime": "0.00ns",
"totalTasks": 0,
"runningTasks": 0,
"completedTasks": 0,
"totalDrivers": 0,
"queuedDrivers": 0,
"runningDrivers": 0,
"blockedDrivers": 0,
"completedDrivers": 0,
"cumulativeUserMemory": 0,
"userMemoryReservation": "0B",
"revocableMemoryReservation": "0B",
"totalMemoryReservation": "0B",
"peakUserMemoryReservation": "0B",
"peakRevocableMemoryReservation": "0B",
"peakTotalMemoryReservation": "0B",
"peakTaskUserMemory": "0B",
"peakTaskRevocableMemory": "0B",
"peakTaskTotalMemory": "0B",
"scheduled": false,
"totalScheduledTime": "0.00ns",
"totalCpuTime": "0.00ns",
"totalBlockedTime": "0.00ns",
"fullyBlocked": false,
"blockedReasons": [],
"physicalInputDataSize": "0B",
"physicalInputPositions": 0,
"internalNetworkInputDataSize": "0B",
"internalNetworkInputPositions": 0,
"rawInputDataSize": "0B",
"rawInputPositions": 0,
"processedInputDataSize": "0B",
"processedInputPositions": 0,
"outputDataSize": "0B",
"outputPositions": 0,
"physicalWrittenDataSize": "0B",
"stageGcStatistics": [],
"operatorSummaries": [],
"spilledDataSize": "0B",
"logicalWrittenDataSize": "0B",
"writtenPositions": 0
},
"setSessionProperties": {},
"resetSessionProperties": [],
"setRoles": {},
"addedPreparedStatements": {},
"deallocatedPreparedStatements": [],
"clearTransactionId": false,
"failureInfo": {
"type": "clojure.lang.ExceptionInfo",
"message": "Datomic Client Exception",
"suppressed": [],
"stack": [
"datomic.client.api.async$ares.invokeStatic(async.clj:58)",
"datomic.client.api.async$ares.invoke(async.clj:54)",
"datomic.client.api.async$db.invokeStatic(async.clj:109)",
"datomic.client.api.async$db.invoke(async.clj:106)",
"datomic.client.api.sync$eval11253$fn__11254.invoke(sync.clj:82)",
"datomic.client.api.protocols$fn__2781$G__2755__2786.invoke(protocols.clj:72)",
"datomic.client.api$db.invokeStatic(api.clj:167)",
"datomic.client.api$db.invoke(api.clj:156)",
"datomic.presto$create_connector$reify__2367$fn__2369.invoke(presto.clj:170)",
"datomic.presto.util$fn_cache$reify__2218.valAt(util.clj:64)",
"clojure.lang.RT.get(RT.java:760)",
"datomic.presto$create_connector$reify$reify__2371.listTables(presto.clj:175)",
"io.prestosql.metadata.MetadataManager.listTables(MetadataManager.java:504)",
"io.prestosql.connector.informationschema.InformationSchemaMetadata.lambda$calculatePrefixesWithTableName$7(InformationSchemaMetadata.java:337)",
"java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:269)",
"java.util.Iterator.forEachRemaining(Iterator.java:116)",
"java.util.Spliterators$IteratorSpliterator.forEachRemaining(Spliterators.java:1801)",
"java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:482)",
"java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:472)",
"java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:708)",
"java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)",
"java.util.stream.ReferencePipeline.collect(ReferencePipeline.java:566)",
"io.prestosql.connector.informationschema.InformationSchemaMetadata.calculatePrefixesWithTableName(InformationSchemaMetadata.java:341)",
"io.prestosql.connector.informationschema.InformationSchemaMetadata.getPrefixes(InformationSchemaMetadata.java:276)",
"io.prestosql.connector.informationschema.InformationSchemaMetadata.applyFilter(InformationSchemaMetadata.java:254)",
"io.prestosql.metadata.MetadataManager.applyFilter(MetadataManager.java:1015)",
"io.prestosql.sql.planner.iterative.rule.PushPredicateIntoTableScan.pushFilterIntoTableScan(PushPredicateIntoTableScan.java:195)",
"io.prestosql.sql.planner.iterative.rule.PushPredicateIntoTableScan.apply(PushPredicateIntoTableScan.java:100)",
"io.prestosql.sql.planner.iterative.rule.PushPredicateIntoTableScan.apply(PushPredicateIntoTableScan.java:70)",
"io.prestosql.sql.planner.iterative.IterativeOptimizer.transform(IterativeOptimizer.java:165)",
"io.prestosql.sql.planner.iterative.IterativeOptimizer.exploreNode(IterativeOptimizer.java:140)",
"io.prestosql.sql.planner.iterative.IterativeOptimizer.exploreGroup(IterativeOptimizer.java:105)",
"io.prestosql.sql.planner.iterative.IterativeOptimizer.exploreChildren(IterativeOptimizer.java:190)",
"io.prestosql.sql.planner.iterative.IterativeOptimizer.exploreGroup(IterativeOptimizer.java:107)",
"io.prestosql.sql.planner.iterative.IterativeOptimizer.exploreChildren(IterativeOptimizer.java:190)",
"io.prestosql.sql.planner.iterative.IterativeOptimizer.exploreGroup(IterativeOptimizer.java:107)",
"io.prestosql.sql.planner.iterative.IterativeOptimizer.exploreChildren(IterativeOptimizer.java:190)",
"io.prestosql.sql.planner.iterative.IterativeOptimizer.exploreGroup(IterativeOptimizer.java:107)",
"io.prestosql.sql.planner.iterative.IterativeOptimizer.optimize(IterativeOptimizer.java:96)",
"io.prestosql.sql.planner.LogicalPlanner.plan(LogicalPlanner.java:173)",
"io.prestosql.sql.planner.LogicalPlanner.plan(LogicalPlanner.java:162)",
"io.prestosql.execution.SqlQueryExecution.doAnalyzeQuery(SqlQueryExecution.java:381)",
"io.prestosql.execution.SqlQueryExecution.analyzeQuery(SqlQueryExecution.java:366)",
"io.prestosql.execution.SqlQueryExecution.start(SqlQueryExecution.java:316)",
"io.prestosql.$gen.Presto_316____20191101_120711_1.run(Unknown Source)",
"io.prestosql.execution.SqlQueryManager.createQuery(SqlQueryManager.java:239)",
"io.prestosql.dispatcher.LocalDispatchQuery.lambda$startExecution$4(LocalDispatchQuery.java:105)",
"java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)",
"java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)",
"java.lang.Thread.run(Thread.java:748)"
],
"errorCode": {
"code": 65536,
"name": "GENERIC_INTERNAL_ERROR",
"type": "INTERNAL_ERROR"
}
},
"errorCode": {
"code": 65536,
"name": "GENERIC_INTERNAL_ERROR",
"type": "INTERNAL_ERROR"
},
"warnings": [],
"inputs": [],
"resourceGroupId": [
"global"
],
"errorType": "INTERNAL_ERROR",
"finalQueryInfo": true
}