PostgreSQL JDBC - Re: org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored unti

Author

Re: org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored unti

im i

2005-07-19, 7:24 am

Hi,

(Sorry my english.)

I think, the problem is not in query. There is other statement what
corrupt the transaction before query, example insert or update. The
postgres 8. solve the problem with savepoint, you can create savepoint
before critical statement and when error occured you need rollback to
savepoint:

http://www.postgresql.org/docs/8.0/...-savepoint.html

When you catch exception then the transaction is corrupt alredy.

try {
savepointName = this.getClass().getName() + "-" +
this.getClass().hashCode();
savePoint = conn. setSavepoint(savepoi
ntName);
stmt.execute();
} catch (SQLException sqle) {
conn. rollback(savePoint);

}

linimi

On 7/19/05, Senthoorkumaran Punniamoorthy <senthoor@gmail.com> wrote:
> We are using postgres as our DB for our application based on EJB. I am
> using the pg74.216.jdbc3.jar driver.
>
> one of the EJB-QL in the finder method translates to a query in JBoss as
>
> Executing SQL: SELECT t0_o.userId, t0_o.deviceId FROM rcp_user_device
> t0_o WHERE (t0_o.userId = ?)
>
> This query works on the postgres command line interface fine.
>
> SELECT t0_o.userId, t0_o.deviceId BEING_VAULT=# SELECT t0_o.userId,
> t0_o.deviceId FROM rcp_user_device t0_o WHERE (t0_o.userId =
> '94773059650')
> BEING_VAULT-# ;
> userid | deviceid
> -------------+-----------------
> 94773059650 | 351532002206818
> (1 row)
>
> However JDBC driver is rasing an exception, and below is the stack trace.
>
> 2005-07-19 12:14:54,506 DEBUG
> [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery. UserDeviceEntityBean
#findAllByUser]
> Executing SQL: SELECT t0_o.userId, t0_o.deviceId FROM rcp_user_device
> t0_o WHERE (t0_o.userId = ?)
> 2005-07-19 12:14:54,509 ERROR
> [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery. UserDeviceEntityBean
#findAllByUser]
> Find failed
> org.postgresql.util.PSQLException: ERROR: current transaction is
> aborted, commands ignored until end of transaction block
>
> at org.postgresql.util.PSQLException. parseServerError(PSQ
LException.java:139)
> at org.postgresql.core.QueryExecutor. executeV3(QueryExecu
tor.java:152)
> at org.postgresql.core.QueryExecutor. execute(QueryExecuto
r.java:100)
> at org.postgresql.core.QueryExecutor. execute(QueryExecuto
r.java:43)
> at org.postgresql.jdbc1. AbstractJdbc1Stateme
nt. execute(AbstractJdbc
1Statement.java:517)
> at org.postgresql.jdbc2. AbstractJdbc2Stateme
nt. execute(AbstractJdbc
2Statement.java:50)
> at org.postgresql.jdbc1. AbstractJdbc1Stateme
nt. executeQuery(Abstrac
tJdbc1Statement.java:233)
> at org.jboss.resource.adapter.jdbc. WrappedPreparedState
ment. executeQuery(Wrapped
PreparedStatement.java:296)
> at org.jboss.ejb.plugins.cmp.jdbc. JDBCAbstractQueryCom
mand. execute(JDBCAbstract
QueryCommand.java:228)
> at org.jboss.ejb.plugins.cmp.jdbc. JDBCAbstractQueryCom
mand. execute(JDBCAbstract
QueryCommand.java:128)
> at org.jboss.ejb.plugins.cmp.jdbc. JDBCFindEntitiesComm
and. execute(JDBCFindEnti
tiesCommand.java:40)
> at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager. findEntities(JDBCSto
reManager.java:598)
> at org.jboss.ejb.plugins. CMPPersistenceManage
r. findEntities(CMPPers
istenceManager.java:322)
> at org.jboss.resource.connectionmanager. CachedConnectionInte
rceptor. findEntities(CachedC
onnectionInterceptor
.java:321)
> at org.jboss.ejb.EntityContainer. findLocal(EntityCont
ainer.java:649)
> at sun.reflect. NativeMethodAccessor
Impl.invoke0(Native Method)
> at sun.reflect. NativeMethodAccessor
Impl. invoke(NativeMethodA
ccessorImpl.java:39)
> at sun.reflect. DelegatingMethodAcce
ssorImpl. invoke(DelegatingMet
hodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:324)
> at org.jboss.invocation.Invocation. performCall(Invocati
on.java:345)
> at org.jboss.ejb. EntityContainer$Cont
ainerInterceptor. invokeHome(EntityCon
tainer.java:1113)
> at org.jboss.ejb.plugins.AbstractInterceptor. invokeHome(AbstractI
nterceptor.java:90)
> at org.jboss.ejb.plugins. EntitySynchronizatio
nInterceptor. invokeHome(EntitySyn
chronizationIntercep
tor.java:192)
> at org.jboss.resource.connectionmanager. CachedConnectionInte
rceptor. invokeHome(CachedCon
nectionInterceptor.java:212)
> at org.jboss.ejb.plugins.AbstractInterceptor. invokeHome(AbstractI
nterceptor.java:90)
> at org.jboss.ejb.plugins. EntityInstanceInterc
eptor. invokeHome(EntityIns
tanceInterceptor.java:117)
> at org.jboss.ejb.plugins. EntityLockIntercepto
r. invokeHome(EntityLoc
kInterceptor.java:61)
> at org.jboss.ejb.plugins. EntityCreationInterc
eptor. invokeHome(EntityCre
ationInterceptor.java:28)
> at org.jboss.ejb.plugins. CallValidationInterc
eptor. invokeHome(CallValid
ationInterceptor.java:41)
> at org.jboss.ejb.plugins. AbstractTxIntercepto
r. invokeNext(AbstractT
xInterceptor.java:109)
> at org.jboss.ejb.plugins.TxInterceptorCMT. runWithTransactions(
TxInterceptorCMT.java:335)
> at org.jboss.ejb.plugins.TxInterceptorCMT. invokeHome(TxInterce
ptorCMT.java:146)
> at org.jboss.ejb.plugins.SecurityInterceptor. invokeHome(SecurityI
nterceptor.java:116)
> at org.jboss.ejb.plugins.LogInterceptor. invokeHome(LogInterc
eptor.java:121)
> at org.jboss.ejb.plugins. ProxyFactoryFinderIn
terceptor. invokeHome(ProxyFact
oryFinderInterceptor
.java:93)
> at org.jboss.ejb.EntityContainer. internalInvokeHome(E
ntityContainer.java:508)
> at org.jboss.ejb.Container.invoke(Container.java:894)
> at org.jboss.ejb.plugins.local. BaseLocalProxyFactor
y. invokeHome(BaseLocal
ProxyFactory.java:342)
> at org.jboss.ejb.plugins.local.LocalHomeProxy. invoke(LocalHomeProx
y.java:118)
> at $Proxy279. findAllByUser(Unknow
n Source)
> at com.purpleace.ripple.contacts.ejb.session. UnsubscriptionSessio
nBean. deleteUserDevices(Un
subscriptionSessionB
ean.java:176)
> at com.purpleace.ripple.contacts.ejb.session. UnsubscriptionSessio
nBean. unsubscribe(Unsubscr
iptionSessionBean.java:147)
> at sun.reflect. NativeMethodAccessor
Impl.invoke0(Native Method)
> at sun.reflect. NativeMethodAccessor
Impl. invoke(NativeMethodA
ccessorImpl.java:39)
> at sun.reflect. DelegatingMethodAcce
ssorImpl. invoke(DelegatingMet
hodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:324)
> at org.jboss.invocation.Invocation. performCall(Invocati
on.java:345)
> at org.jboss.ejb. StatelessSessionCont
ainer$ContainerInter
ceptor. invoke(StatelessSess
ionContainer.java:214)
> at org.jboss.resource.connectionmanager. CachedConnectionInte
rceptor. invoke(CachedConnect
ionInterceptor.java:185)
> at org.jboss.ejb.plugins. StatelessSessionInst
anceInterceptor. invoke(StatelessSess
ionInstanceIntercept
or.java:130)
> at org.jboss.webservice.server. ServiceEndpointInter
ceptor. invoke(ServiceEndpoi
ntInterceptor.java:51)
> at org.jboss.ejb.plugins. CallValidationInterc
eptor. invoke(CallValidatio
nInterceptor.java:48)
> at org.jboss.ejb.plugins. AbstractTxIntercepto
r. invokeNext(AbstractT
xInterceptor.java:105)
> at org.jboss.ejb.plugins.TxInterceptorCMT. runWithTransactions(
TxInterceptorCMT.java:335)
> at org.jboss.ejb.plugins.TxInterceptorCMT. invoke(TxInterceptor
CMT.java:166)
> at org.jboss.ejb.plugins.SecurityInterceptor. invoke(SecurityInter
ceptor.java:139)
> at org.jboss.ejb.plugins.LogInterceptor. invoke(LogIntercepto
r.java:192)
> at org.jboss.ejb.plugins. ProxyFactoryFinderIn
terceptor. invoke(ProxyFactoryF
inderInterceptor.java:122)
> at org.jboss.ejb.SessionContainer. internalInvoke(Sessi
onContainer.java:624)
> at org.jboss.ejb.Container.invoke(Container.java:873)
> at sun.reflect. NativeMethodAccessor
Impl.invoke0(Native Method)
> at sun.reflect. NativeMethodAccessor
Impl. invoke(NativeMethodA
ccessorImpl.java:39)
> at sun.reflect. DelegatingMethodAcce
ssorImpl. invoke(DelegatingMet
hodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:324)
> at org.jboss.mx.interceptor.ReflectedDispatcher. invoke(ReflectedDisp
atcher.java:141)
> at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
> at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
> at org.jboss.mx.server. AbstractMBeanInvoker
. invoke(AbstractMBean
Invoker.java:249)
> at org.jboss.mx.server.MBeanServerImpl. invoke(MBeanServerIm
pl.java:644)
> at org.jboss.invocation.local. LocalInvoker$MBeanSe
rverAction.invoke(LocalInvoker.java:155)
> at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:104)
> at org.jboss.invocation.InvokerInterceptor. invokeLocal(InvokerI
nterceptor.java:179)
> at org.jboss.invocation.InvokerInterceptor. invoke(InvokerInterc
eptor.java:165)
> at org.jboss.proxy. TransactionIntercept
or. invoke(TransactionIn
terceptor.java:46)
> at org.jboss.proxy.SecurityInterceptor. invoke(SecurityInter
ceptor.java:55)
> at org.jboss.proxy.ejb. StatelessSessionInte
rceptor. invoke(StatelessSess
ionInterceptor.java:97)
> at org.jboss.proxy.ClientContainer. invoke(ClientContain
er.java:86)
> at $Proxy379.unsubscribe(Unknown Source)
> at com.purpleace.ripple.contacts.ejb.session. MsisdnUpdaterSession
Bean. removeOldUser(Msisdn
UpdaterSessionBean.java:248)
> at com.purpleace.ripple.contacts.ejb.session. MsisdnUpdaterSession
Bean. updateWhereUserIdEqu
alsMsisdn(MsisdnUpda
terSessionBean.java:231)
> at sun.reflect. NativeMethodAccessor
Impl.invoke0(Native Method)
> at sun.reflect. NativeMethodAccessor
Impl. invoke(NativeMethodA
ccessorImpl.java:39)
> at sun.reflect. DelegatingMethodAcce
ssorImpl. invoke(DelegatingMet
hodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:324)
> at org.jboss.invocation.Invocation. performCall(Invocati
on.java:345)
> at org.jboss.ejb. StatelessSessionCont
ainer$ContainerInter
ceptor. invoke(StatelessSess
ionContainer.java:214)
> at org.jboss.resource.connectionmanager. CachedConnectionInte
rceptor. invoke(CachedConnect
ionInterceptor.java:185)
> at org.jboss.ejb.plugins. StatelessSessionInst
anceInterceptor. invoke(StatelessSess
ionInstanceIntercept
or.java:130)
> at org.jboss.webservice.server. ServiceEndpointInter
ceptor. invoke(ServiceEndpoi
ntInterceptor.java:51)
> at org.jboss.ejb.plugins. CallValidationInterc
eptor. invoke(CallValidatio
nInterceptor.java:48)
> at org.jboss.ejb.plugins. AbstractTxIntercepto
r. invokeNext(AbstractT
xInterceptor.java:105)
> at org.jboss.ejb.plugins.TxInterceptorCMT. runWithTransactions(
TxInterceptorCMT.java:335)
> at org.jboss.ejb.plugins.TxInterceptorCMT. invoke(TxInterceptor
CMT.java:166)
> at org.jboss.ejb.plugins.SecurityInterceptor. invoke(SecurityInter
ceptor.java:139)
> at org.jboss.ejb.plugins.LogInterceptor. invoke(LogIntercepto
r.java:192)
> at org.jboss.ejb.plugins. ProxyFactoryFinderIn
terceptor. invoke(ProxyFactoryF
inderInterceptor.java:122)
> at org.jboss.ejb.SessionContainer. internalInvoke(Sessi
onContainer.java:624)
> at org.jboss.ejb.Container.invoke(Container.java:873)
> at sun.reflect. NativeMethodAccessor
Impl.invoke0(Native Method)
> at sun.reflect. NativeMethodAccessor
Impl. invoke(NativeMethodA
ccessorImpl.java:39)
> at sun.reflect. DelegatingMethodAcce
ssorImpl. invoke(DelegatingMet
hodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:324)
> at org.jboss.mx.interceptor.ReflectedDispatcher. invoke(ReflectedDisp
atcher.java:141)
> at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
> at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
> at org.jboss.mx.server. AbstractMBeanInvoker
. invoke(AbstractMBean
Invoker.java:249)
> at org.jboss.mx.server.MBeanServerImpl. invoke(MBeanServerIm
pl.java:644)
> at org.jboss.invocation.local. LocalInvoker$MBeanSe
rverAction.invoke(LocalInvoker.java:155)
> at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:104)
> at org.jboss.invocation.InvokerInterceptor. invokeLocal(InvokerI
nterceptor.java:179)
> at org.jboss.invocation.InvokerInterceptor. invoke(InvokerInterc
eptor.java:165)
> at org.jboss.proxy. TransactionIntercept
or. invoke(TransactionIn
terceptor.java:46)
> at org.jboss.proxy.SecurityInterceptor. invoke(SecurityInter
ceptor.java:55)
> at org.jboss.proxy.ejb. StatelessSessionInte
rceptor. invoke(StatelessSess
ionInterceptor.java:97)
> at org.jboss.proxy.ClientContainer. invoke(ClientContain
er.java:86)
> at $Proxy361. updateWhereUserIdEqu
alsMsisdn(Unknown Source)
> at com.purpleace.ripple.contacts.serviceinterface.facade.ChangeMsisdnFacade. changeMsisdn(ChangeM
sisdnFacade.java:44)
> at com.purpleace.ripple.contacts.web.servlets. ChangeMsisdnServelet
. controller(ChangeMsi
sdnServelet.java:166)
> at com.purpleace.ripple.contacts.web.servlets. ChangeMsisdnServelet
. newHandleRequest(Cha
ngeMsisdnServelet.java:78)
> at com.purpleace.ripple.contacts.web.servlets. ChangeMsisdnServelet
. doPost(ChangeMsisdnS
ervelet.java:61)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
> at org.apache.catalina.core. ApplicationFilterCha
in. internalDoFilter(App
licationFilterChain.java:252)
> at org.apache.catalina.core. ApplicationFilterCha
in. doFilter(Application
FilterChain.java:173)
> at org.apache.catalina.core. ApplicationDispatche
r. invoke(ApplicationDi
spatcher.java:672)
> at org.apache.catalina.core. ApplicationDispatche
r. processRequest(Appli
cationDispatcher.java:463)
> at org.apache.catalina.core. ApplicationDispatche
r. doForward(Applicatio
nDispatcher.java:398)
> at org.apache.catalina.core. ApplicationDispatche
r. forward(ApplicationD
ispatcher.java:301)
> at com.purpleace.ripple.contacts.web.servlets.RippleServlet. controller(RippleSer
vlet.java:271)
> at com.purpleace.ripple.contacts.web.servlets.RippleServlet. parseString(RippleSe
rvlet.java:425)
> at com.purpleace.ripple.contacts.web.servlets.RippleServlet. handleRequest(Ripple
Servlet.java:124)
> at com.purpleace.ripple.contacts.web.servlets.RippleServlet. doPost(RippleServlet
.java:70)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
> at org.apache.catalina.core. ApplicationFilterCha
in. internalDoFilter(App
licationFilterChain.java:252)
> at org.apache.catalina.core. ApplicationFilterCha
in. doFilter(Application
FilterChain.java:173)
> at com.purpleace.ripple.contacts.web.filters.GlobalFilter. doFilter(GlobalFilte
r.java:37)
> at org.apache.catalina.core. ApplicationFilterCha
in. internalDoFilter(App
licationFilterChain.java:202)
> at org.apache.catalina.core. ApplicationFilterCha
in. doFilter(Application
FilterChain.java:173)
> at org.jboss.web.tomcat.filters.ReplyHeaderFilter. doFilter(ReplyHeader
Filter.java:81)
> at org.apache.catalina.core. ApplicationFilterCha
in. internalDoFilter(App
licationFilterChain.java:202)
> at org.apache.catalina.core. ApplicationFilterCha
in. doFilter(Application
FilterChain.java:173)
> at org.apache.catalina.core. StandardWrapperValve
. invoke(StandardWrapp
erValve.java:213)
> at org.apache.catalina.core. StandardContextValve
. invoke(StandardConte
xtValve.java:178)
> at org.jboss.web.tomcat.security. CustomPrincipalValve
. invoke(CustomPrincip
alValve.java:39)
> at org.jboss.web.tomcat.security. SecurityAssociationV
alve. invoke(SecurityAssoc
iationValve.java:153)
> at org.jboss.web.tomcat.security.JaccContextValve. invoke(JaccContextVa
lve.java:59)
> at org.apache.catalina.core.StandardHostValve. invoke(StandardHostV
alve.java:126)
> at org.apache.catalina.valves.ErrorReportValve. invoke(ErrorReportVa
lve.java:105)
> at org.apache.catalina.core.StandardEngineValve. invoke(StandardEngin
eValve.java:107)
> at org.apache.catalina.connector.CoyoteAdapter. service(CoyoteAdapte
r.java:148)
> at org.apache.coyote.http11.Http11Processor. process(Http11Proces
sor.java:856)
> at org.apache.coyote.http11. Http11Protocol$Http1
1ConnectionHandler. processConnection(Ht
tp11Protocol.java:744)
> at org.apache.tomcat.util.net.PoolTcpEndpoint. processSocket(PoolTc
pEndpoint.java:527)
> at org.apache.tomcat.util.net. MasterSlaveWorkerThr
ead. run(MasterSlaveWorke
rThread.java:112)
> at java.lang.Thread.run(Thread.java:534)
>
> Can you help me identify this issue?
>
> Regards,
> Senthoor
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Sponsored Links