[opencms-dev] error importing OpenCms_Workflow2

Olivier Camus olivier.camus at steria.com
Wed Jan 23 09:59:53 CET 2008


Hi !

Increase mysqld / mysqldump max_allowed_packet parameter.
try to put max_allowed_packet=64M in your my.cnf/my.ini file.
(Take a look to mails archive for mor details.)

@+

-------------- next part --------------
Imported commons successfully, but getting below error on importing
springmanager.

Using MySQL 5, Tomcat 5.0.28 and OpenCms_Workflow2_v0.4.1_full-package.zip

Tried increasing size of " max_allowed_packet" to <19999744>, but no
success.

******************************* *START ERROR****************************
( 14 / 22 ) Importing
/system/modules/com.bearingpoint.opencms.commons.springmanager/lib/hibernate-
entitymanager.jar ... o.k.
( 15 / 22 ) Importing
/system/modules/com.bearingpoint.opencms.commons.springmanager/lib/hibernate3.jar
... Exception org.opencms.db.CmsDbSqlException: Error creating resource
"/system/modules/com.bearingpoint.opencms.commons.springmanager/lib/hibernate3.jar"
on path
"/system/modules/com.bearingpoint.opencms.commons.springmanager/lib/hibernate3.jar".
at org.opencms.db.CmsDbSqlException.createException(CmsDbSqlException.java
:116)
at org.opencms.db.CmsDbContext.throwException(CmsDbContext.java:238)
at org.opencms.db.CmsDbContext.report(CmsDbContext.java:212)
at org.opencms.db.CmsSecurityManager.importResource(CmsSecurityManager.java
:2605)
at org.opencms.file.types.A_CmsResourceType.importResource
(A_CmsResourceType.java:475)
at org.opencms.file.CmsObject.importResource(CmsObject.java:2011)
at org.opencms.importexport.CmsImportVersion4.importResource(
CmsImportVersion4.java:353)
at org.opencms.importexport.CmsImportVersion4.readResourcesFromManifest(
CmsImportVersion4.java:516)
at org.opencms.importexport.CmsImportVersion4.importResources(
CmsImportVersion4.java:140)
at org.opencms.importexport.CmsImport.importResources(CmsImport.java:308)
at org.opencms.module.CmsModuleImportExportHandler.importModule(
CmsModuleImportExportHandler.java:557)
at org.opencms.module.CmsModuleImportExportHandler.importData(
CmsModuleImportExportHandler.java:358)
at org.opencms.importexport.CmsImportExportManager.importData(
CmsImportExportManager.java:694)
at org.opencms.workplace.threads.CmsDatabaseImportThread.run(
CmsDatabaseImportThread.java:90)
Caused by: org.opencms.db.CmsDbSqlException: An SQL error occurred when
executing the following query: com.mysql.jdbc.PreparedStatement at 1eb2473:
INSERT INTO CMS_OFFLINE_CONTENTS (RESOURCE_ID,FILE_CONTENT) VALUES
('7c46f962-c98d-11dc-8e29-a99bc8653b57',** STREAM DATA **).
at org.opencms.db.generic.CmsVfsDriver.createContent(CmsVfsDriver.java:174)
at org.opencms.db.generic.CmsVfsDriver.createResource(CmsVfsDriver.java:622)
at org.opencms.db.CmsDriverManager.createResource(CmsDriverManager.java
:1679)
at org.opencms.db.CmsSecurityManager.importResource(CmsSecurityManager.java
:2603)
... 10 more
Caused by: com.mysql.jdbc.PacketTooBigException: Packet for query is too
large (2036199 > 1048576). You can change this value on the server by
setting the max_allowed_packet' variable.
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2691)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1612)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3256)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java
:1313)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1585)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1500)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1485)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(
DelegatingPreparedStatement.java:102)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(
DelegatingPreparedStatement.java:102)
at org.opencms.db.generic.CmsVfsDriver.createContent(CmsVfsDriver.java:172)
... 13 more
Exception org.opencms.db.CmsDbSqlException: Error creating resource
"/system/modules/com.bearingpoint.opencms.commons.springmanager/lib/hibernate3.jar"
on path
"/system/modules/com.bearingpoint.opencms.commons.springmanager/lib/hibernate3.jar".
at org.opencms.db.CmsDbSqlException.createException(CmsDbSqlException.java
:116)
at org.opencms.db.CmsDbContext.throwException(CmsDbContext.java:238)
at org.opencms.db.CmsDbContext.report(CmsDbContext.java:212)
at org.opencms.db.CmsSecurityManager.importResource(CmsSecurityManager.java
:2605)
at org.opencms.file.types.A_CmsResourceType.importResource
(A_CmsResourceType.java:475)
at org.opencms.file.CmsObject.importResource(CmsObject.java:2011)
at org.opencms.importexport.CmsImportVersion4.importResource(
CmsImportVersion4.java:353)
at org.opencms.importexport.CmsImportVersion4.readResourcesFromManifest(
CmsImportVersion4.java:516)
at org.opencms.importexport.CmsImportVersion4.importResources(
CmsImportVersion4.java:140)
at org.opencms.importexport.CmsImport.importResources(CmsImport.java:308)
at org.opencms.module.CmsModuleImportExportHandler.importModule(
CmsModuleImportExportHandler.java:557)
at org.opencms.module.CmsModuleImportExportHandler.importData(
CmsModuleImportExportHandler.java:358)
at org.opencms.importexport.CmsImportExportManager.importData(
CmsImportExportManager.java:694)
at org.opencms.workplace.threads.CmsDatabaseImportThread.run(
CmsDatabaseImportThread.java:90)
Caused by: org.opencms.db.CmsDbSqlException: An SQL error occurred when
executing the following query: com.mysql.jdbc.PreparedStatement at 1eb2473:
INSERT INTO CMS_OFFLINE_CONTENTS (RESOURCE_ID,FILE_CONTENT) VALUES
('7c46f962-c98d-11dc-8e29-a99bc8653b57',** STREAM DATA **).
at org.opencms.db.generic.CmsVfsDriver.createContent(CmsVfsDriver.java:174)
at org.opencms.db.generic.CmsVfsDriver.createResource(CmsVfsDriver.java:622)
at org.opencms.db.CmsDriverManager.createResource(CmsDriverManager.java
:1679)
at org.opencms.db.CmsSecurityManager.importResource(CmsSecurityManager.java
:2603)
... 10 more
Caused by: com.mysql.jdbc.PacketTooBigException: Packet for query is too
large (2036199 > 1048576). You can change this value on the server by
setting the max_allowed_packet' variable.
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2691)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1612)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3256)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java
:1313)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1585)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1500)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1485)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(
DelegatingPreparedStatement.java:102)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(
DelegatingPreparedStatement.java:102)
at org.opencms.db.generic.CmsVfsDriver.createContent(CmsVfsDriver.java:172)
... 13 more
Skipping
/system/modules/com.bearingpoint.opencms.commons.springmanager/lib/hibernate3.jar

