topic Upgrade Alfresco 2.0.0 to 3 Labs Stable in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/upgrade-alfresco-2-0-0-to-3-labs-stable/m-p/195847#M148977 <HTML><HEAD></HEAD><BODY><SPAN>Hi everybody,</SPAN><BR /><BR /><SPAN>I am currently trying to upgrade from Alfresco community 2.0.0 to Alfresco 3 Labs.</SPAN><BR /><SPAN>I read and followed articles from alfresco wiki : </SPAN><A href="http://wiki.alfresco.com/wiki/General_Upgrade_Process" rel="nofollow noopener noreferrer">http://wiki.alfresco.com/wiki/General_Upgrade_Process</A><SPAN> but problems occured. Here is what I did and where I stuck.</SPAN><BR /><BR /><SPAN>Environment : </SPAN><BR /><SPAN>&nbsp; - Centos</SPAN><BR /><SPAN>&nbsp; - Mysql 5</SPAN><BR /><SPAN>&nbsp; - JBoss 4.0.5.GA</SPAN><BR /><SPAN>&nbsp; - Alfresco 2.0.0 - no plugin installed</SPAN><BR /><SPAN>&nbsp; - Quite big repository (~ 60Go)</SPAN><BR /><BR /><SPAN>First, I tried to upgrade from 2.0.0 :</SPAN><BR /><SPAN>&nbsp; - Cold backup (data + sql dump)</SPAN><BR /><SPAN>&nbsp; - Alfresco war upgrade to 3 Labs</SPAN><BR /><SPAN>&nbsp; - Changing </SPAN><STRONG>index.recovery.mode</STRONG><SPAN> to </SPAN><STRONG>FULL</STRONG><SPAN> and </SPAN><STRONG>db.schema.update</STRONG><SPAN> to </SPAN><STRONG>true</STRONG><BR /><SPAN>&nbsp; - Restarting JBoss and waiting</SPAN><BR /><SPAN>&nbsp; - Upgrade failed with the following error :</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />17:50:41,935 INFO&nbsp; [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /tmp/Alfresco/AlfrescoSchemaUpdate-org.hibernate.dialect.MySQLInnoDBDialect-26168.sql (Copied from classpath:alfresco/dbscripts/upgrade/2.1/org.hibernate.dialect.MySQLInnoDBDialect/AlfrescoSchemaUpdate-2.1-NotNullColumns.sql).<BR />17:50:41,938 INFO&nbsp; [org.hibernate.dialect.Dialect] Using dialect: org.hibernate.dialect.MySQLInnoDBDialect<BR />17:50:41,939 INFO&nbsp; [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /tmp/Alfresco/AlfrescoSchemaUpdate-org.hibernate.dialect.MySQLInnoDBDialect-26169.sql (Copied from classpath:alfresco/dbscripts/upgrade/2.2/org.hibernate.dialect.MySQLInnoDBDialect/AlfrescoSchemaUpdate-2.2-ACL.sql).<BR />17:50:42,470 INFO&nbsp; [org.hibernate.dialect.Dialect] Using dialect: org.hibernate.dialect.MySQLInnoDBDialect<BR />17:50:42,472 INFO&nbsp; [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /tmp/Alfresco/AlfrescoSchemaUpdate-org.hibernate.dialect.MySQLInnoDBDialect-26170.sql (Copied from classpath:alfresco/dbscripts/upgrade/2.2/org.hibernate.dialect.MySQLInnoDBDialect/upgrade-0-create-missing-tables.sql).<BR />17:50:42,517 INFO&nbsp; [org.hibernate.dialect.Dialect] Using dialect: org.hibernate.dialect.MySQLInnoDBDialect<BR />17:50:42,519 INFO&nbsp; [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /tmp/Alfresco/AlfrescoSchemaUpdate-org.hibernate.dialect.MySQLInnoDBDialect-26171.sql (Copied from classpath:alfresco/dbscripts/upgrade/2.2/org.hibernate.dialect.MySQLInnoDBDialect/upgrade-from-2.1.sql).<BR />20:58:00,689 ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] Statement execution failed:<BR />&nbsp;&nbsp; SQL: INSERT INTO alf_locale (locale_str)<BR />&nbsp;&nbsp; SELECT DISTINCT(ma.mkey)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FROM alf_node_properties np<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; JOIN alf_attributes a1 ON (np.attribute_value = a1.id)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; JOIN alf_map_attribute_entries ma ON (ma.map_id = a1.id)<BR /><BR />&nbsp;&nbsp; Error: Table 'alfresco.alf_attributes' doesn't exist<BR />&nbsp;&nbsp; File: /tmp/Alfresco/AlfrescoSchemaUpdate-org.hibernate.dialect.MySQLInnoDBDialect-26171.sql<BR />&nbsp;&nbsp; Line: 735<BR />20:58:00,691 ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema auto-update failed<BR />com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'alfresco.alf_attributes' doesn't exist<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2941)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1623)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1715)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.Connection.execSQL(Connection.java:3243)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.Connection.execSQL(Connection.java:3172)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.Statement.execute(Statement.java:706)<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>I thought there is a big gap between alfresco 2.0.0 and alfresco 3 so I also tried to upgrade from 2.0.0 to 2.9.0 and from 2.9.0 to 3 Labs Stable :</SPAN><BR /><SPAN>&nbsp; - Restoring cold backup to 2.0.0 and restarting JBoss to check if everything is ok and stopping JBoss</SPAN><BR /><SPAN>&nbsp; - Upgrading Alfresco war to 2.9.0</SPAN><BR /><SPAN>&nbsp; - Changing </SPAN><STRONG>index.recovery.mode</STRONG><SPAN> to </SPAN><STRONG>FULL</STRONG><SPAN> and </SPAN><STRONG>db.schema.update</STRONG><SPAN> to </SPAN><STRONG>true</STRONG><BR /><SPAN>&nbsp; - Starting JBoss</SPAN><BR /><SPAN>&nbsp; - Upgrade successfull (not so long, 10 - 20 min)</SPAN><BR /><BR /><SPAN>Upgrade finish successfully with a message that say Alfresco version is 2.9.0 and schema is 2.0.0, is it normal ?</SPAN><BR /><SPAN>Anyway, I continue with upgrading to Alfresco Labs 3 Stable :</SPAN><BR /><SPAN>&nbsp; - Upgrading war to 3 Labs Stable</SPAN><BR /><SPAN>&nbsp; - Changing </SPAN><STRONG>index.recovery.mode</STRONG><SPAN> to </SPAN><STRONG>FULL</STRONG><SPAN> and </SPAN><STRONG>db.schema.update</STRONG><SPAN> to </SPAN><STRONG>true</STRONG><BR /><SPAN>&nbsp; - Starting JBoss</SPAN><BR /><SPAN>&nbsp; - After 12 hours, it failed with error :</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />16:38:34,557 INFO&nbsp; [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /tmp/Alfresco/Alfresco<BR />SchemaUpdate-org.hibernate.dialect.MySQLInnoDBDialect-42924.sql (Copied from classpath:alfresco/dbscripts/upgrade/2.2<BR />/org.hibernate.dialect.MySQLInnoDBDialect/AlfrescoSchemaUpdate-2.2-ACL.sql).<BR />16:38:34,918 INFO&nbsp; [org.hibernate.dialect.Dialect] Using dialect: org.hibernate.dialect.MySQLInnoDBDialect<BR />16:38:34,920 INFO&nbsp; [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /tmp/Alfresco/Alfresco<BR />SchemaUpdate-org.hibernate.dialect.MySQLInnoDBDialect-42925.sql (Copied from classpath:alfresco/dbscripts/upgrade/2.2<BR />/org.hibernate.dialect.MySQLInnoDBDialect/upgrade-0-create-missing-tables.sql).<BR />16:38:34,945 INFO&nbsp; [org.hibernate.dialect.Dialect] Using dialect: org.hibernate.dialect.MySQLInnoDBDialect<BR />16:38:34,947 INFO&nbsp; [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /tmp/Alfresco/Alfresco<BR />SchemaUpdate-org.hibernate.dialect.MySQLInnoDBDialect-42926.sql (Copied from classpath:alfresco/dbscripts/upgrade/2.2<BR />/org.hibernate.dialect.MySQLInnoDBDialect/upgrade-from-2.1.sql).<BR />11:35:14,035 ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] Statement execution failed:<BR />&nbsp;&nbsp; SQL: INSERT INTO t_alf_node_properties<BR />&nbsp;&nbsp; (<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; node_id, qname_id, locale_id, list_index,<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; actual_type_n, persisted_type_n,<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; boolean_value, long_value, float_value, double_value,<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; string_value,<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; serializable_value<BR />&nbsp;&nbsp; )<BR />&nbsp;&nbsp; SELECT<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; np.node_id, tqn.qname_id, 1, -1,<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ptypes_actual.type_id, ptypes_persisted.type_id,<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; np.boolean_value, np.long_value, np.float_value, np.double_value,<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; np.string_value,<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; np.serializable_value<BR />&nbsp;&nbsp; FROM<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; alf_node_properties np<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; JOIN t_qnames tqn ON (np.qname = tqn.qname)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; JOIN t_prop_types ptypes_actual ON (ptypes_actual.type_name = np.actual_type)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; JOIN t_prop_types ptypes_persisted ON (ptypes_persisted.type_name = np.persisted_type)<BR />&nbsp;&nbsp; WHERE<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; np.attribute_value IS NULL<BR /><BR />&nbsp;&nbsp; Error: Data truncation: Data too long for column 'string_value' at row 2445<BR />&nbsp;&nbsp; File: /tmp/Alfresco/AlfrescoSchemaUpdate-org.hibernate.dialect.MySQLInnoDBDialect-42926.sql<BR />&nbsp;&nbsp; Line: 793<BR />11:35:14,036 ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema auto-update failed<BR />com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'string_value' at row 2445<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2939)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1623)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1715)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.Connection.execSQL(Connection.java:3243)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.Connection.execSQL(Connection.java:3172)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.Statement.execute(Statement.java:706)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.domain.schema.SchemaBootstrap.executeStatement(SchemaBootstrap.java:944)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.domain.schema.SchemaBootstrap.executeScriptFile(SchemaBootstrap.java:913)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.domain.schema.SchemaBootstrap.executeScriptUrl(SchemaBootstrap.java:768)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.domain.schema.SchemaBootstrap.checkSchemaPatchScripts(SchemaBootstrap.java:739)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBootstrap.java:641)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1123)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaste<BR />r.java:77)<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>I check this field in DB, it is of type </SPAN><EM>text</EM><SPAN>. So it should not be too short …</SPAN><BR /><SPAN>I googled around and saw some versions of mysql (5.0.x) can failed with this error when inserting a special char (like ç, à, ù, etc …) with some encoding.</SPAN><BR /><BR /><SPAN>I was in latin1 when it failed. So, I restart the whole process in utf-8 and it failed with the same error.</SPAN><BR /><BR /><SPAN>Is somebody have an idea on how I can upgrade from Alfresco 2.0.0 to Alfresco 3 Labs with a 60Go repository ?</SPAN><BR /><BR /><SPAN>Thanks,</SPAN><BR /><SPAN>NMaupu</SPAN></BODY></HTML> Thu, 05 Mar 2009 09:54:57 GMT nmaupu 2009-03-05T09:54:57Z Upgrade Alfresco 2.0.0 to 3 Labs Stable https://connect.hyland.com/t5/alfresco-archive/upgrade-alfresco-2-0-0-to-3-labs-stable/m-p/195847#M148977 Hi everybody,I am currently trying to upgrade from Alfresco community 2.0.0 to Alfresco 3 Labs.I read and followed articles from alfresco wiki : http://wiki.alfresco.com/wiki/General_Upgrade_Process but problems occured. Here is what I did and where I stuck.Environment : &nbsp; - Centos&nbsp; - Mysql 5&nbsp; - JBo Thu, 05 Mar 2009 09:54:57 GMT https://connect.hyland.com/t5/alfresco-archive/upgrade-alfresco-2-0-0-to-3-labs-stable/m-p/195847#M148977 nmaupu 2009-03-05T09:54:57Z Re: Upgrade Alfresco 2.0.0 to 3 Labs Stable https://connect.hyland.com/t5/alfresco-archive/upgrade-alfresco-2-0-0-to-3-labs-stable/m-p/195848#M148978 <HTML><HEAD></HEAD><BODY><SPAN>Hello,</SPAN><BR /><SPAN>did you have any luck with this?&nbsp; I am having the same problems and have spent a long time (1 week) attempting to get this to work…</SPAN><BR /><BR /><SPAN>cheers</SPAN><BR /><SPAN>Damien</SPAN></BODY></HTML> Mon, 18 May 2009 00:11:19 GMT https://connect.hyland.com/t5/alfresco-archive/upgrade-alfresco-2-0-0-to-3-labs-stable/m-p/195848#M148978 dsandy 2009-05-18T00:11:19Z