apache / druid

Apache Druid: a high performance real-time analytics database.
https://druid.apache.org/
Apache License 2.0
13.46k stars 3.7k forks source link

Druid 28 Fresh Install Error on Kubernetes #15696

Open CoinCoderBuffalo opened 9 months ago

CoinCoderBuffalo commented 9 months ago

Affected Version

Druid 28.0.0 in Kubernetes Druid 29.0.0 in Kubernetes

Description

Fresh install of Druid. Druid deploys successfully in k8, but I see the following error in the Druid Console UI related to a metadata query:

Unknown exception / Compiling "GeneratedMetadata_CollationHandler" in Line 19, Column 14: Line 31, Column 50: Compiling "collations(org.apache.calcite.rel.RelNode r, org.apache.calcite.rel.metadata.RelMetadataQuery mq)" / org.codehaus.commons.compiler.InternalCompilerException

Note: I followed the upgrade steps, to add the column (not sure if required for a fresh install, but did it regardless) and gave the druid user account full access to the meta store database. image

I don't see any errors in the Druid k8 Pod logs of any relevance.

abhishekagarwal87 commented 9 months ago

When you open the console in the browser, can you look at the network tab in "Developer Tools" (assuming Chrome)? Through that, you can get the exact HTTP request that's failing with this error.

Are you not able to use druid at all with this error?

CoinCoderBuffalo commented 7 months ago

I see the following HTTP calls are failing. I am unable to load any data into druid. I am using derby as the metastore, I've also tried using postgres.

Notes: I see this error on versions: 28, 29 I don't see this error on version: 27

sql?capabilities { "error": "Unknown exception", "errorClass": "org.codehaus.commons.compiler.InternalCompilerException", "host": null, "errorCode": "legacyQueryException", "persona": "OPERATOR", "category": "RUNTIME_FAILURE", "errorMessage": "Compiling \"GeneratedMetadata_ExplainVisibilityHandler\" in Line 19, Column 14: Line 33, Column 28: Compiling \"isVisibleInExplain(org.apache.calcite.rel.RelNode r, org.apache.calcite.rel.metadata.RelMetadataQuery mq, org.apache.calcite.sql.SqlExplainLevel a2)\"", "context": { "host": null, "errorClass": "org.codehaus.commons.compiler.InternalCompilerException", "legacyErrorCode": "Unknown exception" } }

sql: { "error": "Unknown exception", "errorClass": "org.codehaus.commons.compiler.InternalCompilerException", "host": null, "errorCode": "legacyQueryException", "persona": "OPERATOR", "category": "RUNTIME_FAILURE", "errorMessage": "Compiling \"GeneratedMetadata_CollationHandler\" in Line 19, Column 14: Line 31, Column 50: Compiling \"collations(org.apache.calcite.rel.RelNode r, org.apache.calcite.rel.metadata.RelMetadataQuery mq)\"", "context": { "host": null, "errorClass": "org.codehaus.commons.compiler.InternalCompilerException", "legacyErrorCode": "Unknown exception" } } status: { "cause2":"io.kubernetes.client.openapi.ApiException: ", "cause1":"org.apache.druid.java.util.common.RE: Failed to get current leader for [druid-it-leaderelection-coordinator]", "servlet":"org.apache.druid.server.AsyncManagementForwardingServlet-924f3f1", "cause0":"java.lang.RuntimeException: org.apache.druid.java.util.common.RE: Failed to get current leader for [druid-it-leaderelection-coordinator]", "message":"java.lang.RuntimeException: org.apache.druid.java.util.common.RE: Failed to get current leader for [druid-it-leaderelection-coordinator]", "url":"/druid/coordinator/v1/lookups/status", "status":"500" }

CoinCoderBuffalo commented 6 months ago

@abhishekagarwal87 any update on this issue?