Bug #105

ORA-01591: lock held by in-doubt distributed transaction 1.8.49044

Added by Pablo Escobar 8 months ago. Updated 8 months ago.

Status:ClosedStart date:03/23/2017
Priority:NormalDue date:
Assignee:-% Done:

100%

Category:-
Target version:-

Description

Getting this error in my server.
I've attached xa folder contents with information on transaction that has hanged.

xa.tar.gz (326 Bytes) Pablo Escobar, 03/23/2017 02:58 PM

History

#1 Updated by Madars Vitolins 8 months ago

  • Project changed from endurox-go to Enduro/X

#2 Updated by Madars Vitolins 8 months ago

1490185291614:I:1:1:11:90:1
1490185291615:S:40

Transaction log file info:
first line:

0580     /* Read first time stamp */
0581     TOKEN_READ("info", "tstamp");
0582     p_tl->t_start = atol(p);
0583     
0584     /* read tmrmid, tmnodeid, tmsrvid = ignore, but they must be in place! */
0585     TOKEN_READ("info", "cmdid");
0586     /* Basically we ignore these values, and read from current process!!!: */
0587     TOKEN_READ("info", "tmrmid");
0588     TOKEN_READ("info", "tmnodeid");
0589     TOKEN_READ("info", "tmsrvid");
0590     p_tl->tmrmid = G_atmi_env.xa_rmid;
0591     p_tl->tmnodeid = tpgetnodeid();
0592     p_tl->tmsrvid = G_server_conf.srv_id;
0593     
0594     TOKEN_READ("info", "txtout");
0595     p_tl->txtout = atol(p);
0596     
0597     /* Read involved resrouce managers - put them in join state */
0598     TOKEN_READ("info", "rmsbuf");

- So RMS buffer says which Resource managers are involved, and for current sample it is "1".

Second line:

1490185291615:S:40

- Says that transaction is preparing (stage 40)

So to fix this issue, TM will just to make transaction abort at prepare stage when tmsrv is reboot. Because there is no way caller will get back the response and it is just preparing, thus abort...

#4 Updated by Madars Vitolins 8 months ago

  • Status changed from New to Resolved
  • % Done changed from 0 to 100

#5 Updated by Madars Vitolins 8 months ago

  • Status changed from Resolved to Closed

Also available in: Atom PDF