You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by rohit <ro...@yahoo.com> on 2010/06/13 10:14:07 UTC
Product Search Error when using Postgres database.
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.
Re: Product Search Error when using Postgres database.
Posted by Jacques Le Roux <ja...@les7arts.com>.
I'd try with the same instance but with another DB: Derby is at hand
Jacques
From: "rohit" <ro...@yahoo.com>
> does the error log, provide any help or point to any potential problem. I
> spent the whole day today to resolve this but no success yet.
>
> I also updated postgres to 8.4 and the jdbc driver and did the ant
> run-install. to freshly populate the database but no help.
>
> I guess its more of an environment issue, than with the code. I am using jdk
> 1.6-17, postgres 8.4 and postgres8.4-jdbc4, on FC-8.
>
> If u get any pointers, from the log please do let me know.
>
> Thanks,
>
> Rohit
> --
> View this message in context:
> http://ofbiz.135035.n4.nabble.com/Product-Search-Error-when-using-Postgres-database-tp2253277p2253573.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
Re: Product Search Error when using Postgres database.
Posted by rohit <ro...@yahoo.com>.
does the error log, provide any help or point to any potential problem. I
spent the whole day today to resolve this but no success yet.
I also updated postgres to 8.4 and the jdbc driver and did the ant
run-install. to freshly populate the database but no help.
I guess its more of an environment issue, than with the code. I am using jdk
1.6-17, postgres 8.4 and postgres8.4-jdbc4, on FC-8.
If u get any pointers, from the log please do let me know.
Thanks,
Rohit
--
View this message in context: http://ofbiz.135035.n4.nabble.com/Product-Search-Error-when-using-Postgres-database-tp2253277p2253573.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Product Search Error when using Postgres database.
Posted by Jacques Le Roux <ja...@les7arts.com>.
No, it's only that I'm using 8.4 locally
giz returns results here and on trunk demo (and stable), just tested
Jacques
rohit wrote:
> it was showing for the keyword 'giz'.
>
> u mentioned that you are using postgres 8.4, do we necessarily have to use
> 8.4. I am getting the error when using 8.2.
>
> Does the SQL generated as shown in the error seem correct to you.
>
> Thanks,
>
> Rohit
Re: Product Search Error when using Postgres database.
Posted by rohit <ro...@yahoo.com>.
it was showing for the keyword 'giz'.
u mentioned that you are using postgres 8.4, do we necessarily have to use
8.4. I am getting the error when using 8.2.
Does the SQL generated as shown in the error seem correct to you.
Thanks,
Rohit
--
View this message in context: http://ofbiz.135035.n4.nabble.com/Product-Search-Error-when-using-Postgres-database-tp2253277p2253341.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Product Search Error when using Postgres database.
Posted by Jacques Le Roux <ja...@les7arts.com>.
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
> ---------------------------------------------------------------