[
https://issues.apache.org/jira/browse/MRM-1881?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14487070#comment-14487070
]
Sorin Sbarnea commented on MRM-1881:
------------------------------------
[~skygo] I configured a cleanup script in order to be able to provide you clean
test results. I am trying now with different database settings, it seems that
the problem is related to the defaultTransactionIsolaction which was missing
from the config, the config does not allow text values, and the first two
values I tried didnt work (0 and 2). What happens now is that it starts but
when I get to the login screen and do admin password reset I get exceptions
regarding failed transactions. I will be back in few minutes with more
information.
> Release 2.2.0 does not work with PostgreSQL
> -------------------------------------------
>
> Key: MRM-1881
> URL: https://issues.apache.org/jira/browse/MRM-1881
> Project: Archiva
> Issue Type: Bug
> Components: Documentation, system
> Affects Versions: 2.2.0
> Environment: oracle-java-1.8, ubuntu-12.04-lts
> Reporter: Sorin Sbarnea
> Priority: Critical
> Labels: postgresql
> Attachments: logs.tar.gz
>
>
> It seems that support for PostgreSQL is broken and mostly undocumented.
> There a few things that need to be addressed:
> * Include PostgreSQL ODBC driver in the build, no need to keep it outside
> only to make the installation harder.
> * Include commented out PostreSQL database configuration inside
> /conf/jetty.conf including
> {noformat}
> <New id="users" class="org.eclipse.jetty.plus.jndi.Resource">
> <Arg>jdbc/users</Arg>
> <Arg>
> <New class="org.apache.tomcat.jdbc.pool.DataSource">
> <Set name="driverClassName">org.postgresql.Driver</Set>
> <Set name="url">jdbc:postgresql://localhost/archiva</Set>
> <Set name="name">ArchivaApp</Set>
> <Set name="username">archiva</Set>
> <Set name="password">archivasecret</Set>
> <!-- depends on your concurrent users numbers -->
> <Set name="maxWait">10000</Set>
> <Set name="removeAbandonedTimeout">10000</Set>
> <Set name="maxActive">30</Set>
> <Set name="initialSize">15</Set>
> <Set name="removeAbandoned">true</Set>
> <Set name="logAbandoned">true</Set>
> <Set name="testOnBorrow">true</Set>
> <!-- very rigourous sql query validation -->
> <Set name="validationQuery">select 1</Set>
> <Set name="testOnReturn">false</Set>
> <!--<Set name="defaultTransactionIsolation">READ_COMMITTED</Set>-->
> </New>
> </Arg>
> </New>
> {noformat}
> Also even with these changes being made it seems that Archiva is not properly
> initialized. The database tables are created with the default admin account
> but we cannot validate the admin account (email confirmation fails). We will
> attach the logs.
> Here are few excerpts from the logs:
> {noformat}
> INFO | jvm 1 | 2015/04/07 17:34:15 | 2015-04-07
> 17:34:15.209:WARN:oejw.WebAppContext:Failed startup of context
> o.e.j.w.WebAppContext{/,file:/opt/archiva/apps/archiva/},/opt/archiva/apps/archiva
> INFO | jvm 1 | 2015/04/07 17:34:15 |
> org.springframework.beans.factory.BeanCreationException: Error creating bean
> with name 'archivaServices': Cannot resolve reference to bean
> 'authenticationInterceptor
> INFO | jvm 1 | 2015/04/07 17:34:15 | at
> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:359)
> INFO | jvm 1 | 2015/04/07 17:34:15 | at
> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
> INFO | jvm 1 | 2015/04/07 17:34:15 | at
> java.lang.Thread.run(Thread.java:745)
> INFO | jvm 1 | 2015/04/07 17:34:15 | Caused by:
> INFO | jvm 1 | 2015/04/07 17:34:15 |
> org.springframework.beans.factory.BeanCreationException: Error creating bean
> with name 'authenticationInterceptor#rest': Injection of autowired
> dependencies failed;
> INFO | jvm 1 | 2015/04/07 17:34:15 | at
> org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:334)
> 2015-04-07 17:34:13,313 [WrapperSimpleAppMain] INFO
> org.apache.archiva.web.security.ArchivaRbacManager [] - use rbacManagerIds:
> '[jdo]'
> 2015-04-07 17:34:13,452 [WrapperSimpleAppMain] WARN JPOX.Plugin [] -
> Extension Point "org.eclipse.jdt.apt.core.annotationProcessorFactory" not
> registered, but plugin "" defined in jar:file:/opt/archiva/apps
> /archiva/WEB-INF/lib/org.eclipse.sisu.inject-0.0.0.M2a.jar!/plugin.xml refers
> to it.
> 2015-04-07 17:34:13,471 [WrapperSimpleAppMain] WARN JPOX.Plugin [] -
> Extension Point "org.eclipse.jdt.apt.core.annotationProcessorFactory" not
> registered, but plugin "" defined in jar:file:/opt/archiva/apps
> /archiva/WEB-INF/lib/org.eclipse.sisu.inject-0.0.0.M2a.jar!/plugin.xml refers
> to it.
> 2015-04-07 17:34:13,660 [WrapperSimpleAppMain] INFO
> org.apache.archiva.redback.role.DefaultRoleManager [] - loading System
> 2015-04-07 17:34:14,867 [WrapperSimpleAppMain] INFO
> org.apache.archiva.redback.role.processor.DefaultRoleModelProcessor [] - time
> to process roles model: 191 ms
> 2015-04-07 17:34:14,873 [WrapperSimpleAppMain] INFO
> org.apache.archiva.redback.role.DefaultRoleManager [] - loading Archiva
> 2015-04-07 17:34:15,129 [WrapperSimpleAppMain] INFO
> org.apache.archiva.redback.role.processor.DefaultRoleModelProcessor [] - time
> to process roles model: 156 ms
> 2015-04-07 17:34:15,130 [WrapperSimpleAppMain] INFO
> org.apache.archiva.redback.role.DefaultRoleManager [] - DefaultRoleManager
> initialize time 1527
> 2015-04-07 17:34:15,165 [WrapperSimpleAppMain] WARN
> org.springframework.web.context.support.XmlWebApplicationContext [] -
> Exception encountered during context initialization - cancelling refresh
> attempt
> org.springframework.beans.factory.BeanCreationException: Error creating bean
> with name 'archivaServices': Cannot resolve reference to bean
> 'authenticationInterceptor#rest' while setting bean property 'provid
> ers' with key [1]; nested exception is
> org.springframework.beans.factory.BeanCreationException: Error creating bean
> with name 'authenticationInterceptor#rest': Injection of autowired
> dependencies failed; nes
> ted exception is org.springframework.beans.factory.BeanCreationException:
> Could not autowire field: private
> org.apache.archiva.redback.users.UserManager
> org.apache.archiva.redback.rest.services.interceptors.
> AuthenticationInterceptor.userManager; nested exception is
> org.springframework.beans.factory.BeanCreationException: Error creating bean
> with name 'userManager#archiva': Injection of autowired dependencies fa
> iled; nested exception is
> org.springframework.beans.factory.BeanCreationException: Could not autowire
> field: private
> org.apache.archiva.admin.model.runtime.RedbackRuntimeConfigurationAdmin
> org.apache.archiva
> .web.security.ArchivaConfigurableUsersManager.redbackRuntimeConfigurationAdmin;
> nested exception is org.springframework.beans.factory.BeanCreationException:
> Error creating bean with name 'redbackRuntimeConfi
> gurationAdmin#default': Injection of autowired dependencies failed; nested
> exception is org.springframework.beans.factory.BeanCreationException: Could
> not autowire field: private java.util.List org.apache.ar
> chiva.admin.repository.AbstractRepositoryAdmin.auditListeners; nested
> exception is org.springframework.beans.factory.BeanCreationException: Error
> creating bean with name 'auditListener#metadata': Injection o
> f autowired dependencies failed; nested exception is
> org.springframework.beans.factory.BeanCreationException: Could not autowire
> field: private org.apache.archiva.metadata.repository.RepositorySessionFactory
> org.apache.archiva.audit.MetadataAuditListener.repositorySessionFactory;
> nested exception is org.springframework.beans.factory.BeanCreationException:
> Error creating bean with name 'repositorySessionFactory#
> jcr': Injection of autowired dependencies failed; nested exception is
> org.springframework.beans.factory.BeanCreationException: Could not autowire
> field: private org.apache.archiva.metadata.repository.Metadat
> aResolver
> org.apache.archiva.metadata.repository.jcr.JcrRepositorySessionFactory.metadataResolver;
> nested exception is org.springframework.beans.factory.BeanCreationException:
> Error creating bean with name '
> metadataResolver#default': Injection of autowired dependencies failed; nested
> exception is org.springframework.beans.factory.BeanCreationException: Could
> not autowire field: private org.apache.archiva.metada
> ta.repository.storage.RepositoryStorage
> org.apache.archiva.metadata.repository.DefaultMetadataResolver.repositoryStorage;
> nested exception is org.springframework.beans.factory.BeanCreationException:
> Error cr
> eating bean with name 'repositoryStorage#maven2': Injection of autowired
> dependencies failed; nested exception is
> org.springframework.beans.factory.BeanCreationException: Could not autowire
> field: private or
> g.apache.archiva.admin.model.managed.ManagedRepositoryAdmin
> org.apache.archiva.metadata.repository.storage.maven2.Maven2RepositoryStorage.managedRepositoryAdmin;
> nested exception is org.springframework.beans
> .factory.BeanCreationException: Error creating bean with name
> 'managedRepositoryAdmin#default': Invocation of init method failed; nested
> exception is org.apache.archiva.admin.model.RepositoryAdminException:
> Cannot forcefully unlock a NativeFSLock which is held by another indexer
> component:
> /opt/archiva/repositories/repositories/snapshots/repositories/snapshots/.indexer/write.lock
> at
> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:359)
> ~[spring-beans-4.1.4.RELEASE.jar:4.1.4.RELEASE]
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
