3.4 upgrade scripts failing

[jriker1]

Took my 3.3 instance and replaced with the new war files on Linux.  Starting implementing script upgrades and got a failure that hung things up.  See below:

18:03:32,105  INFO  [admin.patch.PatchExecuter]         Applying patch 'patch.migrateAttrChainingURS' (Migrate old Chaining User Registry Synchronizer attributes).
18:03:32,270  ERROR [admin.patch.PatchExecuter] 08300000 org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0];
— The error occurred in alfresco/ibatis/#resource.dialect#/patch-common-SqlMap.xml.
— The error occurred while applying a result map.
— Check the alfresco.patch.result_ChainingURS.
— Check the result mapping for the 'lastModified' property.
— Cause: org.springframework.jdbc.BadSqlGrammarException: SqlMapClient operation; bad SQL grammar []; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException: 
— The error occurred in alfresco/ibatis/#resource.dialect#/propval-common-SqlMap.xml.
— The error occurred while applying a parameter map.
— Check the alfresco.propval.select_PropertyValueByStringValue-InlineParameterMap.
— Check the statement (query failed).
— Cause: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'sv.string_end_lower' in 'where clause'; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
— The error occurred in alfresco/ibatis/#resource.dialect#/patch-common-SqlMap.xml.
— The error occurred while applying a result map.
— Check the alfresco.patch.result_ChainingURS.
— Check the result mapping for the 'lastModified' property.
— Cause: org.springframework.jdbc.BadSqlGrammarException: SqlMapClient operation; bad SQL grammar []; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException: 
— The error occurred in alfresco/ibatis/#resource.dialect#/propval-common-SqlMap.xml.
— The error occurred while applying a parameter map.
— Check the alfresco.propval.select_PropertyValueByStringValue-InlineParameterMap.
— Check the statement (query failed).
— Cause: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'sv.string_end_lower' in 'where clause'
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
        at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:203)
        at org.springframework.orm.ibatis.SqlMapClientTemplate.queryWithRowHandler(SqlMapClientTemplate.java:327)
        at org.springframework.orm.ibatis.SqlMapClientTemplate.queryWithRowHandler(SqlMapClientTemplate.java:320)
        at org.alfresco.repo.domain.patch.ibatis.PatchDAOImpl.getOldAttrChainingURSImpl(PatchDAOImpl.java:458)
        at org.alfresco.repo.domain.patch.AbstractPatchDAOImpl.migrateOldAttrChainingURS(AbstractPatchDAOImpl.java:255)
        at org.alfresco.repo.admin.patch.impl.MigrateAttrChainingURSPatch.applyInternal(MigrateAttrChainingURSPatch.java:64)
        at org.alfresco.repo.admin.patch.AbstractPatch$1$1.execute(AbstractPatch.java:415)
        at org.alfresco.repo.admin.patch.AbstractPatch$1$1.execute(AbstractPatch.java:409)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:325)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:232)
        at org.alfresco.repo.admin.patch.AbstractPatch$1.doWork(AbstractPatch.java:441)
        at org.alfresco.repo.admin.patch.AbstractPatch$1.doWork(AbstractPatch.java:405)
        at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:508)
        at org.alfresco.repo.admin.patch.AbstractPatch.apply(AbstractPatch.java:445)
        at org.alfresco.repo.admin.patch.PatchServiceImpl.applyPatch(PatchServiceImpl.java:297)
        at org.alfresco.repo.admin.patch.PatchServiceImpl.access$200(PatchServiceImpl.java:50)
        at org.alfresco.repo.admin.patch.PatchServiceImpl$2.execute(PatchServiceImpl.java:226)
        at org.alfresco.repo.admin.patch.PatchServiceImpl$2.execute(PatchServiceImpl.java:223)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:325)
        at org.alfresco.repo.admin.patch.PatchServiceImpl.applyPatchAndDependencies(PatchServiceImpl.java:229)
        at org.alfresco.repo.admin.patch.PatchServiceImpl.applyOutstandingPatches(PatchServiceImpl.java:163)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Can provide more info if needed.  Not sure if this is something that anyone knows what's going on.  This is from the catalina.out file.

Thanks.

JR

[jriker1]

I also tried the latest code out there but no joy.  Also tried updating the mysql connector but same deal.  Created a JIRA ticket.  Has anyone else upgraded and have the before mentioned error?

Thanks.

JR

[loftux]

What database (including version) are you running?
Whats the default character set of your db?
What are your settings in alfresco-global.properties (those related to database)?

[jriker1]

What database (including version) are you running?
Whats the default character set of your db?
What are your settings in alfresco-global.properties (those related to database)?

I am running MySQL 5.0.67 on OpenSuse.
I believe the default character set is Latin-1 however DB for Alfresco is UTF-8.

My global's relative to the DB are:

db.name=alfresco
db.username=alfresco
db.password=<my pass>
db.host=<server name>
db.port=3306
db.driver=org.gjt.mm.mysql.Driver
db.url=jdbc:mysql://${db.host}:${db.port}/${db.name}?useUnicode=true&characterEncoding=utf-8
hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect
index.recovery.mode=AUTO

[jriker1]

I think the only thing that concerned me on the above with the DB connection is Alfresco said they stopped using Hibernate however I'm using Hibernate for the DB connection.  If that isn't used anymore there is no 3.4 documentation on what should be used now.

Thanks.

JR

[loftux]

That looks ok,

Only thing I can think of is to do a mysqldump with the –no-data option of your current database, and then do a clean install of Alfresco with the same version as your current install. Do a mysqldump with –no-data of that db, then do a diff to see if you can find anything.

[jriker1]

The way I see it there has to be some kind of bug.  The below piece of log data for example:

18:03:32,270  ERROR [admin.patch.PatchExecuter] 08300000 org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0];
— The error occurred in alfresco/ibatis/#resource.dialect#/patch-common-SqlMap.xml.
— The error occurred while applying a result map.
— Check the alfresco.patch.result_ChainingURS.
— Check the result mapping for the 'lastModified' property.

So it's referring to the result_ChainingURS of the above XML file.  It also shows that a null was returned if I'm looking at this right and from the lastModified property.  If I run the query that pulls the data from the DB for ChainingURS I do get a string of a date value out of the database.  It's not blank or null.

JR