#749 SQLEXCEPTION SENDING EMAIL

[Sergio Montoro Ten]

When trying to send an email the following SQLException is thrown:

javax.mail.MessagingException: javax.mail.MessagingException MimeMessage.getContent() ERROR: insert or update on table "k_mime_parts" violates foreign key constraint "f1_mime_parts"
Detail: Key (gu_mimemsg)=(ac1263a412e6374a224100000f4f9c87) is not present in table "k_mime_msgs".;
nested exception is:
javax.mail.MessagingException: MimeMessage.getContent() ERROR: insert or update on table "k_mime_parts" violates foreign key constraint "f1_mime_parts"
Detail: Key (gu_mimemsg)=(ac1263a412e6374a224100000f4f9c87) is not present in table "k_mime_msgs".;
nested exception is:
javax.mail.MessagingException: ERROR: insert or update on table "k_mime_parts" violates foreign key constraint "f1_mime_parts"
Detail: Key (gu_mimemsg)=(ac1263a412e6374a224100000f4f9c87) is not present in table "k_mime_msgs".;
nested exception is:
org.postgresql.util.PSQLException: ERROR: insert or update on table "k_mime_parts" violates foreign key constraint "f1_mime_parts"
Detail: Key (gu_mimemsg)=(ac1263a412e6374a224100000f4f9c87) is not present in table "k_mime_msgs".
at com.knowgate.hipermail.DBFolder.appendMessage(DBFolder.java:2542)
at com.knowgate.hipermail.DBFolder.appendMessages(DBFolder.java:199)
at org.apache.jsp.hipermail.msg_005fsend_jsp._jspService(msg_005fsend_jsp.java:1254)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
at java.lang.Thread.run(Unknown Source)
Caused by: javax.mail.MessagingException: MimeMessage.getContent() ERROR: insert or update on table "k_mime_parts" violates foreign key constraint "f1_mime_parts"
Detail: Key (gu_mimemsg)=(ac1263a412e6374a224100000f4f9c87) is not present in table "k_mime_msgs".;
nested exception is:
javax.mail.MessagingException: ERROR: insert or update on table "k_mime_parts" violates foreign key constraint "f1_mime_parts"
Detail: Key (gu_mimemsg)=(ac1263a412e6374a224100000f4f9c87) is not present in table "k_mime_msgs".;
nested exception is:
org.postgresql.util.PSQLException: ERROR: insert or update on table "k_mime_parts" violates foreign key constraint "f1_mime_parts"
Detail: Key (gu_mimemsg)=(ac1263a412e6374a224100000f4f9c87) is not present in table "k_mime_msgs".
at com.knowgate.hipermail.DBFolder.indexMessage(DBFolder.java:1950)
at com.knowgate.hipermail.DBFolder.appendMessage(DBFolder.java:2486)
... 21 more
Caused by: javax.mail.MessagingException: ERROR: insert or update on table "k_mime_parts" violates foreign key constraint "f1_mime_parts"
Detail: Key (gu_mimemsg)=(ac1263a412e6374a224100000f4f9c87) is not present in table "k_mime_msgs".;
nested exception is:
org.postgresql.util.PSQLException: ERROR: insert or update on table "k_mime_parts" violates foreign key constraint "f1_mime_parts"