9 Replies Latest reply on Nov 8, 2007 11:05 AM by David Hoffman

    cms - big file upload problem - mysql

    dssa das Newbie

      I try upload 100mb large file, and I have got transaction error. I looked jira and I saw similar problem with oracle, but they saids mysql must work ok. I suppose it is a problem with my mysql configuration, but I need information which table cointains cms data? It is cms_version_binval ???

      Thanks

        • 1. Re: cms - big file upload problem - mysql
          dssa das Newbie

          It can be other reason, so I add error log:

          12:19:40,126 ERROR [org_jboss_portal_core_portlet_cms_admin_CMSAdminPortlet] The portlet threw an exception
          javax.portlet.PortletException: org.jboss.portal.cms.CMSException: javax.transaction.xa.XAException
           at org.jboss.portal.core.portlet.cms.admin.CMSAdminPortlet.internalProcessAction(CMSAdminPortlet.java:483)
           at org.jboss.portal.core.portlet.cms.admin.CMSAdminPortlet.processAction(CMSAdminPortlet.java:354)
           at org.jboss.portlet.JBossPortlet.processAction(JBossPortlet.java:361)
           at org.jboss.portal.portlet.container.PortletContainer.invokeAction(PortletContainer.java:493)
           at org.jboss.portal.portlet.container.PortletContainer.dispatch(PortletContainer.java:429)
           at org.jboss.portal.portlet.container.PortletContainerInvoker$1.dispatch(PortletContainerInvoker.java:144)
           at org.jboss.portal.portlet.invocation.PortletInvocation.dispatch(PortletInvocation.java:223)
           at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:141)
           at org.jboss.portal.core.aspects.portlet.TransactionInterceptor.org$jboss$portal$core$aspects$portlet$TransactionInterceptor$invokeNotSupported$aop(Tran
          sactionInterceptor.java:85)
           at org.jboss.portal.core.aspects.portlet.TransactionInterceptor$invokeNotSupported_4827075286966232824.invokeNext(TransactionInterceptor$invokeNotSuppor
          ted_4827075286966232824.java)
           at org.jboss.aspects.tx.TxPolicy.invokeInNoTx(TxPolicy.java:66)
           at org.jboss.aspects.tx.TxInterceptor$NotSupported.invoke(TxInterceptor.java:102)
           at org.jboss.portal.core.aspects.portlet.TransactionInterceptor$invokeNotSupported_4827075286966232824.invokeNext(TransactionInterceptor$invokeNotSuppor
          ted_4827075286966232824.java)
           at org.jboss.portal.core.aspects.portlet.TransactionInterceptor.invokeNotSupported(TransactionInterceptor.java)
           at org.jboss.portal.core.aspects.portlet.TransactionInterceptor.invoke(TransactionInterceptor.java:55)
           at org.jboss.portal.portlet.invocation.PortletInterceptor.invoke(PortletInterceptor.java:38)
           at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:131)
           at org.jboss.portal.core.aspects.portlet.HeaderInterceptor.invoke(HeaderInterceptor.java:50)
           at org.jboss.portal.portlet.invocation.PortletInterceptor.invoke(PortletInterceptor.java:38)
           at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:131)
           at org.jboss.portal.portlet.aspects.portlet.ProducerCacheInterceptor.invoke(ProducerCacheInterceptor.java:46)
           at org.jboss.portal.portlet.invocation.PortletInterceptor.invoke(PortletInterceptor.java:38)
           at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:131)
           at org.jboss.portal.portlet.aspects.portlet.ModesInterceptor.invoke(ModesInterceptor.java:60)
           at org.jboss.portal.portlet.invocation.PortletInterceptor.invoke(PortletInterceptor.java:38)
           at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:131)
           at org.jboss.portal.bridge.BridgeInterceptor.invoke(BridgeInterceptor.java:46)
           at org.jboss.portal.portlet.invocation.PortletInterceptor.invoke(PortletInterceptor.java:38)
           at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:131)
           at org.jboss.portal.portlet.aspects.portlet.WindowStatesInterceptor.invoke(WindowStatesInterceptor.java:55)
           at org.jboss.portal.portlet.invocation.PortletInterceptor.invoke(PortletInterceptor.java:38)
           at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:131)
           at org.jboss.portal.portlet.aspects.portlet.PortletSessionSynchronizationInterceptor.invoke(PortletSessionSynchronizationInterceptor.java:77)
           at org.jboss.portal.portlet.invocation.PortletInterceptor.invoke(PortletInterceptor.java:38)
           at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:131)
           at org.jboss.portal.portlet.aspects.portlet.ContextDispatcherInterceptor$InvokeNextCommand.execute(ContextDispatcherInterceptor.java:141)
           at sun.reflect.GeneratedMethodAccessor297.invoke(Unknown Source)
           at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
           at java.lang.reflect.Method.invoke(Method.java:597)
           at org.jboss.portal.server.servlet.CommandServlet.doGet(CommandServlet.java:99)
           at org.jboss.portal.server.servlet.CommandServlet.doPost(CommandServlet.java:156)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
           at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
           at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
           at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672)
           at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:539)
           at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:499)
           at org.jboss.portal.portlet.impl.spi.AbstractRequestContext.include(AbstractRequestContext.java:194)
           at org.jboss.portal.portlet.aspects.portlet.ContextDispatcherInterceptor$1.include(ContextDispatcherInterceptor.java:69)
          


          • 2. Re: cms - big file upload problem - mysql
            dssa das Newbie

            Sorry I forgot, I'm using jboss as 4.0.5 GA, jboss portal 2.4.2 and mysql 5.1.11

            • 3. Re: cms - big file upload problem - mysql
              dssa das Newbie

              Error starts with:

              13:51:52,854 ERROR [STDERR] javax.transaction.xa.XAException
              13:51:52,854 ERROR [STDERR] at org.apache.jackrabbit.core.TransactionContext.commit(TransactionContext.java:182)
              13:51:52,885 ERROR [STDERR] at org.apache.jackrabbit.core.XASessionImpl.commit(XASessionImpl.java:315)
              13:51:52,885 ERROR [STDERR] at org.jboss.portal.cms.impl.jcr.JCRCMS.execute(JCRCMS.java:448)
              13:51:52,885 ERROR [STDERR] at sun.reflect.GeneratedMethodAccessor301.invoke(Unknown Source)
              13:51:52,885 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
              13:51:52,885 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:597)
              13:51:52,885 ERROR [STDERR] at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
              13:51:52,885 ERROR [STDERR] at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
              13:51:52,885 ERROR [STDERR] at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
              13:51:52,885 ERROR [STDERR] at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
              13:51:52,885 ERROR [STDERR] at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
              13:51:52,885 ERROR [STDERR] at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
              13:51:52,885 ERROR [STDERR] at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
              13:51:52,916 ERROR [STDERR] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
              13:51:52,916 ERROR [STDERR] at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
              13:51:52,916 ERROR [STDERR] at $Proxy123.execute(Unknown Source)
              13:51:52,916 ERROR [STDERR] at org.jboss.portal.core.portlet.cms.admin.CMSAdminPortlet.internalProcessAction(CMSAdminPortlet.java:455)
              13:51:52,916 ERROR [STDERR] at org.jboss.portal.core.portlet.cms.admin.CMSAdminPortlet.processAction(CMSAdminPortlet.java:354)
              13:51:52,916 ERROR [STDERR] at org.jboss.portlet.JBossPortlet.processAction(JBossPortlet.java:361)
              13:51:52,916 ERROR [STDERR] at org.jboss.portal.portlet.container.PortletContainer.invokeAction(PortletContainer.java:493)
              13:51:52,916 ERROR [STDERR] at org.jboss.portal.portlet.container.PortletContainer.dispatch(PortletContainer.java:429)
              13:51:52,916 ERROR [STDERR] at org.jboss.portal.portlet.container.PortletContainerInvoker$1.dispatch(PortletContainerInvoker.java:144)
              13:51:52,916 ERROR [STDERR] at org.jboss.portal.portlet.invocation.PortletInvocation.dispatch(PortletInvocation.java:223)
              13:51:52,916 ERROR [STDERR] at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:141)
              13:51:52,916 ERROR [STDERR] at org.jboss.portal.core.aspects.portlet.TransactionInterceptor.org$jboss$portal$core$aspects$portlet$TransactionInterceptor$inv


              • 4. CMS Large File Upload Failure
                David Hoffman Newbie

                I am seeing pretty much the same behavior with a file as small as 5MB. It seemed to work fine when I was using HSQLDB but now that I am using MYSQL for a datastore, I get an exception just like what is described above.

                I am using JBoss Portal 2.6.2 with JDK 1.6.0_02.
                MySql 5 with mysql-connector-java-5.0.3-bin.jar.

                Any assistance that could be rendered would be greatly appreciated.

                Thank you in advance for your help.

                Here is the stacktrace I get when trying to upload a 5MB file:


                javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac,
                 BasicAction: a20fcee:92f:4731f6e1:72f status: ActionStatus.ABORT_ONLY >
                 at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:304)
                 at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:396)
                 at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:842)
                 at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:88)
                 at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:69)
                 at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)
                 at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
                 at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139)
                 at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1547)
                 at org.hibernate.loader.Loader.doQuery(Loader.java:673)
                 at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
                 at org.hibernate.loader.Loader.loadEntity(Loader.java:1907)
                 at org.hibernate.loader.entity.CollectionElementLoader.loadElement(CollectionElementLoader.java:72)
                 at org.hibernate.persister.collection.OneToManyPersister.getElementByIndex(OneToManyPersister.java:360)
                 at org.hibernate.collection.AbstractPersistentCollection.readElementByIndex(AbstractPersistentCollection.java:158)
                 at org.hibernate.collection.PersistentMap.get(PersistentMap.java:146)
                 at org.jboss.portal.core.impl.model.portal.PortalObjectImpl.getChild(PortalObjectImpl.java:372)
                 at org.jboss.portal.core.impl.model.portal.ContextImpl.getPortal(ContextImpl.java:52)
                 at org.jboss.portal.core.impl.model.CustomizationManagerService.getDashboard(CustomizationManagerService.java:280)
                 at org.jboss.portal.core.aspects.controller.PageCustomizerInterceptor.injectDashboardNav(PageCustomizerInterceptor.java:243)
                 at org.jboss.portal.core.aspects.controller.PageCustomizerInterceptor.invoke(PageCustomizerInterceptor.java:149)
                 at org.jboss.portal.core.controller.ControllerInterceptor.invoke(ControllerInterceptor.java:40)
                 at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
                 at org.jboss.portal.core.aspects.controller.PolicyEnforcementInterceptor.invoke(PolicyEnforcementInterceptor.java:77)
                 at org.jboss.portal.core.controller.ControllerInterceptor.invoke(ControllerInterceptor.java:40)
                 at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
                 at org.jboss.portal.core.aspects.controller.node.PortalNodeInterceptor.invoke(PortalNodeInterceptor.java:81)
                 at org.jboss.portal.core.controller.ControllerInterceptor.invoke(ControllerInterceptor.java:40)
                 at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
                 at org.jboss.portal.core.aspects.controller.NavigationalStateInterceptor.invoke(NavigationalStateInterceptor.java:42)
                 at org.jboss.portal.core.controller.ControllerInterceptor.invoke(ControllerInterceptor.java:40)
                 at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
                 at org.jboss.portal.core.controller.ajax.AjaxInterceptor.invoke(AjaxInterceptor.java:51)
                 at org.jboss.portal.core.controller.ControllerInterceptor.invoke(ControllerInterceptor.java:40)
                 at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
                 at org.jboss.portal.core.aspects.controller.ResourceAcquisitionInterceptor.invoke(ResourceAcquisitionInterceptor.java:50)
                 at org.jboss.portal.core.controller.ControllerInterceptor.invoke(ControllerInterceptor.java:40)
                 at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
                 at org.jboss.portal.common.invocation.Invocation.invoke(Invocation.java:157)
                 at org.jboss.portal.core.controller.ControllerContext.execute(ControllerContext.java:128)
                 at org.jboss.portal.core.controller.Controller.processCommand(Controller.java:243)
                 at org.jboss.portal.core.controller.Controller.handle(Controller.java:226)
                 at org.jboss.portal.server.RequestControllerDispatcher.invoke(RequestControllerDispatcher.java:51)
                 at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:131)
                 at org.jboss.portal.core.cms.aspect.IdentityBindingInterceptor.invoke(IdentityBindingInterceptor.java:47)
                 at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:38)
                 at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
                 at org.jboss.portal.server.aspects.server.ContentTypeInterceptor.invoke(ContentTypeInterceptor.java:68)
                 at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:38)
                 at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
                 at org.jboss.portal.core.aspects.server.LocaleInterceptor.invoke(LocaleInterceptor.java:96)
                 at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:38)
                 at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
                 at org.jboss.portal.core.aspects.server.UserInterceptor.invoke(UserInterceptor.java:245)
                 at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:38)
                 at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
                 at org.jboss.portal.server.aspects.server.SessionInvalidatorInterceptor.invoke(SessionInvalidatorInterceptor.java:84)
                 at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:38)
                 at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
                 at org.jboss.portal.core.impl.api.user.UserEventBridgeTriggerInterceptor.invoke(UserEventBridgeTriggerInterceptor.java:65)
                 at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:38)
                 at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
                 at org.jboss.portal.core.aspects.server.TransactionInterceptor.org$jboss$portal$core$aspects$server$TransactionInterceptor$invoke$aop(TransactionInterceptor.java:49)
                 at org.jboss.portal.core.aspects.server.TransactionInterceptor$invoke_N5143606530999904530.invokeNext(TransactionInterceptor$invoke_N5143606530999904530.java)
                 at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:79)
                 at org.jboss.aspects.tx.TxInterceptor$RequiresNew.invoke(TxInterceptor.java:253)
                 at org.jboss.portal.core.aspects.server.TransactionInterceptor$invoke_N5143606530999904530.invokeNext(TransactionInterceptor$invoke_N5143606530999904530.java)
                 at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:79)
                 at org.jboss.aspects.tx.TxInterceptor$RequiresNew.invoke(TxInterceptor.java:262)
                 at org.jboss.portal.core.aspects.server.TransactionInterceptor$invoke_N5143606530999904530.invokeNext(TransactionInterceptor$invoke_N5143606530999904530.java)
                 at org.jboss.portal.core.aspects.server.TransactionInterceptor.invoke(TransactionInterceptor.java)
                 at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:38)
                 at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
                 at org.jboss.portal.server.aspects.LockInterceptor$InternalLock.invoke(LockInterceptor.java:70)
                 at org.jboss.portal.server.aspects.LockInterceptor.invoke(LockInterceptor.java:131)
                 at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
                 at org.jboss.portal.common.invocation.Invocation.invoke(Invocation.java:157)
                 at org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:380)
                 at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
                 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
                 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
                 at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
                 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
                 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
                 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
                 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
                 at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
                 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525)
                 at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
                 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
                 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
                 at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
                 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
                 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:241)
                 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
                 at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:580)
                 at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
                 at java.lang.Thread.run(Thread.java:619)
                


                • 5. Re: cms - big file upload problem - mysql
                  David Hoffman Newbie

                  One error in my previous post. I thought I was at portal version 2.6.2 but in fact I am using 2.6.1.

                  While waiting for some sort of assistance, I will try 2.6.2 and see if it is resolved there.

                  • 6. Re: cms - big file upload problem - mysql
                    Chris Laprun Master

                    Not sure if it would make a difference (as I'm not working on CMS) but we do NOT currently support Java 6...

                    • 7. Re: cms - big file upload problem - mysql
                      David Hoffman Newbie

                      OK, I have tried the following configurations, all with the same results.

                      2.6.1 w/ jdk 1.5
                      2.6.1 w/ jdk 1.6

                      2.6.2 w/ jdk 1.5
                      2.6.2 w/ jdk 1.6

                      Regardless of the configuration, I still get the same exception:

                      
                      javax.resource.ResourceException: Transaction is not active:
                       tx=TransactionImple < ac, BasicAction:
                       a20fcee:92f:4731f6e1:72f status: ActionStatus.ABORT_ONLY >
                       at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManage
                      r.java:304)
                       at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionMan
                      ager2.java:396)
                       at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConne
                      ction(BaseConnectionManager2.java:842)
                       at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:88)
                       at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider
                      .java:69)
                       at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)
                      
                      
                      ...
                      
                      
                      org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
                       at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
                       at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:241)
                       at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
                       at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:580)
                      
                       at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
                       at java.lang.Thread.run(Thread.java:619)
                      
                      


                      Looking through the stacktrace, this seems to be some sort of hibernate transaction issue.... Am I reading this right? Is the transaction closing before it is finished?




                      • 8. Re: cms - big file upload problem - mysql
                        Peter Johnson Master

                        What is the max_allowed_packet size for your MySQL database? It must be as large as the blob you are attempting to insert (I would try the file size plus 5-10%).

                        See http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#option_mysqld_max_allowed_packet

                        • 9. Re: cms - big file upload problem - mysql
                          David Hoffman Newbie

                          Problem solved. Thank you for your help.

                          All I had to do was add

                          max_allowed_packet=10485760
                          


                          to my my.ini file and it started working.