[FELIX-2072] [Karaf] OracleJDBCLock filling UNDO segment.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: karaf-1.4.0
• Component/s: Karaf
• Assignee: Guillaume Nodet
• Reporter: Jamie Mark Goodyear
• Created: 12/Feb/10 15:12
• Updated: 12/Feb/10 16:33
• Resolved: 12/Feb/10 16:33

Description

When using the Oracle JDBC Lock mechanism the UNDO table space fills at a rapid pace. The following log entry will be observed:

ERROR | Thread-1 | OracleJDBCLock | .felix.karaf.main.OracleJDBCLock 211 | Error occured while testing lock: java.sql.SQLException: ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDO'
ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDO'

Reviewing the Oracle JDBC Lock class it appears the UNDO space is being consumed by un-necessary update commands.

I'll be attaching a patch for this shortly.