Hi,
I'm trying to upgrading from Alfresco Comunity 2.1 to 3.3.
My database size is 90 Mb, and my repo size is 76 GB
Yesterday I started an Alfresco copy with 3.3 installation and withe a copy of repo and database, log show me:
17:06:21,219 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /opt/alfresco/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-7046270136065738344.sql (Copied from classpath:alfresco/dbscripts/upgrade/2.2/org.hibernate.dialect.MySQLInnoDBDialect/upgrade-0-create-missing-tables.sql).
17:06:21,489 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /opt/alfresco/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-6919328127734969314.sql (Copied from classpath:alfresco/dbscripts/upgrade/2.2/org.hibernate.dialect.MySQLInnoDBDialect/upgrade-from-2.1.sql).
And now, one day later, at 09:00 it didn't finish yet.
With mytop I can see next sentence is executing now (and yesterday last time I see the query):
EXPLAIN INSERT INTO t_alf_node_properties ( node_id, qname_id, locale_id, list_index, actual_type_n, persisted_type_n, boolean_value, long_value, float_value, double_value, string_value, serializable_value ) SELECT np.node_id, tqn.qname_id, 1, -1, ptypes_actual.type_id, ptypes_persisted.type_id, np.boolean_value, np.long_value, np.float_value, np.double_value, np.string_value, np.serializable_value FROM alf_node_properties np JOIN t_qnames tqn ON (np.qname = tqn.qname) JOIN t_prop_types ptypes_actual ON (ptypes_actual.type_name = np.actual_type) JOIN t_prop_types ptypes_persisted ON (ptypes_persisted.type_name = np.persisted_type) WHERE np.attribute_value IS NULL:
This is the line of mysql in top util:
2322 mysql 20 0 919m 459m 12m S 98.8 23.0 1094:36 mysqld
Should my mysql be customized for Alfresco upgrade ?
How can I know how many time will take Alfresco upgrade?
Any tip ?
Thanks !
