indexer icon indicating copy to clipboard operation
indexer copied to clipboard

handle "out of range for type bigint" errors in rebuild service more gracefully

Open xat opened this issue 1 year ago • 0 comments

mostly happens for financial tokens that should be on the ignore-list anyway.

err error: update "tokens" set "fa2_address" = $1, "token_id" = $2, "platform" = $3, "last_processed_event_id" = $4, "last_processed_event_timestamp" = $5, "last_processed_event_level" = $6, "metadata_uri" = $7, "metadata_status" = $8, "minted_at" = $9, "editions" = $10, "burned_editions" = $11, "minter_address" = $12, "artist_address" = $13, "is_verified_artist" = $14, "symbol" = $15, "name" = $16, "description" = $17, "artifact_uri" = $18, "display_uri" = $19, "thumbnail_uri" = $20, "external_uri" = $21, "mime_type" = $22, "creators" = $23, "contributors" = $24, "rights" = $25, "right_uri" = $26, "formats" = $27, "attributes" = $28, "price" = $29, "last_sales_price" = $30, "highest_sales_price" = $31, "lowest_sales_price" = $32, "first_sales_price" = $33, "lowest_price_listing" = $34, "current_price_to_last_sales_price_diff" = $35, "current_price_to_last_sales_price_pct" = $36, "current_price_to_highest_sales_price_diff" = $37, "current_price_to_highest_sales_price_pct" = $38, "current_price_to_lowest_sales_price_diff" = $39, "current_price_to_lowest_sales_price_pct" = $40, "current_price_to_first_sales_price_diff" = $41, "current_price_to_first_sales_price_pct" = $42, "highest_offer_price" = $43, "last_sale_at" = $44, "sales_count" = $45, "sales_volume" = $46, "royalties_total" = $47, "eightbid_creator_name" = $48, "eightbid_rgb" = $49, "objkt_artist_collection_id" = $50, "fx_issuer_id" = $51, "fx_iteration" = $52, "eightscribo_title" = $53, "eightscribo_rowone" = $54, "eightscribo_rowtwo" = $55, "eightscribo_rowthree" = $56 where "fa2_address" = $57 and "token_id" = $58 - value "12020920205498792000" is out of range for type bigint

xat avatar Mar 21 '23 07:03 xat