AT Server requires restart every morning
Every morning we come in to start the day and we have to restart the AT service to get connected. Connecting directly to MySQL is fine which suggests that it is the AT Server which is failing.
Any ideas? Below is a sample of the log file (which is filled with the same error, just differnt key each time)
org.apache.lucene.store.jdbc.JdbcStoreException: Failed to execute sql [insert into lucene_index (name_, value_, size_, lf_, deleted_) values ( ?, ?, ?, current_timestamp, ? )]; nested exception is com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry '_1036.fnm' for key 1
INFO | jvm 1 | 2008/09/03 19:35:08 | com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry '_1036.fnm' for key 1
INFO | jvm 1 | 2008/09/03 19:35:08 | at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931)
INFO | jvm 1 | 2008/09/03 19:35:08 | at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
INFO | jvm 1 | 2008/09/03 19:35:08 | at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
INFO | jvm 1 | 2008/09/03 19:35:08 | at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
INFO | jvm 1 | 2008/09/03 19:35:08 | at com.mysql.jdbc.Connection.execSQL(Connection.java:3176)
INFO | jvm 1 | 2008/09/03 19:35:08 | at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1153)
INFO | jvm 1 | 2008/09/03 19:35:08 | at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1404)
INFO | jvm 1 | 2008/09/03 19:35:08 | at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1318)
INFO | jvm 1 | 2008/09/03 19:35:08 | at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1303)
INFO | jvm 1 | 2008/09/03 19:35:08 | at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
INFO | jvm 1 | 2008/09/03 19:35:08 | at org.apache.lucene.store.jdbc.support.JdbcTemplate.executeUpdate(JdbcTemplate.java:159)
INFO | jvm 1 | 2008/09/03 19:35:08 | at org.apache.lucene.store.jdbc.index.AbstractJdbcIndexOutput.close(AbstractJdbcIndexOutput.java:47)
INFO | jvm 1 | 2008/09/03 19:35:08 | at org.apache.lucene.index.FieldInfos.write(FieldInfos.java:259)
INFO | jvm 1 | 2008/09/03 19:35:08 | at org.apache.lucene.index.SegmentMerger.mergeFields(SegmentMerger.java:176)
INFO | jvm 1 | 2008/09/03 19:35:08 | at org.apache.lucene.index.SegmentMerger.merge(SegmentMerger.java:88)
INFO | jvm 1 | 2008/09/03 19:35:08 | at org.apache.lucene.index.IndexWriter.mergeSegments(IndexWriter.java:709)
INFO | jvm 1 | 2008/09/03 19:35:08 | at org.apache.lucene.index.IndexWriter.mergeSegments(IndexWriter.java:686)
INFO | jvm 1 | 2008/09/03 19:35:08 | at org.apache.lucene.index.IndexWriter.flushRamSegments(IndexWriter.java:656)
INFO | jvm 1 | 2008/09/03 19:35:08 | at org.apache.lucene.index.IndexWriter.close(IndexWriter.java:402)
INFO | jvm 1 | 2008/09/03 19:35:08 | at agiletrack.server.persistence.GenericFullTextIndexer.closeWriter(GenericFullTextIndexer.java:78)
Mark
—Posted by Software on Sep 4, 2008
|