[AURORA-596] SQL constraint violation in DbAttributeStore

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.5.0
• Component/s: Scheduler
• Assignee: Bill Farner
• Reporter: Bill Farner
• Created: 23/Jul/14 01:11
• Updated: 24/Jul/14 02:36
• Resolved: 23/Jul/14 02:20

Description

W0723 01:00:28.079 THREAD130 org.apache.aurora.GuiceUtils$7.invoke: Trapped uncaught exception: org.apache.ibatis.exceptions.PersistenceException:
### Error updating database.  Cause: org.h2.jdbc.JdbcSQLException: Unique index or primary key violation: "CONSTRAINT_INDEX_49E ON PUBLIC.HOST_ATTRIBUTES(HOST) VALUES ( /* key:1 */ 2, '192.168.33.7', 1, '20140723-002338-119646400-5050-1087-0')"; SQL statement:
INSERT INTO host_attributes (
      host,
      mode,
      slave_id
    ) VALUES (
      ?,
      ?,
      ?
    ) [23505-177]