What Will You Read?

In this analysis, You will Read about Transactions that Fail in the Flow network. We want to know Do times of high transaction volume lead to more transaction failures? I created a visualization that shows the relationship between transaction volume and the success rate of transactions since May 9th. Are there any noticeable patterns to when transactions are more likely to fail? Were there specific events that seem to cause transaction failures?

Method

Find Failed and succeeded Transactions:

• Failed: I used flow.core.fact_events and set TX_SUCCEEDED to False

• Succeeded: I used flow.core.fact_events and set TX_SUCCEEDED to True

• • Then Counted tx and summed volume to compare each other.

The below chart shows the total daily number of failed and succeeded transactions. As You can see Until May 24th, Most transactions succeeded. But From May 25th until May 31st, We can see more transactions become failed instead of succeeding. Let's find out why. Do you think Volume impacted or Number of transactions?

The Cumulative Daily chart shows a better comparison between the number of Failed transactions and succeeded transactions. These numbers are separated from each other. The Number of Failed transactions increased from May 25th. The slope of growth was significantly.

In the below chart we can understand the previous charts better. This chart is based on total volume. As you can see the volume hasn't changed the number of failed transactions. For example, on May 26th, The total volume of transactions reached 2B but the number of failed transactions is not the highest number. The highest number of failed transactions happened on May 30th.

• The number of successful transactions hasn't changed due to the volume. Like the failed transactions.

I think we can find the answer to this bounty in the below chart. This chart is based on the total number of transactions and the number of failed and succeeded transactions. AS you can see the total number of transactions double in the last week of May. The number of failed transactions increased significantly and succeeded transactions decreased.

In the below chart, You can see the daily percentage of Failed and succeeded transactions. There are some trends on this chart.

• May 13th: 27% of transactions failed
• May 25th: nearly 20% of transactions failed
• From May 26th until May 31st, 30-45% of transactions failed

FeesDeducted, TokensDeposited, and TokensWithdraw are caused by failed transactions.

Expect the three events that we have seen in the previous chart, These events were succeded most of the time.

Conclusion

The number of swaps has a direct relationship with the number of failed transactions. When the network faced a peak, The number of Failed transactions increase. Almost 2 transactions, one of them is successful and one of them is a failure during the peak.

Thank You for Reading

Written by Hess

where discord_id: hess#0890

and

twitter_id: @hessaminanloo