Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
TeamSite
TeamSite, LiveSite and OpenDeploy
Eventsubsystem down! Production down! help
System
in eventsubd.log...our messages table has over 240k rows and filled up our oracle database! can this table be cleared? archived? please help!
12:16:22.812 ERROR [server-24] - Failed to make message persistent
org.exolab.jms.persistence.PersistenceException:
java.sql.SQLException: ORA-01653: unable to extend table METADATA.MESSAGES by 1024 in tablespace METADATA
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:582)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1986)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1144)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2152)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2035)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2876)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:609)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:233)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:233)
at org.exolab.jms.persistence.Messages.add(Unknown Source)
at org.exolab.jms.persistence.RDBMSAdapter.addMessage(Unknown Source)
at org.exolab.jms.messagemgr.MessageMgr.addPersistentMessage(Unknown Source)
at org.exolab.jms.messagemgr.MessageMgr.add(Unknown Source)
at org.exolab.jms.server.JmsServerSession.sendMessage(Unknown Source)
at org.exolab.jms.server.mipc.IpcJmsSessionConnection.sendMessage(Unknown Source)
at org.exolab.jms.server.mipc.IpcJmsSessionConnection.notify(Unknown Source)
at org.exolab.jms.server.mipc.IpcJmsReceiver.notify(Unknown Source)
at org.exolab.jms.server.mipc.IpcServerChannel.run(Unknown Source)
Find more posts tagged with
Comments
There are no comments yet