Hi, I have run into a problem with long sleeps in my processes. I have several sleeps in my processes from several minutes up to 12 hours. In certain process instances the 12h sleeps result in the exception below. This is when the scheduler gets a trigger and needs to wake up the process. Because of this error the process instance hangs and won't continue.
Strangely sometimes it works. I use OpenWFE::Extras::DbPersistedEngine in a two-instance load balanced mongrel setup. I don't have any other issues with the database. trigger() caught exception Mysql::Error: MySQL server has gone away: DELETE FROM expressions WHERE (fei = '(fei 0.9.17 engine field:__definition the_leader_in_me 0.9 20080424-juhizagepo sleep 0.0.14)') /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.6/lib/active_record/ connection_adapters/abstract_adapter.rb:128:in `log' /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.6/lib/active_record/ connection_adapters/mysql_adapter.rb:243:in `execute' /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.6/lib/active_record/ connection_adapters/mysql_adapter.rb:258:in `update' /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.6/lib/active_record/ connection_adapters/abstract/database_statements.rb:47:in `delete' /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.6/lib/active_record/ base.rb:513:in `delete_all' /home/j/ja/jai.ejai.com/current/config/../vendor/gems/openwferu- extras-0.9.17/lib/openwfe/extras/expool/dbexpstorage.rb:168:in `delete' /usr/lib/ruby/1.8/monitor.rb:242:in `synchronize' /home/j/ja/jai.ejai.com/current/config/../vendor/gems/openwferu- extras-0.9.17/lib/openwfe/extras/expool/dbexpstorage.rb:167:in `delete' /home/j/ja/jai.ejai.com/current/config/../vendor/gems/openwferu-0.9.17/ lib/openwfe/expool/expstorage.rb:68:in `observe_expool' /home/j/ja/jai.ejai.com/current/config/../vendor/gems/openwferu-0.9.17/ lib/openwfe/util/observable.rb:135:in `call' /home/j/ja/jai.ejai.com/current/config/../vendor/gems/openwferu-0.9.17/ lib/openwfe/util/observable.rb:135:in `do_notify' /home/j/ja/jai.ejai.com/current/config/../vendor/gems/openwferu-0.9.17/ lib/openwfe/util/observable.rb:134:in `each' /home/j/ja/jai.ejai.com/current/config/../vendor/gems/openwferu-0.9.17/ lib/openwfe/util/observable.rb:134:in `do_notify' /home/j/ja/jai.ejai.com/current/config/../vendor/gems/openwferu-0.9.17/ lib/openwfe/util/observable.rb:96:in `onotify' /home/j/ja/jai.ejai.com/current/config/../vendor/gems/openwferu-0.9.17/ lib/openwfe/expool/expressionpool.rb:618:in `remove' /home/j/ja/jai.ejai.com/current/config/../vendor/gems/openwferu-0.9.17/ lib/openwfe/expool/expressionpool.rb:461:in `reply_to_parent' /home/j/ja/jai.ejai.com/current/config/../vendor/gems/openwferu-0.9.17/ lib/openwfe/expressions/flowexpression.rb:181:in `reply_to_parent' /home/j/ja/jai.ejai.com/current/config/../vendor/gems/openwferu-0.9.17/ lib/openwfe/expressions/fe_sleep.rb:128:in `trigger' /home/j/ja/jai.ejai.com/current/config/../vendor/gems/rufus- scheduler-1.0.5/lib/rufus/scheduler.rb:802:in `to_block' /home/j/ja/jai.ejai.com/current/config/../vendor/gems/rufus- scheduler-1.0.5/lib/rufus/scheduler.rb:1131:in `call' /home/j/ja/jai.ejai.com/current/config/../vendor/gems/rufus- scheduler-1.0.5/lib/rufus/scheduler.rb:1131:in `trigger' /home/j/ja/jai.ejai.com/current/config/../vendor/gems/rufus- scheduler-1.0.5/lib/rufus/scheduler.rb:976:in `trigger' /home/j/ja/jai.ejai.com/current/config/../vendor/gems/rufus- scheduler-1.0.5/lib/rufus/scheduler.rb:973:in `initialize' /home/j/ja/jai.ejai.com/current/config/../vendor/gems/rufus- scheduler-1.0.5/lib/rufus/scheduler.rb:973:in `new' /home/j/ja/jai.ejai.com/current/config/../vendor/gems/rufus- scheduler-1.0.5/lib/rufus/scheduler.rb:973:in `trigger' /home/j/ja/jai.ejai.com/current/config/../vendor/gems/rufus- scheduler-1.0.5/lib/rufus/scheduler.rb:962:in `step_trigger' /home/j/ja/jai.ejai.com/current/config/../vendor/gems/rufus- scheduler-1.0.5/lib/rufus/scheduler.rb:950:in `loop' /home/j/ja/jai.ejai.com/current/config/../vendor/gems/rufus- scheduler-1.0.5/lib/rufus/scheduler.rb:950:in `step_trigger' /home/j/ja/jai.ejai.com/current/config/../vendor/gems/rufus- scheduler-1.0.5/lib/rufus/scheduler.rb:850:in `step' /home/j/ja/jai.ejai.com/current/config/../vendor/gems/rufus- scheduler-1.0.5/lib/rufus/scheduler.rb:320:in `start' /home/j/ja/jai.ejai.com/current/config/../vendor/gems/rufus- scheduler-1.0.5/lib/rufus/scheduler.rb:314:in `loop' /home/j/ja/jai.ejai.com/current/config/../vendor/gems/rufus- scheduler-1.0.5/lib/rufus/scheduler.rb:314:in `start' /home/j/ja/jai.ejai.com/current/config/../vendor/gems/rufus- scheduler-1.0.5/lib/rufus/scheduler.rb:304:in `initialize' /home/j/ja/jai.ejai.com/current/config/../vendor/gems/rufus- scheduler-1.0.5/lib/rufus/scheduler.rb:304:in `new' /home/j/ja/jai.ejai.com/current/config/../vendor/gems/rufus- scheduler-1.0.5/lib/rufus/scheduler.rb:304:in `start' /home/j/ja/jai.ejai.com/current/config/../vendor/gems/openwferu-0.9.17/ lib/openwfe/engine/engine.rb:887:in `build_scheduler' /home/j/ja/jai.ejai.com/current/config/../vendor/gems/openwferu-0.9.17/ lib/openwfe/engine/engine.rb:100:in `initialize' /home/j/ja/jai.ejai.com/releases/20080424120616/config/ openwferu_engine.rb:45:in `new' /home/j/ja/jai.ejai.com/releases/20080424120616/config/ openwferu_engine.rb:45 /usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:27:in `gem_original_require' /usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:27:in `require' /usr/lib/ruby/gems/1.8/gems/activesupport-1.4.4/lib/active_support/ dependencies.rb:495:in `require' /usr/lib/ruby/gems/1.8/gems/activesupport-1.4.4/lib/active_support/ dependencies.rb:342:in `new_constants_in' /usr/lib/ruby/gems/1.8/gems/activesupport-1.4.4/lib/active_support/ dependencies.rb:495:in `require' /home/j/ja/jai.ejai.com/current/config/environment.rb:81 /usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:27:in `gem_original_require' /usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:27:in `require' /usr/lib/ruby/gems/1.8/gems/mongrel-1.1.3/bin/../lib/mongrel/rails.rb: 147:in `rails' /usr/lib/ruby/gems/1.8/gems/mongrel-1.1.3/bin/mongrel_rails:121:in `cloaker_' /usr/lib/ruby/gems/1.8/gems/mongrel-1.1.3/bin/../lib/mongrel/ configurator.rb:152:in `call' /usr/lib/ruby/gems/1.8/gems/mongrel-1.1.3/bin/../lib/mongrel/ configurator.rb:152:in `listener' /usr/lib/ruby/gems/1.8/gems/mongrel-1.1.3/bin/mongrel_rails:107:in `cloaker_' /usr/lib/ruby/gems/1.8/gems/mongrel-1.1.3/bin/../lib/mongrel/ configurator.rb:50:in `call' /usr/lib/ruby/gems/1.8/gems/mongrel-1.1.3/bin/../lib/mongrel/ configurator.rb:50:in `initialize' /usr/lib/ruby/gems/1.8/gems/mongrel-1.1.3/bin/mongrel_rails:84:in `new' /usr/lib/ruby/gems/1.8/gems/mongrel-1.1.3/bin/mongrel_rails:84:in `run' /usr/lib/ruby/gems/1.8/gems/mongrel-1.1.3/bin/../lib/mongrel/ command.rb:212:in `run' /usr/lib/ruby/gems/1.8/gems/mongrel-1.1.3/bin/mongrel_rails:289 /usr/bin/mongrel_rails:16:in `load' /usr/bin/mongrel_rails:16 Anyone seen these kind of errors before? Anyone ideas why just this specific operation might result in Mysql errors? Thanks in advance for any help, Maarten --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "OpenWFEru users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/openwferu-users?hl=en -~----------~----~----~----~------~----~------~--~---
