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 ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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 |