SourceForge.net Logo
Main Overview Wiki Issues Forum Build Fisheye
Issue Details (XML | Word | Printable)

Key: CMP-379
Type: Bug Bug
Status: Open Open
Priority: Major Major
Assignee: Shay Banon
Reporter: Swetha Srinath
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Compass

Lucene Indexing - Constraint Violation

Created: 02/Mar/07 02:51 AM   Updated: 02/Mar/07 02:51 AM
Component/s: None
Affects Version/s: 0.9.1, 1.1 GA
Fix Version/s: None

Environment:
Database : Oracle9i
Driver - ojdbc14.jar
thin driver configured with in Websphere6.1 app server


 Description  « Hide
On indexing, constraint violation is obatained as the primary key = "name_" in a table LUCENE_COMMON_INDEX. The name field is conflicting with a record already present. But on deletion of all such records, the same exception was obtained for a record that did not even exist in that table.

This is happening in both compass 0.9 and compass 1.1 versions. Please suggest a solution. The stacktrace is as below:

[3/2/07 12:24:00:500 IST] 0000003f SystemErr R org.apache.lucene.store.jdbc.JdbcStoreException: Failed to execute sql [insert into LUCENE_COMMON_INDEX (name_, value_, size_, lf_, deleted_) values ( ?, ?, ?, current_timestamp, ? )]; nested exception is com.ibm.websphere.ce.cm.DuplicateKeyException: ORA-00001: unique constraint (UATFEB27.SYS_C00101883) violated

com.ibm.websphere.ce.cm.DuplicateKeyException: ORA-00001: unique constraint (UATFEB27.SYS_C00101883) violated

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java(Compiled Code))
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java(Compiled Code))
at java.lang.reflect.Constructor.newInstance(Constructor.java(Compiled Code))
at com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapExceptionHelper(GenericDataStoreHelper.java:470)
at com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapException(GenericDataStoreHelper.java:513)
at com.ibm.ws.rsadapter.jdbc.WSJdbcUtil.mapException(WSJdbcUtil.java:859)
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeUpdate(WSJdbcPreparedStatement.java:538)
at org.apache.lucene.store.jdbc.support.JdbcTemplate.executeUpdate(JdbcTemplate.java:165)
at org.apache.lucene.store.jdbc.index.RAMJdbcIndexOutput.close(RAMJdbcIndexOutput.java:147)
at org.apache.lucene.index.FieldInfos.write(FieldInfos.java:259)
at org.apache.lucene.index.SegmentMerger.mergeFields(SegmentMerger.java(Compiled Code))
at org.apache.lucene.index.SegmentMerger.merge(SegmentMerger.java:88)
at org.apache.lucene.index.IndexWriter.mergeSegments(IndexWriter.java:709)
at org.apache.lucene.index.IndexWriter.mergeSegments(IndexWriter.java:686)
at org.apache.lucene.index.IndexWriter.flushRamSegments(IndexWriter.java:656)
at org.apache.lucene.index.IndexWriter.optimize(IndexWriter.java:534)
at com.uig.unica.core.components.search.services.impl.lucene.JDBCLuceneIndexer.index(JDBCLuceneIndexer.java:33)
at com.uig.unica.core.components.search.services.impl.CommonAutoIndexer.index(CommonAutoIndexer.java:145)
at com.uig.unica.core.components.quote.domain.impl.PersonalAutoQuoteManager.saveAndIndex(PersonalAutoQuoteManager.java:295)
at com.uig.unica.core.components.quote.domain.impl.PersonalAutoQuoteManager.save(PersonalAutoQuoteManager.java:260)
at com.uig.epap.services.usecase.SaveQuoteUseCase.perform(SaveQuoteUseCase.java:114)
at com.uig.uwdf.services.general.manager.impl.procesor.pojo.SpringCommandProcesorSupport.processEvent(SpringCommandProcesorSupport.java:38)
at sun.reflect.GeneratedMethodAccessor178.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code))
at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:287)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:181)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176)
at $Proxy1.processEvent(Unknown Source)
at com.uig.uwdf.services.general.manager.impl.AbstractServicesRequest.services(AbstractServicesRequest.java:73)
at com.uig.uwdf.services.general.manager.impl.AbstractServicesRequest.service(AbstractServicesRequest.java:52)
at com.uig.epap.presentation.ui.web.model.actions.QuoteAction.services(QuoteAction.java:106)
at com.uig.unica.core.commons.presentation.ui.web.model.actions.AbstractCommonAction.execute(AbstractCommonAction.java:98)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1212)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1173)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:69)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:626)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:250)
at com.uig.unica.core.commons.presentation.ui.web.filters.LoginFilter.doFilter(LoginFilter.java:96)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:142)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:77)
at com.uig.unica.core.commons.presentation.ui.web.filters.NoCacheFilter.doFilter(NoCacheFilter.java:44)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:142)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:77)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:626)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:80)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1657)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:77)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:421)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:367)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:94)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java:548)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java:934)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java:1021)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled Code))



 All   Comments   Change History      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.