[
https://issues.apache.org/jira/browse/HDDS-4497?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17237551#comment-17237551
]
Aravindan Vijayan commented on HDDS-4497:
-----------------------------------------
There may be an issue around
{code}
dslContext.truncate(FILE_COUNT_BY_SIZE);
{code}
Maybe we have to explicitly call on .execute() or use .delete instead of
.truncate.
> Recon File Size Count task throws SQL Exception.
> ------------------------------------------------
>
> Key: HDDS-4497
> URL: https://issues.apache.org/jira/browse/HDDS-4497
> Project: Hadoop Distributed Data Store
> Issue Type: Bug
> Components: Ozone Recon
> Reporter: Aravindan Vijayan
> Assignee: Vivek Ratnavel Subramanian
> Priority: Major
>
> {code}
> Caused by: org.jooq.exception.DataAccessException: SQL [insert into
> FILE_COUNT_BY_SIZE (volume, bucket, file_size, count) values (?, ?, ?, ?)];
> [SQLITE_CONSTRAINT] Abort due to constraint violation (UNIQUE constraint
> failed: FILE_COUNT_BY_SIZE.volume, FILE_COUNT_BY_SIZE.bucket,
> FILE_COUNT_BY_SIZE.file_size)
> at org.jooq_3.11.9.SQLITE.debug(Unknown Source)
> at org.jooq.impl.Tools.translate(Tools.java:2429)
> at
> org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:832)
> at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:364)
> at
> org.jooq.impl.TableRecordImpl.storeInsert0(TableRecordImpl.java:202)
> at org.jooq.impl.TableRecordImpl$1.operate(TableRecordImpl.java:173)
> at org.jooq.impl.RecordDelegate.operate(RecordDelegate.java:125)
> at org.jooq.impl.TableRecordImpl.storeInsert(TableRecordImpl.java:169)
> at org.jooq.impl.TableRecordImpl.insert(TableRecordImpl.java:157)
> at org.jooq.impl.TableRecordImpl.insert(TableRecordImpl.java:152)
> at org.jooq.impl.DAOImpl.insert(DAOImpl.java:175)
> at org.jooq.impl.DAOImpl.insert(DAOImpl.java:151)
> at
> org.apache.hadoop.ozone.recon.tasks.FileSizeCountTask.lambda$writeCountsToDB$0(FileSizeCountTask.java:209)
> at java.util.HashMap$KeySet.forEach(HashMap.java:933)
> at
> org.apache.hadoop.ozone.recon.tasks.FileSizeCountTask.writeCountsToDB(FileSizeCountTask.java:181)
> at
> org.apache.hadoop.ozone.recon.tasks.FileSizeCountTask.reprocess(FileSizeCountTask.java:100)
> at
> org.apache.hadoop.ozone.recon.tasks.ReconTaskControllerImpl.lambda$reInitializeTasks$3(ReconTaskControllerImpl.java:175)
> at java.util.concurrent.FutureTask.run(FutureTask.java:266)
> ... 3 more
> Caused by: org.sqlite.SQLiteException: [SQLITE_CONSTRAINT] Abort due to
> constraint violation (UNIQUE constraint failed: FILE_COUNT_BY_SIZE.volume,
> FILE_COUNT_BY_SIZE.bucket, FILE_COUNT_BY_SIZE.file_size)
> at org.sqlite.core.DB.newSQLException(DB.java:941)
> at org.sqlite.core.DB.newSQLException(DB.java:953)
> at org.sqlite.core.DB.execute(DB.java:854)
> at org.sqlite.core.DB.executeUpdate(DB.java:895)
> at
> org.sqlite.jdbc3.JDBC3PreparedStatement.executeUpdate(JDBC3PreparedStatement.java:102)
> at
> org.jooq.tools.jdbc.DefaultPreparedStatement.executeUpdate(DefaultPreparedStatement.java:99)
> at org.jooq.impl.AbstractDMLQuery.execute(AbstractDMLQuery.java:629)
> at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:350)
> ... 17 more
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