( 16 / 22 ) Importing
/system/modules/com.bearingpoint.opencms.commons.springmanager/lib/jta.jar
... o.k.
( 17 / 22 ) Importing
/system/modules/com.bearingpoint.opencms.commons.springmanager/lib/spring-
1.2.6.jar ... Exception org.opencms.db.CmsDbSqlException: Error creating
resource
"/system/modules/com.bearingpoint.opencms.commons.springmanager/lib/spring-
1.2.6.jar" on path
"/system/modules/com.bearingpoint.opencms.commons.springmanager/lib/spring-
1.2.6.jar".
at org.opencms.db.CmsDbSqlException.createException(CmsDbSqlException.java
:116)
at org.opencms.db.CmsDbContext.throwException(CmsDbContext.java:238)
at org.opencms.db.CmsDbContext.report(CmsDbContext.java:212)
at org.opencms.db.CmsSecurityManager.importResource(CmsSecurityManager.java
:2605)
at org.opencms.file.types.A_CmsResourceType.importResource
(A_CmsResourceType.java:475)
at org.opencms.file.CmsObject.importResource(CmsObject.java:2011)
at org.opencms.importexport.CmsImportVersion4.importResource(
CmsImportVersion4.java:353)
at org.opencms.importexport.CmsImportVersion4.readResourcesFromManifest(
CmsImportVersion4.java:516)
at org.opencms.importexport.CmsImportVersion4.importResources(
CmsImportVersion4.java:140)
at org.opencms.importexport.CmsImport.importResources(CmsImport.java:308)
at org.opencms.module.CmsModuleImportExportHandler.importModule(
CmsModuleImportExportHandler.java:557)
at org.opencms.module.CmsModuleImportExportHandler.importData(
CmsModuleImportExportHandler.java:358)
at org.opencms.importexport.CmsImportExportManager.importData(
CmsImportExportManager.java:694)
at org.opencms.workplace.threads.CmsDatabaseImportThread.run(
CmsDatabaseImportThread.java:90)
Caused by: org.opencms.db.CmsDbSqlException: An SQL error occurred when
executing the following query: com.mysql.jdbc.PreparedStatement at 1eb2473:
INSERT INTO CMS_OFFLINE_CONTENTS (RESOURCE_ID,FILE_CONTENT) VALUES
('7d119c66-c98d-11dc-8e29-a99bc8653b57',** STREAM DATA **).
at org.opencms.db.generic.CmsVfsDriver.createContent(CmsVfsDriver.java:174)
at org.opencms.db.generic.CmsVfsDriver.createResource(CmsVfsDriver.java:622)
at org.opencms.db.CmsDriverManager.createResource(CmsDriverManager.java
:1679)
at org.opencms.db.CmsSecurityManager.importResource(CmsSecurityManager.java
:2603)
... 10 more
Caused by: com.mysql.jdbc.PacketTooBigException: Packet for query is too
large (1980691 > 1048576). You can change this value on the server by
setting the max_allowed_packet' variable.
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2691)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1612)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3256)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java
:1313)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1585)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1500)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1485)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(
DelegatingPreparedStatement.java:102)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(
DelegatingPreparedStatement.java:102)
at org.opencms.db.generic.CmsVfsDriver.createContent(CmsVfsDriver.java:172)
... 13 more
Skipping
/system/modules/com.bearingpoint.opencms.commons.springmanager/lib/spring-
1.2.6.jar
( 18 / 22 ) Importing
/system/modules/com.bearingpoint.opencms.commons.springmanager/lib/spring-
mock.jar ... Exception org.opencms.db.CmsDbSqlException: Error creating
resource
"/system/modules/com.bearingpoint.opencms.commons.springmanager/lib/spring-
1.2.6.jar" on path
"/system/modules/com.bearingpoint.opencms.commons.springmanager/lib/spring-
1.2.6.jar".
at org.opencms.db.CmsDbSqlException.createException(CmsDbSqlException.java
:116)
at org.opencms.db.CmsDbContext.throwException(CmsDbContext.java:238)
at org.opencms.db.CmsDbContext.report(CmsDbContext.java:212)
at org.opencms.db.CmsSecurityManager.importResource(CmsSecurityManager.java
:2605)
at org.opencms.file.types.A_CmsResourceType.importResource
(A_CmsResourceType.java:475)
at org.opencms.file.CmsObject.importResource(CmsObject.java:2011)
at org.opencms.importexport.CmsImportVersion4.importResource(
CmsImportVersion4.java:353)
at org.opencms.importexport.CmsImportVersion4.readResourcesFromManifest(
CmsImportVersion4.java:516)
at org.opencms.importexport.CmsImportVersion4.importResources(
CmsImportVersion4.java:140)
at org.opencms.importexport.CmsImport.importResources(CmsImport.java:308)
at org.opencms.module.CmsModuleImportExportHandler.importModule(
CmsModuleImportExportHandler.java:557)
at org.opencms.module.CmsModuleImportExportHandler.importData(
CmsModuleImportExportHandler.java:358)
at org.opencms.importexport.CmsImportExportManager.importData(
CmsImportExportManager.java:694)
at org.opencms.workplace.threads.CmsDatabaseImportThread.run(
CmsDatabaseImportThread.java:90)
Caused by: org.opencms.db.CmsDbSqlException: An SQL error occurred when
executing the following query: com.mysql.jdbc.PreparedStatement at 1eb2473:
INSERT INTO CMS_OFFLINE_CONTENTS (RESOURCE_ID,FILE_CONTENT) VALUES
('7d119c66-c98d-11dc-8e29-a99bc8653b57',** STREAM DATA **).
at org.opencms.db.generic.CmsVfsDriver.createContent(CmsVfsDriver.java:174)
at org.opencms.db.generic.CmsVfsDriver.createResource(CmsVfsDriver.java:622)
at org.opencms.db.CmsDriverManager.createResource(CmsDriverManager.java
:1679)
at org.opencms.db.CmsSecurityManager.importResource(CmsSecurityManager.java
:2603)
... 10 more
Caused by: com.mysql.jdbc.PacketTooBigException: Packet for query is too
large (1980691 > 1048576). You can change this value on the server by
setting the max_allowed_packet' variable.
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2691)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1612)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3256)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java
:1313)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1585)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1500)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1485)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(
DelegatingPreparedStatement.java:102)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(
DelegatingPreparedStatement.java:102)
at org.opencms.db.generic.CmsVfsDriver.createContent(CmsVfsDriver.java:172)
... 13 more
o.k.
( 19 / 22 ) Skipping /system/workplace/
( 20 / 22 ) Skipping /system/workplace/admin/
( 21 / 22 ) Importing /system/workplace/admin/bptools/ ... o.k.
( 22 / 22 ) Importing
/system/workplace/admin/bptools/spring_factory_reload.jsp ... o.k.
Parsing links ...
( 1 / 1 ) Parsing links for
"/system/workplace/admin/bptools/spring_factory_reload.jsp"... o.k.
... The parsing process is finished.
Publishing project ...
Publishing resources ...
Publishing folders ...
( 1 / 6 ) Publishing folder /system/ ... o.k.
( 2 / 6 ) Publishing folder
/system/modules/com.bearingpoint.opencms.commons.springmanager/ ... o.k.
( 3 / 6 ) Publishing folder
/system/modules/com.bearingpoint.opencms.commons.springmanager/classes/ ...
o.k.
( 4 / 6 ) Publishing folder
/system/modules/com.bearingpoint.opencms.commons.springmanager/config/ ...
o.k.
( 5 / 6 ) Publishing folder
/system/modules/com.bearingpoint.opencms.commons.springmanager/lib/ ... o.k.
( 6 / 6 ) Publishing folder /system/workplace/admin/bptools/ ... o.k.
... finished publishing folders
Publishing files ...
( 1 / 13 ) Publishing file
/system/modules/com.bearingpoint.opencms.commons.springmanager/config/bearingpoint-
springmanager.xml ... o.k.
( 2 / 13 ) Publishing file
/system/modules/com.bearingpoint.opencms.commons.springmanager/lib/antlr-
2.7.5H3.jar ... o.k.
( 3 / 13 ) Publishing file
/system/modules/com.bearingpoint.opencms.commons.springmanager/lib/asm-
attrs.jar ... o.k.
( 4 / 13 ) Publishing file
/system/modules/com.bearingpoint.opencms.commons.springmanager/lib/asm.jar
... o.k.
( 5 / 13 ) Publishing file
/system/modules/com.bearingpoint.opencms.commons.springmanager/lib/cglib-
2.1_2jboss.jar ... o.k.
( 6 / 13 ) Publishing file
/system/modules/com.bearingpoint.opencms.commons.springmanager/lib/com.bearingpoint.opencms.commons.springmanager.jar
... o.k.
( 7 / 13 ) Publishing file
/system/modules/com.bearingpoint.opencms.commons.springmanager/lib/hibernate-
annotations.jar ... o.k.
( 8 / 13 ) Publishing file
/system/modules/com.bearingpoint.opencms.commons.springmanager/lib/hibernate-
entitymanager.jar ... o.k.
( 9 / 13 ) Publishing file
/system/modules/com.bearingpoint.opencms.commons.springmanager/lib/hibernate3.jar
... Error publishing file
"/system/modules/com.bearingpoint.opencms.commons.springmanager/lib/hibernate3.jar".

