run Gratipay 190 #477

rohitpaulk · 2016-01-21T14:41:48Z

189

rohitpaulk · 2016-01-21T14:47:24Z

Reviewing users...

rohitpaulk · 2016-01-21T14:48:15Z

@whit537 - I see a suspicious user, and I don't have access to the violations repo...

rohitpaulk · 2016-01-21T14:49:30Z

Migrating tips..

rohitpaulk · 2016-01-21T14:59:59Z

Migrated 0 tip(s) for 'shields'
Migrated 0 tip(s) for 'detexify'
'sudomesh' already migrated.
Migrated 0 tip(s) for 'juice-shop'
'byebug' already migrated.
'konlpy' already migrated.
Migrated 0 tip(s) for 'hamper'
Migrated 0 tip(s) for 'searx'
'md-for-bootstrap' already migrated.
Migrated 0 tip(s) for 'orionjs'
'torque3d' already migrated.
Migrated 0 tip(s) for 'piloting-postdevelopment'
'nim' already migrated.
'tabula' already migrated.
'exercism' already migrated.
Migrated 0 tip(s) for 'meteor-active-route'
'aegirproject' already migrated.
Migrated 0 tip(s) for 'openlp'
'catapultpgh' already migrated.
'svg-js' already migrated.
Migrated 0 tip(s) for 'rtail'
Migrated 0 tip(s) for 'sean-js'
'trakt-for-plex' already migrated.
Migrated 0 tip(s) for 'bootswatch'
'flexget' already migrated.
'the-perl-review' already migrated.
'rubocop' already migrated.
'pylonsproject' already migrated.
Migrated 0 tip(s) for 'tyf'
Migrated 0 tip(s) for 'hypatia-software-organization'
'nanoc' already migrated.
Migrated 0 tip(s) for 'tech-store-club'
'ucoin' already migrated.
'image-optim' already migrated.
'rhombus-tech' already migrated.
'pageres' already migrated.
'davorg' already migrated.
'fabric-js' already migrated.
'cpan-book' already migrated.
'dreditor' already migrated.
Migrated 0 tip(s) for 'libravatar'
'northern-plains-athletics' already migrated.
'gammu' already migrated.
'the-charis-project' already migrated.
Migrated 0 tip(s) for 'kriasoft'
'webtorrent' already migrated.
'josd' already migrated.
Migrated 0 tip(s) for 'projectcloudly'
Migrated 0 tip(s) for 'junest'
Migrated 0 tip(s) for 'musical-artifacts'
Migrated 0 tip(s) for 'simple-icons'
Migrated 0 tip(s) for 'slap'
Migrated 0 tip(s) for 'flexible-grid-system'
Migrated 0 tip(s) for 'weblog-sh'
'sailor' already migrated.
'drupal-search-api' already migrated.
Migrated 0 tip(s) for 'liboctavo'
'mojolicious' already migrated.
'teampopong' already migrated.
'debian-lts-by-freexian' already migrated.
'cpan-io' already migrated.
'doit' already migrated.
'cuberite' already migrated.
'encommuns' already migrated.
'perlweekly' already migrated.
'json-resume' already migrated.
'devdocs' already migrated.
'org-mode' already migrated.
'weblate' already migrated.
'perl-maven' already migrated.
'the-mountain-spirit' already migrated.
Migrated 0 tip(s) for 'hunter'
Migrated 0 tip(s) for 'ng-file-upload'
Migrated 0 tip(s) for 'code-for-seoul'
'act' already migrated.
'knopproject' already migrated.
'grip' already migrated.
Migrated 0 tip(s) for 'kivy'
Migrated 0 tip(s) for 'vegeta'
Migrated 0 tip(s) for 'coala'
'magit' already migrated.
'zed' already migrated.
'introtopython' already migrated.
Migrated 0 tip(s) for 'concrete-clouds'
Migrated 0 tip(s) for 'funcool'
'fsnotify' already migrated.
'citizens-network' already migrated.
'cider' already migrated.
Migrated 0 tip(s) for 'matlab-schemer'
Migrated 0 tip(s) for 'toolitup'
Migrated 0 tip(s) for 'vanilla-music'
Migrated 0 tip(s) for 'yawttk'
Migrated 0 tip(s) for 'cdnjs'
Migrated 0 tip(s) for 'wallabag'
'sublimelinter' already migrated.
'esdiscuss' already migrated.
Migrated 0 tip(s) for 'share-term'
'civicrm-lts' already migrated.
'webpack' already migrated.
'contribkanban-com' already migrated.
Migrated 0 tip(s) for 'botwiki-org'
'totalism-hackbase' already migrated.
Migrated 0 tip(s) for 'tipsy'
Migrated 0 tip(s) for 'brainfock'
Migrated 0 tip(s) for 'chameleon'
Migrated 0 tip(s) for 'gryd'
'dokku' already migrated.
Migrated 0 tip(s) for 'retrospring'
'grimoire' already migrated.
Migrated 0 tip(s) for 'itcase'
Migrated 0 tip(s) for 'sharex'
Migrated 0 tip(s) for 'drupal-media-youtube-upload'
Migrated 0 tip(s) for 'coinvest'
Migrated 0 tip(s) for 'os-js'
'pjf' already migrated.
'bevry' already migrated.
Migrated 0 tip(s) for 'radiant-player'
Migrated 0 tip(s) for 'macdown'
Migrated 0 tip(s) for 'phanbook'
'cappuccino' already migrated.
Migrated 0 tip(s) for 'jeto'
'sudo-room' already migrated.
Migrated 0 tip(s) for 'poll'
Migrated 0 tip(s) for 'youtransfer-io'
Migrated 0 tip(s) for 'flamecore'
'jshttp' already migrated.
'minotar' already migrated.
Migrated 0 tip(s) for 'jsfile'
Migrated 0 tip(s) for 'inventaire-io'
'duo' already migrated.
Migrated 0 tip(s) for 'flif'
'simplytest-me' already migrated.
'pariskiwi' already migrated.
Migrated 0 tip(s) for 'decent-im'
Migrated 1 tip(s) for 'amokjs'
Migrated 0 tip(s) for 'swissdb'
'endless-parentheses' already migrated.
'reddit-enhancement-suite' already migrated.
Migrated 0 tip(s) for 'neocities'
'cyberpipe' already migrated.
Migrated 0 tip(s) for 'asciinema'
'gkz-open-source' already migrated.
'chocolatey' already migrated.
Migrated 0 tip(s) for 'pomodoro-cc'
Migrated 0 tip(s) for 'opensnp'
'wdrl' already migrated.
'pillow' already migrated.
Migrated 0 tip(s) for 'ruboto'
Migrated 0 tip(s) for 'horizon-launcher'
'nuvola-player' already migrated.
'sqlalchemy' already migrated.
'jsbin' already migrated.
'Gratipay' already migrated.
'opencv' already migrated.
Done.

rohitpaulk · 2016-01-21T15:00:10Z

1 tip migrated! 💃

rohitpaulk · 2016-01-21T15:01:03Z

I'm not downloading a backup, but I am triggering one on Heroku.

chadwhitacre · 2016-01-21T15:02:07Z

1 tip migrated! 💃

💃

I'm not downloading a backup, but I am triggering one on Heroku.

wfm

rohitpaulk · 2016-01-21T15:12:07Z

TIL that we allow spaces in usernames

chadwhitacre · 2016-01-21T15:15:09Z

And we allow the empty string as a username. ;-)

rohitpaulk · 2016-01-21T15:16:16Z

We have ourselves an error...

chadwhitacre · 2016-01-21T15:16:31Z

!

rohitpaulk · 2016-01-21T15:16:39Z

pid-1507 thread-140735195557888 (MainThread) Updating balances.
pid-1507 thread-140735195557888 (MainThread) Traceback (most recent call last):
pid-1507 thread-140735195557888 (MainThread)   File "/Users/lp-eng-ggn-096/experiments/gratipay/gratipay.com/gratipay/cli.py", line 24, in payday
pid-1507 thread-140735195557888 (MainThread)     Payday.start().run()
pid-1507 thread-140735195557888 (MainThread)   File "/Users/lp-eng-ggn-096/experiments/gratipay/gratipay.com/gratipay/billing/payday.py", line 132, in run
pid-1507 thread-140735195557888 (MainThread)     self.payin()
pid-1507 thread-140735195557888 (MainThread)   File "/Users/lp-eng-ggn-096/experiments/gratipay/gratipay.com/gratipay/billing/payday.py", line 170, in payin
pid-1507 thread-140735195557888 (MainThread)     raise
pid-1507 thread-140735195557888 (MainThread)   File "/Users/lp-eng-ggn-096/experiments/gratipay/gratipay.com/env/lib/python2.7/site-packages/postgres/context_managers.py", line 46, in __exit__
pid-1507 thread-140735195557888 (MainThread)     self.conn.rollback()
pid-1507 thread-140735195557888 (MainThread) OperationalError: SSL SYSCALL error: EOF detected
pid-1507 thread-140735195557888 (MainThread)

rohitpaulk · 2016-01-21T15:17:07Z

Happened after Updating balances, so we're aaalmost done.

chadwhitacre · 2016-01-21T15:17:08Z

