cancel
Showing results for 
Search instead for 
Did you mean: 

alf_Transcation is full

rubicon49bc
Champ in-the-making
Champ in-the-making
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.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)|#]

Is it safe to clean this table?
1 REPLY 1

rubicon49bc
Champ in-the-making
Champ in-the-making
Fixed it. Had to run the following on the MySQL server;


ALTER TABLE alf_transaction MAX_ROWS=1000000000;