flyingfishRaydium V4 error codes
    Updated 2024-02-07
    with raw_logs AS (
    SELECT
    block_timestamp
    --, index
    , value AS log_text
    -- , log_messages
    -- , account_keys
    , tx_id
    FROM solana.core.fact_transactions
    , lateral flatten(input => log_messages)
    WHERE 1 = 1
    AND block_timestamp::date > current_date - 7
    --AND block_timestamp::date = '2024-02-06'
    --AND block_timestamp > current_timestamp - interval '1 hour' --
    AND ARRAY_CONTAINS('Program 675kPX9MHTjS2zt1qfr1NYHuzeLXfQM9H24wFSUt1Mp8 invoke [1]'::variant, log_messages)
    AND NOT ARRAY_CONTAINS('Program 675kPX9MHTjS2zt1qfr1NYHuzeLXfQM9H24wFSUt1Mp8 success'::variant, log_messages)
    AND succeeded = FALSE
    -- AND tx_id = '2ag2inTyzcvzPLmo6r4aAthRieJ6cWBktWXssgSVXdqKVXTXaZQtmV1Pyvv2f5o6UnFqTFL2fthmi9bStQzYEAqB'
    -- AND tx_id = '3GvN8wHk64RbUGPrZW6HZHSUyc5xTYwBgJfGA8NxJtgL2GNvnwGUCTSvMFcW2fT92yco3Ts8rgtqZxveJbePrkbg'
    )
    , raw_wide AS (
    SELECT
    tx_id
    , max(CASE WHEN log_text ilike 'Program log: Error:%' then log_text end) AS error_text
    , max(CASE WHEN log_text ilike 'Program 675kPX9MHTjS2zt1qfr1NYHuzeLXfQM9H24wFSUt1Mp8 failed:%' then log_text end) AS error_code
    FROM raw_logs
    WHERE log_text ilike 'Program log: Error:%'
    OR
    log_text ilike 'Program 675kPX9MHTjS2zt1qfr1NYHuzeLXfQM9H24wFSUt1Mp8 failed:%'
    GROUP BY 1
    )
    SELECT
    TRY_CAST(SUBSTRING(error_text, POSITION('Program log: Error: ' IN error_text) + LENGTH('Program log: Error: ')) AS STRING) AS error_txt
    , CASE
    WHEN error_code ilike '%custom program error:%' THEN
    TRY_CAST(SUBSTRING(error_code, POSITION('Program 675kPX9MHTjS2zt1qfr1NYHuzeLXfQM9H24wFSUt1Mp8 failed: custom program error: ' IN error_code) + LENGTH('Program 675kPX9MHTjS2zt1qfr1NYHuzeLXfQM9H24wFSUt1Mp8 failed: custom program error: ')) AS STRING)
    Last run: about 1 year ago
    ERROR_TXT
    PROG_ERROR
    COUNTER
    SAMPLE_TX
    SAMPLE_TX_2
    1
    The amm account owner is not match with this program0x1b83568397
    GtXGzwZg1nMNdAAE5Fs5daw6mjuCBZQaw3M6yYnrBWRHjDiggQ53s6zdReKnuFVcNs9vVQFb...
    GtXGzwZg1nMNdAAE5Fs5daw6mjuCBZQaw3M6yYnrBWRHjDiggQ53s6zdReKnuFVcNs9vVQFb...
    2
    InvalidStatus0x168781975
    5jqcEmdZ4cfsGn2mZbNKdUVw3AKiLSyy4wSCNxUZrZduBoXwWBmS32FquKo4d3uxMndwgc8G...
    5jqcEmdZ4cfsGn2mZbNKdUVw3AKiLSyy4wSCNxUZrZduBoXwWBmS32FquKo4d3uxMndwgc8G...
    3
    insufficient funds0x287327255
    42x66PdmwafUzXVBoiUCjeQeHMo5LEz1g3y5Cm9mPYdLEoMdXsHh3GAK4JPRJsYnkCgNiZdK...
    42x66PdmwafUzXVBoiUCjeQeHMo5LEz1g3y5Cm9mPYdLEoMdXsHh3GAK4JPRJsYnkCgNiZdK...
    4
    exceeds desired slippage limit0x1e4796300
    tFFJT29izbwk5keKjTNGPNpVLGQtEogsVJ97XARDfT195KasCiGq6PXeDUQLUhprYb7NFskK...
    tFFJT29izbwk5keKjTNGPNpVLGQtEogsVJ97XARDfT195KasCiGq6PXeDUQLUhprYb7NFskK...
    5
    InvalidSplTokenProgram0x26928151
    4tmq1y8jKJxtwT7MTpgTBiw5SLELj6fjmmpsB1uTgbPpJEuCcwXxunWFwSV1gXxtKe7B2Ni1...
    4tmq1y8jKJxtwT7MTpgTBiw5SLELj6fjmmpsB1uTgbPpJEuCcwXxunWFwSV1gXxtKe7B2Ni1...
    6
    InvalidInput0x1d668488
    5iQAqjzJSaQx5sVoiy2GogHXDb1ofGTd4W5kbKZnFXqVJHP4RJcuBsq7xSMbhxDgGT57hrtJ...
    5iQAqjzJSaQx5sVoiy2GogHXDb1ofGTd4W5kbKZnFXqVJHP4RJcuBsq7xSMbhxDgGT57hrtJ...
    7
    Program failed to complete252084
    5ddYh4m98ZAs1qwrMu1rWofm71XNSjRLS7rDrJGGZffNRhUW39d9Bnm4fYatP6eYanHBUjU7...
    5ddYh4m98ZAs1qwrMu1rWofm71XNSjRLS7rDrJGGZffNRhUW39d9Bnm4fYatP6eYanHBUjU7...
    8
    Computational budget exceeded32836
    2JLG84kVXfg1EZ5tcLEafLgeFAjK321uFzQromBoJT3e5nVQ56UkZMJFcJ2ok7dPqc3MZja7...
    2JLG84kVXfg1EZ5tcLEafLgeFAjK321uFzQromBoJT3e5nVQ56UkZMJFcJ2ok7dPqc3MZja7...
    9
    User token input does not match amm0x2a29878
    3DWgAAJUzMiLfgnhqwgbWyCeNCz2jyH1ddDX68BZXRExWFZxhLqE7XG5KZApmNM6tEmFpgiq...
    3DWgAAJUzMiLfgnhqwgbWyCeNCz2jyH1ddDX68BZXRExWFZxhLqE7XG5KZApmNM6tEmFpgiq...
    10
    ExpectedAccount0x312723
    4MV618kBZumYRuTjswzJf7nPWa5Qc9DyAtekUhtT6CR8pth578Ub6AUgTo4FCgxjT8E1z2tq...
    4MV618kBZumYRuTjswzJf7nPWa5Qc9DyAtekUhtT6CR8pth578Ub6AUgTo4FCgxjT8E1z2tq...
    11
    Account is frozen0x117462
    5R6TfCnYoiPtq5N1cWQqZJxxHLi2zteps2rY3EkNTSmgFADtEFTWy1ta6LMbDyzVM221W1ei...
    5R6TfCnYoiPtq5N1cWQqZJxxHLi2zteps2rY3EkNTSmgFADtEFTWy1ta6LMbDyzVM221W1ei...
    12
    exceeded CUs meter at BPF instruction6824
    74WRHUiJ8JzK165PkY7o9CnphSgkwVhAVsRrJkdGpKEeanLyGbGgSZCgPvtoBbyvC6YFBQqx...
    74WRHUiJ8JzK165PkY7o9CnphSgkwVhAVsRrJkdGpKEeanLyGbGgSZCgPvtoBbyvC6YFBQqx...
    13
    SBF program panicked4855
    2CXg94QpmVjMAMvXaMGZHHV55AyN5n7vsBAE9MCVqoULFKQP84dqgND5sD3812NnHUYWFQan...
    2CXg94QpmVjMAMvXaMGZHHV55AyN5n7vsBAE9MCVqoULFKQP84dqgND5sD3812NnHUYWFQan...
    14
    0x1146
    eiL2Tu6oP587rK2pJoVxuqZQs5Nsuqxc6cDU3E4sX1Yw5QBQnqAdCa7CB4W3bPPV39jrwpNV...
    eiL2Tu6oP587rK2pJoVxuqZQs5Nsuqxc6cDU3E4sX1Yw5QBQnqAdCa7CB4W3bPPV39jrwpNV...
    15
    InvalidCoinVault0x4112
    3GotRTNzX2Ntxz3o8yea13VYrgrKTQbaMfvWUNrSjGUpdFBKmhoLgiLP4nmqRy77uPudxtaM...
    3GotRTNzX2Ntxz3o8yea13VYrgrKTQbaMfvWUNrSjGUpdFBKmhoLgiLP4nmqRy77uPudxtaM...
    16
    The amm account owner is not match with this programexceeded CUs meter at BPF instruction100
    17HV7ej4jATG7wRhod21gXB5Y4LMiVR9b8BbqyQmPDJB1SXBdd1MVfEY42tC2UCntk52Nfi5...
    17HV7ej4jATG7wRhod21gXB5Y4LMiVR9b8BbqyQmPDJB1SXBdd1MVfEY42tC2UCntk52Nfi5...
    17
    InvalidAccountDatainvalid account data for instruction71
    erornw81vvy6Ns6rNA6zSom8MFwhYcWDaYuWkD5AXTeMLFSh1rpzAf1mKBWe5Cx4hxH4q2iy...
    erornw81vvy6Ns6rNA6zSom8MFwhYcWDaYuWkD5AXTeMLFSh1rpzAf1mKBWe5Cx4hxH4q2iy...
    18
    InvalidMarketProgram0xc43
    2izyZohWeMoKMByvZGryZ59uhrpy4Chbt35yjk5qsKGFyS7jWxtn8rXWScHWS7zW9ARNHX4b...
    2izyZohWeMoKMByvZGryZ59uhrpy4Chbt35yjk5qsKGFyS7jWxtn8rXWScHWS7zW9ARNHX4b...
    19
    Init lp amount is too less(Because 10**lp_decimals amount lp will be loc...
    0x3925
    3HK8F9FdWhdTr37n8KNj5tXSp6qQjJQGn4fJHUNufPxy3LXyQ7EwUJ2Rh7Fr91EmTKAfzmhv...
    3HK8F9FdWhdTr37n8KNj5tXSp6qQjJQGn4fJHUNufPxy3LXyQ7EwUJ2Rh7Fr91EmTKAfzmhv...
    20
    InvalidCoinMint0x1023
    2mzj5bSRk6UTk5J2Nf3sPoKePg5vdFmfsioSzBicHeyavrJY9XobNzKjQwrQSQqQdxH9Z8Yg...
    2mzj5bSRk6UTk5J2Nf3sPoKePg5vdFmfsioSzBicHeyavrJY9XobNzKjQwrQSQqQdxH9Z8Yg...
    34
    7KB
    137s