You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@felix.apache.org by "Jamie goodyear (JIRA)" <ji...@apache.org> on 2010/02/12 16:12:27 UTC
[jira] Created: (FELIX-2072) [Karaf] OracleJDBCLock filling UNDO
segment.
[Karaf] OracleJDBCLock filling UNDO segment.
---------------------------------------------
Key: FELIX-2072
URL: https://issues.apache.org/jira/browse/FELIX-2072
Project: Felix
Issue Type: Bug
Components: Karaf
Reporter: Jamie goodyear
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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (FELIX-2072) [Karaf] OracleJDBCLock filling UNDO
segment.
Posted by "Jamie goodyear (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/FELIX-2072?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jamie goodyear updated FELIX-2072:
----------------------------------
Attachment: felix-2072.diff
File: felix-2072.diff
See attached file felix-2072.diff.
This patch modifies OracleJDBCLock to use less UNDO tablespace.
Tested with Oracle XE on Linux.
> [Karaf] OracleJDBCLock filling UNDO segment.
> ---------------------------------------------
>
> Key: FELIX-2072
> URL: https://issues.apache.org/jira/browse/FELIX-2072
> Project: Felix
> Issue Type: Bug
> Components: Karaf
> Reporter: Jamie goodyear
> Attachments: felix-2072.diff
>
>
> 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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Resolved: (FELIX-2072) [Karaf] OracleJDBCLock filling UNDO
segment.
Posted by "Guillaume Nodet (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/FELIX-2072?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Guillaume Nodet resolved FELIX-2072.
------------------------------------
Resolution: Fixed
Fix Version/s: karaf-1.4.0
Assignee: Guillaume Nodet
Committing to https://svn.apache.org/repos/asf/felix/trunk ...
M karaf/main/src/main/java/org/apache/felix/karaf/main/OracleJDBCLock.java
Committed r909494
> [Karaf] OracleJDBCLock filling UNDO segment.
> ---------------------------------------------
>
> Key: FELIX-2072
> URL: https://issues.apache.org/jira/browse/FELIX-2072
> Project: Felix
> Issue Type: Bug
> Components: Karaf
> Reporter: Jamie goodyear
> Assignee: Guillaume Nodet
> Fix For: karaf-1.4.0
>
> Attachments: felix-2072.diff
>
>
> 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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.