As reported by @Jon_Hodl, founders of multiple territories were only receiving revenue for one of their territories each day.
The change I just pushed made these founders whole: for each day we should've paid them revenue on multiple territories, we've back paid them for ALL territories including repaying them for the one territory they were already paid for.
A description of the cause of the bug can be found in the footnote of this comment, which might be informative for anyone else that's in an abusive relationship with postgres.
This bug has also been fixed for any future territory revenue payments. Additionally, we weren't adding territory revenue to sats stacked as seen in profiles and that's been fixed retroactively and into the future.
The following past or current owners of multiple territories suffered from this bug and should, by the time this is posted, experienced the shown increase in their wallet balances:
| nym | back sats |
| @siggy47 | 541782 |
| @benwehrman | 333332 |
| @davidw | 193687 |
| @ek | 131699 |
| @AtlantisPleb | 109638 |
| @MaxAWebster | 70078 |
| @OneOneSeven | 61384 |
| @UCantDoThatDotNet | 54372 |
| @Jon_Hodl | 37607 |
| @nout | 26488 |
| @needcreations_ | 19527 |
| @south_korea_ln | 6663 |
| @BlokchainB | 6371 |
| @lloyddunne | 4829 |
| @roytheholographicuniverse | 4201 |
| @niftynei | 4065 |
| @UCantDoThatDotRugged | 3388 |
| @kr | 1851 |
| @antic | 1079 |
| @Ed_Relight | 87 |
Damn. With all those sats I need a new territory.
Basically investing into SN bugs at this point
Exactly
Haha another territory? What would it be?
Don't know. I actually already have more than I can handle.
Maybe you can invest in the dog.
~Stacker_Fitness could use a sponsor!
@grayruby willing to pledge 25k. We’re going to undercut @benwehrman and his 1000 sat pay-to-post ~health territory. We’re reviving the mortal community ~fitness and bringing it back from the dead. @Coinsreporter thinks it’s a great idea!
U in? 🐕
Why do you need to undercut him? Just ask him to lower his fee and tell him why. More posting for him will help him become profitable. No reason to undercut him. @benwehrman thoughts?
Lifetime ownership!
lol
Linux
Much sats much wow
Nice! Forced Hodl!
the best hodl
Beyond not owning any territory, I appreciate your honesty. A large sum for @siggy47. Now your wife is letting you stay up later on sn
Wow. Glad all of that got sorted.
Looks like beers are on @siggy47
I would say so.
@siggy47 ought to tip you @Jon_Hodl for your service!
I had zero clue hahaha but thanks!!
Good job verifying instead of trusting @Jon_Hodl !
Yeah, I'm not sure that I really did all that much except for just trying to get all my due sats but it's refreshing to see k00b find the problem and push a fix so quickly.
It's good to see you more active here on SN. The lack of threaded replies on Bitcoin Talk makes it so difficult to follow conversations sometimes.
Wow, thats a lot
It's a pretty big f-up.
I just wanted to note that my territory identifies as multiple territories. Haha
I had a notion something was screwy and I kept meaning to do the math. Good thing @Jon_Hodl did. When audits are available this stuff won't happen, I guess.
It may still happen. We'll just all know when it does.
We've done several manual audits in the past when folks have reported issues and everything was right down to the millisat. This in particular was a really subtle bug that requires understanding how a single postgres
updatestatement might not do what it appears to - we couldn't easily reason about this a priori.Must really understand the fee structure and coding well.
Your response to all of it was amazing though, k00b.
Very well done.
You made it right, thats what counts.
I thought it’d be more
You got 131k, thats not too bad.
@benwehrman with almost 333333
333332069 millisats so it doesn't round up sadly.
This made me chuckle
This posts speaks very highly of you, @k00b. It does not affects me as I am not a territory owner. However, the fact you acknowledge the bug and paying back to them, it means a lot. Keep up this great job. Also, congrats to @Jon_Hodl for taking the time to find out what was wrong.
Yeah, k00b's response gives me a lot of faith in the direction of Stacker News.
Look what you did @Jon_Hodl
https://i.giphy.com/media/v1.Y2lkPTc5MGI3NjExajgxc2J0cXVkMng3YzZxZzhrcmtrNTlqajVoZDRyeHU1emxmcTU5dyZlcD12MV9pbnRlcm5hbF9naWZfYnlfaWQmY3Q9Zw/aybJTp7RlbA7Yl9HIK/giphy.gif