btalukder-ea opened a new issue, #17870:
URL: https://github.com/apache/druid/issues/17870
We were setting up druid version 32.0.1 .. using docker-compose
but the coordinator service continuously restarting, when we check the error
it is db migration fail..
DB is fresh db with no previous data.
i think there is a race condition happening due to threads .. if we check
the logs ..
1st it says creating table druid_tasks .. Table[druid_tasks] doesn't exist.
again one line is printed Adding column[type] to table[druid_tasks]. ..
but in the next moment it says task migration failed as column "type" does
not exist
then again in log, one error is printed,
2025-04-03T13:28:38,248 INFO [main]
org.apache.druid.metadata.SQLMetadataConnector - Creating table[druid_config]
2025-04-03T13:28:40,420 INFO [main]
org.apache.druid.metadata.SQLMetadataConnector - Creating table[druid_audit]
2025-04-03T13:28:40,746 INFO [main]
org.apache.druid.metadata.SQLMetadataConnector - **Creating table[druid_tasks]**
2025-04-03T13:28:41,176 INFO [main]
org.apache.druid.metadata.SQLMetadataConnector - Creating Index on Table
[druid_tasks], sql: [CREATE INDEX idx_druid_tasks_active_created_date ON
druid_tasks(active,created_date)]
2025-04-03T13:28:41,677 INFO [main]
org.apache.druid.metadata.SQLMetadataConnector - **Adding column[type] to
table[druid_tasks].**
2025-04-03T13:28:41,870 INFO [main]
org.apache.druid.metadata.SQLMetadataConnector - Adding column[group_id] to
table[druid_tasks].
2025-04-03T13:28:42,070 INFO [main]
org.apache.druid.metadata.SQLMetadataConnector - **Table[druid_tasks] doesn't
exist.**
2025-04-03T13:28:42,264 INFO [main]
org.apache.druid.metadata.SQLMetadataConnector - Creating table[druid_tasklocks]
2025-04-03T13:28:42,579 INFO [main]
org.apache.druid.metadata.SQLMetadataConnector - Creating
table[druid_dataSource]
2025-04-03T13:28:42,890 INFO [main]
org.apache.druid.metadata.SQLMetadataConnector - Creating
table[druid_pendingSegments]
2025-04-03T13:28:43,214 INFO [main]
org.apache.druid.metadata.SQLMetadataConnector - Adding
column[upgraded_from_segment_id] to table[druid_pendingSegments].
2025-04-03T13:28:43,406 INFO [main]
org.apache.druid.metadata.SQLMetadataConnector - Adding
column[task_allocator_id] to table[druid_pendingSegments].
2025-04-03T13:28:43,410 WARN [pool-20-thread-1]
org.apache.druid.metadata.SQLMetadataStorageActionHandler - Task migration
failed while reading entries from task table
org.skife.jdbi.v2.exceptions.CallbackFailedException:
org.skife.jdbi.v2.exceptions.UnableToExecuteStatementException:
org.postgresql.util.PSQLException: ERROR: **column "type" does not exist**
Position: 45 [statement:"SELECT * FROM druid_tasks WHERE id > '' AND type
IS null ORDER BY id LIMIT 100", located:"SELECT * FROM druid_tasks WHERE id >
'' AND type IS null ORDER BY id LIMIT 100", rewritten:"SELECT * FROM
druid_tasks WHERE id > '' AND type IS null ORDER BY id LIMIT 100", arguments:{
positional:{}, named:{}, finder:[]}]
--
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
