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 --------------------------------------------------------------- -- View this message in context: http://ofbiz.135035.n4.nabble.com/Product-Search-Error-when-using-Postgres-database-tp2253277p2253277.html Sent from the OFBiz - User mailing list archive at Nabble.com.
