Overview

• image Source
  This Link

In this dashboard, I will answer this question from Flipside Crypto:

• Establish the failed transaction rate for Osmosis over the last 4 months. Make a case for what is causing the failed transaction rate that you assess and provide recommendations to mitigate it.

Introduction

What is Osmosis (OSMO)

• Osmosis is an automated market maker (AMM) built with the Cosmos SDK; it specializes in the InterchainDeFi movement (Tendermint-based blockchains) in the Cosmos ecosystem. In other words, Osmosis is a decentralized exchange specifically built for Cosmos, with plans to expand to more blockchains.

• Think of Cosmos as the sandbox, and Osmosis as something that can connect all the various dApps. As a DEX, Osmosis nurtures a heterogeneous and interoperable cross-chain trading experience

• A failed transaction happens when a transaction is marked “Fail”, as the funds the sender intended to send are not deducted but remain in the sender’s wallet. However, the“Gas Fee” will still be deducted. Some of the scenarios in where your transaction might fail Out of gas, reverted, bad jump destination, bad instruction,.

• In this dashboard, we'll look at Establish the failed transaction rate for Osmosis over the last 4 months and what type of transaction results in the most failures.

Method

• I used osmosis.core.fact_transactions table to find many answers I did my best to be able to find all possible answers with one Query, And I did this mostly with the help of mathematical equations and came up with the answers.
• then for find what type of transaction results in the most failures I used osmosis.core.fact_msgs But I do not know why I feel that the answers were not found

• The chart above shows the number of failed transactions since the beginning of February 2022. The diagram shows a 5-fold jump and a 2-fold jump.
• According to this chart, the highest number of failed transactions from the beginning until today was 526.143k on May 12, 2022.
• The next jump was on May 25, 2022, when the failed transactions reached 271.437k.
• On other days the failed transactions were between 30k and 138k

• The next comparison also includes the total amount of transactions, which can be seen here again in those 2 days of the month

• The following chart compares the number of failed transactions with the number of successful transactions.
• As mentioned, on May 12 and 25, 2022, the number of failed transactions exceeded the number of successful transactions.
• By May 2022, almost all ecosystems were affected by what happened to Luna. A fear has taken shape in the market and the majority sought to cash in on their capital.

• If we need the above percentage of information, the next chart confirms what we said

• But which category was the most unsuccessful transaction? The following diagram shows this, but I tried very hard to get more accurate information, but it did not work. Most of the table is related to "TX", which accounts for about 68% of our unsuccessful transactions

Cumulative comparisons

• In this section, I checked the accumulated volume.
• From February 1 to May 8, the growth of the volume seems to be uniform.
• From May 8 until today, the growth is slightly out of its previous uniform rhythm

Additional information that may be helpful

provide recommendations to mitigate it

You either have a gas problem.

Or, you have a slippage problem.

• If you are on DEX, you probably need to adjust slippage tolerance and not gas. If you are doing a single transaction, you probably have to adjust gas.

• If you can adjust both, and especially if prices and gas fees are going wild, you may consider adjusting both gas and slippage to avoid failed transactions.

• Failed transactions are most likely to occur during periods of volatility, and each transaction that fails will cost (sometimes a lot).

• So if one transaction fails, slow down, refresh prices, adjust slippage and/or gas, and try again.

• TIP: This only applies when using web3 wallets, dexes, etc. Centralized exchanges like Coinbase don’t use gas.

• TIP: Paying to speed up a transaction can result in the transaction being stuck in some rare cases. Unsticking it can be a pain. You might consider not doing this and focusing on paying more upfront if you can help it. However, generally, if your transaction is being slow, paying to speed it up is the best solution. I personally speed up transactions all the time and have rarely had an issue.

• TIP: If the prices of the coins you are trading are moving really fast, you may have to do a transaction very quickly and adjust slippage tolerance way up (for a really illiquid and volatile coin, 15% isn’t unheard of). If gas prices are moving really fast, you may have to overshoot by a good bit. The charts in both cases will clue you in as to what you have to do.

• TIP: With slippage, you won’t necessarily incur the full slippage tolerance amount. That is only the max slippage amount. With gas, you will pay what you offer to pay. So… don’t offer to pay more than you are willing to pay, check the current gas fees, and aim toward a reasonable high end, and you’ll almost always be fine.

Conclusions

• Unsuccessful transactions were below 150k from February 1 to May 7.
• On May 12, it more than quadrupled to 526.15k.
• On May 25, it had a smaller jump than before, and the number of failed transactions reached 271.437k.
• The highest number of unsuccessful transactions was recorded in tables called t x, which accounted for 67.9%.