I ran into the MySQL file size issue yesterday - I couldn't add a 4MB PDF file to dms. It was fixed by adding the line
max_allowed_packet=1000M to the end of C:\Program Files\MySQL\MySQL Server 5.0\my.ini My config is Windows, Tomcat 5.5, Magnolia 3.0.3, MySQL, JNDI and DataSourcePersistenceManager. I don't know if this helps your issue? David M -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Sent: Monday, August 27, 2007 6:47 PM To: [email protected] Subject: Re: [magnolia-user] Unable to change Repository to MySQL Hmmm..... I found this as a root cause at the bottom of your stacktrace: Caused by: java.io.EOFException It'd be great to see more of the root cause but here's a thought... I think I remember I needed to up the maximum packet size in MySQL because the default was too small for some of the images in my dev site. Either that or you may have a flaky network or firewall causing problems. --David kmasden wrote: > I am trying to change our magnolia repository from bdb to MySQL these are the > steps I am taking: > > 1. Backup everything to WEB-INF/common/bootstrap directory. > 2. Shutdown magnolia delete repository > 3. Change magnolia config so that the repository is now Mysql > 4. Restart Magnolia > > My users, userroles, usergroups, and some of my website content gets loaded. > The process usually dies loading the website content with this error: > > ERROR org.apache.jackrabbit.core.ItemManager 17.08.2007 14:56:14 -- failed > to retrieve item state of item > bf4973ae-0be2-4e83-8104-48cb439aee93/{}content > org.apache.jackrabbit.core.state.ItemStateException: failed to read property > state: bf4973ae-0be2-4e83-8104-48cb439aee93/{}content > at > com.iorgagroup.jackrabbit.core.state.db.DataSourcePersistenceManager.loa d(DataSourcePersistenceManager.java:424) > at > org.apache.jackrabbit.core.state.SharedItemStateManager.loadItemState(Sh aredItemStateManager.java:864) > at > org.apache.jackrabbit.core.state.SharedItemStateManager.getNonVirtualIte mState(SharedItemStateManager.java:789) > at > org.apache.jackrabbit.core.state.SharedItemStateManager.getItemState(Sha redItemStateManager.java:207) > at > org.apache.jackrabbit.core.state.LocalItemStateManager.getPropertyState( LocalItemStateManager.java:111) > at > org.apache.jackrabbit.core.state.LocalItemStateManager.getItemState(Loca lItemStateManager.java:143) > at > org.apache.jackrabbit.core.state.XAItemStateManager.getItemState(XAItemS tateManager.java:235) > at > org.apache.jackrabbit.core.state.SessionItemStateManager.getItemState(Se ssionItemStateManager.java:127) > at > org.apache.jackrabbit.core.ItemManager.createItemInstance(ItemManager.ja va:462) > at org.apache.jackrabbit.core.ItemManager.getItem(ItemManager.java:320) > at > org.apache.jackrabbit.core.ItemImpl.restoreTransientItems(ItemImpl.java: 708) > at org.apache.jackrabbit.core.ItemImpl.save(ItemImpl.java:1208) > at org.apache.jackrabbit.core.SessionImpl.save(SessionImpl.java:805) > at > info.magnolia.cms.core.ie.DataTransporter.importXmlStream(DataTransporte r.java:290) > at > info.magnolia.cms.core.ie.DataTransporter.importFile(DataTransporter.jav a:122) > at > info.magnolia.cms.core.ie.DataTransporter.executeBootstrapImport(DataTra nsporter.java:147) > at > info.magnolia.cms.beans.config.Bootstrapper.bootstrapFiles(Bootstrapper. java:150) > at > info.magnolia.cms.beans.config.Bootstrapper.bootstrapFiles(Bootstrapper. java:134) > at > info.magnolia.cms.beans.config.Bootstrapper.bootstrapRepository(Bootstra pper.java:123) > at > info.magnolia.cms.beans.config.Bootstrapper.bootstrapRepositories(Bootst rapper.java:86) > at > info.magnolia.cms.beans.config.ConfigLoader.bootstrap(ConfigLoader.java: 229) > at info.magnolia.cms.beans.config.ConfigLoader.load(ConfigLoader.java:119) > at > info.magnolia.cms.beans.config.ConfigLoader.<init>(ConfigLoader.java:100 ) > at > info.magnolia.cms.servlets.PropertyInitializer.contextInitialized(Proper tyInitializer.java:212) > at > org.apache.catalina.core.StandardContext.listenerStart(StandardContext.j ava:3763) > at > org.apache.catalina.core.StandardContext.start(StandardContext.java:4211 ) > at > org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.ja va:759) > at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739) > at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav a:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor Impl.java:25) > at java.lang.reflect.Method.invoke(Method.java:585) > at > org.apache.commons.modeler.BaseModelMBean.invoke(BaseModelMBean.java:503 ) > at org.jboss.mx.server.RawDynamicInvoker.invoke(RawDynamicInvoker.java:164) > at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659) > at org.apache.catalina.core.StandardContext.init(StandardContext.java:5052) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav a:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor Impl.java:25) > at java.lang.reflect.Method.invoke(Method.java:585) > at > org.apache.commons.modeler.BaseModelMBean.invoke(BaseModelMBean.java:503 ) > at org.jboss.mx.server.RawDynamicInvoker.invoke(RawDynamicInvoker.java:164) > at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659) > at > org.jboss.web.tomcat.tc5.TomcatDeployer.performDeployInternal(TomcatDepl oyer.java:297) > at > org.jboss.web.tomcat.tc5.TomcatDeployer.performDeploy(TomcatDeployer.jav a:103) > at org.jboss.web.AbstractWebDeployer.start(AbstractWebDeployer.java:371) > at org.jboss.web.WebModule.startModule(WebModule.java:83) > at org.jboss.web.WebModule.startService(WebModule.java:61) > at > org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupp ort.java:289) > at > org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBean Support.java:245) > at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor Impl.java:25) > at java.lang.reflect.Method.invoke(Method.java:585) > at > org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher. java:155) > at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94) > at org.jboss.mx.server.Invocation.invoke(Invocation.java:86) > at > org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.jav a:264) > at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659) > at > org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController .java:978) > at $Proxy0.start(Unknown Source) > at org.jboss.system.ServiceController.start(ServiceController.java:417) > at sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor Impl.java:25) > at java.lang.reflect.Method.invoke(Method.java:585) > at > org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher. java:155) > at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94) > at org.jboss.mx.server.Invocation.invoke(Invocation.java:86) > at > org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.jav a:264) > at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659) > at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210) > at $Proxy45.start(Unknown Source) > at org.jboss.web.AbstractWebContainer.start(AbstractWebContainer.java:466) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav a:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor Impl.java:25) > at java.lang.reflect.Method.invoke(Method.java:585) > at > org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher. java:155) > at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94) > at > org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor. java:133) > at org.jboss.mx.server.Invocation.invoke(Invocation.java:88) > at > org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBea nOperationInterceptor.java:142) > at > org.jboss.mx.interceptor.DynamicInterceptor.invoke(DynamicInterceptor.ja va:97) > at > org.jboss.system.InterceptorServiceMBeanSupport.invokeNext(InterceptorSe rviceMBeanSupport.java:238) > at > org.jboss.ws.integration.jboss.DeployerInterceptor.start(DeployerInterce ptor.java:92) > at > org.jboss.deployment.SubDeployerInterceptorSupport$XMBeanInterceptor.sta rt(SubDeployerInterceptorSupport.java:188) > at > org.jboss.deployment.SubDeployerInterceptor.invoke(SubDeployerIntercepto r.java:95) > at org.jboss.mx.server.Invocation.invoke(Invocation.java:88) > at > org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.jav a:264) > at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659) > at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210) > at $Proxy46.start(Unknown Source) > at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025) > at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819) > at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782) > at sun.reflect.GeneratedMethodAccessor13.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor Impl.java:25) > at java.lang.reflect.Method.invoke(Method.java:585) > at > org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher. java:155) > at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94) > at > org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor. java:133) > at org.jboss.mx.server.Invocation.invoke(Invocation.java:88) > at > org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBea nOperationInterceptor.java:142) > at org.jboss.mx.server.Invocation.invoke(Invocation.java:88) > at > org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.jav a:264) > at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659) > at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210) > at $Proxy6.deploy(Unknown Source) > at > org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentSc anner.java:421) > at > org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScan ner.java:634) > at > org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doS can(AbstractDeploymentScanner.java:263) > at > org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(Abst ractDeploymentScanner.java:336) > at > org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupp ort.java:289) > at > org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBean Support.java:245) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav a:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor Impl.java:25) > at java.lang.reflect.Method.invoke(Method.java:585) > at > org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher. java:155) > at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94) > at org.jboss.mx.server.Invocation.invoke(Invocation.java:86) > at > org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.jav a:264) > at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659) > at > org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController .java:978) > at $Proxy0.start(Unknown Source) > at org.jboss.system.ServiceController.start(ServiceController.java:417) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav a:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor Impl.java:25) > at java.lang.reflect.Method.invoke(Method.java:585) > at > org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher. java:155) > at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94) > at org.jboss.mx.server.Invocation.invoke(Invocation.java:86) > at > org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.jav a:264) > at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659) > at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210) > at $Proxy4.start(Unknown Source) > at org.jboss.deployment.SARDeployer.start(SARDeployer.java:302) > at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025) > at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819) > at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782) > at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:766) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav a:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor Impl.java:25) > at java.lang.reflect.Method.invoke(Method.java:585) > at > org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher. java:155) > at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94) > at > org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor. java:133) > at org.jboss.mx.server.Invocation.invoke(Invocation.java:88) > at > org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBea nOperationInterceptor.java:142) > at org.jboss.mx.server.Invocation.invoke(Invocation.java:88) > at > org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.jav a:264) > at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659) > at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210) > at $Proxy5.deploy(Unknown Source) > at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:482) > at org.jboss.system.server.ServerImpl.start(ServerImpl.java:362) > at org.jboss.Main.boot(Main.java:200) > at org.jboss.Main$1.run(Main.java:490) > at java.lang.Thread.run(Thread.java:595) > Caused by: java.io.EOFException > at java.io.DataInputStream.readFully(DataInputStream.java:178) > at java.io.DataInputStream.readFully(DataInputStream.java:152) > at > org.apache.jackrabbit.core.state.util.Serializer.deserialize(Serializer. java:311) > at > com.iorgagroup.jackrabbit.core.state.db.DataSourcePersistenceManager$DSP MQueryStandard.load(DataSourcePersistenceManager.java:1652) > at > com.iorgagroup.jackrabbit.core.state.db.DataSourcePersistenceManager.loa d(DataSourcePersistenceManager.java:421) > ... 160 more > > I was able to successfully load the content into an instance using derby as > the repository. > > Is there something I am missing? > ---------------------------------------------------------------- for list details see http://documentation.magnolia.info/docs/en/editor/stayupdated.html ---------------------------------------------------------------- ---------------------------------------------------------------- for list details see http://documentation.magnolia.info/docs/en/editor/stayupdated.html ----------------------------------------------------------------
