1 Reply Latest reply: Nov 23, 2012 3:37 AM by EJP RSS

    STAT command failed occasionally

    user10391851
      Hi,
      I'm using Apache James 2.3.2 as my mail server with all data stored into database(Oracle11g). All seems good until I got some complains that some users cannot receive mails. I checked it out and found that it is the STAT command failed(both in my client application and the telnet):
      ------------------
      c:\>telnet hlrdwd.com 110
      +OK csmis POP3 server <JAMES POP3 Server 2.3.2> ready
      user chaixufa
      +OK
      pass 123456
      +OK Welcome chaixufa
      stat
      -ERR
      stat
      -ERR
      stat
      +OK 164 404317
      top 1 0
      +OK Message follows
      ...

      James' logs got exceptions that should not happen. Because I'm quite sure there's no problem about james' config, data-source, database, connections, etc.
      ------------------------
      21/11/12 14:39:16 ERROR pop3server: Unable to STAT mail box
      javax.mail.MessagingException: Exception while retrieving mail: Listener refused the connection with the following error:
      ORA-12519, TNS:no appropriate service handler found
      The Connection descriptor used by the client was:
      192.168.250.23:1521:csmis

           at org.apache.james.mailrepository.JDBCMailRepository.retrieve(JDBCMailRepository.java:918)
           at org.apache.james.pop3server.POP3Handler.stat(POP3Handler.java:399)
           at org.apache.james.pop3server.POP3Handler.doPASS(POP3Handler.java:547)
           at org.apache.james.pop3server.POP3Handler.parseCommand(POP3Handler.java:479)
           at org.apache.james.pop3server.POP3Handler.handleConnection(POP3Handler.java:277)
           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)
      21/11/12 14:39:16 INFO pop3server: Connection for chaixufa from 127.0.0.1 (127.0.0.1) closed.

      All applications running on the same server and there's only me using it when testing it. The error occurs usually when there are a lot of mails in INBOX(more than 40). I can't find the reason, all should be good.

      Please help!