Unix Technical Forum

Aborted Long Transaction

This is a discussion on Aborted Long Transaction within the Informix forums, part of the Database Server Software category; --> HPUX-11 IDS 9.21.HC4 I have been seeing some weird errors in my online log. 08:32:09 Aborting Long Transaction: tx ...


Go Back   Unix Technical Forum > Database Server Software > Informix

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-20-2008, 11:41 AM
Laurie Gustin
 
Posts: n/a
Default Aborted Long Transaction

HPUX-11 IDS 9.21.HC4

I have been seeing some weird errors in my online log.

08:32:09 Aborting Long Transaction: tx 0xa2f427f0 no user info due to XA or distributed (2-phase commit) transaction
08:32:09 Aborting Long Transaction: tx 0x9e236188 no user info due to XA or distributed (2-phase commit) transaction
08:32:09 Aborting Long Transaction: tx 0x9d8d9250 no user info due to XA or distributed (2-phase commit) transaction
08:32:09 Aborting Long Transaction: tx 0xa2f419d0 no user info due to XA or distributed (2-phase commit) transaction
08:32:09 Aborting Long Transaction: tx 0x9d8d8430 no user info due to XA or distributed (2-phase commit) transaction
08:32:09 Aborting Long Transaction: tx 0x9e233c74 no user info due to XA or distributed (2-phase commit) transaction
08:32:09 Aborting Long Transaction: tx 0x9c89d188 no user info due to XA or distributed (2-phase commit) transaction
08:32:09 Aborting Long Transaction: tx 0x9aefbb94 no user info due to XA or distributed (2-phase commit) transaction
08:32:09 Aborting Long Transaction: tx 0x9d8da234 no user info due to XA or distributed (2-phase commit) transaction
08:32:09 Aborting Long Transaction: tx 0x9d8d979c no user info due to XA or distributed (2-phase commit) transaction
08:32:09 Session completed abnormally. Rolling back tx id 80, flags 0x108441b
08:32:09 Session completed abnormally. Rolling back tx id 285, flags 0x108441b
08:32:09 Session completed abnormally. Rolling back tx id 463, flags 0x4108441b
08:32:09 Session completed abnormally. Rolling back tx id 471, flags 0x4108441b
08:32:09 Session completed abnormally. Rolling back tx id 615, flags 0x4108441b
08:32:09 Session completed abnormally. Rolling back tx id 623, flags 0x4108441b
08:32:09 Session completed abnormally. Rolling back tx id 626, flags 0x4108441b
08:32:09 Session completed abnormally. Rolling back tx id 632, flags 0x108441b
08:32:09 Session completed abnormally. Rolling back tx id 648, flags 0x4108441b
08:32:09 Session completed abnormally. Rolling back tx id 669, flags 0x4108441b
08:32:09 Process exited with return code 127: /bin/sh /bin/sh -c /home/informix/etc/log_full1.sh 3 22 "Long Transaction detected." "Aborting Long Transaction: tx 0xa2f
08:32:09 Process exited with return code 127: /bin/sh /bin/sh -c /home/informix/etc/log_full1.sh 3 22 "Long Transaction detected." "Aborting Long Transaction: tx 0x9e2
08:32:09 Process exited with return code 127: /bin/sh /bin/sh -c /home/informix/etc/log_full1.sh 3 22 "Long Transaction detected." "Aborting Long Transaction: tx 0x9d8
08:32:09 Process exited with return code 127: /bin/sh /bin/sh -c /home/informix/etc/log_full1.sh 3 22 "Long Transaction detected." "Aborting Long Transaction: tx 0xa2f
08:32:09 Process exited with return code 127: /bin/sh /bin/sh -c /home/informix/etc/log_full1.sh 3 22 "Long Transaction detected." "Aborting Long Transaction: tx 0x9d8
08:32:09 Process exited with return code 127: /bin/sh /bin/sh -c /home/informix/etc/log_full1.sh 3 22 "Long Transaction detected." "Aborting Long Transaction: tx 0x9e2
08:32:09 Process exited with return code 127: /bin/sh /bin/sh -c /home/informix/etc/log_full1.sh 3 22 "Long Transaction detected." "Aborting Long Transaction: tx 0x9c8
08:32:09 Process exited with return code 127: /bin/sh /bin/sh -c /home/informix/etc/log_full1.sh 3 22 "Long Transaction detected." "Aborting Long Transaction: tx 0x9ae
08:32:09 Process exited with return code 127: /bin/sh /bin/sh -c /home/informix/etc/log_full1.sh 3 22 "Long Transaction detected." "Aborting Long Transaction: tx 0x9d8
08:32:09 Process exited with return code 127: /bin/sh /bin/sh -c /home/informix/etc/log_full1.sh 3 22 "Long Transaction detected." "Aborting Long Transaction: tx 0x9d8


One of the reasons I am confused by these errors is the reference to 2-phase commit. I don't know of any 2-phase commit processes that would be running. Does anyone know what kind of process might cause these type of errors? There doesn't appear to be other problems at this time, however I have had to Heuristically rollback some transactions when errors similar to this have shown up in the past. Any insight would be appreciated.

Thanks.

Laurie

Laurie Gustin
IT Programmer Analyst
Department of Public Safety
lgustin@utah.gov
801-965-4410
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 08:16 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com