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

Exceptions in blockscout explorer service #2469

Open
rgederin-dev opened this issue Feb 4, 2025 · 0 comments
Open

Exceptions in blockscout explorer service #2469

rgederin-dev opened this issue Feb 4, 2025 · 0 comments

Comments

@rgederin-dev
Copy link

Hi all

I am started local devnet cluster using kurtosis and steps described here - https://docs.berachain.com/nodes/guides/kurtosis

However after starting local devnet using kurtosis, blockscout explorer almost immediately starts to producing errors in logs and due to this not reflect actual information in explorer UI:

{"time":"2025-02-04T09:19:33.742Z","severity":"warn","message":"Set refetch_needed for partially imported block because of error: [244]","metadata":{"fetcher":"block_catchup","first_block_number":244,"last_block_number":244}}
{"time":"2025-02-04T09:19:33.745Z","severity":"error","message":"** (DBConnection.EncodeError) Postgrex expected an integer in -2147483648..2147483647, got 18446744073709551615. Please make sure the value you are passing matches the definition in your table or in your query or convert the value accordingly.\n    (postgrex  
....
on_conflict: #Ecto.Query<from w0 in Explorer.Chain.Withdrawal, where: fragment(\n  \"(EXCLUDED.validator_index, EXCLUDED.amount, EXCLUDED.address_hash, EXCLUDED.block_hash) IS DISTINCT FROM (?, ?, ?, ?)\",\n  w0.validator_index,\n  w0.amount,\n  w0.address_hash,\n  w0.block_hash\n), update: [\n  set: [\n    validator_index: fragment(\"EXCLUDED.validator_index\"),\n    amount: fragment(\"EXCLUDED.amount\"),\n    address_hash: fragment(\"EXCLUDED.address_hash\"),\n    block_hash: fragment(\"EXCLUDED.block_hash\"),\n    inserted_at: fragment(\"LEAST(?, EXCLUDED.inserted_at)\", w0.inserted_at),\n    updated_at: fragment(\"GREATEST(?, EXCLUDED.updated_at)\", w0.updated_at)\n  ]\n]>, returning: true, timeout: 60000, timestamps: %{inserted_at: ~U[2025-02-04 09:19:31.747367Z], updated_at: ~U[2025-02-04 09:19:31.747367Z]}]\n\nException:\n\n** (DBConnection.EncodeError) Postgrex expected an integer in -2147483648..2147483647, got 18446744073709551615. Please make sure the value you are passing matches the definition in your table or in your query or convert the value accordingly.\n  

It looks like this is a Postgrex EncodeError due to an integer overflow when trying to insert a value into your PostgreSQL database. The error message indicates that an extremely large integer (18446744073709551615) is being passed, but PostgreSQL expects an integer within the range -2147483648 to 2147483647 (for INTEGER) or -9223372036854775808 to 9223372036854775807 (for BIGINT).

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant