Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Modeling » EMF » [CDO] Possible bug with InnoDB?
[CDO] Possible bug with InnoDB? [message #725670] Thu, 15 September 2011 14:00 Go to next message
erpalma2003 is currently offline erpalma2003Friend
Messages: 12
Registered: July 2011
Junior Member
Using MySQL 5.1.56 + InnoDB + CDO 4.0 (DBStore) I'm getting this when trying to tweak "innodb_log_file_size" from 5MB to >5MB:


[INFO] CDO server starting
[ERROR] Problem with table cdo_lobs: SELECT id, size, bdata, cdata FROM cdo_lobs
org.eclipse.net4j.db.DBException: Problem with table cdo_lobs: SELECT id, size, bdata, cdata FROM cdo_lobs
        at org.eclipse.net4j.spi.db.DBAdapter.validateTable(DBAdapter.java:439)
        at org.eclipse.net4j.spi.db.DBAdapter.createTable(DBAdapter.java:146)
        at org.eclipse.net4j.spi.db.DBAdapter.createTables(DBAdapter.java:111)
        at org.eclipse.net4j.spi.db.DBSchema.create(DBSchema.java:118)
        at org.eclipse.emf.cdo.server.internal.db.DBStore.doActivate(DBStore.java:521)
        at org.eclipse.net4j.util.lifecycle.Lifecycle.activate(Lifecycle.java:72)
        at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:99)
        at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:89)
        at org.eclipse.emf.cdo.internal.server.Repository.doActivate(Repository.java:1543)
        at org.eclipse.net4j.util.lifecycle.Lifecycle.activate(Lifecycle.java:72)
        at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:99)
        at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:89)
        at org.eclipse.emf.cdo.server.CDOServerUtil.addRepository(CDOServerUtil.java:201)
        at org.eclipse.emf.cdo.spi.server.RepositoryConfigurator.configure(RepositoryConfigurator.java:110)
        at org.eclipse.emf.cdo.internal.server.bundle.CDOServerApplication.doStart(CDOServerApplication.java:61)
        at org.eclipse.net4j.util.om.OSGiApplication.start(OSGiApplication.java:61)
        at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
        at org.eclipse.equinox.internal.app.AnyThreadAppLauncher.run(AnyThreadAppLauncher.java:26)
        at java.lang.Thread.run(Thread.java:679)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table engine 'InnoDB'
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
        at com.mysql.jdbc.Util.getInstance(Util.java:381)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1051)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3563)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3495)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2687)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2616)
        at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1453)
        at org.eclipse.net4j.spi.db.DBAdapter.validateTable(DBAdapter.java:428)
        ... 18 more

[Updated on: Fri, 16 September 2011 09:53]

Report message to a moderator

(no subject) [message #725742 is a reply to message #725670] Thu, 15 September 2011 16:11 Go to previous messageGo to next message
Eike Stepper is currently offline Eike StepperFriend
Messages: 6682
Registered: July 2009
Senior Member
Hi,

I'm not sure if Stefan finds this post because it's not prefixed with [CDO], so I've cc'ed him.

Cheers
/Eike

----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper


Am 15.09.2011 16:00, schrieb erpalma2003:
> Using MySQL + InnoDB + DBStore I'm getting this when trying to tweak "innodb_log_file_size" from 5MB to >5MB:
>
>
>
> [INFO] CDO server starting
> [ERROR] Problem with table cdo_lobs: SELECT id, size, bdata, cdata FROM cdo_lobs
> org.eclipse.net4j.db.DBException: Problem with table cdo_lobs: SELECT id, size, bdata, cdata FROM cdo_lobs
> at org.eclipse.net4j.spi.db.DBAdapter.validateTable(DBAdapter.java:439)
> at org.eclipse.net4j.spi.db.DBAdapter.createTable(DBAdapter.java:146)
> at org.eclipse.net4j.spi.db.DBAdapter.createTables(DBAdapter.java:111)
> at org.eclipse.net4j.spi.db.DBSchema.create(DBSchema.java:118)
> at org.eclipse.emf.cdo.server.internal.db.DBStore.doActivate(DBStore.java:521)
> at org.eclipse.net4j.util.lifecycle.Lifecycle.activate(Lifecycle.java:72)
> at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:99)
> at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:89)
> at org.eclipse.emf.cdo.internal.server.Repository.doActivate(Repository.java:1543)
> at org.eclipse.net4j.util.lifecycle.Lifecycle.activate(Lifecycle.java:72)
> at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:99)
> at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:89)
> at org.eclipse.emf.cdo.server.CDOServerUtil.addRepository(CDOServerUtil.java:201)
> at org.eclipse.emf.cdo.spi.server.RepositoryConfigurator.configure(RepositoryConfigurator.java:110)
> at org.eclipse.emf.cdo.internal.server.bundle.CDOServerApplication.doStart(CDOServerApplication.java:61)
> at org.eclipse.net4j.util.om.OSGiApplication.start(OSGiApplication.java:61)
> at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
> at org.eclipse.equinox.internal.app.AnyThreadAppLauncher.run(AnyThreadAppLauncher.java:26)
> at java.lang.Thread.run(Thread.java:679)
> Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table engine 'InnoDB'
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
> at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
> at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
> at com.mysql.jdbc.Util.getInstance(Util.java:381)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1051)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3563)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3495)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)
> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2687)
> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2616)
> at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1453)
> at org.eclipse.net4j.spi.db.DBAdapter.validateTable(DBAdapter.java:428)
> ... 18 more
>

Cheers
/Eike

----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper

Report message to a moderator

