[opencms-dev] error importing OpenCms_Workflow2

[Vikrama Sanjeeva]

Just did and thought to reply for self question :-)

Actually added below in my.ini file and it worked. Restart MySQL.

max_allowed_packet=32M

Bye,
Viki.


On Jan 23, 2008 12:01 PM, Olivier Camus <olivier.camus at steria.com> wrote:

> Sorry, I didn't correctly read your message :
>
> Tried increasing size of " max_allowed_packet" to <19999744>, but no
> success.
>
> Which is the value of your parameter ?
>
> @+
>
> ------------------------------------------------------
> Olivier CAMUS  - olivier.camus at steria.fr
>
> Tel (CoE) : 03-90-21-45-12
>
>
> http://www.steria.fr
>
> STERIA - Parc club des Tanneries
> 2 rue de la Faisanderie
> BP 95 67380 LINGOLSHEIM
>
>
> 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*******************************
>
>
> _______________________________________________
> 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
>
>
> _______________________________________________
> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20080123/0a3d2f78/attachment.htm>