Return-Path: X-Original-To: apmail-aurora-issues-archive@minotaur.apache.org Delivered-To: apmail-aurora-issues-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id F3FD4186AA for ; Tue, 30 Jun 2015 20:48:04 +0000 (UTC) Received: (qmail 52673 invoked by uid 500); 30 Jun 2015 20:48:04 -0000 Delivered-To: apmail-aurora-issues-archive@aurora.apache.org Received: (qmail 52630 invoked by uid 500); 30 Jun 2015 20:48:04 -0000 Mailing-List: contact issues-help@aurora.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@aurora.apache.org Delivered-To: mailing list issues@aurora.apache.org Received: (qmail 52544 invoked by uid 99); 30 Jun 2015 20:48:04 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 30 Jun 2015 20:48:04 +0000 Date: Tue, 30 Jun 2015 20:48:04 +0000 (UTC) From: "Kevin Sweeney (JIRA)" To: issues@aurora.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Created] (AURORA-1379) Referential integrity violation when replaying storage MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 Kevin Sweeney created AURORA-1379: ------------------------------------- Summary: 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)