btalukder-ea commented on issue #17870:
URL: https://github.com/apache/druid/issues/17870#issuecomment-2817981187
```
used BOOLEAN NOT NULL,
payload BYTEA NOT NULL,
used_status_last_updated VARCHAR(255) NOT NULL,
PRIMARY KEY (id)
) was aborted: ERROR: relation "druid_segments" already exists Call
getNextException to see other errors in the batch.
at
org.postgresql.jdbc.BatchResultHandler.handleCompletion(BatchResultHandler.java:186)
~[?:?]
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:590)
~[?:?]
at
org.postgresql.jdbc.PgStatement.internalExecuteBatch(PgStatement.java:912)
~[?:?]
at
org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:936) ~[?:?]
at
org.apache.commons.dbcp2.DelegatingStatement.executeBatch(DelegatingStatement.java:345)
~[commons-dbcp2-2.0.1.jar:2.0.1]
at
org.apache.commons.dbcp2.DelegatingStatement.executeBatch(DelegatingStatement.java:345)
~[commons-dbcp2-2.0.1.jar:2.0.1]
at org.skife.jdbi.v2.Batch.execute(Batch.java:121)
~[jdbi-2.63.1.jar:2.63.1]
at
org.apache.druid.metadata.SQLMetadataConnector.lambda$createTable$2(SQLMetadataConnector.java:227)
~[druid-server-32.0.1.jar:32.0.1]
at org.skife.jdbi.v2.DBI.withHandle(DBI.java:281)
~[jdbi-2.63.1.jar:2.63.1]
... 22 more
Caused by: org.postgresql.util.PSQLException: ERROR: relation
"druid_segments" already exists
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2725)
~[?:?]
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2412)
~[?:?]
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:579)
~[?:?]
at
org.postgresql.jdbc.PgStatement.internalExecuteBatch(PgStatement.java:912)
~[?:?]
at
org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:936) ~[?:?]
at
org.apache.commons.dbcp2.DelegatingStatement.executeBatch(DelegatingStatement.java:345)
~[commons-dbcp2-2.0.1.jar:2.0.1]
at
org.apache.commons.dbcp2.DelegatingStatement.executeBatch(DelegatingStatement.java:345)
~[commons-dbcp2-2.0.1.jar:2.0.1]
at org.skife.jdbi.v2.Batch.execute(Batch.java:121)
~[jdbi-2.63.1.jar:2.63.1]
at
org.apache.druid.metadata.SQLMetadataConnector.lambda$createTable$2(SQLMetadataConnector.java:227)
~[druid-server-32.0.1.jar:32.0.1]
at org.skife.jdbi.v2.DBI.withHandle(DBI.java:281)
~[jdbi-2.63.1.jar:2.63.1]
... 22 more
2025-04-21T08:44:01,337 INFO [main]
org.apache.druid.metadata.SQLMetadataConnector - Adding columns
[upgraded_from_segment_id, used_status_last_updated] to table[druid_segments].
2025-04-21T08:44:01,338 INFO [main]
org.apache.druid.metadata.SQLMetadataConnector - Table[druid_segments] doesn't
exist.
2025-04-21T08:44:01,343 INFO [main]
org.apache.druid.metadata.SQLMetadataConnector - Creating Index on Table
[druid_segments], sql: [CREATE INDEX
idx_druid_segments_datasource_upgraded_from_segment_id ON
druid_segments(dataSource,upgraded_from_segment_id)]
2025-04-21T08:44:01,344 ERROR [main]
org.apache.druid.metadata.SQLMetadataConnector - Exception while creating index
on table [druid_segments]
org.skife.jdbi.v2.exceptions.CallbackFailedException:
org.skife.jdbi.v2.exceptions.UnableToExecuteStatementException:
org.postgresql.util.PSQLException: ERROR: column "upgraded_from_segment_id"
does not exist [statement:"CREATE INDEX
idx_druid_segments_datasource_upgraded_from_segment_id ON
druid_segments(dataSource,upgraded_from_segment_id)", located:"CREATE INDEX
idx_druid_segments_datasource_upgraded_from_segment_id ON
druid_segments(dataSource,upgraded_from_segment_id)", rewritten:"CREATE INDEX
idx_druid_segments_datasource_upgraded_from_segment_id ON
druid_segments(dataSource,upgraded_from_segment_id)", arguments:{
positional:{}, named:{}, finder:[]}]
at org.skife.jdbi.v2.DBI.withHandle(DBI.java:284)
~[jdbi-2.63.1.jar:2.63.1]
at
org.apache.druid.metadata.SQLMetadataConnector.lambda$retryWithHandle$0(SQLMetadataConnector.java:157)
~[druid-server-32.0.1.jar:32.0.1]
at
org.apache.druid.java.util.common.RetryUtils.retry(RetryUtils.java:129)
~[druid-processing-32.0.1.jar:32.0.1]
at
org.apache.druid.java.util.common.RetryUtils.retry(RetryUtils.java:81)
~[druid-processing-32.0.1.jar:32.0.1]
at
org.apache.druid.java.util.common.RetryUtils.retry(RetryUtils.java:163)
~[druid-processing-32.0.1.jar:32.0.1]
at
org.apache.druid.java.util.common.RetryUtils.retry(RetryUtils.java:153)
~[druid-processing-32.0.1.jar:32.0.1]
at
org.apache.druid.metadata.SQLMetadataConnector.retryWithHandle(SQLMetadataConnector.java:157)
~[druid-server-32.0.1.jar:32.0.1]
at
org.apache.druid.metadata.SQLMetadataConnector.retryWithHandle(SQLMetadataConnector.java:167)
~[druid-server-32.0.1.jar:32.0.1]
at
org.apache.druid.metadata.SQLMetadataConnector.createIndex(SQLMetadataConnector.java:1082)
[druid-server-32.0.1.jar:32.0.1]
at
org.apache.druid.metadata.SQLMetadataConnector.alterSegmentTable(SQLMetadataConnector.java:607)
[druid-server-32.0.1.jar:32.0.1]
at
org.apache.druid.metadata.SQLMetadataConnector.createSegmentTable(SQLMetadataConnector.java:760)
[druid-server-32.0.1.jar:32.0.1]
at
org.apache.druid.metadata.IndexerSQLMetadataStorageCoordinator.start(IndexerSQLMetadataStorageCoordinator.java:149)
[druid-server-32.0.1.jar:32.0.1]
at
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[?:?]
at
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
~[?:?]
at
java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[?:?]
at java.base/java.lang.reflect.Method.invoke(Method.java:569) ~[?:?]
at
org.apache.druid.java.util.common.lifecycle.Lifecycle$AnnotationBasedHandler.start(Lifecycle.java:446)
[druid-processing-32.0.1.jar:32.0.1]
at
org.apache.druid.java.util.common.lifecycle.Lifecycle.start(Lifecycle.java:341)
[druid-processing-32.0.1.jar:32.0.1]
at
org.apache.druid.guice.LifecycleModule$2.start(LifecycleModule.java:152)
[druid-processing-32.0.1.jar:32.0.1]
at
org.apache.druid.cli.GuiceRunnable.initLifecycle(GuiceRunnable.java:136)
[druid-services-32.0.1.jar:32.0.1]
at
org.apache.druid.cli.GuiceRunnable.initLifecycle(GuiceRunnable.java:94)
[druid-services-32.0.1.jar:32.0.1]
at org.apache.druid.cli.ServerRunnable.run(ServerRunnable.java:70)
[druid-services-32.0.1.jar:32.0.1]
at org.apache.druid.cli.Main.main(Main.java:112)
[druid-services-32.0.1.jar:32.0.1]
Caused by: org.skife.jdbi.v2.exceptions.UnableToExecuteStatementException:
org.postgresql.util.PSQLException: ERROR: column "upgraded_from_segment_id"
does not exist [statement:"CREATE INDEX
idx_druid_segments_datasource_upgraded_from_segment_id ON
druid_segments(dataSource,upgraded_from_segment_id)", located:"CREATE INDEX
idx_druid_segments_datasource_upgraded_from_segment_id ON
druid_segments(dataSource,upgraded_from_segment_id)", rewritten:"CREATE INDEX
idx_druid_segments_datasource_upgraded_from_segment_id ON
druid_segments(dataSource,upgraded_from_segment_id)", arguments:{
positional:{}, named:{}, finder:[]}]
at
org.skife.jdbi.v2.SQLStatement.internalExecute(SQLStatement.java:1334)
~[jdbi-2.63.1.jar:2.63.1]
at org.skife.jdbi.v2.Update.execute(Update.java:56)
~[jdbi-2.63.1.jar:2.63.1]
at org.skife.jdbi.v2.BasicHandle.update(BasicHandle.java:294)
~[jdbi-2.63.1.jar:2.63.1]
at org.skife.jdbi.v2.BasicHandle.execute(BasicHandle.java:412)
~[jdbi-2.63.1.jar:2.63.1]
```
--
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]
