{"Timestamp":"2025-02-01T00:53:14.7115735+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-02-01T00:53:14.7115568Z"}} {"Timestamp":"2025-02-01T00:53:14.7221799+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-02-01T00:53:14.7221575Z"}} {"Timestamp":"2025-02-01T01:53:14.7092073+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-02-01T01:53:14.7091915Z"}} {"Timestamp":"2025-02-01T01:53:14.7167868+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-02-01T01:53:14.7167684Z"}} {"Timestamp":"2025-02-01T02:53:14.7106916+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-02-01T02:53:14.7106767Z"}} {"Timestamp":"2025-02-01T02:53:14.7185443+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-02-01T02:53:14.7185265Z"}} {"Timestamp":"2025-02-01T03:53:14.7065738+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-02-01T03:53:14.7065603Z"}} {"Timestamp":"2025-02-01T03:53:14.7135258+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-02-01T03:53:14.7135115Z"}} {"Timestamp":"2025-02-01T04:53:14.7150420+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-02-01T04:53:14.7150260Z"}} {"Timestamp":"2025-02-01T04:53:14.7224297+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-02-01T04:53:14.7224135Z"}} {"Timestamp":"2025-02-01T05:53:14.7075482+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-02-01T05:53:14.7075341Z"}} {"Timestamp":"2025-02-01T05:53:14.7151484+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-02-01T05:53:14.7151365Z"}} {"Timestamp":"2025-02-01T06:53:14.7080846+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-02-01T06:53:14.7080672Z"}} {"Timestamp":"2025-02-01T06:53:14.7158423+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-02-01T06:53:14.7158240Z"}} {"Timestamp":"2025-02-01T07:53:14.7074960+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-02-01T07:53:14.7074782Z"}} {"Timestamp":"2025-02-01T07:53:14.7162395+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-02-01T07:53:14.7162223Z"}} {"Timestamp":"2025-02-01T08:53:14.7124391+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-02-01T08:53:14.7124192Z"}} {"Timestamp":"2025-02-01T08:53:14.7204965+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-02-01T08:53:14.7204791Z"}} {"Timestamp":"2025-02-01T09:53:14.7107043+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-02-01T09:53:14.7106896Z"}} {"Timestamp":"2025-02-01T09:53:14.7195512+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-02-01T09:53:14.7195328Z"}} {"Timestamp":"2025-02-01T10:53:14.7096334+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-02-01T10:53:14.7096051Z"}} {"Timestamp":"2025-02-01T10:53:14.7178120+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-02-01T10:53:14.7177947Z"}} {"Timestamp":"2025-02-01T11:53:14.7116375+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-02-01T11:53:14.7116205Z"}} {"Timestamp":"2025-02-01T11:53:14.7192484+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-02-01T11:53:14.7192329Z"}} {"Timestamp":"2025-02-01T12:53:14.7150595+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-02-01T12:53:14.7150360Z"}} {"Timestamp":"2025-02-01T12:53:14.7237500+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-02-01T12:53:14.7237316Z"}} {"Timestamp":"2025-02-01T13:53:14.7126431+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-02-01T13:53:14.7126266Z"}} {"Timestamp":"2025-02-01T13:53:14.7207692+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-02-01T13:53:14.7207522Z"}} {"Timestamp":"2025-02-01T14:53:14.7160844+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-02-01T14:53:14.7160673Z"}} {"Timestamp":"2025-02-01T14:53:14.7256389+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-02-01T14:53:14.7256175Z"}} {"Timestamp":"2025-02-01T15:53:14.7163849+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-02-01T15:53:14.7163701Z"}} {"Timestamp":"2025-02-01T15:53:14.7242238+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-02-01T15:53:14.7242078Z"}} {"Timestamp":"2025-02-01T16:53:14.7220142+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-02-01T16:53:14.7219967Z"}} {"Timestamp":"2025-02-01T16:53:14.7308495+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-02-01T16:53:14.7308341Z"}} {"Timestamp":"2025-02-01T17:53:14.7139767+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-02-01T17:53:14.7139421Z"}} {"Timestamp":"2025-02-01T17:53:14.7268841+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-02-01T17:53:14.7268607Z"}} {"Timestamp":"2025-02-01T18:53:14.7113257+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-02-01T18:53:14.7113118Z"}} {"Timestamp":"2025-02-01T18:53:14.7203680+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-02-01T18:53:14.7203433Z"}} {"Timestamp":"2025-02-01T19:09:05.9215194+00:00","Level":"Error","MessageTemplate":"Failed executing DbCommand ({elapsed}ms) [Parameters=[{parameters}], CommandType='{commandType}', CommandTimeout='{commandTimeout}']{newLine}{commandText}","TraceId":"ca2012ed07d86d7bfcf7b6a5717fdc1d","SpanId":"3ab3ea974892f1b5","Properties":{"elapsed":"0","parameters":"@p0='?' (Size = 255), @p1='?' (DbType = Int32), @p2='?' (DbType = DateTime), @p3='?' (Size = 4000), @p4='?' (Size = 4000), @p5='?' (DbType = DateTime), @p6='?' (Size = 4000), @p7='?' (Size = 4000), @p8='?' (DbType = Double), @p9='?' (DbType = Int32), @p10='?' (DbType = DateTime), @p11='?' (Size = 4000), @p12='?' (Size = 256), @p13='?' (DbType = Boolean), @p14='?' (DbType = Int32), @p15='?' (Size = 4000), @p16='?' (Size = 4000), @p17='?' (DbType = Boolean), @p18='?' (DbType = DateTimeOffset), @p19='?' (Size = 4000), @p20='?' (Size = 256), @p21='?' (Size = 256), @p22='?' (Size = 4000), @p23='?' (Size = 4000), @p24='?' (DbType = Boolean), @p25='?' (Size = 4000), @p26='?' (Size = 4000), @p27='?' (DbType = Int32), @p28='?' (DbType = Boolean), @p29='?' (Size = 256), @p30='?' (Size = 4000), @p31='?' (DbType = Int32)","commandType":"Text","commandTimeout":30,"newLine":"\n","commandText":"SET AUTOCOMMIT = 1;\nINSERT INTO `AspNetUsers` (`Id`, `AccessFailedCount`, `BirthDay`, `ConcurrencyStamp`, `Country`, `CreatedDate`, `DoctorCertificates`, `DoctorExperiences`, `DoctorRate`, `DoctorSpecialty`, `DoctorStartExperience`, `Education`, `Email`, `EmailConfirmed`, `Gender`, `Job`, `Language`, `LockoutEnabled`, `LockoutEnd`, `MaritalStatus`, `NormalizedEmail`, `NormalizedUserName`, `PasswordHash`, `PhoneNumber`, `PhoneNumberConfirmed`, `ProfilePicture`, `SecurityStamp`, `Status`, `TwoFactorEnabled`, `UserName`, `confirmCode`, `userType`)\nVALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14, @p15, @p16, @p17, @p18, @p19, @p20, @p21, @p22, @p23, @p24, @p25, @p26, @p27, @p28, @p29, @p30, @p31);","EventId":{"Id":20102,"Name":"Microsoft.EntityFrameworkCore.Database.Command.CommandError"},"ActionName":"UserController.CreatePatient ","RequestPath":"/api/User/CreatePatient"}} {"Timestamp":"2025-02-01T19:09:05.9217153+00:00","Level":"Error","MessageTemplate":"Failed executing DbCommand ({elapsed}ms) [Parameters=[{parameters}], CommandType='{commandType}', CommandTimeout='{commandTimeout}']{newLine}{commandText}","TraceId":"b6866af85e311fdd63a0528ee8929403","SpanId":"aff10538885f4f06","Properties":{"elapsed":"0","parameters":"@p0='?' (Size = 255), @p1='?' (DbType = Int32), @p2='?' (DbType = DateTime), @p3='?' (Size = 4000), @p4='?' (Size = 4000), @p5='?' (DbType = DateTime), @p6='?' (Size = 4000), @p7='?' (Size = 4000), @p8='?' (DbType = Double), @p9='?' (DbType = Int32), @p10='?' (DbType = DateTime), @p11='?' (Size = 4000), @p12='?' (Size = 256), @p13='?' (DbType = Boolean), @p14='?' (DbType = Int32), @p15='?' (Size = 4000), @p16='?' (Size = 4000), @p17='?' (DbType = Boolean), @p18='?' (DbType = DateTimeOffset), @p19='?' (Size = 4000), @p20='?' (Size = 256), @p21='?' (Size = 256), @p22='?' (Size = 4000), @p23='?' (Size = 4000), @p24='?' (DbType = Boolean), @p25='?' (Size = 4000), @p26='?' (Size = 4000), @p27='?' (DbType = Int32), @p28='?' (DbType = Boolean), @p29='?' (Size = 256), @p30='?' (Size = 4000), @p31='?' (DbType = Int32)","commandType":"Text","commandTimeout":30,"newLine":"\n","commandText":"SET AUTOCOMMIT = 1;\nINSERT INTO `AspNetUsers` (`Id`, `AccessFailedCount`, `BirthDay`, `ConcurrencyStamp`, `Country`, `CreatedDate`, `DoctorCertificates`, `DoctorExperiences`, `DoctorRate`, `DoctorSpecialty`, `DoctorStartExperience`, `Education`, `Email`, `EmailConfirmed`, `Gender`, `Job`, `Language`, `LockoutEnabled`, `LockoutEnd`, `MaritalStatus`, `NormalizedEmail`, `NormalizedUserName`, `PasswordHash`, `PhoneNumber`, `PhoneNumberConfirmed`, `ProfilePicture`, `SecurityStamp`, `Status`, `TwoFactorEnabled`, `UserName`, `confirmCode`, `userType`)\nVALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14, @p15, @p16, @p17, @p18, @p19, @p20, @p21, @p22, @p23, @p24, @p25, @p26, @p27, @p28, @p29, @p30, @p31);","EventId":{"Id":20102,"Name":"Microsoft.EntityFrameworkCore.Database.Command.CommandError"},"ActionName":"UserController.CreatePatient ","RequestPath":"/api/User/CreatePatient"}} {"Timestamp":"2025-02-01T19:09:05.9217202+00:00","Level":"Error","MessageTemplate":"Failed executing DbCommand ({elapsed}ms) [Parameters=[{parameters}], CommandType='{commandType}', CommandTimeout='{commandTimeout}']{newLine}{commandText}","TraceId":"b065e14707ec574c200632e056d84ea3","SpanId":"613f4a47d1f9eb58","Properties":{"elapsed":"0","parameters":"@p0='?' (Size = 255), @p1='?' (DbType = Int32), @p2='?' (DbType = DateTime), @p3='?' (Size = 4000), @p4='?' (Size = 4000), @p5='?' (DbType = DateTime), @p6='?' (Size = 4000), @p7='?' (Size = 4000), @p8='?' (DbType = Double), @p9='?' (DbType = Int32), @p10='?' (DbType = DateTime), @p11='?' (Size = 4000), @p12='?' (Size = 256), @p13='?' (DbType = Boolean), @p14='?' (DbType = Int32), @p15='?' (Size = 4000), @p16='?' (Size = 4000), @p17='?' (DbType = Boolean), @p18='?' (DbType = DateTimeOffset), @p19='?' (Size = 4000), @p20='?' (Size = 256), @p21='?' (Size = 256), @p22='?' (Size = 4000), @p23='?' (Size = 4000), @p24='?' (DbType = Boolean), @p25='?' (Size = 4000), @p26='?' (Size = 4000), @p27='?' (DbType = Int32), @p28='?' (DbType = Boolean), @p29='?' (Size = 256), @p30='?' (Size = 4000), @p31='?' (DbType = Int32)","commandType":"Text","commandTimeout":30,"newLine":"\n","commandText":"SET AUTOCOMMIT = 1;\nINSERT INTO `AspNetUsers` (`Id`, `AccessFailedCount`, `BirthDay`, `ConcurrencyStamp`, `Country`, `CreatedDate`, `DoctorCertificates`, `DoctorExperiences`, `DoctorRate`, `DoctorSpecialty`, `DoctorStartExperience`, `Education`, `Email`, `EmailConfirmed`, `Gender`, `Job`, `Language`, `LockoutEnabled`, `LockoutEnd`, `MaritalStatus`, `NormalizedEmail`, `NormalizedUserName`, `PasswordHash`, `PhoneNumber`, `PhoneNumberConfirmed`, `ProfilePicture`, `SecurityStamp`, `Status`, `TwoFactorEnabled`, `UserName`, `confirmCode`, `userType`)\nVALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14, @p15, @p16, @p17, @p18, @p19, @p20, @p21, @p22, @p23, @p24, @p25, @p26, @p27, @p28, @p29, @p30, @p31);","EventId":{"Id":20102,"Name":"Microsoft.EntityFrameworkCore.Database.Command.CommandError"},"ActionName":"UserController.CreatePatient ","RequestPath":"/api/User/CreatePatient"}} {"Timestamp":"2025-02-01T19:09:05.9271242+00:00","Level":"Error","MessageTemplate":"An exception occurred in the database while saving changes for context type '{contextType}'.{newline}{error}","TraceId":"b6866af85e311fdd63a0528ee8929403","SpanId":"aff10538885f4f06","Exception":"Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while saving the entity changes. See the inner exception for details.\n ---> MySqlConnector.MySqlException (0x80004005): Duplicate entry 'ravena44a@gmail.com' for key 'aspnetusers.IX_AspNetUsers_Email'\n at MySqlConnector.Core.ServerSession.ReceiveReplyAsyncAwaited(ValueTask`1 task) in /_/src/MySqlConnector/Core/ServerSession.cs:line 964\n at MySqlConnector.Core.ResultSet.ReadResultSetHeaderAsync(IOBehavior ioBehavior) in /_/src/MySqlConnector/Core/ResultSet.cs:line 175\n at MySqlConnector.MySqlDataReader.ActivateResultSet(CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 133\n at MySqlConnector.MySqlDataReader.CreateAsync(CommandListPosition commandListPosition, ICommandPayloadCreator payloadCreator, IDictionary`2 cachedProcedures, IMySqlCommand command, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 493\n at MySqlConnector.Core.CommandExecutor.ExecuteReaderAsync(IReadOnlyList`1 commands, ICommandPayloadCreator payloadCreator, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/CommandExecutor.cs:line 77\n at MySqlConnector.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 345\n at MySqlConnector.MySqlCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 337\n at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken)\n --- End of inner exception stack trace ---\n at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IList`1 entriesToSave, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(StateManager stateManager, Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)\n at Pomelo.EntityFrameworkCore.MySql.Storage.Internal.MySqlExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)","Properties":{"contextType":"OnlineClinic.DAL.OC_DBContext","newline":"\n","error":"Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while saving the entity changes. See the inner exception for details.\n ---> MySqlConnector.MySqlException (0x80004005): Duplicate entry 'ravena44a@gmail.com' for key 'aspnetusers.IX_AspNetUsers_Email'\n at MySqlConnector.Core.ServerSession.ReceiveReplyAsyncAwaited(ValueTask`1 task) in /_/src/MySqlConnector/Core/ServerSession.cs:line 964\n at MySqlConnector.Core.ResultSet.ReadResultSetHeaderAsync(IOBehavior ioBehavior) in /_/src/MySqlConnector/Core/ResultSet.cs:line 175\n at MySqlConnector.MySqlDataReader.ActivateResultSet(CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 133\n at MySqlConnector.MySqlDataReader.CreateAsync(CommandListPosition commandListPosition, ICommandPayloadCreator payloadCreator, IDictionary`2 cachedProcedures, IMySqlCommand command, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 493\n at MySqlConnector.Core.CommandExecutor.ExecuteReaderAsync(IReadOnlyList`1 commands, ICommandPayloadCreator payloadCreator, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/CommandExecutor.cs:line 77\n at MySqlConnector.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 345\n at MySqlConnector.MySqlCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 337\n at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken)\n --- End of inner exception stack trace ---\n at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IList`1 entriesToSave, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(StateManager stateManager, Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)\n at Pomelo.EntityFrameworkCore.MySql.Storage.Internal.MySqlExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)","EventId":{"Id":10000,"Name":"Microsoft.EntityFrameworkCore.Update.SaveChangesFailed"},"ActionName":"UserController.CreatePatient ","RequestPath":"/api/User/CreatePatient"}} {"Timestamp":"2025-02-01T19:09:05.9271328+00:00","Level":"Error","MessageTemplate":"An exception occurred in the database while saving changes for context type '{contextType}'.{newline}{error}","TraceId":"ca2012ed07d86d7bfcf7b6a5717fdc1d","SpanId":"3ab3ea974892f1b5","Exception":"Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while saving the entity changes. See the inner exception for details.\n ---> MySqlConnector.MySqlException (0x80004005): Duplicate entry 'ravena44a@gmail.com' for key 'aspnetusers.IX_AspNetUsers_Email'\n at MySqlConnector.Core.ServerSession.ReceiveReplyAsyncAwaited(ValueTask`1 task) in /_/src/MySqlConnector/Core/ServerSession.cs:line 964\n at MySqlConnector.Core.ResultSet.ReadResultSetHeaderAsync(IOBehavior ioBehavior) in /_/src/MySqlConnector/Core/ResultSet.cs:line 175\n at MySqlConnector.MySqlDataReader.ActivateResultSet(CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 133\n at MySqlConnector.MySqlDataReader.CreateAsync(CommandListPosition commandListPosition, ICommandPayloadCreator payloadCreator, IDictionary`2 cachedProcedures, IMySqlCommand command, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 493\n at MySqlConnector.Core.CommandExecutor.ExecuteReaderAsync(IReadOnlyList`1 commands, ICommandPayloadCreator payloadCreator, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/CommandExecutor.cs:line 77\n at MySqlConnector.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 345\n at MySqlConnector.MySqlCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 337\n at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken)\n --- End of inner exception stack trace ---\n at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IList`1 entriesToSave, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(StateManager stateManager, Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)\n at Pomelo.EntityFrameworkCore.MySql.Storage.Internal.MySqlExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)","Properties":{"contextType":"OnlineClinic.DAL.OC_DBContext","newline":"\n","error":"Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while saving the entity changes. See the inner exception for details.\n ---> MySqlConnector.MySqlException (0x80004005): Duplicate entry 'ravena44a@gmail.com' for key 'aspnetusers.IX_AspNetUsers_Email'\n at MySqlConnector.Core.ServerSession.ReceiveReplyAsyncAwaited(ValueTask`1 task) in /_/src/MySqlConnector/Core/ServerSession.cs:line 964\n at MySqlConnector.Core.ResultSet.ReadResultSetHeaderAsync(IOBehavior ioBehavior) in /_/src/MySqlConnector/Core/ResultSet.cs:line 175\n at MySqlConnector.MySqlDataReader.ActivateResultSet(CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 133\n at MySqlConnector.MySqlDataReader.CreateAsync(CommandListPosition commandListPosition, ICommandPayloadCreator payloadCreator, IDictionary`2 cachedProcedures, IMySqlCommand command, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 493\n at MySqlConnector.Core.CommandExecutor.ExecuteReaderAsync(IReadOnlyList`1 commands, ICommandPayloadCreator payloadCreator, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/CommandExecutor.cs:line 77\n at MySqlConnector.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 345\n at MySqlConnector.MySqlCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 337\n at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken)\n --- End of inner exception stack trace ---\n at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IList`1 entriesToSave, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(StateManager stateManager, Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)\n at Pomelo.EntityFrameworkCore.MySql.Storage.Internal.MySqlExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)","EventId":{"Id":10000,"Name":"Microsoft.EntityFrameworkCore.Update.SaveChangesFailed"},"ActionName":"UserController.CreatePatient ","RequestPath":"/api/User/CreatePatient"}} {"Timestamp":"2025-02-01T19:09:05.9271237+00:00","Level":"Error","MessageTemplate":"An exception occurred in the database while saving changes for context type '{contextType}'.{newline}{error}","TraceId":"b065e14707ec574c200632e056d84ea3","SpanId":"613f4a47d1f9eb58","Exception":"Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while saving the entity changes. See the inner exception for details.\n ---> MySqlConnector.MySqlException (0x80004005): Duplicate entry 'ravena44a@gmail.com' for key 'aspnetusers.IX_AspNetUsers_Email'\n at MySqlConnector.Core.ServerSession.ReceiveReplyAsyncAwaited(ValueTask`1 task) in /_/src/MySqlConnector/Core/ServerSession.cs:line 964\n at MySqlConnector.Core.ResultSet.ReadResultSetHeaderAsync(IOBehavior ioBehavior) in /_/src/MySqlConnector/Core/ResultSet.cs:line 175\n at MySqlConnector.MySqlDataReader.ActivateResultSet(CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 133\n at MySqlConnector.MySqlDataReader.CreateAsync(CommandListPosition commandListPosition, ICommandPayloadCreator payloadCreator, IDictionary`2 cachedProcedures, IMySqlCommand command, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 493\n at MySqlConnector.Core.CommandExecutor.ExecuteReaderAsync(IReadOnlyList`1 commands, ICommandPayloadCreator payloadCreator, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/CommandExecutor.cs:line 77\n at MySqlConnector.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 345\n at MySqlConnector.MySqlCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 337\n at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken)\n --- End of inner exception stack trace ---\n at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IList`1 entriesToSave, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(StateManager stateManager, Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)\n at Pomelo.EntityFrameworkCore.MySql.Storage.Internal.MySqlExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)","Properties":{"contextType":"OnlineClinic.DAL.OC_DBContext","newline":"\n","error":"Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while saving the entity changes. See the inner exception for details.\n ---> MySqlConnector.MySqlException (0x80004005): Duplicate entry 'ravena44a@gmail.com' for key 'aspnetusers.IX_AspNetUsers_Email'\n at MySqlConnector.Core.ServerSession.ReceiveReplyAsyncAwaited(ValueTask`1 task) in /_/src/MySqlConnector/Core/ServerSession.cs:line 964\n at MySqlConnector.Core.ResultSet.ReadResultSetHeaderAsync(IOBehavior ioBehavior) in /_/src/MySqlConnector/Core/ResultSet.cs:line 175\n at MySqlConnector.MySqlDataReader.ActivateResultSet(CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 133\n at MySqlConnector.MySqlDataReader.CreateAsync(CommandListPosition commandListPosition, ICommandPayloadCreator payloadCreator, IDictionary`2 cachedProcedures, IMySqlCommand command, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 493\n at MySqlConnector.Core.CommandExecutor.ExecuteReaderAsync(IReadOnlyList`1 commands, ICommandPayloadCreator payloadCreator, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/CommandExecutor.cs:line 77\n at MySqlConnector.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 345\n at MySqlConnector.MySqlCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 337\n at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken)\n --- End of inner exception stack trace ---\n at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IList`1 entriesToSave, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(StateManager stateManager, Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)\n at Pomelo.EntityFrameworkCore.MySql.Storage.Internal.MySqlExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)\n at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)","EventId":{"Id":10000,"Name":"Microsoft.EntityFrameworkCore.Update.SaveChangesFailed"},"ActionName":"UserController.CreatePatient ","RequestPath":"/api/User/CreatePatient"}} {"Timestamp":"2025-02-01T19:09:06.2493379+00:00","Level":"Information","MessageTemplate":"Email Sent Successfully :{@Reciever}, {@Subject}, {@Timestamp}","TraceId":"335a2074f5f0f4fd087c9eb499c9c5b3","SpanId":"9cf76aa4d6c4dd83","Properties":{"Reciever":"ravena44a@gmail.com","Subject":"Confirm Code","Timestamp":"2025-02-01T19:09:06.2492844Z","ActionName":"UserController.CreatePatient ","RequestPath":"/api/User/CreatePatient"}} {"Timestamp":"2025-02-01T19:09:06.4703433+00:00","Level":"Information","MessageTemplate":"New Patient Added To DB , Confirmation Pending: {@Email} ,{@TimestampUTC} ","TraceId":"335a2074f5f0f4fd087c9eb499c9c5b3","SpanId":"9cf76aa4d6c4dd83","Properties":{"Email":"ravena44a@gmail.com","TimestampUTC":"2025-02-01T19:09:06.4702731Z","ActionName":"UserController.CreatePatient ","RequestPath":"/api/User/CreatePatient"}} {"Timestamp":"2025-02-01T19:53:14.7293013+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-02-01T19:53:14.7292836Z"}} {"Timestamp":"2025-02-01T19:53:14.7392838+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-02-01T19:53:14.7392676Z"}} {"Timestamp":"2025-02-01T20:53:14.6765102+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-02-01T20:53:14.6764888Z"}} {"Timestamp":"2025-02-01T20:53:14.6832583+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-02-01T20:53:14.6832369Z"}} {"Timestamp":"2025-02-01T21:53:14.7168882+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-02-01T21:53:14.7168725Z"}} {"Timestamp":"2025-02-01T21:53:14.7255415+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-02-01T21:53:14.7255226Z"}} {"Timestamp":"2025-02-01T22:53:14.7095131+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-02-01T22:53:14.7094978Z"}} {"Timestamp":"2025-02-01T22:53:14.7185107+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-02-01T22:53:14.7184901Z"}} {"Timestamp":"2025-02-01T23:53:14.7076797+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-02-01T23:53:14.7076604Z"}} {"Timestamp":"2025-02-01T23:53:14.7161547+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-02-01T23:53:14.7161405Z"}}