报错:
2016-12-09 13:16:31,645 WARN [com.atomikos.recovery.xa.XaResourceRecoveryManager] - Error while retrieving xids from resource - will retry later…
javax.transaction.xa.XAException
at oracle.jdbc.xa.OracleXAResource.recover(OracleXAResource.java:705)
com.atomikos.jdbc.AtomikosConnectionProxy] - <atomikos connection proxy for oracle.jdbc.driver.LogicalConnection@6c2b2558: close()…>
2020-02-26 04:58:22,579 WARN [com.atomikos.recovery.xa.XaResourceRecoveryManager] - <Error while retrieving xids from resource - will retry later…>
javax.transaction.xa.XAException
at oracle.jdbc.xa.OracleXAResource.recover(OracleXAResource.java:526)
at com.atomikos.datasource.xa.RecoveryScan.recoverXids(RecoveryScan.java:32)
at com.atomikos.recovery.xa.XaResourceRecoveryManager.retrievePreparedXidsFromXaResource(XaResourceRecoveryManager.java:158)
at com.atomikos.recovery.xa.XaResourceRecoveryManager.recover(XaResourceRecoveryManager.java:67)
at com.atomikos.datasource.xa.XATransactionalResource.recover(XATransactionalResource.java:449)
at com.atomikos.icatch.imp.TransactionServiceImp.performRecovery(TransactionServiceImp.java:490)
at com.atomikos.icatch.imp.TransactionServiceImp.access$000(TransactionServiceImp.java:56)
at com.atomikos.icatch.imp.TransactionServiceImp
1.
a
l
a
r
m
(
T
r
a
n
s
a
c
t
i
o
n
S
e
r
v
i
c
e
I
m
p
.
j
a
v
a
:
471
)
a
t
c
o
m
.
a
t
o
m
i
k
o
s
.
t
i
m
i
n
g
.
P
o
o
l
e
d
A
l
a
r
m
T
i
m
e
r
.
n
o
t
i
f
y
L
i
s
t
e
n
e
r
s
(
P
o
o
l
e
d
A
l
a
r
m
T
i
m
e
r
.
j
a
v
a
:
95
)
a
t
c
o
m
.
a
t
o
m
i
k
o
s
.
t
i
m
i
n
g
.
P
o
o
l
e
d
A
l
a
r
m
T
i
m
e
r
.
r
u
n
(
P
o
o
l
e
d
A
l
a
r
m
T
i
m
e
r
.
j
a
v
a
:
82
)
a
t
j
a
v
a
.
u
t
i
l
.
c
o
n
c
u
r
r
e
n
t
.
T
h
r
e
a
d
P
o
o
l
E
x
e
c
u
t
o
r
.
r
u
n
W
o
r
k
e
r
(
T
h
r
e
a
d
P
o
o
l
E
x
e
c
u
t
o
r
.
j
a
v
a
:
1142
)
a
t
j
a
v
a
.
u
t
i
l
.
c
o
n
c
u
r
r
e
n
t
.
T
h
r
e
a
d
P
o
o
l
E
x
e
c
u
t
o
r
1.alarm(TransactionServiceImp.java:471) at com.atomikos.timing.PooledAlarmTimer.notifyListeners(PooledAlarmTimer.java:95) at com.atomikos.timing.PooledAlarmTimer.run(PooledAlarmTimer.java:82) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor
1.alarm(TransactionServiceImp.java:471)atcom.atomikos.timing.PooledAlarmTimer.notifyListeners(PooledAlarmTimer.java:95)atcom.atomikos.timing.PooledAlarmTimer.run(PooledAlarmTimer.java:82)atjava.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)atjava.util.concurrent.ThreadPoolExecutorWorker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
2020-02-26 04:58:22,595 INFO [com.atomikos.datasource.xa.XATransactionalResource] - <ds2: refreshed XAResource>
2020-02-26 04:58:22,596 WARN [com.atomikos.recovery.xa.XaResourceRecoveryManager] - <Error while retrieving xids from resource - will retry later…>
javax.transaction.xa.XAException
at oracle.jdbc.xa.OracleXAResource.recover(OracleXAResource.java:526)
at com.atomikos.datasource.xa.RecoveryScan.recoverXids(RecoveryScan.java:32)
at com.atomikos.recovery.xa.XaResourceRecoveryManager.retrievePreparedXidsFromXaResource(XaResourceRecoveryManager.
解决方案:
grant select on sys.dba_pending_transactions to xmglxt ;
grant select on sys.pending_trans$ to xmglxt;
grant select on sys.dba_2pc_pending to xmglxt;
grant execute on sys.dbms_system to xmglxt;
重启项目问题解决。