Boa tarde, apos a atualização do I-educar para 2.2.20, não consigo sincronizar o ano letivo 2020, e as turmas no i-diário, o no de 2019 abre normalmente.
Alguém está passando por esse problema?
Verificar os registros da tabela do i-Diario ‘teacher_discipline_classrooms’ ajuda a diagnosticar o problema
Boa noite Robson, segue o erro no momento da sincronização:
2020-03-17T01:10:06.432Z 35916 TID-owxe2yjd4 SynchronizerExecuterWorker JID-9fb95eea40ac65f261be5707 INFO: fail: 23.666 sec
2020-03-17T01:10:07.935Z 35916 TID-owxe2yjd4 WARN: {“context”:“Job raised exception”,“job”:{“class”:“SynchronizerExecuterWorker”,“args”:[{“klass”:“SpecificStepsSynchronizer”,“synchronization_id”:37,“worker_batch_id”:37,“entity_id”:5,“year”:“2020”,“unity_api_code”:“6,4,8,2,3”,“filtered_by_year”:true,“filtered_by_unity”:true,“worker_state_id”:2085}],“retry”:3,“queue”:“synchronizer”,“unique”:“until_and_while_executing”,“dead”:false,“jid”:“9fb95eea40ac65f261be5707”,“created_at”:1584407382.6318595,“unique_prefix”:“uniquejobs”,“unique_args”:[{“klass”:“SpecificStepsSynchronizer”,“synchronization_id”:37,“worker_batch_id”:37,“entity_id”:5,“year”:“2020”,“unity_api_code”:“6,4,8,2,3”,“filtered_by_year”:true,“filtered_by_unity”:true,“worker_state_id”:2085}],“unique_digest”:“uniquejobs:1618c63c6db616c75397ad9c28f783ee”,“enqueued_at”:1584407382.641678,“error_message”:“could not obtain a database connection within 5.000 seconds (waited 9.991 seconds)”,“error_class”:“ActiveRecord::ConnectionTimeoutError”,“failed_at”:1584407405.4156613,“retry_count”:0},“jobstr”:"{“class”:“SynchronizerExecuterWorker”,“args”:[{“klass”:“SpecificStepsSynchronizer”,“synchronization_id”:37,“worker_batch_id”:37,“entity_id”:5,“year”:“2020”,“unity_api_code”:“6,4,8,2,3”,“filtered_by_year”:true,“filtered_by_unity”:true,“worker_state_id”:2085}],“retry”:3,“queue”:“synchronizer”,“unique”:“until_and_while_executing”,“dead”:false,“jid”:“9fb95eea40ac65f261be5707”,“created_at”:1584407382.6318595,“unique_prefix”:“uniquejobs”,“unique_args”:[{“klass”:“SpecificStepsSynchronizer”,“synchronization_id”:37,“worker_batch_id”:37,“entity_id”:5,“year”:“2020”,“unity_api_code”:“6,4,8,2,3”,“filtered_by_year”:true,“filtered_by_unity”:true,“worker_state_id”:2085}],“unique_digest”:“uniquejobs:1618c63c6db616c75397ad9c28f783ee”,“enqueued_at”:1584407382.641678}"}
2020-03-17T01:10:07.936Z 35916 TID-owxe2yjd4 WARN: ActiveRecord::ConnectionTimeoutError: could not obtain a database connection within 5.000 seconds (waited 9.991 seconds)
2020-03-17T01:10:07.960Z 35916 TID-owxe2yjd4 WARN: /home/master/.rvm/gems/ruby-2.3.7/gems/activerecord-4.2.11.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:189:in block in wait_poll' /home/master/.rvm/gems/ruby-2.3.7/gems/activerecord-4.2.11.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:180:in loop’
/home/master/.rvm/gems/ruby-2.3.7/gems/activerecord-4.2.11.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:180:in wait_poll' /home/master/.rvm/gems/ruby-2.3.7/gems/activerecord-4.2.11.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:135:in block in poll’
/home/master/.rvm/rubies/ruby-2.3.7/lib/ruby/2.3.0/monitor.rb:214:in mon_synchronize' /home/master/.rvm/gems/ruby-2.3.7/gems/activerecord-4.2.11.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:145:in synchronize’
/home/master/.rvm/gems/ruby-2.3.7/gems/activerecord-4.2.11.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:133:in poll' /home/master/.rvm/gems/ruby-2.3.7/gems/activerecord-4.2.11.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:425:in acquire_connection’
/home/master/.rvm/gems/ruby-2.3.7/gems/activerecord-4.2.11.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:349:in block in checkout' /home/master/.rvm/rubies/ruby-2.3.7/lib/ruby/2.3.0/monitor.rb:214:in mon_synchronize’
/home/master/.rvm/gems/ruby-2.3.7/gems/activerecord-4.2.11.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:348:in checkout' /home/master/.rvm/gems/ruby-2.3.7/gems/activerecord-4.2.11.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:263:in block in connection’
/home/master/.rvm/rubies/ruby-2.3.7/lib/ruby/2.3.0/monitor.rb:214:in mon_synchronize' /home/master/.rvm/gems/ruby-2.3.7/gems/activerecord-4.2.11.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:262:in connection’
/home/master/.rvm/gems/ruby-2.3.7/gems/activerecord-4.2.11.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:571:in retrieve_connection' /home/master/.rvm/gems/ruby-2.3.7/bundler/gems/activerecord-connections-b2a704ff10c4/lib/active_record/connections.rb:63:in retrieve_connection’
/home/master/.rvm/gems/ruby-2.3.7/gems/activerecord-4.2.11.1/lib/active_record/connection_handling.rb:87:in connection' /home/master/.rvm/gems/ruby-2.3.7/gems/activerecord-4.2.11.1/lib/active_record/core.rb:153:in find’
/home/master/.rvm/gems/ruby-2.3.7/gems/bullet-4.14.10/lib/bullet/active_record42.rb:9:in find' /home/master/i-diario/app/workers/ieducar/synchronizer_executer_worker.rb:5:in perform’
/home/master/.rvm/gems/ruby-2.3.7/gems/sidekiq-5.0.3/lib/sidekiq/processor.rb:199:in execute_job' /home/master/.rvm/gems/ruby-2.3.7/gems/sidekiq-5.0.3/lib/sidekiq/processor.rb:170:in block (2 levels) in process’
/home/master/.rvm/gems/ruby-2.3.7/gems/sidekiq-5.0.3/lib/sidekiq/middleware/chain.rb:128:in block in invoke' /home/master/.rvm/gems/ruby-2.3.7/gems/newrelic_rpm-3.14.0.305/lib/new_relic/agent/instrumentation/sidekiq.rb:33:in block in call’
/home/master/.rvm/gems/ruby-2.3.7/gems/newrelic_rpm-3.14.0.305/lib/new_relic/agent/instrumentation/controller_instrumentation.rb:362:in perform_action_with_newrelic_trace' /home/master/.rvm/gems/ruby-2.3.7/gems/newrelic_rpm-3.14.0.305/lib/new_relic/agent/instrumentation/sidekiq.rb:29:in call’
/home/master/.rvm/gems/ruby-2.3.7/gems/sidekiq-5.0.3/lib/sidekiq/middleware/chain.rb:130:in block in invoke' /home/master/.rvm/gems/ruby-2.3.7/gems/sidekiq-5.0.3/lib/sidekiq/middleware/server/active_record.rb:15:in call’
/home/master/.rvm/gems/ruby-2.3.7/gems/sidekiq-5.0.3/lib/sidekiq/middleware/chain.rb:130:in block in invoke' /home/master/.rvm/gems/ruby-2.3.7/gems/sidekiq-unique-jobs-4.0.18/lib/sidekiq_unique_jobs/lock/until_and_while_executing.rb:8:in block in execute’
/home/master/.rvm/gems/ruby-2.3.7/gems/sidekiq-unique-jobs-4.0.18/lib/sidekiq_unique_jobs/lock/while_executing.rb:19:in synchronize' /home/master/.rvm/gems/ruby-2.3.7/gems/sidekiq-unique-jobs-4.0.18/lib/sidekiq_unique_jobs/lock/until_and_while_executing.rb:6:in execute’
/home/master/.rvm/gems/ruby-2.3.7/gems/sidekiq-unique-jobs-4.0.18/lib/sidekiq_unique_jobs/server/middleware.rb:16:in call' /home/master/.rvm/gems/ruby-2.3.7/gems/sidekiq-5.0.3/lib/sidekiq/middleware/chain.rb:130:in block in invoke’
/home/master/.rvm/gems/ruby-2.3.7/gems/honeybadger-4.2.1/lib/honeybadger/plugins/sidekiq.rb:10:in call' /home/master/.rvm/gems/ruby-2.3.7/gems/sidekiq-5.0.3/lib/sidekiq/middleware/chain.rb:130:in block in invoke’
/home/master/.rvm/gems/ruby-2.3.7/gems/sidekiq-5.0.3/lib/sidekiq/middleware/chain.rb:133:in invoke' /home/master/.rvm/gems/ruby-2.3.7/gems/sidekiq-5.0.3/lib/sidekiq/processor.rb:169:in block in process’
/home/master/.rvm/gems/ruby-2.3.7/gems/sidekiq-5.0.3/lib/sidekiq/processor.rb:141:in block (6 levels) in dispatch' /home/master/.rvm/gems/ruby-2.3.7/gems/sidekiq-5.0.3/lib/sidekiq/job_retry.rb:97:in local’
/home/master/.rvm/gems/ruby-2.3.7/gems/sidekiq-5.0.3/lib/sidekiq/processor.rb:140:in block (5 levels) in dispatch' /home/master/.rvm/gems/ruby-2.3.7/gems/sidekiq-5.0.3/lib/sidekiq.rb:36:in block in module:Sidekiq’
/home/master/.rvm/gems/ruby-2.3.7/gems/sidekiq-5.0.3/lib/sidekiq/processor.rb:136:in block (4 levels) in dispatch' /home/master/.rvm/gems/ruby-2.3.7/gems/sidekiq-5.0.3/lib/sidekiq/processor.rb:215:in stats’
/home/master/.rvm/gems/ruby-2.3.7/gems/sidekiq-5.0.3/lib/sidekiq/processor.rb:131:in block (3 levels) in dispatch' /home/master/.rvm/gems/ruby-2.3.7/gems/sidekiq-5.0.3/lib/sidekiq/job_logger.rb:7:in call’
/home/master/.rvm/gems/ruby-2.3.7/gems/sidekiq-5.0.3/lib/sidekiq/processor.rb:130:in block (2 levels) in dispatch' /home/master/.rvm/gems/ruby-2.3.7/gems/sidekiq-5.0.3/lib/sidekiq/job_retry.rb:72:in global’
/home/master/.rvm/gems/ruby-2.3.7/gems/sidekiq-5.0.3/lib/sidekiq/processor.rb:129:in block in dispatch' /home/master/.rvm/gems/ruby-2.3.7/gems/sidekiq-5.0.3/lib/sidekiq/logging.rb:44:in with_context’
/home/master/.rvm/gems/ruby-2.3.7/gems/sidekiq-5.0.3/lib/sidekiq/logging.rb:38:in with_job_hash_context' /home/master/.rvm/gems/ruby-2.3.7/gems/sidekiq-5.0.3/lib/sidekiq/processor.rb:128:in dispatch’
/home/master/.rvm/gems/ruby-2.3.7/gems/sidekiq-5.0.3/lib/sidekiq/processor.rb:168:in process' /home/master/.rvm/gems/ruby-2.3.7/gems/sidekiq-5.0.3/lib/sidekiq/processor.rb:85:in process_one’
/home/master/.rvm/gems/ruby-2.3.7/gems/sidekiq-5.0.3/lib/sidekiq/processor.rb:73:in run' /home/master/.rvm/gems/ruby-2.3.7/gems/sidekiq-5.0.3/lib/sidekiq/util.rb:16:in watchdog’
/home/master/.rvm/gems/ruby-2
Acho que nesse trecho tem a dica: “could not obtain a database connection”