{ "timestamp": "2026-05-26 09:01:35.6255", "level": "Error", "severity": "ERROR", "message": "Cannot add or update a child row: a foreign key constraint fails (`qa_stg_oqsha_4`.`inspections`, CONSTRAINT `inspections_ibfk_6` FOREIGN KEY (`inspection_status_id`) REFERENCES `inspection_statuses` (`id`))", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Cannot add or update a child row: a foreign key constraint fails (`qa_stg_oqsha_4`.`inspections`, CONSTRAINT `inspections_ibfk_6` FOREIGN KEY (`inspection_status_id`) REFERENCES `inspection_statuses` (`id`))\r\n   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()\r\n   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)\r\n   at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)\r\n   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)\r\n   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()\r\n   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)\r\n   at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()\r\n   at System.Data.Common.DbCommand.ExecuteNonQueryAsync(CancellationToken cancellationToken)\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at Dapper.SqlMapper.<ExecuteImplAsync>d__39.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at IncidentReporter.DAL.Repositories.InspectionsRepo.<UpdateInspectionStatus>d__24.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\InspectionsRepo.cs:line 792\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd(Task task)\r\n   at IncidentReporter.RenewalReminder.Helpers.InspectionNextDueDateReminderHelper.<InspectionNextDueDateReminderExecuteAsync>d__4.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.RenewalReminder\\Helpers\\InspectionNextDueDateReminderHelper.cs:line 144" }
{ "timestamp": "2026-05-26 09:14:16.7037", "level": "Error", "severity": "ERROR", "message": "Cannot add or update a child row: a foreign key constraint fails (`qa_stg_oqsha_4`.`inspections`, CONSTRAINT `inspections_ibfk_6` FOREIGN KEY (`inspection_status_id`) REFERENCES `inspection_statuses` (`id`))", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Cannot add or update a child row: a foreign key constraint fails (`qa_stg_oqsha_4`.`inspections`, CONSTRAINT `inspections_ibfk_6` FOREIGN KEY (`inspection_status_id`) REFERENCES `inspection_statuses` (`id`))\r\n   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()\r\n   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)\r\n   at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)\r\n   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)\r\n   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()\r\n   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)\r\n   at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()\r\n   at System.Data.Common.DbCommand.ExecuteNonQueryAsync(CancellationToken cancellationToken)\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at Dapper.SqlMapper.<ExecuteImplAsync>d__39.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at IncidentReporter.DAL.Repositories.InspectionsRepo.<UpdateInspectionStatus>d__24.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\InspectionsRepo.cs:line 792\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd(Task task)\r\n   at IncidentReporter.RenewalReminder.Helpers.InspectionNextDueDateReminderHelper.<InspectionNextDueDateReminderExecuteAsync>d__4.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.RenewalReminder\\Helpers\\InspectionNextDueDateReminderHelper.cs:line 144" }
{ "timestamp": "2026-05-26 09:15:58.8855", "level": "Error", "severity": "ERROR", "message": "Cannot add or update a child row: a foreign key constraint fails (`qa_stg_oqsha_4`.`inspections`, CONSTRAINT `inspections_ibfk_6` FOREIGN KEY (`inspection_status_id`) REFERENCES `inspection_statuses` (`id`))", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Cannot add or update a child row: a foreign key constraint fails (`qa_stg_oqsha_4`.`inspections`, CONSTRAINT `inspections_ibfk_6` FOREIGN KEY (`inspection_status_id`) REFERENCES `inspection_statuses` (`id`))\r\n   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()\r\n   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)\r\n   at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)\r\n   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)\r\n   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()\r\n   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)\r\n   at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()\r\n   at System.Data.Common.DbCommand.ExecuteNonQueryAsync(CancellationToken cancellationToken)\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at Dapper.SqlMapper.<ExecuteImplAsync>d__39.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at IncidentReporter.DAL.Repositories.InspectionsRepo.<UpdateInspectionStatus>d__24.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\InspectionsRepo.cs:line 792\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd(Task task)\r\n   at IncidentReporter.RenewalReminder.Helpers.InspectionNextDueDateReminderHelper.<InspectionNextDueDateReminderExecuteAsync>d__4.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.RenewalReminder\\Helpers\\InspectionNextDueDateReminderHelper.cs:line 144" }
{ "timestamp": "2026-05-26 09:20:21.3315", "level": "Error", "severity": "ERROR", "message": "Cannot add or update a child row: a foreign key constraint fails (`qa_stg_oqsha_4`.`inspections`, CONSTRAINT `inspections_ibfk_6` FOREIGN KEY (`inspection_status_id`) REFERENCES `inspection_statuses` (`id`))", "stackTrace": "MySql.Data.MySqlClient.MySqlException (0x80004005): Cannot add or update a child row: a foreign key constraint fails (`qa_stg_oqsha_4`.`inspections`, CONSTRAINT `inspections_ibfk_6` FOREIGN KEY (`inspection_status_id`) REFERENCES `inspection_statuses` (`id`))\r\n   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()\r\n   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)\r\n   at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)\r\n   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)\r\n   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()\r\n   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)\r\n   at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()\r\n   at System.Data.Common.DbCommand.ExecuteNonQueryAsync(CancellationToken cancellationToken)\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at Dapper.SqlMapper.<ExecuteImplAsync>d__39.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at IncidentReporter.DAL.Repositories.InspectionsRepo.<UpdateInspectionStatus>d__24.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.DAL\\Repositories\\InspectionsRepo.cs:line 792\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd(Task task)\r\n   at IncidentReporter.RenewalReminder.Helpers.InspectionNextDueDateReminderHelper.<InspectionNextDueDateReminderExecuteAsync>d__4.MoveNext() in C:\\GitLab-Runner\\builds\\27n6lYj0J\\0\\incident-reporter\\incident-reporter-api\\IncidentReporter\\IncidentReporter.RenewalReminder\\Helpers\\InspectionNextDueDateReminderHelper.cs:line 144" }