Error Log

[Mike_R]

I'm seeing a lot of this message in the error log and trying to figure out what's causing it. Does anyone have any insight?

I see the error every few minutes

FAILED TRYING TO EXECUTE ON CONNECTION glide.5 (connpid=1156079): INSERT INTO sys_api_stats_whitelist (`collect_requestor_stats`,`sys_id`,`sys_updated_by`,`api_name`,`sys_created_on`,`sys_mod_count`,`collect_api_stats`,`sys_updated_on`,`sys_created_by`) VALUES(0,'48ca45dd1bf588504e6186ecdc4bcb38','guest','now/cmdbhealth','2019-12-17 13:27:19',0,1,'2019-12-17 13:27:19','guest') /* fhlbny008 */
Unique Key violation detected by database (Duplicate entry 'now/cmdbhealth' for key 'api_name_2')
: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry 'now/cmdbhealth' for key 'api_name_2': org.mariadb.jdbc.internal.SQLExceptionMapper.get(SQLExceptionMapper.java:132)
org.mariadb.jdbc.internal.SQLExceptionMapper.throwException(SQLExceptionMapper.java:106)
org.mariadb.jdbc.MySQLStatement.executeQueryEpilog(MySQLStatement.java:274)
org.mariadb.jdbc.MySQLStatement.execute(MySQLStatement.java:302)
org.mariadb.jdbc.MySQLStatement.execute(MySQLStatement.java:393)
sun.reflect.GeneratedMethodAccessor20.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:498)
com.glide.db.StatementWrapper.invoke(StatementWrapper.java:40)
com.sun.proxy.$Proxy12.execute(Unknown Source)
com.glide.db.DBI.executeStatement0(DBI.java:1102)
com.glide.db.DBI.executeStatement(DBI.java:1058)
com.glide.db.DBI.executeStatement(DBI.java:1011)
com.glide.db.DBAction.executeAsResultSet(DBAction.java:284)
com.glide.db.DBCompositeAction.executeAsResultSet(DBCompositeAction.java:178)
com.glide.db.DBCompositeAction.executeChunk(DBCompositeAction.java:138)
com.glide.db.DBCompositeAction.executeAsResultSet0(DBCompositeAction.java:100)
com.glide.db.DBAction.executeAndReturnTable(DBAction.java:247)
com.glide.db.DBAction.executeNormal(DBAction.java:236)
com.glide.db.DBAction.executeAndReturnException(DBAction.java:190)
com.glide.script.GlideRecordITable.insert(GlideRecordITable.java:144)
com.glide.script.GlideRecord.insert(GlideRecord.java:4848)
com.glide.script.GlideRecord.insert(GlideRecord.java:4765)
com.glide.db.stats.transaction.api.whitelist.APIStatsWhitelist.persist(APIStatsWhitelist.java:157)
com.glide.db.stats.transaction.api.APIMetricStatsListener.persist(APIMetricStatsListener.java:74)
com.glide.db.stats.AbstractMetricStats.persist(AbstractMetricStats.java:35)
com.glide.db.stats.AbstractMetricStats.persist(AbstractMetricStats.java:31)
com.glide.db.stats.transaction.api.APIStatsSweeperJob.run(APIStatsSweeperJob.java:27)
com.glide.db.pool.DBPoolSweeperJobStatus.run(DBPoolSweeperJobStatus.java:36)
com.glide.db.pool.DBConnectionPoolSweeper$JobRunner.run(DBConnectionPoolSweeper.java:55)
java.lang.Thread.run(Thread.java:748)

[Jeff Currier · Accepted solution]

It would appear that an interface or job is trying up to update the API Stats whitelist table for the API now/cmdbhealth and it is already there thus trying to create a duplicate.  If you can find this job, you may need to correct it, but I think I would raise a case with ServiceNow support in Hi and have them look at this.