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

[7.14] Slow coroutine step execution (34.290 seconds): BandwidthDatabase.get_total_taken #8032

Closed
kozlovsky opened this issue May 22, 2024 · 1 comment

Comments

@kozlovsky
Copy link
Collaborator

The Sentry issue: https://sentry.tribler.org/organizations/tribler/issues/2752/events/8d70ebb8a60549d6a28120edcb669201/

  File "C:\Users\<relief>\AppData\Local\Programs\Python\Python38\lib\site-packages\ipv8\taskmanager.py", line 24, in delay_runner (function started 34.290 seconds ago)
  File "C:\Users\<relief>\AppData\Local\Programs\Python\Python38\lib\site-packages\ipv8\util.py", line 35, in call_async (function started 34.290 seconds ago)
  File "C:\Users\<relief>\AppData\Local\Programs\Python\Python38\lib\site-packages\ipv8\requestcache.py", line 251, in _on_timeout (function started 34.290 seconds ago)
  File "C:\Users\<relief>\AppData\Local\Programs\Python\Python38\lib\site-packages\ipv8\messaging\anonymization\caches.py", line 70, in on_timeout (function started 34.290 seconds ago)
  File "src\<relief>\core\components\tunnel\community\tunnel_community.py", line 409, in remove_circuit (function started 34.290 seconds ago)
  File "src\<relief>\core\components\tunnel\community\tunnel_community.py", line 325, in do_payout (function started 34.290 seconds ago)
  File "<string>", line 2, in insert (function started 33.504 seconds ago)
  File "C:\Users\<relief>\AppData\Local\Programs\Python\Python38\lib\site-packages\pony\orm\core.py", line 519, in new_func (function started 33.504 seconds ago), 
  File "src\<relief>\core\components\bandwidth_accounting\db\transaction.py", line 167, in insert (function started 33.500 seconds ago), 
  File "src\<relief>\core\components\bandwidth_accounting\db\database.py", line 153, in get_my_balance (function started 33.248 seconds ago)
  File "<string>", line 2, in get_balance (function started 33.248 seconds ago)
  File "C:\Users\<relief>\AppData\Local\Programs\Python\Python38\lib\site-packages\pony\orm\core.py", line 506, in new_func (function started 33.248 seconds ago)
  File "src\<relief>\core\components\bandwidth_accounting\db\database.py", line 146, in get_balance (function started 33.248 seconds ago)
  File "<string>", line 2, in get_total_taken (function started 27.501 seconds ago)
  File "C:\Users\<relief>\AppData\Local\Programs\Python\Python38\lib\site-packages\pony\orm\core.py", line 506, in new_func (function started 27.501 seconds ago)
  File "src\<relief>\core\components\bandwidth_accounting\db\database.py", line 126, in get_total_taken (function started 27.501 seconds ago)

It looks like BandwidthCommunity has some inefficient queries.

@kozlovsky
Copy link
Collaborator Author

We can consider the issue fixed as BandwidthCommunity was removed in #7336.

@kozlovsky kozlovsky changed the title [7.14] Slow coroutine step execution: BandwidthDatabase.get_total_taken [7.14] Slow coroutine step execution (34.290 seconds): BandwidthDatabase.get_total_taken May 22, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant