Red Hat Bugzilla – Bug 508381
frequent DB transaction rollbacks from xmlserver
Last modified: 2013-01-10 05:34:04 EST
Description of problem:
The following bit of SQL is getting rolled back frequently by xmlservers:
select s.id, s.secret from rhnServer s where s.id = :p1
I'm not an Oracle expert, so I'm not sure why this creates a transaction in the first place since it's only a SELECT. Don can provide more detail.
Anyway, what's happening is that the rollback isn't occurring explicitly, but instead the DB holds the transaction open and eventually performs an implicit rollback. The XML servers need to clean up the transaction on their own, because while the transaction is open, it holds memory latches.
Here are a few sample values for the bind variable:
Let me know if you need any additional detail.
auth_system is called from our various xmlrpc handlers.
This was actually not a problem with xmlserver. The problem was fixed elsewhere. Closing the bug.