ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jacques Le Roux" <jacques.le.r...@les7arts.com>
Subject Re: Product Search Error when using Postgres database.
Date Sun, 13 Jun 2010 10:04:05 GMT
I can' reproduce on the trunk demo (Derby on Ubuntu) nor locally (Postgres 8.4 on XP)
Have you a specific reproductible keyword?

Jacques

rohit wrote:
> Hi,
>
> I am using the latest SVN with postgres database 8.2.11. When searching for
> products for certain keyword, its throwing the below error. Did anyone
> notice such error? Its best to try some random keywords to reproduce the
> error.
>
> Any help will be appreciated.
>
> Thanks,
>
> Rohit
>
>
> 010-06-13 04:05:37,506 (TP-Processor7) [       SequenceUtil.java:337:INFO ]
> Got bank of sequenced IDs for [ProductSearchResult]; curSeqId=10010,
> maxSeqId=10020, bankSize=10
> 2010-06-13 04:05:37,508 (TP-Processor7) [   GenericDelegator.java:900:ERROR]
> ---- exception report
> ----------------------------------------------------------
> Failure in create operation for entity [ProductSearchResult]:
> org.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:ProductSearchResult][createdStamp,2010-06-13
> 04:05:37.507(java.sql.Timestamp)][createdTxStamp,2010-06-13
> 04:05:37.377(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-13
> 04:05:37.507(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-13
> 04:05:37.377(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10010(java.lang.String)][searchDate,2010-06-13
> 04:05:37.412(java.sql.Timestamp)][secondsTotal,0.011(java.lang.Double)][visitId,10015(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO
> public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID,
> ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
> VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is
> aborted, commands ignored until end of transaction block)). Rolling back
> transaction.
> Exception: org.ofbiz.entity.GenericEntityException
> Message: Error while inserting:
> [GenericEntity:ProductSearchResult][createdStamp,2010-06-13
> 04:05:37.507(java.sql.Timestamp)][createdTxStamp,2010-06-13
> 04:05:37.377(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-13
> 04:05:37.507(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-13
> 04:05:37.377(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10010(java.lang.String)][searchDate,2010-06-13
> 04:05:37.412(java.sql.Timestamp)][secondsTotal,0.011(java.lang.Double)][visitId,10015(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO
> public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID,
> ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
> VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is
> aborted, commands ignored until end of transaction block))
> ---- cause
> ---------------------------------------------------------------------
> Exception: org.ofbiz.entity.GenericDataSourceException
> Message: SQL Exception while executing the following:INSERT INTO
> public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID,
> ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
> VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is
> aborted, commands ignored until end of transaction block)
> ---- cause
> ---------------------------------------------------------------------
> Exception: org.postgresql.util.PSQLException
> Message: ERROR: current transaction is aborted, commands ignored until end
> of transaction block
> ---- stack trace
> ---------------------------------------------------------------
> org.postgresql.util.PSQLException: ERROR: current transaction is aborted,
> commands ignored until end of transaction block
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1608)
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1343)
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:195)
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351)
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:305)
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:419)
> org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:173)
> org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:115)
> org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:64)
> org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:878)
> org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:744)
> org.ofbiz.entity.GenericValue.create(GenericValue.java:125)
> org.ofbiz.product.product.ProductSearch$ProductSearchContext.saveSearchResultInfo(ProductSearch.java:788)
> org.ofbiz.product.product.ProductSearch$ProductSearchContext.doSearch(ProductSearch.java:237)
> org.ofbiz.product.product.ProductSearchSession.getProductSearchResult(ProductSearchSession.java:959)
> org.ofbiz.product.product.ProductSearchSession$getProductSearchResult.call(Unknown
> Source)
> org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:40)
> org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:117)
> org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:133)
> KeywordSearch.run(KeywordSearch.groovy:35)
> org.ofbiz.widget.screen.ModelScreenAction$Script.runAction(ModelScreenAction.java:421)
> org.ofbiz.widget.screen.ModelScreenAction.runSubActions(ModelScreenAction.java:121)
> org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:180)
> org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:392)
> org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:135)
> org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:97)
> org.ofbiz.widget.screen.ScreenWidgetViewHandler.render(ScreenWidgetViewHandler.java:101)
> org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:839)
> org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:559)
> org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:227)
> org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:90)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:270)
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:555)
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
> org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
> org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
> org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
> org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
> org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
> 2010-06-13 04:05:37,509 (TP-Processor7) [    TransactionUtil.java:370:WARN ]
> ---- exception report
> ----------------------------------------------------------
> [TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly; this
> stack trace shows where this is happening:
> Exception: java.lang.Exception
> Message: Failure in create operation for entity [ProductSearchResult]:
> org.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:ProductSearchResult][createdStamp,2010-06-13
> 04:05:37.507(java.sql.Timestamp)][createdTxStamp,2010-06-13
> 04:05:37.377(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-06-13
> 04:05:37.507(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-13
> 04:05:37.377(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10010(java.lang.String)][searchDate,2010-06-13
> 04:05:37.412(java.sql.Timestamp)][secondsTotal,0.011(java.lang.Double)][visitId,10015(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO
> public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID,
> ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
> VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is
> aborted, commands ignored until end of transaction block)). Rolling back
> transaction.
> ---- stack trace
> --------------------------------------------------------------- 



Mime
View raw message