topic [Solved]SQLException: The table 'alf_audit_fact' is full in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/solved-sqlexception-the-table-alf-audit-fact-is-full/m-p/212900#M166030 <HTML><HEAD></HEAD><BODY><SPAN>I went to log into Explorer and saw the following error:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE>javax.faces.FacesException: Error calling action method of component with id loginForm:submit<BR />caused by:<BR />javax.faces.el.EvaluationException: Exception while invoking expression #{LoginBean.login}<BR />caused by:<BR />org.alfresco.repo.audit.AuditException: 110411028 Failed to audit exception<BR />caused by:<BR />org.hibernate.exception.GenericJDBCException: could not insert: [org.alfresco.repo.audit.hibernate.AuditFactImpl]<BR />caused by:<BR />java.sql.SQLException: The table 'alf_audit_fact' is full<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>I am not sure if this helpful:</SPAN><BR /><BR /><BR /><PRE class="language-none line-numbers"><CODE>javax.faces.FacesException: Error calling action method of component with id loginForm:submit<BR />at org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:72)<BR />at javax.faces.component.UICommand.broadcast(UICommand.java:109)<BR />at javax.faces.component.UIViewRoot._broadcastForPhase(UIViewRoot.java:97)<BR />at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:171)<BR />at org.apache.myfaces.lifecycle.InvokeApplicationExecutor.execute(InvokeApplicationExecutor.java:32)<BR />at org.apache.myfaces.lifecycle.LifecycleImpl.executePhase(LifecycleImpl.java:95)<BR />at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:70)<BR />at javax.faces.webapp.FacesServlet.service(FacesServlet.java:139)<BR />at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)<BR />at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<BR />at org.alfresco.web.app.servlet.AuthenticationFilter.doFilter(AuthenticationFilter.java:124)<BR />at sun.reflect.GeneratedMethodAccessor623.invoke(Unknown Source)<BR />at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<BR />at java.lang.reflect.Method.invoke(Method.java:597)<BR />at org.alfresco.repo.management.subsystems.ChainingSubsystemProxyFactory$1.invoke(ChainingSubsystemProxyFactory.java:122)<BR />at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)<BR />at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)<BR />at $Proxy194.doFilter(Unknown Source)<BR />at org.alfresco.repo.web.filter.beans.BeanProxyFilter.doFilter(BeanProxyFilter.java:88)<BR />at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<BR />at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<BR />at org.alfresco.repo.web.filter.beans.NullFilter.doFilter(NullFilter.java:74)<BR />at sun.reflect.GeneratedMethodAccessor623.invoke(Unknown Source)<BR />at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<BR />at java.lang.reflect.Method.invoke(Method.java:597)<BR />at org.alfresco.repo.management.subsystems.ChainingSubsystemProxyFactory$1.invoke(ChainingSubsystemProxyFactory.java:122)<BR />at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)<BR />at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)<BR />at $Proxy194.doFilter(Unknown Source)<BR />at org.alfresco.repo.web.filter.beans.BeanProxyFilter.doFilter(BeanProxyFilter.java:88)<BR />at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<BR />at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<BR />at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)<BR />at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)<BR />at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)<BR />at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)<BR />at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)<BR />at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)<BR />at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)<BR />at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)<BR />at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)<BR />at java.lang.Thread.run(Thread.java:619)<BR />Caused by: javax.faces.el.EvaluationException: Exception while invoking expression #{LoginBean.login}<BR />at org.apache.myfaces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:156)<BR />at org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:61)<BR />… 41 more<BR />Caused by: org.alfresco.repo.audit.AuditException: 110411028 Failed to audit exception<BR />at org.alfresco.repo.audit.AuditComponentImpl.auditImpl(AuditComponentImpl.java:338)<BR />at org.alfresco.repo.audit.AuditComponentImpl.audit(AuditComponentImpl.java:229)<BR />at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:69)<BR />at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)<BR />at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)<BR />at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)<BR />at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)<BR />at $Proxy26.authenticate(Unknown Source)<BR />at org.alfresco.web.bean.LoginBean.login(LoginBean.java:282)<BR />at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<BR />at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<BR />at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<BR />at java.lang.reflect.Method.invoke(Method.java:597)<BR />at org.apache.myfaces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:132)<BR />… 42 more<BR />Caused by: org.hibernate.exception.GenericJDBCException: could not insert: [org.alfresco.repo.audit.hibernate.AuditFactImpl]<BR />at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)<BR />at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)<BR />at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)<BR />at org.hibernate.id.insert.AbstractSelectingDelegate.performInsert(AbstractSelectingDelegate.java:40)<BR />at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2163)<BR />at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2643)<BR />at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:51)<BR />at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:322)<BR />at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:298)<BR />at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181)<BR />at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107)<BR />at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187)<BR />at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)<BR />at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172)<BR />at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)<BR />at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)<BR />at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:535)<BR />at org.hibernate.impl.SessionImpl.save(SessionImpl.java:523)<BR />at org.hibernate.impl.SessionImpl.save(SessionImpl.java:519)<BR />at org.alfresco.repo.audit.hibernate.HibernateAuditDAO.audit0(HibernateAuditDAO.java:225)<BR />at org.alfresco.repo.audit.hibernate.HibernateAuditDAO.audit(HibernateAuditDAO.java:159)<BR />at org.alfresco.repo.audit.AuditComponentImpl$1.execute(AuditComponentImpl.java:309)<BR />at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:326)<BR />at org.alfresco.repo.audit.AuditComponentImpl.auditImpl(AuditComponentImpl.java:314)<BR />… 55 more<BR />Caused by: java.sql.SQLException: The table 'alf_audit_fact' is full<BR />at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)<BR />at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)<BR />at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)<BR />at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)<BR />at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)<BR />at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)<BR />at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554)<BR />at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1761)<BR />at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2046)<BR />at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1964)<BR />at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1949)<BR />at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)<BR />at org.hibernate.id.insert.AbstractSelectingDelegate.performInsert(AbstractSelectingDelegate.java:33)<BR />… 75 more<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>Return to application</SPAN><BR /><SPAN>My Content</SPAN><BR /><SPAN>Logout</SPAN></BODY></HTML> Fri, 04 Dec 2009 18:48:18 GMT newmember 2009-12-04T18:48:18Z [Solved]SQLException: The table 'alf_audit_fact' is full https://connect.hyland.com/t5/alfresco-archive/solved-sqlexception-the-table-alf-audit-fact-is-full/m-p/212900#M166030 I went to log into Explorer and saw the following error:javax.faces.FacesException: Error calling action method of component with id loginForm:submitcaused by:javax.faces.el.EvaluationException: Exception while invoking expression #{LoginBean.login}caused by<IMG id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />rg.alfresco.repo.audit.AuditException: 1 Fri, 04 Dec 2009 18:48:18 GMT https://connect.hyland.com/t5/alfresco-archive/solved-sqlexception-the-table-alf-audit-fact-is-full/m-p/212900#M166030 newmember 2009-12-04T18:48:18Z Re: [Solved]SQLException: The table 'alf_audit_fact' is full https://connect.hyland.com/t5/alfresco-archive/solved-sqlexception-the-table-alf-audit-fact-is-full/m-p/212901#M166031 <HTML><HEAD></HEAD><BODY><SPAN>What are your environment details, including O/S ? For MySQL/InnoDB, see also:</SPAN><BR /><BR /><A href="http://dev.mysql.com/doc/refman/5.0/en/full-table.html" rel="nofollow noopener noreferrer">http://dev.mysql.com/doc/refman/5.0/en/full-table.html</A><BR /><BR /><SPAN>Regards,</SPAN><BR /><SPAN>Jan</SPAN></BODY></HTML> Mon, 07 Dec 2009 09:50:53 GMT https://connect.hyland.com/t5/alfresco-archive/solved-sqlexception-the-table-alf-audit-fact-is-full/m-p/212901#M166031 janv 2009-12-07T09:50:53Z Re: [Solved]SQLException: The table 'alf_audit_fact' is full https://connect.hyland.com/t5/alfresco-archive/solved-sqlexception-the-table-alf-audit-fact-is-full/m-p/212902#M166032 <HTML><HEAD></HEAD><BODY><SPAN>The problem I had was that I ran out of disk space which made mysql through an error.</SPAN><BR /><SPAN>I had to move everything to a new HDD.</SPAN></BODY></HTML> Mon, 07 Dec 2009 15:30:47 GMT https://connect.hyland.com/t5/alfresco-archive/solved-sqlexception-the-table-alf-audit-fact-is-full/m-p/212902#M166032 newmember 2009-12-07T15:30:47Z