Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 313486 - [DB] Typo in CDODBSchema leads to DB initialization error
Summary: [DB] Typo in CDODBSchema leads to DB initialization error
Status: CLOSED FIXED
Alias: None
Product: EMF
Classification: Modeling
Component: cdo.db (show other bugs)
Version: 3.0   Edit
Hardware: All All
: P3 normal (vote)
Target Milestone: ---   Edit
Assignee: Stefan Winkler CLA
QA Contact: Eike Stepper CLA
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-05-19 05:11 EDT by Stefan Winkler CLA
Modified: 2010-06-29 04:36 EDT (History)
1 user (show)

See Also:

Attachments
Patch (1.04 KB, patch)
2010-05-19 05:57 EDT, Stefan Winkler CLA 		no flags Details | Diff
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Stefan Winkler CLA 2010-05-19 05:11:19 EDT 
Reported in the Newsgroup:

app thread - org.eclipse.emf.cdo.server.app.0 [debug.sql] CREATE TABLE
cdo_objects (cdo_id BIGINT, cdo_class BIGINT, cdo_created BIGINT)
app thread - org.eclipse.emf.cdo.server.app.0 [debug.sql] CREATE UNIQUE
INDEX cdo_objects_idx0 ON cdo_objects (cdo_id)
app thread - org.eclipse.emf.cdo.server.app.0 [debug.sql] CREATE TABLE
cdo_branches (id INTEGER, name text, base_id INTEGER, base_time BIGINT)
app thread - org.eclipse.emf.cdo.server.app.0 [debug.sql] CREATE INDEX
cdo_branches_idx0 ON cdo_branches (id)
app thread - org.eclipse.emf.cdo.server.app.0 [debug.sql] CREATE INDEX
cdo_branches_idx1 ON cdo_branches (commit_time)
app thread - org.eclipse.emf.cdo.server.app.0 [debug.sql] -- ERROR:
Column »commit_time« does not exist. Trying to rollback operation
[ERROR] ERROR: Relation »cdo_branches« does not exist
org.eclipse.net4j.db.DBException: ERROR: Relation »cdo_branches« does
not exist
	at org.eclipse.net4j.spi.db.DBAdapter.validateTable(DBAdapter.java:423)
	at
org.eclipse.net4j.db.postgresql.PostgreSQLAdapter.createTable(PostgreSQLAdapter.java:164)
	at org.eclipse.net4j.spi.db.DBAdapter.createTables(DBAdapter.java:109)
	at org.eclipse.net4j.spi.db.DBSchema.create(DBSchema.java:106)
	at
org.eclipse.emf.cdo.server.internal.db.DBStore.doActivate(DBStore.java:442)
	at org.eclipse.net4j.util.lifecycle.Lifecycle.activate(Lifecycle.java:72)
	at
org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:98)
	at
org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:88)
	at
org.eclipse.emf.cdo.internal.server.Repository.doActivate(Repository.java:1276)
	at org.eclipse.net4j.util.lifecycle.Lifecycle.activate(Lifecycle.java:72)
	at
org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:98)
	at
org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:88)
	at
org.eclipse.emf.cdo.server.CDOServerUtil.addRepository(CDOServerUtil.java:128)
	at
org.eclipse.emf.cdo.internal.server.RepositoryConfigurator.configure(RepositoryConfigurator.java:93)
	at
org.eclipse.emf.cdo.internal.server.bundle.CDOServerApplication.doStart(CDOServerApplication.java:58)
	at org.eclipse.net4j.util.om.OSGiApplication.start(OSGiApplication.java:61)
	at
org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:194)
	at
org.eclipse.equinox.internal.app.AnyThreadAppLauncher.run(AnyThreadAppLauncher.java:26)
	at java.lang.Thread.run(Thread.java:619)
Comment 1 Stefan Winkler CLA 2010-05-19 05:57:47 EDT 
Created attachment 169080 [details]
Patch

change obvious typo BRANCHES to COMMIT_INFOS for the respective index
Comment 2 Stefan Winkler CLA 2010-05-19 06:04:15 EDT 
Committed to HEAD
Comment 3 Eike Stepper CLA 2010-06-29 04:36:34 EDT 
Available in 3.0 GA:
http://download.eclipse.org/modeling/emf/cdo/updates/3.0-releases/