Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Text: 17-07-28 02:20:51: Старт процесса переноса данных счетчиков в БД...
- 17-07-28 02:20:51: {:from=>nil, :to=>Thu, 27 Jul 2017, :debug=>false, :enable_period_check=>true}
- 17-07-28 02:20:51: Обработка счетчика 'hits_by_day'...
- 17-07-28 02:20:51: обрабатываю данные за: 2017-07-27...
- 17-07-28 02:20:51: Ошибка при сохранении статистики.
- 17-07-28 02:20:51: PG::DuplicateTable: ERROR: relation "company_statistic_total_by_days_17_07" already exists
- CONTEXT: SQL statement "CREATE TABLE statistics.company_statistic_total_by_days_17_07 ( CHECK ( date >= TIMESTAMP '2017-07-01 00:00:00' AND date < TIMESTAMP '2017-08-01 00:00:00' ) ) INHERITS (statistics.company_statistic_total_by_days);"
- PL/pgSQL function system.pg_add_range_partition(text,text,text,text,text[],text) line 40 at EXECUTE
- : SELECT
- system.pg_add_range_partition('statistics.company_statistic_total_by_days', 'statistics.company_statistic_total_by_days_17_07',
- '[date] >= TIMESTAMP ''2017-07-01 00:00:00'' AND [date] < TIMESTAMP ''2017-08-01 00:00:00''',
- 'statistics.company_statistic_total_by_days_insert_trigger',
- ARRAY['company_id,date'],
- 's_c_stat_total_by_days_17_07')
- /home/sg/.gem/ruby/2.2.0/gems/apress-utils-2.3.0/lib/apress/utils/extensions/active_record/connection_adapters/postgre_sql_adapter.rb:27:in `async_exec'
- /home/sg/.gem/ruby/2.2.0/gems/apress-utils-2.3.0/lib/apress/utils/extensions/active_record/connection_adapters/postgre_sql_adapter.rb:27:in `exec_no_cache'
- /home/sg/.gem/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/connection_adapters/postgresql_adapter.rb:660:in `block in exec_query'
- /home/sg/.gem/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/connection_adapters/abstract_adapter.rb:280:in `block in log'
- /home/sg/.gem/ruby/2.2.0/gems/activesupport-3.2.22.5/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
- /home/sg/.gem/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/connection_adapters/abstract_adapter.rb:275:in `log'
- /home/sg/.gem/ruby/2.2.0/gems/newrelic_rpm-3.17.1.326/lib/new_relic/agent/instrumentation/active_record.rb:67:in `log_with_newrelic_instrumentation'
- /home/sg/.gem/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/connection_adapters/postgresql_adapter.rb:659:in `exec_query'
- (eval):9:in `exec_query_with_at_active_record'
- /home/sg/.gem/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/connection_adapters/postgresql_adapter.rb:1262:in `select'
- /home/sg/.gem/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/connection_adapters/abstract/database_statements.rb:18:in `select_all'
- /home/sg/.gem/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/connection_adapters/abstract/query_cache.rb:63:in `select_all'
- /home/sg/.gem/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/connection_adapters/abstract/database_statements.rb:24:in `select_one'
- /home/sg/.gem/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/connection_adapters/abstract/database_statements.rb:30:in `select_value'
- /home/sg/.gem/ruby/2.2.0/bundler/gems/apress-company_statistics-502e2701fac4/app/models/apress/company_statistics/migration_helpers.rb:131:in `add_date_ranged_partition'
- /home/sg/.gem/ruby/2.2.0/bundler/gems/apress-company_statistics-502e2701fac4/app/models/apress/company_statistics/migration_helpers.rb:99:in `add_month_ranged_partition'
- /home/sg/.gem/ruby/2.2.0/bundler/gems/apress-company_statistics-502e2701fac4/app/models/apress/company_statistics/total_by_day.rb:16:in `add_partition'
- /home/sg/.gem/ruby/2.2.0/bundler/gems/apress-company_statistics-502e2701fac4/app/counters/apress/company_statistics/counters/dumpers.rb:338:in `block (3 levels) in '
- /home/sg/.gem/ruby/2.2.0/bundler/gems/apress-company_statistics-502e2701fac4/app/counters/apress/company_statistics/counters/dumpers.rb:335:in `each'
- /home/sg/.gem/ruby/2.2.0/bundler/gems/apress-company_statistics-502e2701fac4/app/counters/apress/company_statistics/counters/dumpers.rb:335:in `block (2 levels) in '
- /home/sg/.gem/ruby/2.2.0/gems/callbacks_rb-0.0.1/lib/callbacks_rb.rb:38:in `call'
- /home/sg/.gem/ruby/2.2.0/gems/callbacks_rb-0.0.1/lib/callbacks_rb.rb:38:in `block in fire_callback'
- /home/sg/.gem/ruby/2.2.0/gems/callbacks_rb-0.0.1/lib/callbacks_rb.rb:38:in `each'
- /home/sg/.gem/ruby/2.2.0/gems/callbacks_rb-0.0.1/lib/callbacks_rb.rb:38:in `fire_callback'
- /home/sg/.gem/ruby/2.2.0/bundler/gems/redis_counters-dumpers-d78fa7228ada/lib/redis_counters/dumpers/engine.rb:172:in `merge_data'
- /home/sg/.gem/ruby/2.2.0/bundler/gems/redis_counters-dumpers-d78fa7228ada/lib/redis_counters/dumpers/engine.rb:138:in `block in process!'
- /home/sg/.gem/ruby/2.2.0/gems/activerecord-3.2.22.5/lib/active_record/connection_adapters/abstract/database_statements.rb:192:in `transaction'
- /home/sg/.gem/ruby/2.2.0/bundler/gems/redis_counters-dumpers-d78fa7228ada/lib/redis_counters/dumpers/engine.rb:137:in `process!'
- /home/sg/.gem/ruby/2.2.0/bundler/gems/apress-company_statistics-502e2701fac4/app/services/apress/company_statistics/dumper.rb:166:in `block in dump_counter'
- /home/sg/.gem/ruby/2.2.0/bundler/gems/apress-company_statistics-502e2701fac4/app/services/apress/company_statistics/dumper.rb:164:in `each'
- /home/sg/.gem/ruby/2.2.0/bundler/gems/apress-company_statistics-502e2701fac4/app/services/apress/company_statistics/dumper.rb:164:in `dump_counter'
- /home/sg/.gem/ruby/2.2.0/bundler/gems/apress-company_statistics-502e2701fac4/app/services/apress/company_statistics/dumper.rb:70:in `block (2 levels) in dump!'
- /home/sg/.gem/ruby/2.2.0/bundler/gems/apress-company_statistics-502e2701fac4/app/services/apress/company_statistics/dumper.rb:68:in `each'
- /home/sg/.gem/ruby/2.2.0/bundler/gems/apress-company_statistics-502e2701fac4/app/services/apress/company_statistics/dumper.rb:68:in `block in dump!'
- /home/sg/.gem/ruby/2.2.0/gems/redis-mutex-2.1.1/lib/redis/mutex.rb:81:in `with_lock'
- /home/sg/.gem/ruby/2.2.0/gems/redis-mutex-2.1.1/lib/redis/mutex.rb:126:in `with_lock'
- /home/sg/.gem/ruby/2.2.0/bundler/gems/apress-company_statistics-502e2701fac4/app/services/apress/company_statistics/blocker.rb:13:in `lock'
- /home/sg/.gem/ruby/2.2.0/bundler/gems/apress-company_statistics-502e2701fac4/app/services/apress/company_statistics/dumper.rb:67:in `dump!'
- /home/sg/.gem/ruby/2.2.0/bundler/gems/apress-company_statistics-502e2701fac4/app/services/apress/company_statistics/dumper.rb:48:in `dump!'
- /home/sg/.gem/ruby/2.2.0/bundler/gems/apress-company_statistics-502e2701fac4/lib/tasks/company_statistics.rake:12:in `block (2 levels) in '
- /home/sg/.gem/ruby/2.2.0/gems/rake-10.1.1/lib/rake/task.rb:236:in `call'
- /home/sg/.gem/ruby/2.2.0/gems/rake-10.1.1/lib/rake/task.rb:236:in `block in execute'
- /home/sg/.gem/ruby/2.2.0/gems/rake-10.1.1/lib/rake/task.rb:231:in `each'
- /home/sg/.gem/ruby/2.2.0/gems/rake-10.1.1/lib/rake/task.rb:231:in `execute'
- /home/sg/.gem/ruby/2.2.0/gems/newrelic-rake-1.4.1/lib/newrelic-rake/instrument.rb:33:in `block in execute_with_newrelic_trace'
- /home/sg/.gem/ruby/2.2.0/gems/newrelic_rpm-3.17.1.326/lib/new_relic/agent/instrumentation/controller_instrumentation.rb:363:in `perform_action_with_newrelic_trace'
- /home/sg/.gem/ruby/2.2.0/gems/newrelic-rake-1.4.1/lib/newrelic-rake/instrument.rb:32:in `execute_with_newrelic_trace'
- /home/sg/.gem/ruby/2.2.0/gems/newrelic-rake-1.4.1/lib/newrelic-rake/instrument.rb:23:in `execute'
- /home/sg/.gem/ruby/2.2.0/gems/rake-10.1.1/lib/rake/task.rb:175:in `block in invoke_with_call_chain'
- /usr/lib64/ruby/2.2.0/monitor.rb:211:in `mon_synchronize'
- /home/sg/.gem/ruby/2.2.0/gems/rake-10.1.1/lib/rake/task.rb:168:in `invoke_with_call_chain'
- /home/sg/.gem/ruby/2.2.0/gems/rake-10.1.1/lib/rake/task.rb:161:in `invoke'
- /home/sg/.gem/ruby/2.2.0/gems/rake-10.1.1/lib/rake/application.rb:149:in `invoke_task'
- /home/sg/.gem/ruby/2.2.0/gems/rake-10.1.1/lib/rake/application.rb:106:in `block (2 levels) in top_level'
- /home/sg/.gem/ruby/2.2.0/gems/rake-10.1.1/lib/rake/application.rb:106:in `each'
- /home/sg/.gem/ruby/2.2.0/gems/rake-10.1.1/lib/rake/application.rb:106:in `block in top_level'
- /home/sg/.gem/ruby/2.2.0/gems/rake-10.1.1/lib/rake/application.rb:115:in `run_with_threads'
- /home/sg/.gem/ruby/2.2.0/gems/rake-10.1.1/lib/rake/application.rb:100:in `top_level'
- /home/sg/.gem/ruby/2.2.0/gems/rake-10.1.1/lib/rake/application.rb:78:in `block in run'
- /home/sg/.gem/ruby/2.2.0/gems/rake-10.1.1/lib/rake/application.rb:165:in `standard_exception_handling'
- /home/sg/.gem/ruby/2.2.0/gems/rake-10.1.1/lib/rake/application.rb:75:in `run'
- /home/sg/.gem/ruby/2.2.0/gems/rake-10.1.1/bin/rake:33:in `'
- /home/sg/.gem/ruby/2.2.0/bin/rake:22:in `load'
- /home/sg/.gem/ruby/2.2.0/bin/rake:22:in `'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement