DerbySQLIntegrityConstraintViolationException 문의

[moonkoo88]

안녕하세요

문의가 있어 글 남깁니다.

Reporting

ext_plugin_reporting_drop_table=ture
ext_plugin_reporting_logging_enabled=false
ext_plugin_reporting_max_elapsed_time=5000
ext_plugin_reporting_output_dir=/websvc/scouter-all-2.5.1/scouter/report
ext_plugin_reporting_application_name=SPC-IN
ext_plugin_reporting_excel_export=true

스카우트 서버 재부팅 시 로그를 확인해 보니 아래와 같은 로그가 반복적으로 찍히고 있습니다.

해당 오류 조치는 어떻게 해야 하는지 알 수 있을까요?

감사합니다.

### Error updating database.  Cause: org.apache.derby.shared.common.error.DerbySQLIntegrityConstraintViolationException: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL190917155829212' defined on 'SQL_5M_17'.
### The error may involve Scouter.insertSql-Inline
### The error occurred while setting parameters
### SQL: INSERT INTO SQL_5M_17                (OBJECT_HASH,                  SQL_HASH,                  LOG_DT,                  LOG_TM,                  EXECUTE_COUNT,                  ERROR_COUNT,                  ELAPSED)         VALUES (?,                  ?,                  ?,                  ?,                  ?,                  ?,                  ?)
### Cause: org.apache.derby.shared.common.error.DerbySQLIntegrityConstraintViolationException: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL190917155829212' defined on 'SQL_5M_17'.
	at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:200)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:185)
	at scouter.plugin.server.reporting.ReportingPlugin.summary(ReportingPlugin.java:866)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at scouter.server.plugin.builtin.PluginInvocation.process(PluginInvocation.java:22)
	at scouter.server.plugin.builtin.BuiltInPluginManager.invokeAllPlugins(BuiltInPluginManager.java:72)
	at scouter.server.plugin.PlugInManager.summary(PlugInManager.java:114)
	at scouter.server.core.SummaryCore$$anonfun$1.apply$mcV$sp(SummaryCore.scala:31)
	at scouter.server.util.ThreadScala$$anon$1.run(ThreadScala.scala:12)
Caused by: org.apache.derby.shared.common.error.DerbySQLIntegrityConstraintViolationException: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL190917155829212' defined on 'SQL_5M_17'.
	at org.apache.derby.client.am.SQLExceptionFactory.getSQLException(Unknown Source)
	at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
	at org.apache.derby.client.am.ClientPreparedStatement.execute(Unknown Source)
	at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:46)
	at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74)
	at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50)
	at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
	at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:198)
	... 11 more
Caused by: ERROR 23505: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL190917155829212' defined on 'SQL_5M_17'.
	at org.apache.derby.client.am.ClientStatement.completeExecute(Unknown Source)
	at org.apache.derby.client.net.NetStatementReply.parseEXCSQLSTTreply(Unknown Source)
	at org.apache.derby.client.net.NetStatementReply.readExecute(Unknown Source)
	at org.apache.derby.client.net.StatementReply.readExecute(Unknown Source)
	at org.apache.derby.client.net.NetPreparedStatement.readExecute_(Unknown Source)
	at org.apache.derby.client.am.ClientPreparedStatement.readExecute(Unknown Source)
	at org.apache.derby.client.am.ClientPreparedStatement.flowExecute(Unknown Source)
	at org.apache.derby.client.am.ClientPreparedStatement.executeX(Unknown Source)
	... 18 more