PagesController# (ActiveRecord::StatementInvalid) "PG::Error: ERROR: column "pg_search_rank" does not exist LINE 1: ... ''' ' || 'www.Bef' || ' ''' || ':*')))) ORDER BY pg_search_... ^ : SELECT "datacolumns"."id" AS t0_r0, "datacolumns"."datagroup_id" AS t0_r1, "datacolumns"."dataset_id" AS t0_r2, "datacolumns"."columnheader" AS t0_r3, "datacolumns"."columnnr" AS t0_r4, "datacolumns"."definition" AS t0_r5, "datacolumns"."unit" AS t0_r6, "datacolumns"."comment" AS t0_r7, "datacolumns"."import_data_type" AS t0_r8, "datacolumns"."created_at" AS t0_r9, "datacolumns"."updated_at" AS t0_r10, "datacolumns"."datagroup_approved" AS t0_r11, "datacolumns"."finished" AS t0_r12, "datacolumns"."datatype_approved" AS t0_r13, "datacolumns"."informationsource" AS t0_r14, "datacolumns"."instrumentation" AS t0_r15, "datacolumns"."acknowledge_unknown" AS t0_r16, "datacolumns"."term_id" AS t0_r17, "datasets"."id" AS t1_r0, "datasets"."title" AS t1_r1, "datasets"."abstr

[befdata]

