I have been posting pretty regularly for the past few weeks and it's always exciting to receive rewards sats and territory revenue at the end of the day. I eagerly await midnight in Austin so I can check and see what got the most attention from stackers and how many sats I earned for the day.
It's a great feeling to stack sats every day but after a few payouts that seemed light, I noticed that I am not receiving the amount of sats that my wallet history says that I am.
I have felt like something has been wrong for a while but after yesterday's payout, my wallet history said that I received like 1500 sats but my wallet balance only went from 69.1k sats up to 69.9k sats. I'm no math professor but I know a thing or two about arithmetic. Something wasn't adding up so I decided to take a closer look and collect some data.
Sure enough. I am not receiving my rewards sats.
Since there's no total balance history after each transaction in the wallet history, the only way for me to prove anything is wrong, I had to get a video to see how my payout would behave today.
I recorded my balance increasing at midnight in Austin. My balance jumped up from 71,084 to 71,094 for about half a second and then jumped up to 72,610. That means that I earned 1,526 sats in rewards + revenue. Awesome. I love stacking sats.
Here's the video or my wallet getting paid.
However, when I opened my wallet history, it tells a completely different story.
Stacker News payment bot seems to think that it paid me a lot more than it actually did. Here's a screenshot.
It says it paid me the following sats...
1516.026 in rewards (Approximately 1404 + 111 as shown as a unique line item in my notifications)
1196.58 in ~Podcasts
48.02 in ~Movies
10.43 in ~Memes
174.86 in ~Videos
All together that totals 2945.916
...But if you watch my video, you can clearly see that I didn't receive that many sats. I only received 1,526. That's a difference of 1419 missing sats and this is not the first time this has happened.
There have been multiple payments well into the thousands of sats that I never received and there's not really a way for me to prove it without doing a complete audit of my wallet all the way back to the Genesis.
Here's multiple rewards payments that I never received.
Does anyone else seem to be having this problem?
Perhaps that brief stop at 71,094 when I was receiving my payment in my video is some sort of glitch and the bot only pays out like 10 sats for my rewards when it should be 1516.026 on a day like today.
If anyone has any ideas, please let me know as I don't want to be missing out on such substantial payments when I have millions of sats to recoup.
Footnotes
UPDATE ... FROM
statement that increments the same row and column more than once. Each additionalUPDATE
of the row overwrites the previousUPDATE
to it, because the firstUPDATE
has not been committed when the secondUPDATE
runs (because they're in the same statement). egWITH operand (addend, id) as (values (1, 1000), (1, 1000), (1, 1000)) UPDATE my_table set my_sum = my_table.my_sum + operand.addend FROM operand WHERE my_table.id = operand.id
will only add1
tomy_table.my_sum
-- not the expected3
. ↩