36530 – MySQL 5.0 Store initialization error ...

Bug 36530 - MySQL 5.0 Store initialization error ...

Summary: MySQL 5.0 Store initialization error ...

Status:	NEW

Alias:	None

Product:	Slide
Classification:	Unclassified
Component:	WebDAV Server (show other bugs)
Version:	2.1
Hardware:	Other Linux

Importance:	P2 normal (vote)
Target Milestone:	---
Assignee:	Slide Developer List

URL:
Keywords:

Depends on:
Blocks:

Reported:	2005-09-06 23:39 UTC by Michael Small
Modified:	2005-09-06 15:40 UTC (History)
CC List:	0 users

Attachments
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 Michael Small 2005-09-06 23:39:59 UTC

I'm deploying slide in JBoss 4.0.3RC2 and I'm attempting to the use the MySQL4.1
Adapter for the store.  If a create the tables in the MySQL and deploy slide in
JBoss, it works correctly (i.e. the store is initialized without problems).  If
I redeploy (with any combination of shutting down the server, etc.), I get the
following error during deployment:

16:10:02,644 INFO  [STDOUT] 06 Sep 2005 16:10:02 -
org.apache.slide.common.Namespace - INFO - Registering Store TasconlineSlideDS
(class org.apache.slide.store.ExtendedStore) with parameters {} on scope /
16:10:02,662 INFO  [STDOUT] 06 Sep 2005 16:10:02 -
org.apache.slide.common.Namespace - INFO - Initializing Store
TasconlineSlideDS(org.apache.slide.store.ExtendedStore)
16:10:02,753 INFO  [STDOUT] 06 Sep 2005 16:10:02 -
org.apache.slide.common.Namespace - INFO - Loading namespace slide base data
16:10:02,806 INFO  [STDOUT] 06 Sep 2005 16:10:02 -
org.apache.slide.common.Namespace - INFO - Init namespace slide configuration
16:10:02,807 INFO  [STDOUT] 06 Sep 2005 16:10:02 -
org.apache.slide.common.Namespace - INFO - Import data into namespace slide
16:10:02,822 INFO  [STDOUT] 06 Sep 2005 16:10:02 -
org.apache.slide.common.XMLUnmarshaller - INFO - Loading object /
16:10:02,838 INFO  [STDOUT] 06 Sep 2005 16:10:02 -
org.apache.slide.common.XMLUnmarshaller - INFO - Object already exists at /
16:10:02,877 INFO  [STDOUT] 06 Sep 2005 16:10:02 -
org.apache.slide.store.impl.rdbms.MySqlRDBMSAdapter - ERROR - SQL error 1062 on
/: Duplicate entry '1-DAV:-modificationdate' for key 1
16:10:02,878 INFO  [STDOUT] org.apache.slide.common.ServiceAccessException:
Service org.apache.slide.store.impl.rdbms.J2EEStore@5e305f access error :
Duplicate entry '1-DAV:-modificationdate' for key 1
16:10:02,879 INFO  [STDOUT]     at
org.apache.slide.store.impl.rdbms.MySqlRDBMSAdapter.createException(MySqlRDBMSAdapter.java:66)
16:10:02,894 INFO  [STDOUT]     at
org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.createRevisionDescriptor(StandardRDBMSAdapter.java:650)
16:10:02,895 INFO  [STDOUT]     at
org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.storeRevisionDescriptor(StandardRDBMSAdapter.java:1253)
16:10:02,895 INFO  [STDOUT]     at
org.apache.slide.store.impl.rdbms.AbstractRDBMSStore.storeRevisionDescriptor(AbstractRDBMSStore.java:759)
16:10:02,895 INFO  [STDOUT]     at
org.apache.slide.store.AbstractStore.storeRevisionDescriptor(AbstractStore.java:1219)
16:10:02,895 INFO  [STDOUT]     at
org.apache.slide.store.ExtendedStore.storeRevisionDescriptor(ExtendedStore.java:912)
16:10:02,895 INFO  [STDOUT]     at
org.apache.slide.content.ContentImpl.store(ContentImpl.java:1033)
16:10:02,895 INFO  [STDOUT]     at
org.apache.slide.common.XMLUnmarshaller.loadObjectRevision(XMLUnmarshaller.java:390)
16:10:02,895 INFO  [STDOUT]     at
org.apache.slide.common.XMLUnmarshaller.loadDefaultObjectRevision(XMLUnmarshaller.java:307)
16:10:02,895 INFO  [STDOUT]     at
org.apache.slide.common.XMLUnmarshaller.loadObjectNode(XMLUnmarshaller.java:237)
16:10:02,896 INFO  [STDOUT]     at
org.apache.slide.common.XMLUnmarshaller.unmarshal(XMLUnmarshaller.java:90)
16:10:02,925 INFO  [STDOUT]     at
org.apache.slide.common.NamespaceAccessTokenImpl.importData(NamespaceAccessTokenImpl.java:272)
16:10:02,925 INFO  [STDOUT]     at
org.apache.slide.common.Namespace.loadBaseData(Namespace.java:808)
16:10:02,925 INFO  [STDOUT]     at
org.apache.slide.common.Domain.initNamespace(Domain.java:845)
16:10:02,925 INFO  [STDOUT]     at
org.apache.slide.common.Domain.init(Domain.java:432)
16:10:02,925 INFO  [STDOUT]     at
org.apache.slide.common.Domain.init(Domain.java:366)
16:10:02,926 INFO  [STDOUT]     at
org.apache.slide.common.Domain.init(Domain.java:329)
16:10:02,926 INFO  [STDOUT]     at
org.apache.slide.webdav.WebdavServlet.init(WebdavServlet.java:253)
16:10:02,926 INFO  [STDOUT]     at
javax.servlet.GenericServlet.init(GenericServlet.java:211)
16:10:02,926 INFO  [STDOUT]     at
org.apache.slide.webdav.WebdavServlet.init(WebdavServlet.java:195)
16:10:02,926 INFO  [STDOUT]     at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1091)
16:10:02,951 INFO  [STDOUT]     at
org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:925)
16:10:02,951 INFO  [STDOUT]     at
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3857)
16:10:02,951 INFO  [STDOUT]     at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4118)
16:10:02,951 INFO  [STDOUT]     at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
16:10:02,951 INFO  [STDOUT]     at
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
16:10:02,951 INFO  [STDOUT]     at
org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
16:10:02,951 INFO  [STDOUT]     at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
16:10:02,951 INFO  [STDOUT]     at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
16:10:02,974 INFO  [STDOUT]     at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
16:10:02,974 INFO  [STDOUT]     at java.lang.reflect.Method.invoke(Method.java:585)
16:10:02,975 INFO  [STDOUT]     at
org.apache.commons.modeler.BaseModelMBean.invoke(BaseModelMBean.java:503)
16:10:02,975 INFO  [STDOUT]     at
org.jboss.mx.server.RawDynamicInvoker.invoke(RawDynamicInvoker.java:150)
16:10:02,975 INFO  [STDOUT]     at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
16:10:02,975 INFO  [STDOUT]     at
org.apache.catalina.core.StandardContext.init(StandardContext.java:5005)
16:10:02,975 INFO  [STDOUT]     at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
16:10:02,975 INFO  [STDOUT]     at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
16:10:02,975 INFO  [STDOUT]     at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
16:10:03,001 INFO  [STDOUT]     at java.lang.reflect.Method.invoke(Method.java:585)
16:10:03,001 INFO  [STDOUT]     at
org.apache.commons.modeler.BaseModelMBean.invoke(BaseModelMBean.java:503)
16:10:03,001 INFO  [STDOUT]     at
org.jboss.mx.server.RawDynamicInvoker.invoke(RawDynamicInvoker.java:150)
16:10:03,002 INFO  [STDOUT]     at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
16:10:03,002 INFO  [STDOUT]     at
org.jboss.web.tomcat.tc5.TomcatDeployer.performDeployInternal(TomcatDeployer.java:279)
16:10:03,002 INFO  [STDOUT]     at
org.jboss.web.tomcat.tc5.TomcatDeployer.performDeploy(TomcatDeployer.java:88)
16:10:03,002 INFO  [STDOUT]     at
org.jboss.web.AbstractWebDeployer.start(AbstractWebDeployer.java:357)
16:10:03,002 INFO  [STDOUT]     at
org.jboss.web.WebModule.startModule(WebModule.java:68)
16:10:03,023 INFO  [STDOUT]     at
org.jboss.web.WebModule.startService(WebModule.java:46)
16:10:03,023 INFO  [STDOUT]     at
org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:287)
16:10:03,023 INFO  [STDOUT]     at
org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:236)
16:10:03,023 INFO  [STDOUT]     at
sun.reflect.GeneratedMethodAccessor90.invoke(Unknown Source)
16:10:03,024 INFO  [STDOUT]     at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
16:10:03,024 INFO  [STDOUT]     at java.lang.reflect.Method.invoke(Method.java:585)
16:10:03,024 INFO  [STDOUT]     at
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
16:10:03,024 INFO  [STDOUT]     at
org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
16:10:03,024 INFO  [STDOUT]     at
org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
16:10:03,024 INFO  [STDOUT]     at
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
16:10:03,024 INFO  [STDOUT]     at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
16:10:03,051 INFO  [STDOUT]     at
org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:974)
16:10:03,051 INFO  [STDOUT]     at $Proxy0.start(Unknown Source)
16:10:03,051 INFO  [STDOUT]     at
org.jboss.system.ServiceController.start(ServiceController.java:453)
16:10:03,052 INFO  [STDOUT]     at
sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
16:10:03,052 INFO  [STDOUT]     at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
16:10:03,052 INFO  [STDOUT]     at java.lang.reflect.Method.invoke(Method.java:585)
16:10:03,052 INFO  [STDOUT]     at
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
16:10:03,052 INFO  [STDOUT]     at
org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
16:10:03,052 INFO  [STDOUT]     at
org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
16:10:03,052 INFO  [STDOUT]     at
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
16:10:03,052 INFO  [STDOUT]     at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
16:10:03,079 INFO  [STDOUT]     at
org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
16:10:03,079 INFO  [STDOUT]     at $Proxy47.start(Unknown Source)
16:10:03,079 INFO  [STDOUT]     at
org.jboss.web.AbstractWebContainer.start(AbstractWebContainer.java:394)
16:10:03,079 INFO  [STDOUT]     at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
16:10:03,079 INFO  [STDOUT]     at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
16:10:03,079 INFO  [STDOUT]     at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
16:10:03,079 INFO  [STDOUT]     at java.lang.reflect.Method.invoke(Method.java:585)
16:10:03,079 INFO  [STDOUT]     at
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
16:10:03,080 INFO  [STDOUT]     at
org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
16:10:03,080 INFO  [STDOUT]     at
org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
16:10:03,110 INFO  [STDOUT]     at
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
16:10:03,110 INFO  [STDOUT]     at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
16:10:03,110 INFO  [STDOUT]     at
org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
16:10:03,110 INFO  [STDOUT]     at $Proxy48.start(Unknown Source)
16:10:03,110 INFO  [STDOUT]     at
org.jboss.deployment.MainDeployer.start(MainDeployer.java:973)
16:10:03,110 INFO  [STDOUT]     at
org.jboss.deployment.MainDeployer.start(MainDeployer.java:963)
16:10:03,110 INFO  [STDOUT]     at
org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:774)
16:10:03,111 INFO  [STDOUT]     at
org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:737)
16:10:03,111 INFO  [STDOUT]     at
sun.reflect.GeneratedMethodAccessor16.invoke(Unknown Source)
16:10:03,111 INFO  [STDOUT]     at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
16:10:03,111 INFO  [STDOUT]     at java.lang.reflect.Method.invoke(Method.java:585)
16:10:03,136 INFO  [STDOUT]     at
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
16:10:03,136 INFO  [STDOUT]     at
org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
16:10:03,136 INFO  [STDOUT]     at
org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:118)
16:10:03,136 INFO  [STDOUT]     at
org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
16:10:03,137 INFO  [STDOUT]     at
org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:127)
16:10:03,137 INFO  [STDOUT]     at
org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
16:10:03,137 INFO  [STDOUT]     at
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
16:10:03,137 INFO  [STDOUT]     at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
16:10:03,137 INFO  [STDOUT]     at
org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
16:10:03,137 INFO  [STDOUT]     at $Proxy9.deploy(Unknown Source)
16:10:03,137 INFO  [STDOUT]     at
org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:319)
16:10:03,163 INFO  [STDOUT]     at
org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:507)
16:10:03,164 INFO  [STDOUT]     at
org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:192)
16:10:03,164 INFO  [STDOUT]     at
org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.loop(AbstractDeploymentScanner.java:203)
16:10:03,164 INFO  [STDOUT]     at
org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.run(AbstractDeploymentScanner.java:182)
16:10:03,164 INFO  [STDOUT] 06 Sep 2005 16:10:03 -
org.apache.slide.common.Namespace - INFO - Namespace base configuration was
already done before
16:10:03,185 INFO  [STDOUT] 06 Sep 2005 16:10:03 -
org.apache.slide.common.Namespace - INFO - Loading namespace slide configuration
16:10:03,186 INFO  [STDOUT] 06 Sep 2005 16:10:03 -
org.apache.slide.common.Domain - INFO - Namespace configuration complete

The last three lines indicate that slide figured out that the store has already
been initialized, but I'm concerned about the error.