We are currently running fwa in our environment, all is running fine. Except when we openend up our logfile serverout0.txt
Every few mins it displays a java.exception error with the message of duplicate key or integrity check:
[13:07:39:970]|[11-11-2005]|[SYSOUT]|[INFO]|[23]|: Caused by: java.sql.SQLException: Duplicate key or integrity constraint violation message from server: "Cannot add or update a child row: a foreign key constraint fails"| [13:07:39:970]|[11-11-2005]|[SYSOUT]|[INFO]|[23]|: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1990)| [13:07:39:970]|[11-11-2005]|[SYSOUT]|[INFO]|[23]|: at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1160)| [13:07:39:970]|[11-11-2005]|[SYSOUT]|[INFO]|[23]|: at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1271)| [13:07:39:970]|[11-11-2005]|[SYSOUT]|[INFO]|[23]|: at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1217)| [13:07:39:970]|[11-11-2005]|[SYSOUT]|[INFO]|[23]|: at com.mysql.jdbc.Connection.execSQL(Connection.java:2237)| [13:07:39:970]|[11-11-2005]|[SYSOUT]|[INFO]|[23]|: at com.mysql.jdbc.Connection.execSQL(Connection.java:2185)| [13:07:39:970]|[11-11-2005]|[SYSOUT]|[INFO]|[23]|: at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1252)| [13:07:39:970]|[11-11-2005]|[SYSOUT]|[INFO]|[23]|: at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1198)| [13:07:39:970]|[11-11-2005]|[SYSOUT]|[INFO]|[23]|: at org.jboss.resource.adapter.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:272)| [13:07:39:970]|[11-11-2005]|[SYSOUT]|[INFO]|[23]|: at com.adventnet.la.util.QueryUtil.executeUpdate(QueryUtil.java:106)| [13:07:39:970]|[11-11-2005]|[SYSOUT]|[INFO]|[23]|: ... 17 more|