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

[Jeremy Wilson]

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