flyingfishRaydium V4 error codes
Updated 2024-02-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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
34
7KB
137s