I'm updating some data in my database, and running them through the
Heroku console since we have no direct database access.
I'm calling this like so: ActiveRecord::Base.connection.execute "MY
SQL COMMAND;"
The command takes about 5-10 minutes to run.
Every time I run it, it's causing the console to crash, with the
following message:
/var/lib/gems/1.8/gems/heroku-1.9.9/lib/heroku/client.rb:202:in
`console': undefined method `code' for nil:NilClass (NoMethodError)
from /var/lib/gems/1.8/gems/heroku-1.9.9/lib/heroku/commands/app.rb:
158:in `console_session'
from /var/lib/gems/1.8/gems/heroku-1.9.9/lib/heroku/commands/app.rb:
147:in `console'
from /var/lib/gems/1.8/gems/heroku-1.9.9/lib/heroku/command.rb:48:in
`send'
from /var/lib/gems/1.8/gems/heroku-1.9.9/lib/heroku/command.rb:48:in
`run_internal'
from /var/lib/gems/1.8/gems/heroku-1.9.9/lib/heroku/command.rb:20:in
`run'
from /var/lib/gems/1.8/gems/heroku-1.9.9/bin/heroku:13
from /var/lib/gems/1.8/bin/heroku:19:in `load'
from /var/lib/gems/1.8/bin/heroku:19
After that, apparently the command is continuing to run even though I
have no access to the console, as for about the runtime of my command,
the dyno continues to be completely tied up and non-responsive.
Afterwards, I can connect to the console again, and the data appears
upon first inspection to have been changed.
Has anyone else seen behavior like this? Did your data integrity turn
out okay in the end?
--
You received this message because you are subscribed to the Google Groups
"Heroku" group.
To post to this group, send email to her...@googlegroups.com.
To unsubscribe from this group, send email to
heroku+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/heroku?hl=en.