Huh ... looks like a network error?

rohitpaulk · 2016-01-21T15:17:45Z

Yep, looks like it. We should try running this on a droplet next time :)

rohitpaulk · 2016-01-21T15:18:01Z

Restart, I guess?

chadwhitacre · 2016-01-21T15:18:32Z

http://stackoverflow.com/questions/24130305/postgres-ssl-syscall-error-eof-detected-with-python-and-psycopg suggests it could have something to do with mis-escaping? What ended up happening with the email pkid work in that regard?

chadwhitacre · 2016-01-21T15:19:44Z

We should try running this on a droplet next time :)

Yeah, that would be the workaround for network issues. :)

Restart, I guess?

If that SO link re: string escaping doesn't ring any bells, then yes ... but can we think through this first?

chadwhitacre · 2016-01-21T15:19:58Z

We haven't had an error in a while ... where did we fail and is restarting going to be okay?

chadwhitacre · 2016-01-21T15:20:13Z

Happened after Updating balances, so we're aaalmost done.

chadwhitacre · 2016-01-21T15:21:23Z

It could've happened during the updating balances call. The log message is emitted just before the call.

chadwhitacre · 2016-01-21T15:21:54Z

I guess we have to rerun because we've lost our cursor.

rohitpaulk · 2016-01-21T15:22:31Z

I see "Updating balances..." but not "Updated balances of xx participants"

chadwhitacre · 2016-01-21T15:22:41Z

What's the expected behavior when rerunning? We loop over all participants again but their balances are enough to cover their payments, so we don't charge them a second time? Right?

rohitpaulk · 2016-01-21T15:22:56Z

Yes, correct. I'm going to verify that with one user though, just to make sure

chadwhitacre · 2016-01-21T15:23:08Z

Okay. !m @rohitpaulk

rohitpaulk · 2016-01-21T15:23:23Z

I checked your account, looks like we're good.

chadwhitacre · 2016-01-21T15:23:31Z

Okay. What do you think of http://stackoverflow.com/questions/24130305/postgres-ssl-syscall-error-eof-detected-with-python-and-psycopg?

chadwhitacre · 2016-01-21T15:24:23Z

We didn't reintroduce string interpolated SQL in gratipay/gratipay.com#3893 or related, did we?

rohitpaulk · 2016-01-21T18:15:24Z

cd ../masspay and git commit the four new files.

That directory doesn't fall under a git repository... @whit537 - Do you have that folder linked to the logs git repo?

chadwhitacre · 2016-01-21T18:16:17Z

@rohitpaulk Yeah, we can clean that up maybe. I have symlinks locally that put masspay/ in the expected place.

chadwhitacre · 2016-01-21T18:16:38Z

As well as paydays/.

rohitpaulk · 2016-01-21T18:19:04Z

Aha. I've copied them manually for now, but I'll end up doing the same later. We could make it a convention to have a Folder structure like

gratipay
    - logs (repo)
        - payday
        - masspay
    - gratipay.com
    - inside.gratipay.com

rohitpaulk · 2016-01-21T18:20:51Z

Where do I get the gratipay API key from?

chadwhitacre · 2016-01-21T18:22:14Z

We could make it a convention to have a Folder structure like

👍 Reticketed as gratipay/gratipay.com#3901.

chadwhitacre · 2016-01-21T18:22:36Z

Where do I get the gratipay API key from?

https://gratipay.com/~rohitpaulk/settings/ :-)

rohitpaulk · 2016-01-21T18:24:29Z

Oh, any admin's API key.. I thought we had a specific one for this :P

chadwhitacre · 2016-01-21T18:27:14Z

@rohitpaulk Naw, we could maybe use ~Gratipay's, but I've been using my own so far.

rohitpaulk · 2016-01-21T18:29:12Z

Nah, this makes sense... The sudden 'WHERE IS GRATIPAY'S API KEY' prompt got me confused

rohitpaulk · 2016-01-21T18:29:37Z

MassPay done and POSTed back to Gratipay for 45 users.

rohitpaulk · 2016-01-21T18:30:56Z

Shuffling escrow! How're we going to deal with permissions here, @whit537?

chadwhitacre · 2016-01-21T18:32:07Z

@rohitpaulk I tried to give you access to add funds. You hitting a roadblock?

chadwhitacre · 2016-01-21T18:32:59Z

Nah, this makes sense... The sudden 'WHERE IS GRATIPAY'S API KEY' prompt got me confused

Hopefully addressed in gratipay/gratipay.com@5521d9d?

rohitpaulk · 2016-01-21T18:35:00Z

Our paypal balance is $8,914.16, and the MassPay amount was $1,197.84.

