Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Investigate exceptions happening with the Scheduler #167

Open
joaopgrassi opened this issue Aug 21, 2021 · 0 comments
Open

Investigate exceptions happening with the Scheduler #167

joaopgrassi opened this issue Aug 21, 2021 · 0 comments
Labels
bug Something isn't working

Comments

@joaopgrassi
Copy link
Member

While trying to find out what happened on #165, I noticed that the postgres container logs a log of these messages:

2021-08-21 01:07:21.819 UTC [14052] ERROR:  canceling statement due to user request
2021-08-21 01:07:21.819 UTC [14052] STATEMENT:  SELECT package_id FROM pending_packages_daily_downloads

Also we get exceptions like these on Sentry:

Npgsql.NpgsqlException: Exception while reading from stream
  ?, in async ValueTask<IBackendMessage> NpgsqlConnector.ReadMessage(bool async, DataRowLoadingMode dataRowLoadingMode, bool readingNotifications)+ReadMessageLong(?)
  ?, in async Task<bool> NpgsqlDataReader.NextResult(bool async, bool isConsuming, CancellationToken cancellationToken)
  ?, in async ValueTask<NpgsqlDataReader> NpgsqlCommand.ExecuteReader(CommandBehavior behavior, bool async, CancellationToken cancellationToken) x 2
  File "/home/runner/work/nuget-trends/nuget-trends/src/NuGetTrends.Scheduler/DailyDownloadPackageIdPublisher.cs", line 74, col 21, in async Task DailyDownloadPackageIdPublisher.Import(IJobCancellationToken token)
  File "/home/runner/work/nuget-trends/nuget-trends/src/NuGetTrends.Scheduler/DailyDownloadPackageIdPublisher.cs", line 105, col 21, in async Task DailyDownloadPackageIdPublisher.Import(IJobCancellationToken token) x 2
  ?, in void TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

A brief read indicates that it might be related to connection polling, or maybe some cancellation being triggered by something.
npgsql/npgsql#2711
npgsql/npgsql#3052

@joaopgrassi joaopgrassi added the bug Something isn't working label Aug 21, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant