When Do Flow Transactions Fail? (Part II)
Q7. Building off last week's question investigating when transactions fail on Flow, what addresses and contracts are causing the majority of failures? What types of activities and events are these addresses doing that are spamming the network? What types of arbitrage opportunities are they seeking and how profitable are these efforts?
Flow is a new blockchain that is simple to use and effective for building the next generation of apps, games, and digital assets.
Flow was also built from the ground up to deliver an exceptional user experience at scale, and it is today a decentralized network sponsored and maintained by a growing community of businesses and Web3 developers.
Read more here
- Return the total number of Flow chain transaction failures since May 9th, 2022.
- Calculate and compare the daily transaction failure rate on the Flow chain to the transaction volume.
- Identify the top ten addresses with the largest number of failed transactions.
- Retrieve the contract event containing the failed transaction.
- Determine what type of event those top ten addresses are for.
- Find out how successful Solana's transactions have been since May 9th.
- Compared the success rates of Solana and Flow.
- Examine any trends and devise a strategy to keep Flow from failing more frequently.
The charts show the failure rate on the Flow chain since May 9th. From a total of nearly 15 million transactions, we may determine that 28.6 percent of all transactions were failed.
According to the statistics, only three events have failed transactions: TokensDeposited, TokensWithdrawn, and FeeDeducted. They all have the same percentage of failed transactions (33.3%).
Since May 9th, the graphs reflect the daily transaction failure count and total transaction volume.
Interestingly, the total transaction volume swings between 300,000 and 700,000 per day, but after May 26th, the daily failure count is extremely high then back to a normal rate after June.
Since May 9th, the charts indicate the number of successful and failed Solana transactions. Solana evidently has an extremely high failure count that is just slightly lower than the success count throughout the peroid.
This graph compares Solana and Flow's transaction success rates. As we can see on a daily basis, Flow has a success rate of around 90%, but there are roughly 7 days from May 24 to 30 when the success rate drops below 20% before returning to around 90%.
Solana, on the other hand, has a concerningly low success rate of 50 to 60 percent throughout the duration, which is significantly lower than Flow on most days.
To prepare for and prevent drops in success rate, we can use stake-weighted transaction QoS as Solana, which leader network bandwidth has a fixed capacity and to effectively use it, prioritization is a must in order to end the current practice of accepting transactions carelessly, regardless of source. This model states that a node has the right to transmit at least the percentage of staked packets to the leader and the rest of the network.
This graphic illustrates the percentage of overall success and failed transactions for the top ten addresses with the most unsuccessful transactions since May 9th. Surprisingly, around 47.5 percent of total transactions or 4.2 million transactions are unsuccessful.
The graph depicts the top ten addresses with the most failed transactions since May 9th. We can see that 0a386...e27 has the most unsuccessful transactions with 1.9 million, but only 2200 successful transactions, accounting for only 0.1 percent of total transactions from that address.
Since May 9th, the charts show the daily transaction event count from the top 10 addresses with the most unsuccessful transactions. TokenDeposited is the most active event among the top ten addresses used to spam the network, followed by TokenWithdrawn, which accounts for about 25 to 30 percent of daily activity.
Let's take a look at the highest failure count address, 0a386...e27, to see what kind of behavior this account is up to. The data from FlowScan
According to the previous analysis, 0a386...e27 has the most unsuccessful transactions (1.9 million), but only 2200 successful transactions (0.1 percent of total transactions from that address).
And FlowScan data revealed that almost (if not all) of the transactions interacted with the FlowToken and FlowFee events.
- 28.6 percent of all Flow transactions failed, out of a total of approximately 15 million.
- The flow success rate is extremely low after May 26th, then rebounds to normal after June.
- 0a386...e27 has the highest number of unsuccessful transactions.
- According to the statistics, only three events had unsuccessful transactions: TokensDeposited, TokensWithdrawn, and FeeDeducted.
- Flow has a success rate of more than 90%, although there are around 7 days from May 24 to 30 when the success rate falls below 20% before recovering to 90%.
- Throughout the research period, Solana had a concerningly low transaction efficacy rate of 50 to 60%.