No funded issue found.
Check out the Issue Explorer
Be the OSS Funding you wish to see in the world.
Looking to fund some work? You can submit a new Funded Issue here .
Time left
Opened
Issue Type
Workers Auto Approve
Project Type
Time Commitment
Experience Level
Permissions
Accepted
Reserved For
DB Performance Queries v2
poanetwork
Dockerfile
## Pages
The list below includes links to specific pages that still are loading slow or fail to load.
* https://blockscout.com/eth/mainnet/tokens/0x08ceed1e8db59acbb687a5752f0a7db815cfda5e
* https://blockscout.com/eth/mainnet/tokens/0x595832f8fc6bf59c85c527fec3740a1b7a361269/token_transfers
* https://blockscout.com/eth/mainnet/tokens/0x06012c8cf97bead5deae237070f9587f8e7a266d/token_transfers
## Scripts
These migration scripts have an estimated completion time of over a year for completion. Looping through in smaller batches can be done to complete these much sooner but it would be good to understand what can be done under the hood to Postgres to help with this situation.
* https://github.com/poanetwork/blockscout/blob/master/apps/explorer/priv/repo/migrations/scripts/update_replaced_transaction.sql
* https://github.com/poanetwork/blockscout/blob/master/apps/explorer/priv/repo/migrations/scripts/update_new_tokens_holder_count_in_batches.sql
* https://github.com/poanetwork/blockscout/blob/master/apps/explorer/priv/repo/migrations/scripts/update_address_current_token_balances_in_batches.sql
* https://github.com/poanetwork/blockscout/blob/master/apps/explorer/priv/repo/migrations/scripts/transaction_update_in_batches.sql
## Queries
We continue to have issues on any count queries on the `transactions` table, `token_transfers` table, and `address_current_token_balance` tables.
## Specific Errors
The below deadlock occurs on the `address_coin_balance` and `transactions` table on a consistent basis. Both address and transactions are sorted which is the recommended way to avoid deadlocks.
```
Process 440 waits for ShareLock on transaction 1804; blocked by process 433.
Process 433 waits for ShareLock on transaction 1823; blocked by process 440.
code: for x <- 100..0 do
stacktrace:
(ecto) lib/ecto/adapters/sql.ex:554: Ecto.Adapters.SQL.struct/8
(ecto) lib/ecto/repo/schema.ex:547: Ecto.Repo.Schema.apply/4
(ecto) lib/ecto/repo/schema.ex:213: anonymous fn/14 in Ecto.Repo.Schema.do_insert/4
(ecto) lib/ecto/repo/schema.ex:774: anonymous fn/3 in Ecto.Repo.Schema.wrap_in_transaction/6
(ecto) lib/ecto/adapters/sql.ex:576: anonymous fn/3 in Ecto.Adapters.SQL.do_transaction/3
(db_connection) lib/db_connection.ex:1283: DBConnection.transaction_run/4
(db_connection) lib/db_connection.ex:1207: DBConnection.run_begin/3
(db_connection) lib/db_connection.ex:798: DBConnection.transaction/3
(ecto) lib/ecto/repo/schema.ex:125: Ecto.Repo.Schema.insert!/4
test/explorer_web/features/viewing_chain_test.exs:35: anonymous fn/3 in ExplorerWeb.ViewingChainTest."test statistics average block time live updates"/1
(elixir) lib/enum.ex:2949: Enum.reduce_range_dec/4
test/explorer_web/features/viewing_chain_test.exs:34: (test)
```
Setup your profile
Tell us a little about you:
Skills
No results found for [[search]] .
Type to search skills..
Bio Required
[[totalcharacter]] / 240
Are you currently looking for work?
[[ option.string ]]
Next
Setup your profile
Our tools are based on the principles of earn (💰), learn (📖), and meet (💬).
Select the ones you are interested in. You can change it later in your settings.
I'm also an organization manager looking for a great community.
Back
Next
Save
Enable your organization profile
Gitcoin products can help grow community around your brand. Create your tribe, events, and incentivize your community with bounties. Announce new and upcoming events using townsquare. Find top-quality hackers and fund them to work with you on a grant.
These are the organizations you own. If you don't see your organization here please be sure that information is public on your GitHub profile. Gitcoin will sync this information for you.
Select the products you are interested in:
Out of the box you will receive Tribes Lite for your organization. Please provide us with a contact email:
Email
Back
Save
