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 2006/12/02 20:57:21 UTC
[jira] Created: (JAMES-722) Torque SQL Exception - How Can I
Diagnose Cause?
Torque SQL Exception - How Can I Diagnose Cause?
------------------------------------------------
Key: JAMES-722
URL: http://issues.apache.org/jira/browse/JAMES-722
Project: James
Issue Type: Bug
Components: IMAPServer
Affects Versions: Trunk
Reporter: Robert Burrell Donkin
i'm getting a error when executing an LSUB command. any pointers to working out what the cause is...?
02/12/06 19:55:50 DEBUG imapserver: Got <tag>: A00002
02/12/06 19:55:50 DEBUG imapserver: Got <command>: LSUB
02/12/06 19:55:50 DEBUG imapserver: Parsed LSUB@1165089350035 duration(ms) 0
02/12/06 19:55:50 DEBUG imapserver: Created command class org.apache.james.imapserver.commands.LsubCommand
02/12/06 19:55:50 INFO imapserver: org.apache.james.imapserver.commands.LsubCommand@36ac0eCommand failure:
org.apache.james.imapserver.store.MailboxException: org.apache.james.mailboxmanager.MailboxManagerException: MailboxException caused by org.apache.torque.TorqueException: java.sql.SQLException: An internal error was identified by RawStore module.
at org.apache.james.imapserver.commands.ListCommand.doList(ListCommand.java:159)
at org.apache.james.imapserver.commands.LsubCommand.doList(LsubCommand.java:35)
at org.apache.james.imapserver.commands.ListCommand.doProcess(ListCommand.java:105)
at org.apache.james.imapserver.commands.CommandTemplate.process(CommandTemplate.java:67)
at org.apache.james.imapserver.ImapRequestHandler.doProcessRequest(ImapRequestHandler.java:139)
at org.apache.james.imapserver.ImapRequestHandler.handleRequest(ImapRequestHandler.java:80)
at org.apache.james.imapserver.ImapHandler.handleProtocol(ImapHandler.java:158)
at org.apache.james.core.AbstractJamesHandler.handleConnection(AbstractJamesHandler.java:255)
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: An internal error was identified by RawStore module.
at org.apache.james.mailboxmanager.torque.TorqueMailboxManager.list(TorqueMailboxManager.java:265)
at org.apache.james.imapserver.commands.ListCommand.doList(ListCommand.java:157)
... 10 more
Caused by: org.apache.torque.TorqueException: java.sql.SQLException: An internal error was identified by RawStore module.
at org.apache.torque.util.BasePeer.throwTorqueException(BasePeer.java:103)
at org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:899)
at org.apache.torque.util.BasePeer.doSelect(BasePeer.java:740)
at org.apache.torque.util.BasePeer.doSelect(BasePeer.java:702)
at org.apache.james.mailboxmanager.torque.om.BaseMailboxRowPeer.doSelectVillageRecords(BaseMailboxRowPeer.java:386)
at org.apache.james.mailboxmanager.torque.om.BaseMailboxRowPeer.doSelectVillageRecords(BaseMailboxRowPeer.java:359)
at org.apache.james.mailboxmanager.torque.om.BaseMailboxRowPeer.doSelect(BaseMailboxRowPeer.java:327)
at org.apache.james.mailboxmanager.torque.TorqueMailboxManager.list(TorqueMailboxManager.java:256)
... 11 more
Caused by: java.sql.SQLException: An internal error was identified by RawStore module.
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.execute(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeQuery(Unknown Source)
at com.workingdogs.village.QueryDataSet.<init>(QueryDataSet.java:113)
at org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:888)
... 17 more
02/12/06 19:55:50 INFO imapserver: COMMAND FAILED [null] A00002 - org.apache.james.mailboxmanager.MailboxManagerException: MailboxException caused by org.apache.torque.TorqueException: java.sql.SQLException: An internal error was identified by RawStore module.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org
[jira] Resolved: (JAMES-722) Torque SQL Exception - How Can I
Diagnose Cause?
Posted by "Robert Burrell Donkin (JIRA)" <se...@james.apache.org>.
[ http://issues.apache.org/jira/browse/JAMES-722?page=all ]
Robert Burrell Donkin resolved JAMES-722.
-----------------------------------------
Resolution: Cannot Reproduce
I haven't found a way to obtain good diagnostic messages for this output but I suspect that it was caused by out of memory issues. It has not reoccured since I increased the memory settings.
> Torque SQL Exception - How Can I Diagnose Cause?
> ------------------------------------------------
>
> Key: JAMES-722
> URL: http://issues.apache.org/jira/browse/JAMES-722
> Project: James
> Issue Type: Bug
> Components: IMAPServer
> Affects Versions: Trunk
> Reporter: Robert Burrell Donkin
>
> i'm getting a error when executing an LSUB command. any pointers to working out what the cause is...?
> 02/12/06 19:55:50 DEBUG imapserver: Got <tag>: A00002
> 02/12/06 19:55:50 DEBUG imapserver: Got <command>: LSUB
> 02/12/06 19:55:50 DEBUG imapserver: Parsed LSUB@1165089350035 duration(ms) 0
> 02/12/06 19:55:50 DEBUG imapserver: Created command class org.apache.james.imapserver.commands.LsubCommand
> 02/12/06 19:55:50 INFO imapserver: org.apache.james.imapserver.commands.LsubCommand@36ac0eCommand failure:
> org.apache.james.imapserver.store.MailboxException: org.apache.james.mailboxmanager.MailboxManagerException: MailboxException caused by org.apache.torque.TorqueException: java.sql.SQLException: An internal error was identified by RawStore module.
> at org.apache.james.imapserver.commands.ListCommand.doList(ListCommand.java:159)
> at org.apache.james.imapserver.commands.LsubCommand.doList(LsubCommand.java:35)
> at org.apache.james.imapserver.commands.ListCommand.doProcess(ListCommand.java:105)
> at org.apache.james.imapserver.commands.CommandTemplate.process(CommandTemplate.java:67)
> at org.apache.james.imapserver.ImapRequestHandler.doProcessRequest(ImapRequestHandler.java:139)
> at org.apache.james.imapserver.ImapRequestHandler.handleRequest(ImapRequestHandler.java:80)
> at org.apache.james.imapserver.ImapHandler.handleProtocol(ImapHandler.java:158)
> at org.apache.james.core.AbstractJamesHandler.handleConnection(AbstractJamesHandler.java:255)
> 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: An internal error was identified by RawStore module.
> at org.apache.james.mailboxmanager.torque.TorqueMailboxManager.list(TorqueMailboxManager.java:265)
> at org.apache.james.imapserver.commands.ListCommand.doList(ListCommand.java:157)
> ... 10 more
> Caused by: org.apache.torque.TorqueException: java.sql.SQLException: An internal error was identified by RawStore module.
> at org.apache.torque.util.BasePeer.throwTorqueException(BasePeer.java:103)
> at org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:899)
> at org.apache.torque.util.BasePeer.doSelect(BasePeer.java:740)
> at org.apache.torque.util.BasePeer.doSelect(BasePeer.java:702)
> at org.apache.james.mailboxmanager.torque.om.BaseMailboxRowPeer.doSelectVillageRecords(BaseMailboxRowPeer.java:386)
> at org.apache.james.mailboxmanager.torque.om.BaseMailboxRowPeer.doSelectVillageRecords(BaseMailboxRowPeer.java:359)
> at org.apache.james.mailboxmanager.torque.om.BaseMailboxRowPeer.doSelect(BaseMailboxRowPeer.java:327)
> at org.apache.james.mailboxmanager.torque.TorqueMailboxManager.list(TorqueMailboxManager.java:256)
> ... 11 more
> Caused by: java.sql.SQLException: An internal error was identified by RawStore module.
> 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.execute(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedStatement.executeQuery(Unknown Source)
> at com.workingdogs.village.QueryDataSet.<init>(QueryDataSet.java:113)
> at org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:888)
> ... 17 more
> 02/12/06 19:55:50 INFO imapserver: COMMAND FAILED [null] A00002 - org.apache.james.mailboxmanager.MailboxManagerException: MailboxException caused by org.apache.torque.TorqueException: java.sql.SQLException: An internal error was identified by RawStore module.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org
[jira] Commented: (JAMES-722) Torque SQL Exception - How Can I
Diagnose Cause?
Posted by "Robert Burrell Donkin (JIRA)" <se...@james.apache.org>.
[ http://issues.apache.org/jira/browse/JAMES-722?page=comments#action_12455134 ]
Robert Burrell Donkin commented on JAMES-722:
---------------------------------------------
Evolution shoves a load of commands down the pipe after login. It happened a couple of times just after it had finished it's full login cycle (which is much more than logging in).
Just turned streamdump off today (had been pretty stable for the last week or so) to do some performance logging :-/
Will turn streamdump back on again
I agree about printing the complete client commands to debug. If it's an unexpected exception, then it would be useful to print the command to info (say) if possible.
> Torque SQL Exception - How Can I Diagnose Cause?
> ------------------------------------------------
>
> Key: JAMES-722
> URL: http://issues.apache.org/jira/browse/JAMES-722
> Project: James
> Issue Type: Bug
> Components: IMAPServer
> Affects Versions: Trunk
> Reporter: Robert Burrell Donkin
>
> i'm getting a error when executing an LSUB command. any pointers to working out what the cause is...?
> 02/12/06 19:55:50 DEBUG imapserver: Got <tag>: A00002
> 02/12/06 19:55:50 DEBUG imapserver: Got <command>: LSUB
> 02/12/06 19:55:50 DEBUG imapserver: Parsed LSUB@1165089350035 duration(ms) 0
> 02/12/06 19:55:50 DEBUG imapserver: Created command class org.apache.james.imapserver.commands.LsubCommand
> 02/12/06 19:55:50 INFO imapserver: org.apache.james.imapserver.commands.LsubCommand@36ac0eCommand failure:
> org.apache.james.imapserver.store.MailboxException: org.apache.james.mailboxmanager.MailboxManagerException: MailboxException caused by org.apache.torque.TorqueException: java.sql.SQLException: An internal error was identified by RawStore module.
> at org.apache.james.imapserver.commands.ListCommand.doList(ListCommand.java:159)
> at org.apache.james.imapserver.commands.LsubCommand.doList(LsubCommand.java:35)
> at org.apache.james.imapserver.commands.ListCommand.doProcess(ListCommand.java:105)
> at org.apache.james.imapserver.commands.CommandTemplate.process(CommandTemplate.java:67)
> at org.apache.james.imapserver.ImapRequestHandler.doProcessRequest(ImapRequestHandler.java:139)
> at org.apache.james.imapserver.ImapRequestHandler.handleRequest(ImapRequestHandler.java:80)
> at org.apache.james.imapserver.ImapHandler.handleProtocol(ImapHandler.java:158)
> at org.apache.james.core.AbstractJamesHandler.handleConnection(AbstractJamesHandler.java:255)
> 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: An internal error was identified by RawStore module.
> at org.apache.james.mailboxmanager.torque.TorqueMailboxManager.list(TorqueMailboxManager.java:265)
> at org.apache.james.imapserver.commands.ListCommand.doList(ListCommand.java:157)
> ... 10 more
> Caused by: org.apache.torque.TorqueException: java.sql.SQLException: An internal error was identified by RawStore module.
> at org.apache.torque.util.BasePeer.throwTorqueException(BasePeer.java:103)
> at org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:899)
> at org.apache.torque.util.BasePeer.doSelect(BasePeer.java:740)
> at org.apache.torque.util.BasePeer.doSelect(BasePeer.java:702)
> at org.apache.james.mailboxmanager.torque.om.BaseMailboxRowPeer.doSelectVillageRecords(BaseMailboxRowPeer.java:386)
> at org.apache.james.mailboxmanager.torque.om.BaseMailboxRowPeer.doSelectVillageRecords(BaseMailboxRowPeer.java:359)
> at org.apache.james.mailboxmanager.torque.om.BaseMailboxRowPeer.doSelect(BaseMailboxRowPeer.java:327)
> at org.apache.james.mailboxmanager.torque.TorqueMailboxManager.list(TorqueMailboxManager.java:256)
> ... 11 more
> Caused by: java.sql.SQLException: An internal error was identified by RawStore module.
> 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.execute(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedStatement.executeQuery(Unknown Source)
> at com.workingdogs.village.QueryDataSet.<init>(QueryDataSet.java:113)
> at org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:888)
> ... 17 more
> 02/12/06 19:55:50 INFO imapserver: COMMAND FAILED [null] A00002 - org.apache.james.mailboxmanager.MailboxManagerException: MailboxException caused by org.apache.torque.TorqueException: java.sql.SQLException: An internal error was identified by RawStore module.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org
[jira] Commented: (JAMES-722) Torque SQL Exception - How Can I
Diagnose Cause?
Posted by "Joachim Draeger (JIRA)" <se...@james.apache.org>.
[ http://issues.apache.org/jira/browse/JAMES-722?page=comments#action_12455126 ]
Joachim Draeger commented on JAMES-722:
---------------------------------------
It sounds like a derby problem
After a quick google:
http://issues.apache.org/jira/browse/DERBY-1732
It could be an OOM.
But google brings different issues with no clear solution.
Can you reproduce it?
Does it happen immediately after Login?
What is the exact command line (from streamdump)?
BTW I think we should log complete client commands to debug...
We should upgrade to Torque 3.3-RC1 soon and check for a new derby release. If the error reoccurs, we could try out a costum derby build.
> Torque SQL Exception - How Can I Diagnose Cause?
> ------------------------------------------------
>
> Key: JAMES-722
> URL: http://issues.apache.org/jira/browse/JAMES-722
> Project: James
> Issue Type: Bug
> Components: IMAPServer
> Affects Versions: Trunk
> Reporter: Robert Burrell Donkin
>
> i'm getting a error when executing an LSUB command. any pointers to working out what the cause is...?
> 02/12/06 19:55:50 DEBUG imapserver: Got <tag>: A00002
> 02/12/06 19:55:50 DEBUG imapserver: Got <command>: LSUB
> 02/12/06 19:55:50 DEBUG imapserver: Parsed LSUB@1165089350035 duration(ms) 0
> 02/12/06 19:55:50 DEBUG imapserver: Created command class org.apache.james.imapserver.commands.LsubCommand
> 02/12/06 19:55:50 INFO imapserver: org.apache.james.imapserver.commands.LsubCommand@36ac0eCommand failure:
> org.apache.james.imapserver.store.MailboxException: org.apache.james.mailboxmanager.MailboxManagerException: MailboxException caused by org.apache.torque.TorqueException: java.sql.SQLException: An internal error was identified by RawStore module.
> at org.apache.james.imapserver.commands.ListCommand.doList(ListCommand.java:159)
> at org.apache.james.imapserver.commands.LsubCommand.doList(LsubCommand.java:35)
> at org.apache.james.imapserver.commands.ListCommand.doProcess(ListCommand.java:105)
> at org.apache.james.imapserver.commands.CommandTemplate.process(CommandTemplate.java:67)
> at org.apache.james.imapserver.ImapRequestHandler.doProcessRequest(ImapRequestHandler.java:139)
> at org.apache.james.imapserver.ImapRequestHandler.handleRequest(ImapRequestHandler.java:80)
> at org.apache.james.imapserver.ImapHandler.handleProtocol(ImapHandler.java:158)
> at org.apache.james.core.AbstractJamesHandler.handleConnection(AbstractJamesHandler.java:255)
> 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: An internal error was identified by RawStore module.
> at org.apache.james.mailboxmanager.torque.TorqueMailboxManager.list(TorqueMailboxManager.java:265)
> at org.apache.james.imapserver.commands.ListCommand.doList(ListCommand.java:157)
> ... 10 more
> Caused by: org.apache.torque.TorqueException: java.sql.SQLException: An internal error was identified by RawStore module.
> at org.apache.torque.util.BasePeer.throwTorqueException(BasePeer.java:103)
> at org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:899)
> at org.apache.torque.util.BasePeer.doSelect(BasePeer.java:740)
> at org.apache.torque.util.BasePeer.doSelect(BasePeer.java:702)
> at org.apache.james.mailboxmanager.torque.om.BaseMailboxRowPeer.doSelectVillageRecords(BaseMailboxRowPeer.java:386)
> at org.apache.james.mailboxmanager.torque.om.BaseMailboxRowPeer.doSelectVillageRecords(BaseMailboxRowPeer.java:359)
> at org.apache.james.mailboxmanager.torque.om.BaseMailboxRowPeer.doSelect(BaseMailboxRowPeer.java:327)
> at org.apache.james.mailboxmanager.torque.TorqueMailboxManager.list(TorqueMailboxManager.java:256)
> ... 11 more
> Caused by: java.sql.SQLException: An internal error was identified by RawStore module.
> 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.execute(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedStatement.executeQuery(Unknown Source)
> at com.workingdogs.village.QueryDataSet.<init>(QueryDataSet.java:113)
> at org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:888)
> ... 17 more
> 02/12/06 19:55:50 INFO imapserver: COMMAND FAILED [null] A00002 - org.apache.james.mailboxmanager.MailboxManagerException: MailboxException caused by org.apache.torque.TorqueException: java.sql.SQLException: An internal error was identified by RawStore module.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org