Development resources at your finger tips
Build with the coolest Web3 projects
Recurring funding for Open Source
Learn about Web3 & earn rewards
Show appreciation for each other
Meet fellow developers, designers, futurists and more. Collaborate and BUIDL awesome projects together.
Discover great web3 organizations, work on meaningful projects and build relationships with like minded people. Browse Tribes
Meet the top hunters and contributors from our community.
Hello, Gitcoiners! At Gitcoin, we love bringing good news — new projects built, relationships formed, skills learned. Even better when we find …
Hello, Gitcoiners & Gitcoinerettes! It’s happening again – happy blockchain times are coming to San Francisco 🎉, as the San Francisco…
Gitcoin is GDPR complaint. Learn more in
Gitcoin's Terms & Conditions.
Check out the Issue Explorer
Looking to fund some work? You can submit a new Funded Issue here.
The list below includes links to specific pages that still are loading slow or fail to load.
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.
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
(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