We currently have 4402 successful cases in which the verificationjob is created for each external verifier.

There are 3773 unsuccessful cases, the most common errors are:
🟢 'Contract source code already verified'
🟢 'Daily limit of 250 source code submissions reached'
🟢 'Max calls per sec rate limit reached (5/sec)'
🔴 'Unable to locate ContractCode at%'

I'll paste here the count of all the errors (I kept only the first 60 chars of the error):

error_preview	occurrences
Daily limit of 250 source code submissions reached	2803
Unable to locate ContractCode at%	676
Smart-contract already verified.	618
The address is not a smart contract	402
Max calls per sec rate limit reached (5/sec)	41
Explorer verification request failed (500):	16
Address is not a smart-contract	16
Contract source code already verified	15
Explorer verification request failed (403): <!DOCTYPE html P	6
fetch failed	5
Explorer verification request failed (500):	2
Already verified	2
Explorer verification request failed (502): <t	1
Explorer verification request failed (429): {"message":"429	1
Explorer verification request failed (404): <	1
Unable to process the standard-input-json you uploaded	1

Here the query to extract the errors:

WITH attempts AS (
    SELECT
        vj.id                       AS job_id,
        v.provider                  AS verifier,
        v.data ->> 'verificationId' AS verification_id,
        v.data ->> 'error'          AS error_msg
    FROM verification_jobs vj
    CROSS JOIN LATERAL (
        VALUES
            ('EtherscanVerify',   vj.external_verification -> 'EtherscanVerify'),
            ('BlockscoutVerify',  vj.external_verification -> 'BlockscoutVerify'),
            ('RoutescanVerify',   vj.external_verification -> 'RoutescanVerify')
    ) AS v(provider, data)
),
bucketed AS (
    SELECT
        CASE
            WHEN error_msg LIKE 'Unable to locate ContractCode at%' THEN
                'Unable to locate ContractCode at%'
            ELSE
                error_msg
        END AS error_bucket
    FROM attempts
    WHERE
        verification_id IS NULL
        AND error_msg IS NOT NULL
)
SELECT
    LEFT(error_bucket, 60) AS error_preview,  -- only first 60 chars in output
    COUNT(*)               AS occurrences
FROM bucketed
GROUP BY error_bucket
ORDER BY occurrences DESC;

Assess success rate of verification on external verifier #2472

Description

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions