Raydium v4/v5 missing trades in dex_solana.trades

[xiaojay30]

There is a data issue with Raydium v4 and v5. The solana_utils.token_accounts table has missing records, which causes the pool authority accounts for Raydium v4 and v5 to fail matching. As a result, some trades are missing in the dex_solana.trades table.

This needs to be fixed to ensure complete trade coverage for Raydium v4 and v5.

[Vshankcryptoo]

Ok. As the topic is about Raydium Program, I would like to add an issue being faced with raydium program.
For instance, the following transactions that are related to Raydium CPMM(V5) program are missing in dex_solana.trades table.
https://solscan.io/tx/E2Kw5DZPHPRufoKg3oB8e6uP3EynoGN3ovoRxygUDB7QcnnWzVZ3aqAbcfcbFDRhLTMNTu4oQ8h7twSFkz4gvgP
https://solscan.io/tx/M4yKbZgSdRW1wq5Tu7KQPo84xYgD8tiKXnPJ11eekd1ofQpuvVLZU4q225KeCwweC3HQpeyTFWhVpgkRCUbR5zK
https://solscan.io/tx/2XRz8CWXwQT8i6ydRBkPkD9bYpYDcHpYUgQZPMRFBmUHsYsuMpoRkkMgguTuMb9uQ7Q9yfQsehvo7hPBBwi8dN9E
-- When checked with SwapBaseInput table, all these transactions are present in raydium_cp_solana.raydium_cp_swap_call_swapbaseinput table. This proves that these is some logic error in raydium_v5_base_trades.sql program!
-- The same is with this transaction too -- https://solscan.io/tx/5yNrKDN4ipEY4yKdFaatt3jZEiUEoyez6HoLgznefecWE5R6tiJfC6Kfz2gJkyXTr3RDxzKfvcRxp51A1dYZnHwg
this transaction has multiple swaps in it, all swaps are present in dex_solana.trades excepth the swap that happened through Raydium CPMM.

[xiaojay30]

@jeff-dude @0xBoxer

[0xBoxer]

will be fixed by #8870, thanks for reporting

[jeff-dude]

i need to reopen due to reverts in #8885