[email protected] ha scritto: > See Thread at: http://www.techienuggets.com/Detail?tx=84165 Posted on behalf > of a User > > MySQL: 5.0.51B Community > Connector: mysql-connector-java-5.1.6-bin.jar > > Thanks!
I never had this error reading inboxes, but it seems the db connection is lost. Maybe you have some timeout on the db connection or anything else. Is there anything else on the same db? Did you make any special configuration to james/mysql ? The error seems to be in the SMTPServer so it is completely unrelated to the number of messages being in the INBOX (managed by the POP3Sever)... Can you paste your config.xml? (did you change threads/connections?) Stefano > In Response To: > > What's your mysql version and your mysql connector/j version? > > Stefano > > [email protected] ha scritto: >> See Thread at: http://www.techienuggets.com/Detail?tx=84165 Posted on behalf >> of a User >> >> Hi, >> >> I'm running James 2.3.1. Sometimes I have this bizarre error where my pop3 >> client (Outlook Express) gives an exception: >> >> An unknown error has occurred. Subject '', Account: 'mail.twinix.com', >> Server: 'mail.twinix.com', Protocol: SMTP, Server Response: '451 4.0.0 Error >> processing message.', Port: 25, Secure(SSL): No, Server Error: 451, Error >> Number: 0x800CCC6A >> >> When I look in the James logs I see the following: >> >> In the smtp server log: >> >> javax.mail.MessagingException: Exception spooling message: Exception caught >> while storing mail Container: ; >> nested exception is: >> javax.mail.MessagingException: Exception caught while storing mail >> Container: ; >> nested exception is: >> com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: >> Could not create connection to database server. Attempted reconnect 3 times. >> Giving up.; >> nested exception is: >> com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: >> Could not create connection to database server. Attempted reconnect 3 times. >> Giving up. >> at org.apache.james.James.sendMail(James.java:501) >> at sun.reflect.GeneratedMethodAccessor12.invoke(Unknown Source) >> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) >> at java.lang.reflect.Method.invoke(Unknown Source) >> at >> org.apache.avalon.phoenix.components.application.BlockInvocationHandler.invoke(BlockInvocationHandler.java:134) >> at $Proxy9.sendMail(Unknown Source) >> at >> org.apache.james.smtpserver.SendMailHandler.onMessage(SendMailHandler.java:62) >> at >> org.apache.james.smtpserver.SMTPHandler.handleConnection(SMTPHandler.java:410) >> at >> org.apache.james.util.connection.ServerConnection$ClientConnectionRunner.run(ServerConnection.java:432) >> at >> org.apache.excalibur.thread.impl.ExecutableRunnable.execute(ExecutableRunnable.java:55) >> at >> org.apache.excalibur.thread.impl.WorkerThread.run(WorkerThread.java:116) >> Caused by: javax.mail.MessagingException: Exception caught while storing >> mail Container: ; >> nested exception is: >> com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: >> Could not create connection to database server. Attempted reconnect 3 times. >> Giving up. >> at >> org.apache.james.mailrepository.JDBCMailRepository.store(JDBCMailRepository.java:764) >> at >> org.apache.james.mailrepository.JDBCSpoolRepository.store(JDBCSpoolRepository.java:240) >> at >> org.apache.james.mailrepository.MailStoreSpoolRepository.store(MailStoreSpoolRepository.java:126) >> at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source) >> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) >> at java.lang.reflect.Method.invoke(Unknown Source) >> at >> org.apache.avalon.phoenix.components.application.BlockInvocationHandler.invoke(BlockInvocationHandler.java:134) >> at $Proxy5.store(Unknown Source) >> at org.apache.james.James.sendMail(James.java:493) >> ... 10 more >> Caused by: >> com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could >> not create connection to database server. Attempted reconnect 3 times. >> Giving up. >> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) >> at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) >> at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown >> Source) >> at java.lang.reflect.Constructor.newInstance(Unknown Source) >> at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) >> at com.mysql.jdbc.Util.getInstance(Util.java:381) >> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984) >> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) >> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) >> at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2253) >> at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:718) >> at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46) >> at sun.reflect.GeneratedConstructorAccessor9.newInstance(Unknown Source) >> at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown >> Source) >> at java.lang.reflect.Constructor.newInstance(Unknown Source) >> at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) >> at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302) >> at >> com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282) >> at >> org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37) >> at >> org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290) >> at >> org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:771) >> at >> org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95) >> at >> org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540) >> at >> org.apache.james.util.dbcp.JdbcDataSource.getConnection(JdbcDataSource.java:220) >> at >> org.apache.james.mailrepository.JDBCMailRepository.store(JDBCMailRepository.java:555) >> ... 18 more >> Caused by: java.net.BindException: Address already in use: connect >> at java.net.PlainSocketImpl.socketConnect(Native Method) >> at java.net.PlainSocketImpl.doConnect(Unknown Source) >> at java.net.PlainSocketImpl.connectToAddress(Unknown Source) >> at java.net.PlainSocketImpl.connect(Unknown Source) >> at java.net.SocksSocketImpl.connect(Unknown Source) >> at java.net.Socket.connect(Unknown Source) >> at java.net.Socket.connect(Unknown Source) >> at java.net.Socket.<init>(Unknown Source) >> at java.net.Socket.<init>(Unknown Source) >> at >> com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:253) >> at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:280) >> at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2177) >> ... 33 more >> >> In the James log: >> >> 06/05/09 19:38:48 ERROR James: Error storing message: Exception caught while >> storing mail Container: >> javax.mail.MessagingException: Exception caught while storing mail >> Container: ; >> nested exception is: >> com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: >> Could not create connection to database server. Attempted reconnect 3 times. >> Giving up. >> at >> org.apache.james.mailrepository.JDBCMailRepository.store(JDBCMailRepository.java:764) >> at >> org.apache.james.mailrepository.JDBCSpoolRepository.store(JDBCSpoolRepository.java:240) >> at >> org.apache.james.mailrepository.MailStoreSpoolRepository.store(MailStoreSpoolRepository.java:126) >> at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source) >> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) >> at java.lang.reflect.Method.invoke(Unknown Source) >> at >> org.apache.avalon.phoenix.components.application.BlockInvocationHandler.invoke(BlockInvocationHandler.java:134) >> at $Proxy5.store(Unknown Source) >> at org.apache.james.James.sendMail(James.java:493) >> at sun.reflect.GeneratedMethodAccessor12.invoke(Unknown Source) >> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) >> at java.lang.reflect.Method.invoke(Unknown Source) >> at >> org.apache.avalon.phoenix.components.application.BlockInvocationHandler.invoke(BlockInvocationHandler.java:134) >> at $Proxy9.sendMail(Unknown Source) >> at >> org.apache.james.smtpserver.SendMailHandler.onMessage(SendMailHandler.java:62) >> at >> org.apache.james.smtpserver.SMTPHandler.handleConnection(SMTPHandler.java:410) >> at >> org.apache.james.util.connection.ServerConnection$ClientConnectionRunner.run(ServerConnection.java:432) >> at >> org.apache.excalibur.thread.impl.ExecutableRunnable.execute(ExecutableRunnable.java:55) >> at >> org.apache.excalibur.thread.impl.WorkerThread.run(WorkerThread.java:116) >> Caused by: >> com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could >> not create connection to database server. Attempted reconnect 3 times. >> Giving up. >> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) >> at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) >> at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown >> Source) >> at java.lang.reflect.Constructor.newInstance(Unknown Source) >> at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) >> at com.mysql.jdbc.Util.getInstance(Util.java:381) >> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984) >> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) >> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) >> at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2253) >> at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:718) >> at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46) >> at sun.reflect.GeneratedConstructorAccessor9.newInstance(Unknown Source) >> at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown >> Source) >> at java.lang.reflect.Constructor.newInstance(Unknown Source) >> at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) >> at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302) >> at >> com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282) >> at >> org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37) >> at >> org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290) >> at >> org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:771) >> at >> org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95) >> at >> org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540) >> at >> org.apache.james.util.dbcp.JdbcDataSource.getConnection(JdbcDataSource.java:220) >> at >> org.apache.james.mailrepository.JDBCMailRepository.store(JDBCMailRepository.java:555) >> ... 18 more >> Caused by: java.net.BindException: Address already in use: connect >> at java.net.PlainSocketImpl.socketConnect(Native Method) >> at java.net.PlainSocketImpl.doConnect(Unknown Source) >> at java.net.PlainSocketImpl.connectToAddress(Unknown Source) >> at java.net.PlainSocketImpl.connect(Unknown Source) >> at java.net.SocksSocketImpl.connect(Unknown Source) >> at java.net.Socket.connect(Unknown Source) >> at java.net.Socket.connect(Unknown Source) >> at java.net.Socket.<init>(Unknown Source) >> at java.net.Socket.<init>(Unknown Source) >> at >> com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:253) >> at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:280) >> at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2177) >> ... 33 more >> 06/05/09 19:39:30 ERROR James: Error storing message: Exception caught while >> storing mail Container: >> javax.mail.MessagingException: Exception caught while storing mail >> Container: ; >> nested exception is: >> com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: >> Could not create connection to database server. Attempted reconnect 3 times. >> Giving up. >> at >> org.apache.james.mailrepository.JDBCMailRepository.store(JDBCMailRepository.java:764) >> at >> org.apache.james.mailrepository.JDBCSpoolRepository.store(JDBCSpoolRepository.java:240) >> at >> org.apache.james.mailrepository.MailStoreSpoolRepository.store(MailStoreSpoolRepository.java:126) >> at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source) >> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) >> at java.lang.reflect.Method.invoke(Unknown Source) >> at >> org.apache.avalon.phoenix.components.application.BlockInvocationHandler.invoke(BlockInvocationHandler.java:134) >> at $Proxy5.store(Unknown Source) >> at org.apache.james.James.sendMail(James.java:493) >> at sun.reflect.GeneratedMethodAccessor12.invoke(Unknown Source) >> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) >> at java.lang.reflect.Method.invoke(Unknown Source) >> at >> org.apache.avalon.phoenix.components.application.BlockInvocationHandler.invoke(BlockInvocationHandler.java:134) >> at $Proxy9.sendMail(Unknown Source) >> at >> org.apache.james.smtpserver.SendMailHandler.onMessage(SendMailHandler.java:62) >> at >> org.apache.james.smtpserver.SMTPHandler.handleConnection(SMTPHandler.java:410) >> at >> org.apache.james.util.connection.ServerConnection$ClientConnectionRunner.run(ServerConnection.java:432) >> at >> org.apache.excalibur.thread.impl.ExecutableRunnable.execute(ExecutableRunnable.java:55) >> at >> org.apache.excalibur.thread.impl.WorkerThread.run(WorkerThread.java:116) >> Caused by: >> com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could >> not create connection to database server. Attempted reconnect 3 times. >> Giving up. >> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) >> at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) >> at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown >> Source) >> at java.lang.reflect.Constructor.newInstance(Unknown Source) >> at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) >> at com.mysql.jdbc.Util.getInstance(Util.java:381) >> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984) >> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) >> at com.mysql.jdbc.SQLError.create >> >> The only thing that I can see is the user of the pop3 account has almost >> 2500 emails pending. The only way I have been able to fix this problem is to >> delete half the emails from the in box (Mysql table). Then everything starts >> to work. I'm not sure if there's a single rogue email that's causing the >> problem or is it the number of emails? >> >> Thanks for any help. >> >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [email protected] >> For additional commands, e-mail: [email protected] >> >> > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
