AnsweredAssumed Answered

Alfresco database upgrade failure

Question asked by bsubramanian on Oct 15, 2008
Latest reply on Nov 10, 2008 by toltech
Hi There

We are upgrading alfresco 2.1.2 (Enterprise edition) to 2.2.1 (Enterprise edition) in our development suite running on RHEL 5 with MYSQL database and Jboss 4.2.1. The process we followed was.

1.   Stopped the old alfresco instance running
2.   Backed up the old mysql database using mysqldump command.
3.   Took the backup of alf_data folder along with database dump
4.   Created a new instance of Jboss App server
5.   Deployed the new alfresco.war into deploy folder
6.   Updated the custom-repository.properties, custom-hibernate-dialect.properties, ldap-authentication.properties

       The update in custom-repository.properties  is as follows

dir.root=/home/OSATPortal/jboss-4.2.1.GA/bin/alfresco_2.2.1/alf_data
dir.indexes=/home/OSATPortal/jboss-4.2.1.GA/bin/alfresco_2.2.1/alf_data/lucene-indexes
index.recovery.mode=VALIDATE
db.schema.update=true
db.username=alfresco
db.password=alfresco
db.pool.initial=10
db.pool.max=100
db.driver=com.mysql.jdbc.Driver
db.url=jdbc:mysql://localhost/alfresco

7.   Restored the alf_data from backup (I wanted to retain the old alf_data folder as is which existed in ‘/home/OSATPortal/jboss-4.2.1.GA/bin/alf_data’
8.   Started the Jboss instance.

It finds the db dialect “23:10:17,004 INFO  [STDOUT] 23:10:17,003 INFO  [domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.”

And waits for a few moments and the throw the ERROR

“23:12:20,149 INFO  [STDOUT] 23:12:20,135 ERROR [domain.schema.SchemaBootstrap] Schema auto-update failed
org.alfresco.error.AlfrescoRuntimeException: A previous schema upgrade failed or was not completed.  Revert to the original database before attempting the upgrade again.
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1008)
   at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)
   at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)
   at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)”

In one of the forum posts I saw that the reason for this issue could be the space constraint (http://forums.alfresco.com/en/viewtopic.php?f=8&t=13936&p=46277). Even after emptying some memory I am facing the same issue.  Am I missing any steps? I am attaching the log file for your reference.


At present memory statistics in this machine is as follows.

[root@localhost ~]# free -m
          total       used       free     shared    buffers     cached
Mem:          1391       1348         43          0         34        600
-/+ buffers/cache:        712        678
Swap:         3071          0       3071


[root@localhost ~]# free -b
             total          used          free          shared    buffers     cached
Mem:    1458696192    1413660672   45035520          0      36806656  629583872
-/+ buffers/cache:  747270144  711426048
Swap:   3221168128     110592 3221057536



Thanks
Bala

Outcomes