linkedin
MySqlAccountService.updateAccounts got id conflict and didn't retry
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:?]
