|
Re: [CDO] MySQL database is broken after restart of CDO server [message #1415204 is a reply to message #1415199] |
Tue, 02 September 2014 10:01 |
|
Hi Stefan,
How exactly are you shutting your server down?
Cheers
/Eike
----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper
Am 02.09.2014 um 11:46 schrieb Stefan Weise:
> We have a problem with the CDO server connecting to a MySQL database. The first startup which creates the tables is
> ok. But sometimes after a shutdown and a restart the CDO server detects a crash of the repository and reports the
> exitcode 10000. Here is the log output:
>
>
> [INFO] CDO server stopping
> [INFO] Net4j extension stopping
> [INFO] Net4j extension stopped
> [INFO] Security extension stopping
> [INFO] Security extension stopped
> [INFO] CDO server stopped
> Start VM: /usr/bin/java
> -Xms40m
> -Xmx2G
> -Dnet4j.config=/opt/cdo-server/config
> -Dorg.eclipse.emf.cdo.server.browser.port=7777
> -Dorg.osgi.service.http.port=8080
> -Dosgi.console.enable.builtin=true
> -Ddebug=true
> -jar /opt/cdo-server/plugins/org.eclipse.equinox.launcher_1.3.0.v20130327-1440.jar
> -os linux
> -ws gtk
> -arch x86_64
> -showsplash
> -launcher /opt/cdo-server/cdo-server
> -name Cdo-server
> --launcher.library
> /opt/cdo-server/plugins/org.eclipse.equinox.launcher.gtk.linux.x86_64_1.1.200.v20140116-2212/eclipse_1508.so
> -startup /opt/cdo-server/plugins/org.eclipse.equinox.launcher_1.3.0.v20130327-1440.jar
> --launcher.overrideVmargs
> -exitdata 10000
> -debug
> -console 5555
> -vm /usr/bin/java
> -vmargs
> -Xms40m
> -Xmx2G
> -Dnet4j.config=/opt/cdo-server/config
> -Dorg.eclipse.emf.cdo.server.browser.port=7777
> -Dorg.osgi.service.http.port=8080
> -Dosgi.console.enable.builtin=true
> -Ddebug=true
> -jar /opt/cdo-server/plugins/org.eclipse.equinox.launcher_1.3.0.v20130327-1440.jar Install location:
> file:/opt/cdo-server/
> Configuration file:
> file:/opt/cdo-server/configuration/config.ini loaded
> Configuration location:
> file:/opt/cdo-server/configuration/
> Framework located:
> file:/opt/cdo-server/plugins/org.eclipse.osgi_3.9.1.v20140110-1610.jar
> Framework classpath:
> file:/opt/cdo-server/plugins/org.eclipse.osgi_3.9.1.v20140110-1610.jar
> Splash location:
> null
> Debug options:
> file:/opt/cdo-server/.options not found
> Listening on port 0.0.0.0/0.0.0.0:5555 ... Time to load bundles: 53
> Starting application: 1830
> [INFO] CDO server starting
> [WARN] Detected crash of repository yt_repo
> [ERROR] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'cdo_repo.cdo_objects' doesn't exist
> org.eclipse.net4j.db.DBException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
> 'cdo_repo.cdo_objects' doesn't exist
> at org.eclipse.emf.cdo.server.internal.db.DBStore.visitAllTables(DBStore.java:288)
> at
> org.eclipse.emf.cdo.server.internal.db.mapping.horizontal.AbstractHorizontalMappingStrategy.getMinLocalID(AbstractHorizontalMappingStrategy.java:467)
> at
> org.eclipse.emf.cdo.server.internal.db.mapping.horizontal.AbstractHorizontalMappingStrategy.repairAfterCrash(AbstractHorizontalMappingStrategy.java:105)
> at
> org.eclipse.emf.cdo.server.internal.db.mapping.horizontal.HorizontalMappingStrategy.repairAfterCrash(HorizontalMappingStrategy.java:204)
> at org.eclipse.emf.cdo.server.internal.db.DBStore.repairAfterCrash(DBStore.java:778)
> at org.eclipse.emf.cdo.server.internal.db.DBStore.reStart(DBStore.java:760)
> at org.eclipse.emf.cdo.server.internal.db.DBStore.doActivate(DBStore.java:653)
> at org.eclipse.net4j.util.lifecycle.Lifecycle.internalActivate(Lifecycle.java:76)
> at org.eclipse.net4j.util.lifecycle.Lifecycle.activate(Lifecycle.java:162)
> at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:114)
> at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:104)
> at org.eclipse.emf.cdo.internal.server.Repository.doActivate(Repository.java:1980)
> at org.eclipse.net4j.util.lifecycle.Lifecycle.internalActivate(Lifecycle.java:76)
> at org.eclipse.net4j.util.lifecycle.ShareableLifecycle.internalActivate(ShareableLifecycle.java:43)
> at org.eclipse.net4j.util.lifecycle.Lifecycle.activate(Lifecycle.java:162)
> at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:114)
> at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:104)
> at org.eclipse.emf.cdo.server.CDOServerUtil.addRepository(CDOServerUtil.java:291)
> at org.eclipse.emf.cdo.spi.server.RepositoryConfigurator.configure(RepositoryConfigurator.java:116)
> at org.eclipse.emf.cdo.internal.server.bundle.CDOServerApplication.doStart(CDOServerApplication.java:61)
> at org.eclipse.net4j.util.om.OSGiApplication.start(OSGiApplication.java:63)
> 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:745)
> Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'cdo_repo.cdo_objects' doesn't exist
> 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:526)
> 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:1464)
> at
> org.eclipse.emf.cdo.server.internal.db.mapping.horizontal.AbstractHorizontalMappingStrategy$1.visitTable(AbstractHorizontalMappingStrategy.java:477)
> at org.eclipse.emf.cdo.server.internal.db.DBStore.visitAllTables(DBStore.java:272)
> ... 23 more
> Start VM: /usr/bin/java
> -Xms40m
> -Xmx2G
> -Dnet4j.config=/opt/cdo-server/config
> -Dorg.eclipse.emf.cdo.server.browser.port=7777
> -Dorg.osgi.service.http.port=8080
> -Dosgi.console.enable.builtin=true
> -Ddebug=true
> -jar /opt/cdo-server/plugins/org.eclipse.equinox.launcher_1.3.0.v20130327-1440.jar
> -os linux
> -ws gtk
> -arch x86_64
> -showsplash
> -launcher /opt/cdo-server/cdo-server
> -name Cdo-server
> --launcher.library
> /opt/cdo-server/plugins/org.eclipse.equinox.launcher.gtk.linux.x86_64_1.1.200.v20140116-2212/eclipse_1508.so
> -startup /opt/cdo-server/plugins/org.eclipse.equinox.launcher_1.3.0.v20130327-1440.jar
> --launcher.overrideVmargs
> -exitdata 0
> -debug
> -console 5555
> -vm /usr/bin/java
> -vmargs
> -Xms40m
> -Xmx2G
> -Dnet4j.config=/opt/cdo-server/config
> -Dorg.eclipse.emf.cdo.server.browser.port=7777
> -Dorg.osgi.service.http.port=8080
> -Dosgi.console.enable.builtin=true
> -Ddebug=true
> -jar /opt/cdo-server/plugins/org.eclipse.equinox.launcher_1.3.0.v20130327-1440.jar
Cheers
/Eike
----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper
|
|
|
|
|
|
|
|
|
|
|
|
Re: [CDO] MySQL database is broken after restart of CDO server [message #1428856 is a reply to message #1424816] |
Mon, 22 September 2014 13:06 |
Christophe Bouhier Messages: 937 Registered: July 2009 |
Senior Member |
|
|
On 16-09-14 15:03, Stefan Weise wrote:
> Hi.
>
> Thank you for sharing this information. I've already voted for this bug 8)
@Eike, I can provide a patch, which simply removes, toUpperCase(), which
will likely fix the problem. Is this OK?
> The problem only seems to occur in maintenance mode when the database is
> getting upgraded or repaired. During normal operation this error does
> not appear.
> ~Stefan
>
> Christophe Bouhier wrote on Tue, 16 September 2014 12:23
>> On 16-09-14 12:14, Stefan Weise wrote:
>> Hi, This sounds very much like a problem we have as well.
>> We also have Linux and MySQL. We have done extensive troubleshooting
>> and found the issue. (But still need a patch).
>>
>> The bug is in the class DBNamedElement, this method.
>>
>> public static String name(String name)
>> {
>> return name.toUpperCase().intern();
>> }
>>
>> The CDO Bug report is this one:
>>
>> https://bugs.eclipse.org/bugs/show_bug.cgi?id=412520
>>
>> The bug was introduced somewhere in March 2013. (Judging from the GIT
>> logs). where this bug is very active:
>>
>> https://bugs.eclipse.org/bugs/show_bug.cgi?id=401763
>
>
|
|
|
Powered by
FUDForum. Page generated in 0.03948 seconds