run Gittip 98

[chadwhitacre]

97

[chadwhitacre]

43 accounts reviewed. One marked suspicious:

https://www.gittip.com/galim7771/

Two left unreviewed (cf. last week, #2268):

https://www.gittip.com/ejuhlin/
https://www.gittip.com/knotweed/

[chadwhitacre]

Backup taken and verified.

[chadwhitacre]

Droplet spun up and updated.

[chadwhitacre]

Script started.

[chadwhitacre]

Thu Apr 17 14:44:02 UTC 2014
pid-1351 thread-140491469403904 (MainThread) Traceback (most recent call last):
pid-1351 thread-140491469403904 (MainThread)   File "/home/whit537/www.gittip.com/gittip/cli.py", line 32, in payday
pid-1351 thread-140491469403904 (MainThread)     Payday(db).run()
pid-1351 thread-140491469403904 (MainThread)   File "/home/whit537/www.gittip.com/gittip/billing/payday.py", line 131, in run
pid-1351 thread-140491469403904 (MainThread)     self.db.self_check()
pid-1351 thread-140491469403904 (MainThread)   File "/home/whit537/www.gittip.com/gittip/models/__init__.py", line 22, in self_check
pid-1351 thread-140491469403904 (MainThread)     self._check_paydays_volumes()
pid-1351 thread-140491469403904 (MainThread)   File "/home/whit537/www.gittip.com/gittip/models/__init__.py", line 167, in _check_paydays_volumes
pid-1351 thread-140491469403904 (MainThread)     assert len(charge_volume) == 0
pid-1351 thread-140491469403904 (MainThread) AssertionError

[chadwhitacre]

Repro'd locally with this script:

#!/usr/bin/env python                                                                                   
from gittip import wireup                                                                               
db = wireup.db(wireup.env())                                                                            
db._check_paydays_volumes()

[chadwhitacre]

The self-check is saying that during the last payday we recorded a charge volume of 11,079.68 in the paydays table, but in the exchanges table we have a total of 11,358.18. So that's 278.50 in charges that happened during payday but weren't recorded in the paydays table.

Hypothesis: those charges were made manually and weren't actually part of payday even though they happened during payday.

[chadwhitacre]

I see two exchanges manually recorded by @bruceadams on April 16, but that's outside of last payday.

[chadwhitacre]

Got it! There are two more manually recorded entries from @bruceadams that did occur during payday. The payday check should be updated to exclude entries with a non-null recorder.

[chadwhitacre]

Script restarted using refine-self-check branch from #2292.

[chadwhitacre]

Script ran for {age} (1:56:40.881698).

[chadwhitacre]

Tweet tweeted on Twitter.

[chadwhitacre]

Log downloaded.

[chadwhitacre]

Droplet destroyed.

[seanlinsley]

It looks like Balanced's CC failed this week. I mentioned this to @steveklabnik in IRC (Botbot's down)

[steveklabnik]

We re-stocked the card with funds. @seanlinsley thought there might be a need to re-enter the card, is that true?

[chadwhitacre]

@steveklabnik No need to reenter the card. We'll try it again this week. :-)

[chadwhitacre]

MassPay done and escrow shuffled.