webapi-20260417.log 15 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143
  1. 2026-04-17 11:49:03.322 [INF] [LiveChat] YouTubeLiveChatService 준비 완료
  2. 2026-04-17 11:49:03.582 [INF] Now listening on: http://localhost:4000
  3. 2026-04-17 11:49:03.582 [INF] Application started. Press Ctrl+C to shut down.
  4. 2026-04-17 11:49:03.582 [INF] Hosting environment: Production
  5. 2026-04-17 11:49:03.583 [INF] Content root path: E:\workspace\dpot\Backend\Web.Api
  6. 2026-04-17 11:49:18.336 [INF] [ChannelCache] 채널 캐시 갱신 서비스 시작 — 주기: 1시간
  7. 2026-04-17 11:49:21.928 [ERR] Failed executing DbCommand (32ms) [Parameters=[], CommandType='"Text"', CommandTimeout='30']
  8. SELECT [c].[SID]
  9. FROM [Channel] AS [c]
  10. WHERE [c].[IsActive] = CAST(1 AS bit)
  11. 2026-04-17 11:49:21.980 [ERR] An exception occurred while iterating over the results of a query for context type 'Infrastructure.Persistence.AppDbContext'.
  12. Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid object name 'Channel'.
  13. at Microsoft.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__195_0(Task`1 result)
  14. at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
  15. at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
  16. --- End of stack trace from previous location ---
  17. at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
  18. at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
  19. --- End of stack trace from previous location ---
  20. at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
  21. at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
  22. at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken)
  23. at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)
  24. at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
  25. ClientConnectionId:fce8ca82-f83b-4228-873d-cfad2976ec75
  26. Error Number:208,State:1,Class:16
  27. Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid object name 'Channel'.
  28. at Microsoft.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__195_0(Task`1 result)
  29. at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
  30. at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
  31. --- End of stack trace from previous location ---
  32. at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
  33. at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
  34. --- End of stack trace from previous location ---
  35. at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
  36. at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
  37. at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken)
  38. at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)
  39. at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
  40. ClientConnectionId:fce8ca82-f83b-4228-873d-cfad2976ec75
  41. Error Number:208,State:1,Class:16
  42. 2026-04-17 11:49:21.983 [ERR] [ChannelCache] 채널 캐시 갱신 중 오류
  43. Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid object name 'Channel'.
  44. at Microsoft.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__195_0(Task`1 result)
  45. at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
  46. at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
  47. --- End of stack trace from previous location ---
  48. at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
  49. at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
  50. --- End of stack trace from previous location ---
  51. at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
  52. at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
  53. at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken)
  54. at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)
  55. at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
  56. at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
  57. at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
  58. at Infrastructure.YouTube.YouTubeChannelCacheRefreshService.RefreshAllChannelsAsync(CancellationToken ct) in E:\workspace\dpot\Backend\Infrastructure\YouTube\YouTubeChannelCacheRefreshService.cs:line 53
  59. at Infrastructure.YouTube.YouTubeChannelCacheRefreshService.ExecuteAsync(CancellationToken stoppingToken) in E:\workspace\dpot\Backend\Infrastructure\YouTube\YouTubeChannelCacheRefreshService.cs:line 35
  60. ClientConnectionId:fce8ca82-f83b-4228-873d-cfad2976ec75
  61. Error Number:208,State:1,Class:16
  62. 2026-04-17 11:49:33.333 [INF] [PubSub Renewal] 서비스 시작 — 갱신 주기: 7일
  63. 2026-04-17 11:49:33.336 [INF] [PubSub Renewal] 구독 중인 채널 없음
  64. 2026-04-17 11:49:46.904 [INF] Request starting HTTP/1.1 GET http://localhost:4000/api/config - null null
  65. 2026-04-17 11:49:47.106 [INF] Executing endpoint 'HTTP: GET api/config'
  66. 2026-04-17 11:49:47.108 [WRN] You do not have a valid license key for the Lucky Penny software MediatR. This is allowed for development and testing scenarios. If you are running in production you are required to have a licensed version. Please visit https://luckypennysoftware.com to obtain a valid license.
  67. 2026-04-17 11:49:47.111 [INF] [Start] Query
  68. 2026-04-17 11:49:47.135 [INF] [End] Query
  69. 2026-04-17 11:49:47.138 [INF] Setting HTTP status code 200.
  70. 2026-04-17 11:49:47.140 [INF] Writing value of type 'ApiResponse' as Json.
  71. 2026-04-17 11:49:47.150 [INF] Executed endpoint 'HTTP: GET api/config'
  72. 2026-04-17 11:49:47.152 [INF] Request finished HTTP/1.1 GET http://localhost:4000/api/config - 200 null application/json; charset=utf-8 248.9748ms
  73. 2026-04-17 11:49:54.289 [INF] Request starting HTTP/1.1 GET http://localhost:4000/api/member/test/followers - null null
  74. 2026-04-17 11:49:54.292 [INF] Executing endpoint 'HTTP: GET api/member/{memberSID}/followers'
  75. 2026-04-17 11:49:54.293 [INF] [Start] Query
  76. 2026-04-17 11:49:54.337 [ERR] Failed executing DbCommand (12ms) [Parameters=[@request_MemberSID='?' (Size = 20)], CommandType='"Text"', CommandTimeout='30']
  77. SELECT TOP(1) [m].[ID]
  78. FROM [Member] AS [m]
  79. WHERE [m].[SID] = @request_MemberSID AND [m].[IsWithdraw] = CAST(0 AS bit)
  80. 2026-04-17 11:49:54.338 [ERR] An exception occurred while iterating over the results of a query for context type 'Infrastructure.Persistence.AppDbContext'.
  81. Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid object name 'Member'.
  82. at Microsoft.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__195_0(Task`1 result)
  83. at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
  84. at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
  85. --- End of stack trace from previous location ---
  86. at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
  87. at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
  88. --- End of stack trace from previous location ---
  89. at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
  90. at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
  91. at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken)
  92. at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)
  93. at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
  94. ClientConnectionId:fce8ca82-f83b-4228-873d-cfad2976ec75
  95. Error Number:208,State:1,Class:16
  96. Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid object name 'Member'.
  97. at Microsoft.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__195_0(Task`1 result)
  98. at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
  99. at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
  100. --- End of stack trace from previous location ---
  101. at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
  102. at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
  103. --- End of stack trace from previous location ---
  104. at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
  105. at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
  106. at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken)
  107. at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)
  108. at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
  109. ClientConnectionId:fce8ca82-f83b-4228-873d-cfad2976ec75
  110. Error Number:208,State:1,Class:16
  111. 2026-04-17 11:49:54.339 [INF] Executed endpoint 'HTTP: GET api/member/{memberSID}/followers'
  112. 2026-04-17 11:49:54.341 [ERR] Unhandled exception occurred
  113. Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid object name 'Member'.
  114. at Microsoft.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__195_0(Task`1 result)
  115. at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
  116. at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
  117. --- End of stack trace from previous location ---
  118. at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
  119. at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
  120. --- End of stack trace from previous location ---
  121. at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
  122. at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
  123. at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken)
  124. at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)
  125. at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
  126. at Microsoft.EntityFrameworkCore.Query.ShapedQueryCompilingExpressionVisitor.SingleOrDefaultAsync[TSource](IAsyncEnumerable`1 asyncEnumerable, CancellationToken cancellationToken)
  127. at Microsoft.EntityFrameworkCore.Query.ShapedQueryCompilingExpressionVisitor.SingleOrDefaultAsync[TSource](IAsyncEnumerable`1 asyncEnumerable, CancellationToken cancellationToken)
  128. at Application.Features.Api.Member.Follow.GetFollowers.Handler.Handle(Query request, CancellationToken ct) in E:\workspace\dpot\Backend\Application\Features\Api\Member\Follow\GetFollowers\Handler.cs:line 12
  129. at Application.Behaviors.LoggingBehavior`2.Handle(TRequest request, RequestHandlerDelegate`1 next, CancellationToken ct) in E:\workspace\dpot\Backend\Application\Behaviors\LoggingBehavior.cs:line 17
  130. at Web.Api.Endpoints.Member.Follow.Followers.<>c.<<MapEndpoint>b__0_0>d.MoveNext() in E:\workspace\dpot\Backend\Web.Api\Endpoints\Member\Follow\Followers.cs:line 24
  131. --- End of stack trace from previous location ---
  132. at Microsoft.AspNetCore.Http.RequestDelegateFactory.ExecuteTaskResult[T](Task`1 task, HttpContext httpContext)
  133. at Microsoft.AspNetCore.Routing.EndpointMiddleware.<Invoke>g__AwaitRequestTask|7_0(Endpoint endpoint, Task requestTask, ILogger logger)
  134. at Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invoke(HttpContext context)
  135. at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context)
  136. at Microsoft.AspNetCore.Diagnostics.ExceptionHandlerMiddlewareImpl.<Invoke>g__Awaited|10_0(ExceptionHandlerMiddlewareImpl middleware, HttpContext context, Task task)
  137. ClientConnectionId:fce8ca82-f83b-4228-873d-cfad2976ec75
  138. Error Number:208,State:1,Class:16
  139. 2026-04-17 11:49:54.367 [INF] Request finished HTTP/1.1 GET http://localhost:4000/api/member/test/followers - 500 null application/json; charset=utf-8 78.5453ms
  140. 2026-04-17 11:51:03.335 [INF] [YouTubeDailyAggregator] 서비스 시작 — 매일 KST 00:00 실행
  141. 2026-04-17 11:51:03.336 [INF] [YouTubeDailyAggregator] 다음 실행까지 대기: 12시간 8분
  142. 2026-04-17 11:52:03.325 [INF] [RankingAggregator] 서비스 시작 — 매일 KST 00:30 실행
  143. 2026-04-17 11:52:03.326 [INF] [RankingAggregator] 다음 실행까지 대기: 12시간 37분