· 9 years ago · Nov 07, 2016, 09:14 AM
1NOTICE: Partition script: CREATE TABLE statistics.company_statistic_total_by_months_16_08 ( CHECK ( date >= TIMESTAMP '2016-08-01 00:00:00' AND date < TIMESTAMP '2016-09-01 00:00:00' ) ) INHERITS (statistics.company_statistic_total_by_months);
2NOTICE: Trigger script: CREATE OR REPLACE FUNCTION statistics.company_statistic_total_by_months_insert_trigger() RETURNS TRIGGER AS $body$ BEGIN IF (NEW.date >= TIMESTAMP '2016-08-01 00:00:00' AND NEW.date < TIMESTAMP '2016-09-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_16_08 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2010-06-01 00:00:00' AND NEW.date < TIMESTAMP '2010-07-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_10_06 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2010-07-01 00:00:00' AND NEW.date < TIMESTAMP '2010-08-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_10_07 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2010-08-01 00:00:00' AND NEW.date < TIMESTAMP '2010-09-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_10_08 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2010-09-01 00:00:00' AND NEW.date < TIMESTAMP '2010-10-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_10_09 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2010-10-01 00:00:00' AND NEW.date < TIMESTAMP '2010-11-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_10_10 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2009-11-01 00:00:00' AND NEW.date < TIMESTAMP '2009-12-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_09_11 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2010-03-01 00:00:00' AND NEW.date < TIMESTAMP '2010-04-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_10_03 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2009-04-01 00:00:00' AND NEW.date < TIMESTAMP '2009-05-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_09_04 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2009-05-01 00:00:00' AND NEW.date < TIMESTAMP '2009-06-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_09_05 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2009-06-01 00:00:00' AND NEW.date < TIMESTAMP '2009-07-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_09_06 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2009-07-01 00:00:00' AND NEW.date < TIMESTAMP '2009-08-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_09_07 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2009-08-01 00:00:00' AND NEW.date < TIMESTAMP '2009-09-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_09_08 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2009-09-01 00:00:00' AND NEW.date < TIMESTAMP '2009-10-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_09_09 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2009-10-01 00:00:00' AND NEW.date < TIMESTAMP '2009-11-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_09_10 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2010-11-01 00:00:00' AND NEW.date < TIMESTAMP '2010-12-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_10_11 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2009-12-01 00:00:00' AND NEW.date < TIMESTAMP '2010-01-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_09_12 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2010-01-01 00:00:00' AND NEW.date < TIMESTAMP '2010-02-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_10_01 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2010-02-01 00:00:00' AND NEW.date < TIMESTAMP '2010-03-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_10_02 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2010-04-01 00:00:00' AND NEW.date < TIMESTAMP '2010-05-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_10_04 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2010-05-01 00:00:00' AND NEW.date < TIMESTAMP '2010-06-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_10_05 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2010-12-01 00:00:00' AND NEW.date < TIMESTAMP '2011-01-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_10_12 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2011-01-01 00:00:00' AND NEW.date < TIMESTAMP '2011-02-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_11_01 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2011-02-01 00:00:00' AND NEW.date < TIMESTAMP '2011-03-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_11_02 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2011-03-01 00:00:00' AND NEW.date < TIMESTAMP '2011-04-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_11_03 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2011-04-01 00:00:00' AND NEW.date < TIMESTAMP '2011-05-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_11_04 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2011-05-01 00:00:00' AND NEW.date < TIMESTAMP '2011-06-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_11_05 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2011-06-01 00:00:00' AND NEW.date < TIMESTAMP '2011-07-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_11_06 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2011-07-01 00:00:00' AND NEW.date < TIMESTAMP '2011-08-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_11_07 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2011-08-01 00:00:00' AND NEW.date < TIMESTAMP '2011-09-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_11_08 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2011-09-01 00:00:00' AND NEW.date < TIMESTAMP '2011-10-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_11_09 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2011-10-01 00:00:00' AND NEW.date < TIMESTAMP '2011-11-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_11_10 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2011-11-01 00:00:00' AND NEW.date < TIMESTAMP '2011-12-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_11_11 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2011-12-01 00:00:00' AND NEW.date < TIMESTAMP '2012-01-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_11_12 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2012-01-01 00:00:00' AND NEW.date < TIMESTAMP '2012-02-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_12_01 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2012-02-01 00:00:00' AND NEW.date < TIMESTAMP '2012-03-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_12_02 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2012-03-01 00:00:00' AND NEW.date < TIMESTAMP '2012-04-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_12_03 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2012-04-01 00:00:00' AND NEW.date < TIMESTAMP '2012-05-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_12_04 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2012-05-01 00:00:00' AND NEW.date < TIMESTAMP '2012-06-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_12_05 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2012-06-01 00:00:00' AND NEW.date < TIMESTAMP '2012-07-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_12_06 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2012-07-01 00:00:00' AND NEW.date < TIMESTAMP '2012-08-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_12_07 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2012-08-01 00:00:00' AND NEW.date < TIMESTAMP '2012-09-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_12_08 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2012-09-01 00:00:00' AND NEW.date < TIMESTAMP '2012-10-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_12_09 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2012-10-01 00:00:00' AND NEW.date < TIMESTAMP '2012-11-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_12_10 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2012-11-01 00:00:00' AND NEW.date < TIMESTAMP '2012-12-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_12_11 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2012-12-01 00:00:00' AND NEW.date < TIMESTAMP '2013-01-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_12_12 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2013-01-01 00:00:00' AND NEW.date < TIMESTAMP '2013-02-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_13_01 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2013-02-01 00:00:00' AND NEW.date < TIMESTAMP '2013-03-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_13_02 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2013-03-01 00:00:00' AND NEW.date < TIMESTAMP '2013-04-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_13_03 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2013-04-01 00:00:00' AND NEW.date < TIMESTAMP '2013-05-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_13_04 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2013-05-01 00:00:00' AND NEW.date < TIMESTAMP '2013-06-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_13_05 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2013-06-01 00:00:00' AND NEW.date < TIMESTAMP '2013-07-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_13_06 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2013-07-01 00:00:00' AND NEW.date < TIMESTAMP '2013-08-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_13_07 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2013-08-01 00:00:00' AND NEW.date < TIMESTAMP '2013-09-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_13_08 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2013-09-01 00:00:00' AND NEW.date < TIMESTAMP '2013-10-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_13_09 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2013-10-01 00:00:00' AND NEW.date < TIMESTAMP '2013-11-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_13_10 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2013-11-01 00:00:00' AND NEW.date < TIMESTAMP '2013-12-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_13_11 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2013-12-01 00:00:00' AND NEW.date < TIMESTAMP '2014-01-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_13_12 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2014-01-01 00:00:00' AND NEW.date < TIMESTAMP '2014-02-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_14_01 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2014-02-01 00:00:00' AND NEW.date < TIMESTAMP '2014-03-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_14_02 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2014-03-01 00:00:00' AND NEW.date < TIMESTAMP '2014-04-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_14_03 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2014-04-01 00:00:00' AND NEW.date < TIMESTAMP '2014-05-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_14_04 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2014-05-01 00:00:00' AND NEW.date < TIMESTAMP '2014-06-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_14_05 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2014-06-01 00:00:00' AND NEW.date < TIMESTAMP '2014-07-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_14_06 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2014-07-01 00:00:00' AND NEW.date < TIMESTAMP '2014-08-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_14_07 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2014-08-01 00:00:00' AND NEW.date < TIMESTAMP '2014-09-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_14_08 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2014-09-01 00:00:00' AND NEW.date < TIMESTAMP '2014-10-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_14_09 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2014-10-01 00:00:00' AND NEW.date < TIMESTAMP '2014-11-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_14_10 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2014-11-01 00:00:00' AND NEW.date < TIMESTAMP '2014-12-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_14_11 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2014-12-01 00:00:00' AND NEW.date < TIMESTAMP '2015-01-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_14_12 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2015-01-01 00:00:00' AND NEW.date < TIMESTAMP '2015-02-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_15_01 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2015-02-01 00:00:00' AND NEW.date < TIMESTAMP '2015-03-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_15_02 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2015-03-01 00:00:00' AND NEW.date < TIMESTAMP '2015-04-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_15_03 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2015-04-01 00:00:00' AND NEW.date < TIMESTAMP '2015-05-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_15_04 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2015-05-01 00:00:00' AND NEW.date < TIMESTAMP '2015-06-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_15_05 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2015-06-01 00:00:00' AND NEW.date < TIMESTAMP '2015-07-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_15_06 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2015-07-01 00:00:00' AND NEW.date < TIMESTAMP '2015-08-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_15_07 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2015-08-01 00:00:00' AND NEW.date < TIMESTAMP '2015-09-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_15_08 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2015-09-01 00:00:00' AND NEW.date < TIMESTAMP '2015-10-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_15_09 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2015-10-01 00:00:00' AND NEW.date < TIMESTAMP '2015-11-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_15_10 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2015-11-01 00:00:00' AND NEW.date < TIMESTAMP '2015-12-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_15_11 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2015-12-01 00:00:00' AND NEW.date < TIMESTAMP '2016-01-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_15_12 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2016-01-01 00:00:00' AND NEW.date < TIMESTAMP '2016-02-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_16_01 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2016-02-01 00:00:00' AND NEW.date < TIMESTAMP '2016-03-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_16_02 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2016-03-01 00:00:00' AND NEW.date < TIMESTAMP '2016-04-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_16_03 VALUES (NEW.*); ELSIF (NEW.date >= TIMESTAMP '2016-06-01 00:00:00' AND NEW.date < TIMESTAMP '2016-07-01 00:00:00') THEN INSERT INTO statistics.company_statistic_total_by_months_16_06 VALUES (NEW.*); ELSE RAISE EXCEPTION 'Inserted data is out of range. Fix statistics.company_statistic_total_by_months_insert_trigger.'; END IF; RETURN NULL; END; $body$ LANGUAGE plpgsql;
3rake aborted!
4ActiveRecord::StatementInvalid: PG::InternalError: ERROR: No such queue
5CONTEXT: PL/pgSQL function pgq.insert_event(text,text,text,text,text,text,text) line 24 at RETURN
6SQL statement "select pgq.insert_event($1, $2, $3, $4, $5, $6, $7)"
7SQL statement "INSERT INTO statistics.company_statistic_total_by_months_16_08 VALUES (NEW.*)"
8PL/pgSQL function statistics.company_statistic_total_by_months_insert_trigger() line 1 at SQL statement
9: CREATE TEMP TABLE _source_tmp_hits_by_day ON COMMIT DROP AS
10 SELECT company_id as company_id, value as pages, start_month_date as date
11 FROM tmp_hits_by_day
12
13 ;
14 WITH
15 updated AS
16 (
17 UPDATE "statistics"."company_statistic_total_by_months" target
18 SET
19 pages = COALESCE(target.pages, 0) + source.pages
20 FROM _source_tmp_hits_by_day AS source
21 WHERE (source.company_id, source.date) = (target.company_id, target.date)
22 AND (target.date = '2016-08-01')
23 RETURNING target.*
24 )
25 INSERT INTO "statistics"."company_statistic_total_by_months" (company_id, pages, date)
26 SELECT company_id, pages, date
27 FROM _source_tmp_hits_by_day as source
28 WHERE NOT EXISTS (
29 SELECT 1
30 FROM updated target
31 WHERE (source.company_id, source.date) = (target.company_id, target.date)
32 AND (target.date = '2016-08-01')
33 );
34 DROP TABLE _source_tmp_hits_by_day;
35/home/pc/sites/pulscen/shared/bundle/ruby/1.9.1/bundler/gems/rails-325008e70fd5/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb:605:in `async_exec'
36/home/pc/sites/pulscen/shared/bundle/ruby/1.9.1/bundler/gems/rails-325008e70fd5/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb:605:in `block in execute'
37/home/pc/sites/pulscen/shared/bundle/ruby/1.9.1/gems/apress-utils-1.7.3/lib/apress/utils/extensions/active_record/postgresql_patches.rb:137:in `block in log'
38/home/pc/sites/pulscen/shared/bundle/ruby/1.9.1/bundler/gems/rails-325008e70fd5/activesupport/lib/active_support/notifications/instrumenter.rb:21:in `instrument'
39/home/pc/sites/pulscen/shared/bundle/ruby/1.9.1/gems/apress-utils-1.7.3/lib/apress/utils/extensions/active_record/postgresql_patches.rb:132:in `log'
40/home/pc/sites/pulscen/shared/bundle/ruby/1.9.1/gems/newrelic_rpm-3.16.2.321/lib/new_relic/agent/instrumentation/active_record.rb:57:in `log_with_newrelic_instrumentation'
41/home/pc/sites/pulscen/shared/bundle/ruby/1.9.1/bundler/gems/rails-325008e70fd5/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb:604:in `execute'
42(eval):9:in `execute_with_at_active_record'
43(eval):3:in `execute_with_counter'
44/home/pc/sites/pulscen/shared/bundle/ruby/1.9.1/gems/redis_counters-dumpers-1.0.0/lib/redis_counters/dumpers/destination.rb:78:in `merge'
45/home/pc/sites/pulscen/shared/bundle/ruby/1.9.1/gems/redis_counters-dumpers-1.0.0/lib/redis_counters/dumpers/engine.rb:181:in `block in merge_data'
46/home/pc/sites/pulscen/shared/bundle/ruby/1.9.1/gems/redis_counters-dumpers-1.0.0/lib/redis_counters/dumpers/engine.rb:181:in `each'
47/home/pc/sites/pulscen/shared/bundle/ruby/1.9.1/gems/redis_counters-dumpers-1.0.0/lib/redis_counters/dumpers/engine.rb:181:in `merge_data'
48/home/pc/sites/pulscen/shared/bundle/ruby/1.9.1/gems/redis_counters-dumpers-1.0.0/lib/redis_counters/dumpers/engine.rb:139:in `block in process!'
49/home/pc/sites/pulscen/shared/bundle/ruby/1.9.1/bundler/gems/rails-325008e70fd5/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:194:in `transaction'
50/home/pc/sites/pulscen/shared/bundle/ruby/1.9.1/gems/redis_counters-dumpers-1.0.0/lib/redis_counters/dumpers/engine.rb:138:in `process!'
51/home/pc/sites/pulscen/releases/20161103065846/vendor/plugins/core_company_statistics/lib/core_statistics/company/services/dumper.rb:157:in `block in dump_counter'
52/home/pc/sites/pulscen/releases/20161103065846/vendor/plugins/core_company_statistics/lib/core_statistics/company/services/dumper.rb:155:in `each'
53/home/pc/sites/pulscen/releases/20161103065846/vendor/plugins/core_company_statistics/lib/core_statistics/company/services/dumper.rb:155:in `dump_counter'
54/home/pc/sites/pulscen/releases/20161103065846/vendor/plugins/core_company_statistics/lib/core_statistics/company/services/dumper.rb:65:in `block (2 levels) in dump!'
55/home/pc/sites/pulscen/releases/20161103065846/vendor/plugins/core_company_statistics/lib/core_statistics/company/services/dumper.rb:63:in `each'
56/home/pc/sites/pulscen/releases/20161103065846/vendor/plugins/core_company_statistics/lib/core_statistics/company/services/dumper.rb:63:in `block in dump!'
57/home/pc/sites/pulscen/shared/bundle/ruby/1.9.1/gems/redis-mutex-2.1.1/lib/redis/mutex.rb:81:in `with_lock'
58/home/pc/sites/pulscen/shared/bundle/ruby/1.9.1/gems/redis-mutex-2.1.1/lib/redis/mutex.rb:126:in `with_lock'
59/home/pc/sites/pulscen/releases/20161103065846/vendor/plugins/blocker/lib/blocker.rb:11:in `lock'
60/home/pc/sites/pulscen/releases/20161103065846/vendor/plugins/core_company_statistics/lib/core_statistics/company/services/dumper.rb:62:in `dump!'
61/home/pc/sites/pulscen/releases/20161103065846/vendor/plugins/core_company_statistics/lib/core_statistics/company/services/dumper.rb:44:in `dump!'
62/home/pc/sites/pulscen/releases/20161103065846/vendor/plugins/core_company_statistics/lib/tasks/statistics.rake:14:in `block (3 levels) in <top (required)>'
63(eval):3:in `execute_with_counter_flush'
64/home/pc/sites/pulscen/shared/bundle/ruby/1.9.1/gems/newrelic-rake-1.4.1/lib/newrelic-rake/instrument.rb:33:in `block in execute_with_newrelic_trace'
65/home/pc/sites/pulscen/shared/bundle/ruby/1.9.1/gems/newrelic_rpm-3.16.2.321/lib/new_relic/agent/instrumentation/controller_instrumentation.rb:363:in `perform_action_with_newrelic_trace'
66/home/pc/sites/pulscen/shared/bundle/ruby/1.9.1/gems/newrelic-rake-1.4.1/lib/newrelic-rake/instrument.rb:32:in `execute_with_newrelic_trace'
67/home/pc/sites/pulscen/shared/bundle/ruby/1.9.1/gems/newrelic-rake-1.4.1/lib/newrelic-rake/instrument.rb:23:in `execute'
68Tasks: TOP => statistics:companies:daily
69(See full trace by running task with --trace)