topic Re: Exception on Startup in Alfresco Archive

Exception on Startup

nyronian — Thu, 24 Apr 2008 23:12:08 GMT

I am trying to copy an existing system (database and alf_data) to another installation with the exact same configuration. After doing so I get the below exception on startup. (alfresco.log)Does anyone know what this would be?? Does this mean the data from the DB copy was corrupted? Is there a sp

Re: Exception on Startup

sdavis — Fri, 25 Apr 2008 07:21:05 GMT

Two questions:

1) On the new install, did it startup fine before performing the restore?

2) On the old install, did you follow the steps at http://wiki.alfresco.com/wiki/Backup_and_Restore?

Re: Exception on Startup

nyronian — Mon, 05 May 2008 20:19:36 GMT

arrgh…I did not see the response….need to set my notification right….

Thank you so much for the response….

1. I have an instance of Alfresco that starts fine. I restore the dir.root and the alfresco database and get the exception. I can't seem to get around it.

2. I followed the "Cold Backup" procedures.

I am assuming from the exception that it cannot "deserialize" some Alfresco object from the MySQL database that is getting corrupted on import of the database. Is there "encoding" issue I am missing. It does not specify any special setting or options for mysqldump in the Backup/Restore document.

One note is that I am moving the data from a linux machine to a windows vista machine….could this affect anything?

Any thoughts?

On a side note….I am getting in hotter and hotter water. We have been using Alfresco for about 6 months now and I have yet to get a Backup/Restore to work. I've no idea why this is happening. Now I have a new machine I am trying to bring up and cannot. I have brushed it off thinking there must be thousands doing this every day, I am just missing something simple.

Re: Exception on Startup

nyronian — Mon, 05 May 2008 20:53:05 GMT

Looking at the exception further it's as if a spring configuration file is corrupt. (corruption deserializing a file) and it appears to be around the loading of the spring context.

What is odd, is I can delete the repository, empty the alfresco DB and have it reload from scratch. Everything is fine.

I then replace the repository with the backup of dir.root and alfresco and BAM. So I don't see how it could be a spring file that is getting corrupted. Unless there is something in the DB or stored in dir.root I am not aware of.

Re: Exception on Startup

nyronian — Mon, 05 May 2008 21:15:11 GMT

I turned on detailed debugging and received the following debug lines near the error:

14:37:06,583 DEBUG [sf.ehcache.Cache] org.alfresco.repo.domain.hibernate.NodeImpl cache - Miss
14:37:06,584 DEBUG [ehcache.store.MemoryStore] org.alfresco.repo.domain.hibernate.NodeStatusImplCache: org.alfresco.repo
.domain.hibernate.NodeStatusImplMemoryStore miss for org.alfresco.repo.domain.hibernate.NodeStatusImpl#NodeKey[ id=3bd4f
938-61ff-11dc-99f6-7db49849fce3, protocol=system, identifier=system]
14:37:06,587 DEBUG [sf.ehcache.Cache] org.alfresco.repo.domain.hibernate.NodeStatusImpl cache - Miss
14:37:06,588 DEBUG [ehcache.store.MemoryStore] org.alfresco.repo.domain.hibernate.NodeImpl.aspectsCache: org.alfresco.re
po.domain.hibernate.NodeImpl.aspectsMemoryStore miss for org.alfresco.repo.domain.hibernate.NodeImpl.aspects#8
14:37:06,590 DEBUG [sf.ehcache.Cache] org.alfresco.repo.domain.hibernate.NodeImpl.aspects cache - Miss
14:37:06,597 DEBUG [ehcache.store.MemoryStore] org.alfresco.repo.domain.hibernate.NodeImpl.propertiesCache: org.alfresco
.repo.domain.hibernate.NodeImpl.propertiesMemoryStore miss for org.alfresco.repo.domain.hibernate.NodeImpl.properties#8
14:37:06,599 DEBUG [sf.ehcache.Cache] org.alfresco.repo.domain.hibernate.NodeImpl.properties cache - Miss
14:37:06,609 ERROR [web.context.ContextLoader] Context initialization failed
org.hibernate.type.SerializationException: could not deserialize
        at org.hibernate.util.SerializationHelper.deserialize(SerializationHelper.java:217)
        at org.hibernate.util.SerializationHelper.deserialize(SerializationHelper.java:240)
        at org.hibernate.type.SerializableType.fromBytes(SerializableType.java:82)
        at org.hibernate.type.SerializableType.get(SerializableType.java:39)
        at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:113)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

I found node '3bd4f938-61ff-11dc-99f6-7db49849fce3' in alf_node and then alf_node_properties, if that is indeed the faulty node. The node does have a serializable BLOB as a property of qname 'versionEdition' in the alfresco system namespace. I am assuming that is the faulty value.

I will do some work around this. Maybe the way I am importing it, it is a problem.

Re: Exception on Startup

nyronian — Mon, 05 May 2008 21:30:41 GMT

Ok, I am going to have a hundred posts on here but, I figure the more info that is available the better.

I have tracked down the import of the actual node properties sql. It is below:

INSERT INTO `alf_node_properties` VALUES (8,'SERIALIZABLE',' ','SERIALIZABLE','\0',0,0,0,NULL,NULL,'ï¿½ï¿½\0 sr\0 java.util.ArrayListxï¿½ï¿½ ï¿½ï¿½aï¿½ \0 I\0 sizexp\0\0\0 w \0\0\0 t\0 Community Networkx','{http://www.alfresco.org/model/system/1.0}versionEdition'),
(8,'STRING','\0','STRING','\0',0,0,0,'',NULL,NULL,'{http://www.alfresco.org/model/system/1.0}versionLabel'),
(8,'STRING','\0','STRING','\0',0,0,0,'2',NULL,NULL,'{http://www.alfresco.org/model/system/1.0}versionMajor'),
(8,'STRING','\0','STRING','\0',0,0,0,'1',NULL,NULL,'{http://www.alfresco.org/model/system/1.0}versionMinor'),
(8,'CONTENT','\0','STRING','\0',0,0,0,'contentUrl=store://2007/9/13/7/42/3bdff5bd-61ff-11dc-99f6-7db49849fce3.bin|mimetype=text/plain|size=273|encoding=UTF8|locale=en_US_',NULL,NULL,'{http://www.alfresco.org/model/system/1.0}versionProperties'),(8,'STRING','\0','STRING','\0',0,0,0,'0',NULL,NULL,'{http://www.alfresco.org/model/system/1.0}versionRevision'),
(8,'LONG','\0','LONG','\0',64,0,0,NULL,NULL,NULL,'{http://www.alfresco.org/model/system/1.0}versionSchema'),
‍‍‍‍‍‍‍

Note the serializable column. Any ideas on why it would be corrupt. This is the direction I am working.

Re: Exception on Startup

nyronian — Mon, 05 May 2008 22:15:22 GMT

Do I need to use the following option to turn blobs into hex chars:

mysqldump –hex-blob

maybe that is what is missing?

Re: Exception on Startup

nyronian — Mon, 05 May 2008 23:42:02 GMT

Ok…I think I answered my own question. It does require the hex option.

I am doing some more testing but I am certain that is it.