[opencms-dev] The table 'CMS_BACKUP_CONTENTS' is full - Errormessage when publishing

[Hein van der Kallen]

Jeremy
see http://www.opencms-forum.de/opencms-forum/viewthread?thread=3545#9313

Hein van der Kallen
----- Original Message ----- 
From: "Jeremy Wilson" <jeremy.wilson at laplink.com>
To: "The OpenCms mailing list" <opencms-dev at opencms.org>
Sent: Monday, May 16, 2011 8:24 PM
Subject: [opencms-dev] The table 'CMS_BACKUP_CONTENTS' is full - 
Errormessage when publishing


> Recently a my web staging environment started producing the following
> error, "The table 'CMS_BACKUP_CONTENTS' is full", when trying to publish
> certain files under /sites/default/ and now it is popping up on some
> files under /system/modules/ as well.  It is not consistent except that
> currently it seems limited to larger *.swf, *.pdf, and *.wmv files.
>
> Can anyone tell me if this is easily rectified and maybe a pointer or
> two in the right direction?
>
>
> Here is the text of the console message/error.
>
> Validating links ...
> ... finished validating links
> Publishing resources ...
> Publishing files ...
> ( 1 / 1 ) Publishing file
> /system/modules/com.abc.www/includes/styles/global.css ... Error
> publishing file
> "/system/modules/com.abc.www/includes/styles/global.css".
> Exception org.opencms.db.CmsDbSqlException: An SQL error occurred when
> executing the following query:
> com.mysql.jdbc.ServerPreparedStatement[39] - INSERT INTO
> CMS_BACKUP_CONTENTS
> (CONTENT_ID,RESOURCE_ID,FILE_CONTENT,PUBLISH_TAG,VERSION_ID,BACKUP_ID)
> VALUES
> ('88f13f72-3620-11e0-a36c-000c295d1071','69e07889-400a-11da-be17-0030482
> b843c',** STREAM DATA
> **,11426,137,'17a03424-7fe8-11e0-8f57-000c295d1071').
> at
> org.opencms.db.generic.CmsBackupDriver.internalWriteBackupFileContent(Cm
> sBackupDriver.java:1253)
> at
> org.opencms.db.generic.CmsBackupDriver.writeBackupResource(CmsBackupDriv
> er.java:1087)
> at
> org.opencms.db.generic.CmsProjectDriver.publishFile(CmsProjectDriver.jav
> a:1073)
> at
> org.opencms.db.generic.CmsProjectDriver.publishProject(CmsProjectDriver.
> java:1654)
> at
> org.opencms.db.CmsDriverManager.publishProject(CmsDriverManager.java:449
> 3)
> at
> org.opencms.db.CmsSecurityManager.publishProject(CmsSecurityManager.java
> :2893)
> at org.opencms.file.CmsObject.publishProject(CmsObject.java:1975)
> at
> org.opencms.workplace.threads.CmsPublishThread.run(CmsPublishThread.java
> :122)
> Caused by: java.sql.SQLException: The table 'CMS_BACKUP_CONTENTS' is
> full
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
> at
> com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedState
> ment.java:1124)
> at
> com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedSta
> tement.java:676)
> at
> com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:11
> 66)
> at
> com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:10
> 82)
> at
> com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:10
> 67)
> at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delega
> tingPreparedStatement.java:101)
> at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delega
> tingPreparedStatement.java:101)
> at
> org.opencms.db.generic.CmsBackupDriver.internalWriteBackupFileContent(Cm
> sBackupDriver.java:1250)
> ... 7 more
> Statistics: published files: 1, published folders: 0, deleted folders:
> 0, duration: 00:00:00
> Exception org.opencms.db.CmsDbSqlException: Error publishing file
> "/system/modules/com.abc.www/includes/styles/global.css".
> at
> org.opencms.db.CmsDbSqlException.createException(CmsDbSqlException.java:
> 103)
> at org.opencms.db.CmsDbContext.throwException(CmsDbContext.java:213)
> at org.opencms.db.CmsDbContext.report(CmsDbContext.java:197)
> at
> org.opencms.db.generic.CmsProjectDriver.publishProject(CmsProjectDriver.
> java:1675)
> at
> org.opencms.db.CmsDriverManager.publishProject(CmsDriverManager.java:449
> 3)
> at
> org.opencms.db.CmsSecurityManager.publishProject(CmsSecurityManager.java
> :2893)
> at org.opencms.file.CmsObject.publishProject(CmsObject.java:1975)
> at
> org.opencms.workplace.threads.CmsPublishThread.run(CmsPublishThread.java
> :122)
> Caused by: org.opencms.db.CmsDbSqlException: An SQL error occurred when
> executing the following query:
> com.mysql.jdbc.ServerPreparedStatement[39] - INSERT INTO
> CMS_BACKUP_CONTENTS
> (CONTENT_ID,RESOURCE_ID,FILE_CONTENT,PUBLISH_TAG,VERSION_ID,BACKUP_ID)
> VALUES
> ('88f13f72-3620-11e0-a36c-000c295d1071','69e07889-400a-11da-be17-0030482
> b843c',** STREAM DATA
> **,11426,137,'17a03424-7fe8-11e0-8f57-000c295d1071').
> at
> org.opencms.db.generic.CmsBackupDriver.internalWriteBackupFileContent(Cm
> sBackupDriver.java:1253)
> at
> org.opencms.db.generic.CmsBackupDriver.writeBackupResource(CmsBackupDriv
> er.java:1087)
> at
> org.opencms.db.generic.CmsProjectDriver.publishFile(CmsProjectDriver.jav
> a:1073)
> at
> org.opencms.db.generic.CmsProjectDriver.publishProject(CmsProjectDriver.
> java:1654)
> ... 4 more
> Caused by: java.sql.SQLException: The table 'CMS_BACKUP_CONTENTS' is
> full
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
> at
> com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedState
> ment.java:1124)
> at
> com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedSta
> tement.java:676)
> at
> com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:11
> 66)
> at
> com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:10
> 82)
> at
> com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:10
> 67)
> at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delega
> tingPreparedStatement.java:101)
> at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delega
> tingPreparedStatement.java:101)
> at
> org.opencms.db.generic.CmsBackupDriver.internalWriteBackupFileContent(Cm
> sBackupDriver.java:1250)
> ... 7 more
>
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://lists.opencms.org/mailman/listinfo/opencms-dev