Hi there,
anyone can help me to understand why I get this exception after the
latest refactoring:
1390 [main] INFO sessionLog - Delete failed
org.apache.james.mailbox.MailboxException: Delete of mailbox Mailbox (
mailboxId = 2 name = selected uidValidity = 1869794862 ) failed
at
org.apache.james.mailbox.jpa.mail.JPAMailboxMapper.delete(JPAMailboxMapper.java:108)
at
org.apache.james.mailbox.store.StoreMailboxManager$2.runVoid(StoreMailboxManager.java:304)
at
org.apache.james.mailbox.store.transaction.Mapper$VoidTransaction.run(Mapper.java:67)
at
org.apache.james.mailbox.store.transaction.Mapper$VoidTransaction.run(Mapper.java:64)
at
org.apache.james.mailbox.store.transaction.TransactionalMapper.execute(TransactionalMapper.java:38)
at
org.apache.james.mailbox.store.StoreMailboxManager.deleteMailbox(StoreMailboxManager.java:297)
at
org.apache.james.imap.processor.DeleteProcessor.doProcess(DeleteProcessor.java:59)
at
org.apache.james.imap.processor.DeleteProcessor.doProcess(DeleteProcessor.java:35)
at
org.apache.james.imap.processor.AbstractMailboxProcessor.doProcess(AbstractMailboxProcessor.java:89)
at
org.apache.james.imap.processor.AbstractMailboxProcessor.process(AbstractMailboxProcessor.java:78)
at
org.apache.james.imap.processor.AbstractMailboxProcessor.doProcess(AbstractMailboxProcessor.java:72)
at
org.apache.james.imap.processor.AbstractMailboxProcessor.doProcess(AbstractMailboxProcessor.java:55)
at
org.apache.james.imap.processor.base.AbstractChainedProcessor.process(AbstractChainedProcessor.java:55)
at
org.apache.james.imap.processor.base.AbstractChainedProcessor.process(AbstractChainedProcessor.java:57)
at
org.apache.james.imap.processor.base.AbstractChainedProcessor.process(AbstractChainedProcessor.java:57)
at
org.apache.james.imap.processor.base.AbstractChainedProcessor.process(AbstractChainedProcessor.java:57)
at
org.apache.james.imap.processor.base.AbstractChainedProcessor.process(AbstractChainedProcessor.java:57)
at
org.apache.james.imap.processor.base.AbstractChainedProcessor.process(AbstractChainedProcessor.java:57)
at
org.apache.james.imap.processor.base.AbstractChainedProcessor.process(AbstractChainedProcessor.java:57)
at
org.apache.james.imap.processor.base.AbstractChainedProcessor.process(AbstractChainedProcessor.java:57)
at
org.apache.james.imap.processor.base.AbstractChainedProcessor.process(AbstractChainedProcessor.java:57)
at
org.apache.james.imap.processor.base.AbstractChainedProcessor.process(AbstractChainedProcessor.java:57)
at
org.apache.james.imap.processor.base.AbstractChainedProcessor.process(AbstractChainedProcessor.java:57)
at
org.apache.james.imap.processor.base.AbstractChainedProcessor.process(AbstractChainedProcessor.java:57)
at
org.apache.james.imap.processor.base.AbstractChainedProcessor.process(AbstractChainedProcessor.java:57)
at
org.apache.james.imap.processor.base.AbstractChainedProcessor.process(AbstractChainedProcessor.java:57)
at
org.apache.james.imap.processor.base.AbstractChainedProcessor.process(AbstractChainedProcessor.java:57)
at
org.apache.james.imap.processor.base.AbstractChainedProcessor.process(AbstractChainedProcessor.java:57)
at
org.apache.james.imap.processor.base.AbstractChainedProcessor.process(AbstractChainedProcessor.java:57)
at
org.apache.james.imap.processor.base.AbstractChainedProcessor.process(AbstractChainedProcessor.java:57)
at
org.apache.james.imap.processor.base.AbstractChainedProcessor.process(AbstractChainedProcessor.java:57)
at
org.apache.james.imap.processor.base.AbstractChainedProcessor.process(AbstractChainedProcessor.java:57)
at
org.apache.james.imap.processor.base.AbstractChainedProcessor.process(AbstractChainedProcessor.java:57)
at
org.apache.james.imap.processor.base.AbstractChainedProcessor.process(AbstractChainedProcessor.java:57)
at
org.apache.james.imap.processor.base.AbstractChainedProcessor.process(AbstractChainedProcessor.java:57)
at
org.apache.james.imap.processor.base.AbstractChainedProcessor.process(AbstractChainedProcessor.java:57)
at
org.apache.james.imap.processor.base.AbstractChainedProcessor.process(AbstractChainedProcessor.java:57)
at
org.apache.james.imap.main.AbstractImapRequestHandler.doProcessRequest(AbstractImapRequestHandler.java:55)
at
org.apache.james.imap.main.ImapRequestStreamHandler.handleRequest(ImapRequestStreamHandler.java:77)
at
org.apache.james.imap.tester.ImapHostSystem$Session.readLine(ImapHostSystem.java:123)
at
org.apache.james.imap.tester.base.ProtocolSession$ServerResponse.readLine(ProtocolSession.java:349)
at
org.apache.james.imap.tester.base.ProtocolSession$ServerResponse.checkResponse(ProtocolSession.java:313)
at
org.apache.james.imap.tester.base.ProtocolSession$ServerResponse.testProtocol(ProtocolSession.java:303)
at
org.apache.james.imap.tester.base.ProtocolSession.runSessions(ProtocolSession.java:92)
at
org.apache.james.imap.tester.base.AbstractProtocolTestFramework.runSessions(AbstractProtocolTestFramework.java:111)
at
org.apache.james.imap.tester.base.AbstractSimpleScriptedTestProtocol.scriptTest(AbstractSimpleScriptedTestProtocol.java:74)
at
org.apache.james.imap.tester.suite.SelectedState.testCheckUS(SelectedState.java:36)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:44)
at
org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)
at
org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:41)
at
org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:20)
at
org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:28)
at
org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:31)
at
org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:76)
at
org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:50)
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:193)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:52)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:191)
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:42)
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:184)
at org.junit.runners.ParentRunner.run(ParentRunner.java:236)
at
org.apache.maven.surefire.junit4.JUnit4TestSet.execute(JUnit4TestSet.java:35)
at
org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:115)
at
org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:97)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.apache.maven.surefire.booter.ProviderFactory$ClassLoaderProxy.invoke(ProviderFactory.java:103)
at $Proxy0.invoke(Unknown Source)
at
org.apache.maven.surefire.booter.SurefireStarter.invokeProvider(SurefireStarter.java:150)
at
org.apache.maven.surefire.booter.SurefireStarter.runSuitesInProcess(SurefireStarter.java:91)
at
org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:69)
Caused by: <openjpa-2.1.0-r422266:1071316 fatal general error>
org.apache.openjpa.persistence.PersistenceException: Referential
integrity constraint violation: "CONSTRAINT_9:
PUBLIC.JAMES_MAIL_JAMES_MAIL_HEADER FOREIGN KEY(MESSAGE_MAILBOX_ID,
MESSAGE_MAIL_UID) REFERENCES PUBLIC.JAMES_MAIL(MAILBOX_ID, MAIL_UID)";
SQL statement:
DELETE FROM PUBLIC.JAMES_MAIL t0 WHERE (t0.MAILBOX_ID = ?) [23503-154]
{prepstmnt 562850178 DELETE FROM PUBLIC.JAMES_MAIL t0 WHERE
(t0.MAILBOX_ID = ?) [params=?]} [code=23503, state=23503]
FailedObject: DELETE FROM PUBLIC.JAMES_MAIL t0 WHERE (t0.MAILBOX_ID =
?) [java.lang.String]
at
org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4869)
at
org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4829)
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:136)
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:78)
at
org.apache.openjpa.jdbc.kernel.JDBCStoreQuery.executeBulkOperation(JDBCStoreQuery.java:579)
at
org.apache.openjpa.jdbc.kernel.JDBCStoreQuery.executeDelete(JDBCStoreQuery.java:491)
at
org.apache.openjpa.kernel.ExpressionStoreQuery$DataStoreExecutor.executeDelete(ExpressionStoreQuery.java:788)
at org.apache.openjpa.kernel.QueryImpl.delete(QueryImpl.java:1025)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:865)
at org.apache.openjpa.kernel.QueryImpl.deleteAll(QueryImpl.java:892)
at
org.apache.openjpa.kernel.DelegatingQuery.deleteAll(DelegatingQuery.java:574)
at
org.apache.openjpa.persistence.QueryImpl.executeUpdate(QueryImpl.java:362)
at
org.apache.james.mailbox.jpa.mail.JPAMailboxMapper.delete(JPAMailboxMapper.java:105)
... 76 more
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException:
Referential integrity constraint violation: "CONSTRAINT_9:
PUBLIC.JAMES_MAIL_JAMES_MAIL_HEADER FOREIGN KEY(MESSAGE_MAILBOX_ID,
MESSAGE_MAIL_UID) REFERENCES PUBLIC.JAMES_MAIL(MAILBOX_ID, MAIL_UID)";
SQL statement:
DELETE FROM PUBLIC.JAMES_MAIL t0 WHERE (t0.MAILBOX_ID = ?) [23503-154]
{prepstmnt 562850178 DELETE FROM PUBLIC.JAMES_MAIL t0 WHERE
(t0.MAILBOX_ID = ?) [params=?]} [code=23503, state=23503]
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:281)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:257)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$1000(LoggingConnectionDecorator.java:72)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:1199)
at
org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:291)
at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1776)
at
org.apache.openjpa.jdbc.kernel.JDBCStoreQuery.executeUpdate(JDBCStoreQuery.java:746)
at
org.apache.openjpa.jdbc.kernel.JDBCStoreQuery.executeBulkOperation(JDBCStoreQuery.java:577)
... 84 more
Tests run: 30, Failures: 0, Errors: 30, Skipped: 0, Time elapsed:
3.332 sec <<< FAILURE!
It seems like it don't understand that it need to remove the "many"
mappings first....
Thanks,
Norman
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
