Which MySQL driver are you using? The one built into Rails or the .gem one? Try swapping for the other one.
Scott On 7/11/06, Ian Holsman <[EMAIL PROTECTED]> wrote: > > ok.. I added it, > but I still have the same problem. > I don't think it is a timeout issue, as it happens straight after I launch > mongrel (or WEBBrick). > i'm thinking its a SQL issue. > > > On 12/07/2006, at 2:09 PM, Steve Longdo wrote: > I would guess in the environment.rb, add the line above: > ActionMailer::Base.default_charset = 'utf-8' > > Actually anywhere you put it in there it should get picked up. You might > cross check with the mongrel mailing list to see what they recommend. > > -Steve > http://www.stevelongdo.com > > On 7/11/06, Ian Holsman <[EMAIL PROTECTED] > wrote: > > > > > > nope. > > where do I put that ? > > > > > > > > > > On 12/07/2006, at 1:21 PM, Steve Longdo wrote: > > > > Do you have ActiveRecord MySQL timeout setup for mongrel? > > > > http://mongrel.rubyforge.org/faq.html > > > > From the FAQ: > > > > Q: Mongrel stops working if it's left alone for a long time. > > > > If you find that Mongrel stops working after a long idle time and you're > using MySQL then you're hitting a bug in the MySQL driver that doesn't > properly timeout connections. What happens is the MySQL server side of the > connection times out and closes, but the MySQL client doesn't detect this > and just sits there. > > > > What you have to do is set: ActiveRecord::Base.verification_timeout > > = 14400 > > > > > > Or to any value that is lower than the MySQL server's interactive_timeout > setting. This will make sure that ActiveRecord checks the connection often > enough to reset the connection. > > > > > > On 7/11/06, Ian Holsman <[EMAIL PROTECTED] > wrote: > > > Hi guys. > > > I'm on the latest SVN trunk (1123) and using mysql 5.0.19 . > > > > > > I'm not sure what is going on.. as I just moved hosting providers and > > > not if it is that or typo. > > > > > > regards > > > Ian > > > > > > ActiveRecord::StatementInvalid (Mysql::Error: Lost connection to > > > MySQL server during query: UPDATE sessions SET `sessid` = > > > '6b08673361b2d7cd5780f3593d3e592a', `data` = > > > > 'BAh7CDoOcmV0dXJuX3RvMDoJdXNlcm86CVVzZXIGOhBAYXR0cmlidXRlc3sQ > > > > \nIhZub3RpZnlfdmlhX2phYmJlciIGMCIJbmFtZSIQSWFuIEhvbHNtYW4iHW5v > > > > \ndGlmeV93YXRjaF9teV9hcnRpY2xlczAiFW5vdGlmeV92aWFfZW1haWwiBjAi > > > > \nB2lkIgYyIgtqYWJiZXIiFmtyeXRvbkBqYWJiZXIub3JnIhdub3RpZnlfb25f > > > > \nY29tbWVudHMiBjAiDXBhc3N3b3JkIi1hYTU5ZjMzMTUwZTRmMzhkMjM5ZDE0 > > > > \nY2MwNjA4NzRmNWE2ZWI3NDQ3Igpsb2dpbiIJaWFuaCIbbm90aWZ5X29uX25l > > > > \nd19hcnRpY2xlcyIGMCIKZW1haWwiACIKZmxhc2hJQzonQWN0aW9uQ29udHJv > > > \nbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA==\n', > `updated_at` = > > > '2006-07-11 21:35:40' WHERE id = 64708): > > > > /vendor/rails/activerecord/lib/active_record/connection_adapters/ > > > abstract_adapter.rb:120:in `log' > > > > /vendor/rails/activerecord/lib/active_record/connection_adapters/ > > > mysql_adapter.rb:184:in `execute' > > > > /vendor/rails/activerecord/lib/active_record/connection_adapters/ > > > mysql_adapter.rb:199:in `update' > > > > /vendor/rails/activerecord/lib/active_record/base.rb:1723:in > > > `update_without_lock' > > > > /vendor/rails/activerecord/lib/active_record/locking.rb:33:in > > > `update_without_callbacks' > > > > /vendor/rails/activerecord/lib/active_record/callbacks.rb:274:in > > > `update_without_timestamps' > > > > /vendor/rails/activerecord/lib/active_record/timestamp.rb:39:in > > > `update' > > > > /vendor/rails/activerecord/lib/active_record/base.rb:1718:in > > > `create_or_update_without_callbacks' > > > > /vendor/rails/activerecord/lib/active_record/callbacks.rb:249:in > > > `create_or_update' > > > > /vendor/rails/activerecord/lib/active_record/base.rb:1392:in > > > `save_without_validation' > > > > /vendor/rails/activerecord/lib/active_record/validations.rb: > > > 724:in `save_without_transactions' > > > > /vendor/rails/activerecord/lib/active_record/transactions.rb: > > > 126:in `save' > > > > /vendor/rails/activerecord/lib/active_record/connection_adapters/ > > > abstract/database_statements.rb:51:in `transaction' > > > > /vendor/rails/activerecord/lib/active_record/transactions.rb: > > > 91:in `transaction' > > > > /vendor/rails/activerecord/lib/active_record/transactions.rb: > > > 118:in `transaction' > > > > /vendor/rails/activerecord/lib/active_record/transactions.rb: > > > 126:in `save' > > > > /vendor/rails/actionpack/lib/action_controller/session/ > > > active_record_store.rb:307:in `update' > > > > /vendor/rails/activerecord/lib/active_record/base.rb:794:in > > > `silence' > > > > /vendor/rails/actionpack/lib/action_controller/session/ > > > active_record_store.rb:307:in `update' > > > > /vendor/rails/actionpack/lib/action_controller/session/ > > > active_record_store.rb:314:in `close' > > > /usr/local/lib/ruby/1.8/cgi/session.rb:330:in > `close' > > > > /vendor/rails/actionpack/lib/action_controller/base.rb:984:in > > > `close_session' > > > > /vendor/rails/actionpack/lib/action_controller/base.rb:1026:in > > > `process_cleanup_without_flash' > > > > /vendor/rails/actionpack/lib/action_controller/flash.rb:147:in > > > `process_cleanup_without_filters' > > > > /vendor/rails/actionpack/lib/action_controller/filters.rb:439:in > > > `process_cleanup_without_session_management_support' > > > /vendor/rails/actionpack/lib/action_controller/ > > > session_management.rb:126:in > `process_cleanup_without_components' > > > > /vendor/rails/actionpack/lib/action_controller/components.rb: > > > 182:in `process_cleanup' > > > > /vendor/rails/actionpack/lib/action_controller/base.rb:385:in > > > `process_without_filters' > > > > /vendor/rails/actionpack/lib/action_controller/filters.rb:377:in > > > `process_without_session_management_support' > > > /vendor/rails/actionpack/lib/action_controller/ > > > session_management.rb:117:in `process' > > > /vendor/rails/railties/lib/dispatcher.rb:38:in > `dispatch' > > > /usr/local/lib/ruby/gems/1.8/gems/mongrel- > 0.3.13.3/lib/mongrel/ > > > rails.rb:73:in `process' > > > /usr/local/lib/ruby/gems/1.8/gems/mongrel- > 0.3.13.3/lib/ > > > mongrel.rb:551:in `process_client' > > > /usr/local/lib/ruby/gems/1.8/gems/mongrel- > 0.3.13.3/lib/ > > > mongrel.rb:550:in `process_client' > > > > /usr/local/lib/ruby/gems/1.8/gems/mongrel-0.3.13.3/lib/ > > > mongrel.rb :636:in `run' > > > /usr/local/lib/ruby/gems/1.8/gems/mongrel- > 0.3.13.3/lib/ > > > mongrel.rb:636:in `run' > > > /usr/local/lib/ruby/gems/1.8/gems/mongrel- > 0.3.13.3/lib/ > > > mongrel.rb:625:in `run' > > > /usr/local/lib/ruby/gems/1.8/gems/mongrel- > 0.3.13.3/lib/ > > > mongrel.rb:956:in `run' > > > > /usr/local/lib/ruby/gems/1.8/gems/mongrel-0.3.13.3/lib/ > > > mongrel.rb :955:in `run' > > > /usr/local/lib/ruby/gems/1.8/gems/mongrel- > 0.3.13.3/bin/ > > > mongrel_rails:127:in `run' > > > /usr/local/lib/ruby/gems/1.8/gems/mongrel- > 0.3.13.3/lib/mongrel/ > > > command.rb:199:in `run' > > > /usr/local/lib/ruby/gems/1.8/gems/mongrel- > 0.3.13.3/bin/ > > > mongrel_rails:235 > > > /usr/local/bin/mongrel_rails:18 > > > > > > _______________________________________________ > > > Typo-list mailing list > > > [email protected] > > > http://rubyforge.org/mailman/listinfo/typo-list > > > > > > > > > _______________________________________________ > > Typo-list mailing list > > [email protected] > > http://rubyforge.org/mailman/listinfo/typo-list > > > > > > _______________________________________________ > > Typo-list mailing list > > [email protected] > > http://rubyforge.org/mailman/listinfo/typo-list > > > > > > _______________________________________________ > Typo-list mailing list > [email protected] > http://rubyforge.org/mailman/listinfo/typo-list > > _______________________________________________ > Typo-list mailing list > [email protected] > http://rubyforge.org/mailman/listinfo/typo-list > > _______________________________________________ Typo-list mailing list [email protected] http://rubyforge.org/mailman/listinfo/typo-list
