Users unable to create any incident records.Issue > Users Receiving error message while trying to create any incidents in the portal.> Error message "Lock wait timeout exceeded: try restarting the transaction" keeps popping on the UI.ReleaseALLCause> In the localhost logs, for the transaction, we can see its failing because of below error: XXXX-XX-XX 03:46:07 (523) Default-thread-7 XXXX txid=XXXX GlideSession message was modified by sanitization. [message=(conn=131817475) Lock wait timeout exceeded; try restarting transaction][sanitized=(conn=131817475) Lock wait timeout exceeded; try restarting transaction]XXXX-XX-XX 03:46:07 (524) Default-thread-7 XXXX txid=XXXX SEVERE *** ERROR *** FAILED TRYING TO EXECUTE ON CONNECTION glide.11 (connpid=131817475): INSERT INTO task (`made_sla`,`a_bln_1`,`watch_list`,`upon_reject`,`a_str_49`,`sys_updated_on`,`a_int_6`,`u_round_robin_active`,`task_effective_number`,`number`,`sys_updated_by`,`opened_by`,`sys_created_on`,`sys_domain`,`a_bln_2`,`a_str_7`,`state`,`u_sent_email_count`,`sys_created_by`,`u_on_hold_duration`,`knowledge`,`u_survey_or_not_survey`,`a_str_3`,`impact`,`active`,`work_notes_list`,`business_service`,`a_bln_3`,`priority`,`sys_domain_path`,`u_ishr`,`a_bln_5`,`opened_at`,`a_dtm_2`,`a_ref_4`,`approval_set`,`a_str_76`,`work_notes`,`needs_attention`,`short_description`,`assignment_group`,`a_int_1`,`sys_class_name`,`follow_up`,`sys_id`,`u_incident_linked_to_case`,`contact_type`,`a_bln_4`,`a_int_2`,`urgency`,`company`,`reassignment_count`,`a_int_3`,`comments`,`approval`,`sys_mod_count`,`u_reminder_count`,`a_int_7`,`escalation`,`upon_approval`,`a_str_1`) VALUES(1,1,NULL,'cancel','test ServiceNow (Asia) ','2024-02-23 11:45:16',0,0,'INC02206766','INC02206766','Francis.RENECORAIL@consulting-for.accor.com','73b9eb76dbc0bc54644e3ce339961942','2024-02-23 11:45:16','global',1,NULL,1,1,'Francis.RENECORAIL@consulting-for.accor.com',NULL,0,'2',NULL,2,1,NULL,'5d39581adb7a2c5028861ea6059619f9',0,3,'/',0,0,'2024-02-23 11:45:00',NULL,'73b9eb76dbc0bc54644e3ce339961942',NULL,'incident',NULL,0,'test','dcb1a4d6dbc444507e8cba2139961931',1,'incident',NULL,'0d3af2d99724ce144ee0baefe153af70',0,'external system',0,1,3,NULL,0,3,NULL,'not requested',0,0,0,0,'proceed','incident') /* myaccor016, gs:889E22D197E88E144EE0BAEFE153AFFD, tx:b84a7e199724ce144ee0baefe153af02 */(conn=131817475) Lock wait timeout exceeded; try restarting transactionjava.sql.SQLException: (conn=131817475) Lock wait timeout exceeded; try restarting transactionat org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:255)at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:165)at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:238)at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:355)at org.mariadb.jdbc.MariaDbStatement.execute(MariaDbStatement.java:406)at jdk.internal.reflect.GeneratedMethodAccessor7.invoke(Unknown Source)at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)at java.base/java.lang.reflect.Method.invoke(Method.java:566)at com.glide.db.StatementWrapper.invoke(StatementWrapper.java:42)at com.glide.db.AConnectionWrapperProxy.invoke(AConnectionWrapperProxy.java:34)at com.glide.db.StatementWrapper.invoke(StatementWrapper.java:19)at com.sun.proxy.$Proxy7.execute(Unknown Source)at com.glide.db.DBI.executeStatement0(DBI.java:1502)at com.glide.db.DBI.executeStatement(DBI.java:1428)at com.glide.db.DBAction.executeAsResultSet(DBAction.java:442)at com.glide.db.DBCompositeAction.executeAsResultSet(DBCompositeAction.java:266)at com.glide.db.DBCompositeAction.executeChunk(DBCompositeAction.java:226)at com.glide.db.DBCompositeAction.executeAsResultSet0(DBCompositeAction.java:150)at com.glide.db.DBAction.executeAndReturnTable(DBAction.java:385)at com.glide.db.DBAction.executeNormal(DBAction.java:374)at com.glide.db.DBAction.executeAndReturnException(DBAction.java:328)at com.glide.script.GlideRecordITable.insert(GlideRecordITable.java:165)at com.glide.script.GlideRecord.insert(GlideRecord.java:5242)at com.glide.script.GlideRecord.insert(GlideRecord.java:5149)at com.glide.script.GlideRecord.jsFunction_insert(GlideRecord.java:5725)at jdk.internal.reflect.GeneratedMethodAccessor603.invoke(Unknown Source)at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)at java.base/java.lang.reflect.Method.invoke(Method.java:566)at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:138)at org.mozilla.javascript.FunctionObject.doInvoke(FunctionObject.java:677)at org.mozilla.javascript.FunctionObject.call(FunctionObject.java:614)at org.mozilla.javascript.ScriptRuntime.doCall(ScriptRuntime.java:2649)at org.mozilla.javascript.Interpreter.interpretLoop(Interpreter.java:1518)at org.mozilla.javascript.Interpreter.interpret(Interpreter.java:830)at org.mozilla.javascript.InterpretedFunction.lambda$call$0(InterpretedFunction.java:160)at com.glide.caller.gen.sys_ui_action_42da42d00a0a0b340066377beb6dd099_script.call(Unknown Source)at com.glide.script.ScriptCaller.call(ScriptCaller.java:22)at org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.java:159)at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:597)at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3573)at org.mozilla.javascript.InterpretedFunction.exec(InterpretedFunction.java:172)at com.glide.script.ScriptEvaluator.execute(ScriptEvaluator.java:389)at com.glide.script.ScriptEvaluator.evaluateString(ScriptEvaluator.java:199)at com.glide.script.ScriptEvaluator.evaluateString(ScriptEvaluator.java:131)at com.glide.script.GlideRhinoHelper.evaluateAsString(GlideRhinoHelper.java:149)at com.glide.script.ActionScript.conditionalEval(ActionScript.java:110)at com.glide.script.ActionScript.execute(ActionScript.java:95)at com.glide.script.ActionScriptProcessor.processScript(ActionScriptProcessor.java:233)at com.glide.script.Action.process(Action.java:117)at com.glide.ui.RedirectTransaction.invokeAction(RedirectTransaction.java:549)at com.glide.ui.RedirectTransaction.handleActions(RedirectTransaction.java:505)at com.glide.ui.RedirectTransaction.inboundActions(RedirectTransaction.java:341)at com.glide.ui.RedirectTransaction.process(RedirectTransaction.java:204)at com.glide.ui.GlideServletUITransaction.process(GlideServletUITransaction.java:119)at com.glide.processors.AProcessor.runProcessor(AProcessor.java:733)at com.glide.processors.AProcessor.processTransaction(AProcessor.java:291)at com.glide.processors.ProcessorRegistry.process0(ProcessorRegistry.java:187)at com.glide.processors.ProcessorRegistry.process(ProcessorRegistry.java:175)at com.glide.ui.GlideServletTransaction.process(GlideServletTransaction.java:58)at com.glide.sys.Transaction.run(Transaction.java:2645)at com.glide.ui.HTTPTransaction.run(HTTPTransaction.java:30)at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)at java.base/java.lang.Thread.run(Thread.java:829)Caused by: java.sql.SQLException: Lock wait timeout exceeded; try restarting transactionQuery is: INSERT INTO task (`made_sla`,`a_bln_1`,`watch_list`,`upon_reject`,`a_str_49`,`sys_updated_on`,`a_int_6`,`u_round_robin_active`,`task_effective_number`,`number`,`sys_updated_by`,`opened_by`,`sys_created_on`,`sys_domain`,`a_bln_2`,`a_str_7`,`state`,`u_sent_email_count`,`sys_created_by`,`u_on_hold_duration`,`knowledge`,`u_survey_or_not_survey`,`a_str_3`,`impact`,`active`,`work_notes_list`,`business_service`,`a_bln_3`,`priority`,`sys_domain_path`,`u_ishr`,`a_bln_5`,`opened_at`,`a_dtm_2`,`a_ref_4`,`approval_set`,`a_str_76`,`work_notes`,`needs_attention`,`short_description`,`assignment_group`,`a_int_1`,`sys_class_name`,`follow_up`,`sys_id`,`u_incident_linked_to_case`,`contact_type`,`a_bln_4`,`a_int_2`,`urgency`,`company`,`reassignment_count`,`a_int_3`,`comments`,`approval`,`sys_mod_count`,`u_reminder_count`,`a_int_7`,`escalation`,`upon_approval`,`a_str_1`) VALUES(1,1,NULL,'cancel','test ServiceNow (Asia) ','2024-02-23 11:45:16',0,0,'INC02206766','INC02206766','Francis.RENECORAIL@consulting-for.accor.com','73b9e...java thread: Default-thread-7at org.mariadb.jdbc.internal.util.LogQueryTool.exceptionWithQuery(LogQueryTool.java:126)at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:225)at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:349)... 60 moreXXXX-XX-XX 03:46:07 (525) Default-thread-7 XXXXXX txid=XXXX Error in user input caused action to be cancelled> This will happen when an DML statement on the task is running longer and locking the table due to which the other DML operations are not possible.> In one scenario, the SQL execution for insertion fails because there is a DELETE operation happening on the task table and as the DELETE statement has a lock on the task table, thus no operation on task table or any base table was possible at that moment.Resolution> The job/transaction though which the DML statement is running has to be killed, post which the lock will be released and the other DML operations will proceed as usual.> In this scenario, the Job through which delete statement was running was killed and that killed the delete statement too, post which lock on task table released.