AlfrescoLabs 3c fails in ADMLuceneIndexerImpl [SOLVED]

[samuel_penn]

Hi all,

I've downloaded and installed the WAR version of Alfrescolabs 3c, and have tried installing it in Tomcat 5, running on Gentoo Linux with JDK 1.5, but I'm having some problems.

On startup for the first time, I get the following errors:

16:30:02,853  ERROR [util.exec.RuntimeExecBootstrapBean] Bootstrap command failed:
Execution result:
   os:         Linux
   command:    "soffice" "-accept=socket,host=localhost,port=8100;urp;StarOffice.ServiceManager" "-env:UserInstallation=file://oouser" -nologo -headless -nofirststartwizard -nocrashrep -norestore
   succeeded:  false
   exit code:  2
   out:
   err:        java.io.IOException: "soffice": not found
16:30:04,423 User:System ERROR [web.context.ContextLoader] Context initialization failed
java.lang.NullPointerException
        at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.createDocuments(ADMLuceneIndexerImpl.java:709)
        at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerImpl.indexImpl(AbstractLuceneIndexerImpl.java:632)
        at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerImpl.indexImpl(AbstractLuceneIndexerImpl.java:657)
        at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerImpl.flushPending(AbstractLuceneIndexerImpl.java:789)
        at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.doPrepare(ADMLuceneIndexerImpl.java:1438)
        at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerImpl.prepare(AbstractLuceneIndexerImpl.java:472)
        at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerAndSearcherFactory.prepare(AbstractLuceneIndexerAndSearcherFactory.java:754)
        at org.alfresco.repo.transaction.AlfrescoTransactionSupport$TransactionSynchronizationImpl.beforeCommit(AlfrescoTransactionSupport.java:661)
        at org.springframework.transaction.support.TransactionSynchronizationUtils.triggerBeforeCommit(TransactionSynchronizationUtils.java:48)
        at org.springframework.transaction.support.AbstractPlatformTransactionManager.triggerBeforeCommit(AbstractPlatformTransactionManager.java:835)
        at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:645)
        at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:632)
        at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:314)
        at org.alfresco.util.transaction.SpringAwareUserTransaction.commit(SpringAwareUserTransaction.java:431)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:308)
        at org.alfresco.repo.descriptor.DescriptorServiceImpl.onBootstrap(DescriptorServiceImpl.java:223)
        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)
        at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)
        at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:246)
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:355)
        at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:244)
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:187)
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3827)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4343)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:823)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:807)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:595)
        at org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.java:277)
        at org.apache.catalina.core.StandardHost.install(StandardHost.java:832)
        at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:617)
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:431)
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:968)
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:349)
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1091)
        at org.apache.catalina.core.StandardHost.start(StandardHost.java:789)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1083)
        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:478)
        at org.apache.catalina.core.StandardService.start(StandardService.java:480)
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:2313)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:556)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:284)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:422)
Dec 18, 2008 4:30:04 PM org.apache.catalina.core.StandardContext start
SEVERE: Error listenerStart
Dec 18, 2008 4:30:04 PM org.apache.catalina.core.StandardContext start
SEVERE: Context startup failed due to previous errors
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

I'm assuming that the openoffice error can be ignored (I don't need OO), but I've included it anyway. Alfresco is initialising the MySQL database (I can see that all the tables have been created), and it has created folders in the data directory (/opt/alfresco-data in my case). However, it fails at the above step.

Note that this is a clean installation of Alfresco, the only configuration I've done is to point it at MySQL (on a different machine) and configure the data directory. I've copied the contents of the extensions directory from the installation tgz to /opt/tomcat5/shared/classes/alfresco, and have copied alfresco.war into /opt/tomcat5/webapps.

I haven't done anything with the contents of the endorsed directory (the jars already seem to be in /opt/tomcat5/common/endorsed, with the same file sizes) or the share.war (I'm not planning on using share).

FWIW, I've got the full standalone install working okay (enough to confirm that WCM in Linux is finally fixed, yay!), but don't really have the capacity to run yet another tomcat instance.

Thanks,
Sam.

[samuel_penn]

I'm still having issues with this, despite having tried some fresh re-installations of Alfresco.

I have also tried switching on lucene debugging options, which doesn't appear to show much of interest, though does find some invalid files (at least, the debug displays "invalid = true" on the 2nd line shown below). Since this is all debug, I assume it's pretty normal behaviour however.

13:15:34,361  DEBUG [lucene.index.IndexInfo] Expunging e00f9e9d-876c-426d-ab3f-5f5bb4cb3346 remaining 1
13:15:34,361  DEBUG [lucene.index.IndexInfo] … Id = e00f9e9d-876c-426d-ab3f-5f5bb4cb3346 Invalid = 0 invalid = true closed=true
13:15:34,362 User:System DEBUG [lucene.index.IndexInfo] RELEASED READ LOCK  - main
13:15:34,378 User:System DEBUG [lucene.index.IndexInfo] Got /opt/alfresco-data/lucene-indexes/system/system org.alfresco.repo.search.impl.lucene.index.IndexInfo@269133 for /opt/alfresco-data/lucene-indexes/system/system
‍‍‍‍‍‍

Has anyone got Alfresco 3c working in a shared Tomcat environment? If so, did you do anything other than what is listed on the following wiki page:

http://wiki.alfresco.com/wiki/Install_Shared_Tomcat

Thanks,
Sam.

[zaizi]

Following the instructions at

http://wiki.alfresco.com/wiki/Install_Shared_Tomcat

got Alfresco up and running no problems. What else do you have installed in your Tomcat installation?

[samuel_penn]

What else do you have installed in your Tomcat installation?

About half a dozen small webapps of my own, nothing particularly intrusive. They all use MySQL, but that's about it.

Did you do anything with the libmysqltcl.so in the extras? Is it needed?

Sam.

[zaizi]

Quick steps;

1. Untar tomcat.
2. Untar alfresco 3c war.
3. Copy alfresco.war to webapps.
4. Copy the following from extensions folder: custom-hibernate-dialetc.properties, custom-repository-context.xml, custom-repository.properties to shared/classes/alfresco/extension. Edit as required.
5. Double check permissions for alf_data directory.
6. Copy mysql jar to tomcat/common/lib.
7. Copy over endorsed directory to tomcat/common/endorsed.
8. Export CATALINA_OPTS="-server".
9. Start it up.

Try undeploying all your small apps and see if it works. Then deploy the small apps one at a time.

[samuel_penn]

Installing it into a fresh installation of Tomcat fixed the problem, but probably not in the way you think… The new installation actually failed completely to talk to the database, giving nothing but connection errors (same machine, same user, same database as before). Whilst troubleshooting that, I realised that I was using version 3 of the MySQL connector, rather than the version 5 recommended by Alfresco.

Switching to version 5 didn't fix the new install (it still doesn't work, but I'm blaming that for now on the complete mess Gentoo has made of the file system layout for Tomcat 5.5/6), but it did fix the old installation.

So thanks for the suggestions.

Sam.