Broken viz undefined method `scrollwheel' for nil:NilClass

[iriberri]

NoMethodError: undefined method `scrollwheel' for nil:NilClass
1
File "/home/ubuntu/www/production.cartodb.com/releases/20150420143525/app/models/visualization/vizjson.rb", line 34 in to_poro
2
File "/home/ubuntu/www/production.cartodb.com/releases/20150420143525/app/models/visualization/member.rb", line 626 in calculate_vizjson
3
File "/home/ubuntu/www/production.cartodb.com/releases/20150420143525/app/models/visualization/member.rb", line 353 in block in to_vizjson
4
File "/home/ubuntu/www/production.cartodb.com/releases/20150420143525/app/models/visualization/member.rb", line 634 in redis_cached
5
File "/home/ubuntu/www/production.cartodb.com/releases/20150420143525/app/models/visualization/member.rb", line 352 in to_vizjson
6
File "/home/ubuntu/www/production.cartodb.com/releases/20150420143525/app/controllers/api/json/visualizations_controller.rb", line 217 in vizjson2
... 6 non-project frames
13
File "/home/ubuntu/www/production.cartodb.com/releases/20150420143525/app/controllers/application_controller.rb", line 54 in wrap_in_profiler
... 68 non-project frames

SB/5128927

[Kartones]

Hi @Hayleyr: It will probably have to wait more days (or until I can squeeze a few minutes and fix it). If you feel it is important talk to @javisantana so he reprioritizes it higher.

[Hayleyr]

@javisantana Hi! You will see that @Kartones has suggested that perhaps I refer this issue to you! I am thinking that it should definitely get some attention.

[javisantana]

@Kartones yes, let's fix it

[rafatower]

There's also this trace:

ActionView::Template::Error: undefined method `public_values' for nil:NilClass
1 File "app/views/admin/visualizations/show.html.erb", line 18 in _app_views_admin_visualizations_show_html_erb__2081754932533754588_63344380
... 32 non-project frames
34 File "app/controllers/admin/visualizations_controller.rb", line 76 in show
... 6 non-project frames
41 File "app/controllers/application_controller.rb", line 54 in wrap_in_profiler
... 68 non-project frames

RB/5355

[rafatower]

The problem is that the visualization.map does not exist. It has a visualization.map_id with an uuid that is not found in DB. I don't know how it got to that situation.

[Kartones]

uhmmm then might be again from the problems we had with vis deletion breaking mid-way (after deleting the map, etc.). Not 100% sure but my guess as I bugfixed similar errors last week

[rafatower]

There's no way to recover the related table for that case automatically and I guess it's the same case for the other ~15 users affected. I will fix it manually for this particular case.

For the other cases I suggest to detect and delete the affected visualizations with a supervised rake task. They cannot be deleted manually from the new dashboard.

[rafatower]

As far as I can see the table the viz was based upon was deleted time ago, presumably around June'14 so there's no way to recover that visualization.

[Hayleyr]

@rafatower okay thanks very much for trying!

[rafatower]

I added a script to delete inconsistent visualizations, should it be needed, but I haven't deleted any in production. E.g:

$ RAILS_ENV=production bundle exec rake cartodb:vizs:delete_inconsistent['username']

viz.name = some_table_name
viz.type = table
viz.related_tables = []
viz.map_id = ef592a93-e1e6-4f74-958e-c2684d114fff
About to delete. Are you sure? (y/n)
n

viz.name = Some Viz Name
viz.type = derived
viz.related_tables = []
viz.map_id = 42571f0b-0ed4-4c18-ae5a-d3c9e5b91fff
About to delete. Are you sure? (y/n)
n

Closing this ticket.