[ 
https://issues.apache.org/jira/browse/IMPALA-13207?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17865520#comment-17865520
 ] 

Michael Smith commented on IMPALA-13207:
----------------------------------------

You also need to {{enable_workload_mgmt}} on catalogd to add an exception 
around blacklisted_dbs. That error message could be updated to mention it.

> The 'sys' database for system tables blacklisted by default
> -----------------------------------------------------------
>
>                 Key: IMPALA-13207
>                 URL: https://issues.apache.org/jira/browse/IMPALA-13207
>             Project: IMPALA
>          Issue Type: Bug
>            Reporter: YifanZhang
>            Priority: Major
>
> When enabling `enable_workload_mgmt` in a cluster, the impalad failed to 
> start with a FATAL error:
> {code:java}
> F0710 17:46:51.211848 456937 workload-management.cc:346] AnalysisException: 
> Database does not exist: sys. Impalad exiting. {code}
> There was also a db creation error in the log before this error happened:
> {code:java}
> I0710 17:46:51.169672 456951 client-request-state.cc:1348] 
> 744c895a3184553c:0759f54000000000] IllegalStateException: Can't create 
> blacklisted database: sys. --blacklisted_dbs may be inconsistent between 
> catalogd and coordinators {code}
> We must change the default value of the impalad/catalogd flag 
> 'blacklisted_dbs' to enable the query log table. Maybe we should add a 
> validator for 'enable_workload_mgmt' to avoid any conflicts.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to