Exception	PG::Error: ERROR: column "pg_search_rank" does not exist LINE 1: ... ''' ' || 'www.Bef' || ' ''' || ':*')))) ORDER BY pg_search_... ^ : SELECT "datacolumns"."id" AS t0_r0, "datacolumns"."datagroup_id" AS t0_r1, "datacolumns"."dataset_id" AS t0_r2, "datacolumns"."columnheader" AS t0_r3, "datacolumns"."columnnr" AS t0_r4, "datacolumns"."definition" AS t0_r5, "datacolumns"."unit" AS t0_r6, "datacolumns"."comment" AS t0_r7, "datacolumns"."import_data_type" AS t0_r8, "datacolumns"."created_at" AS t0_r9, "datacolumns"."updated_at" AS t0_r10, "datacolumns"."datagroup_approved" AS t0_r11, "datacolumns"."finished" AS t0_r12, "datacolumns"."datatype_approved" AS t0_r13, "datacolumns"."informationsource" AS t0_r14, "datacolumns"."instrumentation" AS t0_r15, "datacolumns"."acknowledge_unknown" AS t0_r16, "datacolumns"."term_id" AS t0_r17, "datasets"."id" AS t1_r0, "datasets"."title" AS t1_r1, "datasets"."abstract" AS t1_r2, "datasets"."usagerights" AS t1_r3, "datasets"."spatialextent" AS t1_r4, "datasets"."temporalextent" AS t1_r5, "datasets"."taxonomicextent" AS t1_r6, "datasets"."design" AS t1_r7, "datasets"."circumstances" AS t1_r8, "datasets"."submission_at" AS t1_r9, "datasets"."filename" AS t1_r10, "datasets"."comment" AS t1_r11, "datasets"."dataanalysis" AS t1_r12, "datasets"."dataset_downloads_count" AS t1_r13, "datasets"."datemin" AS t1_r14, "datasets"."datemax" AS t1_r15, "datasets"."published" AS t1_r16, "datasets"."visible_for_public" AS t1_r17, "datasets"."created_at" AS t1_r18, "datasets"."updated_at" AS t1_r19, "datasets"."import_status" AS t1_r20, "datasets"."access_code" AS t1_r21, "datasets"."include_license" AS t1_r22, "datasets"."datafiles_count" AS t1_r23, "datasets"."freeformats_count" AS t1_r24 FROM "datacolumns" LEFT OUTER JOIN "datasets" ON "datasets"."id" = "datacolumns"."dataset_id" LEFT OUTER JOIN (SELECT "datacolumns"."id" AS id, string_agg("tags"."name"::text, ' ') AS pg_search_93f916f001b6b057ee2922 FROM "datacolumns" INNER JOIN "taggings" ON "taggings"."taggable_id" = "datacolumns"."id" AND taggings.context = ('tags') AND "taggings"."taggable_type" = 'Datacolumn' INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" GROUP BY "datacolumns"."id") pg_search_b229fd995799cea4ca76c4 ON pg_search_b229fd995799cea4ca76c4.id = "datacolumns"."id" LEFT OUTER JOIN (SELECT "datacolumns"."id" AS id, string_agg("datagroups"."title"::text, ' ') AS pg_search_509fc595b941e26a6058f9, string_agg("datagroups"."description"::text, ' ') AS pg_search_cfa086e09d9d7330680f1a FROM "datacolumns" INNER JOIN "datagroups" ON "datagroups"."id" = "datacolumns"."datagroup_id" GROUP BY "datacolumns"."id") pg_search_0a34399696026690f3a536 ON pg_search_0a34399696026690f3a536.id = "datacolumns"."id" WHERE (((setweight(to_tsvector('english', coalesce("datacolumns"."columnheader"::text, '')), 'A') || setweight(to_tsvector('english', coalesce("datacolumns"."definition"::text, '')), 'B') || setweight(to_tsvector('english', coalesce(pg_search_b229fd995799cea4ca76c4.pg_search_93f916f001b6b057ee2922::text, '')), 'A') || setweight(to_tsvector('english', coalesce(pg_search_0a34399696026690f3a536.pg_search_509fc595b941e26a6058f9::text, '')), 'A') || setweight(to_tsvector('english', coalesce(pg_search_0a34399696026690f3a536.pg_search_cfa086e09d9d7330680f1a::text, '')), 'B')) @@ (to_tsquery('english', ''' ' || 'www.Bef' || ' ''' || ':*')))) ORDER BY pg_search_rank DESC, "datacolumns"."id" ASC
Last Occurrence	October 28, 2014 21:25:11 +0100
Count	2

Stack Trace

/var/lib/gems/1.9.1/gems/activerecord-3.2.19/lib/active_record/connection_adapters/postgresql_adapter.rb:1163:in `async_exec'
/var/lib/gems/1.9.1/gems/activerecord-3.2.19/lib/active_record/connection_adapters/postgresql_adapter.rb:1163:in `exec_no_cache'
/var/lib/gems/1.9.1/gems/activerecord-3.2.19/lib/active_record/connection_adapters/postgresql_adapter.rb:660:in `block in exec_query'
/var/lib/gems/1.9.1/gems/activerecord-3.2.19/lib/active_record/connection_adapters/abstract_adapter.rb:280:in `block in log'
/var/lib/gems/1.9.1/gems/activesupport-3.2.19/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
/var/lib/gems/1.9.1/gems/activerecord-3.2.19/lib/active_record/connection_adapters/abstract_adapter.rb:275:in `log'
/var/lib/gems/1.9.1/gems/activerecord-3.2.19/lib/active_record/connection_adapters/postgresql_adapter.rb:659:in `exec_query'
/var/lib/gems/1.9.1/gems/activerecord-3.2.19/lib/active_record/connection_adapters/postgresql_adapter.rb:1262:in `select'
/var/lib/gems/1.9.1/gems/activerecord-3.2.19/lib/active_record/connection_adapters/abstract/database_statements.rb:18:in `select_all'
/var/lib/gems/1.9.1/gems/activerecord-3.2.19/lib/active_record/connection_adapters/abstract/query_cache.rb:61:in `block in select_all'
/var/lib/gems/1.9.1/gems/activerecord-3.2.19/lib/active_record/connection_adapters/abstract/query_cache.rb:75:in `cache_sql'
/var/lib/gems/1.9.1/gems/activerecord-3.2.19/lib/active_record/connection_adapters/abstract/query_cache.rb:61:in `select_all'
/var/lib/gems/1.9.1/gems/activerecord-3.2.19/lib/active_record/relation/finder_methods.rb:212:in `find_with_associations'
/var/lib/gems/1.9.1/gems/activerecord-3.2.19/lib/active_record/relation.rb:171:in `exec_queries'
/var/lib/gems/1.9.1/gems/activerecord-3.2.19/lib/active_record/relation.rb:160:in `block in to_a'
/var/lib/gems/1.9.1/gems/activerecord-3.2.19/lib/active_record/explain.rb:41:in `logging_query_plan'
/var/lib/gems/1.9.1/gems/activerecord-3.2.19/lib/active_record/relation.rb:159:in `to_a'
/var/lib/gems/1.9.1/gems/activerecord-3.2.19/lib/active_record/relation/delegation.rb:40:in `method_missing'
/var/www/production/befdata/app/controllers/pages_controller.rb:67:in `search'
/var/lib/gems/1.9.1/gems/actionpack-3.2.19/lib/action_controller/metal/implicit_render.rb:4:in `send_action'
/var/lib/gems/1.9.1/gems/actionpack-3.2.19/lib/abstract_controller/base.rb:167:in `process_action'
/var/lib/gems/1.9.1/gems/actionpack-3.2.19/lib/action_controller/metal/rendering.rb:10:in `process_action'
/var/lib/gems/1.9.1/gems/actionpack-3.2.19/lib/abstract_controller/callbacks.rb:18:in `block in process_action'
/var/lib/gems/1.9.1/gems/activesupport-3.2.19/lib/active_support/callbacks.rb:436:in `_run__731468802__process_action__86088004__callbacks'
/var/lib/gems/1.9.1/gems/activesupport-3.2.19/lib/active_support/callbacks.rb:405:in `__run_callback'
/var/lib/gems/1.9.1/gems/activesupport-3.2.19/lib/active_support/callbacks.rb:385:in `_run_process_action_callbacks'
/var/lib/gems/1.9.1/gems/activesupport-3.2.19/lib/active_support/callbacks.rb:81:in `run_callbacks'
/var/lib/gems/1.9.1/gems/actionpack-3.2.19/lib/abstract_controller/callbacks.rb:17:in `process_action'
/var/lib/gems/1.9.1/gems/actionpack-3.2.19/lib/action_controller/metal/rescue.rb:29:in `process_action'
/var/lib/gems/1.9.1/gems/actionpack-3.2.19/lib/action_controller/metal/instrumentation.rb:30:in `block in process_action'
/var/lib/gems/1.9.1/gems/activesupport-3.2.19/lib/active_support/notifications.rb:123:in `block in instrument'
/var/lib/gems/1.9.1/gems/activesupport-3.2.19/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
/var/lib/gems/1.9.1/gems/activesupport-3.2.19/lib/active_support/notifications.rb:123:in `instrument'
/var/lib/gems/1.9.1/gems/actionpack-3.2.19/lib/action_controller/metal/instrumentation.rb:29:in `process_action'
/var/lib/gems/1.9.1/gems/actionpack-3.2.19/lib/action_controller/metal/params_wrapper.rb:207:in `process_action'
/var/lib/gems/1.9.1/gems/activerecord-3.2.19/lib/active_record/railties/controller_runtime.rb:18:in `process_action'
/var/lib/gems/1.9.1/gems/actionpack-3.2.19/lib/abstract_controller/base.rb:121:in `process'
/var/lib/gems/1.9.1/gems/actionpack-3.2.19/lib/abstract_controller/rendering.rb:45:in `process'
/var/lib/gems/1.9.1/gems/actionpack-3.2.19/lib/action_controller/metal.rb:203:in `dispatch'
/var/lib/gems/1.9.1/gems/actionpack-3.2.19/lib/action_controller/metal/rack_delegation.rb:14:in `dispatch'
/var/lib/gems/1.9.1/gems/actionpack-3.2.19/lib/action_controller/metal.rb:246:in `block in action'
/var/lib/gems/1.9.1/gems/actionpack-3.2.19/lib/action_dispatch/routing/route_set.rb:73:in `call'
/var/lib/gems/1.9.1/gems/actionpack-3.2.19/lib/action_dispatch/routing/route_set.rb:73:in `dispatch'
/var/lib/gems/1.9.1/gems/actionpack-3.2.19/lib/action_dispatch/routing/route_set.rb:36:in `call'
/var/lib/gems/1.9.1/gems/journey-1.0.4/lib/journey/router.rb:68:in `block in call'
/var/lib/gems/1.9.1/gems/journey-1.0.4/lib/journey/router.rb:56:in `each'
/var/lib/gems/1.9.1/gems/journey-1.0.4/lib/journey/router.rb:56:in `call'
/var/lib/gems/1.9.1/gems/actionpack-3.2.19/lib/action_dispatch/routing/route_set.rb:608:in `call'
/var/lib/gems/1.9.1/gems/party_foul-1.2.2/lib/party_foul/middleware.rb:8:in `call'
/var/lib/gems/1.9.1/gems/actionpack-3.2.19/lib/action_dispatch/middleware/best_standards_support.rb:17:in `call'
/var/lib/gems/1.9.1/gems/rack-1.4.5/lib/rack/etag.rb:23:in `call'
/var/lib/gems/1.9.1/gems/rack-1.4.5/lib/rack/conditionalget.rb:25:in `call'
/var/lib/gems/1.9.1/gems/actionpack-3.2.19/lib/action_dispatch/middleware/head.rb:14:in `call'
/var/lib/gems/1.9.1/gems/actionpack-3.2.19/lib/action_dispatch/middleware/params_parser.rb:21:in `call'
/var/lib/gems/1.9.1/gems/actionpack-3.2.19/lib/action_dispatch/middleware/flash.rb:242:in `call'
/var/lib/gems/1.9.1/gems/rack-1.4.5/lib/rack/session/abstract/id.rb:210:in `context'
/var/lib/gems/1.9.1/gems/rack-1.4.5/lib/rack/session/abstract/id.rb:205:in `call'
/var/lib/gems/1.9.1/gems/actionpack-3.2.19/lib/action_dispatch/middleware/cookies.rb:341:in `call'
/var/lib/gems/1.9.1/gems/activerecord-3.2.19/lib/active_record/query_cache.rb:64:in `call'
/var/lib/gems/1.9.1/gems/activerecord-3.2.19/lib/active_record/connection_adapters/abstract/connection_pool.rb:479:in `call'
/var/lib/gems/1.9.1/gems/actionpack-3.2.19/lib/action_dispatch/middleware/callbacks.rb:28:in `block in call'
/var/lib/gems/1.9.1/gems/activesupport-3.2.19/lib/active_support/callbacks.rb:405:in `_run__997178836__call__605004260__callbacks'
/var/lib/gems/1.9.1/gems/activesupport-3.2.19/lib/active_support/callbacks.rb:405:in `__run_callback'
/var/lib/gems/1.9.1/gems/activesupport-3.2.19/lib/active_support/callbacks.rb:385:in `_run_call_callbacks'
/var/lib/gems/1.9.1/gems/activesupport-3.2.19/lib/active_support/callbacks.rb:81:in `run_callbacks'
/var/lib/gems/1.9.1/gems/actionpack-3.2.19/lib/action_dispatch/middleware/callbacks.rb:27:in `call'
/var/lib/gems/1.9.1/gems/actionpack-3.2.19/lib/action_dispatch/middleware/remote_ip.rb:31:in `call'
/var/lib/gems/1.9.1/gems/actionpack-3.2.19/lib/action_dispatch/middleware/debug_exceptions.rb:16:in `call'
/var/lib/gems/1.9.1/gems/actionpack-3.2.19/lib/action_dispatch/middleware/show_exceptions.rb:56:in `call'
/var/lib/gems/1.9.1/gems/railties-3.2.19/lib/rails/rack/logger.rb:32:in `call_app'
/var/lib/gems/1.9.1/gems/railties-3.2.19/lib/rails/rack/logger.rb:16:in `block in call'
/var/lib/gems/1.9.1/gems/activesupport-3.2.19/lib/active_support/tagged_logging.rb:22:in `tagged'
/var/lib/gems/1.9.1/gems/railties-3.2.19/lib/rails/rack/logger.rb:16:in `call'
/var/lib/gems/1.9.1/gems/actionpack-3.2.19/lib/action_dispatch/middleware/request_id.rb:22:in `call'
/var/lib/gems/1.9.1/gems/rack-1.4.5/lib/rack/methodoverride.rb:21:in `call'
/var/lib/gems/1.9.1/gems/rack-1.4.5/lib/rack/runtime.rb:17:in `call'
/var/lib/gems/1.9.1/gems/activesupport-3.2.19/lib/active_support/cache/strategy/local_cache.rb:72:in `call'
/var/lib/gems/1.9.1/gems/rack-1.4.5/lib/rack/lock.rb:15:in `call'
/var/lib/gems/1.9.1/gems/rack-cache-1.2/lib/rack/cache/context.rb:136:in `forward'
/var/lib/gems/1.9.1/gems/rack-cache-1.2/lib/rack/cache/context.rb:245:in `fetch'
/var/lib/gems/1.9.1/gems/rack-cache-1.2/lib/rack/cache/context.rb:185:in `lookup'
/var/lib/gems/1.9.1/gems/rack-cache-1.2/lib/rack/cache/context.rb:66:in `call!'
/var/lib/gems/1.9.1/gems/rack-cache-1.2/lib/rack/cache/context.rb:51:in `call'
/var/lib/gems/1.9.1/gems/railties-3.2.19/lib/rails/engine.rb:484:in `call'
/var/lib/gems/1.9.1/gems/railties-3.2.19/lib/rails/application.rb:231:in `call'
/var/lib/gems/1.9.1/gems/railties-3.2.19/lib/rails/railtie/configurable.rb:30:in `method_missing'
/var/lib/gems/1.9.1/gems/passenger-3.0.18/lib/phusion_passenger/rack/request_handler.rb:96:in `process_request'
/var/lib/gems/1.9.1/gems/passenger-3.0.18/lib/phusion_passenger/abstract_request_handler.rb:516:in `accept_and_process_next_request'
/var/lib/gems/1.9.1/gems/passenger-3.0.18/lib/phusion_passenger/abstract_request_handler.rb:274:in `main_loop'
/var/lib/gems/1.9.1/gems/passenger-3.0.18/lib/phusion_passenger/classic_rails/application_spawner.rb:321:in `start_request_handler'
/var/lib/gems/1.9.1/gems/passenger-3.0.18/lib/phusion_passenger/classic_rails/application_spawner.rb:275:in `block in handle_spawn_application'
/var/lib/gems/1.9.1/gems/passenger-3.0.18/lib/phusion_passenger/utils.rb:470:in `safe_fork'
/var/lib/gems/1.9.1/gems/passenger-3.0.18/lib/phusion_passenger/classic_rails/application_spawner.rb:270:in `handle_spawn_application'
/var/lib/gems/1.9.1/gems/passenger-3.0.18/lib/phusion_passenger/abstract_server.rb:357:in `server_main_loop'
/var/lib/gems/1.9.1/gems/passenger-3.0.18/lib/phusion_passenger/abstract_server.rb:206:in `start_synchronously'
/var/lib/gems/1.9.1/gems/passenger-3.0.18/lib/phusion_passenger/abstract_server.rb:180:in `start'
/var/lib/gems/1.9.1/gems/passenger-3.0.18/lib/phusion_passenger/classic_rails/application_spawner.rb:149:in `start'
/var/lib/gems/1.9.1/gems/passenger-3.0.18/lib/phusion_passenger/spawn_manager.rb:219:in `block (2 levels) in spawn_rails_application'
/var/lib/gems/1.9.1/gems/passenger-3.0.18/lib/phusion_passenger/abstract_server_collection.rb:132:in `lookup_or_add'
/var/lib/gems/1.9.1/gems/passenger-3.0.18/lib/phusion_passenger/spawn_manager.rb:214:in `block in spawn_rails_application'
/var/lib/gems/1.9.1/gems/passenger-3.0.18/lib/phusion_passenger/abstract_server_collection.rb:82:in `block in synchronize'
:10:in `synchronize'
/var/lib/gems/1.9.1/gems/passenger-3.0.18/lib/phusion_passenger/abstract_server_collection.rb:79:in `synchronize'
/var/lib/gems/1.9.1/gems/passenger-3.0.18/lib/phusion_passenger/spawn_manager.rb:213:in `spawn_rails_application'
/var/lib/gems/1.9.1/gems/passenger-3.0.18/lib/phusion_passenger/spawn_manager.rb:132:in `spawn_application'
/var/lib/gems/1.9.1/gems/passenger-3.0.18/lib/phusion_passenger/spawn_manager.rb:275:in `handle_spawn_application'
/var/lib/gems/1.9.1/gems/passenger-3.0.18/lib/phusion_passenger/abstract_server.rb:357:in `server_main_loop'
/var/lib/gems/1.9.1/gems/passenger-3.0.18/lib/phusion_passenger/abstract_server.rb:206:in `start_synchronously'
/var/lib/gems/1.9.1/gems/passenger-3.0.18/helper-scripts/passenger-spawn-server:99:in `'

Fingerprint: cc9e09763a026a760718ccbefd60d5ee5b8e07a7

[befdata]

Occurred At	October 28, 2014 21:24:49 +0100
URL	[GET] /search?utf8=%E2%9C%93&q=www.Bef
Params	action search controller pages
Session	session_id 4ee24352ff91a92f13b52ea23926e7e9 _csrf_token Gf9cvD3w5CCz4T2sifnqqwgK6zV8Aod8rpET5asNw3o=
IP Address	1.39.25.240
HTTP Headers	Version User Agent Mozilla/5.0 (Linux; Android 4.4.2; Iris 404 Flair Build/KOT49H) AppleWebKit/537.36 (KHTML, likeGecko) Version/4.0 Chrome/30.0.0.0 Mobile Safari/537.36 Accept Encoding gzip,deflate Accept text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8

[befdata]

Occurred At	October 28, 2014 21:25:11 +0100
URL	[GET] /search?utf8=%E2%9C%93&q=www.Bef
Params	action search controller pages
Session	session_id 4ee24352ff91a92f13b52ea23926e7e9 _csrf_token Gf9cvD3w5CCz4T2sifnqqwgK6zV8Aod8rpET5asNw3o=
IP Address	1.39.25.240
HTTP Headers	Version User Agent Mozilla/5.0 (Linux; Android 4.4.2; Iris 404 Flair Build/KOT49H) AppleWebKit/537.36 (KHTML, likeGecko) Version/4.0 Chrome/30.0.0.0 Mobile Safari/537.36 Accept Encoding gzip,deflate Accept text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8

[manxingxing]

This error occures when the search string contains a dot. corresponding line is

Datacolumn.includes(:dataset).search(params[:q])

remove includes would eliminate this error, but performance gets worse. will rewrite the code while implementing elasticsearch