Comments (24)
JABirchall
commented on May 21, 2024
1
This is problem with statistics microservices called
stats. This service has to connect to blockscout database and it cannot due to problem with username. You can adjustblockscout-database-urlusing this ENV variable: https://github.com/blockscout/blockscout/blob/master/docker-compose/services/docker-compose-stats.yml#L52
Ahh you changed all the credentals in the docker files. :(
We are now getting this error thrown by backend after fixing the credentials.
backend | warning: redefining module ConfigHelper (current version defined in memory)
backend | config/config_helper.exs:1
backend |
backend |
backend | warning: redefining module ConfigHelper (current version defined in memory)
backend | config/config_helper.exs:1
backend |
backend |
backend | Starting dependencies..
backend | Starting repos..
backend | ** (EXIT from #PID<0.131.0>) an exception was raised:
backend | ** (Protocol.UndefinedError) protocol Enumerable not implemented for nil of type Atom. This protocol is implemented for the following type(s): Cldr.Unit.Range, DBConnection.PrepareStream, DBConnection.Stream, Date.Range, Ecto.Adapters.SQL.Stream, File.Stream, Floki.HTMLTree, Flow, Function, GenEvent.Stream, HashDict, HashSet, IO.Stream, Indexer.BoundQueue, Jason.OrderedObject, List, Map, MapSet, Postgrex.Stream, Range, Stream, Timex.Interval
backend | (elixir 1.14.5) lib/enum.ex:1: Enumerable.impl_for!/1
backend | (elixir 1.14.5) lib/enum.ex:166: Enumerable.reduce/3
backend | (elixir 1.14.5) lib/enum.ex:4307: Enum.reverse/1
backend | (elixir 1.14.5) lib/keyword.ex:202: Keyword.new/2
backend | lib/explorer/repo/config_helper.ex:43: Explorer.Repo.ConfigHelper.extract_parameters/1
backend | lib/explorer/repo/config_helper.ex:26: Explorer.Repo.ConfigHelper.get_db_config/1
backend | lib/explorer/repo.ex:20: Explorer.Repo.init/2
backend | (ecto 3.10.3) lib/ecto/repo/supervisor.ex:25: Ecto.Repo.Supervisor.runtime_config/4
backend |
backend |
backend exited with code 1
from blockscout.
JABirchall
commented on May 21, 2024
1
@JABirchall is that node public one? It is possible to get its endpoint in order to reproduce exact your issue?
Yes, https://rpc.rethereum.org/
from blockscout.
vbaranov
commented on May 21, 2024
1
@vbaranov Could you also fix the regex error here: https://github.com/blockscout/blockscout/blob/master/apps/explorer/lib/explorer/repo/config_helper.ex#L41
The username:password seperator should not be required if there is no password.
Currently
scheme://username@host:345/dbfails.Idealy scheme://[email protected]:456/sads scheme://username:@host.sdasd:456/sads scheme://username:[email protected]:456/sads should all pass
Like maybe
\w*:\/\/(?<username>[a-zA-Z0-9_-]*)(:(?<password>[a-zA-Z0-9-*#!%^&$_.]*))?@(?<hostname>(([a-zA-Z0-9]|[a-zA-Z0-9][a-zA-Z0-9\-]*[a-zA-Z0-9])\.)*([A-Za-z0-9]|[A-Za-z0-9][A-Za-z0-9\-]*[A-Za-z0-9])):(?<port>\d+)\/(?<database>[a-zA-Z0-9_-]*)
@JABirchall What is the use case would be for that? We don't allow empty password intentionally in order to force users to not create production system based on DB access without password. Anyways, I created a separate issue for that #8850 - we need to discuss this internally with the team.
from blockscout.
sevenzing
commented on May 21, 2024
This is problem with statistics microservices called stats. This service has to connect to blockscout database and it cannot due to problem with username. You can adjust blockscout-database-url using this ENV variable:
https://github.com/blockscout/blockscout/blob/master/docker-compose/services/docker-compose-stats.yml#L52
from blockscout.
JABirchall
commented on May 21, 2024
Also these errors in the log
stats | 2023-11-15T11:59:54.720773Z ERROR stats_server::update_service: error during updating chart: blockscout database error: Query Error: error returned from database: could not resize shared memory segment "/PostgreSQL.2487670426" to 8388608 bytes: No space left on device chart="averageGasPrice"
stats | 2023-11-15T11:59:54.771992Z ERROR stats_server::update_service: error during updating chart: blockscout database error: Query Error: error returned from database: could not resize shared memory segment "/PostgreSQL.1745587632" to 1048576 bytes: No space left on device chart="averageTxnFee"
If im interpretting that error correctly and its saying we have no space left, we have 18tb of diskspace and only 2TB used.
debian@explorer:~$ df -H "/mnt/chaindata"
Filesystem Size Used Avail Use% Mounted on
/dev/md1 12T 2T 12T 15% /mnt/chaindata
from blockscout.
JABirchall
commented on May 21, 2024
@sevenzing any ideas on the above errors?
I think the backend error is the only think preventing blockscout from starting (unless more errors come after)
from blockscout.
sevenzing
commented on May 21, 2024
I guess the problem in DATABASE_URL env variable. Recently we made a change in default env variables and default user is blockscout:
https://github.com/blockscout/blockscout/blob/master/docker-compose/envs/common-blockscout.env#L5
Try to change username from blockscout to postgres to check that this is a problem
from blockscout.
JABirchall
commented on May 21, 2024
I guess the problem in
DATABASE_URLenv variable. Recently we made a change in default env variables and default user isblockscout: https://github.com/blockscout/blockscout/blob/master/docker-compose/envs/common-blockscout.env#L5 Try to change username from blockscout to postgres to check that this is a problem
@sevenzing I fix all those, we arent getting database errors anymore. I about the other errors i posted.
Both the backened exception
And the stats microservice saying the device has no space left
from blockscout.
JABirchall
commented on May 21, 2024
Update: Im not an exlixer dev but i know regex.
The regex here: https://github.com/blockscout/blockscout/blob/master/apps/explorer/lib/explorer/repo/config_helper.ex#L41
Is incorrect for handling if no password is set on the user. As if no password is set, standard to only have user@host:port
But that regex requires the : to be in the uri, meaning you needs to use user:@host:port
This now boots up blockscout, but its still crashing
backend | warning: redefining module ConfigHelper (current version defined in memory)
backend | config/config_helper.exs:1
backend |
backend |
backend | warning: redefining module ConfigHelper (current version defined in memory)
backend | config/config_helper.exs:1
backend |
backend |
backend | Starting dependencies..
backend | Starting repos..
backend | Create Explorer.Repo database if it doesn't exist
backend | Create Explorer.Repo.Account database if it doesn't exist
backend | Running migrations for explorer
backend | 2023-11-15T16:23:46.376 application=ecto_sql [info] Migrations already up
backend | Running migrations for explorer
backend | Success!
backend | 2023-11-15T16:23:46.387 application=ecto_sql [info] Migrations already up
backend | warning: redefining module ConfigHelper (current version defined in memory)
backend | config/config_helper.exs:1
backend |
backend |
backend | warning: redefining module ConfigHelper (current version defined in memory)
backend | config/config_helper.exs:1
backend |
backend |
backend | 2023-11-15T16:23:50.958 application=que [info] [Que] Booting Que
backend | 2023-11-15T16:23:50.959 application=que [info] [Que] Booting Server Supervisor for Workers
backend | 2023-11-15T16:23:51.016 application=explorer [info] tx/per day chart: collect records for txs per day stats
backend | 2023-11-15T16:23:51.016 application=explorer [info] tx/per day chart: earliest date 2023-11-06 00:00:00Z
backend | 2023-11-15T16:23:51.016 application=explorer [info] tx/per day chart: latest date 2023-11-06 23:59:59Z
backend | 2023-11-15T16:23:51.038 application=explorer [info] tx/per day chart: min/max block numbers [1065671, 1075649]
backend | 2023-11-15T16:23:51.066 application=phoenix [info] Running BlockScoutWeb.Endpoint with cowboy 2.10.0 at 0.0.0.0:4000 (http)
backend | 2023-11-15T16:23:51.071 application=phoenix [info] Access BlockScoutWeb.Endpoint at https://explorer.rethereum.org:4000
backend | 2023-11-15T16:23:51.106 application=indexer fetcher=block_catchup missing_block_count=0 shrunk=false [info] Index already caught up.
backend | 2023-11-15T16:23:51.106 application=indexer fetcher=block_catchup [info] Checking if index needs to catch up in 5000ms.
backend | 2023-11-15T16:23:51.162 application=explorer [info] tx/per day chart: num of transactions 31825
backend | 2023-11-15T16:23:51.229 application=db_connection [info] Postgrex.Protocol (#PID<0.4206.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.4796.0> exited
backend | 2023-11-15T16:23:51.231 application=db_connection [info] Postgrex.Protocol (#PID<0.4163.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.4881.0> exited
backend | 2023-11-15T16:23:51.231 application=db_connection [info] Postgrex.Protocol (#PID<0.4152.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.4884.0> exited
backend | 2023-11-15T16:23:51.231 application=db_connection [info] Postgrex.Protocol (#PID<0.4145.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.4734.0> exited
db | 2023-11-15 16:23:51.257 UTC [1435] ERROR: canceling statement due to user request
db | 2023-11-15 16:23:51.257 UTC [1435] STATEMENT: SELECT b0."hash", count(t1."hash") FROM "blocks" AS b0 LEFT OUTER JOIN "transactions" AS t1 ON t1."block_hash" = b0."hash" WHERE ((b0."consensus" = TRUE) AND b0."refetch_needed") GROUP BY b0."hash" LIMIT $1
db | 2023-11-15 16:23:51.257 UTC [1435] LOG: could not send data to client: Broken pipe
db | 2023-11-15 16:23:51.258 UTC [1435] FATAL: connection to client lost
backend | 2023-11-15T16:23:51.254 application=indexer fetcher=block_catchup missing_block_count=0 shrunk=false [info] Index already caught up.
backend | 2023-11-15T16:23:51.255 application=indexer fetcher=block_catchup [info] Checking if index needs to catch up in 5000ms.
backend | 2023-11-15T16:23:51.310 application=explorer [info] tx/per day chart: total gas used 668325000
backend | 2023-11-15T16:23:51.375 application=db_connection [info] Postgrex.Protocol (#PID<0.4201.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.4958.0> exited
backend | 2023-11-15T16:23:51.377 application=db_connection [info] Postgrex.Protocol (#PID<0.4145.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.5060.0> exited
backend | 2023-11-15T16:23:51.377 application=db_connection [info] Postgrex.Protocol (#PID<0.4172.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.5059.0> exited
backend | 2023-11-15T16:23:51.378 application=db_connection [info] Postgrex.Protocol (#PID<0.4169.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.5062.0> exited
backend | 2023-11-15T16:23:51.378 application=db_connection [info] Postgrex.Protocol (#PID<0.4138.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.4898.0> exited
backend | 2023-11-15T16:23:51.378 application=db_connection [info] Postgrex.Protocol (#PID<0.4152.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.5061.0> exited
db | 2023-11-15 16:23:51.392 UTC [1423] ERROR: canceling statement due to user request
db | 2023-11-15 16:23:51.392 UTC [1423] STATEMENT: SELECT b0."hash", count(t1."hash") FROM "blocks" AS b0 LEFT OUTER JOIN "transactions" AS t1 ON t1."block_hash" = b0."hash" WHERE ((b0."consensus" = TRUE) AND b0."refetch_needed") GROUP BY b0."hash" LIMIT $1
db | 2023-11-15 16:23:51.393 UTC [1423] LOG: could not send data to client: Broken pipe
db | 2023-11-15 16:23:51.393 UTC [1423] FATAL: connection to client lost
backend | 2023-11-15T16:23:51.395 application=indexer fetcher=block_catchup missing_block_count=0 shrunk=false [info] Index already caught up.
backend | 2023-11-15T16:23:51.395 application=indexer fetcher=block_catchup [info] Checking if index needs to catch up in 5000ms.
backend | 2023-11-15T16:23:51.440 application=explorer [info] tx/per day chart: total fee 3277951532708265000
backend | 2023-11-15T16:23:51.440 application=explorer [info] tx/per day chart: collect records for txs per day stats
backend | 2023-11-15T16:23:51.440 application=explorer [info] tx/per day chart: earliest date 2023-11-07 00:00:00Z
backend | 2023-11-15T16:23:51.440 application=explorer [info] tx/per day chart: latest date 2023-11-07 23:59:59Z
backend | 2023-11-15T16:23:51.465 application=explorer [info] tx/per day chart: min/max block numbers [1075649, 1085463]
backend | 2023-11-15T16:23:51.519 application=db_connection [info] Postgrex.Protocol (#PID<0.4191.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.5134.0> exited
backend | 2023-11-15T16:23:51.522 application=db_connection [info] Postgrex.Protocol (#PID<0.4152.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.5264.0> exited
backend | 2023-11-15T16:23:51.522 application=db_connection [info] Postgrex.Protocol (#PID<0.4154.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.5263.0> exited
backend | 2023-11-15T16:23:51.522 application=db_connection [info] Postgrex.Protocol (#PID<0.4183.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.5259.0> exited
backend | 2023-11-15T16:23:51.522 application=db_connection [info] Postgrex.Protocol (#PID<0.4210.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.5074.0> exited
db | 2023-11-15 16:23:51.526 UTC [1447] ERROR: canceling statement due to user request
db | 2023-11-15 16:23:51.526 UTC [1447] STATEMENT: SELECT b0."hash", count(t1."hash") FROM "blocks" AS b0 LEFT OUTER JOIN "transactions" AS t1 ON t1."block_hash" = b0."hash" WHERE ((b0."consensus" = TRUE) AND b0."refetch_needed") GROUP BY b0."hash" LIMIT $1
backend | 2023-11-15T16:23:51.540 application=explorer [info] tx/per day chart: num of transactions 30220
backend | 2023-11-15T16:23:51.550 application=indexer fetcher=block_catchup missing_block_count=0 shrunk=false [info] Index already caught up.
backend | 2023-11-15T16:23:51.551 application=indexer fetcher=block_catchup [info] Checking if index needs to catch up in 5000ms.
backend | 2023-11-15T16:23:51.623 application=explorer [info] tx/per day chart: total gas used 635547781
backend | 2023-11-15T16:23:51.627 application=db_connection [info] Postgrex.Protocol (#PID<0.4157.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.5336.0> exited
backend | 2023-11-15T16:23:51.628 application=db_connection [info] Postgrex.Protocol (#PID<0.4203.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.5276.0> exited
backend | 2023-11-15T16:23:51.629 application=db_connection [info] Postgrex.Protocol (#PID<0.4154.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.5434.0> exited
backend | 2023-11-15T16:23:51.629 application=db_connection [info] Postgrex.Protocol (#PID<0.4162.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.5435.0> exited
backend | 2023-11-15T16:23:51.629 application=db_connection [info] Postgrex.Protocol (#PID<0.4175.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.5439.0> exited
backend | 2023-11-15T16:23:51.631 [notice] Application indexer exited: shutdown
db | 2023-11-15 16:23:51.638 UTC [1391] ERROR: canceling statement due to user request
db | 2023-11-15 16:23:51.638 UTC [1391] STATEMENT: SELECT b0."hash", count(t1."hash") FROM "blocks" AS b0 LEFT OUTER JOIN "transactions" AS t1 ON t1."block_hash" = b0."hash" WHERE ((b0."consensus" = TRUE) AND b0."refetch_needed") GROUP BY b0."hash" LIMIT $1
backend | 2023-11-15T16:23:51.645 application=db_connection [info] Postgrex.Protocol (#PID<0.4160.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.4462.0> exited
backend | 2023-11-15T16:23:51.646 application=db_connection [info] Postgrex.Protocol (#PID<0.4144.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.4440.0> exited
db | 2023-11-15 16:23:51.647 UTC [1386] ERROR: canceling statement due to user request
db | 2023-11-15 16:23:51.647 UTC [1386] STATEMENT: SELECT min(f1."number") FROM "blocks" AS b0 RIGHT OUTER JOIN (SELECT b1.number
db | FROM generate_series(($1)::integer, ($2)::integer) AS b1(number)
db | WHERE NOT EXISTS
db | (SELECT 1 FROM blocks b2 WHERE b2.number=b1.number AND b2.consensus))
db | AS f1 ON b0."number" = f1."number"
db | 2023-11-15 16:23:51.648 UTC [1402] ERROR: canceling statement due to user request
db | 2023-11-15 16:23:51.648 UTC [1402] STATEMENT: SELECT count(*) FROM "transactions" AS t0 WHERE ((t0."status" = $1) AND NOW() - t0."created_contract_code_indexed_at" at time zone 'UTC' <= interval '24 hours')
db | 2023-11-15 16:23:51.648 UTC [1472] FATAL: terminating background worker "parallel worker" due to administrator command
db | 2023-11-15 16:23:51.648 UTC [1472] STATEMENT: SELECT count(*) FROM "transactions" AS t0 WHERE ((t0."status" = $1) AND NOW() - t0."created_contract_code_indexed_at" at time zone 'UTC' <= interval '24 hours')
db | 2023-11-15 16:23:51.648 UTC [1473] FATAL: terminating background worker "parallel worker" due to administrator command
db | 2023-11-15 16:23:51.648 UTC [1473] STATEMENT: SELECT count(*) FROM "transactions" AS t0 WHERE ((t0."status" = $1) AND NOW() - t0."created_contract_code_indexed_at" at time zone 'UTC' <= interval '24 hours')
backend | 2023-11-15T16:23:51.652 application=db_connection [info] Postgrex.Protocol (#PID<0.4218.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.4449.0> exited
db | 2023-11-15 16:23:51.655 UTC [1] LOG: background worker "parallel worker" (PID 1472) exited with exit code 1
db | 2023-11-15 16:23:51.655 UTC [1] LOG: background worker "parallel worker" (PID 1473) exited with exit code 1
db | 2023-11-15 16:23:51.695 UTC [1466] ERROR: canceling statement due to user request
db | 2023-11-15 16:23:51.695 UTC [1466] STATEMENT: SELECT SUM(s0."gas_price" * s0."gas_used") FROM (SELECT st0."hash" AS "hash", st0."block_number" AS "block_number", st0."cumulative_gas_used" AS "cumulative_gas_used", st0."earliest_processing_start" AS "earliest_processing_start", st0."error" AS "error", st0."gas" AS "gas", st0."gas_price" AS "gas_price", st0."gas_used" AS "gas_used", st0."index" AS "index", st0."created_contract_code_indexed_at" AS "created_contract_code_indexed_at", st0."input" AS "input", st0."nonce" AS "nonce", st0."r" AS "r", st0."s" AS "s", st0."status" AS "status", st0."v" AS "v", st0."value" AS "value", st0."revert_reason" AS "revert_reason", st0."max_priority_fee_per_gas" AS "max_priority_fee_per_gas", st0."max_fee_per_gas" AS "max_fee_per_gas", st0."type" AS "type", st0."has_error_in_internal_txs" AS "has_error_in_internal_txs", st0."old_block_hash" AS "old_block_hash", st0."inserted_at" AS "inserted_at", st0."updated_at" AS "updated_at", st0."block_hash" AS "block_hash", st0."from_address_hash" AS "from_address_hash", st0."to_address_hash" AS "to_address_hash", st0."created_contract_address_hash" AS "created_contract_address_hash" FROM "transactions" AS st0 WHERE ((st0."block_number" >= $1) AND (st0."block_number" <= $2))) AS s0 INNER JOIN (SELECT sb0."hash" AS "hash" FROM "blocks" AS sb0 WHERE (sb0."consensus" = TRUE) AND ((sb0."number" >= $3) AND (sb0."number" <= $4))) AS s1 ON s0."block_hash" = s1."hash"
db | 2023-11-15 16:23:51.695 UTC [1466] LOG: could not send data to client: Broken pipe
db | 2023-11-15 16:23:51.695 UTC [1466] FATAL: connection to client lost
backend | {"Kernel pid terminated",application_controller,"{application_termi
backend | nated,indexer,shutdown}"}
backend | Kernel pid terminate
backend | d (applicatio
backend | n_controller) ({application_t
backend | ermin
backend | ated,i
backend | ndexer
backend | ,shutdown}
backend | )
backend |
backend | Crash dump is being written to: erl_crash.dump.
backend | ..
backend | done
backend exited with code 1
backend | warning: redefining module ConfigHelper (current version defined in memory)
backend | config/config_helper.exs:1
backend |
backend |
backend | warning: redefining module ConfigHelper (current version defined in memory)
backend | config/config_helper.exs:1
backend |
backend |
backend | Starting dependencies..
backend | Starting repos..
backend | Create Explorer.Repo database if it doesn't exist
backend | Create Explorer.Repo.Account database if it doesn't exist
backend | Running migrations for explorer
backend | 2023-11-15T16:24:21.596 application=ecto_sql [info] Migrations already up
backend | Running migrations for explorer
backend | Success!
backend | 2023-11-15T16:24:21.609 application=ecto_sql [info] Migrations already up
backend | warning: redefining module ConfigHelper (current version defined in memory)
backend | config/config_helper.exs:1
backend |
backend |
backend | warning: redefining module ConfigHelper (current version defined in memory)
backend | config/config_helper.exs:1
backend |
backend |
backend | 2023-11-15T16:24:26.026 application=que [info] [Que] Booting Que
backend | 2023-11-15T16:24:26.027 application=que [info] [Que] Booting Server Supervisor for Workers
backend | 2023-11-15T16:24:26.103 application=explorer [info] tx/per day chart: collect records for txs per day stats
backend | 2023-11-15T16:24:26.103 application=explorer [info] tx/per day chart: earliest date 2023-11-06 00:00:00Z
backend | 2023-11-15T16:24:26.103 application=explorer [info] tx/per day chart: latest date 2023-11-06 23:59:59Z
backend | 2023-11-15T16:24:26.121 application=explorer [info] tx/per day chart: min/max block numbers [1065671, 1075649]
backend | 2023-11-15T16:24:26.168 application=phoenix [info] Running BlockScoutWeb.Endpoint with cowboy 2.10.0 at 0.0.0.0:4000 (http)
backend | 2023-11-15T16:24:26.175 application=phoenix [info] Access BlockScoutWeb.Endpoint at https://explorer.rethereum.org:4000
backend | 2023-11-15T16:24:26.191 application=explorer [info] tx/per day chart: num of transactions 31825
backend | 2023-11-15T16:24:26.218 application=indexer fetcher=block_catchup missing_block_count=0 shrunk=false [info] Index already caught up.
backend | 2023-11-15T16:24:26.218 application=indexer fetcher=block_catchup [info] Checking if index needs to catch up in 5000ms.
backend | 2023-11-15T16:24:26.300 application=db_connection [info] Postgrex.Protocol (#PID<0.4144.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.4872.0> exited
backend | 2023-11-15T16:24:26.301 application=db_connection [info] Postgrex.Protocol (#PID<0.4214.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.4796.0> exited
backend | 2023-11-15T16:24:26.301 application=db_connection [info] Postgrex.Protocol (#PID<0.4190.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.4871.0> exited
backend | 2023-11-15T16:24:26.302 application=db_connection [info] Postgrex.Protocol (#PID<0.4169.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.4873.0> exited
backend | 2023-11-15T16:24:26.302 application=db_connection [info] Postgrex.Protocol (#PID<0.4172.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.4868.0> exited
backend | 2023-11-15T16:24:26.302 application=db_connection [info] Postgrex.Protocol (#PID<0.4174.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.4734.0> exited
backend | 2023-11-15T16:24:26.303 application=indexer fetcher=block_catchup missing_block_count=0 shrunk=false [info] Index already caught up.
backend | 2023-11-15T16:24:26.304 application=indexer fetcher=block_catchup [info] Checking if index needs to catch up in 5000ms.
db | 2023-11-15 16:24:26.312 UTC [1625] ERROR: canceling statement due to user request
db | 2023-11-15 16:24:26.312 UTC [1625] STATEMENT: SELECT b0."hash", count(t1."hash") FROM "blocks" AS b0 LEFT OUTER JOIN "transactions" AS t1 ON t1."block_hash" = b0."hash" WHERE ((b0."consensus" = TRUE) AND b0."refetch_needed") GROUP BY b0."hash" LIMIT $1
backend | 2023-11-15T16:24:26.390 application=explorer [info] tx/per day chart: total gas used 668325000
backend | 2023-11-15T16:24:26.414 application=db_connection [info] Postgrex.Protocol (#PID<0.4157.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.4945.0> exited
backend | 2023-11-15T16:24:26.416 application=db_connection [info] Postgrex.Protocol (#PID<0.4183.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.5045.0> exited
backend | 2023-11-15T16:24:26.416 application=db_connection [info] Postgrex.Protocol (#PID<0.4165.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.5044.0> exited
backend | 2023-11-15T16:24:26.416 application=db_connection [info] Postgrex.Protocol (#PID<0.4187.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.5046.0> exited
backend | 2023-11-15T16:24:26.416 application=db_connection [info] Postgrex.Protocol (#PID<0.4151.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.4885.0> exited
backend | 2023-11-15T16:24:26.417 application=db_connection [info] Postgrex.Protocol (#PID<0.4158.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.5048.0> exited
db | 2023-11-15 16:24:26.435 UTC [1592] ERROR: canceling statement due to user request
db | 2023-11-15 16:24:26.435 UTC [1592] STATEMENT: SELECT b0."hash", count(t1."hash") FROM "blocks" AS b0 LEFT OUTER JOIN "transactions" AS t1 ON t1."block_hash" = b0."hash" WHERE ((b0."consensus" = TRUE) AND b0."refetch_needed") GROUP BY b0."hash" LIMIT $1
backend | 2023-11-15T16:24:26.443 application=indexer fetcher=block_catchup missing_block_count=0 shrunk=false [info] Index already caught up.
backend | 2023-11-15T16:24:26.443 application=indexer fetcher=block_catchup [info] Checking if index needs to catch up in 5000ms.
backend | 2023-11-15T16:24:26.527 application=explorer [info] tx/per day chart: total fee 3277951532708265000
backend | 2023-11-15T16:24:26.527 application=explorer [info] tx/per day chart: collect records for txs per day stats
backend | 2023-11-15T16:24:26.527 application=explorer [info] tx/per day chart: earliest date 2023-11-07 00:00:00Z
backend | 2023-11-15T16:24:26.527 application=explorer [info] tx/per day chart: latest date 2023-11-07 23:59:59Z
backend | 2023-11-15T16:24:26.546 application=explorer [info] tx/per day chart: min/max block numbers [1075649, 1085463]
backend | 2023-11-15T16:24:26.571 application=db_connection [info] Postgrex.Protocol (#PID<0.4156.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.5120.0> exited
backend | 2023-11-15T16:24:26.573 application=db_connection [info] Postgrex.Protocol (#PID<0.4149.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.5231.0> exited
backend | 2023-11-15T16:24:26.573 application=db_connection [info] Postgrex.Protocol (#PID<0.4152.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.5060.0> exited
backend | 2023-11-15T16:24:26.573 application=db_connection [info] Postgrex.Protocol (#PID<0.4169.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.5235.0> exited
backend | 2023-11-15T16:24:26.574 application=db_connection [info] Postgrex.Protocol (#PID<0.4201.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.5234.0> exited
backend | 2023-11-15T16:24:26.574 application=db_connection [info] Postgrex.Protocol (#PID<0.4206.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.5236.0> exited
db | 2023-11-15 16:24:26.577 UTC [1599] ERROR: canceling statement due to user request
db | 2023-11-15 16:24:26.577 UTC [1599] STATEMENT: SELECT b0."hash", count(t1."hash") FROM "blocks" AS b0 LEFT OUTER JOIN "transactions" AS t1 ON t1."block_hash" = b0."hash" WHERE ((b0."consensus" = TRUE) AND b0."refetch_needed") GROUP BY b0."hash" LIMIT $1
backend | 2023-11-15T16:24:26.601 application=indexer fetcher=block_catchup missing_block_count=0 shrunk=false [info] Index already caught up.
backend | 2023-11-15T16:24:26.602 application=indexer fetcher=block_catchup [info] Checking if index needs to catch up in 5000ms.
backend | 2023-11-15T16:24:26.650 application=explorer [info] tx/per day chart: num of transactions 30220
backend | 2023-11-15T16:24:26.686 application=db_connection [info] Postgrex.Protocol (#PID<0.4165.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.5308.0> exited
backend | 2023-11-15T16:24:26.688 application=db_connection [info] Postgrex.Protocol (#PID<0.4161.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.5437.0> exited
backend | 2023-11-15T16:24:26.688 application=db_connection [info] Postgrex.Protocol (#PID<0.4212.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.5436.0> exited
backend | 2023-11-15T16:24:26.688 application=db_connection [info] Postgrex.Protocol (#PID<0.4206.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.5435.0> exited
backend | 2023-11-15T16:24:26.689 application=db_connection [info] Postgrex.Protocol (#PID<0.4203.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.5248.0> exited
backend | 2023-11-15T16:24:26.691 [notice] Application indexer exited: shutdown
backend | 2023-11-15T16:24:26.704 application=db_connection [info] Postgrex.Protocol (#PID<0.4166.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.4462.0> exited
backend | 2023-11-15T16:24:26.704 application=db_connection [info] Postgrex.Protocol (#PID<0.4146.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.4440.0> exited
backend | 2023-11-15T16:24:26.707 application=db_connection [info] Postgrex.Protocol (#PID<0.4143.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.4449.0> exited
db | 2023-11-15 16:24:26.708 UTC [1674] ERROR: canceling statement due to user request
db | 2023-11-15 16:24:26.708 UTC [1674] STATEMENT: SELECT b0."hash", count(t1."hash") FROM "blocks" AS b0 LEFT OUTER JOIN "transactions" AS t1 ON t1."block_hash" = b0."hash" WHERE ((b0."consensus" = TRUE) AND b0."refetch_needed") GROUP BY b0."hash" LIMIT $1
db | 2023-11-15 16:24:26.708 UTC [1674] LOG: could not send data to client: Broken pipe
db | 2023-11-15 16:24:26.709 UTC [1674] FATAL: connection to client lost
db | 2023-11-15 16:24:26.746 UTC [1589] ERROR: canceling statement due to user request
db | 2023-11-15 16:24:26.746 UTC [1589] STATEMENT: SELECT min(f1."number") FROM "blocks" AS b0 RIGHT OUTER JOIN (SELECT b1.number
db | FROM generate_series(($1)::integer, ($2)::integer) AS b1(number)
db | WHERE NOT EXISTS
db | (SELECT 1 FROM blocks b2 WHERE b2.number=b1.number AND b2.consensus))
db | AS f1 ON b0."number" = f1."number"
db | 2023-11-15 16:24:26.754 UTC [1604] ERROR: canceling statement due to user request
db | 2023-11-15 16:24:26.754 UTC [1604] STATEMENT: SELECT sum(s0."gas_used") FROM (SELECT st0."hash" AS "hash", st0."block_number" AS "block_number", st0."cumulative_gas_used" AS "cumulative_gas_used", st0."earliest_processing_start" AS "earliest_processing_start", st0."error" AS "error", st0."gas" AS "gas", st0."gas_price" AS "gas_price", st0."gas_used" AS "gas_used", st0."index" AS "index", st0."created_contract_code_indexed_at" AS "created_contract_code_indexed_at", st0."input" AS "input", st0."nonce" AS "nonce", st0."r" AS "r", st0."s" AS "s", st0."status" AS "status", st0."v" AS "v", st0."value" AS "value", st0."revert_reason" AS "revert_reason", st0."max_priority_fee_per_gas" AS "max_priority_fee_per_gas", st0."max_fee_per_gas" AS "max_fee_per_gas", st0."type" AS "type", st0."has_error_in_internal_txs" AS "has_error_in_internal_txs", st0."old_block_hash" AS "old_block_hash", st0."inserted_at" AS "inserted_at", st0."updated_at" AS "updated_at", st0."block_hash" AS "block_hash", st0."from_address_hash" AS "from_address_hash", st0."to_address_hash" AS "to_address_hash", st0."created_contract_address_hash" AS "created_contract_address_hash" FROM "transactions" AS st0 WHERE ((st0."block_number" >= $1) AND (st0."block_number" <= $2))) AS s0 INNER JOIN (SELECT sb0."hash" AS "hash" FROM "blocks" AS sb0 WHERE (sb0."consensus" = TRUE) AND ((sb0."number" >= $3) AND (sb0."number" <= $4))) AS s1 ON s0."block_hash" = s1."hash"
db | 2023-11-15 16:24:26.755 UTC [1604] LOG: could not send data to client: Broken pipe
db | 2023-11-15 16:24:26.755 UTC [1604] FATAL: connection to client lost
db | 2023-11-15 16:24:26.755 UTC [1602] ERROR: canceling statement due to user request
db | 2023-11-15 16:24:26.755 UTC [1602] STATEMENT: SELECT count(*) FROM "transactions" AS t0 WHERE ((t0."status" = $1) AND NOW() - t0."created_contract_code_indexed_at" at time zone 'UTC' <= interval '24 hours')
db | 2023-11-15 16:24:26.755 UTC [1650] FATAL: terminating background worker "parallel worker" due to administrator command
db | 2023-11-15 16:24:26.755 UTC [1650] STATEMENT: SELECT count(*) FROM "transactions" AS t0 WHERE ((t0."status" = $1) AND NOW() - t0."created_contract_code_indexed_at" at time zone 'UTC' <= interval '24 hours')
db | 2023-11-15 16:24:26.756 UTC [1651] FATAL: terminating background worker "parallel worker" due to administrator command
db | 2023-11-15 16:24:26.756 UTC [1651] STATEMENT: SELECT count(*) FROM "transactions" AS t0 WHERE ((t0."status" = $1) AND NOW() - t0."created_contract_code_indexed_at" at time zone 'UTC' <= interval '24 hours')
db | 2023-11-15 16:24:26.756 UTC [1589] LOG: could not send data to client: Broken pipe
db | 2023-11-15 16:24:26.756 UTC [1589] FATAL: connection to client lost
db | 2023-11-15 16:24:26.761 UTC [1] LOG: background worker "parallel worker" (PID 1651) exited with exit code 1
db | 2023-11-15 16:24:26.761 UTC [1] LOG: background worker "parallel worker" (PID 1650) exited with exit code 1
db | 2023-11-15 16:24:26.761 UTC [1602] LOG: could not send data to client: Broken pipe
db | 2023-11-15 16:24:26.761 UTC [1602] FATAL: connection to client lost
backend | {"Kernel pid terminated",application_controller,"{application_terminated,indexer,shut
backend | down}"}
backend | Kernel pid terminated (app
backend | licatio
backend | n_co
backend | ntrol
backend | ler)
backend | ({ap
backend | plication_terminated,inde
backend | xer,shutdow
backend | n})
backend |
backend | Crash dump is being written to: erl_crash.dump...
backend | done
from blockscout.
sevenzing
commented on May 21, 2024
Talking about stats error: I think the reason is that docker restricts shared memory by default, you can adjust it in postgres container in docker-compose.yml like that:
db:
shm_size: 1g
from blockscout.
sevenzing
commented on May 21, 2024
Maxim @sl1depengwyn , chould please take a look at blockscout backend error
from blockscout.
JABirchall
commented on May 21, 2024
Do you know where erl_crash.dump is saved, i can upload it if i can find it.
from blockscout.
vbaranov
commented on May 21, 2024
@JABirchall try to unset ETHEREUM_JSONRPC_WS_URL, if it is set in your docker-compose.
from blockscout.
JABirchall
commented on May 21, 2024
@JABirchall try to unset
ETHEREUM_JSONRPC_WS_URL, if it is set in your docker-compose.
OMG is online! Looks like stuff is working, will be monitoring for anything broken.
Some feedback;
You should prolly have some version migration docs, most of my issues today was because of new configs, config values being moved and new config values being added.
Would be worth having upgrading documentation make people aware of such changes so they know if these changes.
from blockscout.
JABirchall
commented on May 21, 2024
Found a page throwing an error, pending transcation page is throwing an error
backend | Request: GET /pending-transactions?type=JSON │
backend | ** (exit) an exception was raised: │
backend | ** (FunctionClauseError) no function clause matching in BlockScoutWeb.AddressView.matching_address_check/4 │
backend | (block_scout_web 5.3.1) lib/block_scout_web/views/address_view.ex:336: BlockScoutWeb.AddressView.matching_address_check(nil, nil, true, false) │
backend | (block_scout_web 5.3.1) lib/block_scout_web/templates/transaction/_tile.html.eex:45: BlockScoutWeb.TransactionView."_tile.html"/1 │
backend | (phoenix 1.5.14) lib/phoenix/view.ex:472: Phoenix.View.render_to_iodata/3 │
backend | (phoenix 1.5.14) lib/phoenix/view.ex:479: Phoenix.View.render_to_string/3 │
backend | (elixir 1.14.5) lib/enum.ex:1658: Enum."-map/2-lists^map/1-0-"/2 │
backend | (elixir 1.14.5) lib/enum.ex:1658: Enum."-map/2-lists^map/1-0-"/2 │
backend | (block_scout_web 5.3.1) lib/block_scout_web/controllers/pending_transaction_controller.ex:48: BlockScoutWeb.PendingTransactionController.index/2 │
backend | (block_scout_web 5.3.1) lib/block_scout_web/controllers/pending_transaction_controller.ex:1: BlockScoutWeb.PendingTransactionController.action/2
https://explorer.rethereum.org/pending-transactions
Other than that, looks like everything else is working.
from blockscout.
vbaranov
commented on May 21, 2024
You should prolly have some version migration docs, most of my issues today was because of new configs, config values being moved and new config values being added.
Thank you for the suggestion. We'll improve documentation on updates.
Found a page throwing an error, pending transcation page is throwing an error
@JABirchall is txpool_content enabled on Geth node? This geth is of which version?
Could you send the response from txpool_content from the node?
from blockscout.
JABirchall
commented on May 21, 2024
You should prolly have some version migration docs, most of my issues today was because of new configs, config values being moved and new config values being added.
Thank you for the suggestion. We'll improve documentation on updates.
Found a page throwing an error, pending transcation page is throwing an error
@JABirchall is
txpool_contentenabled on Geth node? This geth is of which version?Could you send the response from
txpool_contentfrom the node?
The txpool module is enabled on the node.
debian@explorer:~/geth$ curl -XPOST -H "Content-type: application/json" -d '{"jsonrpc":"2.0","method":"txpool_content","params":[],"id":1}' 'http://localhost:8545'
{
"jsonrpc": "2.0",
"id": 1,
"result": {
"pending": {
"0x199768A750330bABAC41c410521D462E8F76Ee30": {
"6": {
"blockHash": null,
"blockNumber": null,
"from": "0x199768a750330babac41c410521d462e8f76ee30",
"gas": "0x5208",
"gasPrice": "0x0",
"hash": "0xf6aaaa6e5944b83aef22acb209723bdfafe78b0a8b4a3426b3155d03498e6d05",
"input": "0x",
"nonce": "0x6",
"to": "0xc90dc4886fa895361a969f91d60532a9d7acbed4",
"transactionIndex": null,
"value": "0xe08220ed01b1a40",
"type": "0x0",
"chainId": "0x97ec5",
"v": "0x12fdae",
"r": "0xd22a3ce800b5b46c3cf586b60640632c4e24aa3131f51b7cec1cbf038a25584d",
"s": "0x5659faf894ace5a2ceba52d7494ec271437d97041d14dc12fce35a0661abacc0"
}
},
"0x242bA43Fd3335f52588A801218Df833C119e1025": {
"3": {
"blockHash": null,
"blockNumber": null,
"from": "0x242ba43fd3335f52588a801218df833c119e1025",
"gas": "0x5208",
"gasPrice": "0xa8f3004",
"hash": "0x7e54b91fb3b4acafb8bc9e6d56d2d0859c66b4d0c2aa13d789d96ad5088d80a4",
"input": "0x",
"nonce": "0x3",
"to": "0x242ba43fd3335f52588a801218df833c119e1025",
"transactionIndex": null,
"value": "0x0",
"type": "0x0",
"chainId": "0x97ec5",
"v": "0x12fdad",
"r": "0x1997584f9825c76a4de11802493584a0604e1f11cc72c5606c21531df2ca7987",
"s": "0x276a54d94dc447a1e508ebb979746059cb8592140942b35158f3814e62e6e002"
},
"4": {
"blockHash": null,
"blockNumber": null,
"from": "0x242ba43fd3335f52588a801218df833c119e1025",
"gas": "0x5208",
"gasPrice": "0x9eaae580",
"hash": "0xcb7795b8eca0e053400eb89d55caa343f8ce3d04e9fd8b43736a53b60b53934f",
"input": "0x",
"nonce": "0x4",
"to": "0x242ba43fd3335f52588a801218df833c119e1025",
"transactionIndex": null,
"value": "0x0",
"type": "0x0",
"chainId": "0x97ec5",
"v": "0x12fdae",
"r": "0xc2468fd4c300eb54dfa55ea261d6ec20227641b9098b8a5ba9846b2f4d5071f8",
"s": "0x7196c84374bda4ba438f89fd6a4d8b254918b3c5728461a38b9b0b9a37003d20"
},
"5": {
"blockHash": null,
"blockNumber": null,
"from": "0x242ba43fd3335f52588a801218df833c119e1025",
"gas": "0x5208",
"gasPrice": "0x903e4500",
"hash": "0x00c1d57125443c0a7cbf1c9ab1acd0c62ab974cafa923c31f1b2fff5a58f4a47",
"input": "0x",
"nonce": "0x5",
"to": "0x242ba43fd3335f52588a801218df833c119e1025",
"transactionIndex": null,
"value": "0x0",
"type": "0x0",
"chainId": "0x97ec5",
"v": "0x12fdae",
"r": "0x36b25fe37bf064fafaf1876147b488b6b768c5ae57db6cc763d34b9f979d8f82",
"s": "0x4e3a29d27170f7419e076ab5b00abb0f150d18e3b080f1bf2026dc280702ae2a"
},
"6": {
"blockHash": null,
"blockNumber": null,
"from": "0x242ba43fd3335f52588a801218df833c119e1025",
"gas": "0x5208",
"gasPrice": "0x903e4500",
"hash": "0x8ce2a423bdf430328ecf0b6848cce4827b7b95fce7d39b8eb715b7abaa9071ae",
"input": "0x",
"nonce": "0x6",
"to": "0x242ba43fd3335f52588a801218df833c119e1025",
"transactionIndex": null,
"value": "0x0",
"type": "0x0",
"chainId": "0x97ec5",
"v": "0x12fdad",
"r": "0x8dcf78eb472ed08499aa9a64457f624ac07d4af5fdf69f1187c373ec4d557cdf",
"s": "0x5aba3ed6c15f2009bfe5a9fe51c90af815f136198b877b91f00614991164d549"
},
"7": {
"blockHash": null,
"blockNumber": null,
"from": "0x242ba43fd3335f52588a801218df833c119e1025",
"gas": "0x5208",
"gasPrice": "0x77359400",
"hash": "0x5ce069f8bac6865123a5a6123429df26c6af064dcd4d7eaa5dc201f73d57215c",
"input": "0x",
"nonce": "0x7",
"to": "0x242ba43fd3335f52588a801218df833c119e1025",
"transactionIndex": null,
"value": "0x0",
"type": "0x0",
"chainId": "0x97ec5",
"v": "0x12fdae",
"r": "0x9b0b5689228d8161adad723cbe09d852dea8d800c38359b70cd40e0a2c5bfc3f",
"s": "0x3d98a2d2116eccae273183eefed0dae3b9578fdde537a3a2a137b57c0c171e41"
},
"8": {
"blockHash": null,
"blockNumber": null,
"from": "0x242ba43fd3335f52588a801218df833c119e1025",
"gas": "0x5208",
"gasPrice": "0x83215600",
"hash": "0x95cafba4bcbad8560e0358b0ccffbdfcc9a5286aca997060aff09f55268e109b",
"input": "0x",
"nonce": "0x8",
"to": "0xa9a5fa482699c3b6291a22c1342be8c5c26a2512",
"transactionIndex": null,
"value": "0x53444835ec580000",
"type": "0x0",
"chainId": "0x97ec5",
"v": "0x12fdae",
"r": "0x8a3edfe34bfb523c09b10d7f37a07ced45c5bfdad7bc31d66a9eca49d11c90f5",
"s": "0x16780ddb4ae046c802748ef1b06b95bba968cd08788f70b57515e7fa6251b3d"
}
},
"0x3B90a89993aBD1Ee7a80370eb961D7859DDCAE54": {
"0": {
"blockHash": null,
"blockNumber": null,
"from": "0x3b90a89993abd1ee7a80370eb961d7859ddcae54",
"gas": "0x249f0",
"gasPrice": "0x0",
"hash": "0x3b477d7592d4ae0b6e7c1bd3db1b5424410d92b9ae9ec5ffb193c54e93ab5152",
"input": "0x4e71d92d",
"nonce": "0x0",
"to": "0x80f6ca0ccc1407ba5e8a73b9424153527bd245b1",
"transactionIndex": null,
"value": "0x0",
"type": "0x0",
"chainId": "0x97ec5",
"v": "0x12fdad",
"r": "0xb966c28c3725646026a0fd71ba41d4977ce572cac549dd9b996167cde299641f",
"s": "0x72d3785088964e40c7b515c0fb4310b6decbca0595f1bb7c663012843f84482a"
}
},
"0x3e3a1a4322bb1a1B2eDAF2F83e0970e0F51f8297": {
"2": {
"blockHash": null,
"blockNumber": null,
"from": "0x3e3a1a4322bb1a1b2edaf2f83e0970e0f51f8297",
"gas": "0x5208",
"gasPrice": "0x0",
"hash": "0x59d81ff81cfc40ea43ce501806efbf562da07f9833d88f9adcbf4f886363efce",
"input": "0x",
"nonce": "0x2",
"to": "0xee974eaa893e47f37922731ec402576a5d21820a",
"transactionIndex": null,
"value": "0x1dd57f239ffda3240",
"type": "0x0",
"chainId": "0x97ec5",
"v": "0x12fdad",
"r": "0x91c2624e78909a380f5ec647d93c036a32f42f1538bf7dfbd3cf3cddaa8c6cb2",
"s": "0x559847e368a008bccc0acd97e4c01e47841a1b7d5ef45cce953b177758f97f4f"
}
},
"0x76b4E75e25216569b8D5Cc34Fd02273E1F2D6433": {
"0": {
"blockHash": null,
"blockNumber": null,
"from": "0x76b4e75e25216569b8d5cc34fd02273e1f2d6433",
"gas": "0x5208",
"gasPrice": "0x0",
"hash": "0x9fbdda0697b25e03d24b06beccfd0f46b2b90aa324e7cbd4ba83e43960f8cce6",
"input": "0x",
"nonce": "0x0",
"to": "0x86e7b4fb3b0702b3b93b2060c983ead04e98cce9",
"transactionIndex": null,
"value": "0x1288ae38d0e1d57bc0",
"type": "0x0",
"chainId": "0x97ec5",
"v": "0x12fdae",
"r": "0x1681f2edb3f71bc39e3783552f7fc91e4e5ba8fa7c0a997d30802483fabc7c65",
"s": "0xdf327969ae2ac8d33dc1bd9f9a55337d5a8ad5c1faf7a759a4d7fd1b68dfaea"
}
},
"0xa1e9DEdB440B222152ca82Fe3d0E8894b012a12D": {
"1": {
"blockHash": null,
"blockNumber": null,
"from": "0xa1e9dedb440b222152ca82fe3d0e8894b012a12d",
"gas": "0x5208",
"gasPrice": "0x0",
"hash": "0x4f9df02a648aa115381868d5254743a2797fd58b02adbfcf50dca7ddb22d44b7",
"input": "0x",
"nonce": "0x1",
"to": "0x066d98c7b92ddc283a0ea1da94f4e7b9991f9fb7",
"transactionIndex": null,
"value": "0x1bd4a9551f783800",
"type": "0x0",
"chainId": "0x97ec5",
"v": "0x12fdae",
"r": "0xffef0c43530f50d99046bd850891a6df579ed6ce5b220dac1a9a3fedc7e1ab67",
"s": "0xab406880fcb751aaba56e12fa999c1f7d1f5b21add2cb656bc1f989b2562697"
}
}
},
"queued": {
"0xEC8698363EBEDb1eECB8c640069fc312E789CCc5": {
"2": {
"blockHash": null,
"blockNumber": null,
"from": "0xec8698363ebedb1eecb8c640069fc312e789ccc5",
"gas": "0x5208",
"gasPrice": "0xb2d05e00",
"hash": "0x00b2237c8b950f64a726413d631793aa73f24eae15ca5147b868a2f338c400a4",
"input": "0x",
"nonce": "0x2",
"to": "0x51b61bc1d2dfd645df0edb969d0e412634a59309",
"transactionIndex": null,
"value": "0x466a95083ed97240",
"type": "0x0",
"chainId": "0x97ec5",
"v": "0x12fdae",
"r": "0x11820109d70cef6d0bebd879462880a8939148e11f6134fd39dc6b9a6cb3359a",
"s": "0x69115e458907a1795535856400f1b0acc6a1c7f4e062612140686d35f13d5823"
}
}
}
}
}
from blockscout.
vbaranov
commented on May 21, 2024
This geth is of which version?
from blockscout.
JABirchall
commented on May 21, 2024
This geth is of which version?
The geth version is our own version, Rethereum 1.12.1
https://github.com/Rethereum-blockchain/go-rethereum/releases/tag/1.12.1
from blockscout.
vbaranov
commented on May 21, 2024
@JABirchall thank you for the response. I confirm, this is a bug with pending transactions page. We'll address it.
from blockscout.
vbaranov
commented on May 21, 2024
@JABirchall is that node public one? It is possible to get its endpoint in order to reproduce exact your issue?
from blockscout.
JABirchall
commented on May 21, 2024
@vbaranov Could you also fix the regex error here: https://github.com/blockscout/blockscout/blob/master/apps/explorer/lib/explorer/repo/config_helper.ex#L41
The username:password seperator should not be required if there is no password.
Currently scheme://username@host:345/db fails.
Idealy
scheme://[email protected]:456/sads
scheme://username:@host.sdasd:456/sads
scheme://username:[email protected]:456/sads
should all pass
Like maybe \w*:\/\/(?<username>[a-zA-Z0-9_-]*)(:(?<password>[a-zA-Z0-9-*#!%^&$_.]*))?@(?<hostname>(([a-zA-Z0-9]|[a-zA-Z0-9][a-zA-Z0-9\-]*[a-zA-Z0-9])\.)*([A-Za-z0-9]|[A-Za-z0-9][A-Za-z0-9\-]*[A-Za-z0-9])):(?<port>\d+)\/(?<database>[a-zA-Z0-9_-]*)
from blockscout.
JABirchall
commented on May 21, 2024
The postgres server isnt exposed to the public internet, so to access to database a person would need to have access to the server. And if they have access to the server they can just pluck out the passwords from the config files anyway.
So the passwords are no more secure than without a password.
from blockscout.
yohanelly95
commented on May 21, 2024
hey @JABirchall were you able to figure out the backend issue you faced ?
I am still getting
Starting dependencies..
Starting repos..
** (EXIT from #PID<0.132.0>) an exception was raised:
** (Protocol.UndefinedError) protocol Enumerable not implemented for nil of type Atom. This protocol is implemented for the following type(s): Cldr.Unit.Range, DBConnection.PrepareStream, DBConnection.Stream, Date.Range, Ecto.Adapters.SQL.Stream, File.Stream, Floki.HTMLTree, Flow, Function, GenEvent.Stream, HashDict, HashSet, IO.Stream, Indexer.BoundQueue, Jason.OrderedObject, List, Map, MapSet, Postgrex.Stream, Range, Stream, Timex.Interval
(elixir 1.14.5) lib/enum.ex:1: Enumerable.impl_for!/1
(elixir 1.14.5) lib/enum.ex:166: Enumerable.reduce/3
(elixir 1.14.5) lib/enum.ex:4307: Enum.reverse/1
(elixir 1.14.5) lib/keyword.ex:202: Keyword.new/2
lib/explorer/repo/config_helper.ex:61: Explorer.Repo.ConfigHelper.extract_parameters/1
lib/explorer/repo/config_helper.ex:26: Explorer.Repo.ConfigHelper.get_db_config/1
lib/explorer/repo.ex:20: Explorer.Repo.init/2
(ecto 3.11.2) lib/ecto/repo/supervisor.ex:25: Ecto.Repo.Supervisor.runtime_config/4
created another issue here as well #10047
from blockscout.
Related Issues (20)
- Bahamut: <Issue Title>
- Add chain & explorer Prometheus metrics
- ETERNAL AI HOT 1
- Transaction issue HOT 1
- Run Microservices ERROR HOT 2
- What's the problem with synchronization not happening halfway through synchronization? HOT 2
- Support for CELO
- Return small balances as ordinary numbers in Token holders CSV export
- Cleaning a previous deployment and redeploying blockscout for new chain HOT 1
- BRIDGE XTERIO TO BNB chain ISSUE HOT 1
- Want to ask HOT 2
- Refactor `:on_conflict` option usage in import runners
- My Transaction not received HOT 1
- Transactions stuck on "pending"-placed a couple days before Degen L3 outage
- Not received BONE to my Ledger HOT 2
- 0xaA88518157736f39DD41EDfa26C7BE1deeaB5531 HOT 1
- Add support for EIP-1967 Solady proxy pattern
- https://scan.bevm.io/tx/0x00bd0132134644986e0324c9b14d163b9961d89d4ade8655b74d984a21565b16?tab=index HOT 1
- certified flag is not returned in /api/v2/search api endpoint in some cases
- Pending transactions sanitizer: make batched `eth_getTransactionReceipt` request to the JSON RPC node
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from blockscout.