ORA-12899 with update trigger

又发现BUG

Java程序报错:

<Feb 9, 2009 5:08:16 PM GMT> <Warning> <MAS Logger> <BEA-000000> <com.motorola.screen3.server.app.newsreader.DCD08NewsReaderApplication: An exception thrown while executing
java.lang.RuntimeException: Error processing complete request with NewsReaderProcessor
        at com.motorola.screen3.server.app.newsreader.NewsReaderProcessor.processCompleteRequest(Unknown Source)
        at com.motorola.screen3.server.app.newsreader.DCD08NewsReaderApplication.getNewsReaderContentUpdateResponse(Unknown Source)
        at com.motorola.screen3.server.app.newsreader.DCD08NewsReaderApplication.execute(Unknown Source)
        at com.motorola.screen3.server.dcd.dcd08.DCD08ContentUpdateHandler.processApplication(Unknown Source)
        at com.motorola.screen3.server.dcd.framework.AbstractDCDContentUpdateHandler.doContentUpdate(Unknown Source)
        Truncated. see log file for complete stacktrace
java.rmi.RemoteException: EJB Exception: ; nested exception is:
        [1h16fe-fqzee7ur] Unable to execute statement: update SUBSCRIBERS set CHANNEL_HASH=?, CHANNEL_HASH_TIMESTAMP =? WHERE ID=? and CHANNEL_HASH=?
        at weblogic.ejb.container.internal.EJBRuntimeUtils.throwRemoteException(EJBRuntimeUtils.java:103)
        at weblogic.ejb.container.internal.BaseRemoteObject.handleSystemException(BaseRemoteObject.java:849)
        at weblogic.ejb.container.internal.BaseRemoteObject.handleSystemException(BaseRemoteObject.java:809)
        at weblogic.ejb.container.internal.BaseRemoteObject.postInvoke1(BaseRemoteObject.java:514)
        at weblogic.ejb.container.internal.StatelessRemoteObject.postInvoke1(StatelessRemoteObject.java:60)
        Truncated. see log file for complete stacktrace
[1h16fe-fqzee7ur] Unable to execute statement: update SUBSCRIBERS set CHANNEL_HASH=?, CHANNEL_HASH_TIMESTAMP =? WHERE ID=? and CHANNEL_HASH=?
        at com.fourthpass.util.dao.DAOUpdateStatement.execute(Unknown Source)
        at com.fourthpass.util.dao.DataAccessObject.execute(Unknown Source)
        at com.fourthpass.wpserver.dynamicportalmanager.dpo.DPSubscriberLookupDPO.updateChannelHash(Unknown Source)
        at com.fourthpass.wpserver.handlers.dynamicportalmanager.DefaultDynamicPortalManager.createActiveChannelsFromDownloadRights(Unknown Source)
        at com.fourthpass.wpserver.handlers.dynamicportalmanager.DefaultDynamicPortalManager.lookupActiveChannels(Unknown Source)
        Truncated. see log file for complete stacktrace
java.sql.SQLException: ORA-12899: value too large for column "S3TEST"."SUBSCRIBERS"."LAST_MODIFIED_DATE" (actual: 4552, maximum: 7)

        at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
        at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
        Truncated. see log file for complete stacktrace
>

表上建有触发器

CREATE OR REPLACE TRIGGER SUBSCRIBERS_MOD_DATE_TRIGGER
BEFORE INSERT OR UPDATE ON SUBSCRIBERS
FOR EACH ROW
BEGIN
:NEW.LAST_MODIFIED_DATE := SYSDATE;
END;

可能是BUG 7583083: ORA-12899 BEING HIT IN UPDATE (BEFORE UPDATE TRIGGER PRESENT)
上面说

customer confirmed that problem was resolved by install patch for 5868257.
note covering this issue: Note 752716.1 ==> will be published

跟ora-7445 _intel_fast_memcpy是同样的BUG啊?


看来以后装完Oracle后不仅要打PSR(Patch Set Release),CPU(Critical Patch Update),还必须打上最新的建议补丁集(Recommended Bundle),才能用啊, 尤其是RAC


外部链接:
GETTING ORA-12899 INTERMITTENTLY, WHILE INSERT/UPDATE ON DATE TYPE COLUMN
ORA-12899 BEING HIT IN UPDATE (BEFORE UPDATE TRIGGER PRESENT)
ORA-12899: value too large for column with Oracle Patch 10.2.0.4
Bug 5868257 - Dump / memory corruption from UPDATE DML


-fin-