Skip to content

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

@earlduque

Description

@earlduque

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)

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions