Unable to Export Project with Word

[wyoung]

About a week ago I had an issue where every time I attempted to export a project, the job would fail.  This project had been previously exported using the same template and nothing had changed.  Restarting the services with "god restart" solved the issue, whatever it was, but now I'm having the same problem.  The error output from Resque is this.  Any idea what might be the problem?:

ActiveRecord::StatementInvalid

Error

Mysql2::Error: MySQL server has gone away: SHOW FULL FIELDS FROM `projects`

/opt/dradispro/dradispro/shared/bundle/ruby/2.0.0/gems/activerecord-3.2.16/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:245:in `query'
/opt/dradispro/dradispro/shared/bundle/ruby/2.0.0/gems/activerecord-3.2.16/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:245:in `block in execute'
/opt/dradispro/dradispro/shared/bundle/ruby/2.0.0/gems/activerecord-3.2.16/lib/active_record/connection_adapters/abstract_adapter.rb:280:in `block in log'
/opt/dradispro/dradispro/shared/bundle/ruby/2.0.0/gems/activesupport-3.2.16/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
/opt/dradispro/dradispro/shared/bundle/ruby/2.0.0/gems/activerecord-3.2.16/lib/active_record/connection_adapters/abstract_adapter.rb:275:in `log'
/opt/dradispro/dradispro/shared/bundle/ruby/2.0.0/gems/activerecord-3.2.16/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:245:in `execute'
/opt/dradispro/dradispro/shared/bundle/ruby/2.0.0/gems/activerecord-3.2.16/lib/active_record/connection_adapters/mysql2_adapter.rb:213:in `execute'
/opt/dradispro/dradispro/shared/bundle/ruby/2.0.0/gems/activerecord-3.2.16/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:259:in `execute_and_free'
/opt/dradispro/dradispro/shared/bundle/ruby/2.0.0/gems/activerecord-3.2.16/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:426:in `columns'
/opt/dradispro/dradispro/shared/bundle/ruby/2.0.0/gems/activerecord-3.2.16/lib/active_record/connection_adapters/schema_cache.rb:12:in `block in initialize'
/opt/dradispro/dradispro/shared/bundle/ruby/2.0.0/gems/activerecord-3.2.16/lib/active_record/model_schema.rb:229:in `yield'
/opt/dradispro/dradispro/shared/bundle/ruby/2.0.0/gems/activerecord-3.2.16/lib/active_record/model_schema.rb:229:in `columns'
/opt/dradispro/dradispro/shared/bundle/ruby/2.0.0/gems/activerecord-3.2.16/lib/active_record/model_schema.rb:238:in `columns_hash'
/opt/dradispro/dradispro/shared/bundle/ruby/2.0.0/gems/activerecord-3.2.16/lib/active_record/relation/delegation.rb:7:in `columns_hash'
/opt/dradispro/dradispro/shared/bundle/ruby/2.0.0/gems/activerecord-3.2.16/lib/active_record/relation/finder_methods.rb:334:in `find_one'
/opt/dradispro/dradispro/shared/bundle/ruby/2.0.0/gems/activerecord-3.2.16/lib/active_record/relation/finder_methods.rb:315:in `find_with_ids'
/opt/dradispro/dradispro/shared/bundle/ruby/2.0.0/gems/activerecord-3.2.16/lib/active_record/relation/finder_methods.rb:107:in `find'
/opt/dradispro/dradispro/shared/bundle/ruby/2.0.0/gems/activerecord-3.2.16/lib/active_record/querying.rb:5:in `find'
/opt/dradispro/dradispro/releases/20140515075558/app/workers/report_processor.rb:27:in `perform'
/opt/dradispro/dradispro/shared/bundle/ruby/2.0.0/gems/resque-status-0.4.2/lib/resque/plugins/status.rb:161:in `safe_perform!'
/opt/dradispro/dradispro/shared/bundle/ruby/2.0.0/gems/resque-status-0.4.2/lib/resque/plugins/status.rb:137:in `perform'

[Daniel Martin]

Hi Will,

This error seems to be similar to what Dimitry described here:

https://github.com/securityroots/dradispro-tracker/issues/147

Can you see if the fix suggested works for your case?

HTH,
Daniel

> --
> You received this message because you are subscribed to the Google Groups "Dradis Pro users" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to dradis-pro+...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.

—
Morris's three golden rules of computer security:
do not own a computer;
do not power it on;
and do not use one

[wyoung]

That did the trick, thanks!