ServiceNowDevProgram / sn-slack-points-thing

[Deprecated, see readme] Repository for the Points Thing Slack Bot Running on ServiceNow
9 stars 34 forks source link

Fix "Failed trying to execute on connection" error in system log #34

Open earlduque opened 3 years ago

earlduque commented 3 years ago

269 instance of this error appeared last week:

FAILED TRYING TO EXECUTE ON CONNECTION glide.1 (connpid=61047): INSERT INTO x_snc_slack_points_point (sys_id,sys_updated_by,sys_created_on,sys_mod_count,source_event,text,sys_updated_on,giver,sys_created_by,target) VALUES('b6dd4161dbc3245051d3f9627596192a','guest','2021-03-22 04:00:11',0,'72dd89eddbcba450791d8f8d1396198f','Thanks for that, man! <@U9QB5VDLN> ++','2021-03-22 04:00:11','U2GNPH4F3','guest','f0286e31133b5300973e70d66144b09c') / devprogramresources006, gs:glide.scheduler.worker.0, tx:3edd4161dbc3245051d3f96275961928 / Unique Key violation detected by database ((conn=61047) Duplicate entry 'b6dd4161dbc3245051d3f9627596192a' for key 'PRIMARY') : java.sql.SQLIntegrityConstraintViolationException: (conn=61047) Duplicate entry 'b6dd4161dbc3245051d3f9627596192a' for key 'PRIMARY': org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:229) org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:165) org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:238) org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:355) org.mariadb.jdbc.MariaDbStatement.execute(MariaDbStatement.java:406) 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:38) com.glide.db.AConnectionWrapperProxy.invoke(AConnectionWrapperProxy.java:33) com.glide.db.StatementWrapper.invoke(StatementWrapper.java:18) com.sun.proxy.$Proxy24.execute(Unknown Source) com.glide.db.DBI.executeStatement0(DBI.java:1129) com.glide.db.DBI.executeStatement(DBI.java:1085) com.glide.db.DBI.executeStatement(DBI.java:1038) com.glide.db.DBAction.executeAsResultSet(DBAction.java:304) com.glide.db.DBCompositeAction.executeAsResultSet(DBCompositeAction.java:213) com.glide.db.DBCompositeAction.executeChunk(DBCompositeAction.java:173) com.glide.db.DBCompositeAction.executeAsResultSet0(DBCompositeAction.java:108) com.glide.db.DBAction.executeAndReturnTable(DBAction.java:267) com.glide.db.DBAction.executeNormal(DBAction.java:256) com.glide.db.DBAction.executeAndReturnException(DBAction.java:210) com.glide.script.GlideRecordITable.insert(GlideRecordITable.java:158) com.glide.script.GlideRecord.insert(GlideRecord.java:4971) com.glide.script.GlideRecord.insert(GlideRecord.java:4881) com.glide.script.GlideRecord.jsFunction_insert(GlideRecord.java:5425) com.glide.script.fencing.ScopedGlideRecord.jsFunction_insert(ScopedGlideRecord.java:163) sun.reflect.GeneratedMethodAccessor313.invoke(Unknown Source) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.lang.reflect.Method.invoke(Method.java:498) org.mozilla.javascript.MemberBox.invoke(MemberBox.java:138) org.mozilla.javascript.FunctionObject.doInvoke(FunctionObject.java:670) org.mozilla.javascript.FunctionObject.call(FunctionObject.java:614) org.mozilla.javascript.ScriptRuntime.doCall(ScriptRuntime.java:2609) org.mozilla.javascript.optimizer.OptRuntime.callProp0(OptRuntime.java:85) org.mozilla.javascript.gen.sys_script_f79200dc13444f009718b9b76144b037_script_573._c_anonymous_2(sys_script.f79200dc13444f009718b9b76144b037.script:50) org.mozilla.javascript.gen.sys_script_f79200dc13444f009718b9b76144b037_script_573.call(sys_script.f79200dc13444f009718b9b76144b037.script) org.mozilla.javascript.ScriptRuntime.doCall2(ScriptRuntime.java:2678) org.mozilla.javascript.ScriptRuntime.doCall(ScriptRuntime.java:2617) org.mozilla.javascript.NativeArray.iterativeMethod(NativeArray.java:1596) org.mozilla.javascript.NativeArray.execIdCall(NativeArray.java:320) org.mozilla.javascript.IdFunctionObject.call(IdFunctionObject.java:102) org.mozilla.javascript.ScriptRuntime.doCall2(ScriptRuntime.java:2678) org.mozilla.javascript.ScriptRuntime.doCall(ScriptRuntime.java:2617) org.mozilla.javascript.optimizer.OptRuntime.call1(OptRuntime.java:32) org.mozilla.javascript.gen.sys_script_f79200dc13444f009718b9b76144b037_script_573._c_executeRule_1(sys_script.f79200dc13444f009718b9b76144b037.script:15) org.mozilla.javascript.gen.sys_script_f79200dc13444f009718b9b76144b037_script_573.call(sys_script.f79200dc13444f009718b9b76144b037.script) org.mozilla.javascript.ScriptRuntime.doCall2(ScriptRuntime.java:2678) org.mozilla.javascript.ScriptRuntime.doCall(ScriptRuntime.java:2617) org.mozilla.javascript.optimizer.OptRuntime.call2(OptRuntime.java:42) org.mozilla.javascript.gen.sys_script_f79200dc13444f009718b9b76144b037_script_573._c_script_0(sys_script.f79200dc13444f009718b9b76144b037.script:1) org.mozilla.javascript.gen.sys_script_f79200dc13444f009718b9b76144b037_script_573.call(sys_script.f79200dc13444f009718b9b76144b037.script) org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:563) org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3459) org.mozilla.javascript.gen.sys_script_f79200dc13444f009718b9b76144b037_script_573.call(sys_script.f79200dc13444f009718b9b76144b037.script) org.mozilla.javascript.gen.sys_script_f79200dc13444f009718b9b76144b037_script_573.exec(sys_script.f79200dc13444f009718b9b76144b037.script) com.glide.script.ScriptEvaluator.execute(ScriptEvaluator.java:279) com.glide.script.ScriptEvaluator.evaluateString(ScriptEvaluator.java:118) com.glide.script.ScriptEvaluator.evaluateString(ScriptEvaluator.java:82) com.glide.script.Evaluator.evaluatePossiblePrefixedString(Evaluator.java:210) com.glide.job.RunScriptJob.evaluateScript(RunScriptJob.java:173) com.glide.job.RunScriptJob.runScript(RunScriptJob.java:128) com.glide.job.RunScriptJob.execute(RunScriptJob.java:91) com.glide.schedule.JobExecutor.lambda$executeJob$0(JobExecutor.java:113) com.glide.schedule.JobExecutor.executeJob(JobExecutor.java:116) com.glide.schedule.JobExecutor.execute(JobExecutor.java:100) com.glide.schedule_v2.SchedulerWorkerThread.executeJob(SchedulerWorkerThread.java:300) com.glide.schedule_v2.SchedulerWorkerThread.lambda$process$0(SchedulerWorkerThread.java:188) com.glide.worker.TransactionalWorkerThread.executeInTransaction(TransactionalWorkerThread.java:35) com.glide.schedule_v2.SchedulerWorkerThread.process(SchedulerWorkerThread.java:188) com.glide.schedule_v2.SchedulerWorkerThread.run(SchedulerWorkerThread.java:102)