You are viewing a plain text version of this content. The canonical link for it is here.
Posted to server-dev@james.apache.org by "Robert Burrell Donkin (JIRA)" <se...@james.apache.org> on 2008/09/20 16:57:44 UTC

[jira] Commented: (IMAP-4) Key violation when trying to create new mailbox

    [ https://issues.apache.org/jira/browse/IMAP-4?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12632973#action_12632973 ] 

Robert Burrell Donkin commented on IMAP-4:
------------------------------------------

Added test to cover this case

> Key violation when trying to create new mailbox
> -----------------------------------------------
>
>                 Key: IMAP-4
>                 URL: https://issues.apache.org/jira/browse/IMAP-4
>             Project: JAMES Imap
>          Issue Type: Bug
>            Reporter: Robert Burrell Donkin
>            Priority: Minor
>             Fix For: 0.1
>
>
> Needs more investigation: maybe this isn't a bug at all but opening a JIRA to hold stack trace
> 16/01/07 17:44:39 DEBUG imapserver: Created command class org.apache.james.imapserver.commands.CreateCommand
> 16/01/07 17:44:39 DEBUG imapserver: error processing command 
> org.apache.james.imapserver.store.MailboxException: org.apache.james.mailboxmanager.MailboxManagerException: MailboxException caused by org.apache.torque.TorqueException: java.sql.SQLException: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL061108100144821' defined on 'MAILBOX'.
> 	at org.apache.james.imapserver.commands.CreateCommand.doProcess(CreateCommand.java:55)
> 	at org.apache.james.imapserver.commands.CommandTemplate.process(CommandTemplate.java:66)
> 	at org.apache.james.imapserver.ImapRequestHandler.doProcessRequest(ImapRequestHandler.java:133)
> 	at org.apache.james.imapserver.ImapRequestHandler.handleRequest(ImapRequestHandler.java:77)
> 	at org.apache.james.imapserver.ImapHandler.handleProtocol(ImapHandler.java:159)
> 	at org.apache.james.core.AbstractJamesHandler.handleConnection(AbstractJamesHandler.java:259)
> 	at org.apache.james.util.connection.ServerConnection$ClientConnectionRunner.run(ServerConnection.java:468)
> 	at org.apache.excalibur.thread.impl.ExecutableRunnable.execute(ExecutableRunnable.java:55)
> 	at org.apache.excalibur.thread.impl.WorkerThread.run(WorkerThread.java:116)
> Caused by: org.apache.james.mailboxmanager.MailboxManagerException: MailboxException caused by org.apache.torque.TorqueException: java.sql.SQLException: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL061108100144821' defined on 'MAILBOX'.
> 	at org.apache.james.mailboxmanager.torque.TorqueMailboxManager.createMailbox(TorqueMailboxManager.java:161)
> 	at org.apache.james.mailboxmanager.impl.VirtualMailboxManager.createMailbox(VirtualMailboxManager.java:99)
> 	at org.apache.james.imapserver.commands.CreateCommand.doProcess(CreateCommand.java:53)
> 	... 8 more
> Caused by: org.apache.torque.TorqueException: java.sql.SQLException: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL061108100144821' defined on 'MAILBOX'.
> 	at org.apache.torque.util.BasePeer.throwTorqueException(BasePeer.java:103)
> 	at org.apache.torque.util.BasePeer.insertOrUpdateRecord(BasePeer.java:626)
> 	at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:516)
> 	at org.apache.james.mailboxmanager.torque.om.BaseMailboxRowPeer.doInsert(BaseMailboxRowPeer.java:222)
> 	at org.apache.james.mailboxmanager.torque.om.MailboxRowPeer.doInsert(MailboxRowPeer.java:47)
> 	at org.apache.james.mailboxmanager.torque.om.BaseMailboxRow.save(BaseMailboxRow.java:657)
> 	at org.apache.james.mailboxmanager.torque.om.BaseMailboxRow.save(BaseMailboxRow.java:621)
> 	at org.apache.james.mailboxmanager.torque.om.BaseMailboxRow.save(BaseMailboxRow.java:601)
> 	at org.apache.james.mailboxmanager.torque.TorqueMailboxManager.createMailbox(TorqueMailboxManager.java:159)
> 	... 10 more
> Caused by: java.sql.SQLException: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL061108100144821' defined on 'MAILBOX'.
> 	at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
> 	at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)
> 	at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source)
> 	at com.workingdogs.village.Record.saveWithInsert(Record.java:410)
> 	at com.workingdogs.village.Record.save(Record.java:220)
> 	at com.workingdogs.village.Record.save(Record.java:190)
> 	at org.apache.torque.util.BasePeer.insertOrUpdateRecord(BasePeer.java:622)
> 	... 17 more
> 16/01/07 17:44:39 INFO  imapserver: COMMAND FAILED [null] A02464 - org.apache.james.mailboxmanager.MailboxManagerException: MailboxException caused by org.apache.torque.TorqueException: java.sql.SQLException: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL061108100144821' defined on 'MAILBOX'.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


---------------------------------------------------------------------
To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org