aurora-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bill Farner (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (AURORA-605) Tests fail on duplicate table in H2
Date Sat, 26 Jul 2014 04:18:38 GMT

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

Bill Farner updated AURORA-605:
-------------------------------

    Summary: Tests fail on duplicate table in H2  (was: Tests fail intermittently on duplicate
table in H2)

> Tests fail on duplicate table in H2
> -----------------------------------
>
>                 Key: AURORA-605
>                 URL: https://issues.apache.org/jira/browse/AURORA-605
>             Project: Aurora
>          Issue Type: Bug
>            Reporter: Bill Farner
>            Assignee: Bill Farner
>
> Here's example output from a failing test:
> {noformat}
> java.lang.IllegalStateException: Expected the service to be RUNNING, but the service
has FAILED
> 	at com.google.common.util.concurrent.AbstractService.checkCurrentState(AbstractService.java:334)
> 	at com.google.common.util.concurrent.AbstractService.awaitRunning(AbstractService.java:277)
> 	at com.google.common.util.concurrent.AbstractIdleService.awaitRunning(AbstractIdleService.java:177)
> 	at org.apache.aurora.scheduler.storage.db.DbStorage.prepare(DbStorage.java:148)
> 	at org.apache.aurora.scheduler.storage.db.DbSchedulerStoreTest.setUp(DbSchedulerStoreTest.java:41)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> 	at java.lang.reflect.Method.invoke(Method.java:606)
> 	at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:47)
> 	at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
> 	at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:44)
> 	at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:24)
> 	at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:271)
> 	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:70)
> 	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:50)
> 	at org.junit.runners.ParentRunner$3.run(ParentRunner.java:238)
> 	at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:63)
> 	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:236)
> 	at org.junit.runners.ParentRunner.access$000(ParentRunner.java:53)
> 	at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:229)
> 	at org.junit.runners.ParentRunner.run(ParentRunner.java:309)
> 	at org.gradle.api.internal.tasks.testing.junit.JUnitTestClassExecuter.runTestClass(JUnitTestClassExecuter.java:86)
> 	at org.gradle.api.internal.tasks.testing.junit.JUnitTestClassExecuter.execute(JUnitTestClassExecuter.java:49)
> 	at org.gradle.api.internal.tasks.testing.junit.JUnitTestClassProcessor.processTestClass(JUnitTestClassProcessor.java:69)
> 	at org.gradle.api.internal.tasks.testing.SuiteTestClassProcessor.processTestClass(SuiteTestClassProcessor.java:48)
> 	at sun.reflect.GeneratedMethodAccessor46.invoke(Unknown Source)
> 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> 	at java.lang.reflect.Method.invoke(Method.java:606)
> 	at org.gradle.messaging.dispatch.ReflectionDispatch.dispatch(ReflectionDispatch.java:35)
> 	at org.gradle.messaging.dispatch.ReflectionDispatch.dispatch(ReflectionDispatch.java:24)
> 	at org.gradle.messaging.dispatch.ContextClassLoaderDispatch.dispatch(ContextClassLoaderDispatch.java:32)
> 	at org.gradle.messaging.dispatch.ProxyDispatchAdapter$DispatchingInvocationHandler.invoke(ProxyDispatchAdapter.java:93)
> 	at com.sun.proxy.$Proxy2.processTestClass(Unknown Source)
> 	at org.gradle.api.internal.tasks.testing.worker.TestWorker.processTestClass(TestWorker.java:105)
> 	at sun.reflect.GeneratedMethodAccessor45.invoke(Unknown Source)
> 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> 	at java.lang.reflect.Method.invoke(Method.java:606)
> 	at org.gradle.messaging.dispatch.ReflectionDispatch.dispatch(ReflectionDispatch.java:35)
> 	at org.gradle.messaging.dispatch.ReflectionDispatch.dispatch(ReflectionDispatch.java:24)
> 	at org.gradle.messaging.remote.internal.hub.MessageHub$Handler.run(MessageHub.java:355)
> 	at org.gradle.internal.concurrent.DefaultExecutorFactory$StoppableExecutorImpl$1.run(DefaultExecutorFactory.java:64)
> 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
> 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> 	at java.lang.Thread.run(Thread.java:744)
> Caused by: org.apache.ibatis.exceptions.PersistenceException: 
> ### Error updating database.  Cause: org.h2.jdbc.JdbcSQLException: Table "FRAMEWORK_ID"
already exists; SQL statement:
> /**
>  * Licensed under the Apache License, Version 2.0 (the "License");
>  * you may not use this file except in compliance with the License.
>  * You may obtain a copy of the License at
>  *
>  *     http://www.apache.org/licenses/LICENSE-2.0
>  *
>  * Unless required by applicable law or agreed to in writing, software
>  * distributed under the License is distributed on an "AS IS" BASIS,
>  * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
>  * See the License for the specific language governing permissions and
>  * limitations under the License.
>  */
> -- schema for h2 engine.
> CREATE TABLE framework_id(
>   id INT PRIMARY KEY,
>   framework_id VARCHAR NOT NULL,
>   UNIQUE(framework_id)
> );
> CREATE TABLE job_keys(
>   id INT IDENTITY,
>   role VARCHAR NOT NULL,
>   environment VARCHAR NOT NULL,
>   name VARCHAR NOT NULL,
>   UNIQUE(role, environment, name)
> );
> CREATE TABLE locks(
>   id INT IDENTITY,
>   job_key_id INT NOT NULL REFERENCES job_keys(id),
>   token VARCHAR NOT NULL,
>   user VARCHAR NOT NULL,
>   timestampMs BIGINT NOT NULL,
>   message VARCHAR,
>   UNIQUE(job_key_id)
> );
> CREATE TABLE quotas(
>   id INT IDENTITY,
>   role VARCHAR NOT NULL,
>   num_cpus FLOAT NOT NULL,
>   ram_mb INT NOT NULL,
>   disk_mb INT NOT NULL,
>   UNIQUE(role)
> );
> CREATE TABLE maintenance_modes(
>   id INT PRIMARY KEY,
>   name VARCHAR NOT NULL,
>   UNIQUE(name)
> );
> CREATE TABLE host_attributes(
>   id INT IDENTITY,
>   host VARCHAR NOT NULL,
>   mode TINYINT NOT NULL REFERENCES maintenance_modes(id),
>   slave_id VARCHAR NOT NULL,
>   UNIQUE(host),
>   UNIQUE(slave_id),
> );
> CREATE TABLE host_attribute_values(
>   id INT IDENTITY,
>   host_attribute_id INT NOT NULL REFERENCES host_attributes(id)
>   ON DELETE CASCADE,
>   name VARCHAR NOT NULL,
>   value VARCHAR NOT NULL,
>   UNIQUE(host_attribute_id, name, value)
> );
>  [42101-177]
> ### The error may involve defaultParameterMap
> ### The error occurred while setting parameters
> ### SQL: /**  * Licensed under the Apache License, Version 2.0 (the "License");  * you
may not use this file except in compliance with the License.  * You may obtain a copy of the
License at  *  *     http://www.apache.org/licenses/LICENSE-2.0  *  * Unless required by applicable
law or agreed to in writing, software  * distributed under the License is distributed on an
"AS IS" BASIS,  * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and  * limitations under
the License.  */  -- schema for h2 engine.  CREATE TABLE framework_id(   id INT PRIMARY KEY,
  framework_id VARCHAR NOT NULL,    UNIQUE(framework_id) );  CREATE TABLE job_keys(   id INT
IDENTITY,   role VARCHAR NOT NULL,   environment VARCHAR NOT NULL,   name VARCHAR NOT NULL,
   UNIQUE(role, environment, name) );  CREATE TABLE locks(   id INT IDENTITY,   job_key_id
INT NOT NULL REFERENCES job_keys(id),   token VARCHAR NOT NULL,   user VARCHAR NOT NULL, 
 timestampMs BIGINT NOT NULL,   message VARCHAR,    UNIQUE(job_key_id) );  CREATE TABLE quotas(
  id INT IDENTITY,   role VARCHAR NOT NULL,   num_cpus FLOAT NOT NULL,   ram_mb INT NOT NULL,
  disk_mb INT NOT NULL,    UNIQUE(role) );  CREATE TABLE maintenance_modes(   id INT PRIMARY
KEY,   name VARCHAR NOT NULL,    UNIQUE(name) );  CREATE TABLE host_attributes(   id INT IDENTITY,
  host VARCHAR NOT NULL,   mode TINYINT NOT NULL REFERENCES maintenance_modes(id),   slave_id
VARCHAR NOT NULL,    UNIQUE(host),   UNIQUE(slave_id), );  CREATE TABLE host_attribute_values(
  id INT IDENTITY,   host_attribute_id INT NOT NULL REFERENCES host_attributes(id)   ON DELETE
CASCADE,   name VARCHAR NOT NULL,   value VARCHAR NOT NULL,    UNIQUE(host_attribute_id, name,
value) );
> ### Cause: org.h2.jdbc.JdbcSQLException: Table "FRAMEWORK_ID" already exists; SQL statement:
> /**
>  * Licensed under the Apache License, Version 2.0 (the "License");
>  * you may not use this file except in compliance with the License.
>  * You may obtain a copy of the License at
>  *
>  *     http://www.apache.org/licenses/LICENSE-2.0
>  *
>  * Unless required by applicable law or agreed to in writing, software
>  * distributed under the License is distributed on an "AS IS" BASIS,
>  * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
>  * See the License for the specific language governing permissions and
>  * limitations under the License.
>  */
> -- schema for h2 engine.
> CREATE TABLE framework_id(
>   id INT PRIMARY KEY,
>   framework_id VARCHAR NOT NULL,
>   UNIQUE(framework_id)
> );
> CREATE TABLE job_keys(
>   id INT IDENTITY,
>   role VARCHAR NOT NULL,
>   environment VARCHAR NOT NULL,
>   name VARCHAR NOT NULL,
>   UNIQUE(role, environment, name)
> );
> CREATE TABLE locks(
>   id INT IDENTITY,
>   job_key_id INT NOT NULL REFERENCES job_keys(id),
>   token VARCHAR NOT NULL,
>   user VARCHAR NOT NULL,
>   timestampMs BIGINT NOT NULL,
>   message VARCHAR,
>   UNIQUE(job_key_id)
> );
> CREATE TABLE quotas(
>   id INT IDENTITY,
>   role VARCHAR NOT NULL,
>   num_cpus FLOAT NOT NULL,
>   ram_mb INT NOT NULL,
>   disk_mb INT NOT NULL,
>   UNIQUE(role)
> );
> CREATE TABLE maintenance_modes(
>   id INT PRIMARY KEY,
>   name VARCHAR NOT NULL,
>   UNIQUE(name)
> );
> CREATE TABLE host_attributes(
>   id INT IDENTITY,
>   host VARCHAR NOT NULL,
>   mode TINYINT NOT NULL REFERENCES maintenance_modes(id),
>   slave_id VARCHAR NOT NULL,
>   UNIQUE(host),
>   UNIQUE(slave_id),
> );
> CREATE TABLE host_attribute_values(
>   id INT IDENTITY,
>   host_attribute_id INT NOT NULL REFERENCES host_attributes(id)
>   ON DELETE CASCADE,
>   name VARCHAR NOT NULL,
>   value VARCHAR NOT NULL,
>   UNIQUE(host_attribute_id, name, value)
> );
>  [42101-177]
> 	at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:26)
> 	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:154)
> 	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:145)
> 	at org.apache.aurora.scheduler.storage.db.DbStorage.startUp(DbStorage.java:176)
> 	at org.mybatis.guice.transactional.TransactionalMethodInterceptor.invoke(TransactionalMethodInterceptor.java:101)
> 	at com.google.common.util.concurrent.AbstractIdleService$2$1.run(AbstractIdleService.java:54)
> 	at com.google.common.util.concurrent.Callables$3.run(Callables.java:93)
> 	... 1 more
> Caused by: org.h2.jdbc.JdbcSQLException: Table "FRAMEWORK_ID" already exists; SQL statement:
> /**
>  * Licensed under the Apache License, Version 2.0 (the "License");
>  * you may not use this file except in compliance with the License.
>  * You may obtain a copy of the License at
>  *
>  *     http://www.apache.org/licenses/LICENSE-2.0
>  *
>  * Unless required by applicable law or agreed to in writing, software
>  * distributed under the License is distributed on an "AS IS" BASIS,
>  * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
>  * See the License for the specific language governing permissions and
>  * limitations under the License.
>  */
> -- schema for h2 engine.
> CREATE TABLE framework_id(
>   id INT PRIMARY KEY,
>   framework_id VARCHAR NOT NULL,
>   UNIQUE(framework_id)
> );
> CREATE TABLE job_keys(
>   id INT IDENTITY,
>   role VARCHAR NOT NULL,
>   environment VARCHAR NOT NULL,
>   name VARCHAR NOT NULL,
>   UNIQUE(role, environment, name)
> );
> CREATE TABLE locks(
>   id INT IDENTITY,
>   job_key_id INT NOT NULL REFERENCES job_keys(id),
>   token VARCHAR NOT NULL,
>   user VARCHAR NOT NULL,
>   timestampMs BIGINT NOT NULL,
>   message VARCHAR,
>   UNIQUE(job_key_id)
> );
> CREATE TABLE quotas(
>   id INT IDENTITY,
>   role VARCHAR NOT NULL,
>   num_cpus FLOAT NOT NULL,
>   ram_mb INT NOT NULL,
>   disk_mb INT NOT NULL,
>   UNIQUE(role)
> );
> CREATE TABLE maintenance_modes(
>   id INT PRIMARY KEY,
>   name VARCHAR NOT NULL,
>   UNIQUE(name)
> );
> CREATE TABLE host_attributes(
>   id INT IDENTITY,
>   host VARCHAR NOT NULL,
>   mode TINYINT NOT NULL REFERENCES maintenance_modes(id),
>   slave_id VARCHAR NOT NULL,
>   UNIQUE(host),
>   UNIQUE(slave_id),
> );
> CREATE TABLE host_attribute_values(
>   id INT IDENTITY,
>   host_attribute_id INT NOT NULL REFERENCES host_attributes(id)
>   ON DELETE CASCADE,
>   name VARCHAR NOT NULL,
>   value VARCHAR NOT NULL,
>   UNIQUE(host_attribute_id, name, value)
> );
>  [42101-177]
> 	at org.h2.message.DbException.getJdbcSQLException(DbException.java:344)
> 	at org.h2.message.DbException.get(DbException.java:178)
> 	at org.h2.message.DbException.get(DbException.java:154)
> 	at org.h2.command.ddl.CreateTable.update(CreateTable.java:110)
> 	at org.h2.command.CommandContainer.update(CommandContainer.java:79)
> 	at org.h2.command.Command.executeUpdate(Command.java:254)
> 	at org.h2.command.CommandList.update(CommandList.java:43)
> 	at org.h2.command.Command.executeUpdate(Command.java:254)
> 	at org.h2.jdbc.JdbcPreparedStatement.execute(JdbcPreparedStatement.java:199)
> 	at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:44)
> 	at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:69)
> 	at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:48)
> 	at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:105)
> 	at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:71)
> 	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:152)
> 	... 6 more
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message