{"Timestamp":"2025-01-13T00:53:14.7116303+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-01-13T00:53:14.7116133Z"}} {"Timestamp":"2025-01-13T00:53:14.7221774+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-01-13T00:53:14.7221590Z"}} {"Timestamp":"2025-01-13T01:53:14.7078602+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-01-13T01:53:14.7078434Z"}} {"Timestamp":"2025-01-13T01:53:14.7154038+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-01-13T01:53:14.7153884Z"}} {"Timestamp":"2025-01-13T02:53:14.7230954+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-01-13T02:53:14.7230795Z"}} {"Timestamp":"2025-01-13T02:53:14.7335913+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-01-13T02:53:14.7335631Z"}} {"Timestamp":"2025-01-13T03:53:14.7182286+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-01-13T03:53:14.7182101Z"}} {"Timestamp":"2025-01-13T03:53:14.7276575+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-01-13T03:53:14.7276324Z"}} {"Timestamp":"2025-01-13T04:53:14.7146576+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-01-13T04:53:14.7146424Z"}} {"Timestamp":"2025-01-13T04:53:14.7242643+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-01-13T04:53:14.7242436Z"}} {"Timestamp":"2025-01-13T05:53:14.7254649+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-01-13T05:53:14.7254475Z"}} {"Timestamp":"2025-01-13T05:53:14.7344739+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-01-13T05:53:14.7344565Z"}} {"Timestamp":"2025-01-13T06:53:14.7197110+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-01-13T06:53:14.7196960Z"}} {"Timestamp":"2025-01-13T06:53:14.7284662+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-01-13T06:53:14.7284482Z"}} {"Timestamp":"2025-01-13T07:53:14.7189422+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-01-13T07:53:14.7189261Z"}} {"Timestamp":"2025-01-13T07:53:14.7287332+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-01-13T07:53:14.7287110Z"}} {"Timestamp":"2025-01-13T08:12:48.1050343+00:00","Level":"Information","MessageTemplate":"User Signed in Successfully:{@Username}, {@Email} ,{@TimestampUTC} ","TraceId":"ffb7cbeb33a070187b63fa26165bf221","SpanId":"4524d0f798d48e69","Properties":{"Username":"Motaz Siam","Email":"mutaz.s@nxt-level.co","TimestampUTC":"2025-01-13T08:12:48.1050084Z","ActionName":"UserController.Signin ","RequestPath":"/api/User/Signin"}} {"Timestamp":"2025-01-13T08:12:48.1071094+00:00","Level":"Error","MessageTemplate":"Failed executing DbCommand ({elapsed}ms) [Parameters=[{parameters}], CommandType='{commandType}', CommandTimeout='{commandTimeout}']{newLine}{commandText}","TraceId":"ffb7cbeb33a070187b63fa26165bf221","SpanId":"4524d0f798d48e69","Properties":{"elapsed":"73","parameters":"@__user_Id_0='?' (Size = 255)","commandType":"Text","commandTimeout":30,"newLine":"\n","commandText":"SELECT `a`.`Id`, `a`.`ClaimType`, `a`.`ClaimValue`, `a`.`UserId`\nFROM `AspNetUserClaims` AS `a`\nWHERE `a`.`UserId` = @__user_Id_0","EventId":{"Id":20102,"Name":"Microsoft.EntityFrameworkCore.Database.Command.CommandError"},"ActionName":"UserController.Signin ","RequestPath":"/api/User/Signin"}} {"Timestamp":"2025-01-13T08:12:48.1066817+00:00","Level":"Error","MessageTemplate":"Connection id \"{ConnectionId}\", Request id \"{TraceIdentifier}\": An unhandled exception was thrown by the application.","TraceId":"ffb7cbeb33a070187b63fa26165bf221","SpanId":"4524d0f798d48e69","Exception":"System.NullReferenceException: Object reference not set to an instance of an object.\n at MySqlConnector.MySqlConnection.FinishQuerying(Boolean hasWarnings) in /_/src/MySqlConnector/MySqlConnection.cs:line 906\n at MySqlConnector.MySqlDataReader.DisposeAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 639\n at MySqlConnector.MySqlConnection.CloseDatabaseAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlConnection.cs:line 1101\n at MySqlConnector.MySqlConnection.DoCloseAsync(Boolean changeState, IOBehavior ioBehavior) in /_/src/MySqlConnector/MySqlConnection.cs:line 1075\n at MySqlConnector.MySqlConnection.DoCloseAsync(Boolean changeState, IOBehavior ioBehavior) in /_/src/MySqlConnector/MySqlConnection.cs:line 1094\n at MySqlConnector.MySqlConnection.CloseAsync(Boolean changeState, IOBehavior ioBehavior) in /_/src/MySqlConnector/MySqlConnection.cs:line 1026\n at MySqlConnector.MySqlConnection.DisposeAsync() in /_/src/MySqlConnector/MySqlConnection.cs:line 704\n at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.DisposeDbConnectionAsync()\n at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.ResetStateAsync(Boolean disposeDbConnection)\n at Microsoft.Extensions.DependencyInjection.ServiceLookup.ServiceProviderEngineScope.g__Await|26_0(Int32 i, ValueTask vt, List`1 toDispose)\n at Microsoft.EntityFrameworkCore.DbContext.DisposeAsync()\n at Microsoft.Extensions.DependencyInjection.ServiceLookup.ServiceProviderEngineScope.g__Await|26_0(Int32 i, ValueTask vt, List`1 toDispose)\n at Microsoft.AspNetCore.Http.Features.RequestServicesFeature.g__Awaited|9_0(RequestServicesFeature servicesFeature, ValueTask vt)\n at Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpProtocol.g__ProcessEvents|242_0(HttpProtocol protocol, Stack`1 events)","Properties":{"TraceIdentifier":"0HN8FNHIBIP5J:00000005","EventId":{"Id":13,"Name":"ApplicationError"},"RequestPath":"/api/User/Signin"}} {"Timestamp":"2025-01-13T08:12:48.1083100+00:00","Level":"Error","MessageTemplate":"An exception occurred while iterating over the results of a query for context type '{contextType}'.{newline}{error}","TraceId":"ffb7cbeb33a070187b63fa26165bf221","SpanId":"4524d0f798d48e69","Exception":"System.NullReferenceException: Object reference not set to an instance of an object.\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.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, 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.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()","Properties":{"contextType":"OnlineClinic.DAL.OC_DBContext","newline":"\n","error":"System.NullReferenceException: Object reference not set to an instance of an object.\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.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, 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.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()","EventId":{"Id":10100,"Name":"Microsoft.EntityFrameworkCore.Query.QueryIterationFailed"},"ActionName":"UserController.Signin ","RequestPath":"/api/User/Signin"}} {"Timestamp":"2025-01-13T08:53:14.7167112+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-01-13T08:53:14.7166957Z"}} {"Timestamp":"2025-01-13T08:53:14.7265030+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-01-13T08:53:14.7264630Z"}} {"Timestamp":"2025-01-13T09:09:33.8918951+00:00","Level":"Information","MessageTemplate":"User Signed in Successfully:{@Username}, {@Email} ,{@TimestampUTC} ","TraceId":"f951ae984e4418662a72c0b0e7e0b0ef","SpanId":"2fb8d0f960757547","Properties":{"Username":"patient test","Email":"patient@gmail.com","TimestampUTC":"2025-01-13T09:09:33.8918712Z","ActionName":"UserController.Signin ","RequestPath":"/api/User/Signin"}} {"Timestamp":"2025-01-13T09:09:33.8932608+00:00","Level":"Error","MessageTemplate":"Failed executing DbCommand ({elapsed}ms) [Parameters=[{parameters}], CommandType='{commandType}', CommandTimeout='{commandTimeout}']{newLine}{commandText}","TraceId":"f951ae984e4418662a72c0b0e7e0b0ef","SpanId":"2fb8d0f960757547","Properties":{"elapsed":"83","parameters":"@__user_Id_0='?' (Size = 255)","commandType":"Text","commandTimeout":30,"newLine":"\n","commandText":"SELECT `a`.`Id`, `a`.`ClaimType`, `a`.`ClaimValue`, `a`.`UserId`\nFROM `AspNetUserClaims` AS `a`\nWHERE `a`.`UserId` = @__user_Id_0","EventId":{"Id":20102,"Name":"Microsoft.EntityFrameworkCore.Database.Command.CommandError"},"ActionName":"UserController.Signin ","RequestPath":"/api/User/Signin"}} {"Timestamp":"2025-01-13T09:09:33.8941389+00:00","Level":"Error","MessageTemplate":"An exception occurred while iterating over the results of a query for context type '{contextType}'.{newline}{error}","TraceId":"f951ae984e4418662a72c0b0e7e0b0ef","SpanId":"2fb8d0f960757547","Exception":"System.NullReferenceException: Object reference not set to an instance of an object.\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.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, 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.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()","Properties":{"contextType":"OnlineClinic.DAL.OC_DBContext","newline":"\n","error":"System.NullReferenceException: Object reference not set to an instance of an object.\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.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, 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.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()","EventId":{"Id":10100,"Name":"Microsoft.EntityFrameworkCore.Query.QueryIterationFailed"},"ActionName":"UserController.Signin ","RequestPath":"/api/User/Signin"}} {"Timestamp":"2025-01-13T09:09:38.1045689+00:00","Level":"Error","MessageTemplate":"An error occurred using the connection to database '{database}' on server '{server}'.","TraceId":"2d36c8677053e65e266491bccc5a726b","SpanId":"af207a6c3b74adfc","Properties":{"database":"sokoun","server":"localhost","EventId":{"Id":20004,"Name":"Microsoft.EntityFrameworkCore.Database.Connection.ConnectionError"},"ActionName":"DoctorController.GetAllDoctor ","RequestPath":"/api/Doctor/GetAllDoctor"}} {"Timestamp":"2025-01-13T09:09:38.1054447+00:00","Level":"Error","MessageTemplate":"An exception occurred while iterating over the results of a query for context type '{contextType}'.{newline}{error}","TraceId":"2d36c8677053e65e266491bccc5a726b","SpanId":"af207a6c3b74adfc","Exception":"MySqlConnector.MySqlProtocolException: Packet received out-of-order. Expected 1; got 2.\n at MySqlConnector.Protocol.Serialization.ProtocolUtility.g__AddContinuation|5_0(ValueTask`1 readPacketTask, BufferedByteReader bufferedByteReader, IByteHandler byteHandler, Func`1 getNextSequenceNumber, ArraySegmentHolder`1 previousPayloads, ProtocolErrorBehavior protocolErrorBehavior, IOBehavior ioBehavior) in /_/src/MySqlConnector/Protocol/Serialization/ProtocolUtility.cs:line 498\n at MySqlConnector.Core.ServerSession.ReceiveReplyAsyncAwaited(ValueTask`1 task) in /_/src/MySqlConnector/Core/ServerSession.cs:line 964\n at MySqlConnector.Core.ServerSession.TryResetConnectionAsync(ConnectionSettings cs, MySqlConnection connection, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ServerSession.cs:line 696\n at MySqlConnector.Core.ConnectionPool.GetSessionAsync(MySqlConnection connection, Int32 startTickCount, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ConnectionPool.cs:line 130\n at MySqlConnector.Core.ConnectionPool.GetSessionAsync(MySqlConnection connection, Int32 startTickCount, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ConnectionPool.cs:line 130\n at MySqlConnector.MySqlConnection.CreateSessionAsync(ConnectionPool pool, Int32 startTickCount, Activity activity, Nullable`1 ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlConnection.cs:line 966\n at MySqlConnector.MySqlConnection.OpenAsync(Nullable`1 ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlConnection.cs:line 457\n at MySqlConnector.MySqlConnection.Open() in /_/src/MySqlConnector/MySqlConnection.cs:line 382\n at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternal(Boolean errorsExpected)\n at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.Open(Boolean errorsExpected)\n at Pomelo.EntityFrameworkCore.MySql.Storage.Internal.MySqlRelationalConnection.Open(Boolean errorsExpected)\n at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject)\n at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.InitializeReader(Enumerator enumerator)\n at Pomelo.EntityFrameworkCore.MySql.Storage.Internal.MySqlExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded)\n at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.MoveNext()","Properties":{"contextType":"OnlineClinic.DAL.OC_DBContext","newline":"\n","error":"MySqlConnector.MySqlProtocolException: Packet received out-of-order. Expected 1; got 2.\n at MySqlConnector.Protocol.Serialization.ProtocolUtility.g__AddContinuation|5_0(ValueTask`1 readPacketTask, BufferedByteReader bufferedByteReader, IByteHandler byteHandler, Func`1 getNextSequenceNumber, ArraySegmentHolder`1 previousPayloads, ProtocolErrorBehavior protocolErrorBehavior, IOBehavior ioBehavior) in /_/src/MySqlConnector/Protocol/Serialization/ProtocolUtility.cs:line 498\n at MySqlConnector.Core.ServerSession.ReceiveReplyAsyncAwaited(ValueTask`1 task) in /_/src/MySqlConnector/Core/ServerSession.cs:line 964\n at MySqlConnector.Core.ServerSession.TryResetConnectionAsync(ConnectionSettings cs, MySqlConnection connection, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ServerSession.cs:line 696\n at MySqlConnector.Core.ConnectionPool.GetSessionAsync(MySqlConnection connection, Int32 startTickCount, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ConnectionPool.cs:line 130\n at MySqlConnector.Core.ConnectionPool.GetSessionAsync(MySqlConnection connection, Int32 startTickCount, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ConnectionPool.cs:line 130\n at MySqlConnector.MySqlConnection.CreateSessionAsync(ConnectionPool pool, Int32 startTickCount, Activity activity, Nullable`1 ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlConnection.cs:line 966\n at MySqlConnector.MySqlConnection.OpenAsync(Nullable`1 ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlConnection.cs:line 457\n at MySqlConnector.MySqlConnection.Open() in /_/src/MySqlConnector/MySqlConnection.cs:line 382\n at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternal(Boolean errorsExpected)\n at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.Open(Boolean errorsExpected)\n at Pomelo.EntityFrameworkCore.MySql.Storage.Internal.MySqlRelationalConnection.Open(Boolean errorsExpected)\n at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject)\n at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.InitializeReader(Enumerator enumerator)\n at Pomelo.EntityFrameworkCore.MySql.Storage.Internal.MySqlExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded)\n at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.MoveNext()","EventId":{"Id":10100,"Name":"Microsoft.EntityFrameworkCore.Query.QueryIterationFailed"},"ActionName":"DoctorController.GetAllDoctor ","RequestPath":"/api/Doctor/GetAllDoctor"}} {"Timestamp":"2025-01-13T09:12:18.0686041+00:00","Level":"Information","MessageTemplate":"New Session Booked {@PatientId} {@DocotrId} {@Date} {@Time} {@Timestamp}","TraceId":"26d8ab0798ac27b71e55b7328ac8b574","SpanId":"8878aba46bf4d9ef","Properties":{"PatientId":"b20b8192-d77b-46d0-8e95-8eaf736c3ede","DocotrId":null,"Date":"2025-01-14T00:00:00.0000000","Time":"13:00:00","Timestamp":"2025-01-13T09:12:18.0685705Z","ActionName":"BookSessionController.CreateBookSession ","RequestPath":"/api/BookSession"}} {"Timestamp":"2025-01-13T09:12:18.0712722+00:00","Level":"Information","MessageTemplate":"Sending Booking Confirmation Emails to Patient and Doctor {@PatientId} {@DocotrId} {@Date} {@Time} {@Timestamp}","TraceId":"26d8ab0798ac27b71e55b7328ac8b574","SpanId":"8878aba46bf4d9ef","Properties":{"PatientId":"b20b8192-d77b-46d0-8e95-8eaf736c3ede","DocotrId":"350f212d-27ab-483a-a9c5-01b2c58fdb35","Date":"2025-01-14T00:00:00.0000000","Time":"13:00:00","Timestamp":"2025-01-13T09:12:18.0712567Z","ActionName":"BookSessionController.CreateBookSession ","RequestPath":"/api/BookSession"}} {"Timestamp":"2025-01-13T09:12:18.3376947+00:00","Level":"Information","MessageTemplate":"Email Sent Successfully :{@Reciever}, {@Subject}, {@Timestamp}","TraceId":"26d8ab0798ac27b71e55b7328ac8b574","SpanId":"8878aba46bf4d9ef","Properties":{"Reciever":"patient@gmail.com","Subject":"Booking Session","Timestamp":"2025-01-13T09:12:18.3376541Z","ActionName":"BookSessionController.CreateBookSession ","RequestPath":"/api/BookSession"}} {"Timestamp":"2025-01-13T09:12:18.7276825+00:00","Level":"Information","MessageTemplate":"Email Sent Successfully :{@Reciever}, {@Subject}, {@Timestamp}","TraceId":"26d8ab0798ac27b71e55b7328ac8b574","SpanId":"8878aba46bf4d9ef","Properties":{"Reciever":"doctor2@3awaafi.com","Subject":"Booking Session","Timestamp":"2025-01-13T09:12:18.7276366Z","ActionName":"BookSessionController.CreateBookSession ","RequestPath":"/api/BookSession"}} {"Timestamp":"2025-01-13T09:53:14.7186264+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-01-13T09:53:14.7186080Z"}} {"Timestamp":"2025-01-13T09:53:14.7284922+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-01-13T09:53:14.7284717Z"}} {"Timestamp":"2025-01-13T10:17:39.6684740+00:00","Level":"Information","MessageTemplate":"User Signed in Successfully:{@Username}, {@Email} ,{@TimestampUTC} ","TraceId":"ac0707ad7c7d81a80aa4d30ac131103e","SpanId":"6fd832f6bd764e8b","Properties":{"Username":"Motaz Siam","Email":"mutaz.s@nxt-level.co","TimestampUTC":"2025-01-13T10:17:39.6684460Z","ActionName":"UserController.Signin ","RequestPath":"/api/User/Signin"}} {"Timestamp":"2025-01-13T10:17:39.6698140+00:00","Level":"Error","MessageTemplate":"Failed executing DbCommand ({elapsed}ms) [Parameters=[{parameters}], CommandType='{commandType}', CommandTimeout='{commandTimeout}']{newLine}{commandText}","TraceId":"ac0707ad7c7d81a80aa4d30ac131103e","SpanId":"6fd832f6bd764e8b","Properties":{"elapsed":"72","parameters":"@__user_Id_0='?' (Size = 255)","commandType":"Text","commandTimeout":30,"newLine":"\n","commandText":"SELECT `a`.`Id`, `a`.`ClaimType`, `a`.`ClaimValue`, `a`.`UserId`\nFROM `AspNetUserClaims` AS `a`\nWHERE `a`.`UserId` = @__user_Id_0","EventId":{"Id":20102,"Name":"Microsoft.EntityFrameworkCore.Database.Command.CommandError"},"ActionName":"UserController.Signin ","RequestPath":"/api/User/Signin"}} {"Timestamp":"2025-01-13T10:17:39.6706881+00:00","Level":"Error","MessageTemplate":"An exception occurred while iterating over the results of a query for context type '{contextType}'.{newline}{error}","TraceId":"ac0707ad7c7d81a80aa4d30ac131103e","SpanId":"6fd832f6bd764e8b","Exception":"System.NullReferenceException: Object reference not set to an instance of an object.\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.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, 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.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()","Properties":{"contextType":"OnlineClinic.DAL.OC_DBContext","newline":"\n","error":"System.NullReferenceException: Object reference not set to an instance of an object.\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.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, 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.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()","EventId":{"Id":10100,"Name":"Microsoft.EntityFrameworkCore.Query.QueryIterationFailed"},"ActionName":"UserController.Signin ","RequestPath":"/api/User/Signin"}} {"Timestamp":"2025-01-13T10:17:49.7884865+00:00","Level":"Error","MessageTemplate":"An error occurred using the connection to database '{database}' on server '{server}'.","TraceId":"71571a63e88f82ae843ed4643a1a0446","SpanId":"d2d29d78569a2047","Properties":{"database":"sokoun","server":"localhost","EventId":{"Id":20004,"Name":"Microsoft.EntityFrameworkCore.Database.Connection.ConnectionError"},"ActionName":"BookSessionController.GetBooksession ","RequestPath":"/api/BookSession/GetallBookSessions"}} {"Timestamp":"2025-01-13T10:17:49.7898654+00:00","Level":"Error","MessageTemplate":"An exception occurred while iterating over the results of a query for context type '{contextType}'.{newline}{error}","TraceId":"71571a63e88f82ae843ed4643a1a0446","SpanId":"d2d29d78569a2047","Exception":"MySqlConnector.MySqlProtocolException: Packet received out-of-order. Expected 1; got 2.\n at MySqlConnector.Protocol.Serialization.ProtocolUtility.g__AddContinuation|5_0(ValueTask`1 readPacketTask, BufferedByteReader bufferedByteReader, IByteHandler byteHandler, Func`1 getNextSequenceNumber, ArraySegmentHolder`1 previousPayloads, ProtocolErrorBehavior protocolErrorBehavior, IOBehavior ioBehavior) in /_/src/MySqlConnector/Protocol/Serialization/ProtocolUtility.cs:line 498\n at MySqlConnector.Core.ServerSession.ReceiveReplyAsyncAwaited(ValueTask`1 task) in /_/src/MySqlConnector/Core/ServerSession.cs:line 964\n at MySqlConnector.Core.ServerSession.TryResetConnectionAsync(ConnectionSettings cs, MySqlConnection connection, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ServerSession.cs:line 696\n at MySqlConnector.Core.ConnectionPool.GetSessionAsync(MySqlConnection connection, Int32 startTickCount, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ConnectionPool.cs:line 130\n at MySqlConnector.Core.ConnectionPool.GetSessionAsync(MySqlConnection connection, Int32 startTickCount, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ConnectionPool.cs:line 130\n at MySqlConnector.MySqlConnection.CreateSessionAsync(ConnectionPool pool, Int32 startTickCount, Activity activity, Nullable`1 ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlConnection.cs:line 966\n at MySqlConnector.MySqlConnection.OpenAsync(Nullable`1 ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlConnection.cs:line 457\n at MySqlConnector.MySqlConnection.Open() in /_/src/MySqlConnector/MySqlConnection.cs:line 382\n at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternal(Boolean errorsExpected)\n at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.Open(Boolean errorsExpected)\n at Pomelo.EntityFrameworkCore.MySql.Storage.Internal.MySqlRelationalConnection.Open(Boolean errorsExpected)\n at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject)\n at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.InitializeReader(Enumerator enumerator)\n at Pomelo.EntityFrameworkCore.MySql.Storage.Internal.MySqlExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded)\n at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.MoveNext()","Properties":{"contextType":"OnlineClinic.DAL.OC_DBContext","newline":"\n","error":"MySqlConnector.MySqlProtocolException: Packet received out-of-order. Expected 1; got 2.\n at MySqlConnector.Protocol.Serialization.ProtocolUtility.g__AddContinuation|5_0(ValueTask`1 readPacketTask, BufferedByteReader bufferedByteReader, IByteHandler byteHandler, Func`1 getNextSequenceNumber, ArraySegmentHolder`1 previousPayloads, ProtocolErrorBehavior protocolErrorBehavior, IOBehavior ioBehavior) in /_/src/MySqlConnector/Protocol/Serialization/ProtocolUtility.cs:line 498\n at MySqlConnector.Core.ServerSession.ReceiveReplyAsyncAwaited(ValueTask`1 task) in /_/src/MySqlConnector/Core/ServerSession.cs:line 964\n at MySqlConnector.Core.ServerSession.TryResetConnectionAsync(ConnectionSettings cs, MySqlConnection connection, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ServerSession.cs:line 696\n at MySqlConnector.Core.ConnectionPool.GetSessionAsync(MySqlConnection connection, Int32 startTickCount, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ConnectionPool.cs:line 130\n at MySqlConnector.Core.ConnectionPool.GetSessionAsync(MySqlConnection connection, Int32 startTickCount, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ConnectionPool.cs:line 130\n at MySqlConnector.MySqlConnection.CreateSessionAsync(ConnectionPool pool, Int32 startTickCount, Activity activity, Nullable`1 ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlConnection.cs:line 966\n at MySqlConnector.MySqlConnection.OpenAsync(Nullable`1 ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlConnection.cs:line 457\n at MySqlConnector.MySqlConnection.Open() in /_/src/MySqlConnector/MySqlConnection.cs:line 382\n at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternal(Boolean errorsExpected)\n at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.Open(Boolean errorsExpected)\n at Pomelo.EntityFrameworkCore.MySql.Storage.Internal.MySqlRelationalConnection.Open(Boolean errorsExpected)\n at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject)\n at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.InitializeReader(Enumerator enumerator)\n at Pomelo.EntityFrameworkCore.MySql.Storage.Internal.MySqlExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded)\n at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.MoveNext()","EventId":{"Id":10100,"Name":"Microsoft.EntityFrameworkCore.Query.QueryIterationFailed"},"ActionName":"BookSessionController.GetBooksession ","RequestPath":"/api/BookSession/GetallBookSessions"}} {"Timestamp":"2025-01-13T10:53:14.7053005+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-01-13T10:53:14.7052854Z"}} {"Timestamp":"2025-01-13T10:53:14.7117547+00:00","Level":"Information","MessageTemplate":"Sending Session One Day Reminder Emails to Patient and Doctor {@PatientId} {@DocotrId} {@Date} {@Time} {@Timestamp}","Properties":{"PatientId":"b20b8192-d77b-46d0-8e95-8eaf736c3ede","DocotrId":"350f212d-27ab-483a-a9c5-01b2c58fdb35","Date":"2025-01-14T00:00:00.0000000","Time":"13:00:00","Timestamp":"2025-01-13T10:53:14.7117363Z"}} {"Timestamp":"2025-01-13T10:53:14.9515382+00:00","Level":"Information","MessageTemplate":"Email Sent Successfully :{@Reciever}, {@Subject}, {@Timestamp}","Properties":{"Reciever":"patient@gmail.com","Subject":"Reminder Session","Timestamp":"2025-01-13T10:53:14.9515021Z"}} {"Timestamp":"2025-01-13T10:53:15.3655404+00:00","Level":"Information","MessageTemplate":"Email Sent Successfully :{@Reciever}, {@Subject}, {@Timestamp}","Properties":{"Reciever":"doctor2@3awaafi.com","Subject":"Reminder Session","Timestamp":"2025-01-13T10:53:15.3654435Z"}} {"Timestamp":"2025-01-13T10:53:15.5945539+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-01-13T10:53:15.5945279Z"}} {"Timestamp":"2025-01-13T11:53:14.7238285+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-01-13T11:53:14.7238128Z"}} {"Timestamp":"2025-01-13T11:53:14.7319861+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-01-13T11:53:14.7319648Z"}} {"Timestamp":"2025-01-13T12:53:14.7123738+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-01-13T12:53:14.7123589Z"}} {"Timestamp":"2025-01-13T12:53:14.7204460+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-01-13T12:53:14.7204281Z"}} {"Timestamp":"2025-01-13T13:53:14.7323719+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-01-13T13:53:14.7323544Z"}} {"Timestamp":"2025-01-13T13:53:14.7424544+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-01-13T13:53:14.7424335Z"}} {"Timestamp":"2025-01-13T14:31:23.5695048+00:00","Level":"Information","MessageTemplate":"User Signed in Successfully:{@Username}, {@Email} ,{@TimestampUTC} ","TraceId":"5fa93bb089a901a0d8d2dd0f42b1081c","SpanId":"27060a93b62a4e5e","Properties":{"Username":"Motaz Siam","Email":"mutaz.s@nxt-level.co","TimestampUTC":"2025-01-13T14:31:23.5694777Z","ActionName":"UserController.Signin ","RequestPath":"/api/User/Signin"}} {"Timestamp":"2025-01-13T14:31:23.5709217+00:00","Level":"Error","MessageTemplate":"Failed executing DbCommand ({elapsed}ms) [Parameters=[{parameters}], CommandType='{commandType}', CommandTimeout='{commandTimeout}']{newLine}{commandText}","TraceId":"5fa93bb089a901a0d8d2dd0f42b1081c","SpanId":"27060a93b62a4e5e","Properties":{"elapsed":"84","parameters":"@__user_Id_0='?' (Size = 255)","commandType":"Text","commandTimeout":30,"newLine":"\n","commandText":"SELECT `a`.`Id`, `a`.`ClaimType`, `a`.`ClaimValue`, `a`.`UserId`\nFROM `AspNetUserClaims` AS `a`\nWHERE `a`.`UserId` = @__user_Id_0","EventId":{"Id":20102,"Name":"Microsoft.EntityFrameworkCore.Database.Command.CommandError"},"ActionName":"UserController.Signin ","RequestPath":"/api/User/Signin"}} {"Timestamp":"2025-01-13T14:31:23.5719408+00:00","Level":"Error","MessageTemplate":"An exception occurred while iterating over the results of a query for context type '{contextType}'.{newline}{error}","TraceId":"5fa93bb089a901a0d8d2dd0f42b1081c","SpanId":"27060a93b62a4e5e","Exception":"System.NullReferenceException: Object reference not set to an instance of an object.\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.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, 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.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()","Properties":{"contextType":"OnlineClinic.DAL.OC_DBContext","newline":"\n","error":"System.NullReferenceException: Object reference not set to an instance of an object.\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.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, 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.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()","EventId":{"Id":10100,"Name":"Microsoft.EntityFrameworkCore.Query.QueryIterationFailed"},"ActionName":"UserController.Signin ","RequestPath":"/api/User/Signin"}} {"Timestamp":"2025-01-13T14:31:26.5663925+00:00","Level":"Error","MessageTemplate":"An error occurred using the connection to database '{database}' on server '{server}'.","TraceId":"f8fea3f0e9ace11c7f1ff82d36a1a30c","SpanId":"5e9a1748b2d0d66a","Properties":{"database":"sokoun","server":"localhost","EventId":{"Id":20004,"Name":"Microsoft.EntityFrameworkCore.Database.Connection.ConnectionError"},"ActionName":"BookSessionController.GetBooksession ","RequestPath":"/api/BookSession/GetallBookSessions"}} {"Timestamp":"2025-01-13T14:31:26.5673640+00:00","Level":"Error","MessageTemplate":"An exception occurred while iterating over the results of a query for context type '{contextType}'.{newline}{error}","TraceId":"f8fea3f0e9ace11c7f1ff82d36a1a30c","SpanId":"5e9a1748b2d0d66a","Exception":"MySqlConnector.MySqlProtocolException: Packet received out-of-order. Expected 1; got 2.\n at MySqlConnector.Protocol.Serialization.ProtocolUtility.g__AddContinuation|5_0(ValueTask`1 readPacketTask, BufferedByteReader bufferedByteReader, IByteHandler byteHandler, Func`1 getNextSequenceNumber, ArraySegmentHolder`1 previousPayloads, ProtocolErrorBehavior protocolErrorBehavior, IOBehavior ioBehavior) in /_/src/MySqlConnector/Protocol/Serialization/ProtocolUtility.cs:line 498\n at MySqlConnector.Core.ServerSession.ReceiveReplyAsyncAwaited(ValueTask`1 task) in /_/src/MySqlConnector/Core/ServerSession.cs:line 964\n at MySqlConnector.Core.ServerSession.TryResetConnectionAsync(ConnectionSettings cs, MySqlConnection connection, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ServerSession.cs:line 696\n at MySqlConnector.Core.ConnectionPool.GetSessionAsync(MySqlConnection connection, Int32 startTickCount, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ConnectionPool.cs:line 130\n at MySqlConnector.Core.ConnectionPool.GetSessionAsync(MySqlConnection connection, Int32 startTickCount, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ConnectionPool.cs:line 130\n at MySqlConnector.MySqlConnection.CreateSessionAsync(ConnectionPool pool, Int32 startTickCount, Activity activity, Nullable`1 ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlConnection.cs:line 966\n at MySqlConnector.MySqlConnection.OpenAsync(Nullable`1 ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlConnection.cs:line 457\n at MySqlConnector.MySqlConnection.Open() in /_/src/MySqlConnector/MySqlConnection.cs:line 382\n at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternal(Boolean errorsExpected)\n at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.Open(Boolean errorsExpected)\n at Pomelo.EntityFrameworkCore.MySql.Storage.Internal.MySqlRelationalConnection.Open(Boolean errorsExpected)\n at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject)\n at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.InitializeReader(Enumerator enumerator)\n at Pomelo.EntityFrameworkCore.MySql.Storage.Internal.MySqlExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded)\n at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.MoveNext()","Properties":{"contextType":"OnlineClinic.DAL.OC_DBContext","newline":"\n","error":"MySqlConnector.MySqlProtocolException: Packet received out-of-order. Expected 1; got 2.\n at MySqlConnector.Protocol.Serialization.ProtocolUtility.g__AddContinuation|5_0(ValueTask`1 readPacketTask, BufferedByteReader bufferedByteReader, IByteHandler byteHandler, Func`1 getNextSequenceNumber, ArraySegmentHolder`1 previousPayloads, ProtocolErrorBehavior protocolErrorBehavior, IOBehavior ioBehavior) in /_/src/MySqlConnector/Protocol/Serialization/ProtocolUtility.cs:line 498\n at MySqlConnector.Core.ServerSession.ReceiveReplyAsyncAwaited(ValueTask`1 task) in /_/src/MySqlConnector/Core/ServerSession.cs:line 964\n at MySqlConnector.Core.ServerSession.TryResetConnectionAsync(ConnectionSettings cs, MySqlConnection connection, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ServerSession.cs:line 696\n at MySqlConnector.Core.ConnectionPool.GetSessionAsync(MySqlConnection connection, Int32 startTickCount, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ConnectionPool.cs:line 130\n at MySqlConnector.Core.ConnectionPool.GetSessionAsync(MySqlConnection connection, Int32 startTickCount, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ConnectionPool.cs:line 130\n at MySqlConnector.MySqlConnection.CreateSessionAsync(ConnectionPool pool, Int32 startTickCount, Activity activity, Nullable`1 ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlConnection.cs:line 966\n at MySqlConnector.MySqlConnection.OpenAsync(Nullable`1 ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlConnection.cs:line 457\n at MySqlConnector.MySqlConnection.Open() in /_/src/MySqlConnector/MySqlConnection.cs:line 382\n at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternal(Boolean errorsExpected)\n at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.Open(Boolean errorsExpected)\n at Pomelo.EntityFrameworkCore.MySql.Storage.Internal.MySqlRelationalConnection.Open(Boolean errorsExpected)\n at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject)\n at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.InitializeReader(Enumerator enumerator)\n at Pomelo.EntityFrameworkCore.MySql.Storage.Internal.MySqlExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded)\n at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.MoveNext()","EventId":{"Id":10100,"Name":"Microsoft.EntityFrameworkCore.Query.QueryIterationFailed"},"ActionName":"BookSessionController.GetBooksession ","RequestPath":"/api/BookSession/GetallBookSessions"}} {"Timestamp":"2025-01-13T14:53:14.6728295+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-01-13T14:53:14.6728124Z"}} {"Timestamp":"2025-01-13T14:53:14.6781924+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-01-13T14:53:14.6781778Z"}} {"Timestamp":"2025-01-13T15:53:14.6719377+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-01-13T15:53:14.6719224Z"}} {"Timestamp":"2025-01-13T15:53:14.6781437+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-01-13T15:53:14.6781258Z"}} {"Timestamp":"2025-01-13T16:53:14.6749759+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-01-13T16:53:14.6749512Z"}} {"Timestamp":"2025-01-13T16:53:14.6833885+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-01-13T16:53:14.6833656Z"}} {"Timestamp":"2025-01-13T17:53:14.7185579+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-01-13T17:53:14.7185424Z"}} {"Timestamp":"2025-01-13T17:53:14.7256702+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-01-13T17:53:14.7256556Z"}} {"Timestamp":"2025-01-13T18:53:14.7056680+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-01-13T18:53:14.7056536Z"}} {"Timestamp":"2025-01-13T18:53:14.7130887+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-01-13T18:53:14.7130735Z"}} {"Timestamp":"2025-01-13T19:53:14.7117251+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-01-13T19:53:14.7117073Z"}} {"Timestamp":"2025-01-13T19:53:14.7201576+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-01-13T19:53:14.7201404Z"}} {"Timestamp":"2025-01-13T20:53:14.7181027+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-01-13T20:53:14.7180866Z"}} {"Timestamp":"2025-01-13T20:53:14.7264886+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-01-13T20:53:14.7264704Z"}} {"Timestamp":"2025-01-13T21:53:14.7134791+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-01-13T21:53:14.7134634Z"}} {"Timestamp":"2025-01-13T21:53:14.7227846+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-01-13T21:53:14.7227581Z"}} {"Timestamp":"2025-01-13T22:53:14.7069138+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-01-13T22:53:14.7068989Z"}} {"Timestamp":"2025-01-13T22:53:14.7154262+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-01-13T22:53:14.7154069Z"}} {"Timestamp":"2025-01-13T23:53:14.7115443+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Started {@Timestamp}","Properties":{"Timestamp":"2025-01-13T23:53:14.7115284Z"}} {"Timestamp":"2025-01-13T23:53:14.7196523+00:00","Level":"Information","MessageTemplate":" Background Task: Refresh Session Booking Status Completed {@Timestamp}","Properties":{"Timestamp":"2025-01-13T23:53:14.7196370Z"}}