search

igrigorik / vimgolf

Real Vim ninjas count every keystroke - do you?
http://www.vimgolf.com/
MIT License
679 stars 65 forks source link

Some challenges failing to load #306

Closed braxler closed 3 years ago

braxler commented 3 years ago

Some challenges are failing to load. Only pattern I've noticed is that the higher the entries the more likely it is to fail.

One example: http://www.vimgolf.com/challenges/5192f96ad8df110002000002 "We're sorry, but something went wrong."

Hettomei commented 3 years ago

Currently Threre is a lot of 'Sort exceeded memory limit' error :

your challenge return : 

2021-01-29T21:25:41.655963+00:00 app[web.1]: Started GET "/challenges/5192f96ad8df110002000002" for 162.158.114.121 at 2021-01-29 21:25:41 +0000
2021-01-29T21:25:41.658176+00:00 app[web.1]: I, [2021-01-29T21:25:41.658085 #12]  INFO -- : Processing by ChallengesController#show as HTML
2021-01-29T21:25:41.658294+00:00 app[web.1]: I, [2021-01-29T21:25:41.658227 #12]  INFO -- :   Parameters: {"id"=>"5192f96ad8df110002000002"}
2021-01-29T21:25:41.693017+00:00 app[web.1]: Rendering challenges/show.erb within layouts/application
2021-01-29T21:25:41.739889+00:00 app[web.1]: Rendered shared/_challenge_description.erb (0.3ms)
2021-01-29T21:25:41.789459+00:00 app[web.1]: Rendered challenges/show.erb within layouts/application (96.2ms)
2021-01-29T21:25:41.789805+00:00 app[web.1]: I, [2021-01-29T21:25:41.789709 #12]  INFO -- : Completed 500 Internal Server Error in 131ms
2021-01-29T21:25:41.792171+00:00 app[web.1]:
2021-01-29T21:25:41.792248+00:00 app[web.1]: ActionView::Template::Error (Sort exceeded memory limit of 33554432 bytes, but did not opt in to external sorting. (292)):
2021-01-29T21:25:41.792516+00:00 app[web.1]: 11:     <p>Check out <a href="/about#resources"> these helpful resources</a> to improve your Vim skills... <em>Game on.</em></p>
2021-01-29T21:25:41.792517+00:00 app[web.1]: 12:
2021-01-29T21:25:41.792519+00:00 app[web.1]: 13: <% if !current_user %>
2021-01-29T21:25:41.792520+00:00 app[web.1]: 14:     <div class="note clearfix">Unlock <b><%= @submissions.count_remaining %></b> remaining solutions by <b><%= link_to "signing in", "/auth/twitter?x_auth_access_type=read&use_authorize=true" %></b> and submitting your own entry</div>
2021-01-29T21:25:41.792520+00:00 app[web.1]: 15:   <% elsif @submissions.count_remaining > 0 %>
2021-01-29T21:25:41.792521+00:00 app[web.1]: 16:     <div class="note clearfix">Unlock <b><%= @submissions.count_remaining %></b> remaining solutions by submitting a higher ranked entry</div>
2021-01-29T21:25:41.792522+00:00 app[web.1]: 17: <% end %>
2021-01-29T21:25:41.792583+00:00 app[web.1]:
2021-01-29T21:25:41.792643+00:00 app[web.1]: app/repositories/repository_challenge.rb:216:in `first'
2021-01-29T21:25:41.792644+00:00 app[web.1]: app/repositories/repository_challenge.rb:216:in `worst_score'
2021-01-29T21:25:41.792645+00:00 app[web.1]: app/services/submissions.rb:65:in `worst_score'
2021-01-29T21:25:41.792645+00:00 app[web.1]: app/services/submissions.rb:46:in `visible_score'
2021-01-29T21:25:41.792646+00:00 app[web.1]: app/services/submissions.rb:99:in `count_remaining'
2021-01-29T21:25:41.792646+00:00 app[web.1]: app/views/challenges/show.erb:14:in `_app_views_challenges_show_erb__3371893031817762190_41338200'
2021-01-29T21:25:41.793841+00:00 app[web.1]: source=rack-timeout id=174c39a3-3d36-4a73-8122-245db46ddcad wait=9ms timeout=15000ms service=139ms state=completed
2021-01-29T21:25:41.809957+00:00 heroku[router]: at=info method=GET path="/challenges/5192f96ad8df110002000002" host=www.vimgolf.com request_id=174c39a3-3d36-4a73-8122-245db46ddcad fwd="2a01:e0a:52a:15a0:6eb2:9b7f:d6b:fdb3,162.158.114.121" dyno=web.1 connect=0ms service=161ms status=500 bytes=956 protocol=http

another page with error is /challenge/challenge_id/user/username

2021-01-29T21:20:19.670882+00:00 heroku[router]: at=info method=GET path="/challenges/5f0f5fbe280fbf000c233304/user/bittfaulk" host=www.vimgolf.com request_id=60c964e1-23d0-405d-8be5-d4ec53f76d25 fwd="64.62.252.174,172.69.22.40" dyno=web.1 connect=0ms service=385ms status=200 bytes=7160 protocol=http
2021-01-29T21:20:19.734896+00:00 app[web.1]: Rendered shared/_submissions.erb (45.9ms)
2021-01-29T21:20:19.849004+00:00 app[web.1]: Rendered shared/_challenge_credits.erb (68.4ms)
2021-01-29T21:20:19.849093+00:00 app[web.1]: Rendered challenges/user.erb within layouts/application (243.8ms)
2021-01-29T21:20:19.849343+00:00 app[web.1]: I, [2021-01-29T21:20:19.849249 #9]  INFO -- : Completed 500 Internal Server Error in 316ms
2021-01-29T21:20:19.850935+00:00 app[web.1]: 
2021-01-29T21:20:19.851024+00:00 app[web.1]: ActionView::Template::Error (Sort exceeded memory limit of 33554432 bytes, but did not opt in to external sorting. (292)):
2021-01-29T21:20:19.851187+00:00 app[web.1]: 11: </h5>
2021-01-29T21:20:19.851187+00:00 app[web.1]: 12:
2021-01-29T21:20:19.851188+00:00 app[web.1]: 13: <h2 style="padding-bottom:1em; border-bottom: 1px dotted;">
2021-01-29T21:20:19.851195+00:00 app[web.1]: 14:     <b class="stat"><%= show_challenge.count_uniq_users %></b> active golfers, <b class="stat"><%= show_challenge.count_entries %></b> entries
2021-01-29T21:20:19.851195+00:00 app[web.1]: 15: </h2>
2021-01-29T21:20:19.851243+00:00 app[web.1]: 
2021-01-29T21:20:19.851305+00:00 app[web.1]: app/repositories/repository_challenge.rb:195:in `first'
2021-01-29T21:20:19.851305+00:00 app[web.1]: app/repositories/repository_challenge.rb:195:in `sum_lines'
2021-01-29T21:20:19.851306+00:00 app[web.1]: app/repositories/repository_challenge.rb:271:in `count_uniq_users'
2021-01-29T21:20:19.851306+00:00 app[web.1]: app/services/show_challenge.rb:35:in `count_uniq_users'
2021-01-29T21:20:19.851307+00:00 app[web.1]: app/views/shared/_challenge_credits.erb:14:in `_app_views_shared__challenge_credits_erb__1786572738972739987_31527600'
2021-01-29T21:20:19.851307+00:00 app[web.1]: app/views/challenges/user.erb:26:in `_app_views_challenges_user_erb___3763864613171643667_37964340'
nazzacode commented 3 years ago

Also experiencing this. Almost all challenges unplayable.

AckslD commented 3 years ago

Me too

tobiabocchi commented 3 years ago

Same problem here

Hettomei commented 3 years ago

@igrigorik can I do some revert and restart heroku ?

Hettomei commented 3 years ago

@igrigorik I deployed an old commit (see https://github.com/igrigorik/vimgolf/issues/307#issuecomment-782408973) and got the same error. (and deployed back to current master)

I don't have time to dig in mongodb's behavior.

igrigorik commented 3 years ago

It's suspect that this started recently.. 🤔

countvajhula commented 3 years ago

@igrigorik I've been checking the site over the last few weeks and haven't been able to access the challenges. I made a mention of this in an unrelated post in the reddit Vim community, hope I'm not overstepping there (and if so, I'll gladly remove the mention). But if you guys do need help, it might not be a bad idea to continue the conversation.

Hettomei commented 3 years ago

@countvajhula

We need help

More technical details here https://github.com/igrigorik/vimgolf/issues/307

But we need @igrigorik to give us access to mongodb logs.

countvajhula commented 3 years ago

@Hettomei Ok, I've updated the post with a link to that ticket. If you guys keep it updated with details there's a chance someone can jump in. I'd also try IRC channels for help, #mongodb or #heroku maybe?

gayatrisridhar commented 3 years ago

None of the challenges are working? Is this happening with everyone?

Hettomei commented 3 years ago

@gayatrisridhar

It is happenning for everyone

It looks like challenge with roughly less than 500 entries is ok

If you can help, more details at https://github.com/igrigorik/vimgolf/issues/307

It will take time to be fixed : the only idea we have is to move from mongodb to postgresql. But it is an hard work.

filbranden commented 3 years ago

Fixed after migration to Postgres (#298).