Error in product search result when using multiple keywords.

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Error in product search result when using multiple keywords.

rohit
Hi,

i am running the latest version of ofbiz with postgres. The product search in ecommerce works fine when using a single keyword, however when two or more keywords are entered i am getting the below error. Is it a bug, should i open a jira issue for it.

Please advise,


Thanks,

Rohit

2010-01-12 21:12:21,982 (TP-Processor20) [     ControlServlet.java:321:INFO ] [[[keywordsearch] Request Done- total:0.269,since last([keywordsearch] R...):0.269]]
2010-01-12 21:12:22,694 (TP-Processor20) [      ContextFilter.java:260:WARN ] [Filtered request]: /favicon.ico (/control/main)
2010-01-12 21:12:23,012 (TP-Processor2) [     ControlServlet.java:140:INFO ] [[[main] Request Begun, encoding=[UTF-8]- total:0.0,since last(Begin):0.0]]
2010-01-12 21:12:23,014 (TP-Processor2) [     RequestHandler.java:733:INFO ] Rendering View [main], sessionId=B3B4DC9539461C47F565AA8E223DCF60.jvm1
2010-01-12 21:12:23,160 (TP-Processor2) [ ProductStoreWorker.java:481:INFO ] getSurvey for product null
2010-01-12 21:12:23,886 (TP-Processor2) [     ControlServlet.java:321:INFO ] [[[main] Request Done- total:0.874,since last([main] Request Be...):0.874]]
2010-01-12 21:12:24,902 (TP-Processor9) [     ControlServlet.java:140:INFO ] [[[keywordsearch] Request Begun, encoding=[UTF-8]- total:0.0,since last(Begin):0.0]]
2010-01-12 21:12:24,907 (TP-Processor9) [      JkInputStream.java:196:INFO ] Receiving: getting request body chunk 96 96
2010-01-12 21:12:24,911 (TP-Processor9) [  KeywordSearchUtil.java:235:INFO ] Expanded keyword [abnormal], got set: []
2010-01-12 21:12:24,912 (TP-Processor9) [  KeywordSearchUtil.java:235:INFO ] Expanded keyword [psychology], got set: []
2010-01-12 21:12:24,912 (TP-Processor9) [     RequestHandler.java:629:INFO ] Ran Event [java:org.ofbiz.product.product.ProductSearchSession#checkDoKeywordOverride] from [request], result is [success]
2010-01-12 21:12:24,912 (TP-Processor9) [     RequestHandler.java:733:INFO ] Rendering View [keywordsearch], sessionId=B3B4DC9539461C47F565AA8E223DCF60.jvm1
2010-01-12 21:12:24,927 (TP-Processor9) [  KeywordSearchUtil.java:235:INFO ] Expanded keyword [abnormal], got set: []
2010-01-12 21:12:24,927 (TP-Processor9) [  KeywordSearchUtil.java:235:INFO ] Expanded keyword [psychology], got set: []
2010-01-12 21:12:24,928 (TP-Processor9) [      ProductSearch.java:271:INFO ] Finished initial setup of keywords, doingBothAndOr=false, andKeywordFixedSet=[]
 keywordFixedOrSetAndList=[[%abnormal%, %psycholog%]]
2010-01-12 21:12:25,129 (TP-Processor9) [         GenericDAO.java:766:INFO ] Ran query in 199 milli-seconds: SELECT DISTINCT SUM(PK1.RELEVANCY_WEIGHT), PROD.PRODUCT_ID FROM (public.PRODUCT PROD LEFT OUTER JOIN public.PRODUCT_CALCULATED_INFO PRODCI ON PROD.PRODUCT_ID = PRODCI.PRODUCT_ID) INNER JOIN public.PRODUCT_KEYWORD PK1 ON PROD.PRODUCT_ID = PK1.PRODUCT_ID WHERE (PROD.IS_VARIANT <> ? AND (PK1.KEYWORD LIKE ? OR PK1.KEYWORD LIKE ?)) GROUP BY PROD.PRODUCT_ID ORDER BY SUM(PK1.RELEVANCY_WEIGHT) DESC
2010-01-12 21:12:25,133 (TP-Processor9) [      ProductSearch.java:762:ERROR]
---- exception report ----------------------------------------------------------
Error getting results from the product search query
Exception: org.ofbiz.entity.GenericDataSourceException
Message: SQL Exception while executing the following:SELECT COUNT(1) FROM (SELECT COUNT(DISTINCT SUM(PK1.RELEVANCY_WEIGHT)) FROM (public.PRODUCT PROD LEFT OUTER JOIN public.PRODUCT_CALCULATED_INFO PRODCI ON PROD.PRODUCT_ID = PRODCI.PRODUCT_ID) INNER JOIN public.PRODUCT_KEYWORD PK1 ON PROD.PRODUCT_ID = PK1.PRODUCT_ID WHERE (PROD.IS_VARIANT <> ? AND (PK1.KEYWORD LIKE ? OR PK1.KEYWORD LIKE ?)) GROUP BY PROD.PRODUCT_ID) TEMP_NAME (ERROR: aggregate function calls may not be nested)
---- cause ---------------------------------------------------------------------
Exception: org.postgresql.util.PSQLException
Message: ERROR: aggregate function calls may not be nested
---- stack trace ---------------------------------------------------------------
org.postgresql.util.PSQLException: ERROR: aggregate function calls may not be nested
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
org.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:386)
org.ofbiz.entity.datasource.GenericDAO.selectCountByCondition(GenericDAO.java:1095)
org.ofbiz.entity.util.EntityListIterator.getResultsSizeAfterPartialList(EntityListIterator.java:515)
org.ofbiz.product.product.ProductSearch$ProductSearchContext.makeProductIdList(ProductSearch.java:749)
org.ofbiz.product.product.ProductSearch$ProductSearchContext.doSearch(ProductSearch.java:224)
org.ofbiz.product.product.ProductSearchSession.getProductSearchResult(ProductSearchSession.java:958)
org.ofbiz.product.product.ProductSearchSession$getProductSearchResult.call(Unknown Source)
KeywordSearch.run(KeywordSearch.groovy:35)
org.ofbiz.base.util.GroovyUtil.runScriptAtLocation(GroovyUtil.java:149)
org.ofbiz.widget.screen.ModelScreenAction$Script.runAction(ModelScreenAction.java:412)
org.ofbiz.widget.screen.ModelScreenAction.runSubActions(ModelScreenAction.java:118)
org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:221)
org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:394)
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:99)
org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:831)
org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:550)
org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:223)
org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:86)
javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
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:266)
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:175)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
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:568)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283)
org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767)
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697)
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:889)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2010-01-12 21:12:25,134 (TP-Processor9) [   GenericDelegator.java:832:ERROR]
---- exception report ----------------------------------------------------------
Failure in create operation for entity [ProductSearchResult]: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductSearchResult][createdStamp,2010-01-12 21:12:25.133(java.sql.Timestamp)][createdTxStamp,2010-01-12 21:12:24.916(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-01-12 21:12:25.133(java.sql.Timestamp)][lastUpdatedTxStamp,2010-01-12 21:12:24.916(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,32996(java.lang.String)][searchDate,2010-01-12 21:12:24.927(java.sql.Timestamp)][secondsTotal,0.205(java.lang.Double)][visitId,429998(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-01-12 21:12:25.133(java.sql.Timestamp)][createdTxStamp,2010-01-12 21:12:24.916(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-01-12 21:12:25.133(java.sql.Timestamp)][lastUpdatedTxStamp,2010-01-12 21:12:24.916(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,32996(java.lang.String)][searchDate,2010-01-12 21:12:24.927(java.sql.Timestamp)][secondsTotal,0.205(java.lang.Double)][visitId,429998(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:2062)
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321)
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:418)
org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:173)
org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:119)
org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:64)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:810)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:684)
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:958)
org.ofbiz.product.product.ProductSearchSession$getProductSearchResult.call(Unknown Source)
KeywordSearch.run(KeywordSearch.groovy:35)
org.ofbiz.base.util.GroovyUtil.runScriptAtLocation(GroovyUtil.java:149)
org.ofbiz.widget.screen.ModelScreenAction$Script.runAction(ModelScreenAction.java:412)
org.ofbiz.widget.screen.ModelScreenAction.runSubActions(ModelScreenAction.java:118)
org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:221)
org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:394)
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:99)
org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:831)
org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:550)
org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:223)
org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:86)
javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
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:266)
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:175)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
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:568)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283)
org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767)
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697)
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:889)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2010-01-12 21:12:25,135 (TP-Processor9) [    TransactionUtil.java:372: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-01-12 21:12:25.133(java.sql.Timestamp)][createdTxStamp,2010-01-12 21:12:24.916(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-01-12 21:12:25.133(java.sql.Timestamp)][lastUpdatedTxStamp,2010-01-12 21:12:24.916(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,32996(java.lang.String)][searchDate,2010-01-12 21:12:24.927(java.sql.Timestamp)][secondsTotal,0.205(java.lang.Double)][visitId,429998(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 ---------------------------------------------------------------
java.lang.Exception: Failure in create operation for entity [ProductSearchResult]: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductSearchResult][createdStamp,2010-01-12 21:12:25.133(java.sql.Timestamp)][createdTxStamp,2010-01-12 21:12:24.916(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-01-12 21:12:25.133(java.sql.Timestamp)][lastUpdatedTxStamp,2010-01-12 21:12:24.916(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,32996(java.lang.String)][searchDate,2010-01-12 21:12:24.927(java.sql.Timestamp)][secondsTotal,0.205(java.lang.Double)][visitId,429998(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.
org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:372)
org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:319)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:835)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:684)
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:958)
org.ofbiz.product.product.ProductSearchSession$getProductSearchResult.call(Unknown Source)
KeywordSearch.run(KeywordSearch.groovy:35)
org.ofbiz.base.util.GroovyUtil.runScriptAtLocation(GroovyUtil.java:149)
org.ofbiz.widget.screen.ModelScreenAction$Script.runAction(ModelScreenAction.java:412)
org.ofbiz.widget.screen.ModelScreenAction.runSubActions(ModelScreenAction.java:118)
org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:221)
org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:394)
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:99)
org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:831)
org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:550)
org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:223)
org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:86)
javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
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:266)
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:175)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
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:568)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283)
org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767)
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697)
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:889)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2010-01-12 21:12:25,136 (TP-Processor9) [      ProductSearch.java:801:ERROR]
---- exception report ----------------------------------------------------------
Error saving product search result info/stats
Exception: org.ofbiz.entity.GenericEntityException
Message: Error while inserting: [GenericEntity:ProductSearchResult][createdStamp,2010-01-12 21:12:25.133(java.sql.Timestamp)][createdTxStamp,2010-01-12 21:12:24.916(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-01-12 21:12:25.133(java.sql.Timestamp)][lastUpdatedTxStamp,2010-01-12 21:12:24.916(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,32996(java.lang.String)][searchDate,2010-01-12 21:12:24.927(java.sql.Timestamp)][secondsTotal,0.205(java.lang.Double)][visitId,429998(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:2062)
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321)
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:418)
org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:173)
org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:119)
org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:64)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:810)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:684)
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:958)
org.ofbiz.product.product.ProductSearchSession$getProductSearchResult.call(Unknown Source)
KeywordSearch.run(KeywordSearch.groovy:35)
org.ofbiz.base.util.GroovyUtil.runScriptAtLocation(GroovyUtil.java:149)
org.ofbiz.widget.screen.ModelScreenAction$Script.runAction(ModelScreenAction.java:412)
org.ofbiz.widget.screen.ModelScreenAction.runSubActions(ModelScreenAction.java:118)
org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:221)
org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:394)
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:99)
org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:831)
org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:550)
org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:223)
org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:86)
javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
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:266)
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:175)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
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:568)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283)
org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767)
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697)
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:889)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2010-01-12 21:12:25,136 (TP-Processor9) [    TransactionUtil.java:376:INFO ] [TransactionUtil.setRollbackOnly] transaction rollback only not set, rollback only is already set.
2010-01-1