run Gittip 72

[chadwhitacre]

71

[chadwhitacre]

This account is in a weird state:

https://www.gittip.com/TheDaleGrant/

The Twitter account is MIA. I looked up the Twitter ID associated with the account, and it resolves to: https://twitter.com/bsebhat. I've flagged the account as suspicious and reached out on Twitter.

[chadwhitacre]

Reviewed 31 accounts.

[chadwhitacre]

I wrote a utility to help manage backups. #1599

[chadwhitacre]

Backup taken and verified. Reticketed #1598.

[chadwhitacre]

Droplet spun up.

[chadwhitacre]

Droplet accessed and updated.

[chadwhitacre]

Script started.

[chadwhitacre]

Ran afoul of the new 10s statement_timeout (#1541):

Traceback (most recent call last):
  File "/home/whit537/www.gittip.com/gittip/cli.py", line 20, in payday
    Payday(db).run()
  File "/home/whit537/www.gittip.com/gittip/billing/payday.py", line 135, in run
    self.payin(ts_start, self.genparticipants(ts_start, ts_start))
  File "/home/whit537/www.gittip.com/gittip/billing/payday.py", line 224, in payin
    for i, (participant, tips, total) in enumerate(participants, start=1):
  File "/home/whit537/www.gittip.com/gittip/billing/payday.py", line 117, in genparticipants
    tips, total = participant.get_tips_and_total(for_payday=for_payday)
  File "/home/whit537/www.gittip.com/gittip/models/participant.py", line 639, in get_tips_and_total
    tips = self.db.all(TIPS, args, back_as=dict)
  File "/home/whit537/www.gittip.com/env/local/lib/python2.7/site-packages/postgres/__init__.py", line 529, in all
    return cursor.all(sql, parameters)
  File "/home/whit537/www.gittip.com/env/local/lib/python2.7/site-packages/postgres/cursors.py", line 145, in all
    self.execute(sql, parameters)
  File "/home/whit537/www.gittip.com/env/local/lib/python2.7/site-packages/psycopg2/extras.py", line 223, in execute
    return super(RealDictCursor, self).execute(query, vars)
QueryCanceledError: canceling statement due to statement timeout

So that's what that looks like. :-)

[chadwhitacre]

Setting statement_timeout per-query during payday reticketed as #1600.

[chadwhitacre]

For now I did:

ALTER ROLE username SET statement_timeout=0;

[chadwhitacre]

I'll change that back to =10000 after payday is done.

Script is off and running.

Parent shell kill -6ed.

[chadwhitacre]

Script ran for {age} (1:34:46.578956).

[chadwhitacre]

I've changed statement_timeout back to 10s.

[chadwhitacre]

I heard from https://www.gittip.com/bsebhat/ (formerly TheDaleGrant) in email and unblocked their account.

[chadwhitacre]

Funding to PayPal hasn't cleared yet. Check again tomorrow.