MySqlAccountService.updateAccounts got id conflict and didn't retry
@lightningrob is already working on this.
Since Dec 5, 2020.
- Dominant language
- Java
- Stars
- 1.8k
- Forks
- 298
- Avg merge
- 21h 43m
- Merged PRs (30d)
- 9
Description
2020/12/04 22:06:09.476 ERROR [MySqlAccountService] [RequestWorker-4] [ambry-frontend] [] Failed updating accounts=[Account[1256,7]] in MySql DB
java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '1256-15' for key 'PRIMARY'
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:117) ~[mysql-connector-java-8.0.21.jar:8.0.21]
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.21.jar:8.0.21]
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-8.0.21.jar:8.0.21]
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953) ~[mysql-connector-java-8.0.21.jar:8.0.21]
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1092) ~[mysql-connector-java-8.0.21.jar:8.0.21]
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1040) ~[mysql-connector-java-8.0.21.jar:8.0.21]
at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1347) ~[mysql-connector-java-8.0.21.jar:8.0.21]
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1025) ~[mysql-connector-java-8.0.21.jar:8.0.21]
at com.github.ambry.account.mysql.ContainerDao.addContainer(ContainerDao.java:78) ~[ambry-account-0.3.394.jar:?]
at com.github.ambry.account.mysql.MySqlAccountStore.addContainer(MySqlAccountStore.java:92) ~[ambry-account-0.3.394.jar:?]
at com.github.ambry.account.MySqlAccountService.updateContainersWithMySqlStore(MySqlAccountService.java:424) ~[ambry-account-0.3.394.jar:?]
at com.github.ambry.account.MySqlAccountService.updateAccountsWithMySqlStore(MySqlAccountService.java:386) ~[ambry-account-0.3.394.jar:?]
at com.github.ambry.account.MySqlAccountService.updateAccounts(MySqlAccountService.java:275) ~[ambry-account-0.3.394.jar:?]
at com.github.ambry.account.CompositeAccountService.updateAccounts(CompositeAccountService.java:89) ~[ambry-account-0.3.394.jar:?]
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Assessment
This issue has not been assessed yet.