Ruby on Rails

Did you check mysql config on server?

On Jun 30, 5:12 am, fischer1121 <bfischer1...@gmail.com> wrote:
> Hi all,
>
> I am getting the following error in the middle of a long-running
> process: "Mysql::Error: Lost connection to MySQL server during
> query:..."
> When rescued and retried, it throws the next error: "Mysql::Error:
> MySQL server has gone away"
>
> (1) The query is not long and (2) the process does not last longer
> than 8 hours (it's < 15 minutes) or idle for a long period.
>
> I've tried: ActiveRecord::Base.allow_concurrency = true,
> ActiveRecord::Base.verification_timeout = 10, and
> ActiveRecord::Base.verify_active_connections!
>
> I can use (1) ActiveRecord::Base.connection_pool.with_connection or
> (2) ActiveRecord::Base.verify_active_connections! to fix it, but...
>
> when future queries search for data that was inserted previously in
> the process, it is no longer there. It seems like there's something
> wrapped around everything - tied to the connection - that prevents any
> writes from really persisting to the database until, I'm assuming, the
> process is complete.
>
> How do I fix the lost MySQL connections or at least make writes
> persist to the database mid-process so that when I open a new
> connection the records will be there?
>
> Any help is appreciated.
>
> Thanks,
>
> Blake

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.