1197.84 * 5 is roughly $6k. So no shuffling required, I guess?

rohitpaulk · 2016-01-21T18:35:49Z

You hitting a roadblock?

Ah, no - silly me I thought that we had to login to New Alliance to send money :P

chadwhitacre · 2016-01-21T18:36:15Z

@rohitpaulk I guess not. We might want to review the X * 5 guideline, but given that we're so stable week to week right now it's probably fine.

chadwhitacre · 2016-01-21T18:36:26Z

Ah, no - silly me I thought that we had to login to New Alliance to send money :P

:-)

rohitpaulk · 2016-01-21T18:39:29Z

Alright then, I guess this ticket is ready to be closed.

rohitpaulk · 2016-01-21T18:39:41Z

I was struggling to write a SELECT statement when I started hacking on Gratipay - This journey has been fun :)

chadwhitacre · 2016-01-21T18:42:36Z

I was struggling to write a SELECT statement when I started hacking on Gratipay - This journey has been fun :)

You, sir, rock! 💃 🚀 🎸 🎲 ✈️ ✨ 💖

rohitpaulk · 2016-01-21T18:43:59Z

!m @whit537

Changaco · 2016-01-21T18:57:35Z

You, sir, rock!

I second that. :-)

rohitpaulk · 2016-01-22T08:00:00Z

Nice to hear :)

chadwhitacre mentioned this issue Jan 21, 2016

delegate payday #467

Closed

chadwhitacre mentioned this issue Jan 21, 2016

tweak masspay scripts gratipay/gratipay.com#3901

Merged

rohitpaulk closed this as completed Jan 21, 2016

chadwhitacre mentioned this issue Jan 21, 2016

Radar 42 #472

Closed

chadwhitacre mentioned this issue Jan 26, 2016

Radar 43 #479

Closed

rohitpaulk mentioned this issue Jan 28, 2016

run Gratipay 191 #485

Closed

chadwhitacre mentioned this issue Feb 18, 2016

run Gratipay 194 #508

Closed

run Gratipay 190 #477

run Gratipay 190 #477

Comments

rohitpaulk commented Jan 21, 2016

rohitpaulk commented Jan 21, 2016

rohitpaulk commented Jan 21, 2016

rohitpaulk commented Jan 21, 2016

rohitpaulk commented Jan 21, 2016

rohitpaulk commented Jan 21, 2016

rohitpaulk commented Jan 21, 2016

chadwhitacre commented Jan 21, 2016

rohitpaulk commented Jan 21, 2016

chadwhitacre commented Jan 21, 2016

rohitpaulk commented Jan 21, 2016

chadwhitacre commented Jan 21, 2016

rohitpaulk commented Jan 21, 2016

rohitpaulk commented Jan 21, 2016

chadwhitacre commented Jan 21, 2016

rohitpaulk commented Jan 21, 2016

rohitpaulk commented Jan 21, 2016

chadwhitacre commented Jan 21, 2016

chadwhitacre commented Jan 21, 2016

chadwhitacre commented Jan 21, 2016

chadwhitacre commented Jan 21, 2016

chadwhitacre commented Jan 21, 2016

chadwhitacre commented Jan 21, 2016

rohitpaulk commented Jan 21, 2016

chadwhitacre commented Jan 21, 2016

rohitpaulk commented Jan 21, 2016

chadwhitacre commented Jan 21, 2016

rohitpaulk commented Jan 21, 2016

chadwhitacre commented Jan 21, 2016

chadwhitacre commented Jan 21, 2016

rohitpaulk commented Jan 21, 2016

chadwhitacre commented Jan 21, 2016

chadwhitacre commented Jan 21, 2016

rohitpaulk commented Jan 21, 2016

rohitpaulk commented Jan 21, 2016

chadwhitacre commented Jan 21, 2016

chadwhitacre commented Jan 21, 2016

rohitpaulk commented Jan 21, 2016

chadwhitacre commented Jan 21, 2016

rohitpaulk commented Jan 21, 2016

rohitpaulk commented Jan 21, 2016

rohitpaulk commented Jan 21, 2016

chadwhitacre commented Jan 21, 2016

chadwhitacre commented Jan 21, 2016

rohitpaulk commented Jan 21, 2016

rohitpaulk commented Jan 21, 2016

chadwhitacre commented Jan 21, 2016

chadwhitacre commented Jan 21, 2016

rohitpaulk commented Jan 21, 2016

rohitpaulk commented Jan 21, 2016

chadwhitacre commented Jan 21, 2016

rohitpaulk commented Jan 21, 2016

Changaco commented Jan 21, 2016

rohitpaulk commented Jan 22, 2016