I updated the /etc/my.cnf file on the MySQL server so that max_allowed_packet=1028M and restarted MySQL but I am still having the same probelm.
Magnolia - User mailing list wrote: > > 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 > ---------------------------------------------------------------- > > -- View this message in context: http://www.nabble.com/Unable-to-change-Repository-to-MySQL-tf4312197.html#a12370566 Sent from the Magnolia - User mailing list archive at Nabble.com. ---------------------------------------------------------------- for list details see http://documentation.magnolia.info/docs/en/editor/stayupdated.html ----------------------------------------------------------------
