gistfile1.txt

PGError: ERROR: invalid input syntax for integer: "--- !ruby/object:Commands::IdReference offset: 3 sequence: !ruby/object:Commands::IdSequence next_offset: 4 released_ids: [] table_name: user_identities " LINE 1: ...rships" WHERE ("memberships"."user_identity_id" = E'--- !rub... ^ : SELECT * FROM "memberships" WHERE ("memberships"."user_identity_id" = E'--- !ruby/object:Commands::IdReference offset: 3 sequence: !ruby/object:Commands::IdSequence next_offset: 4 released_ids: [] table_name: user_identities ' AND "memberships"."membershipable_id" = 27174) AND ( ("memberships"."type" = 'Ccce' ) ) /Users/rjones/.rvm/gems/ruby-1.9.2-p290@cpi2/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract_adapter.rb:219:in `rescue in log' /Users/rjones/.rvm/gems/ruby-1.9.2-p290@cpi2/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract_adapter.rb:202:in `log' /Users/rjones/.rvm/gems/ruby-1.9.2-p290@cpi2/gems/activerecord-2.3.5/lib/active_record/connection_adapters/postgresql_adapter.rb:550:in `execute' /Users/rjones/.rvm/gems/ruby-1.9.2-p290@cpi2/gems/activerecord-2.3.5/lib/active_record/connection_adapters/postgresql_adapter.rb:1037:in `select_raw' /Users/rjones/.rvm/gems/ruby-1.9.2-p290@cpi2/gems/activerecord-2.3.5/lib/active_record/connection_adapters/postgresql_adapter.rb:1024:in `select' /Users/rjones/cpi2/vendor/plugins/query-analyzer/lib/query_analyzer.rb:64:in `select' /Users/rjones/.rvm/gems/ruby-1.9.2-p290@cpi2/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/database_statements.rb:7:in `select_all' /Users/rjones/.rvm/gems/ruby-1.9.2-p290@cpi2/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/query_cache.rb:62:in `select_all_with_query_cache' /Users/rjones/.rvm/gems/ruby-1.9.2-p290@cpi2/gems/activerecord-2.3.5/lib/active_record/base.rb:661:in `find_by_sql' /Users/rjones/.rvm/gems/ruby-1.9.2-p290@cpi2/gems/activerecord-2.3.5/lib/active_record/base.rb:1548:in `find_every' /Users/rjones/.rvm/gems/ruby-1.9.2-p290@cpi2/gems/activerecord-2.3.5/lib/active_record/base.rb:615:in `find' /Users/rjones/.rvm/gems/ruby-1.9.2-p290@cpi2/gems/activerecord-2.3.5/lib/active_record/base.rb:635:in `all' /Users/rjones/cpi2/app/models/csv_imports/csv_clinical_staff.rb:145:in `block in ' /Users/rjones/cpi2/app/models/import/importable.rb:381:in `call' /Users/rjones/cpi2/app/models/import/importable.rb:381:in `importable_process_field' /Users/rjones/cpi2/app/models/import/importable.rb:361:in `importable_import_field' /Users/rjones/cpi2/app/models/import/importable.rb:211:in `block in update_from_import' /Users/rjones/cpi2/app/models/import/importable.rb:207:in `each' /Users/rjones/cpi2/app/models/import/importable.rb:207:in `update_from_import' /Users/rjones/cpi2/app/models/import/importable.rb:177:in `new_from_import' /Users/rjones/cpi2/app/models/import/import_runner.rb:98:in `block in create_new' /Users/rjones/cpi2/app/models/import/import_runner.rb:87:in `each' /Users/rjones/cpi2/app/models/import/import_runner.rb:87:in `create_new' /Users/rjones/cpi2/app/models/import/import_runner.rb:119:in `process' /Users/rjones/cpi2/app/models/import.rb:245:in `execute_runner' /Users/rjones/cpi2/app/models/import.rb:223:in `process_rows' /Users/rjones/cpi2/vendor/plugins/delayed_job/lib/delayed/performable_method.rb:35:in `perform' /Users/rjones/cpi2/vendor/plugins/delayed_job/lib/delayed/backend/base.rb:53:in `invoke_job' /Users/rjones/cpi2/vendor/plugins/delayed_job/lib/delayed/worker.rb:108:in `block (2 levels) in run' /Users/rjones/.rvm/rubies/ruby-1.9.2-p290/lib/ruby/1.9.1/timeout.rb:58:in `timeout' /Users/rjones/cpi2/vendor/plugins/delayed_job/lib/delayed/worker.rb:108:in `block in run' /Users/rjones/.rvm/rubies/ruby-1.9.2-p290/lib/ruby/1.9.1/benchmark.rb:310:in `realtime' /Users/rjones/cpi2/vendor/plugins/delayed_job/lib/delayed/worker.rb:107:in `run' /Users/rjones/cpi2/vendor/plugins/delayed_job/lib/delayed/worker.rb:162:in `reserve_and_run_one_job' /Users/rjones/cpi2/vendor/plugins/delayed_job/lib/delayed/worker.rb:92:in `block in work_off' /Users/rjones/cpi2/vendor/plugins/delayed_job/lib/delayed/worker.rb:91:in `times' /Users/rjones/cpi2/vendor/plugins/delayed_job/lib/delayed/worker.rb:91:in `work_off' /Users/rjones/cpi2/vendor/plugins/delayed_job/lib/delayed/worker.rb:66:in `block (2 levels) in start' /Users/rjones/.rvm/rubies/ruby-1.9.2-p290/lib/ruby/1.9.1/benchmark.rb:310:in `realtime' /Users/rjones/cpi2/vendor/plugins/delayed_job/lib/delayed/worker.rb:65:in `block in start' /Users/rjones/cpi2/vendor/plugins/delayed_job/lib/delayed/worker.rb:62:in `loop' /Users/rjones/cpi2/vendor/plugins/delayed_job/lib/delayed/worker.rb:62:in `start' /Users/rjones/cpi2/vendor/plugins/delayed_job/lib/delayed/command.rb:68:in `run' /Users/rjones/cpi2/vendor/plugins/delayed_job/lib/delayed/command.rb:46:in `block (2 levels) in daemonize' /Users/rjones/.rvm/gems/ruby-1.9.2-p290@cpi2/gems/daemons-1.1.5/lib/daemons/application.rb:249:in `call' /Users/rjones/.rvm/gems/ruby-1.9.2-p290@cpi2/gems/daemons-1.1.5/lib/daemons/application.rb:249:in `block in start_proc' /Users/rjones/.rvm/gems/ruby-1.9.2-p290@cpi2/gems/daemons-1.1.5/lib/daemons/daemonize.rb:200:in `call' /Users/rjones/.rvm/gems/ruby-1.9.2-p290@cpi2/gems/daemons-1.1.5/lib/daemons/daemonize.rb:200:in `call_as_daemon' /Users/rjones/.rvm/gems/ruby-1.9.2-p290@cpi2/gems/daemons-1.1.5/lib/daemons/application.rb:253:in `start_proc' /Users/rjones/.rvm/gems/ruby-1.9.2-p290@cpi2/gems/daemons-1.1.5/lib/daemons/application.rb:293:in `start' /Users/rjones/.rvm/gems/ruby-1.9.2-p290@cpi2/gems/daemons-1.1.5/lib/daemons/controller.rb:70:in `run' /Users/rjones/.rvm/gems/ruby-1.9.2-p290@cpi2/gems/daemons-1.1.5/lib/daemons.rb:195:in `block in run_proc' /Users/rjones/.rvm/gems/ruby-1.9.2-p290@cpi2/gems/daemons-1.1.5/lib/daemons/cmdline.rb:109:in `call' /Users/rjones/.rvm/gems/ruby-1.9.2-p290@cpi2/gems/daemons-1.1.5/lib/daemons/cmdline.rb:109:in `catch_exceptions' /Users/rjones/.rvm/gems/ruby-1.9.2-p290@cpi2/gems/daemons-1.1.5/lib/daemons.rb:194:in `run_proc' /Users/rjones/cpi2/vendor/plugins/delayed_job/lib/delayed/command.rb:45:in `block in daemonize' /Users/rjones/cpi2/vendor/plugins/delayed_job/lib/delayed/command.rb:43:in `times' /Users/rjones/cpi2/vendor/plugins/delayed_job/lib/delayed/command.rb:43:in `daemonize' ./script/delayed_job:5:in `'