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]
