Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save jcreed/6a4d23d1c62644489b25 to your computer and use it in GitHub Desktop.
Save jcreed/6a4d23d1c62644489b25 to your computer and use it in GitHub Desktop.
Deleter Loader error on gpa_by_academic_years
==> loader/log/development.log <==
I, [2015-10-09T08:51:18.644949 #2520] INFO -- : Establishing connection to redis, queues = ["cas3_etl_loader_dev", "self_pipe_2520"]
==> loader/log/development.sql.log <==
E, [2015-10-09T08:51:18.648075 #2520] ERROR -- : PG::Error: ERROR: operator does not exist: integer = record
LINE 1: ... id FROM gpa_by_academic_years WHERE applicant_id = ('id-pro...
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.: SELECT id FROM gpa_by_academic_years WHERE applicant_id = ('id-proxy', 'b8668aa0-bccc-419b-a39e-6f8eb85cab32')
I, [2015-10-09T08:51:18.648396 #2520] INFO -- : (0.000069s) ROLLBACK
==> loader/log/development.error.log <==
E, [2015-10-09T08:51:18.648588 #2520] ERROR -- : Error processing applicant 3233357924:
PG::Error: ERROR: operator does not exist: integer = record
LINE 1: ... id FROM gpa_by_academic_years WHERE applicant_id = ('id-pro...
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/sequel-4.0.0/lib/sequel/adapters/postgres.rb:161:in `async_exec'
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/sequel-4.0.0/lib/sequel/adapters/postgres.rb:161:in `block in execute_query'
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/sequel-4.0.0/lib/sequel/database/logging.rb:37:in `log_yield'
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/sequel-4.0.0/lib/sequel/adapters/postgres.rb:161:in `execute_query'
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/sequel-4.0.0/lib/sequel/adapters/postgres.rb:148:in `block in execute'
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/sequel-4.0.0/lib/sequel/adapters/postgres.rb:124:in `check_disconnect_errors'
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/sequel-4.0.0/lib/sequel/adapters/postgres.rb:148:in `execute'
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/sequel-4.0.0/lib/sequel/adapters/postgres.rb:458:in `_execute'
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/sequel-4.0.0/lib/sequel/adapters/postgres.rb:282:in `block (2 levels) in execute'
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/sequel-4.0.0/lib/sequel/adapters/postgres.rb:479:in `check_database_errors'
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/sequel-4.0.0/lib/sequel/adapters/postgres.rb:282:in `block in execute'
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/sequel-4.0.0/lib/sequel/database/connecting.rb:229:in `block in synchronize'
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/sequel-4.0.0/lib/sequel/connection_pool/threaded.rb:91:in `hold'
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/sequel-4.0.0/lib/sequel/database/connecting.rb:229:in `synchronize'
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/sequel-4.0.0/lib/sequel/adapters/postgres.rb:282:in `execute'
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/sequel-4.0.0/lib/sequel/dataset/actions.rb:794:in `execute'
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/sequel-4.0.0/lib/sequel/adapters/postgres.rb:601:in `fetch_rows'
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/sequel-4.0.0/lib/sequel/dataset/actions.rb:144:in `each'
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/sequel-4.0.0/lib/sequel/dataset/actions.rb:389:in `map'
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/sequel-4.0.0/lib/sequel/dataset/actions.rb:389:in `map'
/Users/jreed/Liaison/WebAdMIT-meta/loader/lib/loader/database/table.rb:11:in `ids_for_applicant'
/Users/jreed/Liaison/WebAdMIT-meta/loader/lib/loader/database/loaders/batch_implicit_delete_loader.rb:164:in `ids_from_database'
/Users/jreed/Liaison/WebAdMIT-meta/loader/lib/loader/database/loaders/batch_implicit_delete_loader.rb:126:in `ask_webadmit_to_delete'
/Users/jreed/Liaison/WebAdMIT-meta/loader/lib/loader/database/loaders/batch_implicit_delete_loader.rb:119:in `block in load!'
/Users/jreed/Liaison/WebAdMIT-meta/loader/lib/loader/database/loaders/batch_implicit_delete_loader.rb:117:in `each'
/Users/jreed/Liaison/WebAdMIT-meta/loader/lib/loader/database/loaders/batch_implicit_delete_loader.rb:117:in `load!'
/Users/jreed/Liaison/WebAdMIT-meta/loader/lib/loader/database/load_strategies/batch_load_strategy.rb:55:in `implicit_deletes'
/Users/jreed/Liaison/WebAdMIT-meta/loader/lib/loader/database/load_strategies/batch_load_strategy.rb:31:in `load'
/Users/jreed/Liaison/WebAdMIT-meta/loader/lib/loader/worker.rb:55:in `block (2 levels) in load'
/Users/jreed/Liaison/WebAdMIT-meta/loader/lib/loader/database/stager.rb:47:in `block in each'
/Users/jreed/Liaison/WebAdMIT-meta/loader/lib/loader/database/stager.rb:43:in `each'
/Users/jreed/Liaison/WebAdMIT-meta/loader/lib/loader/database/stager.rb:43:in `each'
/Users/jreed/Liaison/WebAdMIT-meta/loader/lib/loader/worker.rb:54:in `block in load'
/Users/jreed/Liaison/WebAdMIT-meta/loader/lib/loader/database/load_strategies/batch_with_reporters_load_strategy.rb:23:in `block in around_records'
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/sequel-4.0.0/lib/sequel/database/transactions.rb:118:in `_transaction'
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/sequel-4.0.0/lib/sequel/database/transactions.rb:93:in `block in transaction'
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/sequel-4.0.0/lib/sequel/database/connecting.rb:229:in `block in synchronize'
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/sequel-4.0.0/lib/sequel/connection_pool/threaded.rb:104:in `hold'
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/sequel-4.0.0/lib/sequel/database/connecting.rb:229:in `synchronize'
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/sequel-4.0.0/lib/sequel/database/transactions.rb:86:in `transaction'
/Users/jreed/Liaison/WebAdMIT-meta/loader/lib/loader/database/load_strategies/batch_with_reporters_load_strategy.rb:22:in `around_records'
/Users/jreed/Liaison/WebAdMIT-meta/loader/lib/loader/worker.rb:53:in `load'
/Users/jreed/Liaison/WebAdMIT-meta/loader/lib/loader/application.rb:76:in `block (2 levels) in the_usual'
/Users/jreed/.rvm/rubies/ruby-1.9.3-p551/lib/ruby/1.9.1/benchmark.rb:280:in `measure'
/Users/jreed/Liaison/WebAdMIT-meta/loader/lib/loader/application.rb:76:in `block in the_usual'
/Users/jreed/Liaison/WebAdMIT-meta/loader/lib/loader/transformer_listener.rb:41:in `next_record'
/Users/jreed/Liaison/WebAdMIT-meta/loader/lib/loader/application.rb:73:in `the_usual'
/Users/jreed/Liaison/WebAdMIT-meta/loader/lib/loader/application.rb:63:in `block in run'
/Users/jreed/Liaison/WebAdMIT-meta/loader/lib/loader/application.rb:48:in `loop'
/Users/jreed/Liaison/WebAdMIT-meta/loader/lib/loader/application.rb:48:in `run'
/Users/jreed/Liaison/WebAdMIT-meta/loader/lib/loader.rb:27:in `run'
/Users/jreed/Liaison/WebAdMIT-meta/loader/lib/loader/server/server.rb:15:in `<top (required)>'
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/daemons-1.1.9/lib/daemons/application.rb:203:in `load'
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/daemons-1.1.9/lib/daemons/application.rb:203:in `start_load'
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/daemons-1.1.9/lib/daemons/application.rb:298:in `start'
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/daemons-1.1.9/lib/daemons/controller.rb:70:in `run'
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/daemons-1.1.9/lib/daemons.rb:147:in `block in run'
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/daemons-1.1.9/lib/daemons/cmdline.rb:109:in `call'
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/daemons-1.1.9/lib/daemons/cmdline.rb:109:in `catch_exceptions'
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/daemons-1.1.9/lib/daemons.rb:146:in `run'
bin/loader:5:in `<main>'
==> loader/log/development.log <==
I, [2015-10-09T08:51:19.020145 #2520] INFO -- : Finished processing applicant: 3233357924
I, [2015-10-09T08:51:19.020351 #2520] INFO -- : Done writing record, 0.8021490573883057 seconds
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment