You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@aurora.apache.org by "Chris Lambert (JIRA)" <ji...@apache.org> on 2015/07/06 22:11:04 UTC

[jira] [Updated] (AURORA-1379) Referential integrity violation when replaying storage

     [ https://issues.apache.org/jira/browse/AURORA-1379?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Chris Lambert updated AURORA-1379:
----------------------------------
    Sprint: Twitter Aurora Q2'15 Sprint 6, Twitter Aurora Q2'15 Sprint 7  (was: Twitter Aurora Q2'15 Sprint 6)

> Referential integrity violation when replaying storage
> ------------------------------------------------------
>
>                 Key: AURORA-1379
>                 URL: https://issues.apache.org/jira/browse/AURORA-1379
>             Project: Aurora
>          Issue Type: Bug
>          Components: Scheduler
>            Reporter: Kevin Sweeney
>            Assignee: Bill Farner
>
> At startup in the Vagrant environment I observed:
> {noformat}
> E0630 20:45:54.427 THREAD1 org.apache.aurora.scheduler.SchedulerLifecycle$9.execute: Caught unchecked exception: org.apache.aurora.scheduler.storage.Storage$StorageExce
> ption: 
> ### Error updating database.  Cause: org.h2.jdbc.JdbcSQLException: Referential integrity constraint violation: "CONSTRAINT_4BE: PUBLIC.TASKS FOREIGN KEY(SLAVE_ROW_ID) R
> EFERENCES PUBLIC.HOST_ATTRIBUTES(ID) (1)"; SQL statement:
> DELETE FROM host_attributes
>     WHERE host = ? [23503-187]
> ### The error may involve defaultParameterMap
> ### The error occurred while setting parameters
> ### SQL: DELETE FROM host_attributes     WHERE host = ?
> ### Cause: org.h2.jdbc.JdbcSQLException: Referential integrity constraint violation: "CONSTRAINT_4BE: PUBLIC.TASKS FOREIGN KEY(SLAVE_ROW_ID) REFERENCES PUBLIC.HOST_ATTR
> IBUTES(ID) (1)"; SQL statement:
> DELETE FROM host_attributes
>     WHERE host = ? [23503-187]
> org.apache.aurora.scheduler.storage.Storage$StorageException: 
> ### Error updating database.  Cause: org.h2.jdbc.JdbcSQLException: Referential integrity constraint violation: "CONSTRAINT_4BE: PUBLIC.TASKS FOREIGN KEY(SLAVE_ROW_ID) R
> EFERENCES PUBLIC.HOST_ATTRIBUTES(ID) (1)"; SQL statement:
> DELETE FROM host_attributes
>     WHERE host = ? [23503-187]
> ### The error may involve defaultParameterMap
> ### The error occurred while setting parameters
> ### SQL: DELETE FROM host_attributes     WHERE host = ?
> ### Cause: org.h2.jdbc.JdbcSQLException: Referential integrity constraint violation: "CONSTRAINT_4BE: PUBLIC.TASKS FOREIGN KEY(SLAVE_ROW_ID) REFERENCES PUBLIC.HOST_ATTR
> IBUTES(ID) (1)"; SQL statement:
> DELETE FROM host_attributes
>     WHERE host = ? [23503-187]
>         at org.apache.aurora.scheduler.storage.db.DbStorage.write(DbStorage.java:144)
>         at org.mybatis.guice.transactional.TransactionalMethodInterceptor.invoke(TransactionalMethodInterceptor.java:101)
>         at com.twitter.common.inject.TimedInterceptor.invoke(TimedInterceptor.java:87)
>         at org.apache.aurora.scheduler.storage.log.LogStorage.write(LogStorage.java:632)
>         at org.apache.aurora.scheduler.storage.log.LogStorage$3.execute(LogStorage.java:316)
>         at org.apache.aurora.scheduler.storage.log.LogStorage$3.execute(LogStorage.java:313)
>         at org.apache.aurora.scheduler.storage.log.LogStorage.replay(LogStorage.java:525)
>         at org.apache.aurora.scheduler.storage.log.LogStorage.access$1200(LogStorage.java:116)
>         at org.apache.aurora.scheduler.storage.log.LogStorage$21$1.execute(LogStorage.java:503)
>         at org.apache.aurora.scheduler.storage.log.LogStorage$21$1.execute(LogStorage.java:500)
>         at org.apache.aurora.scheduler.storage.log.StreamManagerImpl.readFromBeginning(StreamManagerImpl.java:127)
>         at org.apache.aurora.scheduler.storage.log.LogStorage$21.execute(LogStorage.java:500)
>         at org.apache.aurora.scheduler.storage.Storage$MutateWork$NoResult.apply(Storage.java:131)
>         at org.apache.aurora.scheduler.storage.db.DbStorage.bulkLoad(DbStorage.java:165)
>         at com.twitter.common.inject.TimedInterceptor.invoke(TimedInterceptor.java:87)
>         at org.apache.aurora.scheduler.storage.log.LogStorage.recover(LogStorage.java:496)
>         at com.twitter.common.inject.TimedInterceptor.invoke(TimedInterceptor.java:87)
>         at org.apache.aurora.scheduler.storage.log.LogStorage$20.execute(LogStorage.java:477)
>         at org.apache.aurora.scheduler.storage.Storage$MutateWork$NoResult.apply(Storage.java:131)
>         at org.apache.aurora.scheduler.storage.Storage$MutateWork$NoResult$Quiet.apply(Storage.java:148)
>         at org.apache.aurora.scheduler.storage.db.DbStorage.write(DbStorage.java:142)
>         at org.mybatis.guice.transactional.TransactionalMethodInterceptor.invoke(TransactionalMethodInterceptor.java:101)
>         at com.twitter.common.inject.TimedInterceptor.invoke(TimedInterceptor.java:87)
>         at org.apache.aurora.scheduler.storage.log.LogStorage.write(LogStorage.java:632)
>         at org.apache.aurora.scheduler.storage.log.LogStorage.start(LogStorage.java:471)
>         at org.apache.aurora.scheduler.storage.CallOrderEnforcingStorage.start(CallOrderEnforcingStorage.java:92)
>         at org.apache.aurora.scheduler.SchedulerLifecycle$6.execute(SchedulerLifecycle.java:252)
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)