topic alf_Transcation is full in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/alf-transcation-is-full/m-p/210413#M163543 <HTML><HEAD></HEAD><BODY><SPAN>Getting this error</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />[#|2009-04-09T19:17:03.167+0000|INFO|sun-appserver2.1|org.alfresco.repo.transaction.RetryingTransactionHelper|_ThreadID=16;_ThreadName=pool-1-thread-4;|Retrying pool-1-thread-4: count 39; wait: 1.4s; msg: "Hibernate operation: could not insert: [org.alfresco.repo.domain.hibernate.TransactionImpl]; uncategorized SQLException for SQL [insert into alf_transaction (version, server_id, change_txn_id, commit_time_ms) values (?, ?, ?, ?)]; SQL state [HY000]; error code [1114]; The table 'alf_transaction' is full; nested exception is java.sql.SQLException: The table 'alf_transaction' is full"; exception: (org.springframework.jdbc.UncategorizedSQLException)|#]<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>Is it safe to clean this table?</SPAN></BODY></HTML> Thu, 09 Apr 2009 11:16:25 GMT rubicon49bc 2009-04-09T11:16:25Z alf_Transcation is full https://connect.hyland.com/t5/alfresco-archive/alf-transcation-is-full/m-p/210413#M163543 Getting this error[#|2009-04-09T19:17:03.167+0000|INFO|sun-appserver2.1|org.alfresco.repo.transaction.RetryingTransactionHelper|_ThreadID=16;_ThreadName=pool-1-thread-4;|Retrying pool-1-thread-4: count 39; wait: 1.4s; msg: "Hibernate operation: could not insert: [org.alfresco.repo.domain.hibernate.T Thu, 09 Apr 2009 11:16:25 GMT https://connect.hyland.com/t5/alfresco-archive/alf-transcation-is-full/m-p/210413#M163543 rubicon49bc 2009-04-09T11:16:25Z Re: alf_Transcation is full https://connect.hyland.com/t5/alfresco-archive/alf-transcation-is-full/m-p/210414#M163544 <HTML><HEAD></HEAD><BODY><SPAN>Fixed it. Had to run the following on the MySQL server;</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />ALTER TABLE alf_transaction MAX_ROWS=1000000000;<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE></BODY></HTML> Thu, 09 Apr 2009 12:31:22 GMT https://connect.hyland.com/t5/alfresco-archive/alf-transcation-is-full/m-p/210414#M163544 rubicon49bc 2009-04-09T12:31:22Z