Exception org.opencms.file.CmsDataAccessException: Unable to read file
contents with resource ID "7c46f962-c98d-11dc-8e29-a99bc8653b57"
(online=false).
at org.opencms.db.generic.CmsProjectDriver.publishFile(CmsProjectDriver.java
:996)
at org.opencms.db.generic.CmsProjectDriver.publishProject(
CmsProjectDriver.java:1407)
at org.opencms.db.CmsDriverManager.publishJob(CmsDriverManager.java:5073)
at org.opencms.publish.CmsPublishThread.run(CmsPublishThread.java:141)
Caused by: org.opencms.file.CmsVfsResourceNotFoundException: Unable to read
file contents with resource ID "7c46f962-c98d-11dc-8e29-a99bc8653b57"
(online=false).
at org.opencms.db.generic.CmsVfsDriver.readContent(CmsVfsDriver.java:1424)
at org.opencms.db.generic.CmsProjectDriver.publishFileContent(
CmsProjectDriver.java:1022)
at org.opencms.db.generic.CmsProjectDriver.publishNewFile(
CmsProjectDriver.java:2903)
at org.opencms.db.generic.CmsProjectDriver.publishFile(CmsProjectDriver.java
:952)
... 3 more
Statistics: published files: 9, published folders: 6, deleted folders: 0,
duration: 00:00:00
Exception org.opencms.file.CmsDataAccessException: Error publishing file
"/system/modules/com.bearingpoint.opencms.commons.springmanager/lib/hibernate3.jar".

