Key violation when trying to create new mailbox
-----------------------------------------------
Key: JAMES-765
URL: https://issues.apache.org/jira/browse/JAMES-765
Project: James
Issue Type: Bug
Components: IMAPServer
Affects Versions: Trunk
Reporter: Robert Burrell Donkin
Priority: Minor
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.
-
If you think it was sent incorrectly contact one of the administrators:
https://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