Re: (no subject) [message #725967 is a reply to message #725742] Fri, 16 September 2011 09:53 Go to previous messageGo to next message
erpalma2003 is currently offline erpalma2003Friend
Messages: 12
Registered: July 2011
Junior Member
Correct! Thanks

Report message to a moderator

(no subject) [message #726023 is a reply to message #725670] Fri, 16 September 2011 12:25 Go to previous messageGo to next message
Stefan Winkler is currently offline Stefan WinklerFriend
Messages: 307
Registered: July 2009
Location: Germany
Senior Member
Hi,

I'm a bit puzzled, how the configuration option you gave would affect
CDO, because CDO has no direct reference to the MySQL store type. The
store type is configured as default in your mysql configuration.

What I can tell is that the stack trace you posted is the result of an
error when executing CREATE TABLE. This statement would use the default
table storage engine, which is likely configured to InnoDB.

My first guess would be the following: have a look in your mysql log
file. Maybe you modified something that results in the InnoDB storage
engine not being started at all (which would explain why it is not found
at runtime).

Also, please try to execute a CREATE TABLE statement manually using your
configuration and see if this fails, too.

Cheers,
Stefan



Am 15.09.11 16:00, schrieb erpalma2003:
> Using MySQL + InnoDB + DBStore I'm getting this when trying to tweak
> "innodb_log_file_size" from 5MB to >5MB:
>
>
>
> [INFO] CDO server starting
> [ERROR] Problem with table cdo_lobs: SELECT id, size, bdata, cdata FROM
> cdo_lobs
> org.eclipse.net4j.db.DBException: Problem with table cdo_lobs: SELECT
> id, size, bdata, cdata FROM cdo_lobs
> at org.eclipse.net4j.spi.db.DBAdapter.validateTable(DBAdapter.java:439)
> at org.eclipse.net4j.spi.db.DBAdapter.createTable(DBAdapter.java:146)
> at org.eclipse.net4j.spi.db.DBAdapter.createTables(DBAdapter.java:111)
> at org.eclipse.net4j.spi.db.DBSchema.create(DBSchema.java:118)
> at
> org.eclipse.emf.cdo.server.internal.db.DBStore.doActivate(DBStore.java:521)
> at org.eclipse.net4j.util.lifecycle.Lifecycle.activate(Lifecycle.java:72)
> at
> org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:99)
>
> at
> org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:89)
>
> at
> org.eclipse.emf.cdo.internal.server.Repository.doActivate(Repository.java:1543)
>
> at org.eclipse.net4j.util.lifecycle.Lifecycle.activate(Lifecycle.java:72)
> at
> org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:99)
>
> at
> org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:89)
>
> at
> org.eclipse.emf.cdo.server.CDOServerUtil.addRepository(CDOServerUtil.java:201)
>
> at
> org.eclipse.emf.cdo.spi.server.RepositoryConfigurator.configure(RepositoryConfigurator.java:110)
>
> at
> org.eclipse.emf.cdo.internal.server.bundle.CDOServerApplication.doStart(CDOServerApplication.java:61)
>
> at org.eclipse.net4j.util.om.OSGiApplication.start(OSGiApplication.java:61)
> at
> org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
>
> at
> org.eclipse.equinox.internal.app.AnyThreadAppLauncher.run(AnyThreadAppLauncher.java:26)
>
> at java.lang.Thread.run(Thread.java:679)
> Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
> Unknown table engine 'InnoDB'
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
>
> at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
>
> at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
> at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
> at com.mysql.jdbc.Util.getInstance(Util.java:381)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1051)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3563)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3495)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)
> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2687)
> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2616)
> at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1453)
> at org.eclipse.net4j.spi.db.DBAdapter.validateTable(DBAdapter.java:428)
> ... 18 more
>

Report message to a moderator

Re: (no subject) [message #733646 is a reply to message #726023] Wed, 05 October 2011 09:46 Go to previous messageGo to next message
Federico Tomassetti is currently offline Federico TomassettiFriend
Messages: 190
Registered: July 2009
Location: Dublin
Senior Member
I get the same error. My DataSource is correctly configured (I tried to create some tables and drop them: everything is working fine).

I create the DBStore in this way:
	private IStore createStore() {
		final MysqlDataSource dataSource = new MysqlDataSource();
	      dataSource.setUser("root");
	      dataSource.setPassword("root");
	      dataSource.setServerName("127.0.0.1");
	      dataSource.setPort(3306);
	      dataSource.setDatabaseName("cdoexperiments");
	      
	    DBAdapter dbAdapter = new DBAdapter("mysql",null) {
			
			@Override
			public String[] getReservedWords() {
				return null;
			}
			
			@Override
			public Driver getJDBCDriver() {
				try {
					return new com.mysql.jdbc.Driver();
				} catch (SQLException e) {
					throw new RuntimeException(e);
				}
			}
			
			@Override
			public DataSource createJDBCDataSource() {
				return dataSource;
			}
		};

		DBStore store = new DBStore();
		store.setDBAdapter(dbAdapter);
		store.setMappingStrategy(new HorizontalMappingStrategy());
		store.setDataSource(dataSource);
		return store;
	}


Then when I launch the server I get the same error as reported by erpalma2003

website: http://www.federico-tomassetti.it

Report message to a moderator

Re: (no subject) [message #733766 is a reply to message #733646] Wed, 05 October 2011 15:12 Go to previous message
Federico Tomassetti is currently offline Federico TomassettiFriend
Messages: 190
Registered: July 2009
Location: Dublin
Senior Member
Solved.

I did not have installed NET4J MySQL Adapter. I have to say that the error is not that clear...

website: http://www.federico-tomassetti.it

Report message to a moderator

Previous Topic:Set properties for multiple children/nodes
Next Topic:How to extend a default EFactoryImpl
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 22:51:04 GMT 2024

Powered by FUDForum. Page generated in 0.03686 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly