You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@druid.apache.org by GitBox <gi...@apache.org> on 2020/09/05 19:22:56 UTC
[GitHub] [druid] dsx opened a new issue #10361: Coordinator fails to create meta tables in PostgreSQL
dsx opened a new issue #10361:
URL: https://github.com/apache/druid/issues/10361
Coordinator fails to create meta tables in PostgreSQL (see log). It looks like option `druid.metadata.storage.connector.createTables=true` is not idempotent and doesn't use `IF EXISTS` clause.
### Affected Version
0.18.0
0.19.0
### Description
[log.txt](https://github.com/apache/druid/files/5178518/log.txt)
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org
[GitHub] [druid] dsx edited a comment on issue #10361: Coordinator fails to create meta tables in PostgreSQL
Posted by GitBox <gi...@apache.org>.
dsx edited a comment on issue #10361:
URL: https://github.com/apache/druid/issues/10361#issuecomment-688892671
@averma111 it's a run on a completely empty database. Relation has been created by coordinator earlier, see log entry that says `[INFO ] 2020-09-05 19:08:56.748 [main] SQLMetadataConnector - Creating table[druid_config]`.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org
[GitHub] [druid] averma111 commented on issue #10361: Coordinator fails to create meta tables in PostgreSQL
Posted by GitBox <gi...@apache.org>.
averma111 commented on issue #10361:
URL: https://github.com/apache/druid/issues/10361#issuecomment-688597740
**ERROR: relation "druid_config" already exists** already exists in your DB. Please login and check PostgreSQL
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org
[GitHub] [druid] dsx commented on issue #10361: Coordinator fails to create meta tables in PostgreSQL
Posted by GitBox <gi...@apache.org>.
dsx commented on issue #10361:
URL: https://github.com/apache/druid/issues/10361#issuecomment-688900143
Later in my experiments I watched tables being created. If I drop `druid_config`, coordinator can continue. However, after restart if `druid.metadata.storage.connector.createTables=true` is still in effect it can't start again, failing to create already existing tables. It seems to me that it is reasonable to expect schema creation to be re-entrant and idempotent operation.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org
[GitHub] [druid] dsx commented on issue #10361: Coordinator fails to create meta tables in PostgreSQL
Posted by GitBox <gi...@apache.org>.
dsx commented on issue #10361:
URL: https://github.com/apache/druid/issues/10361#issuecomment-688892671
@averma111 it's a run on a completely empty database. relation has been created by coordinator earlier, see log entry that says `[INFO ] 2020-09-05 19:08:56.748 [main] SQLMetadataConnector - Creating table[druid_config]`.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org
[GitHub] [druid] dsx closed issue #10361: Coordinator fails to create meta tables in PostgreSQL
Posted by GitBox <gi...@apache.org>.
dsx closed issue #10361:
URL: https://github.com/apache/druid/issues/10361
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org
[GitHub] [druid] dsx commented on issue #10361: Coordinator fails to create meta tables in PostgreSQL
Posted by GitBox <gi...@apache.org>.
dsx commented on issue #10361:
URL: https://github.com/apache/druid/issues/10361#issuecomment-689736103
Figured out that DB user lacks some permissions, however it is not clear yet what exactly is missing. Is there any info on what permissions are needed?
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org
[GitHub] [druid] dsx edited a comment on issue #10361: Coordinator fails to create meta tables in PostgreSQL
Posted by GitBox <gi...@apache.org>.
dsx edited a comment on issue #10361:
URL: https://github.com/apache/druid/issues/10361#issuecomment-688892671
@averma111 it's a run on a freshly created empty Postgresql instance.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org