rave-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Franklin, Matthew B." <mfrank...@mitre.org>
Subject RE: DuplicateItemException after login
Date Wed, 11 Jul 2012 16:55:42 GMT
Hi Christian,

If you are running with the Out of the box H2 database, you might need to "clean" it by removing
the db file from /tmp.  This will remove the entire database and regenerate it on next startup.
 We recommend using something like MySQL, Oracle, MS SQL for real deployments.

-Matt

>-----Original Message-----
>From: Christian Fischer [mailto:c.fischer@cs-hertwig.de]
>Sent: Wednesday, July 11, 2012 12:51 PM
>To: dev@rave.apache.org
>Subject: Re: DuplicateItemException after login
>
>Appendix:
>
>When registering a new user and logging on with it, all works perfectly.
>
>Only the pre-defined username/password doesn't work. But why?
>(canonical / canonical)
>
>Greets,
>Christian
>
>
>Am 11.07.2012 17:28, schrieb Christian Fischer:
>> Hi all,
>>
>> i tried to log into RAVE, but i get the "Rave has suffered a brief
>> meltdown" Error because of a DuplicateItem exception:
>>
>> Request processing failed; nested exception is
>> org.apache.rave.exception.DuplicateItemException: DUPLICATE_ITEM;
>> nested exception is org.h2.jdbc.JdbcSQLException: Eindeutiger Index
>> oder Primarschl├╝ssel verletzt: "U_PAGE_OWNER_ID_INDEX_2 ON
>> PUBLIC.PAGE(OWNER_ID, NAME, PAGE_TYPE)"
>> Unique index or primary key violation: "U_PAGE_OWNER_ID_INDEX_2 ON
>> PUBLIC.PAGE(OWNER_ID, NAME, PAGE_TYPE)"; SQL statement:
>> INSERT INTO page (entity_id, name, page_type, owner_id,
>> page_layout_id, parent_page_id) VALUES (?, ?, ?, ?, ?, ?)
>> [23505-
>154]org.apache.rave.persistence.jpa.impl.H2OpenJpaDialect.translateExcepti
>onIfPossible(H2OpenJpaDialect.java:55)
>>
>>
>org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransact
>ionManager.java:516)
>>
>>
>org.springframework.transaction.support.AbstractPlatformTransactionManag
>er.processCommit(AbstractPlatformTransactionManager.java:754)
>>
>>
>org.springframework.transaction.support.AbstractPlatformTransactionManag
>er.commit(AbstractPlatformTransactionManager.java:723)
>>
>>
>org.springframework.transaction.interceptor.TransactionAspectSupport.com
>mitTransactionAfterReturning(TransactionAspectSupport.java:393)
>>
>>
>org.springframework.transaction.interceptor.TransactionInterceptor.invoke(T
>ransactionInterceptor.java:120)
>>
>>
>org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(R
>eflectiveMethodInvocation.java:172)
>>
>>
>org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDyna
>micAopProxy.java:202)
>>
>>                     $Proxy60.addNewDefaultUserPage(Unknown Source)
>>
>>
>org.apache.rave.portal.web.controller.PageController.getAllPagesForAuthent
>icatedUser(PageController.java:131)
>>
>>
>org.apache.rave.portal.web.controller.PageController.viewDefault(PageContr
>oller.java:75)
>>
>> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>
>>
>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.j
>ava:39)
>>
>>
>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccess
>orImpl.java:25)
>>
>> java.lang.reflect.Method.invoke(Method.java:597)
>>
>>
>org.springframework.web.method.support.InvocableHandlerMethod.invoke(
>InvocableHandlerMethod.java:212)
>>
>>
>org.springframework.web.method.support.InvocableHandlerMethod.invoke
>ForRequest(InvocableHandlerMethod.java:126)
>>
>>
>org.springframework.web.servlet.mvc.method.annotation.ServletInvocableH
>andlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:96)
>>
>>
>org.springframework.web.servlet.mvc.method.annotation.RequestMapping
>HandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.jav
>a:617)
>>
>>
>org.springframework.web.servlet.mvc.method.annotation.RequestMapping
>HandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:578)
>>
>>
>org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdap
>ter.handle(AbstractHandlerMethodAdapter.java:80)
>>
>>
>org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherSe
>rvlet.java:900)
>>
>>
>org.springframework.web.servlet.DispatcherServlet.doService(DispatcherSer
>vlet.java:827)
>>
>>
>org.springframework.web.servlet.FrameworkServlet.processRequest(Frame
>workServlet.java:882)
>>
>>
>org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServl
>et.java:778)
>>
>> javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
>>
>> javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
>>
>>
>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt
>erChain.java:290)
>>
>>
>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain
>.java:206)
>>
>>
>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte
>r(FilterChainProxy.java:311)
>>
>>
>org.springframework.security.web.access.intercept.FilterSecurityInterceptor.i
>nvoke(FilterSecurityInterceptor.java:116)
>>
>>
>org.springframework.security.web.access.intercept.FilterSecurityInterceptor.
>doFilter(FilterSecurityInterceptor.java:83)
>>
>>
>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte
>r(FilterChainProxy.java:323)
>>
>>
>org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(
>ExceptionTranslationFilter.java:113)
>>
>>
>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte
>r(FilterChainProxy.java:323)
>>
>>
>org.springframework.security.web.session.SessionManagementFilter.doFilter
>(SessionManagementFilter.java:101)
>>
>>
>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte
>r(FilterChainProxy.java:323)
>>
>>
>org.springframework.security.web.authentication.AnonymousAuthentication
>Filter.doFilter(AnonymousAuthenticationFilter.java:113)
>>
>>
>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte
>r(FilterChainProxy.java:323)
>>
>>
>org.springframework.security.web.authentication.rememberme.Remember
>MeAuthenticationFilter.doFilter(RememberMeAuthenticationFilter.java:146)
>>
>>
>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte
>r(FilterChainProxy.java:323)
>>
>>
>org.springframework.security.web.servletapi.SecurityContextHolderAwareRe
>questFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
>>
>>
>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte
>r(FilterChainProxy.java:323)
>>
>>
>org.springframework.security.web.savedrequest.RequestCacheAwareFilter.d
>oFilter(RequestCacheAwareFilter.java:45)
>>
>>
>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte
>r(FilterChainProxy.java:323)
>>
>>
>org.springframework.security.web.authentication.www.BasicAuthenticationF
>ilter.doFilter(BasicAuthenticationFilter.java:150)
>>
>>
>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte
>r(FilterChainProxy.java:323)
>>
>>
>org.springframework.security.web.authentication.AbstractAuthenticationPro
>cessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:182)
>>
>>
>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte
>r(FilterChainProxy.java:323)
>>
>>
>org.springframework.security.web.authentication.AbstractAuthenticationPro
>cessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:182)
>>
>>
>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte
>r(FilterChainProxy.java:323)
>>
>>
>org.springframework.security.web.authentication.logout.LogoutFilter.doFilter
>(LogoutFilter.java:105)
>>
>>
>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte
>r(FilterChainProxy.java:323)
>>
>>
>org.springframework.security.web.context.SecurityContextPersistenceFilter.
>doFilter(SecurityContextPersistenceFilter.java:87)
>>
>>
>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte
>r(FilterChainProxy.java:323)
>>
>>
>org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.
>java:173)
>>
>>
>org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(Delega
>tingFilterProxy.java:346)
>>
>>
>org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilte
>rProxy.java:259)
>>
>>
>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt
>erChain.java:235)
>>
>>
>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain
>.java:206)
>>
>>
>org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperVal
>ve.java:233)
>>
>>
>org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
>e.java:191)
>>
>>
>org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:
>127)
>>
>>
>org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:10
>2)
>>
>> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:615)
>>
>>
>org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.j
>ava:109)
>>
>>
>org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:29
>3)
>>
>>
>org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859
>)
>>
>>
>org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(
>Http11Protocol.java:602)
>>
>> org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
>>
>>                     java.lang.Thread.run(Thread.java:619)
>>
>> What is wrong?
>>
>> Same Problem by 0.12 Release AND 0.14-SNAPSHOT
>>
>> I Think der SQl Statement by
>>
>> VALUES (?, ?, ?, ?, ?, ?)
>>
>> is wrong?
>>
>> http://localhost:8080/portal/app/admin/ works perfectly -
>> http://localhost:8080/portal    NOT.
>>
>> Thanks,
>> Christian
>>
>


Mime
View raw message