at org.opencms.file.CmsDataAccessException.createException(
CmsDataAccessException.java:77)
at org.opencms.db.CmsDbContext.throwException(CmsDbContext.java:238)
at org.opencms.db.CmsDbContext.report(CmsDbContext.java:212)
at org.opencms.db.generic.CmsProjectDriver.publishProject(
CmsProjectDriver.java:1427)
at org.opencms.db.CmsDriverManager.publishJob(CmsDriverManager.java:5073)
at org.opencms.publish.CmsPublishThread.run(CmsPublishThread.java:141)
Caused by: org.opencms.file.CmsDataAccessException: Unable to read file
contents with resource ID "7c46f962-c98d-11dc-8e29-a99bc8653b57"
(online=false).
at org.opencms.db.generic.CmsProjectDriver.publishFile(CmsProjectDriver.java
:996)
at org.opencms.db.generic.CmsProjectDriver.publishProject(
CmsProjectDriver.java:1407)
... 2 more
Caused by: org.opencms.file.CmsVfsResourceNotFoundException: Unable to read
file contents with resource ID "7c46f962-c98d-11dc-8e29-a99bc8653b57"
(online=false).
at org.opencms.db.generic.CmsVfsDriver.readContent(CmsVfsDriver.java:1424)
at org.opencms.db.generic.CmsProjectDriver.publishFileContent(
CmsProjectDriver.java:1022)
at org.opencms.db.generic.CmsProjectDriver.publishNewFile(
CmsProjectDriver.java:2903)
at org.opencms.db.generic.CmsProjectDriver.publishFile(CmsProjectDriver.java
:952)
... 3 more
... the resources have been published
Writing export points ...
Writing export point
/system/modules/com.bearingpoint.opencms.commons.springmanager/classes/ ...
o.k.
 ******************************* *END ERROR*******************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20080123/0a633a6e/attachment.htm>
-------------- next part --------------

_______________________________________________
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


More information about the opencms-dev mailing list