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
---------------------------------------------------------------
