You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@amoro.apache.org by "klion26 (via GitHub)" <gi...@apache.org> on 2025/05/12 01:22:52 UTC
[I] [Bug]: duplicate key value in a unique or primary key constraint or unique index identified by 'TABLE_RUNTIME_PK' defined on 'TABLE_RUNTIME' [amoro]
klion26 opened a new issue, #3558:
URL: https://github.com/apache/amoro/issues/3558
### What happened?
16:41:04.578 INFO org.apache.amoro.server.table.DefaultTableService: Syncing external catalogs took 39 ms.
[INFO] Tests run: 5, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 1.196 s - in org.apache.amoro.server.persistence.TestPersistentBase
[INFO]
[INFO] Results:
[INFO]
Error: Failures:
Error: TestInternalMixedCatalogService$TestDatabaseOperation.test:168 expected: <true> but was: <false>
Error: Errors:
Error: TestInternalMixedCatalogService$TestTableCommit.testTableCommit:265 » ServiceFailure Server error: PersistenceException: org.apache.ibatis.exceptions.PersistenceException:
### Error updating database. Cause: org.apache.derby.shared.common.error.DerbySQLIntegrityConstraintViolationException: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'TABLE_RUNTIME_PK' defined on 'TABLE_RUNTIME'.
### The error may exist in org/apache/amoro/server/persistence/mapper/TableMetaMapper.java (best guess)
### The error may involve org.apache.amoro.server.persistence.mapper.TableMetaMapper.insertTableRuntime-Inline
### The error occurred while setting parameters
### SQL: INSERT INTO table_runtime (table_id, catalog_name, db_name, table_name, current_snapshot_id, current_change_snapshotId, last_optimized_snapshotId, last_optimized_change_snapshotId, last_major_optimizing_time, last_minor_optimizing_time, last_full_optimizing_time, optimizing_status_code, optimizing_status_start_time, optimizing_process_id, optimizer_group, table_config, pending_input, table_summary) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
### Cause: org.apache.derby.shared.common.error.DerbySQLIntegrityConstraintViolationException: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'TABLE_RUNTIME_PK' defined on 'TABLE_RUNTIME'.
Error: TestInternalMixedCatalogService$TestTableOperation.before:186 » AlreadyExists Database: test_ns already exists.
Error: TestInternalMixedCatalogService$TestTableOperation.before:186 » AlreadyExists Database: test_ns already exists.
[INFO]
https://github.com/apache/amoro/actions/runs/14957630498/job/42015437155?pr=3555
### Affects Versions
master
### What table formats are you seeing the problem on?
_No response_
### What engines are you seeing the problem on?
_No response_
### How to reproduce
_No response_
### Relevant log output
```shell
```
### Anything else
_No response_
### Are you willing to submit a PR?
- [ ] Yes I am willing to submit a PR!
### Code of Conduct
- [x] I agree to follow this project's Code of Conduct
--
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: commits-unsubscribe@amoro.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug]: duplicate key value in a unique or primary key constraint or unique index identified by 'TABLE_RUNTIME_PK' defined on 'TABLE_RUNTIME' [amoro]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #3558:
URL: https://github.com/apache/amoro/issues/3558#issuecomment-3672803179
This issue has been closed because it has not received any activity in the last 14 days since being marked as 'stale'
--
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: commits-unsubscribe@amoro.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug]: duplicate key value in a unique or primary key constraint or unique index identified by 'TABLE_RUNTIME_PK' defined on 'TABLE_RUNTIME' [amoro]
Posted by "klion26 (via GitHub)" <gi...@apache.org>.
klion26 commented on issue #3558:
URL: https://github.com/apache/amoro/issues/3558#issuecomment-2948456843
another case https://github.com/apache/amoro/actions/runs/15481818593/job/43588911234?pr=3600
--
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: commits-unsubscribe@amoro.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug]: duplicate key value in a unique or primary key constraint or unique index identified by 'TABLE_RUNTIME_PK' defined on 'TABLE_RUNTIME' [amoro]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] closed issue #3558: [Bug]: duplicate key value in a unique or primary key constraint or unique index identified by 'TABLE_RUNTIME_PK' defined on 'TABLE_RUNTIME'
URL: https://github.com/apache/amoro/issues/3558
--
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: commits-unsubscribe@amoro.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug]: duplicate key value in a unique or primary key constraint or unique index identified by 'TABLE_RUNTIME_PK' defined on 'TABLE_RUNTIME' [amoro]
Posted by "klion26 (via GitHub)" <gi...@apache.org>.
klion26 commented on issue #3558:
URL: https://github.com/apache/amoro/issues/3558#issuecomment-2948482041
another case https://github.com/apache/amoro/actions/runs/15465788441/job/43537430320?pr=3557
--
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: commits-unsubscribe@amoro.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug]: duplicate key value in a unique or primary key constraint or unique index identified by 'TABLE_RUNTIME_PK' defined on 'TABLE_RUNTIME' [amoro]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #3558:
URL: https://github.com/apache/amoro/issues/3558#issuecomment-3609340631
This issue has been automatically marked as stale because it has been open for 180 days with no activity. It will be closed in next 14 days if no further activity occurs. To permanently prevent this issue from being considered stale, add the label 'not-stale', but commenting on the issue is preferred when possible.
--
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: commits-unsubscribe@amoro.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org