Tâches cron en erreur (prolongate_services_expiration et send_mail_deadline)
Depuis la mise en prod de vendredi il y a deux tâches cron qui produisent une erreur chaque nuit :
Cron <ambre@cambium> /usr/local/bin/prolongate_services_expiration
rake aborted!
Don't know how to build task 'adminsys:prolongate_services_expired_date' (See the list of available tasks with `rake --tasks`)
(See full trace by running task with --trace)
et la deuxième :
Cron <ambre@cambium> /usr/local/bin/send_mail_deadline
rake aborted!
ActiveRecord::StatementInvalid: PG::UndefinedColumn: ERROR: column services.renewal_method does not exist
LINE 1: ...ROM "services" WHERE "services"."active" = $1 AND "services"...
^
: SELECT "services".* FROM "services" WHERE "services"."active" = $1 AND "services"."renewal_method" = 'on_demand' AND (expired_at <= '2019-12-27') AND
((expiration_notified_on <= '2019-12-30' OR expiration_notified_on IS NULL))
/srv/ambre/www/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.11/lib/active_record/connection_adapters/postgresql_adapter.rb:637:in `prepare'
/srv/ambre/www/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.11/lib/active_record/connection_adapters/postgresql_adapter.rb:637:in `prepare_statement'
/srv/ambre/www/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.11/lib/active_record/connection_adapters/postgresql_adapter.rb:596:in `exec_cache'
/srv/ambre/www/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.11/lib/active_record/connection_adapters/postgresql_adapter.rb:585:in `execute_and_clear'
/srv/ambre/www/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.11/lib/active_record/connection_adapters/postgresql/database_statements.rb:160:in `exec_query'
/srv/ambre/www/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.11/lib/active_record/connection_adapters/abstract/database_statements.rb:356:in `select'
/srv/ambre/www/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.11/lib/active_record/connection_adapters/abstract/database_statements.rb:32:in `select_all'
/srv/ambre/www/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.11/lib/active_record/connection_adapters/abstract/query_cache.rb:70:in `select_all'
/srv/ambre/www/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.11/lib/active_record/querying.rb:39:in `find_by_sql'
/srv/ambre/www/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.11/lib/active_record/relation.rb:639:in `exec_queries'
/srv/ambre/www/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.11/lib/active_record/relation.rb:515:in `load'
/srv/ambre/www/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.11/lib/active_record/relation.rb:243:in `to_a'
/srv/ambre/www/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.11/lib/active_record/relation/delegation.rb:46:in `each'
/srv/ambre/www/app/tasks/send_mail.rb:41:in `notify_service_expiration'
/srv/ambre/www/lib/tasks/send_mail.rake:18:in `block (2 levels) in <top (required)>'
Caused by:
PG::UndefinedColumn: ERROR: column services.renewal_method does not exist
LINE 1: ...ROM "services" WHERE "services"."active" = $1 AND "services"...
/srv/ambre/www/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.11/lib/active_record/connection_adapters/postgresql_adapter.rb:637:in `prepare'
/srv/ambre/www/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.11/lib/active_record/connection_adapters/postgresql_adapter.rb:637:in `prepare_statement'
/srv/ambre/www/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.11/lib/active_record/connection_adapters/postgresql_adapter.rb:596:in `exec_cache'
/srv/ambre/www/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.11/lib/active_record/connection_adapters/postgresql_adapter.rb:585:in `execute_and_clear'
/srv/ambre/www/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.11/lib/active_record/connection_adapters/postgresql/database_statements.rb:160:in `exec_query'
/srv/ambre/www/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.11/lib/active_record/connection_adapters/abstract/database_statements.rb:356:in `select'
/srv/ambre/www/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.11/lib/active_record/connection_adapters/abstract/database_statements.rb:32:in `select_all'
/srv/ambre/www/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.11/lib/active_record/connection_adapters/abstract/query_cache.rb:70:in `select_all'
/srv/ambre/www/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.11/lib/active_record/querying.rb:39:in `find_by_sql'
/srv/ambre/www/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.11/lib/active_record/relation.rb:639:in `exec_queries'
/srv/ambre/www/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.11/lib/active_record/relation.rb:515:in `load'
/srv/ambre/www/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.11/lib/active_record/relation.rb:243:in `to_a'
/srv/ambre/www/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.11/lib/active_record/relation/delegation.rb:46:in `each'
/srv/ambre/www/app/tasks/send_mail.rb:41:in `notify_service_expiration'
/srv/ambre/www/lib/tasks/send_mail.rake:18:in `block (2 levels) in <top (required)>'
Tasks: TOP => send_mail:notify_service_expiration
(See full trace by running task with --trace)